[Pypgsql-users] Problem with schema

[Joseph R. <ume...@gr...>]

It seems that the cursors are not respecting the search_path when I'm trying 
to use the new schema functionality in postgresql. I have made tables 
specifically in another schema (foo) and left public empty, only to find that 
when I connect with a new cursor (in $user,public) i can't create another 
table of the same name in public when I pass just a tablename.

I have been using pyPgSQL for a long time now, and I have a lot of code that 
depends on it.  I've been getting a lot of use out of the PgResultSet, and it 
will take a lot of work to change things around.

I can send you an example, but this is pretty simple to do in psql, and then 
test with the python cursor.
If I can be of any assistance please let me know.

Thanks
-- 
Joseph Rawson