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
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
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
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
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
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
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
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.
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,
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
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
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.
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
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,
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
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
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,
[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
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
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?
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
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
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
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
[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
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
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
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:
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
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
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
31 matches
Mail list logo