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 sequences

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

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

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

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 spec

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

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": Inva

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 s

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] 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', w

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 diffe