I have a linked server on SQL server 2005. I can update or write to a
table in Postgres that does not have a OID. But the Table I have has an
OID and I cannot write or update to that table. Anyone have any ideas.
I would replace the ',' with something else such as a '#' first then
replace the decimal with the ',' then replace the '#' with a decimal '.'
If you do the ',' with a '.' first then all of them will be '.' and you
wont know which ones to change.
-Original Message-
From: [EMAIL PROTECTED]
another problem then. Our date format is also
german :-( "DD.MM.YY" or
"DD.MM.". So if I just exchange '.' and ',' the date will be
unreadable for the import :-(
The (current) file is 1.4 GB so it will take ages to let awk chew on it
I guess.
Chr
Yes the table does have a primary key defined.
-Original Message-
From: Adrian Klaver [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 06, 2008 7:07 PM
To: Ken Allen; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cannot update table with OID with linked server
in SQl Server
