Re: [BUGS] Example in plpgsql docs can lead to infinite loop

#1

Phil Sorber <phil (AT) omniti (DOT) com> writes:

Quote:

http://www.postgresql.org/docs/devel...UPSERT-EXAMPLE
This example can lead to an infinite loop if there is another column
that has a unique key constraint on it in addition to the primary key
and someone tries to execute the function with a unique primary key
but a duplicate value for the column with the unique constraint.

Hmm. It might work, depending on what the table's various unique
indexes are for, but I agree that a caution about the case is
reasonable. I adjusted your text a bit and committed this.

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Example in plpgsql docs can lead to infinite loop

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Example in plpgsql docs can lead to infinite loop - 01-28-2012 , 08:08 PM