pgfutter
pgfutter copied to clipboard
lukasmartinelli
Table never creates
Trying to import test data into PostgreSQL 9.1
pgfutter --user postgres --port 30000 --schema public csv friends.csv
74 B / 74 B [====================] 100.00% 0
3 rows imported into public.friends
No table is created though. Looking in pg_log I see this...
ERROR: schema "public" already exists
STATEMENT: CREATE SCHEMA public
I have tried creating a new schema as well but still no joy. This is on a CentOS 6.7 box. Here is the version info if it helps.
PostgreSQL 9.1.23 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17), 64-bit
No table is created though. Looking in pg_log I see this...
It does try to create the schema but shouldn't be the cause for failing. I must say I never tested it with PostgreSQL 9.1...
You are able to import it into the import schema?
No, not into import schema either. No matter if I use import or public, it always says the schema already exists, even if it doesn't. Do you have plans to add support for it? It really looks like the answer to my prayers but I can't change the version of my postgres server. Thanks so much for the quick response!
Ken
On Tue, Sep 27, 2016 at 2:14 AM, Lukas Martinelli [email protected] wrote:
No table is created though. Looking in pg_log I see this...
It does try to create the schema but shouldn't be the cause for failing. I must say I never tested it with PostgreSQL 9.1...
You are able to import it into the import schema?
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/lukasmartinelli/pgfutter/issues/29#issuecomment-249784796, or mute the thread https://github.com/notifications/unsubscribe-auth/AVbSNafoU5BrWde7PtVs-XY0bDxQH42sks5quMJJgaJpZM4KHUxG .
No, not into import schema either. No matter if I use import or public, it always says the schema already exists, even if it doesn't.
After PostgreSQL 9.3 there is support to only create schema if it does not exist yet. But I don't think the schema creation is the problem here.
Do you have plans to add support for it? It really looks like the answer to my prayers but I can't change the version of my postgres server. Thanks so much for the quick response!
Can't promise. Perhaps I find a moment to make a quick test with it later and figure out what's wrong.
Ok, I understand completely. If I can provide any logs or test anything it for you, please let me know.
I'm going to look at a different alternatives for the moment, but I am more than happy to test out any new code and document findings.
Regardless of your ability to add support for 9.1, your tool looks amazing and I appreciate you working to create such an awesome tool!
On Sep 27, 2016 2:51 AM, "Lukas Martinelli" [email protected] wrote:
No, not into import schema either. No matter if I use import or public, it always says the schema already exists, even if it doesn't.
After PostgreSQL 9.3 there is support to only create schema if it does not exist yet. But I don't think the schema creation is the problem here.
Do you have plans to add support for it? It really looks like the answer to my prayers but I can't change the version of my postgres server. Thanks so much for the quick response!
Can't promise. Perhaps I find a moment to make a quick test with it later and figure out what's wrong.
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/lukasmartinelli/pgfutter/issues/29#issuecomment-249791873, or mute the thread https://github.com/notifications/unsubscribe-auth/AVbSNZvJ2mEGV8uGhtFA2A8Y4_eE5wNUks5quMr8gaJpZM4KHUxG .