Re: Re: [HACKERS] Postgresql OO Patch - Mailing list pgsql-general

From Mike Mascari
Subject Re: Re: [HACKERS] Postgresql OO Patch
Date
Msg-id 39290818.CF17D125@mascari.com
Whole thread Raw
In response to Re: [HACKERS] Postgresql OO Patch  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Chris Bitmead wrote:
>
> While SQL3 talks about trees and leaf rows, it's not implemented like
> that, so all this worrying about digging down trees and leafs is all a
> bit mute.

Moot. ;-)

At a minimum, it seems to me, the backend must support the
concept of multiple tuples with different attributes at the
relation level since concurrency and rollback-ability of ALTER
TABLE ADD COLUMN will cause two concurrent transactions to see a
single relation with different attributes. It doesn't seem a
large leap to support this concept for OO purposes from "leaf" to
"base". For "base" to "leaf" type queries, wouldn't it be
acceptable to return the base attributes only, as long as the
equivalent of run-time type information could be had from the
OID?

Just curious,

Mike Mascari

pgsql-general by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] Postgresql OO Patch
Next
From: Chris Bitmead
Date:
Subject: Re: Re: [HACKERS] Postgresql OO Patch