Hi,
Are a trigger or rule part of a query, that is:
1. Does an insert, update or delete statement return before or after an
After trigger (is such a trigger or rule synchronous or a-synchronous?
2. Is there a concept of a rule or trigger that fails? If so, if a
trigger or rule fails, does the
Joost Kraaijeveld wrote:
1. Does an insert, update or delete statement return before or after
an After trigger (is such a trigger or rule synchronous or
a-synchronous?
Synchronous
2. Is there a concept of a rule or trigger that fails?
If so, if a trigger or rule fails, does the insert,
Hi Peter,
On Sun, 2005-11-20 at 12:08 +0100, Peter Eisentraut wrote:
Joost Kraaijeveld wrote:
1. Does an insert, update or delete statement return before or after
an After trigger (is such a trigger or rule synchronous or
a-synchronous?
Synchronous
2. Is there a concept of a rule or
PROTECTED] Behalf Of Enrico Weigelt
Sent: Monday, May 02, 2005 9:02 AM
To: pgsql-sql
Subject: Re: [SQL] trigger/rule question
* Ramakrishnan Muralidharan [EMAIL PROTECTED] wrote:
Hi,
Going through you mail, I assume that you are updating the mtime
only after inserting the record
Enrico Weigelt wrote:
* Christoph Haller [EMAIL PROTECTED] wrote:
Hi,
I assume this still refers to
[SQL] RULE for mtime recording
from last Friday.
ehm, yeah. I forgot that I've already asked this stuff ...
hmmpf. seems I'm not getting younger ;-)
snip
I gave it another
* Ramakrishnan Muralidharan [EMAIL PROTECTED] wrote:
Hi,
Going through you mail, I assume that you are updating the mtime
only after inserting the record.
An normal update (=done by an application or user) should also
update the mtime. But there's an replication subsystem, which
* Christoph Haller [EMAIL PROTECTED] wrote:
Hi,
I assume this still refers to
[SQL] RULE for mtime recording
from last Friday.
ehm, yeah. I forgot that I've already asked this stuff ...
hmmpf. seems I'm not getting younger ;-)
snip
I gave it another thought and
I am now having
,
R.Muralidharan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Enrico Weigelt
Sent: Wednesday, April 27, 2005 10:26 PM
To: pgsql-sql
Subject: [SQL] trigger/rule question
Hi folks,
for database synchronization I'm maintaining an mtime field in
each record
Enrico Weigelt wrote:
Hi folks,
for database synchronization I'm maintaining an mtime field in
each record and I'd like to get it updated automatically on
normal writes (insert seems trivial, but update not), but it
must remain untouched when data is coming in from another node
(to
Hi folks,
for database synchronization I'm maintaining an mtime field in
each record and I'd like to get it updated automatically on
normal writes (insert seems trivial, but update not), but it
must remain untouched when data is coming in from another node
(to prevent sync loops).
I first
10 matches
Mail list logo