pg-el icon indicating copy to clipboard operation
pg-el copied to clipboard

Cannot use `bigint` as a type

Open ahyatt opened this issue 3 months ago • 0 comments

I am inserting values into a database, using a bigint as a type, since my row IDs are going to be large. If I execute the following:

(pg-exec-prepared #<PostgreSQL connection to test, pid 17013> "INSERT INTO test_collection_sv_postgres (id, vector, \"my-val\") VALUES ($1, $2, $3), ($4, $5, $6), ($7, $8, $9)\n                    ON CONFLICT (id) DO UPDATE SET vector = EXCLUDED.vector, \"my-val\" = EXCLUDED.\"my-val\";" ((10000000000 . "bigint") ([0.1 0.2 0.3] . "vector") (1 . "BIGINT") (20000000000 . "bigint") ([0.4 0.5 0.6] . "vector") (2 . "BIGINT") (30000000000 . "bigint") ([0.7 0.8 0.9] . "vector") (3 . "BIGINT")))

I get the following error:

(pg-error "Don't know the OID for PostgreSQL type bigint")

Since bigint is a standard Postgres numerical type, I think it should be supported here - I guess as an alias of int8.

ahyatt avatar Oct 11 '25 22:10 ahyatt