Обсуждение: SQL Features...
There seems to be a few SQL compatibility issues in Postgres that are making it difficult for me to convert from Interbase. They are: Support for foreign keys Cascading a deletion across a referenced table or tables using a foreign key Does anyone know when these feature might be implemented? Also: Is libpg a shared library? Can I write a client program say on a FreeBSD box that links to this library and calls a remote Postgres db server running on a Linux box? Thanks
> There seems to be a few SQL compatibility issues in Postgres that are > making it difficult for me to convert from Interbase. They are: > > Support for foreign keys > Cascading a deletion across a referenced table or tables using a foreign > key Next release 7.0 in a few months will have this. > > Does anyone know when these feature might be implemented? > > Also: Is libpg a shared library? Can I write a client program say on a > FreeBSD > box that links to this library and calls a remote > Postgres db server running on a Linux box? You can communicate via tcp/ip to any server machine. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
rjb@typeline.com wrote: > There seems to be a few SQL compatibility issues in Postgres that are > making it difficult for me to convert from Interbase. They are: > > Support for foreign keys > Cascading a deletion across a referenced table or tables using a foreign > key > > Does anyone know when these feature might be implemented? Coming in the next version courtesy of Jan Wieck. > > > Also: Is libpg a shared library? Can I write a client program say on a > FreeBSD > box that links to this library and calls a remote > Postgres db server running on a Linux box? libpq is a shared library and you can write a client on most unix client systems to connect to a postgres database. Adriaan