473,767 Members | 1,735 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Query buffer editing on Win32 version of postgresql?

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

PSQL_EDITOR="c: \progra~1\Textp a~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.t mp": File exists
db_merrymaids=#

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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #1
0 1403

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
2224
by: manders2k | last post by:
Hi all -- I'm contemplating the idea of writing a simple emacs-like editor in python (for fun and the experience of doing so). In reading through Craig Finseth's "The Craft of Text Editing": http://www.finseth.com/~fin/craft/ , I've come across the "buffer gap" representation for the text data of the buffer. Very briefly, it keeps the unallocated memory of the
1
1607
by: Christian Traber | last post by:
Hi, sometime ago I heard that there will be a native win32 version of postgresql 7.4. Is this true or will there only be a cygwin version like now? What do you think, how stable and fast is the cygwin version? Best regards, Christian
8
3270
by: Együd Csaba | last post by:
Hi All, how can I improve the query performance in the following situation: I have a big (4.5+ million rows) table. One query takes approx. 9 sec to finish resulting ~10000 rows. But if I run simultaneously 4 similar queries it takes nearly 5 minutes instead of 4 times 9 seconds or something near of that. here is a sample query: select mertido, fomeazon, ertektipus, mertertek from t_me30 where fomeazon in (select distinct fomeazon...
5
3318
by: Christian Traber | last post by:
Hi! just playing with tablespaces... - moved a existing table to a new tablespace - tried to move it back to default tablespace (ALTER TABLE accounts SET TABLESPACE pg_default;) Got the following error in logfile:
0
1103
by: Josué Maldonado | last post by:
I did the pg_dump with the Linux 7.4.3 version and tried to pg_restore with Win32 8beta1 version and I got: C:\TEMP>pg_restore -d desarrollo -i -U postgres xdump pg_restore: input file does not appear to be a valid archive Taken from the help "For best results, however, try to use the pg_dumpall command from
1
1367
by: Tom Hebbron | last post by:
Hi group, I've installed the win32 binary version of the 8.0beta1 using the PGInstaller (http://pgfoundry.org/projects/pginstaller). I've also downloaded the source to compile on our linux boxes and that is fine. The problem I've got now is building binaries of the contrib folder for win32 - specifically the fuzzystrmatch and tsearch2 bits - but I'm sure the rest would be useful. I've installed MinGW and had a bash at compiling in...
1
1106
by: Antonios Christofides | last post by:
Hi, I know we will be using at our own risk, I have read the "experimental" warnings, but still PostgreSQL is a very attractive RDBMS for the Windows application we are developing. Most customers will want a simple single-machine version, where the program will be storing its data in a local database without the user knowing much about it. Some customers will want a central database and will probably be given the option to choose...
2
3429
by: Don Kelloway | last post by:
I'm a first-time user with PostgreSQL so please forgive my ignorance. I've purchased (and read) Practical PostgreSQL (O'Reilly) and PostgreSQL Essential Reference (New Riders). So far, so good. I think learning PostgreSQL will not be as difficult as I thought it would be. I've also been googling for the last few days, but I have a question in regards to determining the proper size of the buffer cache parameter. ...
8
3007
by: Jim in Arizona | last post by:
I've been using an example out of a book to be able to edit the rows in a database. I am getting the following error: ======================================================== ======================================================== Server Error in '/' Application. -------------------------------------------------------------------------------- Operation must use an updateable query. Description: An unhandled exception occurred during...
0
9405
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10013
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9960
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9841
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7383
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6655
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5424
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3533
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2807
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.