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:
An
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
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
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 fe-be
27;t be able to pull it back
> > for re-editing a second time.
>
> 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) 162
t that a user would type \E QUERY BUFFER themselves often
(if at all).
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)--
7;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://www.retep.org.uk/
Tel/Fax: +44 (0) 1622 749439
Mobile: +44 (0) 7903 1558
esn't work (or worse if the
terminal doesn't support it, or it's scrolled off the top of the buffer).
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
--
t; > Wow, that would be a nifty trick, though they really did type \e and
> > not the query the pulled in from the editor.
>
> What about those of us who want to use \e repeatedly? Will that be
> in the history buffer?
The number of times I've cursed things over the years,
um ... another reason not to announce it right away :)
Looks pretty good here.
However, the bugs link on the main page is currently broken (404: Page not
found) http://www.postgresql.org/bugs/bugs.php link from the main page.
Peter
--
Peter Mount
[EMAIL PROTECTED]
http://www.retep.org.uk/
Tel
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
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 alw
From looking
>at the page I'm guessing Peter Mount, can we get some kind of
>prominent contact info on it? I've had a few emails on it so
>far.
Bottom of every page (part of the template) is both my name and email
address ;-)
Peter
>Vince.
>--
>===
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 impo
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
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 wou
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
>Thoma
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
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
Ok, a bit late but ;-)
a few weeks ago I had an Advanced Java course, and the tutor actually
demonstrated the Python Corba interface.
Looked pretty good. He even showed JPython & corba (which is Python written
in Java).
Peter
At 11:24 08/02/01 +0100, Georges Martin wrote:
>On 7/02/01 at 18:0
At 22:27 06/02/01 -0600, JP Sugarbroad wrote:
>Well... still no CORBA? I thought someone would pick it up... then
>again, I haven't seen that many people using it. JDBC seems to be more
>popular...
going by the amount of emails I get it is ;-)
PS: There's several corba bits floating around, but
At 12:36 03/02/01 -0500, Alex Pilosov wrote:
>On Sat, 3 Feb 2001, Peter Mount wrote:
[snip]
> > I know some people think this would slow the backend down, but it's
> > only the instanciation of the JVM thats slow, hence the other reason
> > fork() is holding this ba
At 17:56 03/02/01 +0100, Peter Eisentraut wrote:
>Peter Mount writes:
>
> > Thats correct. Basically you are talking of something like PL/Java. The
> > Java side would be simple, but its linking the JVM to the backend that's
> > the problem.
>
>I've tried t
At 11:18 04/02/01 +0200, Hannu Krosing wrote:
>Peter Mount wrote:
[snip]
> > It's been a while since I delved into the backend, but unless it's changed
> > from fork() to threading,
>
>Someone posted here recently his port/tweaks of backend so that it used
>
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 p
At 12:07 02/02/01 -0500, Mitch Vincent wrote:
>hhs=> select version();
>version
>---
>PostgreSQL 6.4.2 on i386-unknown-freebsd3.1, compiled by gcc 2.7.2.
[snip]
> If it changed, it looks like it changed a long time ago! :-)
Hmm,
At 14:57 02/02/01 -0500, Alex Pilosov wrote:
>On Fri, 2 Feb 2001, tomasz konefal wrote:
>
> > could someone please clarify what "Allow Java
> > server-side programming" actually means? what are the
> > limitations of using java and jdbc with pgsql?
>
>It means to embed Java interpreter inside p
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 LargeOb
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.
>
At 13:01 22/01/01 -0500, Tom Lane wrote:
>Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > We're losing this battle anyway. Look into src/interfaces/libpq/libpq.rc.
>
>Ugh. Magnus, is there any reasonable way to generate that thing on the
>fly on Win32?
While on this subject, does anyone have
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
--
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 PRO
ead by now
so obviously don't use that one either.
Please only use the [EMAIL PROTECTED] 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
It's been committed into the cvs repository. The easiest thing to do is to
use CVS. I can't remember if it was posted direct to me, or to the patches
list.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: [EMAIL PROTECTED]
WWW: http://www.maidstone.
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
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 expres
ECTED]
[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
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 &#
On Mon, 30 Oct 2000, Peter Eisentraut wrote:
> Peter Mount writes:
>
> > 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 ma
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
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
that one? Every time a change to
the system tables is made, unless everyone who maintains the code that's
dependent on it hears about it, the queries can quickly get out of sync.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: [EMAIL PROTECTED]
WWW: http:/
On Thu, 12 Oct 2000, Tom Lane wrote:
> Vince Vielhaber <[EMAIL PROTECTED]> writes:
> > We never really had a large one.
>
> Drat. Guess I'll have to use the cartoon elephant instead.
>
> Does anyone know how to convert a ".ai" file into EPS? I think that's
> some kind of vector-art format, an
It seems that I'm now getting some delayed emails from around the 27th of
September. It's probably at my end, but if you sent me anything important,
like patches etc, please can you resend it to me.
Thanks, Peter
--
Peter T Mount [EMAIL PROTECTED] http://www.retep.org.uk
PostgreSQL JDBC Driver
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 ;-)
--
On Tue, 12 Sep 2000, Bruce Momjian wrote:
> > > As if my JDBC patch hasn't already caused enough grief, there is now a
> > > one-line change necessary. Due to the Mark Holloman "New Relkind for
> > > Views" patch, my support for views in the driver will need to be updated
> > > to match. The ch
46 matches
Mail list logo
