[SQL] How to disable rules??

hi all, I'm looking for a way to temporary disable a rule on a table. I've find (looking at the dump) the way to disable triggers : UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = ''table_name''; ***QUERY***; UPDATE pg_class SET reltriggers = (SELECT count(*) FR

Re: [SQL] Retrieving the new nextval...

Hi all, I'm in trouble with the same problem, but in PHP.. With your solution, I cannot be totally sure that last inserted raw was mine... Because I'm on a web page, it could be that, as soon as I've inserted my record, another one do an insertion, so I would get the wrong ID... does transactions

Re: [SQL] Retrieving the new "nextval" for primary keys....

One solution seems to locking table(s), but I prefer to leave it as last chance... using table locks, and the trick of writing and suddenly reading back from DB it probably works, but it doesn't seems so sexy... :) ciao danilo

[SQL] nextval...

Ok , now I believe it :) thanks to all. danilo __ Yahoo! Musica: notizie, recensioni, classifiche, speciali multimediali http://it.yahoo.com/mail_it/foot/?http://it.music.yahoo.com/ ---(end of broadcast)