Re: [HACKERS] psql \e broken again

2004-11-16 Thread Kevin Brown
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: Agreed, no quotes on Unix. I'm just wondering what to do on Windows. I don't think I've seen a single windows program that uses the EDITOR variable. There are some ported unix tools, but that's it. Native windows program will

Re: [HACKERS] psql \e broken again

2004-11-16 Thread Zeugswetter Andreas DAZ SD
So I thought I'd try a few scenarios, since I have it installed: [ none of which work ] So to answer your question, at least in part, there is no current good behavior to emulate. At least on this version of CVS: I think this is fairly graphic proof that (1) a straight port without doing

Re: [HACKERS] GiST: PickSplit and multi-attr indexes

2004-11-16 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: On Mon, 2004-11-15 at 10:19 -0500, Tom Lane wrote: I'm not familiar with the details of the GiST code, but would it work to generalize PickSplit to return a three-way classification? That is, instead of actually splitting the node, have it identify each

Re: [HACKERS] psql \e broken again

2004-11-16 Thread Bort, Paul
Title: RE: [HACKERS] psql \e broken again From: Zeugswetter Andreas DAZ SD [mailto:[EMAIL PROTECTED]] I am not sure the test is valid, since %EDITOR% was used on the command line, which does it's own magic on quotes. Is there a command that would use the envvar EDITOR without

Re: [HACKERS] psql \e broken again

2004-11-16 Thread Tom Lane
Bort, Paul [EMAIL PROTECTED] writes: I like Kevin Brown's suggestion of writing out a temporary .txt file and 'executing' it. It will follow the principle of least suprise for Windows users. Note that the current default behavior (assuming you've not set EDITOR) is vi foo.txt which is quite

Re: [HACKERS] psql \e broken again

2004-11-16 Thread Zeugswetter Andreas DAZ SD
I like Kevin Brown's suggestion of writing out a temporary .txt file and 'executing' it. It will follow the principle of least suprise for Windows users. Note that the current default behavior (assuming you've not set EDITOR) is vi foo.txt which is quite unlikely to be helpful to a Windows

[HACKERS] need help on writing an aggregate function

2004-11-16 Thread subhash
hi, I was writing my own data type, and, I have to write aggregare function like min() and max() for my datatype. I googled for the user defined aggregate functions, but I could not find any examples for the sfunc and ffunc. Can any of you provide me the source/structure in C or SQL for these two

Re: [HACKERS] postmaster segfaults with HUGE table

2004-11-16 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: Attached is a revised patch -- I just did the check at the end of transformStmt(), Looks OK offhand. BTW I figure this should be backpatched to REL7_4_STABLE. Barring any objections I will do that (and apply to HEAD) this evening. No objection here.

[HACKERS] Minor problem with Makefile.shlib

2004-11-16 Thread Thomas Hallgren
I have a minor issue with Makefile.shlib. Compiling with win32 it spits out these warnings (the same is true for Cygwin) Makefile.shlib:327: warning: overriding commands for target `libpljava.a' Makefile.shlib:262: warning: ignoring old commands for target `libpljava.a' As it turns out,

Re: [HACKERS] GiST: PickSplit and multi-attr indexes

2004-11-16 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: If there are no don't-care cases, then you're effectively saying that the first column's PickSplit has sole control over the tree shape, which is where we're at now. ISTM the entire point of a multi-column index is that the first column has duplicates, or

Re: [HACKERS] Minor problem with Makefile.shlib

2004-11-16 Thread Andrew Dunstan
I submitted a patch to fix this on October 21st, but it has not been applied (in common with several other cleanup patches I sent in about a week ago). cheers andrew Thomas Hallgren wrote: I have a minor issue with Makefile.shlib. Compiling with win32 it spits out these warnings (the same is

Re: [HACKERS] need help on writing an aggregate function

2004-11-16 Thread Bruno Wolff III
On Tue, Nov 16, 2004 at 12:41:45 -0700, [EMAIL PROTECTED] wrote: hi, I was writing my own data type, and, I have to write aggregare function like min() and max() for my datatype. I googled for the user defined aggregate functions, but I could not find any examples for the sfunc and ffunc.

Re: [HACKERS] GiST: PickSplit and multi-attr indexes

2004-11-16 Thread Greg Stark
Greg Stark [EMAIL PROTECTED] writes: I'm not sure that GiST indexes behave the same way as btree indexes for the multi-column case. In a btree index the second column is entirely subordinate to the first column. In a GiST index the data is multi-dimensional, and all dimensions are equally

[HACKERS] Unicode characters above 0x10000 #2

2004-11-16 Thread John Hansen
I sent this to -patches, but it has not shown up, so I resend to -hackers. Comments on the matter so we can get this issue resolved welcome. Kind Regards, John Hansen -- Hello, Seing that the limit is still in place,

Re: [HACKERS] Minor problem with Makefile.shlib

2004-11-16 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: I submitted a patch to fix this on October 21st, but it has not been applied (in common with several other cleanup patches I sent in about a week ago). Bruce got horribly backlogged recently and didn't get any patches in to speak of. Since he's in

Re: [HACKERS] GiST: PickSplit and multi-attr indexes

2004-11-16 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: The approach they take is to have a function which calculates an abstract distance between any two entries. There's an algorithm that they use to pick the split based on this distance function. If you abandoned PickSplit and instead exposed this distance

Re: [PATCHES] [HACKERS] plperl Safe restrictions

2004-11-16 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: It has just been brought to my attention that we are being very restrictive about what we allow to be done in trusted plperl. ... OK, based on this and some further thought, I have prepared the attached patch which does the right thing, I think,

Re: [HACKERS] CVS should die

2004-11-16 Thread Kaz Kylheku
[EMAIL PROTECTED] (Travis P) wrote in message news:[EMAIL PROTECTED]... Misinforming the user on rename with local changes [EMAIL PROTECTED] news://news.gmane.org:119/[EMAIL PROTECTED] Might be easier to read with a browser here: http://svn.haxx.se/dev/archive-2004-11/index.shtml

Re: [HACKERS] CVS should die

2004-11-16 Thread Thomas Hallgren
Travis P wrote: Thomas (Hallgren): Unfortunately, my efforts to get Thunderbird to do something useful with that URL have been unsuccessful and I can't find the thread on the (usable) mailing list archive ( don't use the tigris.org archive; use http://svn.haxx.se/ ). Thanks Travis. I'm not at

Re: [PATCHES] [HACKERS] plperl Safe restrictions

2004-11-16 Thread John Hansen
Applied, with changes to allow srand and disallow sprintf, as per subsequent discussion. How about allowing: use utf8; use locale; ? Kind Regards, John ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [HACKERS] Concern about new PL/Perl

2004-11-16 Thread Peter Eisentraut
Andrew Dunstan wrote: $res-{rows} is a reference to an array of the result rows. For a different command $res-{rows} is a scalar containing the number of affected rows. I don't recall seeing any reply to this, but I'm inclined to agree with it. Joshua, any comment from CP? I

[HACKERS] Problems with output function of new datatype!

2004-11-16 Thread subhash
hi, I have programmed a rational datatype and provided it with an output function rational_out. The output function takes a rational data type as input and returns cstring as output. The postgres is giving an error server closed the connection unexpectedly This probably means the

Re: [PATCHES] [HACKERS] plperl Safe restrictions

2004-11-16 Thread Andrew Dunstan
John Hansen wrote: Applied, with changes to allow srand and disallow sprintf, as per subsequent discussion. How about allowing: use utf8; use locale; ? I think it is *way* too late in the dev cycle to be proposing this. Maybe it should be a TODO item - I at least don't have time even

Re: [PATCHES] [HACKERS] plperl Safe restrictions

2004-11-16 Thread John Hansen
I think it is *way* too late in the dev cycle to be proposing this. Maybe it should be a TODO item - I at least don't have time even to think about the implications os using these pragmas. The effect of the first is achievable via an environment setting, I believe. If you need these

Re: [HACKERS] Problems with output function of new datatype!

2004-11-16 Thread Tom Lane
[EMAIL PROTECTED] writes: The real problem starts here: when i use the function as select rational_out(rational_type) from testtable; it works fine and returns a cstring. But when i execute select rational_type from testtable; then it dies with the error i mentioned before. Why is

Re: [HACKERS] postmaster segfaults with HUGE table

2004-11-16 Thread Neil Conway
On Tue, 2004-11-16 at 16:25 +1100, Neil Conway wrote: Attached is a revised patch Applied to HEAD, and backpatched to REL7_4_STABLE. -Neil ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] need help on writing an aggregate function

2004-11-16 Thread David Fetter
On Tue, Nov 16, 2004 at 03:21:44PM -0600, Bruno Wolff III wrote: On Tue, Nov 16, 2004 at 12:41:45 -0700, [EMAIL PROTECTED] wrote: hi, I was writing my own data type, and, I have to write aggregare function like min() and max() for my datatype. I googled for the user defined aggregate

[HACKERS] java.lang.ClassNotFoundException

2004-11-16 Thread Ulrich, Azar S.
I was reading the email trail about this error message posted by and Ernst Jan and Dave Cramer on: Date: 10 Feb 2003 16:37:51 -0500 and I can't figure out what the advice is to fix the problem. Could you please help? I get the this error: java.lang.ClassNotFoundException:

[HACKERS] pg_dump problem

2004-11-16 Thread Roberto Fichera
Hi All, today I ve got this error during a backup: [EMAIL PROTECTED] root]# pg_dump -U postgres radiuslog | gzip -c radiuslog-20041116.gz pg_dump: ERROR: unknown address family (3) pg_dump: lost synchronization with server, resetting connection pg_dump: SQL command to dump the contents of table

Re: [HACKERS] java.lang.ClassNotFoundException

2004-11-16 Thread Doug McNaught
Ulrich, Azar S. [EMAIL PROTECTED] writes: and I do have classpath set to where pg73jdbc3.jar is located via: export CLASSPATH=.:~/lib You need to put the JAR file itself in the classpath: export CLASSPATH=~/lib/pg73jdbc3.jar:other stuff -Doug ---(end of

Re: [Plperlng-devel] Re: [HACKERS] Concern about new PL/Perl

2004-11-16 Thread Josh Berkus
Andrew, Peter, It seems that in the new PL/Perl, the result of the spi_exec_query function changes in meaning depending on the command.  For a SELECT, the value of $res-{rows} is a reference to an array of the result rows. For a different command $res-{rows} is a scalar