Create script for user have a serious bug:
CREATE USER test
WITH SYSID 101
PASSWORD ENCRYPTED md5c104555d849cf47bd82febf072dd479c
NOCREATEDB NOCREATEUSER;
and it should be :
CREATE USER test
WITH SYSID 101
ENCRYPTED PASSWORD 'md5c104555d849cf47bd82febf072dd479c'
NOCREATEDB NOCREATEUSER;
Please change the order of ENCRYPTED and PASSWORD keywords and quote the
password string, or should I do the patch ?
Regards !
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match