plv8's `plv8_info()` function has a permissions error

Open
#1,227 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
42/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
postgresql
Domain
databases

Research direction

Start by reproducing the SQL shown after creating the plv8 extension, then compare the permissions on plv8_info() with plv8_version(). Done means plv8_info() can be called successfully under the same conditions as the working equivalent function.

Written by the indexing model from the issue text.

Description

bug p4

Bug report

create extension plv8;
select plv8_info();
-- ERROR:  permission denied for function plv8_info

note that the other equivalent function select plv8_version(); works fine.

This is an existing bug on the platform, unrelated to the 3.1.10 update.

Dominant language
Nix
Stars
1.8k
Forks
266
Avg merge
2d 8h
Merged PRs (30d)
25

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from supabase/postgres

All issues in supabase/postgres

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.