[HACKERS] zero-column table behavior

2004-05-22 Thread Neil Conway
Does the following zero-column behavior strike anyone else as being a little strange? I can take a look at fixing this, I'm just curious if there's a consensus that the status quo isn't optimal. (1) neilc=# create table zero_col (); CREATE TABLE neilc=# select * from zero_col; -- (0 rows) -- Why

[HACKERS] New horology failure

2004-05-22 Thread Christopher Kings-Lynne
I get this since Tom's commit. Chris --- ./results/horology.out Sun May 23 11:39:49 2004 *** *** 1787,1796 | Wed Mar 15 13:14:02 2000 PST | @ 34 years| Tue Mar 15 13:14:02 1966 PST | Sun Dec 31 17:32:01 2000 PST | @ 34 years

Re: [HACKERS] CVS HEAD: "make install" broken for vpath

2004-05-22 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > With current sources, it appears that vpath builds (i.e. separate source > and build trees) are broken. "make" succeeds, but "make install" produces: I can't take the time right now to test it, but try changing TZDATAFILES := $(TZDATA:%=data/%) to TZDATAF

Re: [HACKERS] Call for 7.5 feature completion

2004-05-22 Thread Gaetano Mendola
David Garamond wrote: Robert Treat wrote: Given that the cygwin version is currently labeled as not ready for production I would say you are right. The truth is that many will never declare win32 good for production simply because of the OS it runs on, but we still want to make it as solid as possi

Re: [HACKERS] Call for 7.5 feature completion

2004-05-22 Thread David Garamond
Robert Treat wrote: Given that the cygwin version is currently labeled as not ready for production I would say you are right. The truth is that many will never declare win32 good for production simply because of the OS it runs on, but we still want to make it as solid as possible. People _do_ use p

[HACKERS] CVS HEAD: "make install" broken for vpath

2004-05-22 Thread Neil Conway
With current sources, it appears that vpath builds (i.e. separate source and build trees) are broken. "make" succeeds, but "make install" produces: [neilc:/Users/neilc/build-pgsql]% make install make -C doc install make[1]: Nothing to be done for `install'. make -C src install make -C port instal

Re: [HACKERS] add server include files to default installation?

2004-05-22 Thread Fabien COELHO
Dear Tom, > > Agreed. If we are pushing things out, it seems it is our duty to make > > it easy for outside things to integrate and build properly. > > It does not thereby follow that we should try to merge devel and base > packages (to express it in RPM terms). They are not necessarily merged,

Re: [HACKERS] postgresql extension API proof of concept

2004-05-22 Thread Fabien COELHO
Dear Carl, > What is the purpose of the extension api in simple terms; what is it FOR? > What does it DO? Thanks for this perfectly legitimate question, as my mail was not very easy to understand without the context. The aim is to provide a compilation infrastructure to external modules (that i

[HACKERS] pg_autovacuum fixes

2004-05-22 Thread Matthew T. O'Connor
This weekend I am trying to fix up all known the pg_autovacuum issues that should be resolved for 7.4.3. I am aware of only two issues: temp table issues, and unchecked send_query() calls, if I am forgetting something, please let me know. 1) temp table issue: I was not able to reproduce the cr

Re: [HACKERS] Database variables when copying a database

2004-05-22 Thread Christopher Kings-Lynne
Anyone thought about this at all yet? Is it possible to have per-database variables that refer to the current database in someway that would need to be altered to refer to the new db? Chris Christopher Kings-Lynne wrote: Hi, When you do this: CREATE DATABASE test TEMPLATE master; It doesn't cop