Re: Fwd: [BUGS] BUG #1972: index error with space character

2005-10-18 Thread Tom Lane
Eduardo RBS <[EMAIL PROTECTED]> writes: > I need a locate that not ignores the space chracater and also sort > accents like á or ã. I'm afraid you'll have to learn how to build your own locale definition. AFAIK, the "C" locale is the *only* common locale in which spaces aren't second-class citizen

[BUGS] BUG #1975: Postgres 8.0.4 build fails on AIX

2005-10-18 Thread Dirk Pirschel
The following bug has been logged online: Bug reference: 1975 Logged by: Dirk Pirschel Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: AIX Description:Postgres 8.0.4 build fails on AIX Details: Postgres 8.0.4 build fails on AIX. $cd /va

Fwd: [BUGS] BUG #1972: index error with space character

2005-10-18 Thread Eduardo RBS
-- Forwarded message -- From: Eduardo RBS <[EMAIL PROTECTED]> Date: 18/10/2005 13:31 Subject: Re: [BUGS] BUG #1972: index error with space character To: Richard Huxton Hellow.. Thank you very much for the attention. I need a locate that not ignores the space chracater and also so

Re: [BUGS] BUG #1970: Existing /etc/pam.d/postgresql clobbered by

2005-10-18 Thread Tom Lane
Devrim GUNDUZ <[EMAIL PROTECTED]> writes: > I can't see any problems with adding > account required pam_stack.so service=system-auth See also https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=167040 which is what inspired this to start with. Not knowing enough about PAM, I didn't get it righ

Re: [BUGS] BUG #1970: Existing /etc/pam.d/postgresql clobbered by

2005-10-18 Thread Devrim GUNDUZ
Hi, On Mon, 17 Oct 2005, Mark Gibson wrote: Bug reference: 1970 Logged by: Mark Gibson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Redhat Enterprise Linux 4 Description:Existing /etc/pam.d/postgresql clobbered by RPM install Details:

Re: [BUGS] BUG #1969: Unable to Install

2005-10-18 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 1969 > Logged by: jayesh > Email address: [EMAIL PROTECTED] > PostgreSQL version: postgresq-8.0ja > Operating system: window 2000 > Description:Unable to Install > Details: > > I get following error when

Re: [BUGS] BUG #1974: UTF-8 french postmaster messages corrupted

2005-10-18 Thread REISS Thomas DSIC DESP
Title: RE: [BUGS] BUG #1974: UTF-8 french postmaster messages corrupted Hello Peter, On the 8.0.4 db cluster, I get the following: template1=# SHOW lc_ctype;   lc_ctype -  fr_FR.UTF-8 (1 ligne) Temps : 1,041 ms template1=# SHOW server_encoding;  server_encoding ---

Re: [BUGS] BUG #1974: UTF-8 french postmaster messages corrupted

2005-10-18 Thread Peter Eisentraut
Am Dienstag, 18. Oktober 2005 15:00 schrieb Thomas Reiss: > [EMAIL PROTECTED] postgres]$ pg_ctl stop > en attente de l'arrêt du postmasterTRACE: arrêt en cours des > traces > fait > postmaster arrêté This probably means that the LC_CTYPE setting on your server does not match the

Re: [BUGS] BUG #1971: Start Transaction is giving Errors !!!

2005-10-18 Thread Alvaro Herrera
Yogaraj. C wrote: >When I was executing the procedure (with Transaction), postgres will > producing the following error. > > ERROR: SPI_prepare() failed on "START TRANSACTION" > CONTEXT: PL/pgSQL function "sp_example1" line 4 at SQL statement > >If anyone know the solution for this, pl

Re: [BUGS] BUG #1971: Start Transaction is giving Errors !!!

2005-10-18 Thread Michael Fuhr
On Mon, Oct 17, 2005 at 12:50:29PM +0100, Yogaraj. C wrote: >When I was executing the procedure (with Transaction), postgres will > producing the following error. > > ERROR: SPI_prepare() failed on "START TRANSACTION" > CONTEXT: PL/pgSQL function "sp_example1" line 4 at SQL statement http:/

Re: [BUGS] BUG #1972: index error with space character

2005-10-18 Thread Richard Huxton
Eduardo Soares wrote: Operating system: Linux Fedora 4 Description:index error with space character Details: In above example the "AZTES Z" should be after the "AZTESA". It happens with any encoding type. The DB not see the space character. The index shoulb see the space and put "AZT

[BUGS] BUG #1974: UTF-8 french postmaster messages corrupted

2005-10-18 Thread Thomas Reiss
The following bug has been logged online: Bug reference: 1974 Logged by: Thomas Reiss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Linux Fedora Core 1 Description:UTF-8 french postmaster messages corrupted Details: Hello, The french

[BUGS] BUG #1969: Unable to Install

2005-10-18 Thread jayesh
The following bug has been logged online: Bug reference: 1969 Logged by: jayesh Email address: [EMAIL PROTECTED] PostgreSQL version: postgresq-8.0ja Operating system: window 2000 Description:Unable to Install Details: I get following error when I click setup. Erro

[BUGS] BUG #1970: Existing /etc/pam.d/postgresql clobbered by RPM install

2005-10-18 Thread Mark Gibson
The following bug has been logged online: Bug reference: 1970 Logged by: Mark Gibson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Redhat Enterprise Linux 4 Description:Existing /etc/pam.d/postgresql clobbered by RPM install Details: H

[BUGS] BUG #1971: Start Transaction is giving Errors !!!

2005-10-18 Thread Yogaraj. C
The following bug has been logged online: Bug reference: 1971 Logged by: Yogaraj. C Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.8 Operating system: Linux - Red Hat 9 Description:Start Transaction is giving Errors !!! Details: Hi, When I was executin

[BUGS] BUG #1972: index error with space character

2005-10-18 Thread Eduardo Soares
The following bug has been logged online: Bug reference: 1972 Logged by: Eduardo Soares Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux Fedora 4 Description:index error with space character Details: In above example the "AZTES Z" s

[BUGS] BUG #1973: Error on installation after uninstall PostgreSQL

2005-10-18 Thread Andri gunawan
The following bug has been logged online: Bug reference: 1973 Logged by: Andri gunawan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: WindowsXP Pro SP2 Description:Error on installation after uninstall PostgreSQL Details: Failde to cone

Re: [BUGS] Problem with COPY in 8.0.3

2005-10-18 Thread Oliver Elphick
On Wed, 2005-10-12 at 19:28 -0400, Tom Lane wrote: > Oliver Elphick writes: > > On Wed, 2005-10-12 at 17:45 -0400, Tom Lane wrote: > >> Hm. Could we see the actual pg_attribute data for both this table and > >> its parent? > > > Here you are: > > Thanks. Nothing particularly strange-looking th