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 fo

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 wou

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.

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] 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 complet

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 tha

[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 iss

[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 190

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 anywa

[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] [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> ver

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 ke

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 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 presumabl

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

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 s

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] 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, tha

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 documentati

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 [E

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

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

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 a

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 -0400

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

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 th

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? > >

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 do

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

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 ch

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 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

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] 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

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 00:40

[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] [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 (#po

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 broadcast)---

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 > > > > > >

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] 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 witho

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: [HA

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 PROTE

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 y

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 hth, - Stuart

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)

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] 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] 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 broadcast

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 retu

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 >

[HACKERS] a tiny question

2002-11-05 Thread Luis Alberto Amigo Navarro
Hi all: I've been running small aplications over postgres 7.2.2, they are based over a tpch-like 100Mb database (which give us about 400Mb of disk usage), system is an 8-CPU SGI Power Challenge, postgres is given 8 shared buffers and backends 32Mb of sort-memory, so all data fits in memor

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 symbo

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

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: > > > http:/