Re: [GENERAL] Unicode license compatibility with PostgreSQL license
On Fri, Mar 20, 2015 at 5:54 AM, Peter Geoghegan peter.geoghega...@gmail.com wrote: On Wed, Mar 18, 2015 at 11:03 PM, Haribabu Kommi kommi.harib...@gmail.com 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 is compatible with PostgreSQL. Do you mean that you'd like to add ICU support? I think that would be extremely interesting, FWIW. The stability of ICU collations would be quite helpful from a number of different perspective. One of which is that having a contract about the stability of strxfrm()-style binary keys would allow me to make text abbreviated keys exploited in the internal pages of B-Tree indexes, to greatly reduce cache misses with index scans on text attributes. This general technique already been very effective with sorting [1], but it feels likely that we'll need ICU to make the abbreviation technique useful for indexes. [1] http://pgeoghegan.blogspot.com/2015/01/abbreviated-keys-exploiting-locality-to.html Hi All, Thanks for the information. we are just evaluating some conversion algorithms to convert from UTF32/16 to UTF8 and vice versa. Regards, Hari Babu Fujitsu Australia -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] create table if not exists xx AS select ...
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 */ create table test2 as select * from test where 1=0; Thanks Daniel
Re: [GENERAL] create table if not exists xx AS select ...
On Mon, Mar 23, 2015 at 10:28 AM, Daniel Caldeweyher daniel.caldewey...@pricefinder.com.au 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 9.3: http://www.postgresql.org/docs/9.3/static/sql-createtableas.html http://www.postgresql.org/docs/9.4/static/sql-createtableas.html But it does in 9.5 and onwards: http://www.postgresql.org/docs/devel/static/sql-createtableas.html Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] create table if not exists xx AS select ...
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 michael.paqu...@gmail.com wrote: On Mon, Mar 23, 2015 at 10:28 AM, Daniel Caldeweyher daniel.caldewey...@pricefinder.com.au 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 9.3: http://www.postgresql.org/docs/9.3/static/sql-createtableas.html http://www.postgresql.org/docs/9.4/static/sql-createtableas.html But it does in 9.5 and onwards: http://www.postgresql.org/docs/devel/static/sql-createtableas.html Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] pgadmin 3 on windows 7 install
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 access violation. Help please.