Re: [GENERAL] Read tables of sql server with postgres

2014-03-04 Thread loref85
So, there's no way to do this? 



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Read-tables-of-sql-server-with-postgres-tp5793046p5794581.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Read tables of sql server with postgres

2014-03-04 Thread Merlin Moncure
On Tue, Mar 4, 2014 at 6:48 AM, loref85 lore...@yahoo.com.ar wrote:
 So, there's no way to do this?

You might want to give jdbc-fdw a try.  not sure what's wrong with
odbc -- looks like a driver mismatch issue.

merlin


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Read tables of sql server with postgres

2014-03-04 Thread Adrian Klaver

On 03/04/2014 04:48 AM, loref85 wrote:

So, there's no way to do this?



In your original post you said you found a version of odbc_fdw that 
compiled for 9.2+, but hung on a select due to this error:


ERROR:  odbc_fdw::odbcGetTableSize: Could not retrieve table size

Have you tried to contact the author of the odbc_fdw extension and see 
what they have to say?




--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general