Re: [HACKERS] Companies, Version 8.0 release

2004-09-21 Thread Josh Berkus
Gavin, > > c) any company which sponsored a major add-on which was significantly > > improved/created in the last year. > > What would you say falls under this category? Slony-I courtesy of Afilias Command Prompt's PL/PHP as examples. -- Josh Berkus Aglio Database Solutions San Francisco -

Re: [HACKERS] CVS configure failure

2004-09-21 Thread James William Pye
On Tue, 2004-09-21 at 17:13, Neil Conway wrote: > Should this be documented in the installation instructions? I think so. I figure just a mention should be enough. (Also add some productname tags around 'Python'.) -- Regards, James William Pye Index: installation.sgml ==

Re: testing concurrency (was Re: [HACKERS] subtransaction assert failure)

2004-09-21 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > On Fri, 2004-09-17 at 01:43, Tom Lane wrote: >> PS: this points up once again that the regression tests do not do very >> well at testing concurrent behavior. We need to think about some sort >> of parallel-test harness that would let us write tests that h

[HACKERS] Variable assignment from dynamic SQL in PL/PgSQL

2004-09-21 Thread David Fetter
Kind people, I've figured out something that many others probably have, but I thought I'd put it out there anyhow. As PL/PgSQL doesn't allow assignment of singleton SELECTs and dynamic queries to variables, as mentioned in the docs. Here's a working hack that gets around this. DECLARE foo_rec R

Re: testing concurrency (was Re: [HACKERS] subtransaction assert

2004-09-21 Thread Gavin Sherry
On Wed, 22 Sep 2004, Neil Conway wrote: > On Fri, 2004-09-17 at 01:43, Tom Lane wrote: > > PS: this points up once again that the regression tests do not do very > > well at testing concurrent behavior. We need to think about some sort > > of parallel-test harness that would let us write tests th

[HACKERS] temporary view from TODO list

2004-09-21 Thread Koju Iijima
Dear Hackers, (B (BI would like to implement and contribute two TODO items: (B"Have views on temporary tables exist in the temporary namespace" and (B"Allow temporary views on non-temporary tables". (B (BI would like to discuss several points with community. (B (B*Synopsis (B (BCREATE [ O

testing concurrency (was Re: [HACKERS] subtransaction assert failure)

2004-09-21 Thread Neil Conway
On Fri, 2004-09-17 at 01:43, Tom Lane wrote: > PS: this points up once again that the regression tests do not do very > well at testing concurrent behavior. We need to think about some sort > of parallel-test harness that would let us write tests that have better > odds of catching bugs like this.

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Neil Conway
On Wed, 2004-09-22 at 00:16, Bruce Momjian wrote: > So distutils is now required to build python? If that is intended, I > will just skip building python. I didn't realize we had new > requirements for python, but that is fine. Should this be documented in the installation instructions? -Neil

Re: [HACKERS] Companies, Version 8.0 release

2004-09-21 Thread Gavin Sherry
On Tue, 21 Sep 2004, Josh Berkus wrote: > c) any company which sponsored a major add-on which was significantly > improved/created in the last year. What would you say falls under this category? Gavin ---(end of broadcast)--- TIP 6: Have you searc

Re: Open items (was Re: [HACKERS] Disabling bgwriter on my notebook)

2004-09-21 Thread Bruce Momjian
Alvaro Herrera wrote: > On Tue, Sep 21, 2004 at 10:22:57AM -0400, Bruce Momjian wrote: > > > Added to open items list: > > > > * adjust bgwriter defaults, allow disabling > > Now that the oid2name patch has been applied, you can remove the > oid2name item from the open items list. Done. >

[HACKERS] Companies, Version 8.0 release

2004-09-21 Thread Josh Berkus
Folks, We will be listing some of the companies who made major contributions to PostgreSQL 8.0 in the press release. I'd like to make sure I don't leave anyone out just because I don't know about them. What we're covering is: a) any company that under-wrote a feature for 8.0 (such as Fujitsu

Re: [HACKERS] where n how 2 integrate COMPRESSION

2004-09-21 Thread Peter Eisentraut
Piyush Porwal wrote: > I am trying to implement Compression/Decompression techniques in > PostgreSQL, I am not able to figure out where and how to integrate > it. Did anybody worked on it. Compression already happens automatically. There is nothing left to do on the storage side. -- Peter Eise

Re: [HACKERS] SSL Support

2004-09-21 Thread Dominic Mitchell
Tom Lane wrote: [EMAIL PROTECTED] (Dominic Mitchell) writes: On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote: Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell: In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT

Re: [HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-21 Thread D'Arcy J.M. Cain
On Tue, 21 Sep 2004 11:00:33 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > I had previously mentioned that queries run much different depending > > on whether a VACUUM ANALYZE is done or just a plain ANALYZE. > > The problem appears to be that it's

[HACKERS] where n how 2 integrate COMPRESSION

2004-09-21 Thread Piyush Porwal
hello I am a student of MTech at IIT Bombay, India. I am trying to implement Compression/Decompression techniques in PostgreSQL, I am not able to figure out where and how to integrate it. Did anybody worked on it. Please help me !! -- ~~ Piyush Porwal CSE - Mtech1 IIT Bomabay

Re: [HACKERS] Fwd: How to change/replace an in-memory palloced tuple- tuple data

2004-09-21 Thread Alvaro Herrera
On Tue, Sep 21, 2004 at 01:00:18PM -0300, Fx wrote: > I tried to do this using the heap_modifytuple function , and > returning a "newSlot with a newTuple" instead the "resultSlot" but as > i suppose im missing something , can anyone help me ? or give me a > clue You need to provide more in

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Bruce Momjian wrote: >> So distutils is now required to build python? > Yes, the python docs imply that it is a reasonable expectation. FWIW, CVS tip still builds --with-python on my pretty-nearly-stock RHL 8.0 box, so distutils was standard a couple years

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Sudhakar Kurumella
Dear Andrew,   Thanks a LOT!!   It is working:   [D:\]psql -U postgres sosWelcome to psql 8.0.0beta2, the PostgreSQL interactive terminal. Type:  \copyright for distribution terms   \h for help with SQL commands   \? for help with psql commands   \g or terminate with semicolon to execut

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Andrew Dunstan
try host all all 127.0.0.1/32 trust restart the server, then try to connect. Sudhakar Kurumella wrote: Is there any alternative for me ?...Any suggestinons would be highly appreciated. thanks, kuru */Andrew Dunstan <[EMAIL PROTECTED]>/* wrote: The "local" line has no effect on Windows - it

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Sudhakar Kurumella
Is there any alternative for me ?...Any suggestinons would be highly appreciated.   thanks, kuruAndrew Dunstan <[EMAIL PROTECTED]> wrote: The "local" line has no effect on Windows - it only has relevance for Unix domain socket connections, which Windows does not support.The line that affects local

[HACKERS] Fwd: How to change/replace an in-memory palloced tuple- tuple data

2004-09-21 Thread Fx
-- Forwarded message -- From: Fx <[EMAIL PROTECTED]> Date: Mon, 20 Sep 2004 14:32:09 -0300 Subject: How to change/replace an in-memory palloced tuple- tuple data To: [EMAIL PROTECTED] Hi there , i have this scenario : - postgresql 7.5 ( with modified heap_* functions

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Laszlo Hornyak
On Tue, 21 Sep 2004, Sudhakar Kurumella wrote: > Dear Laszlo, > > Indeed that is tough, It is highly appreciated if you could explain a bit in detail. > I tried with option "password no need" in my server, and also tried remove md5 from > pg_hba.conf : > > # TYPE DATABASEUSERCIDR-

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Andrew Dunstan
The "local" line has no effect on Windows - it only has relevance for Unix domain socket connections, which Windows does not support. The line that affects local connections on Windows is "host all all 127.0.0.1/32 ..." (We really need to make that crystal clear in the pg_hba.conf ...) cheers a

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Joe Conway
Bruce Momjian wrote: So distutils is now required to build python? If that is intended, I will just skip building python. I didn't realize we had new requirements for python, but that is fine. Yes, the python docs imply that it is a reasonable expectation. Here's a snippet from the thread a week

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Andrew Dunstan
That doesn't answer the question of why he isn't even asked for a password. cheers andrew Laszlo Hornyak wrote: You could enable local connections with no password, then connect with your postgres user, change pwd, and then re-enable security. use pg_ctl reload for reloading security settings. Not

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Sudhakar Kurumella
Dear Laszlo,   Indeed that is tough, It is highly appreciated if you could explain a bit in detail. I tried with option "password no need" in my server, and also tried remove md5 from pg_hba.conf : # TYPE  DATABASE    USER    CIDR-ADDRESS  METHOD local   all postgres

Open items (was Re: [HACKERS] Disabling bgwriter on my notebook)

2004-09-21 Thread Alvaro Herrera
On Tue, Sep 21, 2004 at 10:22:57AM -0400, Bruce Momjian wrote: > Added to open items list: > > * adjust bgwriter defaults, allow disabling Now that the oid2name patch has been applied, you can remove the oid2name item from the open items list. Additionaly, there's a patch in the patch que

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Laszlo Hornyak
You could enable local connections with no password, then connect with your postgres user, change pwd, and then re-enable security. use pg_ctl reload for reloading security settings. Not nice, but quick :) On Tue, 21 Sep 2004, Sudhakar Kurumella wrote: > I am trying to connect to database call

Re: [HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-21 Thread Tom Lane
"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > I had previously mentioned that queries run much different depending on > whether a VACUUM ANALYZE is done or just a plain ANALYZE. The problem appears to be that it's picking the wrong index to use for the second part of the query (the certrans_act

Re: [HACKERS] Disabling bgwriter on my notebook

2004-09-21 Thread Bruce Momjian
Added to open items list: * adjust bgwriter defaults, allow disabling --- Tom Lane wrote: > "Michael Paesold" <[EMAIL PROTECTED]> writes: > > Setting the delay to the same value as checkpoint_timeout would effectiv

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Sudhakar Kurumella
I am trying to connect to database called "sos", i tried as you said:   [D:\]psql -U postgres template1psql: FATAL:  Password authentication failed for user "postgres" [D:\]psql -U postgres -W template1psql: FATAL:  Password authentication failed for user "postgres" [D:\]   I got the above error ag

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Bruce Momjian
Gaetano Mendola wrote: > Bruce Momjian wrote: > > I get this failure on current CVS running configure --with-python: > > > > checking for python... /usr/local/bin/python > > checking for Python distutils module... no > > configure: error: distutils module not found > > gmake: *

Re: [HACKERS] SSL Support

2004-09-21 Thread Tom Lane
[EMAIL PROTECTED] (Dominic Mitchell) writes: > On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote: >> Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell: >>> In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass >>> in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT fla

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Andrew Dunstan
Which database are you trying to connect to? try: psql -U postgres template1 or psql -U postgres -W template1 and see what happens cheers andrew Sudhakar Kurumella wrote: I tried that, the error is the same but with user "postgres" [D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres psql: FATAL:

Re: [HACKERS] Disabling bgwriter on my notebook

2004-09-21 Thread Tom Lane
"Michael Paesold" <[EMAIL PROTECTED]> writes: > Setting the delay to the same value as checkpoint_timeout would effectivly > disable bgwriter between checkpoints. This is what I wanted. > The problem is that this is currently not possible, since bgwriter_delay has > an upper limit of 5 seconds. Tom

Re: [HACKERS] SSL Support

2004-09-21 Thread Alvaro Herrera
On Tue, Sep 21, 2004 at 10:35:56AM +0100, Dominic Mitchell wrote: > I think it's misleading to talk about SSL being supported without these > options. I've used SSL in other places (apache/mod_ssl, curl, stunnel) > and I came to expect this sort of verification as standard behaviour. > What's mor

Re: [HACKERS] elog in 7.4

2004-09-21 Thread Tom Lane
Laszlo Hornyak <[EMAIL PROTECTED]> writes: > I am implementing a java language handler. If unrecoverable error occurs, > it needs to send a signal to the java process, so it can stop the > execution of the stored procedure, otherwise it would stay in inconsystent > state. Well, an elog callback is

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Sudhakar Kurumella
I tried that, the error is the same but with user "postgres"   [D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgrespsql: FATAL:  Password authentication failed for user "postgres"   It is not taking my password if i give option with "-W" as well.   [D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres -

Re: [HACKERS] psql: FATAL: Password authentication failed for

2004-09-21 Thread Dave Cramer
Use psql -U postgres Dave On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote: > Hi, > > I am using postgresql windows based "8.0-beta2-dev3". I have provided > default user and password while installing. When i am trying to > connecto to psql through dos command prompt, i am getting following

[HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-21 Thread D'Arcy J.M. Cain
[I sent this 24 hours ago and it hasn't shown up yet. I may have used the wrong address. If not apologies for the dup.] I had previously mentioned that queries run much different depending on whether a VACUUM ANALYZE is done or just a plain ANALYZE. At the time I was told that that couldn't be

[HACKERS] psql: FATAL: Password authentication failed for user "Administrator"

2004-09-21 Thread Sudhakar Kurumella
Hi,   I am using postgresql windows based "8.0-beta2-dev3". I have provided default user and password while installing. When i am trying to connecto to psql through dos command prompt, i am getting following error:   [D:\Postgresql\8.0-beta2-dev3\bin]psqlpsql: FATAL:  Password authentication failed

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Gaetano Mendola
Bruce Momjian wrote: I get this failure on current CVS running configure --with-python: checking for python... /usr/local/bin/python checking for Python distutils module... no configure: error: distutils module not found gmake: *** [config.status] Error 1 I

Re: [HACKERS] libpq and prepared statements progress for 8.0

2004-09-21 Thread Shachar Shemesh
Harald Fuchs wrote: The first problem with this approach is that it requires libpq to be all things to all people. We've already had some discussion in this thread about the tension between supporting application programs written in C, which want one set of features, and drivers, which need some o

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Gaetano Mendola
Bruce Momjian wrote: > I get this failure on current CVS running configure --with-python: > >checking for python... /usr/local/bin/python >checking for Python distutils module... no >configure: error: distutils module not found >gmake: *** [config.status] Error 1 > > I have pyth

Re: [HACKERS] libpq and prepared statements progress for 8.0

2004-09-21 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> writes: > David Wheeler <[EMAIL PROTECTED]> writes: >> On Sep 20, 2004, at 12:34 AM, Bruce Momjian wrote: >>> I think we should favor libpq usage wherever possible and only >>> re-implement it in the native language when required, like f

Re: [HACKERS] SSL Support

2004-09-21 Thread Dominic Mitchell
On Tue, Sep 21, 2004 at 10:44:22AM +0200, Kaare Rasmussen wrote: > > I think verification of the server certificates is not supported either. > > SSL only serves for encryption, not authentication or integrity checking > > (which is probably a stupid idea). > > I have this feeling that SSL in Pos

Re: [HACKERS] SSL Support

2004-09-21 Thread Dominic Mitchell
On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote: > Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell: > > I am also unsure of the > > procedures for submitting patches; is it ok to just send to hackers? > > [EMAIL PROTECTED] Thanks, I'll send it along there. > > I

Re: [HACKERS] Disabling bgwriter on my notebook

2004-09-21 Thread Michael Paesold
Bruce Momjian wrote: > What about the original request to turn off the bgwriter? Would setting > the delay to a very high value do that? Setting the delay to the same value as checkpoint_timeout would effectivly disable bgwriter between checkpoints. This is what I wanted. The problem is that thi

Re: [HACKERS] SSL Support

2004-09-21 Thread Kaare Rasmussen
Hi > I think verification of the server certificates is not supported either. > SSL only serves for encryption, not authentication or integrity checking > (which is probably a stupid idea). I have this feeling that SSL in PostgreSQL isn't category 1 supported if you can put it that way. Maybe I

Re: [HACKERS] SSL Support

2004-09-21 Thread Peter Eisentraut
Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell: > I am also unsure of the > procedures for submitting patches; is it ok to just send to hackers? [EMAIL PROTECTED] > In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass > in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT fl

[HACKERS] SSL Support

2004-09-21 Thread Dominic Mitchell
I've just spent a while this afternoon attempting to get SSL support working. It appears to be lacking in a few areas, foremost documentation. I've got a patch filling in the missing pieces for the server side, but I am unsure where I should document the client side bits (~/.postgresql/root.crt a