Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Re: [HACKERS] changes in 6.4

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Hannu Krosing <hannu(at)trust(dot)ee>
Cc: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, pgsql-interfaces(at)postgreSQL(dot)org, hackers(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Date: 1998-07-15 20:25:44
Message-ID: 35AD1048.97441728@krs.ru (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-interfaces
Hannu Krosing wrote:
> 
> Not requiring the column to sort on in target list ia also quite
> important.

I'm not sure but isn't this already in 6.4-current ?

> 
> As are the (still elementary) constraints, still elementary becuse
> there is no way to use functions or "is null" in check constraint,

ispas=> create table t (x int, check (x is null or x = 5));
CREATE
ispas=> insert into t values (1);
ERROR:  ExecAppend: rejected due to CHECK constraint $1
ispas=> insert into t values (null);
INSERT 168212 1
ispas=> insert into t values (5);
INSERT 168213 1

And I'm sure that functions are supported too. This is 6.3.2

> and constraints can be used only when defining tables, not in
> "alter table" construct.

I hadn't time to do this when implementing and have no plans
to do this. In "near" future :)

> 
> > The days where every release fixed server crashes, or added a feature
> > that users were 'screaming for' may be a thing of the past.
> 
> Is anyone working on fixing the exploding optimisations for many OR-s,
> at least the canonic case used by access?
> 
> My impression is that this has fallen somewhere between
> insightdist and Vadim.

I'm not working...

Vadim

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-07-15 20:39:39
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Previous:From: Bruce MomjianDate: 1998-07-15 20:23:47
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4

pgsql-interfaces by date

Next:From: Bruce MomjianDate: 1998-07-15 20:39:39
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Previous:From: Bruce MomjianDate: 1998-07-15 20:23:47
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4

pgsql-general by date

Next:From: Bruce MomjianDate: 1998-07-15 20:39:39
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Previous:From: Bruce MomjianDate: 1998-07-15 20:23:47
Subject: Re: [INTERFACES] Re: [HACKERS] changes in 6.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group