pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SQL 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