Обсуждение: check_primary_key on Postgres 6.5.3-23

I'm using PostgreSQL 6.5.3-23 (which came with Debian 2.2r0),
and it looks like the check_primary_key (and also check_foreign_key)
functions are missing. What should I do to get them ?

--
Christophe Devine

Christophe Devine <devine@iie.cnam.fr> writes:

> I'm using PostgreSQL 6.5.3-23 (which came with Debian 2.2r0),
> and it looks like the check_primary_key (and also check_foreign_key)
> functions are missing. What should I do to get them ?

I'm not sure what those functions are supposed to do, however if you
are trying to perform primary/foreign key checks on your tables, you
will need the most recent/stable version of postgres: 7.0.3, where
that functionality is fairly stable.

Regards,
Manuel.

On Wed, 13 Dec 2000, Christophe Devine wrote:

> I'm using PostgreSQL 6.5.3-23 (which came with Debian 2.2r0),
> and it looks like the check_primary_key (and also check_foreign_key)
> functions are missing. What should I do to get them ?

Upgrade to 7.01?

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Williams and Holland's Law:
    If enough data is collected, anything may be proven by statistical
    methods.

On Wed, Dec 13, 2000 at 03:44:39PM -0500, Brett W. McCoy wrote :

> > I'm using PostgreSQL 6.5.3-23 (which came with Debian 2.2r0),
> > and it looks like the check_primary_key (and also check_foreign_key)
> > functions are missing. What should I do to get them ?
>
> Upgrade to 7.01?

Yep, it's precisely what I've done today. Upgraded to 7.0.3-2, and
everything runs OK. But why does it depends on libc 2.2 and perl 5.6 ?
It seems to me that a plain old libc 2.1 and perl 5.5 would have been
quite enough.

--
Christophe Devine

On Wed, 13 Dec 2000, Christophe Devine wrote:

> > Upgrade to 7.01?
>
> Yep, it's precisely what I've done today. Upgraded to 7.0.3-2, and
> everything runs OK. But why does it depends on libc 2.2 and perl 5.6 ?
> It seems to me that a plain old libc 2.1 and perl 5.5 would have been
> quite enough.

Did you install as binaries from packages or as source?  If you installed
via .deb packages, they put in the dependencies most likely because that's
what they built the binaries against.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
It's the RINSE CYCLE!!  They've ALL IGNORED the RINSE CYCLE!!