2.0 Documentation on browseable PGSQL
Hello Team,
On https://lemonldap-ng.org/documentation/2.0/browseablesessionbackend
We recommand creating the sessions tables like this :
CREATE UNLOGGED TABLE sessions (
id VARCHAR(64) NOT NULL PRIMARY KEY,
a_session text,
_whatToTrace text,
_session_kind text,
_utime BIGINT,
USER text,
ipAddr VARCHAR(64)
);
CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace text_pattern_ops);
CREATE INDEX _s1 ON sessions (_session_kind);
CREATE INDEX _u1 ON sessions (_utime);
CREATE INDEX ip1 ON sessions USING BTREE (ipAddr)
However when I run the exact command I got this error :
ERREUR: erreur de syntaxe sur ou près de « USER »
LIGNE 7 : USER text,
Ignoring the USER line it works okay.
Also should we add a warning concerning the creation on an Unlogged table, witch can be unsafe in some setups ?
Thanks