Re: SEGFAULT in CREATE EXTENSION related pg_init_privs

Pavel,

* Pavel Stehule (pavel(dot)stehule(at)gmail(dot)com) wrote:
> I am trying to prepare orafce for PostgreSQL 9.6.
>
> I can successfully compile this extension, but the statement CREATE
> EXTENSION fails on segfault

Just the latest off of https://github.com/orafce/orafce ?

I took a quick look through and nothing is jumping out at me and,
unfortunately, have a lot on my plate today. I'll take a look at it
later on tonight though.

> This is enforced by sequence of statements REVOKE, GRANT
>
> try to add following lines to hstore--1.3.sql
>
> CREATE VIEW public.dual AS SELECT 'X'::varchar AS dummy;
> REVOKE ALL ON public.dual FROM PUBLIC;
> GRANT SELECT, REFERENCES ON public.dual TO PUBLIC;
>
> then create extension hstore enforces this error.
>
> When I remove the REVOKE statement - all is working.

Ok, good to know, that'll help.

Thanks!

Stephen