sqlalchemy/sqlalchemy issues and pull requests

#12908 - Improve column reflection query

Issue - State: open - Opened by CaselIT about 2 months ago - 1 comment
Labels: postgresql, reflection, performance, use case

#12877 - Incorrect PSQL Quotes for postgresql_inherits (document quoted_name for this, and also clean up old things in quoted_name docs)

Issue - State: open - Opened by marcuswishart 2 months ago - 8 comments
Labels: documentation, postgresql, schema

#12874 - array of enum can't be used with any_() / all_()

Issue - State: closed - Opened by zzzeek 2 months ago - 3 comments
Labels: bug, postgresql, array of enums, near-term release

#12868 - JSONB subscript index not used anymore after sqlalchemy 2.0.42

Issue - State: closed - Opened by valumapps 2 months ago - 8 comments
Labels: bug, documentation, postgresql, regression, great mcve, json

#12867 - Rendering of dialect options in postgres primary key constraint / factor out constraint rendering into components

Issue - State: open - Opened by DavideCanton 3 months ago - 9 comments
Labels: bug, postgresql, schema

#12866 - Ensure virtual generated columns are supported in pg18+

Issue - State: open - Opened by CaselIT 3 months ago - 1 comment
Labels: postgresql, schema, use case

#12847 - [Bug] select() of a enum[] column with NULL entries in the array fails

Issue - State: closed - Opened by zzzeek 3 months ago - 2 comments
Labels: bug, postgresql, array of enums

#12761 - Postgresql named that have the same name as an internal type are not rendered correctly in `create table`

Issue - State: closed - Opened by CaselIT 4 months ago - 22 comments
Labels: bug, postgresql, schema, reflection

#12734 - bring values() into the fold as a HasCTE and support PGs "WITH x(y,z) AS VALUES (...)"

Issue - State: open - Opened by zzzeek 5 months ago - 5 comments
Labels: postgresql, use case

#12600 - Reflection regression in postgresql

Issue - State: closed - Opened by CaselIT 7 months ago - 18 comments
Labels: bug, postgresql, reflection, regression

#12417 - PostgreSQL dialect throws an exception compiling FOR UPDATE OF inside subquery

Issue - State: closed - Opened by CaselIT 9 months ago - 2 comments
Labels: bug, postgresql, sql

#12342 - Introduce PostgresSQL DistictOn extension, deprecate old api

Issue - State: closed - Opened by CaselIT 10 months ago - 2 comments
Labels: postgresql, use case

#12174 - all PG domain reflection tests failing for pg17

Issue - State: closed - Opened by zzzeek 12 months ago - 7 comments
Labels: postgresql, blocker, reflection, regression

#12170 - `SmallInteger` is compiled to `SERIAL` instead of `SMALLSERIAL` on table creation when `asyncpg` driver is used.

Issue - State: closed - Opened by FeeeeK 12 months ago - 3 comments
Labels: bug, postgresql

#12118 - Support psycopg `ClientCursor`

Issue - State: closed - Opened by CaselIT about 1 year ago - 1 comment
Labels: postgresql, use case, dialects

#12060 - [psycopg3] MAC address comparison fails due to incorrect type casting

Issue - State: closed - Opened by yoch about 1 year ago - 8 comments
Labels: bug, postgresql, sql

#11994 - missing type cast for jsonb in values for postgres?

Issue - State: closed - Opened by CaselIT about 1 year ago - 2 comments
Labels: postgresql, schema, use case

#11961 - Comment reflection confused by pg_description entries with overlapping oid values

Issue - State: open - Opened by gordthompson about 1 year ago
Labels: bug, postgresql, reflection

#11946 - Support "SET NULL" for only one column of composite foreign key in postgresql

Issue - State: open - Opened by CaselIT about 1 year ago
Labels: postgresql, schema, PRs (with tests!) welcome

#11821 - add CancelledError to list of exceptions caught in terminate

Issue - State: closed - Opened by zzzeek about 1 year ago - 2 comments
Labels: bug, postgresql, asyncio, near-term release

#11819 - any rollback() that fails with missing greenlet will make asyncpg connection believe it's all done

Issue - State: closed - Opened by zzzeek about 1 year ago - 3 comments
Labels: bug, postgresql, blocker, near-term release

#11758 - Support empty connection string for postgresql+psycopg

Issue - State: closed - Opened by stinovlas over 1 year ago - 4 comments
Labels: postgresql, cant reproduce, awaiting info, use case

#11724 - The get_multi_indexes method in PGDialect does not work correctly with pgvector-rs

Issue - State: closed - Opened by xianyuntang over 1 year ago - 6 comments
Labels: bug, postgresql, reflection, PRs (with tests!) welcome

#11636 - Implicit type conversion for asyncpg

Issue - State: closed - Opened by riwu over 1 year ago - 3 comments
Labels: postgresql, awaiting info, use case

#11576 - the collate() binary expression should copy the internal type and reset its collation as well

Issue - State: closed - Opened by riwu over 1 year ago - 4 comments
Labels: bug, postgresql, sql, datatypes, near-term release

#11551 - Support tcp keepalive for postgresql

Issue - State: closed - Opened by NiuBlibing over 1 year ago - 1 comment
Labels: question, postgresql, use case

#11537 - use_insertmanyvalues=True case error when add record in Postgresql

Issue - State: closed - Opened by swuecho over 1 year ago - 5 comments
Labels: postgresql, expected behavior

#11522 - pool_pre_ping fails to reconnect on psycopg2 "SSL SYSCALL error: Success"

Issue - State: closed - Opened by dhirving over 1 year ago - 4 comments
Labels: postgresql, connection pool

#11141 - SQLAlchemy doesn't respect `prepared_statement_name_func` for calls to `set_type_codec` in asyncpg

Issue - State: closed - Opened by CobaltCause over 1 year ago - 8 comments
Labels: postgresql, expected behavior, awaiting info, asyncio

#11006 - issue 10863 put an invalid exception class in the catch, does not get exercised

Issue - State: closed - Opened by zzzeek almost 2 years ago - 1 comment
Labels: duplicate, postgresql, blocker, asyncio, near-term release

#11005 - AttributeError of AsyncAdapt_asyncpg_dbapi

Issue - State: closed - Opened by decaz almost 2 years ago - 5 comments
Labels: bug, tests, postgresql, blocker, asyncio, near-term release

#10909 - Implement `get_table_options` and `get_multi_table_options` for the PostgreSQL dialect

Issue - State: open - Opened by edgarrmondragon almost 2 years ago - 4 comments
Labels: postgresql, reflection, PRs (with tests!) welcome, use case

#10817 - Incorrect interference between "not_" and "any_"

Issue - State: closed - Opened by amaslyaev almost 2 years ago - 9 comments
Labels: bug, postgresql, sql

#10787 - Error when adding model with datetime and UUID

Issue - State: closed - Opened by KyloEntro almost 2 years ago - 5 comments
Labels: postgresql, awaiting info, external extension issues

#10777 - get_check_constraints() fails to parse constraints marked NO INHERIT

Issue - State: closed - Opened by ellisvalentiner almost 2 years ago - 3 comments
Labels: postgresql, reflection, use case

#10753 - `IndexError` when using `str()` on a postgresql `insert` using `on_conflict_do_update()` followed by `cte()`

Issue - State: closed - Opened by odelmarcelle almost 2 years ago - 4 comments
Labels: bug, postgresql, sqlite, sql

#10693 - add reflection for pg DOMAIN types similarly to ENUM reflection

Issue - State: closed - Opened by ovangle about 2 years ago - 13 comments
Labels: postgresql, reflection, PRs (with tests!) welcome, use case

#10665 - PrimaryKey and Unique Constraint do not support 'postgresql_include'

Issue - State: closed - Opened by CaselIT about 2 years ago - 5 comments
Labels: postgresql, schema, reflection, PRs (with tests!) welcome, use case

#10604 - add "create_type" to sqltypes.Enum ?

Issue - State: closed - Opened by zzzeek about 2 years ago - 8 comments
Labels: postgresql, datatypes, code review in progress

#10556 - create new string subclass for bit strings for PG drivers

Issue - State: closed - Opened by zzzeek about 2 years ago - 5 comments
Labels: bug, postgresql, datatypes, PRs (with tests!) welcome

#10445 - sqlalchemy.dialects.postgresql.Insert does not use SQL compilation caching

Issue - State: closed - Opened by CaselIT about 2 years ago - 2 comments
Labels: postgresql, PRs (with tests!) welcome, use case, statement caching

#10207 - Rename sequence / identity order to oracle_order, ignore it in other dbs

Issue - State: open - Opened by CaselIT over 2 years ago
Labels: bug, postgresql, schema, oracle

#10103 - Connection error on Google Cloud SQL with 2.0.18

Issue - State: closed - Opened by stabacco over 2 years ago - 1 comment
Labels: duplicate, postgresql

#10096 - PostgreSQL CITEXT case-insensitive comparison not working in psycopg dialect due to ::VARCHAR cast

Issue - State: closed - Opened by jtbeach over 2 years ago - 4 comments
Labels: bug, postgresql, datatypes, great mcve, near-term release

#10069 - support postgresql host forms that have a colon in them but are not multihost format

Issue - State: closed - Opened by aebrahim over 2 years ago - 17 comments
Labels: bug, postgresql, regression, near-term release

#10004 - SQLAlchemy asyncpg dialect doesn't support mutlihost connection string

Issue - State: closed - Opened by iliadmitriev over 2 years ago - 5 comments
Labels: postgresql, PRs welcome, use case

#9945 - Unexpected/incorrect Python type returned for INET data type when used with psycopg driver

Issue - State: closed - Opened by jtbeach over 2 years ago - 9 comments
Labels: bug, postgresql, datatypes, use case

#9944 - Reflect don't recognize foreign tables in postgresql

Issue - State: open - Opened by joaostorrer over 2 years ago - 19 comments
Labels: postgresql, schema, reflection, use case

#9791 - SET statement_timeout =3; not working with raw_sql set to false.

Issue - State: closed - Opened by sughosh-kaushik-eightfold over 2 years ago - 1 comment
Labels: postgresql

#9773 - [Postgresql] `ENUM` does not forward `create_type` when producing column copies for `declarative_base`

Issue - State: closed - Opened by ohaibbq over 2 years ago - 4 comments
Labels: bug, postgresql, datatypes, near-term release

#9739 - Commit two or more objects with `LargeBinary` column throws `sqlalchemy.exc.DBAPIError`

Issue - State: closed - Opened by Rubikoid over 2 years ago - 2 comments
Labels: bug, postgresql, regression, near-term release

#9737 - Missing literal processor for datetime.timedelta in postgresql

Issue - State: open - Opened by web4u2qd over 2 years ago - 6 comments
Labels: postgresql, sql, PRs welcome, use case

#9736 - Incorrect type annotation for postgres multirange types

Issue - State: closed - Opened by uriyyo over 2 years ago - 6 comments
Labels: bug, postgresql, PRs (with tests!) welcome, typing

#9718 - sqlalchemy + asyncpg still blocking in Fastapi Program

Issue - State: closed - Opened by mydu27 over 2 years ago - 3 comments
Labels: postgresql, asyncio

#9701 - Floats are rounded to whole numbers when inserted in batches

Issue - State: closed - Opened by rbuffat over 2 years ago - 14 comments
Labels: bug, postgresql, datatypes, regression, near-term release

#9693 - Text type columns using schema qualified collations compile a quoted DDL statement on Postgres

Issue - State: open - Opened by matt-mclaughlin-quantum-si over 2 years ago - 6 comments
Labels: postgresql, schema, datatypes, PRs welcome, use case

#9615 - Indices with long column names (element values) are reflected wrongly

Issue - State: closed - Opened by Kalmis over 2 years ago - 7 comments
Labels: bug, postgresql, reflection

#9611 - postgresql ENUM auto-chooses the name from the given Enum, so "name" needs to be optional

Issue - State: closed - Opened by al-dpopowich over 2 years ago - 3 comments
Labels: bug, postgresql, regression

#9610 - PostgreSQL regexp_match operator precedence should be equal to concat

Issue - State: open - Opened by RazerM over 2 years ago - 4 comments
Labels: bug, postgresql, sql, PRs welcome

#9608 - Proposal: Add support for asyncpg adapter unique name generator

Issue - State: closed - Opened by teror4uks over 2 years ago - 1 comment
Labels: postgresql, use case

#9509 - Python postgres `Range` impl missed `intersection` method

Issue - State: closed - Opened by uriyyo over 2 years ago - 1 comment
Labels: postgresql, use case

#9442 - we likely need to keep some mention of postgresql 8.2 around to have nominal redshift support

Issue - State: closed - Opened by zoomequipd over 2 years ago - 20 comments
Labels: bug, wontfix / out of scope, postgresql, regression, near-term release

#8664 - Postgres: Reflection of indexes with operators

Issue - State: closed - Opened by garyvdm about 3 years ago - 8 comments
Labels: postgresql, reflection, PRs (with tests!) welcome, use case

#8204 - asyncpg dialect's dollar-number conversion does not use the same "dollar number" for the same-named parameter

Issue - State: closed - Opened by mitchej123 over 3 years ago - 22 comments
Labels: help wanted, postgresql, use case, asyncio

#8130 - support Postgresql / MySQL DELETE...USING [LEFT OUTER] JOIN

Issue - State: open - Opened by tgross35 over 3 years ago - 11 comments
Labels: postgresql, mysql, sql, PRs welcome, use case

#7604 - add execution option for asyncpg_timeout

Issue - State: open - Opened by blazewicz almost 4 years ago - 20 comments
Labels: postgresql, PRs (with tests!) welcome, use case, asyncio

#7225 - Change UUID default to `as_uuid=True`

Issue - State: closed - Opened by N-Maas about 4 years ago - 10 comments
Labels: postgresql, use case, dialects

#6833 - add typed version of to_tsvector and related, as well as REGCONFIG datatype; update docs to show use of REGCONFIG when necessary

Issue - State: closed - Opened by decaz over 4 years ago - 18 comments
Labels: bug, postgresql, full text search

GitHub / sqlalchemy/sqlalchemy issues and pull requests