On Thu, 2006-08-24 at 14:12 -0400, Tom Lane wrote:
> Rajarshi Guha <[EMAIL PROTECTED]> writes:
> > On Thu, 2006-08-24 at 10:50 -0400, Tom Lane wrote:
> >> I think you are getting burnt by the list of pending trigger actions
> >> to check the foreign-key references in B.
>
> > Thanks for the pointe
Rajarshi Guha <[EMAIL PROTECTED]> writes:
> On Thu, 2006-08-24 at 10:50 -0400, Tom Lane wrote:
>> I think you are getting burnt by the list of pending trigger actions
>> to check the foreign-key references in B.
> Thanks for the pointer. I've dropped the constraint and am now running
> the INSERT.
On Thu, 2006-08-24 at 10:50 -0400, Tom Lane wrote:
> Rajarshi Guha <[EMAIL PROTECTED]> writes:
> > I have a table, A with 15 fields, out of which I am interested in 2
> > fields, a and b. The table has 8,000,000 rows
>
> > I have another table, B, which has 3 fields a, c, and d. The field a
> > re
Rajarshi Guha <[EMAIL PROTECTED]> writes:
> I have a table, A with 15 fields, out of which I am interested in 2
> fields, a and b. The table has 8,000,000 rows
> I have another table, B, which has 3 fields a, c, and d. The field a
> references field a in table A. Table B is empty at this point.
>
Hi, I've recently been using PostgreSQL and am having some trouble
performing an insert.
My situation is this:
I have a table, A with 15 fields, out of which I am interested in 2
fields, a and b. The table has 8,000,000 rows
I have another table, B, which has 3 fields a, c, and d. The field a
r
