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

Re: [pgsql-hackers-win32] Edit query buffer

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Wood, Bruce" <Bruce(dot)Wood(at)ngc(dot)com>
Cc: Postgres Win32 <pgsql-hackers-win32(at)postgresql(dot)org>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [pgsql-hackers-win32] Edit query buffer
Date: 2004-11-02 19:44:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-hackers-win32pgsql-patches
I can confirm this bug.


Wood, Bruce wrote:
> 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.
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index
> scan if your
>  joining column's datatypes do not match

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Neil ConwayDate: 2004-11-03 04:27:49
Subject: Re: psql and schemas
Previous:From: Wood, BruceDate: 2004-11-02 19:28:04
Subject: Edit query buffer

pgsql-patches by date

Next:From: Roland VolkmannDate: 2004-11-02 23:22:12
Subject: Charset WIN1252
Previous:From: Wood, BruceDate: 2004-11-02 19:28:04
Subject: Edit query buffer

pgsql-hackers-win32 by date

Next:From: Magnus HaganderDate: 2004-11-02 20:24:57
Subject: Signals inheritance work - major problems
Previous:From: Wood, BruceDate: 2004-11-02 19:28:04
Subject: Edit query buffer

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