we've had a lot of issues with Postgres and using  
information_schema.  whereas MySQL's information_schema support was  
pointless, Postgres mostly works, but performs very slowly unless you  
VACUUM your database every hour.  we've had reports of primary keys  
not being reflected for tables across user names as well.

what does the list think of dumping information_schema usage  
altogther and using PG's own schema tables for reflection ?


On Jun 3, 2006, at 4:41 AM, Yuan HOng wrote:

> There is something wrong with my 7.3.x database. The primary key is
> not shown in information_schema.table_constraints while it is in the
> table definition.
>
> So this is not a bug of SA but maybe that of postgres.
>
> On 6/3/06, Yuan HOng <[EMAIL PROTECTED]> wrote:
>> I've found out that when I try to autoload the table metadata from
>> Postgres 7.3.x databases, the primary key column is not correctly
>> detected by SA. The loaded table will be without primary key.
>>
>> But with Postgres 8.x, primary key is correctly set for the table
>> automatically reflected from the database.
>>
>
> -- 
> Hong Yuan
>
> 大管家网上建材超市
> 装修装潢建材一站式购物
> http://www.homemaster.cn
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to