Re: reproducible database crash with simple sql command on postgres 8.3.1

No problems here.

create table regions (id integer, name varchar);
alter table regions alter column name set default 'bavaria';

PostgreSQL 8.3.1 vc++ build 1400 xp sp2

# - Memory -

shared_buffers = 32MB # min 128kB or max_connections*16kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
temp_buffers = 8MB # min 800kB

#max_prepared_transactions = 5 # can be 0 or more
# (change requires restart)
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared
memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
#work_mem = 1MB # min 64kB
work_mem = 2MB # min 64kB
#maintenance_work_mem = 16MB # min 1MB
maintenance_work_mem = 32MB # min 1MB
max_stack_depth = 2MB # min 100kB

cheers

Josep

2008/5/9 <Christian(dot)Strobl(at)dlr(dot)de>:

>
> hi all,
>
> first i create a table
> create table regions (id integer, name varchar);
>
> then i want to set a default value for a column, e.g.
> alter table regions alter column name set default 'bavaria';
>
> at this point crashes the database with the message
>
> PANIK: ERROR_STACK_SIZE exceeded
>
> the rest of the message is unfortunately in german then i have to
> restart the postgres-service manually this error is very easy
> reproducible at my environment
>
> is this a problem of my installation or can anybody reproduce this error
> at his environment
>
> thanks and greetings from munich
> christian
>
> p.s. os windows xp, sp2
> postgres 8.3.1, visual c++, build 1400
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>