Re: [PATCHES] tz error prevents postmaster.c compiling...

2004-06-25 Thread Simon Riggs
On Fri, 2004-06-25 at 21:36, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > Going backwards at a rate of knots, I can't even get postmaster to
> > compile now and I'm talking about the one from cvstip, NOT with my
> 
> > postmaster.c:1046: error: storage size of `tz' isn't known
> > postmaster.c:1048: warning: implicit declaration of function
> > `gettimeofday'
> 
> You probably need to rerun configure.  It sounds like 
> isn't getting imported because HAVE_SYS_TIME_H isn't defined ...
> 
> > ...for the last few days, I've been getting this when I attempt initdb
> > with -d option enabled
> 
> > LOG:  could not open directory "/share/timezone": No such file or
> > directory
> 
> I am suspicious that this is a configuration problem too.  "make
> distclean" and a full rebuild seems indicated.
> 

Hmmm...I already tried running configure again

Advice given...advice heeded:
  configure
  make distclean
  make

fails...same way...damn.

I'll try a full clean cvstip checkout and try again...

I've not gone anywhere near timezones...so I have bad vibes.

Regards, Simon Riggs


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [PATCHES] tz error prevents postmaster.c compiling...

2004-06-25 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes:
> Going backwards at a rate of knots, I can't even get postmaster to
> compile now and I'm talking about the one from cvstip, NOT with my

> postmaster.c:1046: error: storage size of `tz' isn't known
> postmaster.c:1048: warning: implicit declaration of function
> `gettimeofday'

You probably need to rerun configure.  It sounds like 
isn't getting imported because HAVE_SYS_TIME_H isn't defined ...

> ...for the last few days, I've been getting this when I attempt initdb
> with -d option enabled

> LOG:  could not open directory "/share/timezone": No such file or
> directory

I am suspicious that this is a configuration problem too.  "make
distclean" and a full rebuild seems indicated.

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[PATCHES] tz error prevents postmaster.c compiling...

2004-06-25 Thread Simon Riggs
Going backwards at a rate of knots, I can't even get postmaster to
compile now and I'm talking about the one from cvstip, NOT with my
changes...please assist a tired brain

My errors:
[EMAIL PROTECTED] postmaster]$ make
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -I../../../src/include -D_GNU_SOURCE   -c -o
postmaster.o postmaster.c
postmaster.c: In function `ServerLoop':
postmaster.c:1046: error: storage size of `tz' isn't known
postmaster.c:1048: warning: implicit declaration of function
`gettimeofday'
postmaster.c:1046: warning: unused variable `tz'
postmaster.c: In function `BackendRun':
postmaster.c:2388: error: storage size of `tz' isn't known
postmaster.c:2388: warning: unused variable `tz'
make: *** [postmaster.o] Error 1
[EMAIL PROTECTED] postmaster]$

These are the only errors from make...
port.h
postmaster.c
have both just been updated by cvs update

...for the last few days, I've been getting this when I attempt initdb
with -d option enabled

LOG:  could not open directory "/share/timezone": No such file or
directory
DEBUG:  Reject TZ "GMT0BST": at 968000 2005-03-28 00:00:00 std
versus 2005-03-28 01:00:00 dst
DEBUG:  Reject TZ "GMT0": at 1088121600 2004-06-25 00:00:00 std versus
2004-06-25 01:00:00 dst
LOG:  could not recognize system timezone, defaulting to "Etc/GMT0"
HINT:  You can specify the correct timezone in postgresql.conf.

...my system shows 

[EMAIL PROTECTED] pgsql]$ date
Fri Jun 25 20:55:31 BST 2004

...is this a case of?

#ifdef BRIT
gcc -throw-wobbly
#endif

Comments? 

Regards, Simon Riggs


---(end of broadcast)---
TIP 8: explain analyze is your friend