Re: Updating an emty table? - Mailing list pgsql-general

From Hubert Lubaczewski
Subject Re: Updating an emty table?
Date
Msg-id 20030625110649.742ee7b5.hubert.lubaczewski@eo.pl
Whole thread Raw
In response to Re: Updating an emty table?  ("Bjorn T Johansen" <btj@havleik.no>)
List pgsql-general
On Wed, 25 Jun 2003 11:00:55 +0200 (CEST)
"Bjorn T Johansen" <btj@havleik.no> wrote:

> I am guessing that since you are using an if statement, that PostgreSQL
> doesn't support writing this using exceptions. (I know I have written
> functions like this, trying to do an update first and if specific
> exception occured I then do an insert...)

hmm .. exception will issue "rollback" thus making your transaction void. any update's or inserts would vanish.

depesz

pgsql-general by date:

Previous
From: "Bjorn T Johansen"
Date:
Subject: Re: Updating an emty table?
Next
From: Sven Köhler
Date:
Subject: Re: [BUG?] table inhiritance violates primary key