3 ms·
Would love to use it. But I get this error in Chrome when I try to connect: > Disconnected from PostgreSQL (Error: Too many result rows to serialize: Try using
by chime 9y ago
Would love to use it. But I get this error in Chrome when I try to connect:
> Disconnected from PostgreSQL (Error: Too many result rows to serialize: Try using a LIMIT statement.)
This is on my console (my credentials replaced with ellipses):
~> npx franchise-client@0.2.2
npx: installed 140 in 12.533s
franchise-client listening on port 14645
opened connection
received: {"action":"get_postgres_credentials","id":1}
received: {"action":"open","db":"postgres","credentials":{"id":1,"host":"localhost","user":"...","database":"...","port":"...","autofilled":true,"password":"..."},"id":2}
received: {"action":"exec","sql":"SELECT table_schema, table_name, column_name\n FROM information_schema.columns \n WHERE table_schema not in ('pg_catalog', 'information_schema', 'pg_internal')","id":3}
Error: Too many result rows to serialize: Try using a LIMIT statement.
at Object.query (~/.npm/_npx/736/lib/node_modules/franchise-client/response.js:128:23)
at <anonymous>
at process._tickCallback (internal/process/next_tick.js:188:7)
I ran the SELECT query in Valentina Studio and got 11000+ rows in 4s. Maybe raise the acceptable row count to 100,000?