Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32pgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group