"tbz" writes:
> CREATE TABLE pg_user (
> login_name VARCHAR(50) NOT NULL
> );
> CREATE UNIQUE INDEX ak1_login_name ON pg_user(login_name);
> [fails]
This is expected, given the default search_path settings in which
pg_catalog is implicitly at the front of the path. When you create
pg_user, it's
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 log
