Re: [Maypole] problem with maypole and postgresql, different schema than public

From: Perrin Harkins (perrin at elem.com)
Date: Tue Sep 21 2004 - 23:36:55 BST


On Tue, 2004-09-21 at 10:16, Jochen Schroer wrote:
> I have a problem with maypole and postgresql, because I don't know how
> I can access tables in different schema than public.

When I need to do this in a Class::DBI app, I just put this in my
Class::DBI base class:

__PACKAGE__->db_Main->do('SET search_path TO myschema, public');

I think you can configure that permanently for specific users somehow as
well.

You can typically just pass a table name with a . in it as well. So, it
looks like the problem here is caused by Class::DBI::Loader or the way
Maypole interacts with it.

- Perrin

_______________________________________________
maypole mailing list
maypole at lists.netthink.co.uk
http://lists.netthink.co.uk/listinfo/maypole



This archive was generated by hypermail 2.1.3 : Thu Feb 24 2005 - 22:25:56 GMT