Re: OT: Calling SQL experts

[Alan Chandler <alan@chandlerfamily.org.uk>]

On Saturday 16 April 2005 18:47, Chris Boot wrote:
> Alan Chandler wrote:
> >Can someone tell me the scope of the various SQL names.  I have googled
> > around all afternoon looking for a document that defines it and can find
...
>
> cerberus=# create table foo_table ( id INTEGER );
> CREATE TABLE
> cerberus=# create table bar_table ( id INTEGER );
> CREATE TABLE
> cerberus=# CREATE INDEX foo_idx ON foo_table (id);
> CREATE INDEX
> cerberus=# CREATE INDEX foo_idx ON bar_table (id);
> ERROR:  relation "foo_idx" already exists
> cerberus=# CREATE INDEX bar_idx ON bar_table (id);
> CREATE INDEX
> cerberus=#

Thanks - exactly what I needed to know.  I am going to have to add the table 
prefix to the index names( harder - but doable).

-- 
Alan Chandler
http://www.chandlerfamily.org.uk