Re: Error Message: ERROR: Unterminated quoted identifier - Mailing list pgadmin-support

Dear Reggie White.

From: "Reggie White" <reginaldwhite@cox.net>
(snip)
> ************************************************************
>
> Insert your comment:
>
> This error happen when trying to drop a use defined type by pressing
<DEL>.
> Typing in 'DROP TYPE my_type' did work.

It may be a reliable problem...
Try to apply the next patch.

--- pgschema/Types.cls.orig     Wed Aug 27 06:16:28 2003
+++ pgschema/Types.cls  Wed Aug 27 06:17:19 2003
@@ -327,7 +327,7 @@Dim szSQL As String
  'Generate/Execute SQL to drop the Type.
-  szSQL = "DROP TYPE " & mCol(ULEncode(Key)).FormattedID & QUOTE
+  szSQL = "DROP TYPE " & mCol(ULEncode(Key)).FormattedID  objServer.ExecSQL szSQL, cnDatabase
  'If we get this far, then we can't have errored,

If it is OK, Frank will apply it.
Regards,
Hiroshi Saito