From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | dustin+pgsqlbugs(at)spy(dot)net |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Bug #829: 7.3 crashes when trying to set variable to |
Date: | 2002-12-01 21:54:01 |
Message-ID: | 1038779641.5915.71.camel@tokyo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Sun, 2002-12-01 at 16:35, pgsql-bugs(at)postgresql(dot)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(at)samurai(dot)com> || PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2002-12-01 22:00:21 | Re: contrib/adddepend does not properly re-create |
Previous Message | pgsql-bugs | 2002-12-01 21:44:07 | Bug #831: RFE - Schema list from psql |