Re: sessions/cookies issues with postgres

[Nala Ginrut]

Hi Mortimer!
I patched ssql.scm in the branch fix/ssql, could you try this branch?
If it's OK then I'd merge it to master.

Best regards.


Mortimer Cladwell writes:

> 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


--
GNU Powered it
GPL Protected it
GOD Blessed it
HFG - NalaGinrut
Fingerprint F53B 4C56 95B5 E4D5 6093 4324 8469 6772 846A 0058

signature.asc
Description: PGP signature