Re: [HACKERS] docs on tsearch2

2004-03-03 Thread Oleg Bartunov
Check http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ Oleg On Wed, 3 Mar 2004, [gb2312] wrote: hi all Are there any other docs about tsearch2 except for the 3 docs in \contrib\tsearch2\docs i want some tech docs on tsearch2 thank all---(end of

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-03 Thread Claudio Natoli
Gavin Sherry wrote: I'm going to focus on implementing this on the system(s) I'm used to developing on (ie, those which support symlinks). Once that is done, I'll talk with the Win32 guys about what, if anything, we can do about getting this to work on Win32 (and possibly other non-symlink

Re: [HACKERS] Tablespaces

2004-03-03 Thread Claudio Natoli
Bruce Momjian writes: I just checked from the MinGW console and I see: [snip] It accepts ln -s, but does nothing with it. And even if it had worked, it wouldn't really matter, since we don't actually want to *run* the system under MinGW/msys, just build it. I think the idea of implementing

Re: [HACKERS] log_line_info

2004-03-03 Thread Andrew Dunstan
Bruce Momjian said: Andrew Dunstan wrote: I haven't had any other feedback on this patch that I posted. However, I'm a bit dissatisfied with it for a couple of reasons: . when a connection is logged we don't yet know the user and database, because we haven't processed the initial packet

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-03 Thread Zeugswetter Andreas SB SD
For tablespaces on OS's that don't support it, I think we will have to store the path name in the file and read it via the backend. Somehow we should cache those lookups. My feeling is that we need not support tablespaces on OS's without symlinks. To create symlinked directories

Re: [HACKERS] Tablespaces

2004-03-03 Thread Oliver Elphick
On Wed, 2004-03-03 at 04:59, Tom Lane wrote: What might make sense is some sort of marker file in a tablespace directory that links back to the owning $PGDATA directory. CREATE TABLESPACE should create this, or reject if it already exists. It will not be enough for the marker to list the

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-03 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: My feeling is that we need not support tablespaces on OS's without symlinks. Agreed, but are we going to support non-tablespace installs? I wasn't sure that was an option. A setup containing only the default

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-03 Thread Bruce Momjian
Claudio Natoli wrote: Bruce Momjian writes: I just checked from the MinGW console and I see: [snip] It accepts ln -s, but does nothing with it. And even if it had worked, it wouldn't really matter, since we don't actually want to *run* the system under MinGW/msys, just build it. I

Re: [HACKERS] Thread safe connection-name mapping in ECPG. Is it

2004-03-03 Thread Bruce Momjian
Should I add this to the TODO list? --- Lee Kindness wrote: Sort of related, I was thinking about adding some more thread-related code such that if a connection wasn't explicitely specified then the last connection SET

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-03 Thread Magnus Hagander
I just checked from the MinGW console and I see: [snip] It accepts ln -s, but does nothing with it. And even if it had worked, it wouldn't really matter, since we don't actually want to *run* the system under MinGW/msys, just build it. I think the idea of implementing in

Re: [HACKERS] Thread safe connection-name mapping in ECPG. Is it

2004-03-03 Thread Shridhar Daithankar
Oh.. By all means..Please do.. The reason I posted it because I didn't wanted to work on it if core is not going to accept it on account of non-compliance with spec. Is this fine? * Allow a 'connection *' pointer to be specified instead of a string to denote a connection. I plan to work on

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-03 Thread Tom Lane
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: My feeling is that we need not support tablespaces on OS's without symlinks. To create symlinked directories on Win2k NTFS see: http://www.sysinternals.com/ntw2k/source/misc.shtml#junction I think Win2000 or XP would be a reasonable

Re: [HACKERS] Tablespaces

2004-03-03 Thread Tom Lane
Oliver Elphick [EMAIL PROTECTED] writes: It will not be enough for the marker to list the path of the parent $PGDATA, since that path might get changed by system administration action. The marker should contain some sort of unique string which would match the same string somewhere in $PGDATA.

Re: [HACKERS] Thread safe connection-name mapping in ECPG. Is it

2004-03-03 Thread Tom Lane
Shridhar Daithankar [EMAIL PROTECTED] writes: The reason I posted it because I didn't wanted to work on it if core is not going to accept it on account of non-compliance with spec. When it comes to ecpg, Michael Meskes is the man you have to convince, not any of the core committee.

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-03 Thread Andrew Dunstan
Zeugswetter Andreas SB SD wrote: To create symlinked directories on Win2k NTFS see: http://www.sysinternals.com/ntw2k/source/misc.shtml#junction I don't think we could use this s/w though, unless the author is prepared to relicense it. I'm sure implementing a clean room version of

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-03 Thread Magnus Hagander
To create symlinked directories on Win2k NTFS see: http://www.sysinternals.com/ntw2k/source/misc.shtml#junction I don't think we could use this s/w though, unless the author is prepared to relicense it. I'm sure implementing a clean room version of the relevant parts

[HACKERS] Client side copy functionality

2004-03-03 Thread Jan Wieck
Tom, with the since 7.4 deprecated copy support functions in libpq, is there any define or other way to figure out if compiling against a pre-7.4 or post-7.4 libpq? Jan -- #==# # It's easier to get forgiveness for being wrong

Re: [HACKERS] Client side copy functionality

2004-03-03 Thread Tom Lane
Jan Wieck [EMAIL PROTECTED] writes: with the since 7.4 deprecated copy support functions in libpq, is there any define or other way to figure out if compiling against a pre-7.4 or post-7.4 libpq? Hm, don't think so. If you've autoconfiscated your client code, you can just put in a configure

Re: [HACKERS] Tablespaces

2004-03-03 Thread Greg Stark
Bruce Momjian [EMAIL PROTECTED] writes: Greg Stark wrote: I am expecting to hear some bleating about this from people whose preferred platforms don't support symlinks ;-). However, if we don't Well, one option would be to have the low level filesystem storage (md.c?) routines

Re: [HACKERS] Thread safe connection-name mapping in ECPG. Is it

2004-03-03 Thread Bruce Momjian
Tom Lane wrote: Shridhar Daithankar [EMAIL PROTECTED] writes: The reason I posted it because I didn't wanted to work on it if core is not going to accept it on account of non-compliance with spec. When it comes to ecpg, Michael Meskes is the man you have to convince, not any of the core

Re: [HACKERS] log_line_info

2004-03-03 Thread Bruce Momjian
Andrew Dunstan wrote: defaulting to the beginning if not found. Examples: %T [%P]: (everybody gets timestamp and pid) %T [%P]: [EMAIL PROTECTED](%C:%S %I line:%L %X%T [%P]: (same effect as example under previous point) - something else I haven't

Re: [HACKERS] Tablespaces

2004-03-03 Thread Bruce Momjian
Greg Stark wrote: Bruce Momjian [EMAIL PROTECTED] writes: Greg Stark wrote: I am expecting to hear some bleating about this from people whose preferred platforms don't support symlinks ;-). However, if we don't Well, one option would be to have the low level filesystem

Re: [HACKERS] Tablespaces

2004-03-03 Thread Barry Lind
Oliver Elphick wrote: On Wed, 2004-03-03 at 04:59, Tom Lane wrote: What might make sense is some sort of marker file in a tablespace directory that links back to the owning $PGDATA directory. CREATE TABLESPACE should create this, or reject if it already exists. It will not be enough for the

Re: [pgsql-hackers-win32] [HACKERS] What's left?

2004-03-03 Thread Greg Stark
Jan Wieck [EMAIL PROTECTED] writes: the point is that PostgreSQL is no GNU product, never has been and if someone intends to he shall do so after yanking out the contributions I made. Note that when you released your contributions you did so under a license that imposed no such conditions. If

Re: [pgsql-hackers-win32] [HACKERS] What's left?

2004-03-03 Thread Merlin Moncure
Greg Stark wrote: imposed no such conditions. If Microsoft wanted to release a Microsoft Postgresql under a completely proprietary license they would be free to do I have often wondered, in a completely off-topic and unproductive sort of way, if exactly that has not already been done by an

Re: [pgsql-hackers-win32] [HACKERS] What's left?

2004-03-03 Thread Ken Hirsch
Merlin Moncure [EMAIL PROTECTED] wrote: Greg Stark wrote: imposed no such conditions. If Microsoft wanted to release a Microsoft Postgresql under a completely proprietary license they would be free to do I have often wondered, in a completely off-topic and unproductive sort of way, if exactly

Re: [HACKERS] Out of space situation and WAL log pre-allocation (was Tablespaces)

2004-03-03 Thread Simon Riggs
Tom Lane [mailto:[EMAIL PROTECTED] Joe Conway [EMAIL PROTECTED] writes: Tom Lane wrote: Joe Conway [EMAIL PROTECTED] writes: Maybe specify an archive location (that of course could be on a separate partition) that the external archiver should check in addition to the normal WAL

[HACKERS] The Return of PITR

2004-03-03 Thread Simon Riggs
In the last few days, a number of issues have come up on [HACKERS] and [PERFORM] that have made important contribs to the PITR topic. Moreover, work such as tablespaces has sufficient cross-over with PITR to make it important to double post things, which defeats the object of having a separate

Re: [HACKERS] Out of space situation and WAL log pre-allocation (was Tablespaces)

2004-03-03 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Simon Riggs wrote: O... and other dbms will freeze when this situation is hit, rather than continue and drop archive logs.] Been there, done that, don't see how it's any better. I hesitate to be real specific here, but let's just say the end result was

Re: [pgsql-hackers-win32] [HACKERS] What's left?

2004-03-03 Thread Dann Corbit
-Original Message- From: Merlin Moncure [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 12:28 PM To: Greg Stark Cc: [EMAIL PROTECTED] Subject: Re: [pgsql-hackers-win32] [HACKERS] What's left? Greg Stark wrote: imposed no such conditions. If Microsoft wanted to

Re: [HACKERS] Out of space situation and WAL log pre-allocation (was

2004-03-03 Thread Bruce Momjian
Simon Riggs wrote: User-selectable behaviour? OK. That's how we deal with fsync; I can relate to that. That hadn't been part of my thinking because of the importance I'd attached to the log files themselves, but I can go with that, if that's what was meant. So, if we had a parameter called

Re: [HACKERS] Out of space situation and WAL log pre-allocation (was

2004-03-03 Thread Joe Conway
Simon Riggs wrote: Tom Lane [mailto:[EMAIL PROTECTED] That should be user-scriptable policy, in my worldview. O... and other dbms will freeze when this situation is hit, rather than continue and drop archive logs.] Been there, done that, don't see how it's any better. I hesitate to be real

Re: [HACKERS] Thread safe connection-name mapping in ECPG. Is it

2004-03-03 Thread Lee Kindness
Shridhar, want to discuss this off list a bit to work through the various options and then revent back to the list with a suitable to-do (for discussion)? L. - Original Message - From: Shridhar Daithankar [EMAIL PROTECTED] To: Bruce Momjian [EMAIL PROTECTED] Cc: PostgreSQL-development

Re: [HACKERS] Prepared queries and portals

2004-03-03 Thread Tom Lane
Cyril VELTER [EMAIL PROTECTED] writes: so I've modified libpq to handle the case by adding to functions : PQexecPreparedPortal(conn,stmtName,portalName,nParams,paramValues,paramlengt h,paramFormats,resultFormat,maxrows); and PQfetchPortal(conn,portalName,maxrows)

Re: [HACKERS] Slony-I makes progress

2004-03-03 Thread Alex J. Avriette
On Wed, Mar 03, 2004 at 04:57:28PM -0500, Jan Wieck wrote: After some substantial progress on the Slony-I engine development, I'd like to give a little status report and invite everyone who wants to participate in this project to join the mailing list and the development team. Jan, thank

Re: [HACKERS] Tablespaces

2004-03-03 Thread Thomas Swan
Bruce Momjian wrote: Greg Stark wrote: Bruce Momjian [EMAIL PROTECTED] writes: Greg Stark wrote: I am expecting to hear some bleating about this from people whose preferred platforms don't support symlinks ;-). However, if we don't Well, one option would be to

Re: [HACKERS] Tablespaces

2004-03-03 Thread Bruce Momjian
Thomas Swan wrote: The advantage of symlinks is that an administrator could see how things are laid out from the command line. That's a poor reason to require symlinks. The administrator can just as easily open up psql and query pg_tablespace to see that same information. Besides,

[HACKERS] 7.4.2 branding

2004-03-03 Thread Bruce Momjian
I have caught up on my email and am working on the 7.4.2 branding now. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.|

Re: [HACKERS] Comments on patch for date_trunc( 'week', ... );

2004-03-03 Thread Robert Creager
Hey Bruce, I never saw the patch hit the hackers list. Did any of you smart folks take a look at it? Cheers, Rob When grilled further on (Wed, 3 Mar 2004 13:58:02 -0500 (EST)), Bruce Momjian [EMAIL PROTECTED] confessed: Your patch has been added to the PostgreSQL unapplied patches list

Re: [HACKERS] Comments on patch for date_trunc( 'week', ... );

2004-03-03 Thread Bruce Momjian
Well, it must have hit the lists if I have put it in the patch queue, no? --- Hey Bruce, I never saw the patch hit the hackers list. Did any of you smart folks take a look at it? Cheers, Rob When grilled further on

Re: [HACKERS] Slony-I makes progress

2004-03-03 Thread Jan Wieck
Followup-To: Slony1-general ML Alex J. Avriette wrote: On Wed, Mar 03, 2004 at 04:57:28PM -0500, Jan Wieck wrote: After some substantial progress on the Slony-I engine development, I'd like to give a little status report and invite everyone who wants to participate in this project to join the

Re: [HACKERS] 7.4.2 branding

2004-03-03 Thread Matthew T. O'Connor
On Wednesday 03 March 2004 10:11 pm, Bruce Momjian wrote: I have caught up on my email and am working on the 7.4.2 branding now. Ack is it too late to submit a patch to fix the int overflow problem with pg_autovacuum? I'll send a patch to the patches list shortly, hopefully it will get

Re: [HACKERS] 7.4.2 branding

2004-03-03 Thread Marc G. Fournier
On Wed, 3 Mar 2004, Bruce Momjian wrote: I have caught up on my email and am working on the 7.4.2 branding now. Just as a reminder, before ppl panic ... we are aiming for Monday for a 7.4.2 release ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email:

Re: [HACKERS] 7.4.2 branding

2004-03-03 Thread Tom Lane
Matthew T. O'Connor [EMAIL PROTECTED] writes: Ack is it too late to submit a patch to fix the int overflow problem with pg_autovacuum? No; we're not planning to wrap 7.4.2 till (probably) Sunday. If you can get the patch in within the next day or so, we can include it. I thought we'd

Re: [HACKERS] 7.4.2 branding

2004-03-03 Thread Matthew T. O'Connor
On Thursday 04 March 2004 12:04 am, Tom Lane wrote: I thought we'd fixed that problem already though. Is there another? Don't know if it's another, but the problem posted by Cott Lang on 1/17 ( http://archives.postgresql.org/pgsql-bugs/2004-01/msg00111.php ) has not been resolved.

Re: [HACKERS] Tablespaces

2004-03-03 Thread Thomas Swan
Tom Lane wrote: Thomas Swan [EMAIL PROTECTED] writes: Bruce Momjian wrote: The advantage of symlinks is that an administrator could see how things are laid out from the command line. That's a poor reason to require symlinks. The administrator can just as easily open up psql

Re: [HACKERS] Thread safe connection-name mapping in ECPG. Is it

2004-03-03 Thread Shridhar Daithankar
Lee Kindness wrote: Shridhar, want to discuss this off list a bit to work through the various options and then revent back to the list with a suitable to-do (for discussion)? I don't mind. Just for summary, I am listing the discussion/proposal so far on this issue.. - Dispose names of

Re: [HACKERS] Out of space situation and WAL log pre-allocation (was

2004-03-03 Thread Shridhar Daithankar
Tom Lane wrote: I think also that Simon completely misunderstood my intent in saying that this could be user-scriptable policy. By that I meant that the *user* could write the code to behave whichever way he liked. Not that we were going to go into a mad rush of feature invention and try to

[HACKERS] Regression tests on Nintendo Game Cube

2004-03-03 Thread Hans-Jürgen Schönig
Folks, Today Michael Steil and I have tested PostgreSQL 7.4.1 on Nintendo Game Cubes. All regression test (but stats - stats collector was off instead of on) have passed successfully. [EMAIL PROTECTED] root]# uname -a Linux 192.168.0.47 2.6.3 #20 Wed Mar 3 12:22:07 CET 2004 ppc unknown

Re: [HACKERS] [PERFORM] WAL Optimisation - configuration and usage

2004-03-03 Thread Simon Riggs
Neil Conway Simon Riggs wrote: Josh Berkus wrote Simon Riggs wrote Please set WAL_DEBUG to 1 so we can see a bit more info: thanks. I'm pretty sure that WAL_DEBUG requires a compile-time option. I'm surprised, but you are right, the manual does SAY this requires a compile time

Re: [HACKERS] [PERFORM] WAL Optimisation - configuration and usage

2004-03-03 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: The behaviour I wish to add is: Keep wal_debug as a value between 0 and 16. If =0 then no debug output (default). Use following bitmasks against the value Mask 1 = XLOG Checkpoints get logged Mask 2 = Archive API calls get logged Mask 4 = Transaction -

Re: [HACKERS] [PERFORM] WAL Optimisation - configuration and usage

2004-03-03 Thread Neil Conway
Simon Riggs wrote: On the other hand, I was just about to change the wal_debug behaviour to allow better debugging of PITR features as they're added. That's a development activity. Enabling the WAL_DEBUG #ifdef by default during the 7.5 development cycle would be uncontroversial, I think. I

[HACKERS] Slony-I makes progress

2004-03-03 Thread Jan Wieck
After some substantial progress on the Slony-I engine development, I'd like to give a little status report and invite everyone who wants to participate in this project to join the mailing list and the development team. The project homepage is here: