Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group