| From: | Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Delete Problem |
| Date: | 2006-07-13 06:58:26 |
| Message-ID: | 44B5EF12.8050108@doitonce.net.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-07-13 07:20:16 | Re: Delete Problem |
| Previous Message | Michael Fuhr | 2006-07-13 06:52:31 | Re: Delete Problem |