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
REFERENCEStblStSC1 ON UPDATE
CASCADE ON DELETE RESTRICT, PRIMARY KEY (SC1OptionID)
);
Thanks,
-Cedar