Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Wed, Apr 22, 2009 at 2:28 PM, Atul Chojar <achojar@xxxxxxxxxxxx> wrote: >> Any ideas why above update is not working? > Any possibility you're doing the updates to an inherited table, or a > table in a different schema or a different database than you think? Another possibility is that the script is issuing BEGIN and then not sending a COMMIT before it exits. In that case the behavior is going to be auto-rollback, not auto-commit. The psql invocation as given doesn't show any sign of that, but maybe there's a \set AUTOCOMMIT off hiding in ~/.psqlrc, or something like that? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
