Login with LDAP authentication takes 5 seconds

2018-05-29 Thread Andreas Schmid
Hi, I configured my PostgreSQL 10 DB on Debian 9.2 with LDAP authentication (simple bind mode). While this basically works, it has the strange effect that the first login with psql takes around 5 seconds. When I reconnect within 60 seconds, the login completes immediately. The LDAP server is beh

Re: Login with LDAP authentication takes 5 seconds

2018-06-04 Thread Andreas Schmid
v6 requests properly... I'll check with my IT. Thank you again, folks. Andy On 31 May 2018 at 16:54, Achilleas Mantzios wrote: > On 28/05/2018 17:26, Andreas Schmid wrote: > > Hi, > > I configured my PostgreSQL 10 DB on Debian 9.2 with LDAP authentication > (simple bind mo

UNION ALL: Apparently based on column order rather than on column name or alias

2018-12-06 Thread Andreas Schmid
Hi list I realized the following behaviour of UNION ALL: SELECT 'a' AS col1, 'b' AS col2 UNION ALL SELECT 'c' AS col1, 'd' AS col2; returns: col1 | col2 --+-- a| b c| d Now I switch the column aliases in the second SELECT-Statement: SELECT 'a' AS col1, 'b' AS col2 UNION ALL