Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group