Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: dbicdump not importing the full table (Postgres)

by Anonymous Monk
on May 08, 2012 at 11:49 UTC ( #969428=note: print w/ replies, xml ) Need Help??


in reply to dbicdump not importing the full table (Postgres)

Environment - Perl: Ububtu 12.04; Perl 5.14.2; all packages installed via .debs. Database: postgres database on a Sun server. ... I am using dbicdump to create a pile of DBIx::Class ...

Upgrade to latest dbicdump version ?

perl -MDevel::Modlist -S dbicdump ...

Or dump schema using pg_dump -n schema ...   so that others (me) can try sqlt on the output :)

Or try http://search.cpan.org/perldoc/Catalyst::Helper::Model::DBIC::Schema#TYPICAL_EXAMPLES to see if you get something different


Comment on Re: dbicdump not importing the full table (Postgres)
Re^2: dbicdump not importing the full table (Postgres)
by Anonymous Monk on May 08, 2012 at 12:18 UTC

    the sqlt test suite is good :)

    Create table schema manually from description

    and sqlt doesn't appear to miss anything either

    output from sqlt -f PostgreSQL -t DBIx::Class::File --prefix=EDINA::ORI < in > out

    Is this a bug in dbicdump ? I can't tell :)

Re^2: dbicdump not importing the full table (Postgres)
by kiz (Monk) on May 08, 2012 at 15:57 UTC

    dbicdump: Hmmm - Ubuntu has packaged 0.07010, and CPAN has 0.07023... I'll have a look at the changes file!

    pg_dump: I've removed a pile of PostGIS stuff from this (I think I got it all....)

Re^2: dbicdump not importing the full table (Postgres)
by kiz (Monk) on May 09, 2012 at 12:05 UTC

    Hmmmm... the plot thickens!

    W did some testing with a colleague, who had got good results when he 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.

    I would class this as a bug, and will report it back.

    Thankee for your time, and attention.



    -- Ian Stuart
    A man depriving some poor village, somewhere, of a first-class idiot.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://969428]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (10)
As of 2014-07-14 09:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (257 votes), past polls