"Jean-Pierre Pelletier" <[EMAIL PROTECTED]> writes:
>pstmt = connection.prepareStatement("select currval(?)"); throws =
> "function currval(character varying) does not exist"
>Is currval(text) gone for good or is this an oversight?
currval(text) is gone for good; the oversight is that we
Hi,
pstmt =
connection.prepareStatement("select currval(?)"); throws "function
currval(character varying) does not exist"
Using pgAdmin, I could see that
currval() now takes a regclass parameter, so
I got it to work using
pstmt =
connection.prepareStatement("select currval
Tony Marston wrote:
No, but Oracle does, which is why I am trying to produce SQL statements that
will run on MySQL, PostgreSQL and Oracle without the need for conversion.
Hi Tony,
Let me make a constructive suggestion. I see what you are trying to do
and I can understand why this is usefu
Tom Lane wrote:
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
And you might want to make it a project at http://pgfoundry.org so
others can make use of it. You might also want to define it as accepting
an array; I think that would allow you to accept any number of
parameters.
I think Ton
Anand Kumria <[EMAIL PROTECTED]> writes:
> I have a set of perl scripts which invoke each other (via system());
> eventually I found that they were crashing and ultimately causing Perl
> to SIGSEGV.
Are you doing anything multi-threaded in those scripts? libpq is not
thread-aware --- it's up to y
Am Freitag, 14. Oktober 2005 21:15 schrieb C Wegrzyn:
> The customer I am writing this for will only accept it based on released
> code. That means I run either 8.0.3 or 8.0.4.
Would it help you if I do a special ecpg release just for you? Or does it have
to be part of the postgres release?
Mich
mouse wrote:
The following bug has been logged online:
Bug reference: 1978
Logged by: mouse
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Gentoo Linux 2.6.11-r9
Description:connection sinks
Details:
Make sure you have logging turned
The following bug has been logged online:
Bug reference: 1978
Logged by: mouse
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Gentoo Linux 2.6.11-r9
Description:connection sinks
Details:
I have: (2) user X which can create databases and
Hello,
>> CREATE DOMAIN test_domain
>> AS varchar(64)
>> NOT NULL;
>> CREATE TYPE test_type AS
>>("Id" int4,
>> "Data" test_domain);
>> CREATE OR REPLACE FUNCTION union_test()
>> RETURNS SETOF test_type AS
>> $BODY$
>> select 1 as "Id", 'string1'::test_domain as "Data"
>> u
