Обсуждение: 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

M S wrote:
> 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

Thanks, fixed in SVN.

Regards, Dave