Postgres Pro
Downloads
Home   >   mailing lists

Error dropping constraint (case sensitivity) - Mailing list pgadmin-support

From M S
Subject Error dropping constraint (case sensitivity)
Date
Msg-id 20061215142744.66329.qmail@web25011.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: Error dropping constraint (case sensitivity)  (Dave Page <dpage@postgresql.org>)
List pgadmin-support
Tree view 
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

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Menu accelerators don't work when another window
Next
From: Dave Page
Date:
Subject: Re: Error dropping constraint (case sensitivity)