ERROR: fe_sendauth: no password supplied

[patty-chow]

Describe the bug
Error encountered while using

• Issue observed with $Graphlookup operator.
• Dropping an Index.
• Dropping a collection.
• Listing indexes on a table, with list_indexes function.

Environment

• Docker
• Operating system and version - Intel Core i9 and Mac sequoia (v15)
• PostgreSQL version - Postgres 16
• Architecture -

Reproduction Steps
Steps to reproduce the behavior:
SELECT documentdb_api.create_collection('Documentdbdatabase','patient');
SELECT * FROM documentdb_api.create_indexes_background('Documentdbdatabase', '{ "createIndexes": "patient", "indexes": [{ "key": {"age": 1},"name": "id_age"}]}');
CALL documentdb_api.drop_indexes('Documentdbdatabase', '{"dropIndexes": "patient", "index":"idx_age"}');

Expected behavior

• We should be able to drop an index or collection.
• $graphlookup pipeline should function.
• All indexes should be listed.

** Actual behavior **

-- ERROR: fe_sendauth: no password supplied
-- CONTEXT: while executing command over libpq connection

Additional context
Add any other context about the problem here.

[diipak-bisht]

The drop_indexes seems to have a typo, the actual name of the index that is created above it is id_age, so drop_indexes would fail.

What is the graphlookup or drop collection query that fails with the above error?

[sivethe]

The drop_indexes seems to have a typo, the actual name of the index that is created above it is id_age, so drop_indexes would fail.

What is the graphlookup or drop collection query that fails with the above error?

Tagging @patty-chow for her awareness