pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedecpg and the timezone database
7+ messages / 4 participants
[nested] [flat]
* ecpg and the timezone database
@ 2004-04-30 20:48 Bruce Momjian <pgman@candle.pha.pa.us>
2004-04-30 23:05 ` Re: ecpg and the timezone database Andrew Dunstan <andrew@dunslane.net>
2004-05-02 18:08 ` Re: [HACKERS] ecpg and the timezone database Michael Meskes <meskes@postgresql.org>
0 siblings, 2 replies; 7+ messages in thread
From: Bruce Momjian @ 2004-04-30 20:48 UTC (permalink / raw)
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ecpg and the timezone database
2004-04-30 20:48 ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
@ 2004-04-30 23:05 ` Andrew Dunstan <andrew@dunslane.net>
2004-05-01 00:24 ` Re: ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 1 reply; 7+ messages in thread
From: Andrew Dunstan @ 2004-04-30 23:05 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ecpg and the timezone database
2004-04-30 20:48 ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
2004-04-30 23:05 ` Re: ecpg and the timezone database Andrew Dunstan <andrew@dunslane.net>
@ 2004-05-01 00:24 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2004-05-01 00:24 UTC (permalink / raw)
To: Andrew Dunstan <andrew@dunslane.net>; +Cc: pgsql-hackers@postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [HACKERS] ecpg and the timezone database
2004-04-30 20:48 ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
@ 2004-05-02 18:08 ` Michael Meskes <meskes@postgresql.org>
2004-05-02 18:19 ` Re: [HACKERS] ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
2004-05-02 18:21 ` Re: [HACKERS] ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 2 replies; 7+ messages in thread
From: Michael Meskes @ 2004-05-02 18:08 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>; pgsql-interfaces
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!
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [HACKERS] ecpg and the timezone database
2004-04-30 20:48 ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
2004-05-02 18:08 ` Re: [HACKERS] ecpg and the timezone database Michael Meskes <meskes@postgresql.org>
@ 2004-05-02 18:19 ` Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2004-05-02 18:19 UTC (permalink / raw)
To: Michael Meskes <meskes@postgresql.org>; +Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [HACKERS] ecpg and the timezone database
2004-04-30 20:48 ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
2004-05-02 18:08 ` Re: [HACKERS] ecpg and the timezone database Michael Meskes <meskes@postgresql.org>
@ 2004-05-02 18:21 ` Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2004-05-02 18:21 UTC (permalink / raw)
To: Michael Meskes <meskes@postgresql.org>; +Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ecpg and the timezone database
@ 2004-04-30 21:11 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 7+ messages in thread
From: Magnus Hagander @ 2004-04-30 21:11 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; PostgreSQL-development <pgsql-hackers@postgreSQL.org>; pgsql-interfaces
>
>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.
>
I think it should not use it, for the following reasons:
* When ecpg is used to write a program, this is a client program. I'd
expect a client program to follow the timezone rules of the client (and
other rules), and not the server. And it has to interface with any
amount of other code that is linked only against the normal timezone
libraries on the client.
* Ecpg is used to write client programs. If it used the "special pg
timezone library", every client program written using ecpg would have to
ship with the pg *timezone database* as well. I'm sure that's now what
you'd want.
But then again, I don't use ecpg myself, so others may certainly have
better arguments in either direction.
//Magnus
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2004-05-02 18:21 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-30 20:48 ecpg and the timezone database Bruce Momjian <pgman@candle.pha.pa.us>
2004-04-30 23:05 ` Andrew Dunstan <andrew@dunslane.net>
2004-05-01 00:24 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-05-02 18:08 ` Michael Meskes <meskes@postgresql.org>
2004-05-02 18:19 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-05-02 18:21 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-04-30 21:11 Re: ecpg and the timezone database Magnus Hagander <mha@sollentuna.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox