Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group