On Tue, Jun 06, 2006 at 02:22:39PM +0200, Sandro Dentella wrote: > On Mon, Jun 05, 2006 at 07:32:52PM -0400, Michael Bayer wrote: > > im on 8.0.4 here and it performs like crap. not sure if the "primary key > > with a different user" bug (ticket 71 in trac) is with the 8 series as > > well. > > It's working ok with pg8.1 while it's not with 7.4.
I must contraddict myself... again a normal user different from the owner cannot even reflect the table, the situation is unchanged: estr='postgres://hostname=localhost&password=vicie&database=eurotex&port=5433' eng1 = create_engine(estr + '&user=sandro') eng2 = create_engine(estr + '&user=test') eng3 = create_engine(estr + '&user=eurotex') table = 'calendario' Table1 = Table (table, eng1, autoload=True) Table2 = Table (table, eng2, autoload=True) Table3 = Table (table, eng3, autoload=True) print "Sandro (super_user): %s" % Table1.columns._list print "Test (normal_user): %s" % Table2.columns._list print "Eurotex (owner): %s" % Table3.columns._list Sandro (super_user): ['cal_anno', 'cal_giorno', 'cal_id', 'cal_mese', 'cal_nota', 'cal_ore', 'cal_tipo', 't_id'] Test (normal_user): [] Eurotex (owner): ['cal_anno', 'cal_giorno', 'cal_id', 'cal_mese', 'cal_nota', 'cal_ore', 'cal_tipo', 't_id'] sandro *:-) -- Sandro Dentella *:-) http://www.tksql.org TkSQL Home page - My GPL work _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
