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}
"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:
-Doug
---(end of broadcast)-
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
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: org.po
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 ag
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
[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
> 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
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 to
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 server
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
> 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?
ht
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 a
[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/ind
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 thin
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 d
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 i
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, attach
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
>
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.
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 tr
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
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, the
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
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
>> 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
"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
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
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 identif
>> 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
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
> > win
31 matches
Mail list logo