On Sun, 3 Mar 2002, Dan Langille wrote:
> On 2 Mar 2002 at 23:42, Stephan Szabo wrote:
>
> >
> > > I found the list of duplicate constraints by eyeballing the files I
> > > created using the methods mentioned in previous post (mainly grep and
> > > sort). Then I would search in the original dump
On 2 Mar 2002 at 23:42, Stephan Szabo wrote:
>
> > I found the list of duplicate constraints by eyeballing the files I
> > created using the methods mentioned in previous post (mainly grep and
> > sort). Then I would search in the original dump file for the the CREATE
> > CONSTRAINT statement.
> I found the list of duplicate constraints by eyeballing the files I
> created using the methods mentioned in previous post (mainly grep and
> sort). Then I would search in the original dump file for the the CREATE
> CONSTRAINT statement. Using the name found there
> (RI_ConstraintTrigger_9981
On 2 Mar 2002 at 11:09, Stephan Szabo wrote:
> On Sat, 2 Mar 2002, Dan Langille wrote:
>
> > On 2 Mar 2002 at 10:19, Dan Langille wrote:
> >
> > > CREATE CONSTRAINT TRIGGER "" AFTER INSERT OR UPDATE ON "ports"
> > > FROM "categories" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW
> > > EXECUTE
On Sat, 2 Mar 2002, Dan Langille wrote:
> On 2 Mar 2002 at 10:19, Dan Langille wrote:
>
> > CREATE CONSTRAINT TRIGGER "" AFTER INSERT OR UPDATE ON "ports"
> > FROM "categories" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE
> > PROCEDURE "RI_FKey_check_ins" ('', 'ports', 'categories',
>
On 2 Mar 2002 at 10:19, Dan Langille wrote:
> CREATE CONSTRAINT TRIGGER "" AFTER INSERT OR UPDATE ON "ports"
> FROM "categories" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE
> PROCEDURE "RI_FKey_check_ins" ('', 'ports', 'categories',
> 'UNSPECIFIED', 'category_id', 'id');
>
> CREATE
I was looking through my database schema and noticed that some foreign key
declarations were duplicated. For example, I found this statement
occurred twice within my DDL:
alter table ports
add foreign key (category_id)
references categories (id) on update cascade on delete cascade;
