| From: | "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp> |
|---|---|
| To: | "Reggie White" <reginaldwhite(at)cox(dot)net> |
| Cc: | "frank_lupo" <frank_lupo(at)email(dot)it>, <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Error Message: ERROR: Unterminated quoted identifier |
| Date: | 2003-08-26 21:23:31 |
| Message-ID: | 02da01c36c18$4cf44e40$1f324d80@w2k |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Dear Reggie White.
From: "Reggie White" <reginaldwhite(at)cox(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2003-08-26 21:46:51 | Re: Error Message: ERROR: Unterminated quoted identifier |
| Previous Message | Dave Page | 2003-08-26 20:40:59 | Re: Error Message: ERROR: must be called under standalone postgres with -O -P options |