BUG #14492: Foreign Table import from SQL Server 2005
The following bug has been logged on the website:
Bug reference: 14492
Logged by: jorge castañeda
Email address: jorgito14@gmail.com
PostgreSQL version: 9.6.1
Operating system: Windows 10
Description:
Hi,
I got this problem when i try to do a foreign table that is related from sql
server 2005.
I got a table that is called itinerario, is has too much fields, when i
create the foreign table with the fields, almost all fields insert
correctly, but there are 2 fields that doesnt insert and i don't know really
why.
My two fields are called "MRN varchar(50)" and "sec_itinerario int". It
surprise me because i got too many foreign tables created and no one shows
problems.
One example of the field "MRN" is: CEC2013WHLU5102
I'm using PostgreSQL 9.6.1 and PgAdmin III 1.22.
I tried creating a foreign table called "m_itinerario2" where i just call
the fields "MRN" and "sec_itinerario", when i do this, i got dc from server
on PgAdmin 3 and on PgAdmin 4 i got crash problem.
Any solution/sugestion?
Thanks for the attention,
Jorge
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Thu, Jan 12, 2017 at 6:53 AM, <jorgito14@gmail.com> wrote:
I got this problem when i try to do a foreign table that is related from sql
server 2005.I tried creating a foreign table called "m_itinerario2" where i just call
the fields "MRN" and "sec_itinerario", when i do this, i got dc from server
on PgAdmin 3 and on PgAdmin 4 i got crash problem.Any solution/sugestion?
And I guess that you go through tds_fdw (SQL server FDW) to create the
foreign table. You may want to see about this problem directly with
them:
https://github.com/tds-fdw/tds_fdw
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Is any other FDW for sql server that you know is working correctly with
PostgreSQL 9.6?
--
Jorge
2017-01-11 20:09 GMT-05:00 Michael Paquier <michael.paquier@gmail.com>:
On Thu, Jan 12, 2017 at 6:53 AM, <jorgito14@gmail.com> wrote:
I got this problem when i try to do a foreign table that is related from
sql
server 2005.
I tried creating a foreign table called "m_itinerario2" where i just call
the fields "MRN" and "sec_itinerario", when i do this, i got dc fromserver
on PgAdmin 3 and on PgAdmin 4 i got crash problem.
Any solution/sugestion?
And I guess that you go through tds_fdw (SQL server FDW) to create the
foreign table. You may want to see about this problem directly with
them:
https://github.com/tds-fdw/tds_fdw
--
Michael
--
att. Jorge Castañeda C.