Re: Re: sessions/cookies issues with postgres

[Mortimer Cladwell]

Hi Nala,

One issue I see with Postgres is that double quotes are not allowed in SQL statements eg:

postgres=> select * from Sessions  where sid="6ec92c0efde92a4837843cbfd77ee3ca" and valid="1" limit 1 ;
ERROR:  column "6ec92c0efde92a4837843cbfd77ee3ca" does not exist
LINE 1: select * from Sessions  where sid="6ec92c0efde92a4837843cbfd...
                                          ^
postgres=> select * from Sessions  where sid='6ec92c0efde92a4837843cbfd77ee3ca' and valid='1' limit 1 ;
               sid                | data |            expires            |  client   | valid
----------------------------------+------+-------------------------------+-----------+-------
 6ec92c0efde92a4837843cbfd77ee3ca | ()   | Mon, 02 Nov 2020 22:19:33 GMT | 127.0.0.1 |     1
(1 row)

So I think that means #:auth and #:session are not usable with Postgres

Thanks

Mortimer