cannot "make USE_PGXS=1" b/c no pgxs.mk exists
Greetings
I'm using Ubuntu 10.04 LTS Server and Postgresql 8.4.8. I'm trying to set up Cybertec's ODBC_LINK program (http://www.cybertec.at/download/odbc..._odbc_link.pdf ) so I can read MS-SQL data into my Postgresql 8.4.8 database. Their build instructions say to Compile the module using make USE_PGXS=1. Code:
sudo make USE_PGXS=1 Quote:
Why are the PGXS files / folders not automatically created for me? How can i install PGXS so that the make process succeeds? If someone knows an easier way to read directly from a MS-SQL table or view into a Postgres function I'd love to know about it! I don't want to use MSSQL DTS as i don't have control of that server, so i can't use .csv intermediary files or that kind of strategy (i can only access 2 read-only views on their server). I'm trying to Code:
INSERT INTO postgres_table (pg fields...) SELECT * FROM ODBCSOURCE; Help! |
i hope this will be useful
http://postgresql.1045698.n5.nabble....td4551314.html |
thanks, no, that is my post in the postgresql world trying to get answers to how to import data directly to Postgres from an ODBC link. Now I'm just trying to get PGXS working so I can attempt to install the ODBC-Link program.
Apparently I need to "set the PGXS environment variable" or "copy it into the contrib directory of your source code and compile it like a contrib module". I tried Quote:
Quote:
|
All times are GMT -5. The time now is 08:03 PM. |