Re: drop table and references
От | Martin A. Marques |
---|---|
Тема | Re: drop table and references |
Дата | |
Msg-id | Pine.LNX.4.10.10101101546330.28460@math.unl.edu.ar обсуждение исходный текст |
Ответ на | Re: drop table and references (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Список | pgsql-general |
On Tue, 9 Jan 2001, Stephan Szabo wrote: > > On Tue, 9 Jan 2001, Martin A. Marques wrote: > > > I have a big doubt. If I drop a table with a primary key to which other > > tables reference to, what happens? And If I create the table again, just as > > it was, but maybe with another column? > > Theoretically (ie, assuming no bugs), when you drop the table the foreign > key constraints are dropped as well. If you recreate the table the > constraints are not recreated, you'd have to use ALTER TABLE ADD > CONSTRAINT to make them again. I was talking about tables with primary keys to which foreign keys of other tables are referenced to. Any way the primary key has to be recreated, because the column was of type SERIAL. I'm I right? System Administration: It's a dirty job, but someone told I had to do it. ----------------------------------------------------------------- Martín Marqués email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------
В списке pgsql-general по дате отправления: