[Dbix-class] PostgreSQL & schema

[Diab Jerius]

On Thu, 2013-02-28 at 02:13 +1100, Peter Rabbitson wrote:
> On Wed, Feb 27, 2013 at 10:04:34AM -0500, Diab Jerius wrote:
> > I'm trying to organize database objects using schema.  My primary server
> > backend is Postgres.  The DBIC Pg storage docs indicate that it supports
> > schema, but there's not much information anywhere that I can find in the
> > DBIC documentation as to how one specifies schema.
> > 
> > ...
> >         
> > The quoting looks a bit weird.  In any case, upon deployment (via
> > $schema->deploy) the tables are created, but Postgres balks at the extra
> > '.' in the constraint names:
> > 
> >         NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pbk_hdrs_pkey" for table "pbk_hdrs"
> >         DBIx::Class::Schema::deploy(): DBIx::Class::Schema::deploy(): DBI Exception: DBD::Pg::db do failed: ERROR:  syntax error at or near "."
> >         LINE 4:   CONSTRAINT "acis"."pbk_ccds_filename_ccd_id" UNIQUE ("file...
> >                                    ^ at lib/CXC/MSTDB/Deploy/ACIS/PBK/Deploy.pm line 51
> >          (running "CREATE TABLE "acis"."pbk_ccds" (
> >           "filename" text NOT NULL,
> >           "ccd_id" integer NOT NULL,
> >           CONSTRAINT "acis"."pbk_ccds_filename_ccd_id" UNIQUE ("filename", "ccd_id")
> >         );
> >         CREATE INDEX "acis"."pbk_ccds_idx_filename" on "acis"."pbk_ccds" ("filename");
> >         
> >         ") at lib/CXC/MSTDB/Deploy/ACIS/PBK/Deploy.pm line 51
> >         DBIx::Class::Schema::deploy(): DBIx::Class::Schema::deploy(): DBI Exception: DBD::Pg::db do failed: ERROR:  syntax error at or near "."
> >         LINE 1: ...LTER TABLE "acis"."pbk_ccds" ADD CONSTRAINT "acis"."pbk_ccds...
> >                                                                      ^ at lib/CXC/MSTDB/Deploy/ACIS/PBK/Deploy.pm line 51
> >          (running "ALTER TABLE "acis"."pbk_ccds" ADD CONSTRAINT "acis"."pbk_ccds_fk_filename" FOREIGN KEY ("filename")
> >           REFERENCES "acis"."pbk_hdrs" ("filename") ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE;
> >         
> >         ") at lib/CXC/MSTDB/Deploy/ACIS/PBK/Deploy.pm line 51
> > 
> > Am I going about this the wrong way?
> > 
> 
> What are the versions of DBIx::Class and SQL::Translator you are using?
> 
> perl -MDBIx::Class\ 999
> perl -MSQL::Translator\ 999
> 
> Cheers
> 

% perl -MDBIx::Class\ 999
DBIx::Class version 999 required--this is only version 0.08208.
BEGIN failed--compilation aborted.

% perl -MSQL::Translator\ 999
SQL::Translator version 999 required--this is only version 0.11016.
BEGIN failed--compilation aborted.