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