Strange syntax for create/drop index

From: Haris Peco <snpe(at)snpe(dot)co(dot)yu>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange syntax for create/drop index
Date: 2006-04-09 03:56:56
Message-ID: 200604090356.56869.snpe@snpe.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have tried create/drop index in separate schema :

example :
create table :

create table test.test(id integer not null,name varchar(30),constraint test_pkey primary key (id)) - ok
create index test_name on test.test(name) - ok
drop index test_name - not ok
drop index test.test_name - ok
create index test.test_name on test.test(name) - not ok

'drop index' request schema prefix, but 'create index' doesn't accept schema prefix

this is strange for me

Comments ?

Best
Peco

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2006-04-09 04:14:41 Re: More PostgreSQL conversion fun
Previous Message Stephen Frost 2006-04-09 03:33:27 Re: Debian package for freeradius_postgresql module