Re: [BUGS] [SQL] Function Parameters in GROUP BY clause cause errors

2006-03-23 Thread Davidson, Robert
How amazing is that? I call it a night and come back to find that a bug has been identified and patched while I sleep. When will it appear in the binaries (I see that the release version is still 8.1.3)? I thought about trying to compile from source, but after looking at the mingw page was too

[BUGS] vacuum: invalid memory alloc request size 2684354556

2006-03-23 Thread Anita Lederer
Hi, i have - PostgreSQL 8.1.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 20050117 (prerelease) (SuSE Linux) - 2 services running, one on port 5432 and another one on port 5431. vacuum fails in every way i tried (psql, pgadmin, autovac, jdbc; single table, whole database) but ana

Re: [BUGS] BUG #2350: Timezone string fails in a certain context

2006-03-23 Thread Gloria
Thank you. I appreciate this quick response. Gloria "Gloria W" <[EMAIL PROTECTED]> writes: ERROR: invalid input syntax for type timestamp with time zone: "2006-03-20 09:06:00 US/Pacific" That is not currently supported, sorry. Timestamp input can only use the timezone

Re: [BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292

2006-03-23 Thread Harco de Hilster
That did the trick. Thanks. Kind regards, Harco Tom Lane wrote: Harco de Hilster <[EMAIL PROTECTED]> writes: (gdb) bt #0 MemoryContextAlloc (context=0x8b3a10, size=4294967292) at mcxt.c:505 #1 0x004e06f9 in lazy_vacuum_rel (onerel=0x2a955ecbd8, vacstmt=0x8bf390) at vacuumlazy

Re: [BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292

2006-03-23 Thread Tom Lane
Harco de Hilster <[EMAIL PROTECTED]> writes: > (gdb) bt > #0 MemoryContextAlloc (context=0x8b3a10, size=4294967292) at mcxt.c:505 > #1 0x004e06f9 in lazy_vacuum_rel (onerel=0x2a955ecbd8, > vacstmt=0x8bf390) at vacuumlazy.c:963 What do you have maintenance_work_mem set to? If it's la

[BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292

2006-03-23 Thread Harco de Hilster
Hi all, vacuumdb (and autovacuum) fails for two of nine databases with the error message: vacuumdb -v -e -z pgcmisnlt1 VACUUM VERBOSE ANALYZE; INFO: vacuuming "information_schema.sql_features" vacuumdb: vacuuming of database "pgcmisnlt1" failed: ERROR: invalid memory alloc request size 4294