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....

--~--~---------~--~----~------------~-------~--~----~
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