text column error when using "select ... into cstore_fdw_table from ...." about cstore_fdw HOT 4 CLOSED

Hello
Thanks for reporting the issue.
would you mind sharing more data that would help us investigate the problem ?

• table schema
• insert/select statements
• sample data if possible

thanks

from cstore_fdw.

I could generate a related error, but not the exact error:

CREATE TABLE text_data AS
SELECT string_agg(random()::text, '')
FROM generate_series(1, 1000) a, generate_series(1, 10) b
GROUP BY b;

CREATE FOREIGN TABLE cstore_text_data(A text) SERVER cstore_server;

INSERT INTO cstore_text_data SELECT * FROM text_data;

SELECT char_length(a) FROM cstore_text_data;

DROP TABLE text_data;

SELECT char_length(a) FROM cstore_text_data;

ERROR:  could not open relation with OID 16522

We are looking into this and will resolve it.

I think both errors should be because of the same bug, so solving this issue will also resolve the original issue, although you will need to reload your data in the cstore table.

from cstore_fdw.

this issue is fixed and merged into development branch. it will be available in master branch at upcoming release (1.2)

from cstore_fdw.

Merged into master. Closing.

from cstore_fdw.