From: | "tbz" <tbb(at)vollbio(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5630: CREATE INDEX does not use schema search path |
Date: | 2010-08-27 14:56:48 |
Message-ID: | 201008271456.o7REumna028567@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5630
Logged by: tbz
Email address: tbb(at)vollbio(dot)de
PostgreSQL version: 8.3.11
Operating system: Debian Sqeeze
Description: CREATE INDEX does not use schema search path
Details:
1. Create a new schema like a login user
2. Write a script, that creates a new table pg_user (system table!) and
seperately an index on it
3. Run the script
The table is created in the "user" schema. The creating of the index results
in
[Error Code: 0, SQL State: 42501] FEHLER: Berechtigung nur für
Eigentümer der Relation pg_user
I have to use the full qualified table name while creating the index.
pg_user seems to be a system table, but I think this error will also be
occured, when there is an table with an identical name in schema public.
Bye Thomas
---------- Snip ----------
CREATE TABLE pg_user (
login_name VARCHAR(50) NOT NULL
);
CREATE UNIQUE INDEX ak1_login_name ON pg_user(login_name);
---------- Snap ----------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-08-27 15:11:29 | Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART |
Previous Message | Alexsander Rosa | 2010-08-27 13:21:45 | Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART |