about creating DB

On Fri, 23 Mar 2001, hiroko wrote:

we're switching our system from Unix-version to Linux-version,
and from SQLplus to PostgreSQL

the questions are about CREATING DB

I found that FOREIGN KEY clause, which we need for our DB, is not
implemented on PostgreSQL.
that means you can't use DELETE CASCADE clause neither.

is there some alternative way for them????
llike, can't you use CHECK clause instead for them???

Foreign keys have been available in PostgreSQL since version 7.0. Please
see the online documentation.

-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
You can do more with a kind word and a gun than with just a kind word.
- Al Capone

On Fri, Mar 23, 2001 at 07:41:51PM +0900, hiroko wrote:

hi all

we're switching our system from Unix-version to Linux-version,
and from SQLplus to PostgreSQL

the questions are about CREATING DB

I found that FOREIGN KEY clause, which we need for our DB, is not
implemented on PostgreSQL.
that means you can't use DELETE CASCADE clause neither.

i'm using 7.0.3 (on debian potato)--

create table lookup (
major serial,
minor int4,
other ...
);

create table kahunamydata (
id serial,
...
MAJOR int4,
MINOR int4,
yada ...,
FOREIGN KEY(major,minor) REFERENCES lookup(major,minor) ON DELETE CASCADE,
...
primary key(id)
);

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

the questions are about CREATING DB

I found that FOREIGN KEY clause, which we need for our DB, is not >

implemented on PostgreSQL.

I believe, it's implemented called REFERENCES
http://www.postgresql.org/devel-corner/docs/postgres/sql-createtable.html

that means you can't use DELETE CASCADE clause neither.

This one I am not sure, but seems can be implemented by adding one
trigger
http://www.postgresql.org/devel-corner/docs/postgres/sql-createtrigger.html

Have fun

--
LM Liu