statement level triggers in PostgreSQL , anybody??

From: nramakrishna7(at)yahoo(dot)com (rama)
To: pgsql-general(at)postgresql(dot)org
Subject: statement level triggers in PostgreSQL , anybody??
Date: 2004-05-27 13:28:08
Message-ID: fd508551.0405270528.4e94d25d@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I am a bit troubled with the row-level triggers which PostgreSQL
uses when using update table cpmmand.
For instance, if the primary key column has values 1,2,3,... and
i want to update the whole column as column = colunm + 1 , then there
is an error. This obviously works on databases such as mssql which has
row level triggers.
Any suggestions so that i do not have to modify the query and
still make it work in the postgresql database ??

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2004-05-27 13:48:43 Re: insert/update
Previous Message Nick Barr 2004-05-27 12:32:14 Re: Naive schema questions