Bill Bartlett wrote:
> I hit this exact same problem, and my initial reaction was the same as
> yours -- psql was "hanging". After much head-banging, I discovered that
> it is not in fact hanging, but is instead getting confused by being run
> from inside Putty, Cygwin, xterm, rxvt terminal, etc. Because psql is
> not being run from a native Win32 console window, it puts itself into
> non-interactive mode, so it shows no prompts, allows no line editing,
> shows no command history, etc. But it is actually running.
Thanks for sharing this insight. Reid Thompson pointed me to
http://www.cygwin.com/ml/cygwin/2003-03/msg01457.html where the cause of
this problem is discussed. It's good to know I can still use 'psql -f
foo.sql' safely under these terminals.
> Alternatively, you can run Cygwin's version of psql against the native
> Win32 PostgreSQL 8 database, assuming you install the base Cygwin
> environment.
I don't like the idea of running a different version of the client and
server, but the thought did cross my mind. I think I'll stick with the
cmd.exe terminal instead (for the time being).
Sincerely,
--
Richard van den Berg, CISSP
-------------------------------------------
Trust Factory B.V. | www.dna-portal.net
Bazarstraat 44a | www.trust-factory.com
2518AK The Hague | Phone: +31 70 3620684
The Netherlands | Fax : +31 70 3603009
-------------------------------------------