Re: [BUGS] PostgreSQL 8.1.5: regression tests fail on sparc

2006-11-24 Thread Tom Lane
=?KOI8-R?Q?=E4=C5=CA=D4=C5=D2_=E1=CC=C5=CB=D3=C1=CE=C4=D2_=F7=C1?= =?KOI8-R?Q?=CC=C5=D2=C9=C5=D7=C9=DE?= <[EMAIL PROTECTED]> writes: > PostgreSQL 8.1.5 have a problem with division by zero on sparc. > Solaris 9 sparc, gcc 4.0.2, 4.1.1: We've not heard that reported before, so I wonder whether the

Re: [BUGS] BUG #2779: Making an inherited table to a view causes could not open relation error in base table

2006-11-24 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Actually, I wonder whether we still need to support conversion of >> tables to views at all. That was never meant as anything but a >> temporary hack to allow loading pre-7.1 pg_dump scripts. > IIRC I tried it when I was reviewing th

Re: [BUGS] BUG #2775: Error select

2006-11-24 Thread Tom Lane
"Mas Kus" <[EMAIL PROTECTED]> writes: > But, when I tried select : > =>select 2148*100; > ?column? > -- > -214623000 PG releases before 8.0 don't check for overflow in integer multiplication. regards, tom lane ---(end of bro

Re: [BUGS] BUG #2779: Making an inherited table to a view causes could not open relation error in base table

2006-11-24 Thread Alvaro Herrera
Tom Lane wrote: > "Sven Klemm" <[EMAIL PROTECTED]> writes: > > CREATE TABLE base( name TEXT ); > > CREATE TABLE child() INHERITS( base ); > > > CREATE RULE "_RETURN" AS ON SELECT TO child DO INSTEAD SELECT 'Chunky > > Bacon'::text AS name; > > This is definitely in the category of "don't do that

Re: [BUGS] BUG #2779: Making an inherited table to a view causes could not open relation error in base table

2006-11-24 Thread Tom Lane
"Sven Klemm" <[EMAIL PROTECTED]> writes: > CREATE TABLE base( name TEXT ); > CREATE TABLE child() INHERITS( base ); > CREATE RULE "_RETURN" AS ON SELECT TO child DO INSTEAD SELECT 'Chunky > Bacon'::text AS name; This is definitely in the category of "don't do that". It's an oversight that Defin

[BUGS] PostgreSQL 8.1.5: regression tests fail on sparc

2006-11-24 Thread Дейтер Александр Ва лериевич
Hi, PostgreSQL 8.1.5 have a problem with division by zero on sparc. Solaris 9 sparc, gcc 4.0.2, 4.1.1: $ ./configure --enable-thread-safety --disable-nls --without-perl --without-python --without-krb5 --without-openssl --without-readline ... $ make && make check ... === 1 of

[BUGS] BUG #2776: unable to access created user directory

2006-11-24 Thread Raghava
The following bug has been logged online: Bug reference: 2776 Logged by: Raghava Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: RHEL Description:unable to access created user directory Details: hi, We have uninstalled postgres-7.1.4 a

[BUGS] BUG #2774: Error select

2006-11-24 Thread Mas Kus
The following bug has been logged online: Bug reference: 2774 Logged by: Mas Kus Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.1-2 Operating system: Mandrake 10.0 Description:Error select Details: Hello... I'm using Mandrake 10.0 full version as my OS. An

[BUGS] BUG #2775: Error select

2006-11-24 Thread Mas Kus
The following bug has been logged online: Bug reference: 2775 Logged by: Mas Kus Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.1-2 Operating system: Mandrake 10.0 Description:Error select Details: Hello... I'm using Mandrake 10.0 full version as my OS. An

Re: [BUGS] BUG #2768: dates before year 1600 in timestamptz column

2006-11-24 Thread Mikko Tiihonen
On Tue, 21 Nov 2006, Heikki Linnakangas wrote: > Heikki Linnakangas wrote: > > Tom Lane wrote: > > > The weird offset from GMT is probably a function of your local timezone, > > > which you didn't > > > mention. > > > > Most likely "Europe/Helsinki". I can reproduce the problem with that: > >

[BUGS] BUG #2778: make check failed

2006-11-24 Thread Alex Deiter
The following bug has been logged online: Bug reference: 2778 Logged by: Alex Deiter Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: Solaris 9 sparc Description:make check failed Details: System detail: Solaris 9 sparc, gcc 4.0.2, 4.1.1

[BUGS] Error in postgresql after crash unable to restart this needs to be posted on -hackers or -bugs, so that tom, oleg and teodor can take a look

2006-11-24 Thread anil maran
this needs to be posted on -hackers or -bugs, so that tom, oleg and teodor can take a look Logs here http://rafb.net/paste/results/NgHkIl17.html Anil Sponsored Link Compare mortgage rates for today. Ge

[BUGS] BUG #2779: Making an inherited table to a view causes could not open relation error in base table

2006-11-24 Thread Sven Klemm
The following bug has been logged online: Bug reference: 2779 Logged by: Sven Klemm Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Linux (Debian) Description:Making an inherited table to a view causes could not open relation error in base t

Re: [BUGS] BUG #2759: \df doesn't show functions with no args

2006-11-24 Thread Leon Miller-Out
Bruce, you're right... I was using an old client. I wasn't aware that the client translated the \d commands into SQL. Thanks for clearing this up! Leon On 11/20/06, Bruce Momjian <[EMAIL PROTECTED]> wrote: I am wondering if you are using an old psql with your 8.1.X server. I see in 8.2.X this

[BUGS] PGSQL SETUP PROBLEM

2006-11-24 Thread rahman sule
Hello, I Sule Rahman from the International Institute of Tropical Agriculture, Ibadan, Nigeria( IITA). IITA is an international research organisation committed to the development and improve production of agricultural products. We recently installed PGSQL on a Redhat Linux server but each time