Re: Delete Problem

db=# \d job
                                                Table "job"
       Column        |            Type
|                           Modifiers
---------------------+-----------------------------+----------------------------------------------------------------
 primary             | integer                     | not null default
nextval('job_primary_seq'::regclass)
 jobnumber           | text                        |
 jobname             | text                        |
 jobdetails          | text                        |
Indexes:
    "job_pkey" PRIMARY KEY, btree ("primary")

Michael Fuhr wrote:
> 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?
>
>