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
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 |