On Fri, 2004-10-08 at 14:45, XceXac XbdXaa wrote:
> psql:zouxian-data-bak:243910: PANIC: ERRORDATA_STACK_SIZE exceeded
> psql:zouxian-data-bak:243921: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while
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
Michael Kleiser <[EMAIL PROTECTED]> writes:
> test1=> select * from pg_indexes where tablename='foobar';
> schemaname | tablename | tablespace | indexname |
> indexdef
> +---++---+---
On PosgreSQl 8.0.0 beta 3 (on SuSE Linux 8.1) I tried this:
mkdir /opt/pgsql/data2
mkdir /opt/pgsql/data3
psql test1
test1=# CREATE TABLESPACE ts_test_1 OWNER testuser LOCATION '/opt/pgsql/data2';
CREATE TABLESPACE
test1=# CREATE TABLESPACE ts_test_2 OWNER testuser LOCATION '/opt/pgsql/data3';
CR
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
Yep !
You are right !
void=> \d users
Table "public.users"
Column | Type | Modifiers
+--+---
id | integer | default
nextval('u
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
Tom Lane wrote:
I believe there are known problems with BSD kernels sometimes returning
wrong clock readings on SMP machines, so that might be a place to look too.
Thanks Tom.
Just filled out a FreeBSD Bug Report, so we'll see how that goes.
:)
Regards and best wishes,
Justin Clift
regards, tom
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
