hi you need to compile with the postgresql dialect, see https://docs.sqlalchemy.org/en/14/faq/sqlexpressions.html#stringifying-for-specific-databases
from sqlalchemy import column from sqlalchemy import table from sqlalchemy.dialects import postgresql from sqlalchemy.future import select t = table("internal", column("person_id_internal")) sql = select( t.c.person_id_internal ).with_for_update(nowait=True) print(sql.compile(dialect=postgresql.dialect())) On Sun, Jun 13, 2021, at 12:23 PM, sector119 wrote: > Hello! > > On a PostgreSQL database can't get NOWAIT with FOR UPDATE clause ( > > sqlalchemy 1.4.18 > > from sqlalchemy.future import select > from unity.models.unity import Internal > > sql = select( > Internal.person_id_internal > ).with_for_update(nowait=True) > > str(sql) > Out[12]: 'SELECT unity.internals.person_id_internal \nFROM unity.internals > FOR UPDATE' > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/587b5317-e275-4c22-a78e-460eeafff1c1n%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/587b5317-e275-4c22-a78e-460eeafff1c1n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/391054ea-1ade-429b-ad41-100390cd935b%40www.fastmail.com.