On Sep 12, 2004, at 2:48 PM, Michael Glaesemann wrote:
On Sep 12, 2004, at 5:42 AM, [EMAIL PROTECTED] wrote:
Is the syntax "schema_name.index_name" for create unique index wrong, unsupported or what? I know is doesn't work as postgres kicks me back a syntax error each time (version 7.3.2 & 7.4.5). -sigh-
Could you give a full example (including the error) of what you're doing? It's kind of hard to give a suggestion based on your brief description.
Also, looking quickly at the online docs, we find :
name
The name of the index to be created. No schema name can be included here; the index is always created in the same schema as its parent table.
<http://www.postgresql.org/docs/current/static/sql-createindex.html>
Michael
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
