Re: [BUGS] CVS Head - message formatting issue in initdb on Win32

[Bruce Momjian]

Dave Page wrote:
> I see the following at the end of initdb on win32. Note the path
> quoting:
> 
> Success. You can now start the database server using:
> 
> "C:\msys\1.0\local\pgsql\bin"\postmaster -D "data"
> or
> "C:\msys\1.0\local\pgsql\bin"\pg_ctl -D "data" -l logfile start

Thanks, fixed:

Success. You can now start the database server using:

"C:\u\pg\bin\postmaster" -D "\u\pg\data" 
or
"C:\u\pg\bin\pg_ctl" -D "\u\pg\data" -l logfile start

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  pgman@candle.pha.pa.us   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[BUGS] CVS Head - message formatting issue in initdb on Win32

[Dave Page]

I see the following at the end of initdb on win32. Note the path
quoting:

Success. You can now start the database server using:

"C:\msys\1.0\local\pgsql\bin"\postmaster -D "data"
or
"C:\msys\1.0\local\pgsql\bin"\pg_ctl -D "data" -l logfile start


Regards, Dave.

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [BUGS] BUG #1852: compilation failed

[Tom Lane]

"fischer" <[EMAIL PROTECTED]> writes:
> c99 -O3 -mips4 -woff 1164,1171,1185,1195,1552 -I. -I../../../src/include
> -I/usr/local/include -I/usr/local2/include -I/usr/nekoware/include 
> -U_NO_XOPEN4  -c -o analyze.o analyze.c
> Signal: Segmentation fault in Global Optimization -- Copy Propagation
> phase.
> Error: Signal Segmentation fault in phase Global Optimization -- Copy
> Propagation -- processing aborted
> c99 ERROR:  /usr/lib32/cmplrs/be died due to signal 4
> c99 ERROR:  core dumped

Think you need to be complaining to your compiler vendor, not us.

A short-term workaround might be to use a less aggressive -O setting.

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [BUGS] BUG #1853: explain gives ERROR: bogus varno: 23

[Michael Fuhr]

On Sun, Aug 28, 2005 at 06:13:12AM +0100, Dustin Sallings wrote:
> PostgreSQL version: 8.1b1
> Description:explain gives ERROR:  bogus varno: 23

This might be the same problem that was fixed yesterday:

http://archives.postgresql.org/pgsql-committers/2005-08/msg00374.php

Try building the latest code from CVS and see if you still get the
error.

Do you get the error if you execute "SET enable_bitmapscan TO off;"
and then run EXPLAIN?

-- 
Michael Fuhr

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[BUGS] BUG #1853: explain gives ERROR: bogus varno: 23

[Dustin Sallings]

The following bug has been logged online:

Bug reference:  1853
Logged by:  Dustin Sallings
Email address:  dustin@spy.net
PostgreSQL version: 8.1b1
Operating system:   Mac OS X 10.3.something
Description:explain gives ERROR:  bogus varno: 23
Details: 

If I run this query on my model:

  select
sensor_id,
min(sample) as min_reading,
avg(sample) as avg_reading,
stddev(sample) as stddev_reading,
max(sample) as max_reading,
date(ts) as day
  from
samples
  where
ts >= (select max(day)+1 from rollups_day)
and ts < current_date
  group by
sensor_id, day


It works by itself, but if I run it in explain, it fails with the following
error:

ERROR:  bogus varno: 23


...  I've so far been unable to make a standalone sample break because I
don't quite understand the problem.

samples is a view made of up union alls to a bunch of tables like this:

View definition:
( SELECT samples_1999.ts, samples_1999.sensor_id, samples_1999.sample
   FROM samples_1999
UNION ALL 
 SELECT samples_2000.ts, samples_2000.sensor_id, samples_2000.sample
   FROM samples_2000)
UNION ALL 
 SELECT samples_2001.ts, samples_2001.sensor_id, samples_2001.sample
   FROM samples_2001)
UNION ALL 
 SELECT samples_2002.ts, samples_2002.sensor_id, samples_2002.sample
   FROM samples_2002)
UNION ALL 
 SELECT samples_2003.ts, samples_2003.sensor_id, samples_2003.sample
   FROM samples_2003)
UNION ALL 
 SELECT samples_2004.ts, samples_2004.sensor_id, samples_2004.sample
   FROM samples_2004)
UNION ALL 
 SELECT samples_2005.ts, samples_2005.sensor_id, samples_2005.sample
   FROM samples_2005;


I don't have any confidential data in this database, so I can provide the
entire thing if necessary, but it is a rather large database.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

[BUGS] beta page has broken link to bug submission

[Dustin Sallings]

http://www.postgresql.org/developer/beta        links tohttp://www.postgresql.org/developer/support/submitbug        should link tohttp://www.postgresql.org/support/submitbug --SPY                      My girlfriend asked me which one I like better.pub  1024/3CAE01D5 1994/11/03 Dustin Sallings |    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BEL___ I hope the answer won't upset her.  

[BUGS] BUG #1852: compilation failed

[fischer]

The following bug has been logged online:

Bug reference:  1852
Logged by:  fischer
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.1 beta1
Operating system:   irix
Description:compilation failed
Details: 

mipspro 7.43.
CFLAGS=-O3 -mips4.
options: ./configure --prefix=/usr/local/postgresql --without-readline
--disable-rpath.
-

gmake[3]: Entering directory
`/mnt/3/temp/postgresql-8.1beta1/src/backend/parser'
c99 -O3 -mips4 -woff 1164,1171,1185,1195,1552 -I. -I../../../src/include
-I/usr/local/include -I/usr/local2/include -I/usr/nekoware/include 
-U_NO_XOPEN4  -c -o analyze.o analyze.c
Signal: Segmentation fault in Global Optimization -- Copy Propagation
phase.
Error: Signal Segmentation fault in phase Global Optimization -- Copy
Propagation -- processing aborted
c99 ERROR:  /usr/lib32/cmplrs/be died due to signal 4
c99 ERROR:  core dumped

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster