[Dbix-class] PostgreSQL & schema

[Diab Jerius]

On Thu, 2013-02-28 at 18:41 +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.
> 
> 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.

Will do.  Thanks for the pointer.