Re: [HACKERS] Request for supported platforms

2002-11-05 Thread Alessio Bragadini
On Tue, 2002-11-05 at 00:40, Bruce Momjian wrote: Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html Please note that you have an entry for Digital Unix and one for Compaq Tru64 while in fact they are the same OS that went through a whirlwind of

Re: [HACKERS] Float output formatting options

2002-11-05 Thread Pedro M. Ferreira
Pedro M. Ferreira wrote: Tom Lane wrote: Perhaps P_MAXLEN now needs to be (2*(DBL_DIG+2+7)+1), considering that we'll allow extra_float_digits to be up to 2. What's it used for? Yes. I guess so, because it is used in what I think is a memory allocation function. P_MAXLEN is only used twice:

Re: [HACKERS] [CYGWIN] command

2002-11-05 Thread Henshall, Stuart - Design Print
Title: RE: [CYGWIN] command Florian Litot wrote: what is the command to launch a sql script not in psql thanks psql is used to execute sql scripts as follows: psql -f filename database hth, - Stuart

Re: [HACKERS] a tiny question

2002-11-05 Thread Neil Conway
Luis Alberto Amigo Navarro [EMAIL PROTECTED] writes: When we improve seq scans, systems scales well up to 8 cpus.When we improve index scan, query performance increase but system stops scaling at about 4 proccessors, profiling shows that it is due to increased memory contention What do you

Re: [HACKERS] a tiny question

2002-11-05 Thread Luis Alberto Amigo Navarro
a guess it's said inter-locking, I mean data accessed exclusively. I apologize for my english - Original Message - From: Neil Conway [EMAIL PROTECTED] To: Luis Alberto Amigo Navarro [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 4:47 PM Subject: Re: [HACKERS] a

Re: [HACKERS] rebuilding beta4 ... fails in docs build ...

2002-11-05 Thread Marc G. Fournier
k, rebuuilding now On Mon, 4 Nov 2002, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: one too many things removed? Just broken SGML markup ... fixed I think ... regards, tom lane ---(end of

[HACKERS] New beta4 created ...

2002-11-05 Thread Marc G. Fournier
from looking at the sizes for the previous beta's, it *looks* right ... someone want to take a quick peak? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to

Re: [HACKERS] New beta4 created ...

2002-11-05 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: from looking at the sizes for the previous beta's, it *looks* right ... someone want to take a quick peak? The code seems right, and the postgres.tar.gz doc tarball seems right, but the man.tar.gz doc tarball seems out of date --- in fact it looks to

Re: [HACKERS] New beta4 created ...

2002-11-05 Thread Marc G. Fournier
On Tue, 5 Nov 2002, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: from looking at the sizes for the previous beta's, it *looks* right ... someone want to take a quick peak? The code seems right, and the postgres.tar.gz doc tarball seems right, but the man.tar.gz doc tarball

Re: [HACKERS] Test of PG7.3.2b2 on SGI Irix

2002-11-05 Thread Robert E. Bruccoleri
Dear Tom, All the regression tests pass except for tests involving Savings Time which are off by one hour. --Bob Details? If you ran it today then the DST-boundary problems shouldn't be there anymore. Here are the diffs: It looks like your files match the solaris-1947 variants;

Re: [HACKERS] Request for supported platforms

2002-11-05 Thread Dave Page
-Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 05 November 2002 03:18 To: Sean Chittenden Cc: Tom Lane; Larry Rosenman; PostgreSQL-development Subject: Re: [HACKERS] Request for supported platforms Ports list updated:

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Karel Zak
On Mon, Nov 04, 2002 at 07:22:54PM -0500, Neil Conway wrote: (1) Add an optional textual message to NOTIFY (2) Remove the hard-coded limits on database and user names (SM_USER, SM_DATABASE), replace them with variable-length fields. (3)

[HACKERS] The document

2002-11-05 Thread Jinqiang Han
Hello In the document of postgresql I always see such text '\ref{where_clause} '. But I wonder how can I see the graphics. In the DocBook software? Thank you in advance. Jinqiang Han

Re: [HACKERS] Another bug in tsearch?

2002-11-05 Thread Oleg Bartunov
On Tue, 5 Nov 2002, Christopher Kings-Lynne wrote: Hi Oleg Teodor, This behaviour is causing problems in my search engine: australia=# select 'banana/pineapple'::mquery_txt; mquery_txt 'banana/pineapple' (1 row) In our case the forward slash symbol should

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Maarten Boekhold
On 11/05/2002 04:42:55 AM Neil Conway wrote: Mike Mascari [EMAIL PROTECTED] writes: Is there any thought about changing the protocol to support two-phase commit? Not that 2PC and distributed transactions would be implemented in 7.4, but to prevent another protocol change in the future?

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Hannu Krosing
Satoshi Nagayasu kirjutas T, 05.11.2002 kell 08:05: Tom Lane wrote: I don't see why 2PC would require any protocol-level change. I would think that the API would be something like BEGIN; issue some commands ... PRECOMMIT; -- if the above does not return an error,

Re: [HACKERS] Is my Internet connection slow

2002-11-05 Thread Peter Eisentraut
'k, is there a reason why it can't be run more often? If you say it's OK then no. I've made it run every 15 minutes now. -- +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! ---(end of

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Satoshi Nagayasu
Hannu Krosing [EMAIL PROTECTED] wrote: I think a precommit-vote-commit phase of 2PC can be implemented in command-lavel or protocol-level. In command-level 2PC, an user application (or application programmer) must know the DBMS is clustered or not (to use PRECOMMIT command). In

Re: [HACKERS] Is my Internet connection slow

2002-11-05 Thread Bruce Momjian
Peter Eisentraut wrote: 'k, is there a reason why it can't be run more often? If you say it's OK then no. I've made it run every 15 minutes now. Will it run unconditionally or only on a CVS SGML change? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Ross J. Reedstrom
On Tue, Nov 05, 2002 at 08:54:46PM +0900, Satoshi Nagayasu wrote: Hannu Krosing [EMAIL PROTECTED] wrote: In protocol-layer 2PC, no new SQL command is required. A precommit-vote-commit phase will be called implicitly. It means an user application can be used without any

Re: [HACKERS] Is my Internet connection slow

2002-11-05 Thread Bruce Momjian
I have ordered 128k ISDN, to be installed on November 12th. I am too far for ADSL but I hope the distances will increase in the future. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive,

Re: [HACKERS] Request for supported platforms

2002-11-05 Thread Bruce Momjian
Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 05 November 2002 03:18 To: Sean Chittenden Cc: Tom Lane; Larry Rosenman; PostgreSQL-development Subject: Re: [HACKERS] Request for supported platforms Ports list

Re: [HACKERS] [GENERAL] PostgreSQL IRC Channel... who's the Admin?

2002-11-05 Thread Marc G. Fournier
*** Topic for #postgresql: 7.3Beta4 is now out, expect RC1 by the end of the week *** Topic for #postgresql set by DarcyB_ on Nov 4 17:54:40 Note that we are all on #EfNet servers ... On Tue, 5 Nov 2002, Justin Clift wrote: Hi all, Who's an Admin for the PostgreSQL IRC Channel

Re: [HACKERS] Request for supported platforms

2002-11-05 Thread Bruce Momjian
Yes, now it is Digital/HP/Compaq. Updated to existing Tru64 entry. Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Alessio Bragadini wrote: On Tue, 2002-11-05 at

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-05 Thread Peter Eisentraut
Tom Lane writes: I disagree: just because cygipc returns error codes chosen at random doesn't mean that we should neglect the clear meaning of an error code. If a normal Unix system were to return EACCES here, the clear implication would be that there is an existing segment that we do not

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Christof Petig
Neil Conway wrote: (6) Protocol-level support for prepared queries, in order to bypass the parser (and maybe be more compatible with the implementation of prepared queries in other databases). Let me add (6b) Protocol level support for query parameters. This

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Christof Petig
Christof Petig wrote: Neil Conway wrote: (6) Protocol-level support for prepared queries, in order to bypass the parser (and maybe be more compatible with the implementation of prepared queries in other databases). Let me add (6b)Protocol level support

Re: [HACKERS] Is my Internet connection slow

2002-11-05 Thread Peter Eisentraut
Bruce Momjian writes: 'k, is there a reason why it can't be run more often? If you say it's OK then no. I've made it run every 15 minutes now. Will it run unconditionally or only on a CVS SGML change? It will run when anything in CVS changes, which is something yours appears to get

Re: [HACKERS] v7.3Beta4 Tag'd and Packaged ...

2002-11-05 Thread Peter Eisentraut
Tom Lane writes: Right-o: HEAD is 7.4devel now ... Will someone merge the 7.3 branch into 7.4devel when the former is released? I don't feel like double-patching... -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have

Re: [HACKERS] Is my Internet connection slow

2002-11-05 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: 'k, is there a reason why it can't be run more often? If you say it's OK then no. I've made it run every 15 minutes now. Will it run unconditionally or only on a CVS SGML change? It will run when anything in CVS changes, which is

Re: [HACKERS] v7.3Beta4 Tag'd and Packaged ...

2002-11-05 Thread Marc G. Fournier
On Tue, 5 Nov 2002, Peter Eisentraut wrote: Tom Lane writes: Right-o: HEAD is 7.4devel now ... Will someone merge the 7.3 branch into 7.4devel when the former is released? I don't feel like double-patching... At this stage, there shouldn't be anything really going *into* STABLE, if we

Re: [HACKERS] Is my Internet connection slow

2002-11-05 Thread Bruce Momjian
Bruce Momjian wrote: Peter Eisentraut wrote: Bruce Momjian writes: 'k, is there a reason why it can't be run more often? If you say it's OK then no. I've made it run every 15 minutes now. Will it run unconditionally or only on a CVS SGML change? It will run when

Re: [HACKERS] v7.3Beta4 Tag'd and Packaged ...

2002-11-05 Thread Thomas Lockhart
... to pull in those changes that were made to the REL7_3_STABLE branch ... Right. But, if I did: cvs checkout -rREL7_3_STABLE pgsql What would I use as BRANCHNAME in the -j to 'pull in' the changes we made to HEAD? Or is there where I'm misunderstanding something? Use HEAD for the

Re: [HACKERS] [PORTS] openbsd 3.2, postgresql 7.3beta3 and openssl 'e_os.h' include

2002-11-05 Thread Bruce Momjian
Peter Galbavy wrote: According to the feedback I have had, e_os.h is no longer a public interface header file in OpenSSL. 'get_last_socket_error' is a macro that seems to expand to errno. Can I suggest someone with better understanding of the postgresql sources, and ssl support, please pick

Re: [HACKERS] Postgresql and multithreading

2002-11-05 Thread Bruce Momjian
I have updated the developers FAQ item 1.9 to address this: http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html+Developers-FAQ --- Anuradha Ratnaweera wrote: On Wed, Oct 16, 2002 at 01:51:28AM

Re: [HACKERS] PL/Perl and Perl 5.8

2002-11-05 Thread Bruce Momjian
Neil Conway wrote: Peter Eisentraut [EMAIL PROTECTED] writes: The HAS_CRYPT_R is true because the function is available even without the prototype, but the struct is not. A plain bug in Perl's configury mechanism. Yeah, that's true. The question is whether it's worth working around the

Re: [HACKERS] [GENERAL] What user to defaults execute as?

2002-11-05 Thread Peter Eisentraut
Tom Lane writes: Okay, I've thought of one: consider the situation where you want to label each row in a table with the ID of the user who inserted it. Right now, you can do ..., who namedefault current_user, ... or for greater security use a trigger to set the

Re: [HACKERS] v7.3Beta4 Tag'd and Packaged ...

2002-11-05 Thread Marc G. Fournier
On Tue, 5 Nov 2002, Thomas Lockhart wrote: ... to pull in those changes that were made to the REL7_3_STABLE branch ... Right. But, if I did: cvs checkout -rREL7_3_STABLE pgsql What would I use as BRANCHNAME in the -j to 'pull in' the changes we made to HEAD? Or is there

Re: [HACKERS] v7.3Beta4 Tag'd and Packaged ...

2002-11-05 Thread Peter Eisentraut
Marc G. Fournier writes: At this stage, there shouldn't be anything really going *into* STABLE, if we want to get to RC1 ... If we don't put anything into stable then we will never get to anything. Surely we still need to put in some fixes and documentation updates. -- Peter Eisentraut

Re: [HACKERS] v7.3Beta4 Tag'd and Packaged ...

2002-11-05 Thread Bruce Momjian
Peter Eisentraut wrote: Marc G. Fournier writes: At this stage, there shouldn't be anything really going *into* STABLE, if we want to get to RC1 ... If we don't put anything into stable then we will never get to anything. Surely we still need to put in some fixes and documentation

Re: [HACKERS] PL/Perl and Perl 5.8

2002-11-05 Thread Marcel Grünauer
On Dienstag, November 5, 2002, at 11:24 Uhr, Bruce Momjian wrote: Neil Conway wrote: Peter Eisentraut [EMAIL PROTECTED] writes: The HAS_CRYPT_R is true because the function is available even without the prototype, but the struct is not. A plain bug in Perl's configury mechanism. Yeah,

Re: [HACKERS] New beta4 created ...

2002-11-05 Thread Peter Eisentraut
Marc G. Fournier writes: We'll get this build right yet :) I'm copying the man.tar.gz that is in: cp /var/spool/ftp/pub/dev/doc/man.tar.gz .. The postgres.tar.gz that is in there appears to be good to 1hr ago, but you are right about the man.tar.gz ... Peter? I've uploaded a new one. --

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-05 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane writes: I disagree: just because cygipc returns error codes chosen at random doesn't mean that we should neglect the clear meaning of an error code. If a normal Unix system were to return EACCES here, the clear implication would be that

Re: [HACKERS] PL/Perl and Perl 5.8

2002-11-05 Thread Neil Conway
Bruce Momjian [EMAIL PROTECTED] writes: With no motion on this, I assume we are going to call this a perl bug and not work around it for 7.3. Erm, no -- Reinhard Max already sent a fix for this to -patches, Tom had an objection to it, and then Reinhard posted another version (which presumably

Re: [HACKERS] PL/Perl and Perl 5.8

2002-11-05 Thread Neil Conway
Marcel Grünauer [EMAIL PROTECTED] writes: I've only just subscribed to this list, so I don't know all of the discussion (given time, I'll look it up in the archives). But if you have found a perl bug, particularly one of configuration, I'm sure the perl developers would be grateful if you

Re: [HACKERS] PL/Perl and Perl 5.8

2002-11-05 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: Erm, no -- Reinhard Max already sent a fix for this to -patches, Tom had an objection to it, and then Reinhard posted another version (which presumably satisfies Tom's objections). Peter didn't like it ... which is about what I'd expected, but I was

Re: [HACKERS] [PORTS] openbsd 3.2, postgresql 7.3beta3 and openssl 'e_os.h' include

2002-11-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Peter Galbavy wrote: According to the feedback I have had, e_os.h is no longer a public interface header file in OpenSSL. 'get_last_socket_error' is a macro that seems to expand to errno. OK, I am using: #$ openssl OpenSSL version

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Satoshi Nagayasu
Ross J. Reedstrom [EMAIL PROTECTED] wrote: If application continues to use just BEGIN/COMMIT, then the protocol level must parse command stream and recognize COMMIT in order to replace it with PRECOMMIT, COMMIT. If the communication library has to do that anyway, it could still

[HACKERS] RC1 on Friday?

2002-11-05 Thread Bruce Momjian
Are we still on schedule for RC1 on Friday? -- 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.| Newtown Square, Pennsylvania

[HACKERS] Win32 port

2002-11-05 Thread Bruce Momjian
I have copies of Peer Direct's (Jan's company) port of PostgreSQL to Win32, and SRA's port to Win32, and permission to generate a merged patch that can be applied to 7.4. Now that 7.3 is almost complete, I am going to start work on that. I will post patches that deal with specific portability

Re: [HACKERS] Win32 port

2002-11-05 Thread Justin Clift
Bruce Momjian wrote: I have copies of Peer Direct's (Jan's company) port of PostgreSQL to Win32, and SRA's port to Win32, and permission to generate a merged patch that can be applied to 7.4. Now that 7.3 is almost complete, I am going to start work on that. I will post patches that deal

Re: [HACKERS] Win32 port

2002-11-05 Thread Matthew T. O'Connor
On Wed, 2002-11-06 at 01:32, Justin Clift wrote: Bruce Momjian wrote: I have copies of Peer Direct's (Jan's company) port of PostgreSQL to Win32, and SRA's port to Win32, and permission to generate a merged patch that can be applied to 7.4. Now that 7.3 is almost complete, I am

Re: [HACKERS] Win32 port

2002-11-05 Thread Hannu Krosing
Bruce Momjian kirjutas K, 06.11.2002 kell 08:19: I have copies of Peer Direct's (Jan's company) port of PostgreSQL to Win32, and SRA's port to Win32, and permission to generate a merged patch that can be applied to 7.4. Great! Now that 7.3 is almost complete, I am going to start work on

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Hannu Krosing
Satoshi Nagayasu kirjutas K, 06.11.2002 kell 04:15: Ross J. Reedstrom [EMAIL PROTECTED] wrote: If application continues to use just BEGIN/COMMIT, then the protocol level must parse command stream and recognize COMMIT in order to replace it with PRECOMMIT, COMMIT. If the