Re: [sqlalchemy] How to LOCK TABLE for PostgreSQL

2023-02-23 Thread Mike Bayer
On Thu, Feb 23, 2023, at 10:44 PM, jens.t...@gmail.com wrote: > Hello, > > In order to use the PostgreSQL LOCK > with SQLAlchemy, is there > a better way than > > *session.execute(sa.text(f"LOCK TABLE {Foo.__tablename__} IN SHARE MODE"))* I

[sqlalchemy] How to LOCK TABLE for PostgreSQL

2023-02-23 Thread jens.t...@gmail.com
Hello, In order to use the PostgreSQL LOCK with SQLAlchemy, is there a better way than *session.execute(sa.text(f"LOCK TABLE {Foo.__tablename__} IN SHARE MODE"))* Poking through the dialect