-
-
Notifications
You must be signed in to change notification settings - Fork 1.2k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Writing 80K bytea columns #1166
Comments
Actually, |
What is your table's schema? |
elf_file is a bytea column, Not Null with extended storage. The other fields are an integer, a bigint, and a character varying 32. |
Can you provide a simple but complete example? Can you provide the full psql output for |
|
I'm trying to insert a row with a bytea column, using a Uint8Array variable.
pool.queryPool ( "INSERT INTO DeviceOS (elf_file) VALUES($1::bytea)", [elf_file], function(err, result) {...});
elf_file
is aUint8Array
The operation fails. In the callback:
err.code
ends up being'22001'
err.message
ends up being'value too long for type character varying(1024)'
Is this a bug or operator error? Is
Uint8Array
not a valid type for a bytea field?The text was updated successfully, but these errors were encountered: