Re: [GENERAL] Read MS-SQL data into Postgres via ODBC link?

I was really hoping to keep the data-replication (between MSSQL --> PG) contained within a PG function. Instead I could write a small shell script or C service to do this using tsql (freetds). I have access to the MSSQL data via unixodbc and tdsodbc/freetds in my Ubuntu console. But I want to r

Re: [GENERAL] cannot "make USE_PGXS=1" b/c no pgxs.mk exists

.mk exists Jonathan Brinkman wrote: > Makefile:12: /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk: No such > file or directory Maybe you have to install the software package that contains PostgreSQL's development environment. Yours, Laurenz Albe -- Sent via pgsql-general mailin

Re: [GENERAL] Read MS-SQL data into Postgres via ODBC link?

imple pg2pg example: psql -d $DB1 -F '|' -Atc "select * from table;" | psql -d $DB2 -c "copy table from STDIN with delimiter '|' with null '';" A MySQL example would be similar, the second part pretty much identical. HTH, Brent Wood Brent Wood

[GENERAL] Read MS-SQL data into Postgres via ODBC link?

Greetings I'd like to INSERT data into my Postgresql 8.4.8 table directly from an ODBC-linked MS-SQL table or view. I'm looking at using the Cybertec tool "ODBC-LINK" (http://www.cybertec.at/en/postgresql_products/odbc-link) but I'm wondering if there isn't a way to do this through Postgresql di

[GENERAL] cannot "make USE_PGXS=1" b/c no pgxs.mk exists

Greetings I'm trying to set up Cybertec's ODBC_LINK program (http://www.cybertec.at/download/odbc_link/2010_03_16_odbc_link.pdf ) so I can read MS-SQL data into my Postgresql 8.4.8 database. I'm using Ubuntu 10.04 LTS Server. Their build instructions say to Compile the module using make USE_PGXS=1

Re: [GENERAL] TO_CHAR(timestamptz,datetimeformat) wrong after DST change

I was setting TIME ZONE to 'EST' in my formatting function, and I've now learned that EST is NOT the same as 'America/New_York', as EST is not DST-sensitive. I mistyped, the 2011-03-17 18:21:50-04 should have been 2011-03-17 10:21:50-04 Thank you all!! -Original Message- From: Steve C

[GENERAL] custom search_path reverts to default after DB restore

Greetings I have a customized search_path for my database. When I backup (pgdump) the database and restore it to another server, the search_path must be reset, since it reverts to $User, public upon restore. Why is the search_path info not being retained in the backup? Thank you! Jonathan -- Se

Re: [GENERAL] searchpath reverts to default after each server restart

alter database "MYDATABASE" SET search_path TO custom, clientdata, configs, replication, structure, archive; that seems to fix it. Thank you! -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Wednesday, September 15, 2010 4:40 PM To: Jonathan Brinkman

[GENERAL] searchpath reverts to default after each server restart

When i run the command SET search_path TO custom,idsystems, clientdata, configs, replication, structure, archive; then when I run SHOW search_path; it does show those schemas as the search_path. however when i restart the postgresql service, the search_path has reverted to $User, public. when i p

Re: [GENERAL] I keep getting "type does not exist" on compile of this SETOF function (list 2 table)

Thanks, yes the schema was missing from the DECLARE rs statement! -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Monday, September 13, 2010 1:35 PM To: Jonathan Brinkman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] I keep getting "type does not

[GENERAL] I keep getting "type does not exist" on compile of this SETOF function (list 2 table)

[CODE] BEGIN; DROP TYPE structure.format_list2table_rs CASCADE; CREATE TYPE structure.format_list2table_rs AS ( "item" VARCHAR(4000) ); END; CREATE OR REPLACE FUNCTION structure.format_list2table ( "v_list" varchar, "v_delim" varchar ) RETURNS SETOF structure.format_list2table_rs AS $bod