Comments (2)
VAX-1806 Unexpected encoding of a boolean value in a table referenced by an FK
from electric.
I have traced the origin of the "true"
value to this place in LogicalReplicationProducer
module's implementation:
defp process_message(
%Message{transactional?: true, prefix: "electric.fk_chain_touch", content: content},
state
) do
received = Jason.decode!(content)
The JSON-encoded content
is decoded into
%{
"data" => %{"id" => "5", "is_open" => "true", "value" => "five"},
"pk" => ["5"],
"schema" => "public",
"table" => "items",
"tags" => "{\"(\\\"2024-04-23 10:31:43.066+00\\\",)\"}"
}
And "data"
later ends up passed verbatim to the serialization function in the Serialization
module to encode it as part of a SatOpLog
message for the client. The problem lies in the fact that the source encoding of values in this "data"
map is different from what we get when querying Postgres directly with epgsql
functions or when receiving regular logical replication messages.
from electric.
Related Issues (20)
- when select where item contains in json array, array_constiains key not recognize, how to filter if json type constains element HOT 2
- Can't load data when phone is offline in Expo app HOT 5
- [BUG] Syntax error CREATE_REPLICATION_SLOT when install electric-sql with docker HOT 8
- MODULE ERROR: Electric.Replication.PostgresConnector HOT 5
- Possible issue in the new ShapeManager code. HOT 3
- SQLite/PGLite not fully compatible with NextJS HOT 4
- Inactive replication slot causing warnings on DO managed Postgres HOT 6
- Demo example with PostGis plugin?? HOT 1
- Error: FOREIGN KEY constraint failed HOT 4
- [rpc] recv: #SatInStartReplicationResp{`Error: Cannot catch up to the server's current state`} HOT 1
- Unable to install electric-sql on MacOS & Node@22 HOT 2
- Zod rejects UUIDs that Postgres deems valid HOT 1
- `(FunctionClauseError) no function clause matching in Electric.Postgres.Extension.SchemaCache.name/1` HOT 7
- too many arguments on function json_object HOT 2
- Issue with ElectricSQL when I try to change the content of an entry in the database HOT 3
- tauri-sqlite example start failed HOT 2
- Secure auth invalid key HOT 6
- Checkout and Linear example not working (client side issue) HOT 1
- Sync service complains about multiple connections from the same client HOT 1
- Fly deploy (launch) of Quickstart app fails HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from electric.