Bug about 'Foreign Key'
От | Cid R Andrade |
---|---|
Тема | Bug about 'Foreign Key' |
Дата | |
Msg-id | 00dc01c0b6cc$4c9e4bc0$543c620a@catnet.com.br обсуждение исходный текст |
Ответы |
Re: Bug about 'Foreign Key'
|
Список | pgsql-bugs |
PostgreSQL Developers, I have a PostgreSQL 7.0.2 running at Conectiva Linux, with kernel 2.2.14, w= ith 56 Mb of data. I'd created a table: Create Table Andamento ( Etiqueta integer not null, CodTecnico integer not null, DtInicio timestamp not null, DtLiberacao timestamp null, Primary Key (Etiqueta), Foreign Key (Etiquetas) References Etiquetas (Etiqueta) On Delete Casca= de) =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 I wrong a field name in Foreign Key declaration, and PostgreSQL created it! Before this, I always named triggers and constraints, but, at this time, I'= d tried this way. Well, look the trigger at table Etiquetas: CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "etiquetas" NOT DEFE= RRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction= _del" ('<unnamed>', 'andamento', 'etiquetas', 'UNSPECIFIED', 'etiquetas', '= etiqueta'); It says exists a field named etiquetas at table Andamento. I'd droped table andamento (Drop Table Andamento) and the trigger referenci= ng it didn't droped. I solved it with pg_dump.
В списке pgsql-bugs по дате отправления: