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
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
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
>
>
> If not I wonder why messages aren't arriving in my INBOX.
Check your settings for this group. If you do not see the option on the
menu, try visiting https://groups.google.com/g/sqlalchemy/membership
Google sometimes has a product change de-selects the email delivery
option. Sometimes users
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
hi -
can you please create a self-contained MCVE and post to
https://github.com/sqlalchemy/sqlalchemy/issues - thanks.
- mike
On Mon, Jun 21, 2021, at 5:25 AM, Julien Cigar wrote:
> ok .. :)
>
> Another regression from 1.3: I have two deferred column_property on my
> mapped class (1) and
I don't think you'll be able to get what you want in an onupdate
function. You'd probably be better off with the before_insert and
before_update mapper events:
https://docs.sqlalchemy.org/en/14/orm/events.html#sqlalchemy.orm.MapperEvents.before_insert
ok .. :)
Another regression from 1.3: I have two deferred column_property on my
mapped class (1) and with (2) I'm getting a
sqlalchemy.exc.ProgrammingError: sqlalchemy.exc.ProgrammingError:
(psycopg2.errors.InvalidColumnReference) WITH query "parents" has 21
columns available but 23 columns
Which version of SQLAlchemy are you using, and how are you creating
your engine? I believe savepoints are handled differently in SA 1.4 if
you are using the "future-style" engine.
Do these doc links help you at all?