Problem with schema

Joseph Rawson <[email protected]> Sun, 3 Oct 2004 17:43:31 -0500
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
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


-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl