On Wed, Mar 29, 2006 at 01:33:39PM +0200, Ivan Horvath wrote: > i think there is a problem with this sql which intend to find the > primary key. > as you can see on the below sql command, if the table is in > another schema, then we have to query the pg_namespace table as > well > so the relname contains just the class name, while the > pg_namespace.nspname contains the schema name and the two table > can be related by the c.relnamespace = pg_namespace.oid fields > > i think this is a bug in sqlobject, which is only occurs when we > would like to work tables from other schema then public.
May be. Nobody patched SQLObject to consistently support schemas. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss