| Subject: | dbicdump error reading postgreSQL database |
I had a problem with dbicdump, and I think I've tracked it to a version
problem.
I did some testing with a colleague, who had demonstrated the
advantage of Catalyst to me.
- He's running Perl 5.12, I'm on 5.14
- We are running the same version of catalyst
- He's running DBIx::Class::Schema::Loader 0.07017, I went from 0.07020
to 0.07023
I have rolled back to ::::Loader 0.07017, and I'm no longer getting
errors.
my dbicdump command is:
dbicdump -o dump_directory=/home/ori/lib/perl -o debug=1 EDINA::ORI
'dbi:Pg:dbname=oarj3;host=devel.edina.ac.uk;port=6000' 'ori'
'CramPL1nk23'
(this should work for you too - its read-only access to a development
version of the database)
With 0.07020 I had two other errors:
1) I had Classes being built that were incomplete (some tables, it was
dropping 8 columns, others it pulled in all 12 columns)
2) I had at least one column being renamed: 'tbl' became 'table', for
example
With 0.07023 I was just getting loads of errors and nothing built:
lots of "Use of uninitialized value $col in hash element at
/usr/local/share/perl/5.14.2/DBIx/Class/Schema/Loader/Base.pm line
2349."
"Use of uninitialized value in hash element at
/usr/local/share/perl/5.14.2/DBIx/Class/Schema/Loader/RelBuilder.pm
line 398."
"Use of uninitialized value $column in exists at
/usr/share/perl5/DBIx/Class/ResultSource.pm line 380."
"Use of uninitialized value $column in concatenation (.) or string at
/usr/share/perl5/DBIx/Class/ResultSource.pm line 380."
"DBIx::Class::Schema::Loader::make_schema_at(): No such column at
/usr/local/bin/dbicdump line 178"
Anyway... rolling back to 0.07017 seems to have solved my problem....
so I suspect there's a bug in the later code.
(I'll try to keep access to the database open for you..... to work
against)