Skip to content

feat: allow for disabling of extension loading #11103

@nick-youngblut

Description

@nick-youngblut

Is your feature request related to a problem?

My code:

def get_data() -> BaseBackend:
    conn = ibis.postgres.connect(
        host=XXX,
        port=XXX,
        database=XXX,
        user=XXX,
        password=XXX,
    )

    return conn.table("my_table$raw").execute()

The warning:

UserWarning: Failed to load hstore extension: permission denied to create extension "hstore"
HINT:  Must have CREATE privilege on current database to create this extension.

It would be helpful if one could disable the attempted loading of extensions (e.g., hstore).

What is the motivation behind your request?

An unnecessary warning is generated for read-only postgresql databases.

Describe the solution you'd like

Allow for easy disabling of extension loading

What version of ibis are you running?

10.4.0

What backend(s) are you using, if any?

postgresql

Code of Conduct

  • I agree to follow this project's Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    featureFeatures or general enhancements

    Type

    No type

    Projects

    Status

    done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions