Greetings,
* Stephen Frost (sfr...@snowman.net) wrote:
> * Frank van Vugt (ftm.van.v...@foxi.nl) wrote:
> > Well, I didn't run into this issue with any of my db's that 'nicely' use
> > tables in various schema's, it was actually the one 'older' db with
> > everything
> > in the public schema
Frank,
* Frank van Vugt (ftm.van.v...@foxi.nl) wrote:
> Well, I didn't run into this issue with any of my db's that 'nicely' use
> tables in various schema's, it was actually the one 'older' db with
> everything
> in the public schema that brought it up, so maybe keeping one of those around
>
Hi Stephen,
Op maandag 13 februari 2017 09:10:42 schreef Stephen Frost:
> We should be able to get it addressed shortly.
Great, 'as always', I'd like to add!
Thanks for the great work, people. This cannot be stated too often...
> For your specific case
Thanks for the additional info,
On 02/13/2017 07:52 AM, Stephen Frost wrote:
Greetings,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
On 02/13/2017 06:04 AM, Stephen Frost wrote:
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
I am following this up to the point of not understanding what
exactly changed between 9.5
Greetings,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> On 02/13/2017 06:04 AM, Stephen Frost wrote:
> >* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> >>I am following this up to the point of not understanding what
> >>exactly changed between 9.5 and 9.6. Namely 9.5 does include the
On 02/13/2017 06:04 AM, Stephen Frost wrote:
Adrian,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
I am following this up to the point of not understanding what
exactly changed between 9.5 and 9.6. Namely 9.5 does include the
default ACL's in the dump output and 9.6 does not.
Quite a
Frank,
* Frank van Vugt (ftm.van.v...@foxi.nl) wrote:
> Op zaterdag 11 februari 2017 15:28:55 schreef Tom Lane:
> > I'm inclined to argue that it was a mistake to include any non-pinned
> > objects in pg_init_privs.
>
> > We might need to fix pg_dump too, but I think these entries in
> >
Adrian,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> I am following this up to the point of not understanding what
> exactly changed between 9.5 and 9.6. Namely 9.5 does include the
> default ACL's in the dump output and 9.6 does not.
Quite a bit in pg_dump changed, but the relevant bit
* Tom Lane (t...@sss.pgh.pa.us) wrote:
> Stephen Frost writes:
> > I'm not seeing a very simple answer for this, unfortunately.
>
> I'm inclined to argue that it was a mistake to include any non-pinned
> objects in pg_init_privs. The reason initdb leaves some objects
Hi Tom/Stephen/Adrian,
Op zaterdag 11 februari 2017 15:28:55 schreef Tom Lane:
> I'm inclined to argue that it was a mistake to include any non-pinned
> objects in pg_init_privs.
> We might need to fix pg_dump too, but I think these entries in
> pg_init_privs should simply not be there.
Thanks
On 02/11/2017 02:06 PM, Stephen Frost wrote:
Greetings,
* Frank van Vugt (ftm.van.v...@foxi.nl) wrote:
I noticed the following and wondered whether this is intentional or an
oversight in pg_dump's '-c' option?
The clean option causes the public schema to be dropped and recreated, but
this is
Stephen Frost writes:
> I'm not seeing a very simple answer for this, unfortunately.
I'm inclined to argue that it was a mistake to include any non-pinned
objects in pg_init_privs. The reason initdb leaves some objects unpinned
is exactly because they can be dropped and
Greetings,
* Frank van Vugt (ftm.van.v...@foxi.nl) wrote:
> I noticed the following and wondered whether this is intentional or an
> oversight in pg_dump's '-c' option?
>
> The clean option causes the public schema to be dropped and recreated, but
> this is done with the default schema
Hi Adrian,
Op zaterdag 11 februari 2017 13:31:17 schreef Adrian Klaver:
> I see the same thing now.
Glad you do ;)
> That seems to cause a problem
Yeah, I originally ran into this when I noticed that on a restored db a
regular user lost access to tables created by him in the public schema.
On 02/11/2017 01:14 PM, Frank van Vugt wrote:
Hi Adrian,
Op zaterdag 11 februari 2017 13:02:29 schreef Adrian Klaver:
What version of Postgres?
Ah, sorry, missed copying that in:
postgres=# select version();
version
Hi Adrian,
Op zaterdag 11 februari 2017 13:02:29 schreef Adrian Klaver:
> What version of Postgres?
Ah, sorry, missed copying that in:
postgres=# select version();
version
On 02/11/2017 12:42 PM, Frank van Vugt wrote:
> L.S.
>
> I noticed the following and wondered whether this is intentional or an
> oversight in pg_dump's '-c' option?
What version of Postgres?
Because when I do it on 9.5.5 I get:
test=# create database publictest;
L.S.
I noticed the following and wondered whether this is intentional or an
oversight in pg_dump's '-c' option?
The clean option causes the public schema to be dropped and recreated, but
this is done with the default schema priviliges, which are not the same as the
ones assigned during create
18 matches
Mail list logo