RE: What's going on here figured it out? - Mailing list pgsql-general

From Dave Cramer
Subject RE: What's going on here figured it out?
Date
Msg-id 023501c11698$2faf4420$8201a8c0@inspiron
Whole thread Raw
In response to Re: What's going on here?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane
Sent: July 27, 2001 1:57 AM
To: Dave@micro-automation.net
Cc: pgsql-general@postgresql.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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Running Postmaster - PGDATA Variable
Next
From: Fariba Noorbakhsh
Date:
Subject: Question about Foreign key!