Getting affected rows in pgplsql

Lists: pgsql-general
From: Artacus <artacus(at)comcast(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Getting affected rows in pgplsql
Date: 2008-09-04 09:07:01
Message-ID: 48BFA535.5000509@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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?

From: Blazej <bl(dot)oleszkiewicz(at)gmail(dot)com>
To: Artacus <artacus(at)comcast(dot)net>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting affected rows in pgplsql
Date: 2008-09-04 11:08:40
Message-ID: 819df3760809040408s2fb960f2u7488080d97a68585@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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 <artacus(at)comcast(dot)net>:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Artacus <artacus(at)comcast(dot)net>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting affected rows in pgplsql
Date: 2008-09-04 11:08:44
Message-ID: 20080904110844.GA32685@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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 regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

From: Artacus <artacus(at)comcast(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting affected rows in pgplsql
Date: 2008-09-05 03:52:13
Message-ID: 48C0ACED.2030402@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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-statements.html
> search for "GET DIAGNOSTICS"