Re: Re: can't delete record

I think actually you are wrong, for two reasons.  1. If I was having a
problem with referential integrity, I would get an error message when I
tried to delete.  2. This is the many side of the relationship.  It is
perfectly valid to delete a record on the many side.  In fact, if I do
attempt to delete the record on the one side, I get the error message.

Strike 1! :)

On Tue, 6 Mar 2001, Michael Fork wrote:

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