Re: [BUGS] BUG #2327: Startup script for FC4 with selinux

2006-03-16 Thread Peter Eisentraut
Tom Lane wrote: > We could push the RPM initscript into the contrib item, but I fear > we'd forget again to keep it up to date. I doubt that the RPM init script is going to be portable to all Linux systems. I think it's useful to have a generic script there for people doing source installations

Re: [BUGS] BUG #2327: Startup script for FC4 with selinux

2006-03-16 Thread Devrim GUNDUZ
Hi, On Fri, 2006-03-17 at 00:31 -0500, Tom Lane wrote: > We could push the RPM initscript into the contrib item, but I fear > we'd > forget again to keep it up to date. > > Comments anyone? We don't change initscript so often, so keeping it up2date will not be hard -- I'll remind you when we cha

Re: [BUGS] BUG #2317: Wrong sorting order for (VW)

2006-03-16 Thread Tomas Zerolo
On Thu, Mar 16, 2006 at 11:03:59AM +0100, Tomas Klockar wrote: [...] > I would say that sorting V and W as the same character may work in a > dictionary [...] > Currently the sortingfunction in postgreSQL have disqualified itself > from beeing used, and I do the sorting in java which treat them

Re: [BUGS] BUG #2326: Problems Upgrading from 8.0.2

2006-03-16 Thread Tom Lane
"Dan B." <[EMAIL PROTECTED]> writes: > I'm trying to restore a database dumpall from postgres 8.0.2 to an 8.1.3 > installation on the same machine but have encountered an error which has > resulted in some views not being recreated. > ... > " psql:backuptoday.bak:5182: ERROR: missing FROM-clause e

Re: [BUGS] BUG #2327: Startup script for FC4 with selinux

2006-03-16 Thread Tom Lane
"Tom Hollins" <[EMAIL PROTECTED]> writes: > It was in a previous version of the init scripts. Not sure if those came > with the OS release or whether I installed it. However, if you want to > release the script for FC4 just edit your ../contrib/startup-scripts/linux > and replace all su commands wi

Re: [BUGS] BUG #2318: language

2006-03-16 Thread Tomas Zerolo
On Thu, Mar 16, 2006 at 01:02:57PM +0100, Andreas Pflug wrote: > Tomas Zerolo wrote: [...] > > export LANG=C pgadmin & > > This is a wrong advice. > Mete, use the option dialog to select your favourite language. Don't > touch the environment. OK, I assume you *do* know, gven your mail address

[BUGS] Merge join bug?

2006-03-16 Thread Bruce Momjian
Someone has reported to me that VACUUM ANALYZE is causing different results for the same query. They believe it is caused by merge join. I tested in both 8.1.X and CVS HEAD and both appear to be affected. SQL test attached. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://w

[BUGS] BUG #2326: Problems Upgrading from 8.0.2

2006-03-16 Thread Dan B.
The following bug has been logged online: Bug reference: 2326 Logged by: Dan B. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Mac OS X 10.4.1 Description:Problems Upgrading from 8.0.2 Details: I'm trying to restore a database dumpall f

[BUGS] BUG #2327: Startup script for FC4 with selinux

2006-03-16 Thread Tom Hollins
The following bug has been logged online: Bug reference: 2327 Logged by: Tom Hollins Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Linux (Fedora Core 4) Description:Startup script for FC4 with selinux Details: It was in a previous vers

[BUGS] BUG #2324: OLE DB Provider error

2006-03-16 Thread Pavel
The following bug has been logged online: Bug reference: 2324 Logged by: Pavel Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP Description:OLE DB Provider error Details: I have troubles/errors with the PostgreSQL OLE DB Provider

Re: [BUGS] BUG #2317: Wrong sorting order for (VW)

2006-03-16 Thread Tomas Klockar
Magnus Hagander wrote: The following bug has been logged online: Bug reference: 2317 Logged by: TomasKlockar Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2/7.4.7 Operating system: linux(fedora) Description:Wrong sorting order for (VW) Det

[BUGS] BUG #2325: fails to compile with undefined symbol (FP_PLUS_INF)

2006-03-16 Thread Riccardo
The following bug has been logged online: Bug reference: 2325 Logged by: Riccardo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: AIX 4.2.1 Description:fails to compile with undefined symbol (FP_PLUS_INF) Details: when compiling using gc

Re: [BUGS] BUG #2315: Crash engine after modify "active" function

2006-03-16 Thread Alexander Kirpa
On 15 Mar 2006, at 19:54, Tom Lane wrote: > "Alexander Kirpa" <[EMAIL PROTECTED]> writes: > > Description:Crash engine after modify "active" function > > I can't reproduce this in HEAD. I think it's probably the same bug > already reported here: Yes. It's possible, because engine crash

Re: [BUGS] BUG #2318: language

2006-03-16 Thread Andreas Pflug
Tomas Zerolo wrote: hi, i am a teaching assistant in www.deu.edu.tr, in one of our db courses, we are planning to teach from postgresql. but pgadmin's language is changing to Turkish due to opsys regional settings. [...] Just give pgadmin another environment: from the command line type

Re: [BUGS] BUG #2317: Wrong sorting order for (VW)

2006-03-16 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 2317 > Logged by: TomasKlockar > Email address: [EMAIL PROTECTED] > PostgreSQL versi

Re: [BUGS] BUG #2317: Wrong sorting order for (VW)

2006-03-16 Thread Magnus Hagander
> > The following bug has been logged online: > > > > Bug reference: 2317 > > Logged by: TomasKlockar > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.3.2/7.4.7 > > Operating system: linux(fedora) > > Description:Wrong sorting order for (VW) > > Details: >