Re: [HACKERS] 6.6 release

>
> Thus spake Hannu Krosing
> > "D'Arcy J.M. Cain" wrote:
> > > Any chance of getting the FK semantics into the parser right away even
> > > though it is ignored?
> >
> > We do have foreign key syntax in parser
> >
> > hannu=> create table foreign_tab(
> > hannu-> f int,
> > hannu-> foreign key(f) references primary_tab (i)
> > hannu-> );
> > NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented
> >
> > What do you mean by semantics here ?
> > Should it check that the primary table and field(s) exist ?
>
> Nope. That's exactly what I meant. I didn't realize that it was already
> there. Sorry for the confusion.

Caution D'Arcy,

the FOREIGN KEY syntax that's in 6.5 is a little incomplete.
Doesn't allow match type and constraint attribute
specification (deferrability and initial deferred state).
Especially the match type is required, because in 7.0 only
MATCH FULL will be implemented, not the <unspecified>
default.

As I said in another post, the constraint attr spec isn't
possible in column constraint right now in 7.0, but we're
working on it. Should be ready in a few days.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #