DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
	h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=ghdupC9ycdJSyjpzRLlRhBDTLmlptdhwTNhXr84O2DAz5OLhwuN9Q5WDAePjfnXQWg7ZFj+vSDrbWFST7layAsnXR7Y+FJi0TT2BC/ojp6S1jxOqjeLEc6NeVNDrBhLSlCe4AEDJ34KV6B9bAaYGX95U7ZbPosy1JLrMQ5HXhag=;
References: <19759.1362357835@sss.pgh.pa.us>
	<20130304020324.GE16142@tamriel.snowman.net>
	<2480.1362363162@sss.pgh.pa.us>
	<20130304023335.GH16142@tamriel.snowman.net>
	<CABUevEwfw24iF9-czueLSmdFQwck012qfVmLXcoKbG37xG56jQ@mail.gmail.com>
	<CABUevEzM2F8qAxVds9Me-41L5BqeEGO4DuosCQhC0C6v05HPUw@mail.gmail.com>
Message-ID: <1362402660.43431.YahooMailNeo@web162901.mail.bf1.yahoo.com>
Date: Mon, 4 Mar 2013 05:11:00 -0800 (PST)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: gitweb is no longer a real-time view
To: Magnus Hagander <magnus@hagander.net>, Tom Lane <tgl@sss.pgh.pa.us>,
	Peter Eisentraut <peter_e@gmx.net>
Cc: PostgreSQL WWW <pgsql-www@postgresql.org>,
	Stephen Frost <sfrost@snowman.net>
In-Reply-To: 
 <CABUevEzM2F8qAxVds9Me-41L5BqeEGO4DuosCQhC0C6v05HPUw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-www-owner@postgresql.org

Magnus Hagander <magnus@hagander.net> wrote:

> Actually, looking closer, I'm seeing a failure when it actually tries the
> push:
>
> To ssh://git@git.postgresql.org/postgresql.git
> ! [rejected]=A0=A0=A0=A0=A0=A0=A0 master -> master (non-fast-forward)
>
>
> So the problem might have nothing at all to do with the cacheing.
>
> AFAICT, the three missing commits are materialized=A0 views,
> accidentally committed .orig file and \l support.
>
> But. The *anonymous* repository also has:
> bc61878682051678ade5f59da7bfd90ab72ce13b Fix
> map_sql_value_to_xml_value() to treat domains like their base types.
>
> This patch is *not* in the master repository, it's only in anonymous.
> (The object is in the repository, but it's not part of any branch)
>
> How the hell did *that* happen?
>
> The master repo has:
> commit 5db5974c692b0fc68e7608dd85a6b4e6173a0f28
> Author: Peter Eisentraut <peter_e@gmx.net>
>
>=A0=A0=A0=A0 psql: Let \l accept a pattern
>
> commit d63977eea3ab18fdec05e370b633d10b9fd20179
> Author: Kevin Grittner <kgrittn@postgresql.org>
>
>=A0=A0=A0=A0 Remove accidentally-committed .orig file.
>
> commit 3bf3ab8c563699138be02f9dc305b7b77a724307
> Author: Kevin Grittner <kgrittn@postgresql.org>
>
>=A0=A0=A0=A0 Add a materialized view relations.
>
> commit b15a6da29217b14f02895af1d9271e84415a91ae
> Author: Tom Lane <tgl@sss.pgh.pa.us>
>
>=A0=A0=A0=A0 Get rid of any toast table when converting a table to a view.
>
>
> And the anonymous one has:
> commit bc61878682051678ade5f59da7bfd90ab72ce13b
> Author: Tom Lane <tgl@sss.pgh.pa.us>
>
>=A0=A0=A0=A0 Fix map_sql_value_to_xml_value() to treat domains like their =
base types.
>
> commit 3bf3ab8c563699138be02f9dc305b7b77a724307
> Author: Kevin Grittner <kgrittn@postgresql.org>
>
>=A0=A0=A0=A0 Add a materialized view relations.
>
> commit b15a6da29217b14f02895af1d9271e84415a91ae
> Author: Tom Lane <tgl@sss.pgh.pa.us>
>
>=A0=A0=A0=A0 Get rid of any toast table when converting a table to a view.
>
>
>
> Does anybody have an explanation for that? Did someone do a force-push
> on the master repository, overwriting some old history?
>
> We don't explicitly forbid this on the master repo, since we expect
> committers to know how things work.. Maybe we need to do that, and
> manually turn it off in case someone actually *needs* to do a non fast
> forward push? But either way, it would be good to actually know how
> tihs happened...
>
> Copying this one to Kevin and Peter too, since they seem to be the
> other people who are involved in any of these pushes.

Apologies if I contributed to this.=A0 At no point did I use a force option.

I'm using this pattern:

http://wiki.postgresql.org/wiki/Committing_with_Git#Dependent_Clone_per_Bra=
nch.2C_Pushing_and_Pulling_From_a_Local_Repository

I still have the shell windows open that I used, so (redacting
things which I'm sure are not significant, like git log commands)
there is this:

You will see a pull command used.=A0 Here's what that is:

kgrittn@Kevin-Desktop:~/pg/master$ cat ~/bin/pull
#!/bin/bash

pushd ~/pg/postgresql.git >/dev/null && git fetch && popd >/dev/null && git=
 pull


Here's what I have in my (still open) shell windows:

kgrittn@Kevin-Desktop:~/pg/master$ git push
Counting objects: 301, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (154/154), done.
Writing objects: 100% (155/155), 40.94 KiB, done.
Total 155 (delta 147), reused 6 (delta 1)
To /home/kgrittn/pg/postgresql
=A0=A0 2b78d10..3a21ef1=A0 master -> master
kgrittn@Kevin-Desktop:~/pg/master$ cd ../postgresql.git/
kgrittn@Kevin-Desktop:~/pg/postgresql.git$ git push --dry-run
To ssh://git@gitmaster.postgresql.org/postgresql.git
=A0+ b15a6da...3a21ef1 master -> master (forced update)
=A0+ b15a6da...2b78d10 anonymous/master -> anonymous/master (forced update)
kgrittn@Kevin-Desktop:~/pg/postgresql.git$ git fetch
remote: Counting objects: 31, done.
remote: Compressing objects: 100% (16/16), done.
remote: Total 16 (delta 15), reused 0 (delta 0)
Unpacking objects: 100% (16/16), done.
=46rom ssh://gitmaster.postgresql.org/postgresql
=A0+ 3a21ef1...b15a6da master=A0=A0=A0=A0 -> master=A0 (forced update)
=A0=A0 2b78d10..b15a6da=A0 anonymous/master -> anonymous/master
kgrittn@Kevin-Desktop:~/pg/postgresql.git$ git remote --verbose
origin=A0 ssh://git@gitmaster.postgresql.org/postgresql.git (fetch)
origin=A0 ssh://git@gitmaster.postgresql.org/postgresql.git (push)
kgrittn@Kevin-Desktop:~/pg/postgresql.git$ cd ../master
kgrittn@Kevin-Desktop:~/pg/master$ pull
remote: Counting objects: 31, done.
remote: Compressing objects: 100% (16/16), done.
remote: Total 16 (delta 15), reused 0 (delta 0)
Unpacking objects: 100% (16/16), done.
=46rom /home/kgrittn/pg/postgresql
=A0+ 3a21ef1...b15a6da master=A0=A0=A0=A0 -> origin/master=A0 (forced updat=
e)
First, rewinding head to replay your work on top of it...
kgrittn@Kevin-Desktop:~/pg/master$ git status
# On branch master
nothing to commit (working directory clean)
kgrittn@Kevin-Desktop:~/pg/master$ git pull
Current branch master is up to date.
kgrittn@Kevin-Desktop:~/pg/master$ git status
# On branch master
nothing to commit (working directory clean)
kgrittn@Kevin-Desktop:~/pg/master$ patch -p1 <~/patch/matview-v6.diff
[some offsets in rewriteDefine.c which looked OK on review]
kgrittn@Kevin-Desktop:~/pg/master$ git add --all
kgrittn@Kevin-Desktop:~/pg/master$ git commit
[master 3bf3ab8] Add a materialized view relations.
=A0103 files changed, 4240 insertions(+), 438 deletions(-)
=A0create mode 100644 doc/src/sgml/ref/alter_materialized_view.sgml
=A0create mode 100644 doc/src/sgml/ref/create_materialized_view.sgml
=A0create mode 100644 doc/src/sgml/ref/drop_materialized_view.sgml
=A0create mode 100644 doc/src/sgml/ref/refresh_materialized_view.sgml
=A0create mode 100644 src/backend/commands/matview.c
=A0create mode 100644 src/backend/rewrite/rewriteDefine.c.orig
=A0create mode 100644 src/include/commands/matview.h
=A0create mode 100644 src/test/regress/expected/matview.out
=A0create mode 100644 src/test/regress/sql/matview.sql
kgrittn@Kevin-Desktop:~/pg/master$ git push
Counting objects: 301, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (154/154), done.
Writing objects: 100% (155/155), 40.95 KiB, done.
Total 155 (delta 147), reused 5 (delta 1)
To /home/kgrittn/pg/postgresql
=A0=A0 b15a6da..3bf3ab8=A0 master -> master
kgrittn@Kevin-Desktop:~/pg/master$ cd ../postgresql.git/
kgrittn@Kevin-Desktop:~/pg/postgresql.git$ git push --dry-run
To ssh://git@gitmaster.postgresql.org/postgresql.git
=A0=A0 b15a6da..3bf3ab8=A0 master -> master
kgrittn@Kevin-Desktop:~/pg/postgresql.git$ git push
Counting objects: 301, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (8/8), done.
Writing objects: 100% (155/155), 40.95 KiB, done.
Total 155 (delta 147), reused 155 (delta 147)
To ssh://git@gitmaster.postgresql.org/postgresql.git
=A0=A0 b15a6da..3bf3ab8=A0 master -> master

[on review, discover accidental commit of .orig file]

kgrittn@Kevin-Desktop:~/pg/master$ git rm src/backend/rewrite/rewriteDefine=
.c.orig
rm 'src/backend/rewrite/rewriteDefine.c.orig'
kgrittn@Kevin-Desktop:~/pg/master$ git commit
[master d63977e] Remove accidentally-committed .orig file.
=A01 file changed, 945 deletions(-)
=A0delete mode 100644 src/backend/rewrite/rewriteDefine.c.orig
kgrittn@Kevin-Desktop:~/pg/master$ git push
Counting objects: 9, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (5/5), done.
Writing objects: 100% (5/5), 440 bytes, done.
Total 5 (delta 4), reused 0 (delta 0)
Unpacking objects: 100% (5/5), done.
To /home/kgrittn/pg/postgresql
=A0=A0 3bf3ab8..d63977e=A0 master -> master
kgrittn@Kevin-Desktop:~/pg/master$ cd ../postgresql.git/
kgrittn@Kevin-Desktop:~/pg/postgresql.git$ git push
Counting objects: 15018, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (4617/4617), done.
Writing objects: 100% (13087/13087), 2.31 MiB | 632 KiB/s, done.
Total 13087 (delta 11231), reused 9860 (delta 8431)
To ssh://git@gitmaster.postgresql.org/postgresql.git
=A0+ bc61878...d63977e master -> master (forced update)
=A0+ bc61878...b15a6da anonymous/master -> anonymous/master (forced update)
kgrittn@Kevin-Desktop:~/pg/postgresql.git$ cd ../master ; git diff --stat H=
EAD^ HEAD
=A0src/backend/rewrite/rewriteDefine.c.orig |=A0 945 ----------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
-------------------------------------------------
=A01 file changed, 945 deletions(-)
kgrittn@Kevin-Desktop:~/pg/master$ git status
# On branch master
nothing to commit (working directory clean)
kgrittn@Kevin-Desktop:~/pg/master$ pull
Current branch master is up to date.

--=20
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--=20
Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-www