Error dropping constraint (case sensitivity)

From: M S <arthur_ringworn(at)yahoo(dot)co(dot)uk>
To: pgadmin <pgadmin-support(at)postgresql(dot)org>
Subject: Error dropping constraint (case sensitivity)
Date: 2006-12-15 14:27:44
Message-ID: 20061215142744.66329.qmail@web25011.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-12-15 14:54:19 Re: Error dropping constraint (case sensitivity)
Previous Message Dave Page 2006-12-15 14:19:44 Re: Menu accelerators don't work when another window