Postgres Pro
Downloads
Home   >   mailing lists

Thread: Bug in PGAdmin III 1.2.0 Beta

Bug in PGAdmin III 1.2.0 Beta

From
"TaRRaDeLo"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-GB">Hi, I don’t known if that`s a bug:</span></font><span lang="EN-GB"
style="mso-ansi-language:EN-GB"></span><pclass="MsoNormal"><font face="Times New Roman" size="3"><span lang="EN-GB"
style="font-size:12.0pt;mso-ansi-language:EN-GB"> </span></font><pclass="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB">when i create a new table, and i include a varchar o char field, i
obtainthis error : "Error: syntax error at or near "(" at character xxx"</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB">the bug is in the specification of sql query, varchar, char datatypes
arequoted</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB">if i copy the sql especification ofthe table to query tool, and i
removethe quotes from char types i execute the query normally.</span></font><p class="MsoNormal"><font face="Times New
Roman"size="3"><span style="font-size: 
12.0pt"> </span></font><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:Arial;mso-ansi-language:EN-GB"></span></font><pclass="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB">Thanks!!!</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-GB">TaRRaDeLo</span></font></div>

Re: Bug in PGAdmin III 1.2.0 Beta

From
"Dave Page"
Date:
Hi
 
This is a known bug in beta 2 that has already been fixed.
 
Thanks for the report though.
 
Regards, Dave.

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of TaRRaDeLo
Sent: 10 October 2004 21:00
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Bug in PGAdmin III 1.2.0 Beta

 

Hi, I don’t known if that`s a bug:

 

when i create a new table, and i include a varchar o char field, i obtain this error : "Error: syntax error at or near "(" at character xxx"

 

the bug is in the specification of sql query, varchar, char datatypes are quoted

 

 

if i copy the sql especification ofthe table to query tool, and i remove the quotes from char types i execute the query normally.

 

Thanks!!!

 

TaRRaDeLo