[GENERAL] pgadmin 3 on windows 7 install

2015-03-22 Thread Yuri Budilov
Hello everyone, a new Postgresql user here. I installed the msi for pgadmin 3 on windows 7 and installed C++ redistributable from VS 2013 and 2005 too. Pgadmin exe crashes, can not find dll, msvcp120. It's all there in windows system 32 folder. So I copied to pgadmin folder, now it crashes with

Re: [GENERAL] create table if not exists xx AS select ...

2015-03-22 Thread Daniel Caldeweyher
Thanks Michael, I suppose I should have checked the docs for CREATE TABLE AS and not just CREATE TABLE :) Regards, Daniel On Mon, Mar 23, 2015 at 11:41 AM, Michael Paquier wrote: > On Mon, Mar 23, 2015 at 10:28 AM, Daniel Caldeweyher > wrote: > > I am not entirely sure if this is a bug (fail

Re: [GENERAL] create table if not exists xx AS select ...

2015-03-22 Thread Michael Paquier
On Mon, Mar 23, 2015 at 10:28 AM, Daniel Caldeweyher wrote: > I am not entirely sure if this is a bug (fails on 9.3 and 9.4) or working as > intended: > [...] > create table test2 as > select * from test where 1=0; This works as intended, CREATE TABLE AS does not support IF NOT EXISTS in 9.4 and

[GENERAL] create table if not exists xx AS select ...

2015-03-22 Thread Daniel Caldeweyher
Hi All, I am not entirely sure if this is a bug (fails on 9.3 and 9.4) or working as intended: create table if not exists test ( foo boolean ); create table if not exists test2 as select * from test where 1=0; /* ERROR: syntax error at or near "as" LINE 1: create table if not exists test2 as */

Re: [GENERAL] Unicode license compatibility with PostgreSQL license

2015-03-22 Thread Haribabu Kommi
On Fri, Mar 20, 2015 at 5:54 AM, Peter Geoghegan wrote: > On Wed, Mar 18, 2015 at 11:03 PM, Haribabu Kommi > wrote: >> For our next set of development activities in PostgreSQL, we want to >> use the Unicode organization code with PostgreSQL to open source that >> feature. Is the Unicode license i