[sqlalchemy] Re: postgresql: need schema-qualified foreign keys

2007-07-10 Thread Michael Bayer
On Jul 10, 1:10 am, klaus [EMAIL PROTECTED] wrote: I'm not sure whether I understody your posting correctly. Now I've checked out revision 2867 and nothing has changed, that is, I still get the same exceptions. if you can create a test for me in the style of those in test/dialects/

[sqlalchemy] Re: postgresql: need schema-qualified foreign keys

2007-07-09 Thread klaus
Oops, obviously I made a mess of my program when pasting it into the web form. Of course, there was a foreign key right from the beginning. A whole line including a parenthesis and a comma dropped out: referer = Table(referer, metadata, Column(id, Integer, primary_key=True),

[sqlalchemy] Re: postgresql: need schema-qualified foreign keys

2007-07-09 Thread klaus
I'm not sure whether I understody your posting correctly. Now I've checked out revision 2867 and nothing has changed, that is, I still get the same exceptions. Best regards Klaus On Jul 9, 9:44 am, klaus [EMAIL PROTECTED] wrote: Oops, obviously I made a mess of my program when pasting it

[sqlalchemy] Re: postgresql: need schema-qualified foreign keys

2007-06-19 Thread klaus . barthelmann
This looks like a good solution. I'll need some time to provide a test case, however. If the change breaks existing code, how are cross-schema references supposed to be handled? Best regards Klaus On 18 Jun., 21:54, Michael Bayer [EMAIL PROTECTED] wrote: On Jun 18, 2007, at 4:25 AM, [EMAIL

[sqlalchemy] Re: postgresql: need schema-qualified foreign keys

2007-06-18 Thread Michael Bayer
On Jun 18, 2007, at 4:25 AM, [EMAIL PROTECTED] wrote: In my first experiments with elixir I noticed that sqlalchemy doesn't handle foreign keys correctly on autoloaded tables. This has to to with schema handling in the postgresql driver. A foreign key referencing a table in the public