Can't create table in public schema as 'unrecognized configuration parameter "anon.maskschema"'.

I have tried using a different schema to public, can't find any reference of this happening anywhere on the internet. This is using a db created before vercel handed off all db stuff to neon, and when I could control the db from vercel. Not sure if that matters.

9 Replies

extended-salmonOP•7mo ago

It also just doesn't even work if I do this

extended-salmonOP•7mo ago

Full error from pgAdmin, looks like the anon addon?:

ERROR:  unrecognized configuration parameter "anon.maskschema"
CONTEXT:  SQL statement "SELECT nspname
  FROM pg_catalog.pg_namespace
  WHERE nspname = pg_catalog.current_setting('anon.maskschema')::NAME"
PL/pgSQL function anon.mask_update() line 4 at PERFORM
SQL statement "SELECT anon.mask_update()"
PL/pgSQL function anon.trg_mask_update() line 5 at PERFORM 

SQL state: 42704

ERROR:  unrecognized configuration parameter "anon.maskschema"
CONTEXT:  SQL statement "SELECT nspname
  FROM pg_catalog.pg_namespace
  WHERE nspname = pg_catalog.current_setting('anon.maskschema')::NAME"
PL/pgSQL function anon.mask_update() line 4 at PERFORM
SQL statement "SELECT anon.mask_update()"
PL/pgSQL function anon.trg_mask_update() line 5 at PERFORM 

SQL state: 42704

Just ran it on a new account that isnt using vercel and it worked.

reduced-jade•7mo ago

Did you happen to have the anon extenion installed previously? We added it at one point, but we never officially supported it. Recently it was fully removed.

like-gold•7mo ago

@Wosca we think that this will need our Support team to change some things in your project. Can you email support@neon.tech with your project id please? We're sorry about this

extended-salmonOP•7mo ago

Yeah for sure That's all good I figured it might have been something removed

fascinating-indigo•7mo ago

@Wosca can you please run DROP EXTENSION anon?

extended-salmonOP•7mo ago

fascinating-indigo•7mo ago

@Wosca can you DM me your endpoint ID? And what region your project is in

extended-salmonOP•7mo ago

For sure

Gaming

Programming

Can't create table in public schema as 'unrecognized configuration parameter "anon.maskschema"'.

Did you find this page helpful?