Hi:
I would like to ask the following questions:
a) Are foreign key constraint triggers guaranteed to
execute first before any ordinary BEFORE
INSERT/UPDATE/DELETE trigger is executed? (This is
assuming that the foreign keys are declared as NOT
DEFERRABLE)
b) Is varchar (without upper limit)
On Thu, 12 Jun 2003, Ludwig Lim wrote:
I would like to ask the following questions:
a) Are foreign key constraint triggers guaranteed to
execute first before any ordinary BEFORE
INSERT/UPDATE/DELETE trigger is executed? (This is
assuming that the foreign keys are declared as NOT
Hi, all
By using 'PLpgsql', is that possible to
1) check if a specific table exists?
2) check if an INSERT/UPDATE/ DELETE has done successfully?
Is there some more documents or samples for PLpgsql except USER GUIDE and
PostgreSQL Introduction concept?
THANK YOU
JACK
PROTECTED]
Subject: [SQL] Some questions about PLpgSql
Hi, all
By using 'PLpgsql', is that possible to
1) check if a specific table exists?
2) check if an INSERT/UPDATE/ DELETE has done successfully?
Is there some more documents or samples for PLpgsql except USER GUIDE
Jack,
2) check if an INSERT/UPDATE/ DELETE has done successfully?
This happens automatically, within a PL/pgSQL function. If the
INSERT/UPDATE errors out, the function automatically halts. Actually,
this kind of behaviour can be annoying the other way (sometimes one
doesn't care about the