Strange syntax for create/drop index - Mailing list pgsql-general

From Haris Peco
Subject Strange syntax for create/drop index
Date
Msg-id 200604090356.56869.snpe@snpe.co.yu
Whole thread Raw
Responses Re: Strange syntax for create/drop index  (Michael Glaesemann <grzm@myrealbox.com>)
List 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

pgsql-general by date:

Previous
From: "Guy Rouillier"
Date:
Subject: Re: More PostgreSQL conversion fun
Next
From: Stephen Frost
Date:
Subject: Re: Debian package for freeradius_postgresql module