Re: [BUGS] BUG #1455: pg_dumpall fails

2005-02-02 Thread Boris Makovecki
Currently I'm using 7.4.0 version. I'll first upgarade to 7.4.7 and then try to upgarade to 8.0.1, thanks, Boris Makovecki -Original Message- From: Tom Lane <[EMAIL PROTECTED]> To: "Boris Makovecki" <[EMAIL PROTECTED]> Cc: pgsql-bugs@postgresql.org Date: Thu, 03 Feb 2005 01:02:01 -0500

Re: [BUGS] BUG #1457: ./configure --with-openssl --enabled-thread-safety fails

2005-02-02 Thread Peter Eisentraut
Tim Larson wrote: > Required lib installed at /usr/include/openssl/ssl.h, but ./configure > step still fails all three tests for it. But without showing us the complete details, we won't be able to fix it. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(

Re: [BUGS] BUG #1454: error in "select * from table where a1 like '%\%%' " ???

2005-02-02 Thread Peter Eisentraut
Ricky wrote: > I perform a query to get data,which contains '%'. > so I do this query. > select * from table where a1 like '%\%%'; > but it returns all rows. select * from table where a1 like '%\\%%'; The first \ escapes the second \ for the string parser, the second \ is the escape character fo

Re: [BUGS] BUG #1458: to_char is crazy

2005-02-02 Thread Alvaro Herrera
On Wed, Feb 02, 2005 at 12:27:53AM +, Tomás Zandoná wrote: Hey Tomás, > I dont't know if it's a bug, but I insert the date 2005-10-09 in a Date > field. > Later I execute: > > select to_char(day, 'DD/MM/') from test_table; > > It returns 08/10/2005. > > ? I don't understand why i

Re: [BUGS] BUG #1455: pg_dumpall fails

2005-02-02 Thread Tom Lane
"Boris Makovecki" <[EMAIL PROTECTED]> writes: > I'm trying to migrate postgre DB from 7.4 to 8.0. When I start pg_dumpall > (8.0) and connect it to 7.4 it fails with error: > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: cannot cast type "unknown" to > text > pg_dump: T

[BUGS] BUG #1458: to_char is crazy

2005-02-02 Thread Tomás Zandoná
The following bug has been logged online: Bug reference: 1458 Logged by: Tomás Zandoná Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: i don't know Description:to_char is crazy Details: I'm from brazil. I don't wrote English very well.

[BUGS] Probably libpq on windows bug

2005-02-02 Thread Filip Hrbek
Hello,   I have a problem with libpq behaviour on Windows.   I have no problem to connect to the database and execute SQL statments. The error happens if I try to call a non-existent SQL function, e.g.   select function_which_is_really_not_here();   I should get an error: ERROR:  function f

Re: [BUGS] Bad planner decision in Postgres

2005-02-02 Thread Matthew Wakeling
> Matthew Wakeling <[EMAIL PROTECTED]> writes: > > [ snip... ] > > If we remove the limit, then the planner switches to this query plan: > > > Limit (cost=156.24..156.26 rows=10 width=14) > > ... which still has a limit. I think you have made several cut-and-paste > errors here, because the plan

[BUGS] Password authentication on Windows psql

2005-02-02 Thread Filip Hrbek
Hello,   I have a problem with psql on Windows XP Pro. After an attempt to connect to a database I get this error:   psql: FATAL:  password authentication failed for user ""   This happens both for local (Windows) and remote (Linux) database. Both databases are easily accessible from other cl

[BUGS] install errors with dspace

2005-02-02 Thread Nigel Pegus
Hello I am installing postgresql 7.4.3 with ant 1.6.1 jdk1.4.3 tomcat web server 5.0.19 under linux enterprise ws and I ran in to trouble with the with-java switch og the configure option. It produed errors so I left out the with-java switch and downloaded jdbc compiled driver. I noticed h

[BUGS] BUG #1456: COPY FROM error

2005-02-02 Thread Pascal Van Puymbroeck
The following bug has been logged online: Bug reference: 1456 Logged by: Pascal Van Puymbroeck Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows 2000 Description:COPY FROM error Details: The COPY table FROM command works fine as lo

[BUGS] BUG #1455: pg_dumpall fails

2005-02-02 Thread Boris Makovecki
The following bug has been logged online: Bug reference: 1455 Logged by: Boris Makovecki Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows 2K3 web server Description:pg_dumpall fails Details: I'm trying to migrate postgre DB from 7

[BUGS] Postgres install on windows 2003 server

2005-02-02 Thread Adodo, Adewale
I am having problems installing PostgresSQL 8.0.0 on our windows 2003 server. I downloaded the postgresql-8.0.1.zip installer from http://www.postgresql.org/ftp/win32/ but each time I try to install it I get a "Error binding test network socket: 10013" error message. This always happens at the p

[BUGS] BUG #1454: error in "select * from table where a1 like '%\%%' " ???

2005-02-02 Thread Ricky
The following bug has been logged online: Bug reference: 1454 Logged by: Ricky Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Mandrake Linux 10.1 Description:error in "select * from table where a1 like '%\%%' " ??? Details: I perform a qu

[BUGS] BUG #1457: ./configure --with-openssl --enabled-thread-safety fails

2005-02-02 Thread Tim Larson
The following bug has been logged online: Bug reference: 1457 Logged by: Tim Larson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: YDLinux 3.0.1 Description:./configure --with-openssl --enabled-thread-safety fails Details: Required lib

[BUGS] timezone offsets and documentation

2005-02-02 Thread Kris Jurka
The documentation says the time with time zone datatype allows zone offsets from +12 to -12. http://www.postgresql.org/docs/8.0/static/datatype-datetime.html This is at odds with the implementation which allows values +1359 to -1359 jurka=# select '00:00:00+1359'::timetz; timetz