On 7/28/05, Diego Zuccato <[EMAIL PROTECTED]> wrote: > Hello all. > > It seems that Mergeant can't retrieve tables in PG's schemas. > If you do something like: > > CREATE SCHEMA x; > CREATE SCHEMA y; > CREATE TABLE x.a (...); > CREATE TABLE y.a (...); > CREATE TABLE b (...); > > the only table Mergeant can "see" is b. > > Is it a known limitation (couldn't find it documented anywhere) or > something that sneaked in unnoticed? > > Please cc me since I'm not subscribed to this list. >
You have to define the search_path you want to use in the connection's DSN string, and if you don't then the 'public' schema is assumed (this is why table b is visible). Regards, Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
