Edit query buffer

From: "Wood, Bruce" <Bruce(dot)Wood(at)ngc(dot)com>
To: "Postgres Win32" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Edit query buffer
Date: 2004-11-02 19:28:04
Message-ID: 727B82C682D8E8409BD807B361874F4102208FED@xcgmd050.northgrum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-win32 pgsql-patches

I'm not sure if this goes here or to bugs, but it seems obvious (to me) that if this problem existed elsewhere, it would have been brought up by now.

In the first version of the beta native Windows release, if I try to edit the query buffer using the \e command, psql crashes spectacularly. The error is "The instruction at "0x00422078" referenced memory at "0x00000000". The memory could not be "read"." If I connect from a client machine to the database server and attempt the same thing, psql crashes less spectacularly. It just dies without a whimper. Yes, I have PSQL_EDITOR set to notepad and if I use \e filename, it attempts to open "filename". If it exists, it opens. If it doesn't exist, it asks to create it. If it's any help, when the debugger opens, it says "Unhandled exception in psql.exe: 0xC0000005: Access Violation." Selecting OK, the debugger is sitting on this line:

00422078 mov al,byte ptr [ecx]

if that means anything.

Stepping forward to the present, attempting the same \e in the beta 4 release of psql, it gripes "could not open temporary file ".\psq48F.tmp": File exists". At least now psql doesn't crash, taking the DOS window with it (if you launched psql from the menu).

Coming from an Oracle environment, I kind of like being able to edit the buffer because I don't type very well.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-11-02 19:44:22 Re: [pgsql-hackers-win32] Edit query buffer
Previous Message Magnus Hagander 2004-11-02 18:42:28 make installcheck

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Bruce Momjian 2004-11-02 19:44:22 Re: [pgsql-hackers-win32] Edit query buffer
Previous Message Magnus Hagander 2004-11-01 21:42:25 Re: [pgsql-hackers-win32] Win32 lost signals open item

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-11-02 19:44:22 Re: [pgsql-hackers-win32] Edit query buffer
Previous Message Magnus Hagander 2004-11-02 13:30:03 Re: [PATCHES] Open Items