The following bug has been logged online: Bug reference: 5630 Logged by: tbz Email address: t...@vollbio.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 ---------- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
