[BUGS] BUG #3986: Error ts_vector with UTF8 WS2003

2008-02-25 Thread Yann
The following bug has been logged online: Bug reference: 3986 Logged by: Yann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 build1400 Operating system: Windows Server 2003 Description:Error ts_vector with UTF8 WS2003 Details: Hi, When i try to execute

Re: [BUGS] BUG #3979: SELECT DISTINCT slow even on indexed column

2008-02-25 Thread Simon Riggs
On Thu, 2008-02-21 at 23:34 +, David Lee wrote: I ran EXPLAIN and it showed that the path did not use the index, so I ran: Your expectation that this would use an index is unfortunately not correct. We need to check visibility on the table rows to do the query. We choose to do this by

Re: [BUGS] Incomplete docs for restore_command for hot standby

2008-02-25 Thread Markus Bertheau
2008/2/22, Simon Riggs [EMAIL PROTECTED]: On Thu, 2008-02-21 at 08:01 +0600, Markus Bertheau wrote: Section 24.3.3.1 states about restore_command: The command will be asked for file names that are not present in the archive; it must return nonzero when so asked. Section

[BUGS] BUG #3987: Not checking the password

2008-02-25 Thread chandra
The following bug has been logged online: Bug reference: 3987 Logged by: chandra Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Linux Description:Not checking the password Details: We have installed postgres in Linux box and accessing

[BUGS] BUG #3988: problem with installation

2008-02-25 Thread Amandeep Singh
The following bug has been logged online: Bug reference: 3988 Logged by: Amandeep Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Windows XP SP-2 Description:problem with installation Details: I downloaded Postgresql 8.3.0 and

[BUGS] BUG #3989: Error when Installing

2008-02-25 Thread
The following bug has been logged online: Bug reference: 3989 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Release Operating system: Vista Description:Error when Installing Details: When trying to install the new release of Postgres 8.3 I'm

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Dave Page
On Sun, Feb 24, 2008 at 12:11 PM, Miroslav Nachev [EMAIL PROTECTED] wrote: Hi Dave, Please find the attached files - log in ZIP format and the messages from MessageBox-es (JPG files). Hi Miro, I don't see why that error would occur unless there's a tmp file in C:\Program

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Miroslav Nachev
Can you send me a script (BAT/CMD) file? Or another installations where more detail log is available? Miro. Dave Page wrote: On Sun, Feb 24, 2008 at 12:11 PM, Miroslav Nachev [EMAIL PROTECTED] wrote: Hi Dave, Please find the attached files - log in ZIP format and the

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Dave Page
On Mon, Feb 25, 2008 at 2:48 PM, Miroslav Nachev [EMAIL PROTECTED] wrote: Can you send me a script (BAT/CMD) file? Or another installations where more detail log is available? Script for what? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Oracle-compatible database company

Re: [BUGS] BUG #3987: Not checking the password

2008-02-25 Thread Tom Lane
chandra [EMAIL PROTECTED] writes: When we connecting to the database it is asking the password. Without giving the password we are able to connect to the database thru pqadmin tool. It should check the password. It sounds like you have different authentication methods selected for different

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Miroslav Nachev
To get up and running though, you should be able to install with initdb disabled and then run it manually from the commandline. How to do the above? Miro. Dave Page wrote: On Mon, Feb 25, 2008 at 2:48 PM, Miroslav Nachev [EMAIL PROTECTED] wrote: Can you send me a

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Dave Page
On Mon, Feb 25, 2008 at 3:39 PM, Miroslav Nachev [EMAIL PROTECTED] wrote: To get up and running though, you should be able to install with initdb disabled and then run it manually from the commandline. How to do the above? When you install, un-check the initdb option on the initdb page

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Miroslav Nachev
I can not start that command because: C:\Program Files\PostgreSQL\8.3\bininitdb -D ../data The program "postgres" is needed by initdb but was not found in the same directory as "C:\Program Files\PostgreSQL\8.3\bin/initdb". Check your installation. In the same time there are 2 files with that

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Dave Page
On Mon, Feb 25, 2008 at 4:56 PM, Miroslav Nachev [EMAIL PROTECTED] wrote: I can not start that command because: C:\Program Files\PostgreSQL\8.3\bininitdb -D ../data The program postgres is needed by initdb but was not found in the same directory as C:\Program

[BUGS] BUG #3990: PostgreSQL does not work

2008-02-25 Thread Rafael Aguilar
The following bug has been logged online: Bug reference: 3990 Logged by: Rafael Aguilar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows vista 32 bits Description:PostgreSQL does not work Details: The PostgreSQL 8.0 does not work

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Miroslav Nachev
Hi, When I see the error I suppose that the kind of the problem is space in the path: "C:\Program Files\PostgreSQL\8.3\bin". Then I use another program path without space and the installation is successful. I mean the regular installation, not patched. Regards, Miro. Miroslav Nachev

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Dave Page
2008/2/25 Miroslav Nachev [EMAIL PROTECTED]: Hi, When I see the error I suppose that the kind of the problem is space in the path: C:\Program Files\PostgreSQL\8.3\bin. Then I use another program path without space and the installation is successful. I mean the regular installation, not

Re: [BUGS] BUG #3990: PostgreSQL does not work

2008-02-25 Thread Peter Eisentraut
Rafael Aguilar wrote: The PostgreSQL 8.0 does not work with Windows Vista 32 bits. 8.0 is 3 years old (compare Vista: 1 year) and deprecated on Windows. Use something newer. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of

Re: [BUGS] BUG #3980: Can not Install PostgreSQL - error at the end of installation

2008-02-25 Thread Miroslav Nachev
Yes, this is curious for me also. Miro. On 2/25/08, Dave Page [EMAIL PROTECTED] wrote: 2008/2/25 Miroslav Nachev [EMAIL PROTECTED]: Hi, When I see the error I suppose that the kind of the problem is space in the path: C:\Program Files\PostgreSQL\8.3\bin. Then I use another

Re: [BUGS] BUG #3986: Error ts_vector with UTF8 WS2003

2008-02-25 Thread Euler Taveira de Oliveira
Yann wrote: When i try to execute the ts_vector function with a text i get the following error : ERROR: 22021: invalid byte sequence for encoding UTF8: 0xc3 It seems to be a client encoding problem. What is your client_encoding? A common problem is a mismatch between client_encoding and the