Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

credcheck doesn't use its schema #45

Open
georg-h opened this issue Jan 27, 2025 · 0 comments
Open

credcheck doesn't use its schema #45

georg-h opened this issue Jan 27, 2025 · 0 comments

Comments

@georg-h
Copy link

georg-h commented Jan 27, 2025

the extension creates an own schema "credcheck" on create extension but doesn't put its views and functions in it.
What is the purpose of this schema?

postgres=# select version();
version

PostgreSQL 15.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-22), 64-bit
(1 row)

postgres=# create extension credcheck;
CREATE EXTENSION
postgres=# \dn
List of schemas
Name | Owner
-----------+-------------------
admin | postgres
credcheck | postgres
public | pg_database_owner
(3 rows)

postgres=# \dt credcheck.*
Did not find any relation named "credcheck.*".

postgres=# \dv credcheck.*
Did not find any relation named "credcheck.*".

postgres=# \df credcheck.*
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)

postgres=# \dx+ credcheck
Objects in extension "credcheck"
Object description

function pg_banned_role()
function pg_banned_role_reset()
function pg_banned_role_reset(name)
function pg_password_history()
function pg_password_history_reset()
function pg_password_history_reset(name)
function pg_password_history_timestamp(name,timestamp with time zone)
schema credcheck
view pg_banned_role
view pg_password_history
(10 rows)

postgres=# \dx credcheck
List of installed extensions
Name | Version | Schema | Description
-----------+---------+--------+------------------------------------------------------
credcheck | 2.8.0 | public | credcheck - postgresql plain text credential checker
(1 row)

postgres=# drop extension credcheck ;
DROP EXTENSION

postgres=# create schema credcheck;
CREATE SCHEMA

postgres=# create extension credcheck schema credcheck;
ERROR: schema "credcheck" already exists

As there is a schema "credcheck" I've expected to find its views and functions within this schema.

kind regards
Georg

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant