Postgres Pro
Downloads
Home   >   mailing lists

Re: wrong message when trying to create an already existing index - Mailing list pgsql-general

From legrand legrand
Subject Re: wrong message when trying to create an already existing index
Date
Msg-id 1520708017041-0.post@n3.nabble.com
Whole thread Raw
In response to Re: wrong message when trying to create an already existing index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
> regression=# create index mv1 on t1 (f1);
...
> ERROR:  materialized view "mv1" already exists 

Is in fact the one I prefer ;^)

I come from a DBMS world where Tables and Indexes do not share the same name
space,
and have to change my mind !

Thanks you Tom for pointing that.

Regards
PAscal




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

pgsql-general by date:

Previous
From: Ryan Murphy
Date:
Subject: Is there a way to create a functional index that tables tableoidcolumn as an arg?
Next
From: David Rowley
Date:
Subject: Re: Is there a way to create a functional index that tables tableoidcolumn as an arg?