hi,
1. unfortunately i can't subscribe to the mailinglist - it doesn't send me
the confirmation mail so please cc me.
2. we had a server crash today - had to fsck and postgres is corrupted now
if i try a pg_dump i get:
inetmain:/tmp/tests$ pg_dump -c -v -d factline1 > /tmp/factline1_20011025_1
On Thu, 25 Oct 2001, Tom Lane wrote:
> Bill Studenmund <[EMAIL PROTECTED]> writes:
> > Enabling --debug while running regression tests notes regression test
> > failures which are not present when --debug is not enabled.
>
> Not --enable-debug, but running with debug_print_parse turned on.
>
> I'
Hmm. This seems to be a slightly different variant of the problem than
the one we fixed. You could avoid it by not letting your clients hold
open transactions while they're sitting idle. The path that's causing
a problem (or at least the problem I reproduced here) is
Backend 1
hi,
we had a server crash today - had to fsck and postgres is corrupted now
if i try a pg_dump i get:
inetmain:/tmp/tests$ pg_dump -c -v -d factline1 > /tmp/factline1_20011025_144800.sql
-- saving database definition
getDatabase(): SELECT failed. Explanation from backend: 'ERROR: pg_atoi:
er
Peter Breton <[EMAIL PROTECTED]> writes:
> Is there something that I'm not understanding here, or is this a bug?
What locale are you using? Non-C locales have sorting rules more
complex than you seem to be expecting.
$ cat data
e
,
ke
k,
ken
k,
kens
k, P
ens
, P
$ LANG=C sort data
,
, P
e
ens
k
Bill Studenmund <[EMAIL PROTECTED]> writes:
> Enabling --debug while running regression tests notes regression test
> failures which are not present when --debug is not enabled.
Not --enable-debug, but running with debug_print_parse turned on.
I've added the missing print routine.
Hi,
On my Postgres system ( PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled
by GCC 2.96), I get the following odd behavior in string compares:
# Works -- e (ASCII code 101) is after comma (ASCII code 44)
select current_time where 'e' > ',';
# Works -- adding a k to the front of both strings
se
