On Thu, Aug 31, 2000 at 03:28:14PM +1100, Chris wrote:
Jules Bean wrote:
On Thu, Aug 31, 2000 at 12:22:36AM +1000, Andrew Snow wrote:
I believe I can work around this problem using cursors (although I
don't know how well DBD::Pg copes with cursors). However, that
doesn't
On Thu, Aug 31, 2000 at 01:33:35AM -0400, Tom Lane wrote:
"Travis Bauer" [EMAIL PROTECTED] writes:
I'm getting:
FATAL: StreamServerPort: bind() failed: Address already in use
Is another postmaster already running on that port?
If not, wait a few seconds and retry.
On Thu, Aug 31, 2000 at 09:58:34AM +0100, Jules Bean wrote:
On Thu, Aug 31, 2000 at 03:28:14PM +1100, Chris wrote:
but it is true that this is a flaw in postgres. It has been
discussed on hackers from time to time about implementing a "streaming"
interface. This means that
On Thu, Aug 31, 2000 at 07:30:36AM -0500, Travis Bauer wrote:
Well, there were two other copies of postgress running, and at least one
was tying up port 5432, but . . .
I couldn't see them with 'ps' or 'ps -a', netstat did not list them as
using a port, but it did list something as having
On Thu, Aug 31, 2000 at 09:43:52AM -0300, Campbell, Scott wrote:
$sth = $dbh-prepare("begin work");
$sth-execute();
[snip error]
after seeing this I assumed that you just can't use the begin statement
accross the DBI but there has to be a way of opening a transaction (it even
says so
Hiya,
I am running a very large SELECT - it selects every row from a ~10 000
000 row table. I'm running this in Perl using DBD:Pg, with the general
sequence:
$sth = $dbh-prepare("SELECT $fields FROM $from") || return 0;
$fh = new FileHandle("$file") || die "Can't open $file : $!";
On Thu, Aug 31, 2000 at 12:22:36AM +1000, Andrew Snow wrote:
I believe I can work around this problem using cursors (although I
don't know how well DBD::Pg copes with cursors). However, that
doesn't seem right -- cursors should be needed to fetch a large query
without having it all in
n 64bit linux, AFAIK (at least, not
with a 64-bit happy libc; I can't remember if the patches made it into
the version we use in Debian).
Jules
--
Jules Bean |Any sufficiently advanced
[EMAIL PROTECTED]| technology is indistinguisha