[BUGS] Internal compiler error in `layout_type' at stor-layout.c

2002-09-03 Thread Guoben Li
Title: Internal compiler error in `layout_type' at stor-layout.c (Solaris2.7, gcc2.95) 1. cd postgresql-7.2.2 2. ./configure --with-java --with-perl -enable-odbc (got two warnings:) checking for flex... no configure: warning: *** Without Flex you will not be able to build PostgreSQL from

Re: [BUGS] Bug #755: Error on create a new sequence by using the

2002-09-03 Thread Rod Taylor
7.3 will partially fix this issue by extending the length of the NAME data type. Ie. You won't hit it until you have large (32+ character) length names. On Tue, 2002-09-03 at 16:31, [EMAIL PROTECTED] wrote: > Søren Laursen ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the n

Re: [BUGS] Bug #755: Error on create a new sequence by using the create

2002-09-03 Thread Bruce Momjian
7.3 will have 64 byte indentifiers, which should make this less likely. We could randomly pick non-conflicting names, but then the serial names would not be predicable, and because those are used by nextval(), etc, it would be bad. ---

[BUGS] Bug #755: Error on create a new sequence by using the create table command.

2002-09-03 Thread pgsql-bugs
Søren Laursen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Error on create a new sequence by using the create table command. Long Description In postgresql 7.1 and 7.2.1: Then using a statement like: CREATE TABLE longtablen

Re: [BUGS] bug in contrib/contrib-global.mk

2002-09-03 Thread Peter Eisentraut
gianpaolo racca writes: > In postgres 7.2.2 i found an error that causes array not to be correctly > installed, because variable $libdir not to be expanded. > > line 196 > sed 's,MODULE_PATHNAME,$$libdir/$*,g' $< >$@ > I think should be > sed 's,MODULE_PATHNAME,$(libdir)/$*,g' $< >$@ No, it's co

Re: [BUGS] Postgres 7.2.2

2002-09-03 Thread Bruce Momjian
Gianfranco Masia - Eprom s.r.l. wrote: > In addition to security patches, I wondered if with release 7.2.2 contains > more fixes of previous 7.2.1 or must we waits for 7.2.3? See HISTORY for changes. There will be no 7.2.3. -- Bruce Momjian| http://candle.pha.

Re: [BUGS] failed to build libpq.so on AIX 4 and 5/I have a solution

2002-09-03 Thread Bruce Momjian
Patch applied. Thanks. --- Tomoyuki Niijima wrote: > I'm posting this report to [EMAIL PROTECTED] too. I aware the fact > that I posted mostly the same report to [EMAIL PROTECTED] about two > month ago. Though, I had a

[BUGS] ERROR: parser: parse error at or near

2002-09-03 Thread * *
Thanx to those who responded. Unfortunately I haven't been able to solve my problem. Using this statement I get the error: ERROR: parser: parse error at or near "=" SQL = "Select users . first_name, users . last_name, profiles . profile_name, countries . city, countries . province, countrie

Re: [BUGS] ERROR: parser: parse error at or near "'"

2002-09-03 Thread Rod Taylor
Single single quote literals, double quote literals. 'profiles' => "profiles" On Tue, 2002-09-03 at 10:56, * * wrote: > I'm getting the error ERROR: parser: parse error at or near "'" > This is my sql statement in my servlet and i don't see what's wrong with it. > > SQL = "Select users.first_n

[BUGS] bug in contrib/contrib-global.mk

2002-09-03 Thread gianpaolo racca
In postgres 7.2.2 i found an error that causes array not to be correctly installed, because variable $libdir not to be expanded. line 196 sed 's,MODULE_PATHNAME,$$libdir/$*,g' $< >$@ I think should be sed 's,MODULE_PATHNAME,$(libdir)/$*,g' $< >$@ bye, gianpaolo --

[BUGS] ERROR: parser: parse error at or near "'"

2002-09-03 Thread * *
I'm getting the error ERROR: parser: parse error at or near "'" This is my sql statement in my servlet and i don't see what's wrong with it. SQL = "Select users.first_name, users.last_name, profiles.profile_name, countries.city, countries.province" + "countries.country, users.email_

[BUGS] Fw: recreate_mmaps_after_fork_failed

2002-09-03 Thread Amit Gupta
  - Original Message - From: Amit Gupta To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 4:12 PM Subject: recreate_mmaps_after_fork_failed Hi,   I have successfully installed postgresql 7.2.2. on windows XP.I am using cygipc-1.11-1 package. On  running the database it gives t

[BUGS] Postgres 7.2.2

2002-09-03 Thread Gianfranco Masia - Eprom s.r.l.
In addition to security patches, I wondered if with release 7.2.2 contains more fixes of previous 7.2.1 or must we waits for 7.2.3? Thanks Gianfranco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] recreate_mmaps_after_fork_failed

2002-09-03 Thread Amit Gupta
Hi,   I have successfully installed postgresql 7.2.2. on windows XP.I am using cygipc-1.11-1 package. On  running the database it gives the following error: ** amit gupta@AMITG /cygdrive/c/pgsql$ ipc-daemon &[2] 3656   amit gupta@AMITG /cyg

[BUGS] BUG

2002-09-03 Thread NISHAL K.R
When I am giving a SQL-query with four tables and three of the tables contain 5,000 records .each table contain less than 12 column and few columns having a varchar length of 50.In the SQL-Query I had given a few condition to retrieve the records its getting hang.Its a very serious problem f

[BUGS] pg_statistic cannot open pg_statistic: No such file or directory

2002-09-03 Thread fpussault
pg_statistic cannot open pg_statistic: No such file or directory Condition founding this error : working well on psql console mode, done a \q to quit the database, & tryied to open another one : @linux:~> psql medias NOTICE: RelationBuildDesc: can't open pg_statistic: No such file or directory E

[BUGS] make check hang on AIX 5L p690 4way/I have two solutions (corrected)

2002-09-03 Thread Tomoyuki Niijima
Sounds like, I should not post bug report with patch to [EMAIL PROTECTED] I post the same report to [EMAIL PROTECTED] PoorTom - Forwarded by Tomoyuki Niijima/Japan/IBM on 2002/09/02 08:29 -

[BUGS] failed to build libpq.so on AIX 4 and 5/I have a solution

2002-09-03 Thread Tomoyuki Niijima
I'm posting this report to [EMAIL PROTECTED] too. I aware the fact that I posted mostly the same report to [EMAIL PROTECTED] about two month ago. Though, I had a mistake on it. I needed -Wl, before -bnoentry to support gcc. PoorTom - Forwarded by Tomoyuki Niijima/Japan/IBM on 2002/09/02 08