any SELECT statement in the 'psql' console returns 'SELECT'

From: cedric(dot)lemaire(at)bnpparibas(dot)com
To: pgsql-cygwin(at)postgresql(dot)org
Subject: any SELECT statement in the 'psql' console returns 'SELECT'
Date: 2003-10-08 12:20:52
Message-ID: OF026746E5.06779CA2-ONC1256DB9.004209FC@bnpparibas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Hi,

It fact, I wrote on newsgroup yesterday about a problem that seemed to come
from "libqp.dll", but it wasn't.

It looks like something going wrong at the server-side (version 7.3.4-2 on
Cygwin 1.5.1) when sending the result of a query.

When I call a function from 'psql' (or 'libpq'), the client returns
"SELECT " (instead of a number)
and here is the client trace:
To backend> Q
To backend> SELECT news_stockIDtoMDS(10)
From backend> C
From backend> "SELECT"
From backend> Z
From backend> Z

When I write a SELECT statement under 'psql' (either in '/usr/bin" or compiled as 'psql.exe' with VC++) ,
the console displays "SELECT ", and here is the trace at the server side:
LOG: plan:
{ SEQSCAN :startup_cost 0.00 :total_cost 20.00 :rows 1000 :width 346
:qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod
-1 :resname _id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false }
:expr { VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0
:varnoold 1 :varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 2 :restype
1043 :restypmod 36 :resname _mds_code :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { VAR :varno 1 :varattno 2 :vartype 1043 :vartypmod 36
:varlevelsup 0 :varnoold 1 :varoattno 2}} { TARGETENTRY :resdom { RESDOM
:resno 3 :restype 1043 :restypmod 36 :resname _ric :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype
1043 :vartypmod 36 :varlevelsup 0 :varnoold 1 :varoattno 3}} { TARGETENTRY
:resdom { RESDOM :resno 4 :restype 1043 :restypmod 36 :resname _isin :reskey 0
:reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno
4 :vartype 1043 :vartypmod 36 :varlevelsup 0 :varnoold 1 :varoattno 4}} {
TARGETENTRY :resdom { RESDOM :resno 5 :restype 1043 :restypmod 36 :resname
_bloomberg :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr {
VAR :varno 1 :varattno 5 :vartype 1043 :vartypmod 36 :varlevelsup 0 :varnoold
1 :varoattno 5}} { TARGETENTRY :resdom { RESDOM :resno 6 :restype 1043
:restypmod 260 :resname _name :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { VAR :varno 1 :varattno 6 :vartype 1043 :vartypmod 260
:varlevelsup 0 :varnoold 1 :varoattno 6}} { TARGETENTRY :resdom { RESDOM
:resno 7 :restype 1043 :restypmod 68 :resname _sector :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 7 :vartype
1043 :vartypmod 68 :varlevelsup 0 :varnoold 1 :varoattno 7}} { TARGETENTRY
:resdom { RESDOM :resno 8 :restype 1043 :restypmod 6 :resname _country :reskey
0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1
:varattno 8 :vartype 1043 :vartypmod 6 :varlevelsup 0 :varnoold 1 :varoattno
8}} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 23 :restypmod -1 :resname
_has_parent :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr {
VAR :varno 1 :varattno 9 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1
:varoattno 9}}) :qpqual <> :lefttree <> :righttree <> :extprm () :locprm ()
:initplan <> :nprm 0 :scanrelid 1 }

SEQSCAN :c=0.00..20.00 :r=1000 :w=346 ( stock_mapping )

The server has found 346 records, so why doesn't it work properly?
Before passing to 'ipc-daemon2.exe', it was working well.

Note: I installed Cygwin + PostgreSQL without having logged as an administrator,
updating an older version that was installed as administrator. But the server
encounters no problem to start.

Thanks for any help,

Cedric

This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message stealth monkey 2003-10-08 16:42:56 installing postgres on windows2003 server
Previous Message Muhyiddin A.M Hayat 2003-10-08 09:05:14 Login As postgres