Re: [PATCHES] [HACKERS] large object regression tests

2006-10-14 Thread Bruce Momjian
Sorry, please disregard. Was means for a Japanese FAQ update. --- Bruce Momjian wrote: > > Patch applied. Thanks. > > --- > > > Jeremy Drake wrote

Re: [PATCHES] [HACKERS] large object regression tests

2006-10-14 Thread Bruce Momjian
Patch applied. Thanks. --- Jeremy Drake wrote: > On Sun, 24 Sep 2006, Jeremy Drake wrote: > > > On Thu, 21 Sep 2006, Tom Lane wrote: > > > > > I think we could do without the Moby Dick extract too ... > > > > I am open to

Re: [HACKERS] [BUGS] BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

2006-10-14 Thread Tom Lane
"Vitali Stupin" <[EMAIL PROTECTED]> writes: > If database uses UTF8 encoding, then spi_exec_query in plperl should return > query results in UTF8 encoding. But unfortunately only data is marked as > UTF8, while column names are not. It looks to me like basically everywhere in plperl.c that does ne

Re: [HACKERS] Problems building 8.2beta1 on macos G5 xserve

2006-10-14 Thread Sean Davis
Tom Lane wrote: Sean Davis <[EMAIL PROTECTED]> writes: Trying to build 8.2beta1 on MacOS G5 Xserver, OS version 10.4.7. I got this: /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) file: -lSystem is not an object file (not allowed in a library) What Xcode version

Re: [HACKERS] Problems building 8.2beta1 on macos G5 xserve

2006-10-14 Thread Tom Lane
Sean Davis <[EMAIL PROTECTED]> writes: > Trying to build 8.2beta1 on MacOS G5 Xserver, OS version 10.4.7. I got > this: > /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) > file: -lSystem is not an object file (not allowed in a library) What Xcode version have you got? My

[HACKERS] Not quite there on timezone names in timestamp input

2006-10-14 Thread Tom Lane
This doesn't work: regression=# select '2006-07-13 09:20:00 EST5EDT'::timestamptz; ERROR: invalid input syntax for type timestamp with time zone: "2006-07-13 09:20:00 EST5EDT" It never has worked in the past, of course, but I expected it to work in HEAD seeing that the zic database includes EST

[HACKERS] Problems building 8.2beta1 on macos G5 xserve

2006-10-14 Thread Sean Davis
Trying to build 8.2beta1 on MacOS G5 Xserver, OS version 10.4.7. I got this: gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-aliasing -dynamiclib -install_name /usr/local/pgsql/lib/libpq.5.dylib -compatibility_version 5 -current_

Re: [HACKERS] [PATCHES] New shared memory hooks proposal (was Re: pre_load_libraries)

2006-10-14 Thread Tom Lane
Marc Munro <[EMAIL PROTECTED]> writes: > The attached patch provides add-ins with the means to register for > shared memory and LWLocks. I finally got around to reviewing this patch, and realized that it's got a pretty fundamental design flaw: it isn't useful under Windows (or any other EXEC_BACKE

Re: [HACKERS] query optimization with UDFs

2006-10-14 Thread Tom Lane
Markus Schaber <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> The trick is to figure out what a useful parameterized cost model would >> look like. IIRC, the main reason the xfunc code rotted on the vine was >> that its cost parameters didn't seem to be either easy to select or >> powerful in pr

Re: [HACKERS] query optimization with UDFs

2006-10-14 Thread Markus Schaber
Hi, Tom, Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: >> BTW, I think it would make sense to implement a limited subset of the >> xfunc ideas: add options to CREATE FUNCTION to allow cost information to >> be specified, and then take advantage of this information instead of >> using t

Re: [HACKERS] Interface of the R-tree in order to work with postgresql

2006-10-14 Thread Markus Schaber
Hi, Jorge, jorge alberto wrote: > I'm Jorge from Peru South America, and this is my first post > > I want to know how can I add a new spatial access method into the > postgresql (I'm doing research on spatial access methods( reading a lot > of papers and programming a lot too ) but also I want t