Re: Delete Problem

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delete Problem
Date: 2006-07-13 06:52:31
Message-ID: 20060713065231.GA25071@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 13, 2006 at 04:28:50PM +1000, Jamie Deppeler wrote:
> From psql
>
> db=# select "primary" from job where "primary" = 370;
> primary
> ---------
> 370
> (1 row)
>
> db=# delete from job where "primary" = 370;
> DELETE 0

You said that you had deleted all triggers -- have you verified
that none remain? Does the table have any rules? What does
"\d job" show?

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jamie Deppeler 2006-07-13 06:58:26 Re: Delete Problem
Previous Message Jamie Deppeler 2006-07-13 06:48:05 Re: Delete Problem