Thread: 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
On Thu, 23 Dec 1999 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 refint, for now, handles foreign key constraints. search the mailing list for additional info. > Does anyone know when these feature might be implemented? full fk support ( via REFERENCES ) is due out in 7.0. > Also: Is libpg a shared library? depends on how you compile it. > 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? yes. and vice versa. --- Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org "I've learned that you cannot make someone love you. All you can do is stalk them and hope they panic and give in."
> > > Does anyone know when these feature might be implemented? > > full fk support ( via REFERENCES ) is due out in 7.0. Not full, only partial. All that'll be available is MATCH FULL. Missing will be MATCH PARTIAL, MATCH <unspecified> and PENDANT. But will be much better than refint anyway, since it will completely support DEFERRED and check for thinks like "triggered data change violation". Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #========================================= wieck@debis.com (Jan Wieck) #