RE: [HACKERS] 6.5.1 status - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: [HACKERS] 6.5.1 status
Date
Msg-id 000e01bec361$c4e15ba0$2801007e@cadzone.tpf.co.jp
Whole thread Raw
In response to Re: [HACKERS] 6.5.1 status  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
>
> > Neither of these two can be added to version 6.5.1...the minor releases
> > are meant to be 'non-dump/initdb, bug fix only' releases, and, at least
> > for number 1, adding a numeric_ops would require a dump/reload ...
>

I see.

> This could be done as a contrib package for the v6.5.x series. Are you
> interested in doing this?
>

Hmmm,I don't know the right way to do so.

AFAIC it is necessary to insert new OID entries into pg_opclass.h and
pg_amproc.h . Is it right ?  And is it all ?
If so,I would try.
BTW how do I get new System OID ?

> > As for the TRUNCATE, take a look at the oracle_compat.c file in util/adt
> > and supply a patch that will add the appropriate functionality, and I
> > don't see why it can't b eadded fo r6.6 ...
>
> If TRUNCATE is some "stringy function thing", then that is the place
> to look. Isn't it some table deletion short-circuit capability
> though?? If so, it is not as trivial...
>

TRUNCATE statement deletes all rows of the target table quickly and
could not be rollbacked.
Marcus Mascari [mascarim@yahoo.com] posted a patch today.
At first glance his story seems right,though it needs more checking.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp




pgsql-hackers by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] RE: [GENERAL] urgent: problems with query_limit
Next
From: Michael Robinson
Date:
Subject: Re: [HACKERS] regression bigtest needs very long time