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.
You did it correctly. While DBIC does support schema specified that way for DML work, SQL::Translator (which is a separate project DBIC is using to do DDL) seems to get confused. However the culprit ultimately is still DBIC, because it names the constraints in a way that SQLT simply passes on. Please try to tweak https://github.com/dbsrgits/dbix-class/blob/master/lib/DBIx/Class/ResultSource.pm#L805 by doing something along the lines of $name =~ s/ ^ [\w\-]+ \. //x If this works for you *please* get back to us and let us know so DBIC can be fixed in that regard. Cheers _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
