Re: Updating an emty table?

From: Hubert Lubaczewski <hubert(dot)lubaczewski(at)eo(dot)pl>
To: "Bjorn T Johansen" <btj(at)havleik(dot)no>, pgsql-general(at)postgresql(dot)org
Subject: Re: Updating an emty table?
Date: 2003-06-25 09:06:49
Message-ID: 20030625110649.742ee7b5.hubert.lubaczewski@eo.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 25 Jun 2003 11:00:55 +0200 (CEST)
"Bjorn T Johansen" <btj(at)havleik(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-25 09:25:46 Re: pg_statistic_relid_att_index
Previous Message Sven Köhler 2003-06-25 09:06:23 Re: [BUG?] table inhiritance violates primary key