Reinier Olislagers wrote:
Subject to a maximum user name length of 31 characters on Firebird. The
manual suggests that PostgreSQL has a limit of 64.
If you're going to list all differences between PG and FB as you hit
them, you might put them on a wiki page for easy retrieval by others.
The table/trigger/sp/view/general object name max length in FB is about
32 bytes IIRC.
True, but I thought that a detail relating to something that people were
likely to do comparatively infrequently (i.e. user management by a
custom app rather than by something like Flamerobin) was worth getting
into the record.
I suppose you found out FB has an 8 char effective password? You can use
more letters but MASTERKE is the same as MASTERKEY. Of course this goes
away if you use trusted authentication/OS authentication.
I hadn't yet, but I was going to hash (etc.) the user's submission
anyway so that it could be stored and moved around without grave risk.
Which obviously introduces issues when communities with different salt
are merged... and so on :-)
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
