Re: plpgsql question/problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Hyatt, Gordon" <Gordon(dot)Hyatt(at)joslin(dot)harvard(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: plpgsql question/problem
Date: 2007-08-13 21:06:10
Message-ID: 22026.1187039170@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> On 8/13/07, Hyatt, Gordon <Gordon(dot)Hyatt(at)joslin(dot)harvard(dot)edu> wrote:
>> When I attempt to run insert_a_and_b, insert_b fails with a foreign key violation.

> I ran your exact same code and it worked fine. Note that I changed one line:

Works for me too (with Scott's correction), in 8.1.x, 8.2.x, and HEAD.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message olivier.boissard@cerene.fr 2007-08-13 21:30:26 Re: except command
Previous Message Scott Marlowe 2007-08-13 20:46:17 Re: plpgsql question/problem