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