This repository was archived by the owner on Sep 19, 2024. It is now read-only.
This repository was archived by the owner on Sep 19, 2024. It is now read-only.
Can't insert more than 657 records into a table #45
Description
What I want to do
I want to insert more than 1000 records into a table to see the performance of Postgres WASM.
What I did
I have a file to load data to a table like https://gist.github.com/satob/421f19ed438a9abe56b7139022df44d2 .
I have uploaded the file with [Transfer Files] and run \i /mnt/test.sql on the psql console.
What I expected
All INSERT INTO statements are executed and the employee table has 1,000 records.
What I got
psql returns an error with the following message:
postgres=# \i /mnt/test.sql
CREATE TABLE
INSERT 0 1
(snip)
INSERT 0 1
psql:/mnt/test.sql:665: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
psql:/mnt/test.sql:665: fatal: connection to server was lost
#
The employee table only has 657 records.
postgres=# select count(*) from employee;
count
-------
657
(1 row)
After the error, I couldn't insert any records into the table.
# psql -U postgres
psql (14.5)
Type "help" for help.
postgres=# insert into employee values (998, 'Guy Zimmerman');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!?>
Question
How can I insert more than 1000 records into a table on Postgres WASM?