Re: [HACKERS] psql and readline

2003-01-09 Thread Peter Mount
is only three key presses any how ;-) Peter -- Peter Mount [EMAIL PROTECTED] http://www.retep.org.uk/ Tel/Fax: +44 (0) 1622 749439 Mobile: +44 (0) 7903 155887 US Fax: 1 435 304 5165 US Voice: 1 435 304 5165 ---(end of broadcast)--- TIP 3

Re: [HACKERS] psql and readline

2003-01-09 Thread Peter Mount
FILENAME opens an editor based on the file to the right of the command. That's a possible one, but the only problem I can see is if the user uses \e on it's own (ie not read in a file). Do we then place just \e or \E QUERY BUFFER into the history? Peter -- Peter Mount [EMAIL PROTECTED] http

Re: [HACKERS] psql and readline

2003-01-09 Thread Peter Mount
, but we shouldn't change things too much. I currently think that if \e is typed on it's own, then \E QUERY BUFFER goes into the history. Keep the existing behaviour of \e FILENAME the same. I'd doubt that a user would type \E QUERY BUFFER themselves often (if at all). Peter -- Peter Mount

Re: [HACKERS] psql and readline

2003-01-09 Thread Peter Mount
. If you call \e again immediately then you edit the previous command. Yes, but it's not always the last command you want :-( Peter -- Peter Mount [EMAIL PROTECTED] http://www.retep.org.uk/ Tel/Fax: +44 (0) 1622 749439 Mobile: +44 (0) 7903 155887 US Fax: 1 435 304 5165 US Voice: 1 435 304

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-09-23 Thread Peter Mount
Hannu Krosing wrote: On N, 2004-09-23 at 11:34, Grant Finnemore wrote: Hi Magnus, Yes, this is the situation that I have been thinking about. Specifically when a single stored procedure returns many recordsets. IIRC support for returning multiple recordsets was removed from postgresql

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-09-23 Thread Peter Mount
Hannu Krosing wrote: On N, 2004-09-23 at 15:22, Peter Mount wrote: Hannu Krosing wrote: On N, 2004-09-23 at 11:34, Grant Finnemore wrote: Hi Magnus, Yes, this is the situation that I have been thinking about. Specifically when a single stored procedure returns many recordsets

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-09-24 Thread Peter Mount
Tom Lane wrote: One interesting point is whether it's possible for one procedure to call another, and if so what that means for the semantics. Is the inner procedure allowed to commit a transaction started by the outer one? Usually yes a procedure can call another, and it's extremely useful to

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-09-24 Thread Peter Mount
Maarten Boekhold wrote: Joe Conway wrote: Gavin Sherry wrote: Do you have any idea about databases returning result sets from SQL procedures (ie, not functions). As other's have pointed out, this is very common in the MS SQL Server world (and I believe Sysbase also supports it). It works like:

Re: [HACKERS] Please no // comments in C source (ecpg)

2000-09-25 Thread Peter Mount
On Mon, 25 Sep 2000, Zeugswetter Andreas SB wrote: Subj, sais it all, Please don't use C++ style comments in C source files. It does not work for all ports. AFAIK, only GCC supports // as comments. Currently in connect.c. And in the java areas, but that doesn't count here ;-) --

[HACKERS] RE: [INTERFACES] RE: JDBC now needs updates for large objects

2000-10-24 Thread Peter Mount
Yes, the joins were one of the reasons I was going to do it. If no one starts a list by Saturday, then I'll start one when I go through JDBC. Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: [EMAIL PROTECTED] WWW: http://www.maidstone.gov.uk All views

[HACKERS] Current CVS broken?

2000-10-30 Thread Peter Mount
I've just tried to checkout a clean copy of the cvs tree, and it seems that configure is missing a substitutions in Makefile.global.in, ie: make: *** No rule to make target `@abs_top_srcdir@/src/Makefile.global.in', needed by `../../../src/Makefile.global'. Stop. Any ideas? Peter -- Peter T

Re: [HACKERS] Current CVS broken?

2000-10-30 Thread Peter Mount
On Mon, 30 Oct 2000, Peter Eisentraut wrote: Peter Mount writes: Run './config.status --recheck'. No still has the problem. I'm currently having to edit it manually to get round the problem. Oh, you need to run './config.status' as well. './config.status --recheck' figures out

[HACKERS] Changes affecting the JDBC archive

2000-11-07 Thread Peter Mount
] [EMAIL PROTECTED] [EMAIL PROTECTED] Hopefully everything else will be working properly before long, and the retep.org.uk domain will be back online. Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: [EMAIL PROTECTED] WWW: http://www.maidstone.gov.uk All views

[HACKERS] RE: [INTERFACES] JDBC 'Unterminated quoted string'

2000-11-10 Thread Peter Mount
Yes it does look like it's the insert that's at fault. I've tested it on a current backend here and it has the same problem. Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: [EMAIL PROTECTED] WWW: http://www.maidstone.gov.uk All views expressed within

RE: [HACKERS] PostgreSQL as windows 2000 service

2000-11-23 Thread Peter Mount
There's bound to be a better way, but in the NT resource kit there was a tool you can use to make any .exe a service. I have a bash script running under Cygwin as a service here using it. Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: [EMAIL PROTECTED] WWW

[HACKERS] Status of JDBC Interface

2000-12-20 Thread Peter Mount
] one for contacting me from now on. Thanks, Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: [EMAIL PROTECTED] WWW: http://www.maidstone.gov.uk All views expressed within this email are not the views of Maidstone Borough Council

RE: [HACKERS] Status of JDBC Interface

2000-12-22 Thread Peter Mount
-- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: [EMAIL PROTECTED] WWW: http://www.maidstone.gov.uk All views expressed within this email are not the views of Maidstone Borough Council -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED

[HACKERS] Re: [GENERAL] postgres memory management

2001-01-22 Thread Peter Mount
At 13:18 21/01/01 +0100, Alexander Jerusalem wrote: Hi all, I'm experiencing some strange behaviour with postgresql 7.0.3 on Red Hat Linux 7. I'm sending lots of insert statements to the postgresql server from another machine via JDBC. During that process postgresql continues to take up more

[HACKERS] Re: Re: [GENERAL] Trouble porting postgreSQL to WinNT

2001-01-30 Thread Peter Mount
At 14:07 30/01/01 -0600, Fred Yankowski wrote: On Tue, Jan 30, 2001 at 09:41:11AM -0800, Barry Lind wrote: Yes I had the same problem, but for me the reason was that I forgot to start the ipc-daemon before running initdb. Last night I had no problems installing beta4 on WinNT 4.0. Also,

Re: [HACKERS] Open 7.1 items

2001-01-30 Thread Peter Mount
At 15:02 29/01/01 -0500, Bruce Momjian wrote: LAZY VACUUM (Vadim) Runtime btree recovery (Vadim) JDBC setMaxRows() is global variable affecting other objects Now fixed. When called from within a Statement it uses its maxrows value, but internal queries don't have a restriction. JDBC

Re: [HACKERS] Format of the Money field

2001-02-03 Thread Peter Mount
At 12:55 02/02/01 -0400, The Hermit Hacker wrote: On Fri, 2 Feb 2001, Peter T Mount wrote: When did the MONEY type change it's output format? While working on the JDBC test suite, Money broke. It seems to output: $10.99 ($10.99) for negative values While since ages past, the

Re: [HACKERS] Re: PostgreSQL JDBC

2001-02-24 Thread Peter Mount
At 13:05 23/02/01 -0500, Jeff Duffy wrote: On Fri, 23 Feb 2001, Andy Engdahl wrote: I seem to be having some problems w/ the psql jdbc driver. I'm able to load the driver, but as soon as I try to connect w/ the database. here's my code: import java.sql.*; public class dataBase {

Re: [HACKERS] jdbc driver hack

2001-03-01 Thread Peter Mount
At 06:15 25/02/01 -0500, Ola Sundell wrote: Hello. I have made a small contribution to the JDBC driver, in the JDBC v2.0 stuff. Whom do I send it to? The JDBC list is the best place (which I've seen you already have). PS: I'm replying this only to get this into the mail archives ;-) Peter

Re: [HACKERS] Release in 2 weeks ...

2001-03-01 Thread Peter Mount
At 11:52 26/02/01 -0400, The Hermit Hacker wrote: Morning all ... Are there any major outstandings that ppl have on their plates, that should prevent a release? I'd like to put out an RC1 by Friday this week, with a full release schedualed for March 15th ... this would give Thomas his

Re: [HACKERS] Release in 2 weeks ...

2001-03-01 Thread Peter Mount
At 17:54 27/02/01 +0100, Peter Eisentraut wrote: The Hermit Hacker writes: Are there any major outstandings that ppl have on their plates, that should prevent a release? I'd like to put out an RC1 by Friday this week, with a full release schedualed for March 15th ... this would give

[HACKERS] Re: contrib: retep - empty documentation files

2001-03-01 Thread Peter Mount
At 20:37 01/03/01 +, Oliver Elphick wrote: 7.1beta5 in contrib/retep: Implementation and README are both empty. Hmmm, not sure what happened there. I'm committing in more of the retep contrib stuff over the weekend, so I'll fix them then. Peter -- Oliver Elphick

Re: [HACKERS] Banner links not working (fwd)

2001-03-12 Thread Peter Mount
to know. Still trying to find the correct driverClass/connectString for the Postgres JDBC driver... That should be on the site already (infact its been on there for about 3 years now ;-) --- Who maintains this site? It's certainly not me. From looking at the page I'm guessing Peter Mount

Re: [HACKERS] Internationalized error messages

2001-03-12 Thread Peter Mount
At 23:49 08/03/01 +0100, Peter Eisentraut wrote: I really feel that translated error messages need to happen soon. Managing translated message catalogs can be done easily with available APIs. However, translatable messages really require an error code mechanism (otherwise it's completely

Re: [HACKERS] Banner links not working (fwd)

2001-03-12 Thread Peter Mount
At 11:41 12/03/01 -0500, Vince Vielhaber wrote: On Mon, 12 Mar 2001, Peter Mount wrote: Bottom of every page (part of the template) is both my name and email address ;-) Can we slightly enlarge the font? Can do. What size do you think is best? I've always used size=1 for that line

Re: [HACKERS] CORBA and PG

2001-03-12 Thread Peter Mount
At 12:37 07/03/01 +1100, John Reid wrote: Hi, This was mentioned a while back on this list (pg hackers) - thanks to whoever provided the pointer :-) I have not yet looked at it in depth, though that is high on my list of TO-DO's. It is released under an apache style licence. Any reason why