Michael Bayer ha scritto:
> 
> On Nov 20, 2007, at 4:35 AM, Manlio Perillo wrote:
> 
>> I have asked on the psycopg2 list.
>>
>> psycopg2 connection has a notices attribute.
>>
>>
>> try:
>>     conn = db.connect()
>>     metadata.create_all(bind=conn)
>>
>>     print conn.connection.connection.notices
>> finally:
>>     metadata.drop_all()
>>
>>
>> ['NOTICE:  CREATE TABLE will create implicit sequence "a_id_seq" for
>> serial column "a.id"\n', 'NOTICE:  CREATE TABLE / PRIMARY KEY will
>> create implicit index "a_pkey" for table "a"\n', 'NOTICE:  CREATE  
>> TABLE
>> / PRIMARY KEY will create implicit index "b_pkey" for table "b"\n',
>> 'WARNING:  foreign key constraint "b_id_fkey" will require costly
>> sequential scans\nDETAIL:  Key columns "id" and "id" are of different
>> types: text and integer.\n']
>>
>>
>> So SQLAlchemy can process it, if this is reasonable.
> 
> 
> hmmm, thats interesting.  it would have to be placed at the execute  
> level, but of course we are only going to issue warnings, not  
> exceptions.  I think this might also be better as an optional flag for  
> the PG dialect.
> 
> create a ticket in trac else I'll lose track of this one....
> 


Done: #877.



Manlio Perillo

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to