Re: [HACKERS] PostgreSQL Service on Windows does not start. ~ is not a valid Win32 application

2013-10-31 Thread Sandeep Thakkar
Services are started with the system privileges. If somebody is able to place that .exe in the specified directory, then it will be executed on service start. So, yes, I too agree with Asif that it is an important issue and should be fixed in the code at the earliest. On Thu, Oct 31, 2013 at

Re: [HACKERS] Fast insertion indexes: why no developments

2013-10-31 Thread Leonardo Francalanci
Jeff Janes wrote True, but that is also true of indexes created in bulk. It all has to reach disk eventually-- [...] If the checkpoint interval is as long as the partitioning period, then hopefully the active index buffers get re-dirtied while protected in shared_buffers, and only get

Re: [HACKERS] Fast insertion indexes: why no developments

2013-10-31 Thread Leonardo Francalanci
Gavin Flower-2 wrote How about being able to mark indexes: 'MEMORY ONLY' to make them not go to disk and 'PERSISTENT | TRANSIENT' to mark if they should be recreated on machine bootup? I would love that. But: 1) I'd like to make some tests with a memory drive, and confirm that in

Re: [HACKERS] Something fishy happening on frogmouth

2013-10-31 Thread Heikki Linnakangas
On 30.10.2013 18:52, Robert Haas wrote: Here's a short summary of what I posted back in August: at system startup time, the postmaster creates one dynamic shared segment, called the control segment. That segment sticks around for the lifetime of the server and records the identity of any

Re: [HACKERS] Something fishy happening on frogmouth

2013-10-31 Thread Andres Freund
Hi, On 2013-10-31 11:33:28 +0200, Heikki Linnakangas wrote: Wait, that sounds horrible. If you kill -9 the server, and then rm -rf $PGDATA, the shared memory segment is leaked until next reboot? I find that unacceptable. There are many scenarios where you never restart postmaster after a

[HACKERS] Add accurate option to pgbench

2013-10-31 Thread Mitsumasa KONDO
Hi, I create pgbench patch that adding accurate option in benchmark, and submit it in CF3. It is simple option to get more accurate benchmark result and to avoid miss benchmark result in pgbench. Logic of this option is under following. 1. execute cluster command to sort records. 2. execute

[HACKERS] Using indices for UNION.

2013-10-31 Thread Kyotaro HORIGUCHI
Hello, This patch might be too complicated (and seems somewhat ad hoc) for the gain, but more index usage for this kind of operation should be worth doing. Currently, PostgreSQL ignores from the very first the availablity of indexes for UNION. Sorting and SeqScan is choosed as follows, * EX.1

[HACKERS] Get more from indices.

2013-10-31 Thread Kyotaro HORIGUCHI
Hello, This is the last episode of the 'dance with indices'? series. Unique indexes can sort the tuples in corresponding tables prefectly. So this query might can use index. uniquetest=# create table t (a int, b int, c int, d text); uniquetest=# create unique index i_t_pkey on t(a, b);

[HACKERS] Show lossy heap block info in EXPLAIN ANALYZE for bitmap heap scan

2013-10-31 Thread Etsuro Fujita
=0) (actual time=22.821..22.821 rows=100047 loops=1) Index Cond: ((col2 = 0.01::double precision) AND (col2 = 0.02::double precision)) Total runtime: 1129.334 ms (7 rows) Comments welcome. Thanks, Best regards, Etsuro Fujita explain-bitmapscan-20131031.patch Description: Binary data

Re: [HACKERS] OSX doesn't accept identical source/target for strcpy() anymore

2013-10-31 Thread Andres Freund
On 2013-10-29 02:29:03 +0100, Andres Freund wrote: 3. valgrind gets floating point computations for exp(larger_negative_double) wrong and returns the wrong error message: regression=# SELECT exp(-808.3::float8); ERROR: value out of range: overflow exp sets errno=ERANGE and returns inf.

Re: [HACKERS] Show lossy heap block info in EXPLAIN ANALYZE for bitmap heap scan

2013-10-31 Thread Fujii Masao
On Thu, Oct 31, 2013 at 7:54 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: Hi, I think that lossy-heap-block information for a bitmap heap scan, not just Rows Removed by Index Recheck information, would also be a clue used to tune work_mem for better performance especially when the

Re: [HACKERS] Something fishy happening on frogmouth

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 5:50 AM, Andres Freund and...@2ndquadrant.com wrote: On 2013-10-31 11:33:28 +0200, Heikki Linnakangas wrote: Wait, that sounds horrible. If you kill -9 the server, and then rm -rf $PGDATA, the shared memory segment is leaked until next reboot? I find that unacceptable.

Re: [HACKERS] PostgreSQL Service on Windows does not start. ~ is not a valid Win32 application

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 1:44 AM, Asif Naeem anaeem...@gmail.com wrote: On Thu, Oct 31, 2013 at 10:17 AM, Amit Kapila amit.kapil...@gmail.com wrote: On Tue, Oct 29, 2013 at 12:46 PM, Naoya Anzai anzai-na...@mxu.nes.nec.co.jp wrote: Hi Sandeep I think, you should change the subject line

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Robert Haas
On Wed, Oct 30, 2013 at 5:32 PM, Tom Lane t...@sss.pgh.pa.us wrote: MauMau maumau...@gmail.com writes: From: Tom Lane t...@sss.pgh.pa.us Yeah, but what shall we replace it with? And can we preserve the API contrib/uuid-ossp offers? (Maybe we shouldn't even try, but just deprecate that

[HACKERS] [bug fix] PostgreSQL fails to start on Windows if it crashes after tablespace creation

2013-10-31 Thread MauMau
Hello, I've found and fixed a bug that causes recovery (crash recovery, PITR) to fail. Please find attached the patch against HEAD. [Bug] To reproduce the problem, do the following on Windows: 1. pg_ctl start 2. CREATE TABLESPACE tbs LOCATION 'some_tblspc_path'; 3. pg_ctl stop -mi 4.

Re: [HACKERS] Creating partial index on a relation

2013-10-31 Thread Kevin Grittner
naman.iitb naman.b...@gmail.com wrote: An example of partial index that i need is if my My table1 schema is (a int ,b int ,c int) index on c where a is null, b is null and c is not null Your question is not very clear, but perhaps you are looking for something like this: CREATE INDEX index1

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Andres Freund
On 2013-10-31 08:22:14 -0400, Robert Haas wrote: On Wed, Oct 30, 2013 at 5:32 PM, Tom Lane t...@sss.pgh.pa.us wrote: MauMau maumau...@gmail.com writes: Note the lack of enthusiasm for taking on maintainership of the OSSP code. Pushing it into core would mean that we're buying into that

Re: [HACKERS] Creating partial index on a relation

2013-10-31 Thread Craig Ringer
On 10/29/2013 04:15 PM, naman.iitb wrote: So is there a way to populate manually IndexStmt--whereClause Unless you have an _extremely_ compelling reason, you should probably just use the SPI routines to execute a CREATE INDEX command. -- Craig Ringer

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread MauMau
From: Robert Haas robertmh...@gmail.com ISTM that the biggest problem is that we don't have a random number generator which generates enough bits of randomness to implement uuid_generate_v3. I think relatively few people would cry if we didn't support uuid_generate_v1(), and the others all look

[HACKERS] pg_fallocate

2013-10-31 Thread Mitsumasa KONDO
Hi, I'l like to add fallocate() system call to improve sequential read/write peformance. fallocate() system call is different from posix_fallocate() that is zero-fille algorithm to reserve continues disk space. fallocate() is almost less overhead alogotithm to reserve continues disk space than

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Peter Eisentraut
On 10/30/13, 12:43 PM, Tom Lane wrote: Alvaro Herrera alvhe...@2ndquadrant.com writes: At this point, I think we need to consider ossp-uuid as dead code. Yeah, but what shall we replace it with? One possibility: https://github.com/petere/pglibuuid Not sure whether that has a chance of

Re: [HACKERS] [bug fix] PostgreSQL fails to start on Windows if it crashes after tablespace creation

2013-10-31 Thread Andrew Dunstan
On 10/31/2013 08:40 AM, MauMau wrote: Hello, I've found and fixed a bug that causes recovery (crash recovery, PITR) to fail. Please find attached the patch against HEAD. [Bug] To reproduce the problem, do the following on Windows: 1. pg_ctl start 2. CREATE TABLESPACE tbs LOCATION

Re: [HACKERS] [bug fix] PostgreSQL fails to start on Windows if it crashes after tablespace creation

2013-10-31 Thread MauMau
From: Andrew Dunstan and...@dunslane.net Why are you making this a runtime check instead of a compile time check? I thought the same situation could happen as in destroy_tablespace_directories(), but it doesn't seem to apply on second thought. Revised patch attached, which is very simple

Re: [HACKERS] appendStringInfo vs appendStringInfoString

2013-10-31 Thread Alvaro Herrera
Robert Haas escribió: So, does that mean we're good to go? Looks fine to me ... -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] Something fishy happening on frogmouth

2013-10-31 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Oct 31, 2013 at 5:50 AM, Andres Freund and...@2ndquadrant.com wrote: On 2013-10-31 11:33:28 +0200, Heikki Linnakangas wrote: Wait, that sounds horrible. If you kill -9 the server, and then rm -rf $PGDATA, the shared memory segment is leaked

Re: [HACKERS] Something fishy happening on frogmouth

2013-10-31 Thread Andres Freund
On 2013-10-31 10:29:17 -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Oct 31, 2013 at 5:50 AM, Andres Freund and...@2ndquadrant.com wrote: On 2013-10-31 11:33:28 +0200, Heikki Linnakangas wrote: Wait, that sounds horrible. If you kill -9 the server, and then rm

Re: [HACKERS] Something fishy happening on frogmouth

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 10:29 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Oct 31, 2013 at 5:50 AM, Andres Freund and...@2ndquadrant.com wrote: On 2013-10-31 11:33:28 +0200, Heikki Linnakangas wrote: Wait, that sounds horrible. If you kill -9 the

[HACKERS] ERROR during end-of-xact/FATAL

2013-10-31 Thread Noah Misch
CommitTransaction() and AbortTransaction() both do much work, and large portions of that work either should not or must not throw errors. An error during either function will, as usual, siglongjmp() out. Ordinarily, PostgresMain() will regain control and fire off a fresh AbortTransaction(). The

Re: [HACKERS] Get more from indices.

2013-10-31 Thread Tom Lane
Kyotaro HORIGUCHI horiguchi.kyot...@lab.ntt.co.jp writes: Unique indexes can sort the tuples in corresponding tables prefectly. So this query might can use index. uniquetest=# create table t (a int, b int, c int, d text); uniquetest=# create unique index i_t_pkey on t(a, b); uniquetest=#

Re: [HACKERS] [bug fix] PostgreSQL fails to start on Windows if it crashes after tablespace creation

2013-10-31 Thread MauMau
From: MauMau maumau...@gmail.com I thought the same situation could happen as in destroy_tablespace_directories(), but it doesn't seem to apply on second thought. Revised patch attached, which is very simple based on compile time check. Sorry, I was careless to leave an old comment. Please

[HACKERS] SP-GiST bug and fix

2013-10-31 Thread Teodor Sigaev
SP-GiST has a bug during creation: % create table ranges as select int4range( (random()*5)::int, (random()*5)::int+5) as range from generate_series(1,100) x; % create index ranges_range_spgist_idx on ranges using spgist(range); ERROR: unexpected

Re: [HACKERS] Get more from indices.

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 10:59 AM, Tom Lane t...@sss.pgh.pa.us wrote: However, if the index is unique, wouldn't scanning the index produce data that actually satisfies the longer sort key? It doesn't matter what the values of c,d are if there are no duplicates in the a,b columns. So maybe as

[HACKERS] Reference to parent query from ANY sublink

2013-10-31 Thread Antonin Houska
So far, a suquery of ANY sublink located in WHERE/ON clause can't reference vars exactly one level up, as long as pull-up into the join tree is expected. Now that we have LATERAL subqueries (there seem to be no specifics of SEMI JOIN when it comes to parameterization etc), I think this restriction

[HACKERS] API bug in DetermineTimeZoneOffset()

2013-10-31 Thread Tom Lane
DetermineTimeZoneOffset thinks that if the passed pg_tz parameter is equal to session_timezone, it should pay attention to HasCTZSet/CTimeZone and allow those to override the pg_tz. The folly of this is revealed by bug #8572, wherein timestamptz input that explicitly specifies a timezone name is

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Garick Hamlin
On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: From: Robert Haas robertmh...@gmail.com ISTM that the biggest problem is that we don't have a random number generator which generates enough bits of randomness to implement uuid_generate_v3. I think relatively few people would cry if we

Re: [HACKERS] API bug in DetermineTimeZoneOffset()

2013-10-31 Thread Alvaro Herrera
Tom Lane wrote: I think that we should change this function to follow the API convention used by timestamp2tm(), namely that one passes a NULL pointer if one would like session_timezone/HasCTZSet/CTimeZone to control the result. A non-null pointer should mean to use that zone specification,

Re: [HACKERS] Get more from indices.

2013-10-31 Thread Tom Lane
I wrote: Kyotaro HORIGUCHI horiguchi.kyot...@lab.ntt.co.jp writes: Unique indexes can sort the tuples in corresponding tables prefectly. So this query might can use index. BTW, how much of any of this is correct if the unique index contains multiple NULL values? We might need to restrict the

Re: [HACKERS] API bug in DetermineTimeZoneOffset()

2013-10-31 Thread Tom Lane
Alvaro Herrera alvhe...@2ndquadrant.com writes: ... So, perhaps, instead of having the code check session_timezone explicitely, have the caller pass it down. This consideration probably shouldn't drive a backpatchable fix, however. Well, it's impossible to do that in a back-patchable way,

Re: [HACKERS] Add accurate option to pgbench

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 6:36 AM, Mitsumasa KONDO kondo.mitsum...@gmail.com wrote: Hi, I create pgbench patch that adding accurate option in benchmark, and submit it in CF3. It is simple option to get more accurate benchmark result and to avoid miss benchmark result in pgbench. Logic of

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 1:02 PM, Garick Hamlin gham...@isc.upenn.edu wrote: On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: From: Robert Haas robertmh...@gmail.com ISTM that the biggest problem is that we don't have a random number generator which generates enough bits of randomness to

Re: [HACKERS] pg_fallocate

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 9:16 AM, Mitsumasa KONDO kondo.mitsum...@gmail.com wrote: I'l like to add fallocate() system call to improve sequential read/write peformance. fallocate() system call is different from posix_fallocate() that is zero-fille algorithm to reserve continues disk space.

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Garick Hamlin
On Thu, Oct 31, 2013 at 01:59:04PM -0400, Robert Haas wrote: On Thu, Oct 31, 2013 at 1:02 PM, Garick Hamlin gham...@isc.upenn.edu wrote: On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: From: Robert Haas robertmh...@gmail.com ISTM that the biggest problem is that we don't have a

Re: [HACKERS] API bug in DetermineTimeZoneOffset()

2013-10-31 Thread Tom Lane
I wrote: Actually, it strikes me there might be another way to do this, which is to get rid of HasCTZSet/CTimeZone entirely in favor of consing up some pseudo pg_tz structure that represents the desired semantics when we want a brute force setting. After some study of the pgtz code, it turns

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Christopher Browne
On Thu, Oct 31, 2013 at 2:44 PM, Garick Hamlin gham...@isc.upenn.edu wrote: On Thu, Oct 31, 2013 at 01:59:04PM -0400, Robert Haas wrote: On Thu, Oct 31, 2013 at 1:02 PM, Garick Hamlin gham...@isc.upenn.edu wrote: On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: From: Robert Haas

Re: [HACKERS] API bug in DetermineTimeZoneOffset()

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 2:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: I wrote: Actually, it strikes me there might be another way to do this, which is to get rid of HasCTZSet/CTimeZone entirely in favor of consing up some pseudo pg_tz structure that represents the desired semantics when we want

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 2:44 PM, Garick Hamlin gham...@isc.upenn.edu wrote: I think using /dev/urandom directly would be surprising. At least it would have probably have taken me a while to figure out what was depleting the entropy pool here. Perhaps so; a bigger problem IMHO is that it's not

[HACKERS] Review: Patch FORCE_NULL option for copy COPY in CSV mode

2013-10-31 Thread Payal Singh
The post was made before I subscribed to the mailing list, so posting my review separately. The link to the original patch mail is http://www.postgresql.org/message-id/CAB8KJ=jS-Um4TGwenS5wLUfJK6K4rNOm_V6GRUj+tcKekL2=g...@mail.gmail.com Hi, This patch implements the following TODO item:

Re: [HACKERS] Record comparison compiler warning

2013-10-31 Thread Kevin Grittner
Bruce Momjian br...@momjian.us wrote: On Wed, Oct 16, 2013 at 11:49:13AM -0700, Kevin Grittner wrote: Bruce Momjian br...@momjian.us wrote: I am seeing this compiler warning in git head: rowtypes.c: In function 'record_image_cmp': rowtypes.c:1433: warning: 'cmpresult' may be used   

[HACKERS] Feature request: Optimizer improvement

2013-10-31 Thread Joe Love
In postgres 9.2 I have a function that is relatively expensive. When I write a query such as: select expensive_function(o.id),o.* from offeirng o where valid='Y' order by name limit 1; the query runs slow and appears to be running the function on each ID, which in this case should be totally

Re: [HACKERS] Feature request: Optimizer improvement

2013-10-31 Thread Kevin Grittner
Joe Love j...@primoweb.com wrote: In postgres 9.2 I have a function that is relatively expensive. What did you specify in the COST clause on the CREATE FUNCTION statement? -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing

Re: [HACKERS] Reference to parent query from ANY sublink

2013-10-31 Thread Antonin Houska
On 10/31/2013 03:46 PM, Antonin Houska wrote: Can the change be as simple as this or do I neglect anything? Well, the example of outer join is wrong. Instead I think query SELECT * FROMtab1 a LEFT JOIN tab1 b ON b.i = ANY ( SELECT tab2.k

[HACKERS] Feature request: optimizer improvement

2013-10-31 Thread Joe Love
In postgres 9.2 I have a function that is relatively expensive. When I write a query such as: select expensive_function(o.id),o.* from offeirng o where valid='Y' order by name limit 1; the query runs slow and appears to be running the function on each ID, which in this case should be totally

Re: [HACKERS] [BUGS] BUG #8542: Materialized View with another column_name does not work?

2013-10-31 Thread Kevin Grittner
t.katsumata1...@gmail.com t.katsumata1...@gmail.com wrote: I'm testing the Materialized View. When I've tried to create materialized view with specified column_name, I got an ERROR. example: - Creating original table CREATE TABLE t ( i int ); - Creating materialized view with column_name

Re: [HACKERS] Something fishy happening on frogmouth

2013-10-31 Thread Heikki Linnakangas
On 31.10.2013 16:43, Robert Haas wrote: Let me say this again: the dynamic shared memory code *does* clean up after itself. If you kill -9 the postmaster and all of its children, you'll orphan the main shared memory segment and any dynamic shared memory segments that exist. There is nothing we

[HACKERS] Re: [BUGS] BUG #8542: Materialized View with another column_name does not work?

2013-10-31 Thread Michael Paquier
On Thu, Oct 31, 2013 at 10:22 PM, Kevin Grittner kgri...@ymail.com wrote: t.katsumata1...@gmail.com t.katsumata1...@gmail.com wrote: If there are no objections I'll apply this within a few days. I am not sure that adding a boolean flag introducing a concept related to matview inside

[HACKERS] Re: [GENERAL] postgresql-9.3.1-1-windows-x64.exe does not install correctly for me

2013-10-31 Thread Dann Corbit
The PostgreSQL installer for Windows 64 appears to be broken for Microsoft Windows Server 2012 Standard. Even after uninstalling, removing the entire postgresql directory structure, and running the installer as administrator, I get this error: fixing permissions on existing directory

Re: [HACKERS] API bug in DetermineTimeZoneOffset()

2013-10-31 Thread Tom Lane
I wrote: So what I'm thinking we should do is internally translate SET TIMEZONE with an interval value into a POSIX-style zone name in the above format, and then just flush HasCTZSet/CTimeZone and all the special case logic around them. Attached is a set of proposed patches for this. 1. The

Re: [HACKERS] Shave a few instructions from child-process startup sequence

2013-10-31 Thread Amit Kapila
On Thu, Oct 31, 2013 at 2:41 AM, Gurjeet Singh gurj...@singh.im wrote: Just a small patch; hopefully useful. This is valid saving as we are filling array ListenSocket[] in StreamServerPort() serially, so during ClosePostmasterPorts() once if it encountered PGINVALID_SOCKET, it is valid to break

Re: [HACKERS] Shave a few instructions from child-process startup sequence

2013-10-31 Thread Tom Lane
Amit Kapila amit.kapil...@gmail.com writes: On Thu, Oct 31, 2013 at 2:41 AM, Gurjeet Singh gurj...@singh.im wrote: Just a small patch; hopefully useful. This is valid saving as we are filling array ListenSocket[] in StreamServerPort() serially, so during ClosePostmasterPorts() once if it

Re: [HACKERS] Something fishy happening on frogmouth

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 7:48 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 31.10.2013 16:43, Robert Haas wrote: There should be no cases where the main shared memory segment gets cleaned up and the dynamic shared memory segments do not. 1. initdb -D data1 2. initdb -D data2 3.

Re: [HACKERS] Shave a few instructions from child-process startup sequence

2013-10-31 Thread Robert Haas
On Fri, Nov 1, 2013 at 12:20 AM, Tom Lane t...@sss.pgh.pa.us wrote: Amit Kapila amit.kapil...@gmail.com writes: On Thu, Oct 31, 2013 at 2:41 AM, Gurjeet Singh gurj...@singh.im wrote: Just a small patch; hopefully useful. This is valid saving as we are filling array ListenSocket[] in

Re: [HACKERS] [BUGS] BUG #8542: Materialized View with another column_name does not work?

2013-10-31 Thread Ashutosh Bapat
CREATE MATERIALIZED VIEW statement ends up being CREATE TABLE AS statement underneath with table type matview. In that case, why don't I see special treatment only for materialized view and not CTAS in general, which allows column names to specified like the case in the bug reported. On Fri, Nov

[HACKERS] Re: [GENERAL] postgresql-9.3.1-1-windows-x64.exe does not install correctly for me

2013-10-31 Thread Christian Ullrich
* Dann Corbit wrote: The PostgreSQL installer for Windows 64 appears to be broken for Microsoft Windows Server 2012 Standard. Even after uninstalling, removing the entire postgresql directory structure, and running the installer as administrator, I get this error: fixing permissions on