Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCWZU-00032Z-JC for pgsql-www@arkaria.postgresql.org; Mon, 04 Mar 2013 14:40:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UCWZU-00069O-37 for pgsql-www@arkaria.postgresql.org; Mon, 04 Mar 2013 14:40:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCWZT-00069J-M9 for pgsql-www@postgresql.org; Mon, 04 Mar 2013 14:40:55 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCWZQ-0001ms-5E for pgsql-www@postgresql.org; Mon, 04 Mar 2013 14:40:55 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id r24EedRG004726; Mon, 4 Mar 2013 09:40:39 -0500 (EST) From: Tom Lane To: Alvaro Herrera cc: Andres Freund , Magnus Hagander , Kevin Grittner , Peter Eisentraut , PostgreSQL WWW , Stephen Frost Subject: Re: gitweb is no longer a real-time view In-reply-to: <20130304143349.GX9507@alvh.no-ip.org> References: <19759.1362357835@sss.pgh.pa.us> <20130304020324.GE16142@tamriel.snowman.net> <2480.1362363162@sss.pgh.pa.us> <20130304023335.GH16142@tamriel.snowman.net> <20130304125013.GB3943@awork2.anarazel.de> <20130304143349.GX9507@alvh.no-ip.org> Comments: In-reply-to Alvaro Herrera message dated "Mon, 04 Mar 2013 11:33:49 -0300" Date: Mon, 04 Mar 2013 09:40:38 -0500 Message-ID: <4725.1362408038@sss.pgh.pa.us> X-Pg-Spam-Score: -2.5 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-www Precedence: bulk Sender: pgsql-www-owner@postgresql.org Alvaro Herrera writes: > Andres Freund wrote: >> I think the most realistic way to resolve this is to push the current >> anongit state to master and cherry-pick >> bc61878682051678ade5f59da7bfd90ab72ce13b ontop it. That way only >> committers need to deal with rebasing their branches and not everyone >> else. > I agree this seems the sanest course of action, but I think it would be > better to install defenses in the master repo so that forced pushes are > no longer allowed *before* rebasing gitmaster; otherwise some other > committer could clobber things again if they don't force-pull their > trees. Agreed. I'm astonished that we had this configured this way in the first place. FWIW, I noticed something about a "forced update" when I did a git pull after Kevin's commits. I failed to pay enough attention though. Now that I look, the xml fix is not in my local history either, and I don't know what bc61878682051678ade5f59da7bfd90ab72ce13b is because none of the recent commits have that hash according to my repo: $ git status # On branch master nothing to commit (working directory clean) $ git log commit d63977eea3ab18fdec05e370b633d10b9fd20179 Author: Kevin Grittner Date: Sun Mar 3 18:38:44 2013 -0600 Remove accidentally-committed .orig file. commit 3bf3ab8c563699138be02f9dc305b7b77a724307 Author: Kevin Grittner Date: Sun Mar 3 18:23:31 2013 -0600 Add a materialized view relations. A materialized view has a rule just like a view and a heap and other physical properties like a table. The rule is only used to populate the table, references in queries refer to the materialized data. This is a minimal implementation, but should still be useful in many cases. Currently data is only populated "on demand" by the CREATE MATERIALIZED VIEW and REFRESH MATERIALIZED VIEW statements. It is expected that future releases will add incremental updates with various timings, and that a more refined concept of defining what is "fresh" data will be developed. At some point it may even be possible to have queries use a materialized in place of references to underlying tables, but that requires the other above-mentioned features to be working first. Much of the documentation work by Robert Haas. Review by Noah Misch, Thom Brown, Robert Haas, Marko Tiikkaja Security review by KaiGai Kohei, with a decision on how best to implement sepgsql still pending. commit b15a6da29217b14f02895af1d9271e84415a91ae Author: Tom Lane Date: Sun Mar 3 19:05:47 2013 -0500 Get rid of any toast table when converting a table to a view. Also make sure other fields of the view's pg_class entry are appropriate for a view; it shouldn't have relfrozenxid set for instance. This ancient omission isn't believed to have any serious consequences in versions 8.4-9.2, so no backpatch. But let's fix it before it does bite us in some serious way. It's just luck that the case doesn't cause problems for autovacuum. (It did cause problems in 8.3, but that's out of support.) Andres Freund commit 2b78d101d1d6b1d8533a7b7aeff4d82b10a915f8 Author: Tom Lane Date: Sun Mar 3 17:39:58 2013 -0500 Fix SQL function execution to be safe with long-lived FmgrInfos. regards, tom lane -- Sent via pgsql-www mailing list (pgsql-www@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-www