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:
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 l
Josh Berkus <[EMAIL PROTECTED]> writes:
> Now, testing how many rows were inserted/updated/deleted ... that I'm
> not sure about. It would be nice to have a ROWS_AFFECTED returned from
> a data manipulation query in PL/pgSQL, but I don't believe that that has
> been implemented.
It has as of 7.1
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 er
gt; Sent: 15 March 2001 12:04
> To: [EMAIL 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?
&
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
---
