Re: Odd table ownership for PostgreSQL

Re: Giles Thomas 2013-07-26 <51F2B37E.5070501@pythonanywhere.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@df7cb.de | http://www.df7cb.de/