Re: [GENERAL] (redefinition) alter table, add foreign key constraint

2000-10-17 Thread bmccoy
On Tue, 17 Oct 2000, Matthew Kennedy wrote: > A little redefinition of my question is in order. If I try doing this: > > create table things (name varchar(20), state(2)); > create table states (abbreviation varchar(2)); > alter table things > add foreign key (state) > references st

Re: [GENERAL] (redefinition) alter table, add foreign key constraint

2000-10-17 Thread Stephan Szabo
On Tue, 17 Oct 2000, Matthew Kennedy wrote: > [EMAIL PROTECTED] wrote: > > On Tue, 17 Oct 2000, Matthew Kennedy wrote: > > > Is it possible to perform an alter table with add foreign key constraint > > > in PostgreSQL? We are trying to support multiple DBMS in our project by > > > keeping to a c

Re: [GENERAL] (redefinition) alter table, add foreign key constraint

2000-10-17 Thread Matthew Kennedy
[EMAIL PROTECTED] wrote: > On Tue, 17 Oct 2000, Matthew Kennedy wrote: > > Is it possible to perform an alter table with add foreign key constraint > > in PostgreSQL? We are trying to support multiple DBMS in our project by > > keeping to a common, compatible denominator. Oracle, supports such a >