Re: [PATCHES] plpython improvements

2006-06-16 Thread Sven
Quoting Bruce Momjian : > > Added to TODO: > >o Allow PL/python to composite types and result sets > once buggy assert-enabled versions of python can be detected I actually tried to work other way around -- get all known buggy systems fixed: 1) Debugging Python version:

Re: [PATCHES] table/index fillfactor control, try 2

2006-06-16 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Fri, 2006-06-16 at 13:33 +0900, ITAGAKI Takahiro wrote: >> 2. Store the structures in AM's meta page. But heaps don't have meta pages. > But perhaps they should? That sounds very similar to the idea of > non-transactional pg_class data. The disadvantag

Re: [PATCHES] plpython improvements

2006-06-16 Thread Bruce Momjian
Added to TODO: o Allow PL/python to composite types and result sets once buggy assert-enabled versions of python can be detected http://archives.postgresql.org/pgsql-patches/2006-04/msg00087$ ---

Re: [PATCHES] [GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-16 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Should pg_dumpall be using the "SET default_tablespace = foo" method as > > well? > > That would mean changing the semantics of CREATE DATABASE; currently it > copies the default tablespace from the template database, rather than > looking at default_ta

Re: [PATCHES] [BUGS] [Win32] Problem with rename()

2006-06-16 Thread Bruce Momjian
Peter Brant wrote: > Really? If there was a patch, I missed it. > > My recollection is that there was general agreement about this > particular problem (see, for example, > http://archives.postgresql.org/pgsql-bugs/2006-04/msg00189.php ), but > things kind of trailed off after that without a reso

Re: [PATCHES] [BUGS] [Win32] Problem with rename()

2006-06-16 Thread Peter Brant
Really? If there was a patch, I missed it. My recollection is that there was general agreement about this particular problem (see, for example, http://archives.postgresql.org/pgsql-bugs/2006-04/msg00189.php ), but things kind of trailed off after that without a resolution. As far as the complete

Re: [PATCHES] drop if exists remnainder (reprise)

2006-06-16 Thread Andrew Dunstan
Andrew Dunstan wrote: Here is an updated patch for the remaining cases of DROP objtype IF EXISTS ... as recently discussed on -hackers. The cases are: language, tablespace, trigger, rule, opclass, function, aggregate. operator, and cast. Regression tests and docs still to come. I was

Re: [PATCHES] table/index fillfactor control, try 2

2006-06-16 Thread Simon Riggs
On Fri, 2006-06-16 at 13:33 +0900, ITAGAKI Takahiro wrote: > This is a revised fillfactor patch. It uses WITH syntax and > we can add new AM specific parameters easily. Cool. I'll look at that in more detail. > > So we have a new element of the RelationData struct: > > void*rd_amopts; > >

Re: [PATCHES] [BUGS] [Win32] Problem with rename()

2006-06-16 Thread Bruce Momjian
I am assuming this problem and the other rash of Win32 problems reported in March are now all fixed in 8.1.4. If not, please let me know. --- Tom Lane wrote: > I wrote: > > "Peter Brant" <[EMAIL PROTECTED]> writes: > >> Doe

Re: [PATCHES] TupleDesc refcounting

2006-06-16 Thread Tom Lane
I wrote: > I'm finally getting back to looking at the problem of reference-counting > cached TupleDescs as was discussed in January. I had objected to the > last patch Neil posted: > http://archives.postgresql.org/pgsql-patches/2006-01/msg00243.php > on the grounds that it seemed too complicated.

Re: [PATCHES] [HACKERS] Automatic free space map filling

2006-06-16 Thread Bruce Momjian
Added to TODO list with URL. --- ITAGAKI Takahiro wrote: > "Zeugswetter Andreas DCP SD" <[EMAIL PROTECTED]> wrote: > > > Ok, we cannot reuse a dead tuple. Maybe we can reuse the space of a dead > > tuple by reducing the tup

Re: [PATCHES] CREATE TABLE LIKE INCLUDING CONSTRAINTS

2006-06-16 Thread Greg Stark
Greg Stark <[EMAIL PROTECTED]> writes: > > This patch implements an option to copy check constraints when using LIKE. Ah, found a problem. I need to do a change_varattnos_of_a_node() call here. Should this function maybe be promoted to some other file like ruleutils.c? -- greg --

Re: [PATCHES] plpython tracebacks

2006-06-16 Thread Bruce Momjian
URL added to TODO list. --- Neil Conway wrote: > P. Scott DeVos wrote: > > I'm on it. > > Actually, don't worry about it -- I've made the corrections I had in > mind myself. Attached is a revised patch. On looking closer,

Re: [PATCHES] patch fixing the old RETURN NEXT bug

2006-06-16 Thread Bruce Momjian
Added to TODO: o Fix problems with RETURN NEXT on tables with dropped/added columns after function creation http://archives.postgresql.org/pgsql-patches/2006-02/msg00165$ --- Sergey E. Koposov wr

Re: [PATCHES] CREATE TABLE LIKE INCLUDING CONSTRAINTS

2006-06-16 Thread Greg Stark
Fixed the bug, added docs and tests. like.patch3 Description: Binary data The previous message explaining the patch: Greg Stark <[EMAIL PROTECTED]> writes: > This patch implements an option to copy check constraints when using LIKE. > Because the standard specifically excludes constraints

[PATCHES] CREATE TABLE LIKE INCLUDING CONSTRAINTS

2006-06-16 Thread Greg Stark
I just managed to crash the server so I guess this isn't finished, but I'm posting it in the "post early post often" spirit. Aside from error checks it also needs docs and tests of course. This patch implements an option to copy check constraints when using LIKE. Because the standard specificall