error in schema alter database --- SET

From: frank_lupo <frank_lupo(at)email(dot)it>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: error in schema alter database --- SET
Date: 2003-01-27 15:33:44
Message-ID: H9DPW8$3BCD871BF67B63DB68AE76C920C3E731@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2003-01-28 09:24:58 Re: error in schema alter database --- SET
Previous Message Dave Page 2003-01-27 11:59:53 Re: Data migration plugin and mssql6