Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Error dropping constraint (case sensitivity)

Error dropping constraint (case sensitivity)



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



Home | Main Index | Thread Index

top