Re: [GENERAL] foriegn key...

2000-04-12 Thread Manuel Cabido


  Better try to install PostgreSQL version 7 and experiment on referential
integrity...

-- 
  Manny C. Cabido
  
  e-mail:[EMAIL PROTECTED]
 [EMAIL PROTECTED]
  =




Re: [GENERAL] foriegn key...

2000-04-12 Thread Jan Wieck

  AFAIK Postgres doesn't (yet) directly support foreign keys. You have
  to supply that ability yourself, possibly through triggers and
  procedures.

 I am using version 7.0 beta 5... and btw, I found a little snippit of
 code syntax on this page: http://www.postgresql.org/projects/devel-refint.html
 which is good enough to meet my needs for now.

Final  will  have  the appropriate doc changes. Sorry for the
delay, I just forgot a doc patch in my mailbox.


Jan

--

#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.  #
#= [EMAIL PROTECTED] (Jan Wieck) #





Re: [GENERAL] foriegn key...

2000-04-12 Thread Jan Wieck

 On 11 Apr 2000 17:55:43 -0400, [EMAIL PROTECTED] (Andrew
 Schmeder) wrote:

 AFAIK Postgres doesn't (yet) directly support foreign keys. You have
 to supply that ability yourself, possibly through triggers and
 procedures.

AFAIK (and I led the project),

v7.0  (released  soon  and  the version he asked about) has a
fear amount of FK support.  The  implementation  misses  only
MATCH  PARTIAL  and  PENDANT from the SQL3 specs, so it's far
more than SQL92!

Special thanks go to Stephan Szabo and Don Baccus; both where
major contributors to the project.


Jan

--

#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.  #
#= [EMAIL PROTECTED] (Jan Wieck) #