Skip site navigation (1) Skip section navigation (2)

can't delete record

From: Cedar Cox <cedarc(at)visionforisrael(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: can't delete record
Date: 2001-03-06 20:36:49
Message-ID: Pine.LNX.4.21.0103062229550.17353-100000@nanu.visionforisrael.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
testdb=# select * from tblstsc1options where sc1optionid=1;
 sc1optionid | sc1optionname | sc1optionvalue | surid 
-------------+---------------+----------------+-------
           1 | blah          |                | 1.2
(1 row)

testdb=# delete from tblstsc1options where sc1optionid=1;
DELETE 0
testdb=# 

--
 I must be really, really tired and I'm missing something.  Can anyone
help ;)  FYI, I'm on PG 7.0.2.

As far as I can see, I don't have any rules on this table and the trigger
function returns new, not null.  This is the table definition:

CREATE TABLE tblStSC1Options (
        SC1OptionID int4 NOT NULL,
        SC1OptionName character varying(50) NOT NULL CHECK
(SC1OptionName<>''),
        SC1OptionValue float4 CHECK (SC1OptionValue>0),
        SurID character varying(50) NOT NULL REFERENCES tblStSC1 ON UPDATE
CASCADE ON DELETE RESTRICT,
        PRIMARY KEY (SC1OptionID)
);


Thanks,
-Cedar


Responses

pgsql-interfaces by date

Next:From: Bjorn SolbergDate: 2001-03-06 21:10:39
Subject: Backend dies for DBI
Previous:From: Michael ForkDate: 2001-03-06 20:28:01
Subject: Re: can't delete record

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group