Advertisement
Guest User

Untitled

a guest
Jan 16th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. -- PostgreSQL 10.1
  2. CREATE TABLE test_bytea(test_bytea_id serial PRIMARY KEY, some_blob bytea NOT NULL);
  3. INSERT INTO test_bytea(some_blob)
  4. SELECT CAST(repeat('012345678901', 50000000) AS bytea);
  5.  
  6. > pg_dump -t test_bytea -f test_bytea.dump
  7. pg_dump: Dumping the contents of table "test_bytea" failed: PQgetResult() failed.
  8. pg_dump: Error message from server: ERROR: invalid memory alloc request size 1200000003
  9. pg_dump: The command was: COPY public.test_bytea (test_bytea_id, some_blob) TO stdout;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement