You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
At the moment this plugin does not support incremental querying for tables with an OID primary key.
The problem is that OID is defined at the moment as an unsigned 4 byte integer but the initial offset is a negative number.
The first query will look like this: SELECT * FROM "public"."config" WHERE "public"."config"."oid" > -1 ORDER BY "public"."config"."oid" ASC
And PostgreSQL will respond with: OID out of range.
Way to overcome this problem:
create a view in source database which casts OID to INT8 cast(id as int8)
use query mode and lose the ability to do incremental updates
Suppose the database has all tables with OID primary keys. It would be nice to be able to customize the condition in WHERE clause through a configuration parameter (condition_pattern?) the default being '%s > ?'. In that case it would be possible to do the casts for all the tables with cast(%s as int8) > ?.
The text was updated successfully, but these errors were encountered:
At the moment this plugin does not support incremental querying for tables with an OID primary key.
The problem is that OID is defined at the moment as an unsigned 4 byte integer but the initial offset is a negative number.
The first query will look like this:
SELECT * FROM "public"."config" WHERE "public"."config"."oid" > -1 ORDER BY "public"."config"."oid" ASC
And PostgreSQL will respond with: OID out of range.
Way to overcome this problem:
cast(id as int8)
Suppose the database has all tables with OID primary keys. It would be nice to be able to customize the condition in WHERE clause through a configuration parameter (condition_pattern?) the default being '%s > ?'. In that case it would be possible to do the casts for all the tables with
cast(%s as int8) > ?
.The text was updated successfully, but these errors were encountered: