Hi,
I just produced and error message when trying to drop a constraint on a table
which is in a schema with a mixed-case name.
---------------------------
pgAdmin III
---------------------------
An error has occurred:
ERROR: schema "mycomponent" does not exist
---------------------------
OK
---------------------------
Where the schema is called "MyComponent". A couple of extra quotes should fix
it. It drops ok via psql (with quoting).
(Win XP, PGAdmin 1.6.1, Postgres 8.2)
Cheers.
___________________________________________________________
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" – The
Wall Street Journal
http://uk.docs.yahoo.com/nowyoucan.html
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
