Re: [BUGS] attislocal value changed with the dump

2005-11-04 Thread Tom Lane
elein <[EMAIL PROTECTED]> writes: > This is the repro with the sql file below. FWIW, this seems to work as expected with 8.1. Don't have time to try it with 8.0 right now, but it may be an already-solved issue ... regards, tom lane ---(end of broa

Re: [BUGS] attislocal value changed with the dump

2005-11-04 Thread elein
This is the repro with the sql file below. createdb bug1 psql bug1 < qna.sql pg_dump bug1 > bug1.sql createdb bug2 psql bug2 < bug1.sql psql bug1 =# select r.relname, attname, attislocal, attinhcount from pg_attribute a join pg_class r ON (a.attrelid = r.oid) where attname = 'avid' order by rel

[BUGS] Missing seconds in a date (timestamp)

2005-11-04 Thread Eliézer Madeira de Campos
Hello everyone:   I'm working to upgrade a database from PostgreSQL 7.3 to 8.0 version.The database serves a complex J2EE application, running Jboss in multiple servers. All servers run Linux RedHat.I found a problem yesterday.Whenever the application inserts a date prior to 1914-01-01, the

Re: [BUGS] how to install postgres 8.0.4 in RHEL4

2005-11-04 Thread Devrim GUNDUZ
Hi, On Fri, 4 Nov 2005, venki wrote: hello sir i have facing a problem past one weeks onwords iam using redhat enterprise linux 4 in that postgres version is 7.4 i want to upgrade postgres version of the existing operating system RHEL4 iam searched a lot of links but fail to get the result in

[BUGS] BUG #2020: 7.3 -> 8.0.4 migration timestamp problem

2005-11-04 Thread Fernando Rubbo
The following bug has been logged online: Bug reference: 2020 Logged by: Fernando Rubbo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Linux - Fedora Core 3 Description:7.3 -> 8.0.4 migration timestamp problem Details: 1) I have a p

Re: [BUGS] Bad French support encoding for postgresql version 8.0.4

2005-11-04 Thread Peter Eisentraut
Jacques Grelet wrote: > Since version 8.0.4, all French Postgresql messages are bad encoded. Yes, the file is encoded in UTF-8 but declared to be ISO-8859-1. Guillaume, can you check what is going on? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end

[BUGS] Bad French support encoding for postgresql version 8.0.4

2005-11-04 Thread Jacques Grelet
Hi, Since version 8.0.4, all French Postgresql messages are bad encoded. Having a quick look beetween po's files version 8.0.3 and 8.0.4, it appear that po's files was included to cvs certainly from an host using a bad locale setting. Regards, cf: --- psql -h $DBHOST -d inventaire Bienvenu

[BUGS] how to install postgres 8.0.4 in RHEL4

2005-11-04 Thread venki
hello sir i have facing a problem past one weeks onwords iam using redhat enterprise linux 4 in that postgres version is 7.4 i want to upgrade postgres version of the existing operating system RHEL4 iam searched a lot of links but fail to get the result in the operating system rpm -qa | grep post

Re: [BUGS] BUG #2019: tsearch2-related coredump

2005-11-04 Thread Bernhard Weisshuhn
Bernhard Weisshuhn wrote: > The attached patch for Teodor seems to fix the problem for me. I say ^^^ I meant 'from' of course ;-) --bkw ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] BUG #2019: tsearch2-related coredump

2005-11-04 Thread Bernhard Weisshuhn
On Thu, Nov 03, 2005 at 03:12:33PM +, Bernhard Weisshuhn <[EMAIL PROTECTED]> wrote: > The following bug has been logged online: > > Bug reference: 2019 > Logged by: Bernhard Weisshuhn > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1rc1 > Operating system: Lin