Re: can't delete record

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
> 
>