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

------=_Part_1754_811434.1210326086448
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.Strobl@[EMAIL PROTECTED]
>:

>
> 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@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

------=_Part_1754_811434.1210326086448
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

No problems here.<br><br><br>create table regions (id integer, name
varchar);<br>alter table regions alter column name set default
&#39;bavaria&#39;;<br><br><br>PostgreSQL 8.3.1 vc++ build 1400 xp
sp2<br><br># - Memory -<br>
<br>shared_buffers = 32MB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # min 128kB or
max_connections*16kB<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # (change
requires restart)<br>#temp_buffers = 8MB&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min 800kB<br>temp_buffers =
8MB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min
800kB<br><br>
#max_prepared_transactions = 5&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # can
be 0 or more<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # (change requires restart)<br>#
Note:&nbsp; Increasing max_prepared_transactions costs ~600 bytes of
shared memory<br># per transaction slot, plus lock space (see
max_locks_per_transaction).<br>
#work_mem = 1MB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # min 64kB<br>work_mem = 2MB&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min
64kB<br>#maintenance_work_mem = 16MB&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
# min 1MB<br>maintenance_work_mem = 32MB&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; # min 1MB<br>max_stack_depth = 2MB&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # min 100kB<br>
<br><br><br><br>cheers<br><br><br>Josep<br><br><br><div
class="gmail_quote">2008/5/9  &lt;<a
href="mailto:Christian.Strobl@[EMAIL PROTECTED]
">Christian.Strobl@[EMAIL PROTECTED]
>&gt;:<br><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
hi all,<br>
<br>
first i create a table<br>
create table regions (id integer, name varchar);<br>
<br>
then i want to set a default value for a column, e.g.<br>
alter table regions alter column name set default &#39;bavaria&#39;;<br>
<br>
at this point crashes the database with the message<br>
<br>
PANIK: ERROR_STACK_SIZE exceeded<br>
<br>
the rest of the message is unfortunately in german then i have to<br>
restart the postgres-service manually this error is very easy<br>
reproducible at my environment<br>
<br>
is this a problem of my installation or can anybody reproduce this
error<br>
at his environment<br>
<br>
thanks and greetings from munich<br>
christian<br>
<br>
p.s. &nbsp; &nbsp;os windows xp, sp2<br>
 &nbsp; &nbsp; &nbsp; &nbsp;postgres 8.3.1, visual c++, build 1400<br>
<font color="#888888"><br>
--<br>
Sent via pgsql-general mailing list (<a
href="mailto:pgsql-general@[EMAIL PROTECTED]
">pgsql-general@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-general"
target="_blank">http://www.postgresql.org/mailpref/pgsql-general</a><br>
</font></blockquote></div><br>

------=_Part_1754_811434.1210326086448--