Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 55439

Additional modules supplied by the Postgres project but not installed by default.

1 vote
2 answers
517 views

What does it mean by PostgreSQL's ERROR: schema XX is not a member of extension YY?

I have two PostgreSQL (14.5, Ubuntu 22.04) extensions A and B that each creates some functions in a common schema schm. Now I am having trouble re-creating the two extensions as there seems to be conf …
tinlyx's user avatar
  • 3,620
1 vote

What does it mean by PostgreSQL's ERROR: schema XX is not a member of extension YY?

This seems to be an issue with the PostgreSQL 14.5 version (from the pdpg repo). I went back to an old image with PostgreSQL 14.4, and repeated the process. There is no error with the old version. Fo …
tinlyx's user avatar
  • 3,620
1 vote
1 answer
394 views

How to package a PostgreSQL extension as a binary .deb file in Ubuntu?

What is the minimal-effort way to package a PostgreSQL extension into a .deb file for Ubuntu (as of 18.04)? I did some search but find many different suggestions (some outdated). Suppose I want to …
tinlyx's user avatar
  • 3,620
8 votes
2 answers
3k views

list of PostgreSQL trusted languages?

I am trying to find a list of PostgreSQL trusted procedural languages (PL) as I often need to use a PL in a non-superuser environment. But I couldn't find a definitive answer. For example, the Postg …
tinlyx's user avatar
  • 3,620
4 votes

list of PostgreSQL trusted languages?

For those who are interested in an "official source", there is the PL Matrix in PostgreSQL wiki, which contains a "(un)trusted" column telling whether a language is trusted or not.
tinlyx's user avatar
  • 3,620