I believe your foreign key is stopping the delete:
SurID character varying(50) NOT NULL .... ON DELETE RESTRICT,
^^^^^^^^^^^^^^^^^^
Make sure all tuples that SurID references are deleted, then try it
again.
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Tue, 6 Mar 2001, Cedar Cox wrote:
>
> 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
>
>