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