Re: Backend-internal SPI operations

Lists: pgsql-hackers
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Jan Wieck <janwieck(at)Yahoo(dot)com>, Mark Hollomon <mhh(at)nortelnetworks(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Backend-internal SPI operations
Date: 2000-09-01 13:28:05
Message-ID: 16289.967814885@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> then it becomes
> SELECT * FROM (SELECT a, b, c FROM my_table);
> which would presumably be possible with the new query-tree.

Right, that's exactly how we've been planning to fix the problems
with grouped views and so forth.

I am beginning to think that this may have to happen for 7.1, else
view inside ISO-style JOIN constructs aren't going to work right.
Further news as it happens...

regards, tom lane


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <janwieck(at)Yahoo(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Mark Hollomon <mhh(at)nortelnetworks(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Backend-internal SPI operations
Date: 2000-09-01 22:02:45
Message-ID: 29314.967845765@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Jan Wieck <janwieck(at)Yahoo(dot)com> writes:
> I suggest let's get what we have out of the door now and
> don't work under pressure on these complex things.

Pressure? I've got a month, I thought. Should be plenty of time.

regards, tom lane


From: Jan Wieck <janwieck(at)Yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Jan Wieck <janwieck(at)Yahoo(dot)com>, Mark Hollomon <mhh(at)nortelnetworks(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Backend-internal SPI operations
Date: 2000-09-01 22:21:24
Message-ID: 200009012221.RAA19767@jupiter.jw.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > then it becomes
> > SELECT * FROM (SELECT a, b, c FROM my_table);
> > which would presumably be possible with the new query-tree.
>
> Right, that's exactly how we've been planning to fix the problems
> with grouped views and so forth.
>
> I am beginning to think that this may have to happen for 7.1, else
> view inside ISO-style JOIN constructs aren't going to work right.
> Further news as it happens...

You really want to start on that NOW?

I suggest let's get what we have out of the door now and
don't work under pressure on these complex things.

Jan

--

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