Re: [ADMIN] Avoid casting NULLs in UNION...

2013-02-03 Thread Marko Rihtar
OK Albe, thanks for info 2013/2/1 Albe Laurenz > Marko Rihtar wrote: > > maybe you can help me with this issue. > > Here is an example > > > > SELECT NULL::integer > > UNION ALL > > SELECT NULL > > UNION ALL > > SELECT 123 > > > > For this sql to work i have to cast NULL to integer. > > I was w

[ADMIN] SSPI Authentication on Windows 2012 (for Win. Clients)

2013-02-03 Thread Dave Manginelli
I'm running PostgreSQL 9.2 on Windows Server 2012 and I've attempted to follow these instructions for single sign-on: http://wiki.postgresql.org/wiki/Configuring_for_single_sign-on_using_SSPI_on_Windows I followed the simplified instructions for 9.2 and successfully executed the setspn command rec