Please do not piggyback on an unrelated thread to ask a question.
Start a new thread.
Vinicius Abrahao <vinnix.bsd@gmail.com> writes:
> postgres=# CREATE EXTENSION pg_buffercache SCHEMA pg_catalog;
> ERROR: syntax error at or near "NO"
This looks like a syntax error in the pg_buffercache--1.0.sql file ...
have you tampered with that at all?
I believe BTW that you cannot specify pg_catalog as the target schema
here. When I try that, I get:
regression=# CREATE EXTENSION pg_buffercache SCHEMA pg_catalog;
ERROR: permission denied to create "pg_catalog.pg_buffercache"
DETAIL: System catalog modifications are currently disallowed.
but it goes through fine without the SCHEMA clause.
regards, tom lane