[BUGS] RE: iofflush psql 7.0.3 coredump on RH 6.1

2000-12-04 Thread Rasputin
Sod's Law, isn't it? The minute you report a bug, you find a workaround. In this case, disabling readline starts up the client OK. (That'd be : [postgres@cartman pgsql]$ psql -n -d honeypi Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h

[BUGS] I'm not able to install PostgreSQL

2000-12-04 Thread Zenon Braga F.
I'm trying to install PostgreSQL 7.0.2 in Solaris 8 Intel platform, but I'm getting the following messages when I run gmake: gmake[2]: Leaving directory `/export/home/zfbf/lixo2/postgresql-7.0.2/src/backend/executor' gmake -C lib all gmake[2]: Entering directory `/export/home/zfbf/lix

Re: [BUGS] Solaris 8 / still waiting

2000-12-04 Thread Tom Lane
It seems the problem is > checking for ANSI C header files... no which causes not to be included. Dunno what about Solaris is nonstandard enough to fool autoconf's test, but I see that the AC_HEADER_STDC macro tests quite a bit more than just whether the header files exist. Try modifying src/i

Re: [BUGS] bug with postgresql

2000-12-04 Thread Tom Lane
mohamed hgug <[EMAIL PROTECTED]> writes: > After a successful installation of postgresql (7.0.3), when i want to start > using it, i have a problemes: > in the directory /usr/local/pgsql/bin i type ./psql , and i have this > result: > welcome to psql, the postgresql interactive terminal. > Type

[BUGS] Outer joins in views

2000-12-04 Thread pgsql-bugs
Grzegorz M. Mucha ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Outer joins in views Long Description In the 7.1 devel version, the OUTER JOIN statementes are working, but not in VIEWs. I have created the below listed view,

[BUGS] Rules with Conditions: Still Doesn't Work (Bug Rpt)

2000-12-04 Thread Joel Burton
(sorry for cross-posting a bug report directly to pgsql- hackers, but it started here, and I know it's still a topic of conversation.) About a week ago, I posted to pgsql-bugs and pgsql- hackers a VIEW that shows all user table fields w/comment, if any, as well as 2 RULES that tried to allow f

[BUGS] initdb on Alpha dies with spinlock errors

2000-12-04 Thread pgsql-bugs
Carl Perry ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description initdb on Alpha dies with spinlock errors Long Description Compiled PostgreSQL 7.0.2 on my 21164 Alpha running SuSE 6.4 AXP. Compiled fine, but when trying to run ini

Re: [BUGS] Outer joins in views

2000-12-04 Thread Tom Lane
[EMAIL PROTECTED] writes: > In the 7.1 devel version, the OUTER JOIN statementes are working, but > not in VIEWs. I have created the below listed view, and while it > allows to be created, any attempt of using it ends with: > ERROR: Internal error: no jointree entry for rel *OLD* Thanks for the r

Re: [BUGS] initdb on Alpha dies with spinlock errors

2000-12-04 Thread Tom Lane
[EMAIL PROTECTED] writes: > initdb on Alpha dies with spinlock errors Make sure it's compiled -O0. We're hoping to clean up the Alpha portability problems for 7.1, but 7.0.* won't work very well on Alpha without -O0 :-( regards, tom lane

Re: [BUGS] initdb on Alpha dies with spinlock errors

2000-12-04 Thread Lamar Owen
Tom Lane wrote: > > [EMAIL PROTECTED] writes: > > initdb on Alpha dies with spinlock errors > > Make sure it's compiled -O0. > > We're hoping to clean up the Alpha portability problems for 7.1, > but 7.0.* won't work very well on Alpha without -O0 :-( Or Ryan Kirkpatrick's patches. -- Lamar Ow

Re: [BUGS] Rules with Conditions: Still Doesn't Work (Bug Rpt)

2000-12-04 Thread Tom Lane
"Joel Burton" <[EMAIL PROTECTED]> writes: > The problems are demonstrated below, with non-system tables. Wow, what a great bunch of test cases! You've exposed a number of bugs in the current sources. I'm working on fixes, but have run out of steam for today... regards,