Postgres Pro
Downloads
Home   >   mailing lists

Re: Does psql use nested transactions? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Does psql use nested transactions?
Date
Msg-id 4122FB7E.7050704@familyhealth.com.au
Whole thread Raw
In response to Re: Does psql use nested transactions?  (Honza Pazdziora <adelton@informatics.muni.cz>)
Responses Re: Does psql use nested transactions?  (Honza Pazdziora <adelton@informatics.muni.cz>)
List pgsql-hackers
Tree view 
> It is not just a typo that you make in the SQL command. You often need
> to do
> 
>     insert into table which has primary key
>     if the insert failed, do update of the existing record

Do the update first then the insert.

Chris

pgsql-hackers by date:

Previous
From: Honza Pazdziora
Date:
Subject: Re: Does psql use nested transactions?
Next
From: Honza Pazdziora
Date:
Subject: Re: Does psql use nested transactions?