Hi Laurent!

As I stated, I get the error messages when opening the edit grid with a filter in pgAdmin or when running SQL from psql (standard command line interface of PG). In the SQL query dialogue window of pgAdmin I only get the error code. This problem has been reported shortly after release of v1.6.2 and (I think, correct me if I'm wrong) is fixed already. But we have to wait for the next release.

My report is concerned with the crashing, which is a more serious problem.

Regards
Erwin


[EMAIL PROTECTED] wrote:
Hello Erwin,

I am interested in the part "I get an error message with only the error code".

I have the same problem, however in the rest of your message you do have an error message with the error code " FEHLER: Fehler »Syntaxfehler« bei »loc«
    SQL state: 42601
    Character: 1"

How do you achieve this ?

My problem is that, if my database is in UTF-8, I will not get any error 
messages, just the code.
Is that the same for you ? Have you found a solution to have an error message ?
So far we have not been able to reproduce this error: it seems its due to my PG 
server configuration (Ubuntu with French locale), other configurations 
(including on WinXP machine) work fine.

Cheers,
[EMAIL PROTECTED]
The Computing Froggy

----- Message d'origine ----
De : Erwin Brandstetter <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.org
Envoyé le : Mercredi, 21 Février 2007, 2h06mn 21s
Objet : [pgadmin-support] Crashing v1.6.2 with a syntax error

Hi developers! Hi Dave!


Testing pgAdmin III v1.6.2 rev: 5837, client Win XP, host Debian Sarge, PG 8.1.4. / Debian Etch, PG 8.2.1.

I have found a 'reliable' way to crash pgAdmin. Look at the following query:
     select * from loc where loc like 'a%' loc = 'b';
Note the syntax error: "and" is missing in the WHERE clause. If I run this from the SQL query dialogue window I get an error message with only the error code - but that has been reported before.

    FEHLER: Fehler »Syntaxfehler« bei »loc«
    SQL state: 42601
    Character: 1

However, if I open the edit grid with a filter and enter the faulty WHERE clause, pgAdmin crashes. I have run tests with a variety of tables and operators in PG 8.1.4 and PG 8.2.1. Any of the following WHERE clauses triggers a crash.
    fld1 like 'a%' fld2 = 'b'
    fld1 = 'a%' fld2 = 'b'
    fld1 = 'a%' fld1 = '%a%'
    ...

The "essential" part ist the "%" at the end of the first string.


An observation I have made along the way:
Look at the error message I get from pgAdmin for the following WHERE clause:
    loc = '%a' loc = ''
Note that the % is in front this time (does not trigger a crash).

    An error has occurred:
    FEHLER: Fehler >>Syntaxfehler<< bei >>b<<
    Line 1: EXPLAIN SELECT * FROM loc WHERE loc = '0x1.1f9d8ap-997' loc = ''
                            ^
The string containing the character "%" is scrambled in a weird way. The caret in the next line points to a seemingly random position. If I run it from psql, I get a similar error message. Only the string is not scrambled, and the caret is in a reasonable position.

    event=# select * from loc where loc = '%a' loc = '';
    FEHLER:  Fehler »Syntaxfehler« bei »loc« at character 36
    ZEILE 1: select * from loc where loc = '%a' loc = '';
                                                ^
I have tried to switch the "user language" in the pgAdmin options from English to German. To no effect.

It might have to do with locales. From my postgresql.conf:
    lc_messages = '[EMAIL PROTECTED]'

I have tried changing it to:
    lc_messages = 'C'

After that the error message was scrambled differently:
    loc = '%a' loc = ''

    An error has occurred:
    ERROR: syntax error at or near "loc"
LINE 1: EXPLAIN SELECT * FROM loc WHERE loc = '0x1.518a0fp-1002' loc = ''
                                ^

But it crashes just as well.
    loc = 'a%' loc = ''


Regards
Erwin

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly





        

        
                
___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to