Dear
Sirs,
I am spending about
10 hours on little problem: to pass a parameter (text) to a PostgreSQL (v.
8.1 on Win2000). The
relevant code
is:
java
side:
private
CallableStatement cs;
cs =
conn.prepareCall(INSERT_CONGRESSO);
cs.setString(1,
itemCongresso.getCongresso()); //return a
Dave Page wrote:
Wow this is good to know.
I'm also glad to know I'm not the only person this is happening to.
Kenneth; what platform are you running on, and ehich window manager are you using?
Regards, Dave
gentoo linux on an AMD. here are
-Original Message-
From: "Kenneth Downs"<[EMAIL PROTECTED]>
Sent: 14/05/06 21:31:15
To: "pgsql-general@postgresql.org"
Subject: Re: [GENERAL] GUI Interface
> Florian G. Pflug wrote:
> > However, I figured out that if you press ALT- with being the
> > shortcut for some menu _directly_ af
> The postmaster log might have something enlightening ...
hmm, perhaps. I had a couple of these messages in there:
postgresql-2006-05-14_105843.log:2006-05-14 11:01:34 LOG: could not
receive data from client: No connection could be made because the
target machine actively refused it.
however
Florian G. Pflug wrote:
Tino Wildenhain wrote:
Kenneth Downs schrieb:
Dave Page wrote:
On my linux box, it also has the dubious honor of being the only
program I have ever seen that can lock X hard, with killing the X
server being the only rescue (if you call that a rescue).
Tino Wildenhain wrote:
Kenneth Downs schrieb:
Dave Page wrote:
On my linux box, it also has the dubious honor of being the only
program I have ever seen that can lock X hard, with killing the X
server being the only rescue (if you call that a rescue). It can
connect over netwo
"Michael Artz" <[EMAIL PROTECTED]> writes:
> I thought I'd be clever and use the cygwin 'psql' client to connect to
> the Windows native PostgreSQL 8.1.3 running on the same box, since the
> the cygwin port feels more like home (keybindings). Unfortunately, I
> get the following message when conne
Martijn van Oosterhout writes:
> Well, I notice that the SQL standard defines something called WITH, so
> what you want is something like:
> WITH OLD AS ( SELECT blah )
> DO
> ( UPDATE
> ; DELETE )
I think it'd be a mistake to assume that WITH would fix Markus'
complaint. I haven't studied th
On 5/14/06, Alejandro Michelin Salomon ( Adinet ) <[EMAIL PROTECTED]> wrote:
Martijn :
OK, y try to explain.
First, y im using phppgAdmin for do this operations, becous my systems are
all web based.
My developpement plataform is windows, and this is the reason of use pg
8.0.4.
1) I change :
The full explanation can be found here-
http://www.postgresql.org/docs/7.4/interactive/xplang.html
The short answer is that the language is included but needs to be installed.
This is left to the discretion of the database administrator.
On Sunday 14 May 2006 08:18 am, Alejandro Michelin Salomon
I thought I'd be clever and use the cygwin 'psql' client to connect to
the Windows native PostgreSQL 8.1.3 running on the same box, since the
the cygwin port feels more like home (keybindings). Unfortunately, I
get the following message when connecting (after about a minute):
$ psql -h 127.0.0.1
Adrian :
I make some changes, based in documentation that i find in the web, and i
have this error :
ERROR: language "plpgsql" does not exist
Seems this guys does not put pg/plsql in the instalation.
I have a question, is not pg/plsql core part in postgresql?
If not is core funcionality, is no
The first thing to check is whether the hosting service has installed PL/pgsql
as a language. If you have sufficient privileges you could try 'select
lanname from pg_languages' to see if it is installed.
On Sunday 14 May 2006 07:08 am, Alejandro Michelin Salomon ( Adinet ) wrote:
> Martijn :
>
>
Martijn :
OK, y try to explain.
First, y im using phppgAdmin for do this operations, becous my systems are
all web based.
My developpement plataform is windows, and this is the reason of use pg
8.0.4.
1) I change :
CREATE OR REPLACE FUNCTION LEFT( sTexto CHARACTER VARYING, nPosFin INTEGER )
fo
Alejandro Michelin Salomon ( Adinet ) <[EMAIL PROTECTED]> schrieb:
> I criated some function in my pg 8.0.4, they function as spected.
>
> But when i try tu criate this functions in my hosting that has pg 7.4.8, i
> can not do.
> I read documentation an i see some disferences.
>
> This is one of
On Sun, May 14, 2006 at 10:10:44AM -0300, Alejandro Michelin Salomon ( Adinet )
wrote:
> Hi :
>
> I criated some function in my pg 8.0.4, they function as spected.
>
> But when i try tu criate this functions in my hosting that has pg 7.4.8, i
> can not do.
> I read documentation an i see some di
Hi :
I criated some function in my pg 8.0.4, they function as spected.
But when i try tu criate this functions in my hosting that has pg 7.4.8, i
can not do.
I read documentation an i see some disferences.
This is one of original function that i try to criate :
CREATE OR REPLACE FUNCTION LEFT(
Sebastian Ma?yska wrote:
> Hi all
>
> I have got a problem. I try to install postgresql ver.8.1.3. on the
> Debian (2.4.27-2-sparc64). I got message that readline does not found.
> So I downloaded readline 5.1 and instaled it. But I still can not
> install postgresql I recive the same message :( .
On Sun, May 14, 2006 at 08:01:39AM +0200, Markus Schiltknecht wrote:
> > What you probably want is a function that is given the row and then
> > executes the two statements on a per row basis. This has the effect you
> > want but gives up the major benefit of rules, wholesale query
> > restructurin
Hi allI have got a problem. I try to install postgresql ver.8.1.3. on the Debian (2.4.27-2-sparc64). I got message that readline does not found. So I downloaded readline 5.1 and instaled it. But I still can not install postgresql I recive the same message :( . I don't know what I am doing wrong. Ma
Jerry LeVan wrote:
> Hi,
> On my linux box I can issue the command
>
> ssh -L :macjerry:5432 -l jerry macjerry
>
> This will create a "tunnel" to connect to my
> mac named "macjerrry".
>
> I can connect to databases on macjerry via psql
> by specifying port on my linux box and other
At 11:53 AM 5/12/2006 -0400, Tom Lane wrote:
Scott Ribe <[EMAIL PROTECTED]> writes:
>> My damn powerbook drive recently failed with very little warning
> It seems to me that S.M.A.R.T. reporting is a crock of shit. I've had ATA
> drives report everything OK while clearly in the final throes of
22 matches
Mail list logo
