Thread: Error Message: ERROR: Unterminated quoted identifier
-- System Information -- Platform: Windows 2000 Version: 5.0 Build: 2195 Service Pack 2 -- Application Information -- Name: pgAdmin II Version: 1.6.0 Descripton: Name: pgSchema Version: 1.6.0 Descripton: PostgreSQL Schema Objects v1.6.0 -- Database Information -- Version: 7.2.1 Descripton: PostgreSQL 7.2.1 on i686-pc-winnt-msdev, compiled by msdev 6.0 -- Driver Information -- Name: PostgreSQL Version: 7.3.111 Descripton: PostgreSQL 7.2.1 on i686-pc-winnt-msdev, compiled by msdev 6.0 -- Error Information -- Description: ERROR: Unterminated quoted identifier Number: -2147467259 Routine: pgAdmin II:basActions.Drop ************************************************************ 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.
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
> -----Original Message----- > From: Hiroshi Saito [mailto:saito@inetrt.skcapi.co.jp] > Sent: 26 August 2003 22:24 > To: Reggie White > Cc: frank_lupo; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Error Message: ERROR: > Unterminated quoted identifier > > > If it is OK, Frank will apply it. Thanks Hiroshi, I got it! Reggie, please try the latest snapshot from http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin2/binaries/. Installation instructions are in the readme file. Regards, Dave.
> -----Original Message----- > From: Reggie White [mailto:reginaldwhite@cox.net] > Sent: 26 August 2003 06:29 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Error Message: ERROR: Unterminated > quoted identifier > > > This error happen when trying to drop a use defined type by > pressing <DEL>. Typing in 'DROP TYPE my_type' did work. > Hi, Can you recreate this error with logging (under Tools -> Options) set to SQL & Errors, and then sent the logfile please? Thanks, Dave.