Re: [BUGS] Unable to dump database/table

2004-10-11 Thread Andre Maasikas
On Mon, 11 Oct 2004, Krok wrote: > void=> select max(length(passwd)) from users; > max > --- > 536870919 > (1 row) > > But how can this happen, that varchar(255) field became broken ? > According to my caclulator, in hex this is 0x2007 so there's likely a bit flip if th

Re: [BUGS] Unable to dump database/table

2004-10-11 Thread Tom Lane
Krok <[EMAIL PROTECTED]> writes: > But how can this happen, that varchar(255) field became broken ? I'd wonder about flaky memory or flaky disk drive, for starters ... regards, tom lane ---(end of broadcast)--- TIP 6: Have y

Re: [BUGS] Unable to dump database/table

2004-10-11 Thread Krok
Yep ! You are right ! void=> \d users Table "public.users" Column | Type | Modifiers +--+--- id | integer | default nextval('u

Re: [BUGS] Unable to dump database/table

2004-10-11 Thread Tom Lane
Krok <[EMAIL PROTECTED]> writes: > pg_dump: dumping contents of table users > pg_dump: ERROR: out of memory > DETAIL: Failed on request of size 536870920. > pg_dump: SQL command to dump the contents of table "users" failed: > PQendcopy() failed. > pg_dump: Error message from server: ERROR: out

[BUGS] Unable to dump database/table

2004-10-11 Thread Krok
Hello. pg_dump cann't dump some databases (at least one table) with the following error ; $ pg_dump -b -F c -v -f pgdump_void_2004-10-11T03:04:00 void pg_dump: saving encoding pg_dump: saving database definition pg_dump: reading schemas pg_dump: reading user-defined types pg_dump: reading user-de