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

Cedric,

Please keep your replies on-list.

On Thu, Oct 09, 2003 at 08:29:39AM +0200, Cedric Lemaire wrote:
> Thanks for your answer.

You are welcome.

> >> 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.
>
> > Try upgrading Cygwin to 1.5.5-1. I just ran a make installcheck under
> > Cygwin 1.5.5-1 without any problems.
>
> In fact, I wanted to say "1.5.5-1" (I have forgotten a five).
> Yesterday, after posting my mail, I did some trials:
> - I downgraded to PGSQL 7.3.4-1 (without uninstalling)
> -> initdb failed, because of 'ipc-daemon2.exe' I guess (semaphor
> stuff),
> - I upgraded to 7.3.4-2 (without uninstalling)
> -> initdb failed with 'ipc-daemon2.exe' !? It was surprising, so:
> - I uninstalled properly PostGreSQL, then I uninstalled 7.3.4-2
> -> initdb ran correctly,
> - I ran '/usr/bin/postmaster' (messages on stdin):
> -> I populated the database via server functions: 'psql' was returning
> "SELECT" after each call,
> -> I wrote SELECT statements in 'psql' that were returning "SELECT"
> - I stopped 'postmaster' and I ran 'pg_ctl' instead:
> -> I populated the database via server functions NORMALLY,
> -> I wrote SELECT statements in 'psql' that were returning their value
> AS EXPECTED,
>
> My conclusion, considering the appearances:
> - it is very important to uninstall first before installing or
> re-installing
> PostGreSQL on Cygwin (I tried the reinstall too),
> - under 7.3.4-2, it is better to run 'pg_ctl' instead of 'postmaster',
> - for me, the problem is now solved.

I'm glad you solved your problem.

> However, I can't explain why 'postmaster' returns a 'C' answer on
> SELECT-like statement, instead of a 'P' answer in the frontend/backend
> protocol (I didn't have time to debug the server), when not running as
> a background process (and after doing all what I detailed above).
>
> Doesn't it sound like a bug? Or is it a misuse of 'postmaster'?

Sorry, but I'm not qualified to address the above.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6