Thread: pgsql 8.0 beta 4 - Win32 psql client problem

pgsql 8.0 beta 4 - Win32 psql client problem

From
John Browne
Date:
-- Originally posted to pgsql-general, but no replies --

I was attempting to set up my psql client on the Win32 version of
postgres 8.0 beta 4 to be able to use an external editor.  I set the
environment variable in windows like so:

PSQL_EDITOR="c:\progra~1\Textpa~1\Textpad.exe"

which does appear to work correctly.  However, I get the following
when attempting to edit the query buffer:

db_merrymaids=# \e
could not open temporary file ".\psqA8C.tmp": File exists
db_merrymaids=#

Each successive "\e" command tries to create a different tmp file with
a different filename, all fail with the "File Exists" message.

If I specify a file using

db_merrymaids=# \e somefile.txt

Textpad does launch and ask to create the new file.  But, I don't need
to create a new file.  I need to edit the built-in query buffer.  :-)
Any ideas why I'm getting the "File exists" error on the temp file?  Bug maybe?

Thanks for any help