As far as I know, UTF-8 is the standard encoding used by MSSQL.
ISO8859-1 is LATIN1, so the system is trying to convert
(as the error message says) from utf-8 (SqlServer) to ISO8859-1 (
LATIN1 ).
So I think you have to search on the MSSQL side, not PostgreSql...
You can also use UNICODE encod
I don't know, OS x; on linux the local directory is
/usr/local/pgsql/data for 8.0 version, and used to be
/var/lib/pgsql/data on older versions for linux redhat.
You should have the default superuser account postgres and the
database
template1 (don't change it, just login and create you own o
At least, you can do a "select count(*) from ..." just before the
delete, better if inside a transaction, if the query itself is not too
much expensive
Andrus wrote:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read
If, as the name of the column suggests, the backslash is used for
pathnames, why don't you bypass the problem by using normal slash (I.E:
"path/to/my/file")? It works well
with new windows versions and, of course, unix-style pathnames
Hope this helps, Roberto
ketan shah wrote:
Hi,
All,
Title: Signature
I think it's because of uppercase letters: if you don't quote ...
create table "OfficeTalk.absent" , postgresql will lowercase
everything
regards
Josef Springer wrote:
Hi,
sorry, i am a PostgesSQL beginner:
I started the pgadmin tool as superuser.
Create
Andrus wrote:
I try to convert code from other database to Postgres.
CREATE TABLE test(test BOOLEAN);
SELECT MAX(test) FROM test;
causes error
ERROR: function max(boolean) does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.
