Does ecpg need to use the same timezone database as the backend?

I just committed code so it will not, but I am not sure.

-- 
  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

Fri, 30 Apr 2004 16:48:33 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
ecpg and the timezone database
Bruce Momjian said:
> Does ecpg need to use the same timezone database as the backend?
>
> I just committed code so it will not, but I am not sure.
>

surely all clients should be utterly ignorant of what the backend uses?

cheers

andrew



Fri, 30 Apr 2004 19:05:35 -0400 (EDT)
"Andrew Dunstan" <andrew@dunslane.net>
Re: ecpg and the timezone database
Andrew Dunstan wrote:
> Bruce Momjian said:
> > Does ecpg need to use the same timezone database as the backend?
> >
> > I just committed code so it will not, but I am not sure.
> >
> 
> surely all clients should be utterly ignorant of what the backend uses?

OK, just asking the question to be sure.  I was a little concerned that
ecpg would be looking at some binary data from the backend and trying to
do some timezone comparison on it.

-- 
  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

Fri, 30 Apr 2004 20:24:32 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: ecpg and the timezone database
On Fri, Apr 30, 2004 at 04:48:33PM -0400, Bruce Momjian wrote:
> Does ecpg need to use the same timezone database as the backend?

I have to check what you changed. ecpg itself does not use the timezone
database, but some of that code is used in pgtypeslib.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

Sun, 2 May 2004 20:08:53 +0200
Michael Meskes <meskes@postgresql.org>
Re: [HACKERS] ecpg and the timezone database
Michael Meskes wrote:
> On Fri, Apr 30, 2004 at 04:48:33PM -0400, Bruce Momjian wrote:
> > Does ecpg need to use the same timezone database as the backend?
> 
> I have to check what you changed. ecpg itself does not use the timezone
> database, but some of that code is used in pgtypeslib.

Yea, that's where I saw it used.

-- 
  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

Sun, 2 May 2004 14:19:24 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] ecpg and the timezone database
Michael Meskes wrote:
> On Fri, Apr 30, 2004 at 04:48:33PM -0400, Bruce Momjian wrote:
> > Does ecpg need to use the same timezone database as the backend?
> 
> I have to check what you changed. ecpg itself does not use the timezone
> database, but some of that code is used in pgtypeslib.

For changes see include/port.h:
	
	#define localtime(timep) pg_localtime(timep)
	#define gmtime(timep) pg_gmtime(timep)
	#define asctime(timep) pg_asctime(timep)
	#define ctime(timep) pg_ctime(timep)
	#define difftime(t1,t2) pg_difftime(t1,t2)
	#define mktime(tm) pg_mktime(tm)
	#define tzset pg_tzset

Right now it is only Win32, but there are plans to use this for all
ports.

-- 
  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

Sun, 2 May 2004 14:21:31 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] ecpg and the timezone database