[GENERAL] psql file restore - problem with encoding

Hi all, I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem: I have dump file created with pg_dump on my dev linux machine (PostgreSQL 8.0.1). When I upload the file to the client's

Re: [GENERAL] psql file restore - problem with encoding

Just update - the system is Fedora Core 2, but the PostgreSQL is compiled from sources. Miroslav ulc wrote: Hi all, I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem: I have dump

Re: [GENERAL] psql file restore - problem with encoding

John DeSoi wrote: On Mar 16, 2005, at 9:34 AM, Miroslav ulc wrote: I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem: Maybe try setting the client side encoding explicitly at the top

Re: [GENERAL] psql file restore - problem with encoding (solved)

We have solved the problem. Maybe someone will face the same problem so just to close this thread, the problem was in php.ini where a default output character set was set which caused the second recoding problem (just for display using php). Miroslav ulc wrote: Hi all, I have problem on one

Re: [GENERAL] Localization problems between Access and PostgresSQL

Secrtariat wrote: Hello, I've dumped the content of MS-Access 2002 SP3 tables on a PC with Windows XP Pro in French localization. Then I COPY these files, on the same PC hosting an PostgreSQL 8.0.1 database. I've problems with the accents !? Why ? Luc, what encoding did you set for your

Re: [GENERAL] Internal account lookup failure

sferriol wrote: hello on windows 2000 (chinese) during postgres8.0.0-rc1.msi installation, it fails in 'Service configuration': Internal account lookup failure Is there a reason for not using version 8.0.1? Maybe this one will install without problem. sylvain Miroslav begin:vcard

Re: [GENERAL] prelimiary performance comparison pgsql vs mysql

Hi Rick, the work you are doing is important (at least I think so). From my experience PosgreSQL performance is also very slow in case there are several LEFT JOINs and there are varchar() fields. You can see an example in archive where my problem is described (Subject: How to read query plan).

Re: [GENERAL]

Mohsen Pahlevanzadeh wrote: Dears, When i wanna insert to my following code,I receive following error: Insert into c(t) values('ccc'); -- It's my qurey. Insert command failed!So i can't continue to insert in your table! ERROR: pg_atoi: error in ccc: can't parse ccc Usually atoi

Re: [GENERAL] free space map settings

go wrote: Hi Tell me please what does it mean the next hint: TIP 7: don't forget to increase your free space map settings where can i read about this settings? http://www.postgresql.org/docs/8.0/interactive/runtime-config.html -- Igor Miroslav begin:vcard fn;quoted-printable:Miroslav

Re: [GENERAL] Problem with special character on

David Gagnon wrote: Thanks for your answer. The ISP created the db fom me .. So I don't have this information. I search the web to know how to get this info via PgadminIII and I haven't found :-( Is there a way to get this information once the database have been created ? I looked via psql

Re: [GENERAL] Problem with special character on

David Gagnon wrote: Hi Thanks for the tips. Locale are the same ... unless I don`t look at the right thing... ... Can you try to run the procedure from some other environment? It seems you use some Java class, so I mean try psql, phpPgAdmin or something different. Miroslav begin:vcard

Re: [GENERAL] General query optimization howto

Bruce Momjian wrote: Have you read the FAQ? Yes, but I have found only some useful information saying when indexes are not used. Miroslav ulc begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable

Re: [GENERAL] General query optimization howto

Peter Eisentraut wrote: Miroslav ¦ulc wrote: is there on the net any general howto on SQL query optimizations? We have recently moved our project from MySQL to PostgreSQL and are having problem with one of our queries. I doubt that there is a generic documentation on SQL optimization

[GENERAL] General query optimization howto

the query so I'm looking for some intro that could help me. -- Miroslav ulc begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet

Re: [GENERAL] Locale problem

for the database (= in this example 'UNICODE'). Then the sorting should be correct. I'm just a newbie for PostgreSQL so somebody might explain it more precisely. People, help pls to megrate to PG 8.01 properly Thanks, and have a nice day!! Igor Miroslav ulc begin:vcard fn;quoted-printable:Miroslav

Re: [GENERAL] postgres 7.4 build for win

Hi Amin, maybe I'm little off but why don't you try the 8.0.1 version which should run on Windows platform? Miroslav ulc Amin Abdulghani wrote: Hi, I am trying to build postgres 7.4.5 on windows (200) on mingw/msys env. I have installed win32-pthreads to enable-thread safet feature. Couple

Re: [GENERAL] PRoblems instalation PostgreeSQL8.0.1 in WindowsXP

. Miroslav ulc begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet:[EMAIL PROTECTED] title:CEO tel;work:+420 257 225 602 tel;cell