-- 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)