error in schema alter database --- SET - Mailing list pgadmin-hackers

In schema is present error when setting var to database or user.
The name of variable is quoted but the value no.

E.g 
pippo=# ALTER DATABASE gedis30 SET "TRANSACTION ISOLATION LEVEL" = read commi
tted\g
ERROR:  parser: parse error at or near "committed" at character 65
pippo=# ALTER DATABASE gedis30 SET "TRANSACTION ISOLATION LEVEL" = "read comm
itted"\g
ALTER DATABASE

Error in sub AddOrUpdate class UserVars, DatabaseVars

  szSQL = "ALTER DATABASE " & fmtID(Database) & " SET " & fmtID(Name) & " = " & dbSZ(Value) <<<<<<<<<<<< ERROR

  szSQL = "ALTER USER " & fmtID(szUser) & " SET " & fmtID(Name) & " = " & dbSZ(Value) <<<<<<<<<<<< ERROR



Bye !!
Frank Lupo (Wolf) !!

    /\_ _/\
    \ o o /
--ooo-----ooo---



--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Il vero Pomodoro San Marzano D.O.P. dell' Agro-Sarnese-Nocerino.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=981&d=27-1