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

Thanks Frank, fixed in CVS.

Regards, Dave.

> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo@email.it]
> Sent: 27 January 2003 15:34
> To: pgadmin-hackers
> Subject: [pgadmin-hackers] error in schema alter database --- SET
>
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster