Re: [HACKERS] [PATCHES] psql 'none' as a HISTFILE special case

2006-08-25 Thread Tom Lane
Martin Atukunda [EMAIL PROTECTED] writes: On 8/25/06, Tom Lane [EMAIL PROTECTED] wrote: There's probably no way to get Apple's libedit to not try the fchmod, so what do we want to do here? Maybe special-case the string /dev/null? If this is OK, I can up with a patch that special cases

Re: [HACKERS] [PATCHES] psql 'none' as a HISTFILE special case

2006-08-25 Thread Martin Atukunda
On 8/25/06, Tom Lane [EMAIL PROTECTED] wrote: Martin Atukunda [EMAIL PROTECTED] writes: On 8/25/06, Tom Lane [EMAIL PROTECTED] wrote: There's probably no way to get Apple's libedit to not try the fchmod, so what do we want to do here? Maybe special-case the string /dev/null? If this is

Re: [HACKERS] [PATCHES] psql 'none' as a HISTFILE special case

2006-08-25 Thread Peter Eisentraut
Am Freitag, 25. August 2006 17:03 schrieb Martin Atukunda: hmm, setting HISTFILE to /dev/null doesn't work on my MacOSX here. Please elaborate on doesn't work. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)---

Re: [PATCHES] [HACKERS] Performance testing of COPY (SELECT) TO

2006-08-25 Thread Böszörményi Zoltán
Böszörményi Zoltán [EMAIL PROTECTED] writes: With PostgreSQL 8.1.4, I used this: begin; select ... into temp myquery1; copy myquery1 to stdout csv delimiter '|'; rollback; The performance of this would doubtless vary a lot with the temp_buffers setting. Did you try different values?

Re: [PATCHES] psql 'none' as a HISTFILE special case

2006-08-25 Thread Martin Atukunda
On 8/21/06, Bruce Momjian [EMAIL PROTECTED] wrote: Tom Lane wrote: Neil Conway [EMAIL PROTECTED] writes: On Mon, 2006-08-21 at 19:27 +0300, Martin Atukunda wrote: If readline is used by psql, a history file is automatically used. This patch adds the special file name 'none', which if set

Re: [HACKERS] [PATCHES] psql 'none' as a HISTFILE special case

2006-08-25 Thread Martin Atukunda
On 8/25/06, Peter Eisentraut [EMAIL PROTECTED] wrote: Am Freitag, 25. August 2006 17:03 schrieb Martin Atukunda: hmm, setting HISTFILE to /dev/null doesn't work on my MacOSX here. Please elaborate on doesn't work. without any .psqlrc file I get the following error when quitting a psql

Re: [HACKERS] [PATCHES] psql 'none' as a HISTFILE special case

2006-08-25 Thread Tom Lane
Martin Atukunda [EMAIL PROTECTED] writes: On 8/25/06, Peter Eisentraut [EMAIL PROTECTED] wrote: Please elaborate on doesn't work. without any .psqlrc file I get the following error when quitting a psql session: could not save history to file /Users/matlads/.psql_history: Invalid argument

Re: [HACKERS] [PATCHES] psql 'none' as a HISTFILE special case

2006-08-25 Thread Martin Atukunda
On 8/25/06, Tom Lane [EMAIL PROTECTED] wrote: When I set HISTFILE to /dev/null I get the following: could not save history to file /dev/null: Operation not permitted Hm. ktrace shows this happening: 23279 psql CALL open(0x302d70,0x601,0x1b6) 23279 psql NAMI /dev/null 23279 psql

Re: [PATCHES] plpython improvements

2006-08-25 Thread Bruce Momjian
Sven Suursoho wrote: Quoting Sven Suursoho [EMAIL PROTECTED]: On Sat, 17 Jun 2006 18:47:46 +0300, Tom Lane [EMAIL PROTECTED] wrote: Obviously we should document the problem in the plpython documentation (don't try to use this feature with python versions before XXX), but I'm not

Re: [PATCHES] [HACKERS] Interval aggregate regression failure (expected

2006-08-25 Thread Bruce Momjian
I used your ideas to make a patch to fix your example: test= select '41 months'::interval / 10; ?column? --- 4 mons 3 days (1 row) and test= select '41 months'::interval * 0.3; ?column? ---

Re: [PATCHES] Adding fulldisjunctions to the contrib

2006-08-25 Thread Bruce Momjian
Sorry, we did not get enough feedback to include this in 8.2. Please add it to pgfoundry and let's see how it goes. --- Tzahi Fadida wrote: Hi, I wish to add the fulldisjunctions function to the contrib. With the help

Re: [PATCHES] IDENTITY/GENERATED columns

2006-08-25 Thread Bruce Momjian
This is being done for 8.3, right? --- Zoltan Boszormenyi wrote: Hi, here's the next version. Changes: - Extended documentation - Extending permissions to new sequences ALTER TABLE tab ADD col type GENERATED AS

Re: [PATCHES] IDENTITY/GENERATED columns

2006-08-25 Thread Zoltan Boszormenyi
Yes, I am not ready with it. Bruce Momjian írta: This is being done for 8.3, right? --- Zoltan Boszormenyi wrote: Hi, here's the next version. Changes: - Extended documentation - Extending permissions to new