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

[BUG] postgres function ownership isn't determined correctly #62251

Closed
nicholasmhughes opened this issue Jun 30, 2022 · 1 comment
Closed

[BUG] postgres function ownership isn't determined correctly #62251

nicholasmhughes opened this issue Jun 30, 2022 · 1 comment
Labels
Bug broken, incorrect, or confusing behavior Duplicate Duplicate of another issue or PR - will be closed

Comments

@nicholasmhughes
Copy link
Collaborator

Description
the query that determines the owner of a function seems to be broken

[ERROR   ] Command '/usr/bin/psql' failed with return code: 1
[ERROR   ] stderr: ERROR:  column "rolname" does not exist
LINE 1: COPY (SELECT rolname AS name FROM pg_catalog.pg_proc p JOIN ...
                     ^
HINT:  Perhaps you meant to reference the column "p.proname".
[ERROR   ] retcode: 1
[ERROR   ] Error connecting to Postgresql server
[ERROR   ] Command '/usr/bin/psql' failed with return code: 1
[ERROR   ] stderr: ERROR:  column "rolname" does not exist
LINE 1: COPY (SELECT rolname AS name FROM pg_catalog.pg_proc p JOIN ...
                     ^
HINT:  Perhaps you meant to reference the column "p.proname".
[ERROR   ] retcode: 1
[ERROR   ] Error connecting to Postgresql server

Steps to Reproduce the behavior
attempt to grant execute on a function

Versions Report

salt --versions-report (Provided by running salt --versions-report. Please also mention any differences in master/minion versions.)
Salt Version:
            Salt: 3004.1
 
Dependency Versions:
            cffi: 1.15.0
        cherrypy: Not Installed
        dateutil: 2.8.2
       docker-py: Not Installed
           gitdb: 2.0.6
       gitpython: 3.0.7
          Jinja2: 3.0.1
         libgit2: Not Installed
        M2Crypto: Not Installed
            Mako: Not Installed
         msgpack: 1.0.4
    msgpack-pure: Not Installed
    mysql-python: Not Installed
       pycparser: 2.21
        pycrypto: Not Installed
    pycryptodome: 3.14.1
          pygit2: Not Installed
          Python: 3.8.10 (default, Mar 15 2022, 12:22:08)
    python-gnupg: 0.4.5
          PyYAML: 6.0
           PyZMQ: 21.0.2
           smmap: 2.0.5
         timelib: Not Installed
         Tornado: 4.5.3
             ZMQ: 4.3.3
 
Salt Extensions:
 saltext.azurerm: 0.1.dev12+g89704fb.d20220625
 
System Versions:
            dist: ubuntu 20.04 Focal Fossa
          locale: utf-8
         machine: x86_64
         release: 5.13.0-1023-azure
          system: Linux
         version: Ubuntu 20.04 Focal Fossa
@nicholasmhughes nicholasmhughes added the Bug broken, incorrect, or confusing behavior label Jun 30, 2022
@nicholasmhughes nicholasmhughes changed the title [BUG] postgres [BUG] postgres function ownership isn't determined correctly Jun 30, 2022
@OrangeDog
Copy link
Contributor

Duplicate: #59585

@OrangeDog OrangeDog added the Duplicate Duplicate of another issue or PR - will be closed label Jun 30, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug broken, incorrect, or confusing behavior Duplicate Duplicate of another issue or PR - will be closed
Projects
None yet
Development

No branches or pull requests

2 participants