[Dbix-class] PostgreSQL & schema

[Peter Rabbitson]

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