Postgres Pro
Downloads
Home   >   mailing lists

Thread: SQL Features...

SQL Features...

From
rjb@typeline.com
Date:
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

Re: [GENERAL] SQL Features...

From
Bruce Momjian
Date:
> 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

Re: [GENERAL] SQL Features...

From
Adriaan Joubert
Date:
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