Re: JDBC not returning update count from updateable view

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: Russell Keane <Russell(dot)Keane(at)inps(dot)co(dot)uk>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: JDBC not returning update count from updateable view
Date: 2013-02-26 15:18:40
Message-ID: CAEZATCXDUuqHjsHfLTfdM4W_CYCAkAdAFj-qBqn5WOkUjAD=hQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 25 February 2013 19:52, Russell Keane <Russell(dot)Keane(at)inps(dot)co(dot)uk> wrote:
> Hi,
>
>
>
> We have a table which is inserted to and update via a view (using rules /
> functions).
>

In PG 9.1 and later, the recommended way to do this is using INSTEAD
OF triggers on the view.

See the "Notes" section here:
http://www.postgresql.org/docs/current/static/sql-createview.html

and the example here:
http://www.postgresql.org/docs/current/static/plpgsql-trigger.html#PLPGSQL-VIEW-TRIGGER-AUDIT-EXAMPLE

Regards,
Dean

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2013-02-26 23:30:49 Re: PosgreSQL Konfigürasyonu
Previous Message Russell Keane 2013-02-26 15:01:14 Re: JDBC not returning update count from updateable view