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?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
