On 10-3-2013 21:56, Mark Morgan Lloyd wrote: > Reinier Olislagers wrote: >> I've written a demo application that: >> uses regular TIBConnection and SQL commands to >> 1. create a new db on a server >> 2. create a user with GRANT ADMIN ROLE and full control over the new db <snip> > > 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. 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 suppose things'll change in FB 3 though. When that is released... probably around the release of FPC 2.8 :) _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
