[BUGS] Postgres8.0.4 install problem

2005-11-08 Thread Maneesh Sharma
Hi to all, I am trying to install postgres8.0.4 on Linux but at tar command it is giving error every time. I also tried to downpload postgres file on different mirror sites but no change in error. I have tried postgres7.4.9 but getting same error. Can anybody do let me know about this error

[Fwd: [BUGS] initdb.log]

2005-11-08 Thread Diego Cattelan
... child process was terminated by signal 1 initdb: removing contents of data directory "C:/Programmi/PostgreSQL/8.1/data" I worked around installing without running initdb and then manually runas /user:DOMAIN\postgres cmd initdb -D c:\programmi\postgresql\8.1\data ... start the service a

[BUGS] Roomity.com v 1.5 is a web 2.01

2005-11-08 Thread shenanigans
I was interested in getting feedback from current mail group users.We have mirrored your mail list in a new application that provides a more aggregated and safe environment which utilizes the power of broadband.Roomity.com v 1.5 is a web 2.01 community webapp. Our newest version adds broadcast vide

[BUGS] initdb.log

2005-11-08 Thread Diego Cattelan
Sorry if I missed some FAQ but I have a problem during initdb PostgreSQL 8.1 on Windows XP SP2 ITA update from 8.0.4: - backup previous data - uninstall and erased PostgreSQL 8.0.4 directory - rebooted system - trying install 8.1, but on initdb ... The files belonging to this database system wil

Re: [BUGS] a problem, maybe not a bug

2005-11-08 Thread Tom Lane
acvolcano <[EMAIL PROTECTED]> writes: > I use the postgresql package for my embeded platform. while > cross-compile the package, It occurs an error and I can't dispose it. Sorry, we don't currently support cross-compilation, precisely because the "zic" program has to be run during installation. T

Re: [BUGS] BUG #2027: Select on view hangs.

2005-11-08 Thread Tom Lane
"Dmitri Fuerle" <[EMAIL PROTECTED]> writes: > A select on the following view hangs the database Are you sure it's actually hung, and not (say) computing like mad? Perhaps the planner chose a bad plan that will take a long time. Have you ANALYZEd all the tables underlying the view?

Re: [BUGS] FW: [pgadmin-support] Column name validation in embedded query.

2005-11-08 Thread Tom Lane
"Lori Pate" <[EMAIL PROTECTED]> writes: > However, when the query with the incorrect column name (Query A) is > embedded in a where clause, column validation does not happen, no error > is displayed, and PGAdmin apparently ignores the where clause all > together, resulting in complete data deletion

Re: [BUGS] BUG #2023: Assertion Failure: File: "slru.c", Line: 309

2005-11-08 Thread Alvaro Herrera
Joel Stevenson wrote: > I'm running 8.1RC1 on a RHEL 3 machine (dual proc Xeon w/2G of ram). Under > extremely heavy load (for the hardware) Postgres is periodically throwing > the following assertion error: > > TRAP: FailedAssertion("!(shared->page_number[slotno] == pageno && > shared->page_sta

Re: [BUGS] BUG #2027: Select on view hangs.

2005-11-08 Thread Alvaro Herrera
Dmitri Fuerle wrote: > A select on the following view hangs the database > and produces the lock table at the bottom of the message It doesn't look like it's actually waiting on a lock (unless you managed to paste only a portion of pg_locks). Are you running on NFS or some such? -- Alvaro Her

Re: [BUGS] BUG #2025: i can conect to the server

2005-11-08 Thread Richard Huxton
edgar garcia wrote: Bug reference: 2025 Operating system: Windows xp Description:i can conect to the server when try to connect with tiny application, show a error connection. Are ther some ficxes to connect. I selected : Port port 5443 You mean 5432 here don't you? host loc

[BUGS] BUG #2024: Wrong Greek ISO-encoding assignment

2005-11-08 Thread Nikolaos Papageorgiou
The following bug has been logged online: Bug reference: 2024 Logged by: Nikolaos Papageorgiou Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0.1 Operating system: Windows 2000 Professional & XP Pro Description:Wrong Greek ISO-encoding assignment Details:

[BUGS] BUG #2027: Select on view hangs.

2005-11-08 Thread Dmitri Fuerle
The following bug has been logged online: Bug reference: 2027 Logged by: Dmitri Fuerle Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Mac OS X Description:Select on view hangs. Details: A select on the following view hangs the database an

[BUGS] a problem, maybe not a bug

2005-11-08 Thread acvolcano
hi, I use the postgresql package for my embeded platform. while cross-compile the package, It occurs an error and I can't dispose it. Maybe your can give me some advise. My configure file (as follows): #!/bin/bash rm config.cache config.status -f CC=arm-linux-gcc \ CXX=arm-linux-g++

[BUGS] BUG #2028: delphi-->postgresql

2005-11-08 Thread Robert Pausch
The following bug has been logged online: Bug reference: 2028 Logged by: Robert Pausch Email address: [EMAIL PROTECTED] PostgreSQL version: all Operating system: win98,winME,winXP Description:delphi-->postgresql Details: Hello, I use delphi client. A table, ec. id

[BUGS] FW: [pgadmin-support] Column name validation in embedded query.

2005-11-08 Thread Lori Pate
Title: Re: [pgadmin-support] Column name validation in embedded query. I am using pgAdmin III, PostgreSQL tools, Version 1.2.0 Beta on Windows XP Pro. The following query, when executed as a stand alone query returns an error, correctly, that the column name is not valid:Query A) Select patie

[BUGS] BUG #2025: i can conect to the server

2005-11-08 Thread edgar garcia
The following bug has been logged online: Bug reference: 2025 Logged by: edgar garcia Email address: [EMAIL PROTECTED] PostgreSQL version: 8 Operating system: Windows xp Description:i can conect to the server Details: when try to connect with tiny application, show

[BUGS] Problems with index-scan on regexp in 8.1

2005-11-08 Thread Lars Kanis
Sorry, I accidentally posted this at pgsql-hackers already. Again: We're using Postgres 8.0.2 on SuSE10.0 (64-Bit). Tests on 8.1 beta 4 have shown no problems but this one: SELECT * FROM mitglieder WHERE lower(vorname::text)='lars' does a bitmap-index-scan like this: Bitmap Heap Scan on mi

[BUGS] BUG #2023: Assertion Failure: File: "slru.c", Line: 309

2005-11-08 Thread Joel Stevenson
The following bug has been logged online: Bug reference: 2023 Logged by: Joel Stevenson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1RC1 Operating system: RHEL 3 update 6 Description:Assertion Failure: File: "slru.c", Line: 309 Details: Hi, I'm running 8