Re: Simple SQL INSERT to avoid duplication failed: why? - Mailing list pgsql-general

From Tom Lane
Subject Re: Simple SQL INSERT to avoid duplication failed: why?
Date
Msg-id 22217.1366923989@sss.pgh.pa.us
Whole thread Raw
In response to Simple SQL INSERT to avoid duplication failed: why?  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Responses Re: Simple SQL INSERT to avoid duplication failed: why?
List pgsql-general
"Carlo Stonebanks" <stonec.register@sympatico.ca> writes:
> Ok, I tried to be clever and I wrote code to avoid inserting duplicate data.
> The calling function has a try-catch to recover from this, but I am curious
> as to why it failed:

There's nothing obviously wrong with that, which means the issue is in
something you didn't show us.  Care to assemble a self-contained
example?

            regards, tom lane


pgsql-general by date:

Previous
From: "Carlo Stonebanks"
Date:
Subject: Simple SQL INSERT to avoid duplication failed: why?
Next
From: Merlin Moncure
Date:
Subject: Re: is there a way to deliver an array over column from a query window?