That's just what I needed. Thanks guys!
Artacus
On Thu, Sep 04, 2008 at 02:07:01AM -0700, Artacus wrote:
I'm writing some ETL procedures in pgplsql. After each
insert/update/delete, I'd like to log how many rows were affected.
http://www.postgresql.org/docs/current/interactive/plpgsql-state
On Thu, Sep 04, 2008 at 02:07:01AM -0700, Artacus wrote:
> I'm writing some ETL procedures in pgplsql. After each
> insert/update/delete, I'd like to log how many rows were affected.
http://www.postgresql.org/docs/current/interactive/plpgsql-statements.html
search for "GET DIAGNOSTICS"
Best reg
Maybe this will be helpfull:
http://www.postgresql.org/docs/8.3/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
Regards,
Blazej Oleszkiewicz
2008/9/4 Artacus <[EMAIL PROTECTED]>:
> I'm writing some ETL procedures in pgplsql. After each insert/update/delete,
> I'd like to log h
I'm writing some ETL procedures in pgplsql. After each
insert/update/delete, I'd like to log how many rows were affected.
I'm not finding anything on Google. Does anyone know how to get this?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
