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?
>
>