Re: [sqlalchemy] Lose the schema??

2021-06-21 Thread Mike Bayer
https://github.com/sqlalchemy/sqlalchemy/issues/6658 will be fixed in the next release though your program should not have to use the IDENTITY INSERT feature and we need to see your schema / Table. On Mon, Jun 21, 2021, at 5:57 PM, Mike Bayer wrote: > OK more specifically you seem to be

Re: [sqlalchemy] Lose the schema??

2021-06-21 Thread Mike Bayer
OK more specifically you seem to be using the "schema_translate_map" feature and but for some reason SQLAlchemy is also attempting to manipulate the IDENTITY INSERT feature, which normally should not be happening, and in this case it appears there may be a bug in the SQL Server dialect that

Re: [sqlalchemy] Lose the schema??

2021-06-21 Thread Mike Bayer
you have a Table that defines "schema" as "SCHEMA__none", and this schema does not exist. Schema definition is described at https://docs.sqlalchemy.org/en/14/core/metadata.html#specifying-the-schema-name . On Mon, Jun 21, 2021, at 4:34 PM, Victor Manuel Arévalo Fandiño wrote: > Hello > >

[sqlalchemy] Lose the schema??

2021-06-21 Thread Victor Manuel Arévalo Fandiño
Hello I'm trying to insert a row in a table but I have the message: "No se pudo realizar el insert en Tbl_cataloging_meeting:(, ProgrammingError('(pypyodbc.ProgrammingError) (\'42000\', \'[42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot find the object