Re: Odd table ownership for PostgreSQL

Re: Giles Thomas 2013-07-26 <51F2B37E(dot)5070501(at)pythonanywhere(dot)com>
> We're installing PostgreSQL to Ubuntu raring machines using the
> http://apt.postgresql.org/pub/repos/apt/ PPA. Something strange
> seems to have happened at some point after 19:39 UTC on 23 July.
>
> Details of the error are here <http://dba.stackexchange.com/questions/47005/postgresql-create-table-creates-with-incorrect-owner>
> but to summarise, we're creating a user, creating a database owned
> by that user, and then as that user we're creating a table in the
> database. The new table turns out to be owned by user postgres
> rather than by the new user. The new user does not have (but can
> grant himself) permissions on the table.
>
> This problem is not present on a machine that installed PostgreSQL
> from the PPA at 19:39 UTC on 23 July. But it is present in one that
> installed it at 13:16 UTC on 24 July, and in every machine we've
> installed it on since.
>
> Any help would be much appreciated!

Nothing has changed on apt.postgresql.org since July 22nd, so this is
not caused by a packaging change. I cannot reproduce the problem using
9.2.4-1.pgdg+1 on sid/amd64.

Is there any pooler between you and the database that might be messing
up with the current user?

Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/