Re: Bug #829: 7.3 crashes when trying to set variable to - Mailing list pgsql-bugs

From Neil Conway
Subject Re: Bug #829: 7.3 crashes when trying to set variable to
Date
Msg-id 1038779641.5915.71.camel@tokyo
Whole thread Raw
In response to Bug #829: 7.3 crashes when trying to set variable to default  (pgsql-bugs@postgresql.org)
List pgsql-bugs
On Sun, 2002-12-01 at 16:35, pgsql-bugs@postgresql.org wrote:
> alter user nobody set search_path to [something]
>
> and then
>
> alter user nobody set search_path to default
>
> (having already done this for my own username).
>
> The database server immediately crashes

Works for me:

template1=# select version();
                            version
----------------------------------------------------------------
 PostgreSQL 7.3rc2 on i686-pc-linux-gnu, compiled by GCC 2.95.4
(1 row)

template1=# create user nobody;
CREATE USER
template1=# create schema a;
CREATE SCHEMA
template1=# alter user nobody set search_path to 'a';
ALTER USER
template1=# alter user nobody set search_path to default;
ALTER USER
template1=#

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #831: RFE - Schema list from psql
Next
From: Rod Taylor
Date:
Subject: Re: contrib/adddepend does not properly re-create