pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSQL features...
3+ messages / 3 participants
[nested] [flat]
* SQL features...
@ 1999-12-23 16:50 rjb@typeline.com
1999-12-24 05:51 ` Re: [SQL] SQL features... Howie <caffeine@toodarkpark.org>
0 siblings, 1 reply; 3+ messages in thread
From: rjb@typeline.com @ 1999-12-23 16:50 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] SQL features...
1999-12-23 16:50 SQL features... rjb@typeline.com
@ 1999-12-24 05:51 ` Howie <caffeine@toodarkpark.org>
1999-12-24 11:46 ` Re: [SQL] SQL features... Jan Wieck <wieck@debis.com>
0 siblings, 1 reply; 3+ messages in thread
From: Howie @ 1999-12-24 05:51 UTC (permalink / raw)
To: rjb@typeline.com; +Cc: pgsql-sql
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."
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] SQL features...
1999-12-23 16:50 SQL features... rjb@typeline.com
1999-12-24 05:51 ` Re: [SQL] SQL features... Howie <caffeine@toodarkpark.org>
@ 1999-12-24 11:46 ` Jan Wieck <wieck@debis.com>
0 siblings, 0 replies; 3+ messages in thread
From: wieck@debis.com @ 1999-12-24 11:46 UTC (permalink / raw)
To: caffeine@toodarkpark.org; +Cc: rjb@typeline.com; pgsql-sql
>
> > 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) #
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-12-24 11:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-12-23 16:50 SQL features... rjb@typeline.com
1999-12-24 05:51 ` Howie <caffeine@toodarkpark.org>
1999-12-24 11:46 ` Jan Wieck <wieck@debis.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox