Tom Lane wrote:
David Rysdam <[EMAIL PROTECTED]> writes:
Why can't I have the same index name be on
different tables?
You can ... if they are in different schemas. Indexes and tables share
the same namespace, ie, they must be unique within a schema.
As for your original question, you prob
David Rysdam <[EMAIL PROTECTED]> writes:
> Why can't I have the same index name be on
> different tables?
You can ... if they are in different schemas. Indexes and tables share
the same namespace, ie, they must be unique within a schema.
As for your original question, you probably want somethin
And another thing, can't I do this:
create table s.a (blah);
create table s.b (blah);
create index myindex on s.a(blah);
create index myindex on s.b(blah);
? When I drop them I have to specify the schema name, so presumably it
tracks them that way. Why can't I have the same index name be on
dif
I have a script that automatically creates my database objects. In
order to automatically create indexes, it needs to first make sure they
don't exist.
For things like tables, this is easy:
select * from information_schema.tables where table_schema =
"" and table_name = ""
But for indexes it
