| 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: | Whole Thread | Raw Message | 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 |