RE: What's going on here figured it out?

From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: RE: What's going on here figured it out?
Date: 2001-07-27 12:32:23
Message-ID: 023501c11698$2faf4420$8201a8c0@inspiron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for everyone's input. Dumping the schema for the table was the
hint. I found the trigger that was causeing it to fail.

Would be nice if there was some debug mode to see what it was doing?

Dave

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: July 27, 2001 1:57 AM
To: Dave(at)micro-automation(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] What's going on here?

Seems pretty weird. May we see the full schema for the table? "pg_dump
-s -t tablename dbname" is the best way.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fariba Noorbakhsh 2001-07-27 14:33:24 Question about Foreign key!
Previous Message Tom Lane 2001-07-27 05:59:17 Re: Re: Running Postmaster - PGDATA Variable