Обсуждение: pgAdmin III: timestamp displayed in what time zone?

Поиск
Список
Период
Сортировка

pgAdmin III: timestamp displayed in what time zone?

От
Fred Janon
Дата:
Sorry if if's a double post, but I thought that it would be more likely I would get an answer on the hackers list.<br
/><br/>Thanks<br /><br />Fred<br /><br /><div class="gmail_quote">---------- ----------<br />From: <b
class="gmail_sendername">FredJanon</b> <span dir="ltr"><<a href="mailto:fjanon@gmail.com"
target="_blank">fjanon@gmail.com</a>></span><br/> Date: Mon, Dec 14, 2009 at 19:04<br />Subject: pgAdmin III:
timestampdisplayed in what time zone?<br />To: <a href="mailto:pgsql-general@postgresql.org"
target="_blank">pgsql-general@postgresql.org</a><br/><br /><br />Hi,<br /><br /> I am using Postgres 8.3. I have a
tabledefined like this:<br /><br />=======================<br />-- Table: timeson<br /><br />-- DROP TABLE timeson;<br
/><br/>CREATE TABLE timeson<br />(<br />  id bigint NOT NULL,<br />  enddatetime timestamp without time zone NOT
NULL,<br/>   startdatetime timestamp without time zone NOT NULL,<br />  times_id bigint,<br />  CONSTRAINT timeson_pkey
PRIMARYKEY (id),<br />  CONSTRAINT fkb1af5ba5890cf3da FOREIGN KEY (times_id)<br />      REFERENCES times (id) MATCH
SIMPLE<br/>       ON UPDATE NO ACTION ON DELETE NO ACTION<br />)<br />WITH (OIDS=FALSE);<br />ALTER TABLE timeson OWNER
TOmyfreo;<br /><br />======================<br />I populate the table with some data and use pgAdmin III 1.8.4 to view
thedate "View date> first top100 rows". the question is: in what timezone are the fields showed in pgAdmin? no
timezone(as stored), the server time zone or the time zone of the computer where pgAdmin runs?<br /><br />Thanks<br
/><fontcolor="#888888"><br />Fred<br /></font></div><br /> 

Re: pgAdmin III: timestamp displayed in what time zone?

От
Greg Smith
Дата:
Fred Janon wrote:
> Sorry if if's a double post, but I thought that it would be more 
> likely I would get an answer on the hackers list.
In that case just posting here would have been better than hitting 
both.  I usually ignore any request for help that is posted on more than 
one list just to draw attention to itself; I wouldn't be surprised that 
are other people who are similarly annoyed by the behavior and do 
likewise. 

In your case, both lists you picked were the wrong ones, since you're 
asking a pgAdmin specific question which isn't the direct topic of any 
of the pgsql-* lists; pgadmin-support was the right place for it:  
http://archives.postgresql.org/pgadmin-support/

--
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com



Re: pgAdmin III: timestamp displayed in what time zone?

От
Fred Janon
Дата:
Thanks Greg, at least among the socially unacceptable insults I got the the right list to post my question in. I am
tryingto get some help from (supposedly) helping and knowledgeable people and I get insults in return.<br /><br />BTW,
thislist is listed as the list for tech questions in the pgAdmin tips, therefore if you don't want to be disturb, you
mightwant to remove it from the pgAdmin tips.<br /><br />Has someone heard of cyber bullying?<br /><br />Fred<br /><br
/><divclass="gmail_quote">On Tue, Dec 15, 2009 at 00:44, Greg Smith <span dir="ltr"><<a
href="mailto:greg@2ndquadrant.com">greg@2ndquadrant.com</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">Fred
Janonwrote:<br /><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex;padding-left: 1ex;"> Sorry if if's a double post, but I thought that it would be more likely I would get an
answeron the hackers list.<br /></blockquote></div> In that case just posting here would have been better than hitting
both. I usually ignore any request for help that is posted on more than one list just to draw attention to itself; I
wouldn'tbe surprised that are other people who are similarly annoyed by the behavior and do likewise. <br /> In your
case,both lists you picked were the wrong ones, since you're asking a pgAdmin specific question which isn't the direct
topicof any of the pgsql-* lists; pgadmin-support was the right place for it:  <a
href="http://archives.postgresql.org/pgadmin-support/"
target="_blank">http://archives.postgresql.org/pgadmin-support/</a><br/><font color="#888888"><br /> --<br /> Greg
Smith   2ndQuadrant   Baltimore, MD<br /> PostgreSQL Training, Services and Support<br /> greg@2ndQuadrant.com  <a
href="http://www.2ndQuadrant.com"target="_blank">www.2ndQuadrant.com</a><br /><br /></font></blockquote></div><br /> 

Re: pgAdmin III: timestamp displayed in what time zone?

От
Robert Haas
Дата:
On Mon, Dec 14, 2009 at 9:08 PM, Fred Janon <fjanon@gmail.com> wrote:
> Thanks Greg, at least among the socially unacceptable insults I got the the
> right list to post my question in. I am trying to get some help from
> (supposedly) helping and knowledgeable people and I get insults in return.

I don't want to make what's obviously a bad situation for you worse,
but I think you might want to reconsider your position on this point.
I can't find anything in Greg's email that sounds to me like an
insult.  I can see why you might think it's rude, but I have met Greg
and he is a very nice guy and I am pretty sure he's just trying to
help you understand your actions are likely to be interpreted.

I actually spend a lot of time, for which I don't get paid, trying to
make sure that questions posted to the mailing lists which I follow
get answered.  I have to admit that, like Greg, I find it annoying
when people post a question that is off-topic for the list, or when
they cross-post the same question to many different lists.  That might
not speak well of me, but it seems to me when someone cross-posts
something to multiple mailing lists, they're (a) sending it to many
people who are not interested in or knowledgeable about the topic of
the question and (b) implying that they are entitled to free support
from the community.  Well, OK, we do try to provide good support, but
since it is something people do on a volunteer basis, they like to be
asked rather than told what they "have" to do.  That probably wasn't
your intention, of course.  I actually thought about trying to answer
your question myself, but then realized that as a non-pgadmin user I
had no chance of telling you anything useful.  Had Greg not answered,
I probably would have looked up the correct mailing list for you
myself, but that's really about all I would be able to do since it's
outside my area of knowledge.

A few more resources you might want to look at:

http://www.postgresql.org/community/lists/
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

> BTW, this list is listed as the list for tech questions in the pgAdmin tips,
> therefore if you don't want to be disturb, you might want to remove it from
> the pgAdmin tips.

If there is a tip there that pointed you here in error, we should
probably try to get that fixed, although I certainly have no ability
to change the pgadmin tips myself.  I've never even used it, let alone
have access to change the source code.  However, I don't think we get
more than one or two pgadmin questions here a year, so I suspect that
whatever the tip says includes some caveats about the circumstances
under which posting to pgsql-hackers is recommended.  Feel free to
tell me if I'm wrong.

...Robert


Re: pgAdmin III: timestamp displayed in what time zone?

От
Greg Smith
Дата:
Fred Janon wrote:
> Thanks Greg, at least among the socially unacceptable insults I got 
> the the right list to post my question in. 
Aww, is somebody having a case of the Monday's?

Frankly that was all useful advice.  I was pointing out that despite 
what you thought, you might actually be decreasing your chances of 
getting an answer to your question in the future if you cross-post the 
way you did.  Here's an equally helpful hint:  when you have a question 
you'd like answered, don't insult someone in the group who spends their 
time every day answering questions in that area, particularly if they've 
actually given you a useful suggestion.  Next time, I might be the best 
qualified to help you out, and you haven't really endeared yourself to 
me with your comments here.

> BTW, this list is listed as the list for tech questions in the pgAdmin 
> tips, therefore if you don't want to be disturb, you might want to 
> remove it from the pgAdmin tips.

When I look at http://www.pgadmin.org/support/ for example it suggests 
the right list.  I only see this one listed in the Translation section, 
as the place to ask to get added to the translators list.  Does anyone 
know where the tips section suggesting people send tech questions to 
pgsql-hackers he's referring to is at?  That seems like it should be 
cleaned up to point to the pgAdmin list instead if that's floating 
around there somewhere.

Fred, if you could recall exactly what path you followed to end up here 
and let us know, we can try to keep someone else from being confused and 
instead directed to the right place more directly.  It would be a nice 
gesture on your part to end our conversation here having done something 
useful, rather than with you just venting at me.

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com



Re: pgAdmin III: timestamp displayed in what time zone?

От
Dave Page
Дата:
On Tue, Dec 15, 2009 at 5:30 AM, Greg Smith <greg@2ndquadrant.com> wrote:

> When I look at http://www.pgadmin.org/support/ for example it suggests the
> right list.  I only see this one listed in the Translation section, as the
> place to ask to get added to the translators list.  Does anyone know where
> the tips section suggesting people send tech questions to pgsql-hackers he's
> referring to is at?  That seems like it should be cleaned up to point to the
> pgAdmin list instead if that's floating around there somewhere.

We actually removed the tips from 1.10.x which shipped with PG 8.4,
but prior to that there were 2 tips relating to the mailing lists:

Support for pgAdmin can be requested through the
pgadmin-support@postgresql.org mailing list.
New features and developments are discussed by the pgAdmin Developers
through the pgadmin-hackers@postgresql.org mailing list.


(http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/branches/REL-1_8_0_PATCHES/pgadmin3/docs/en_US/tips.txt?rev=6770&view=markup)

Neither of those tips has changed since they were committed in July
2003. I also can't find any reference to this list in the docs or the
guru hints.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com


Re: pgAdmin III: timestamp displayed in what time zone?

От
Guillaume Lelarge
Дата:
Le mardi 15 décembre 2009 à 06:30:15, Greg Smith a écrit :
> [...]
> > BTW, this list is listed as the list for tech questions in the pgAdmin
> > tips, therefore if you don't want to be disturb, you might want to
> > remove it from the pgAdmin tips.
>
> When I look at http://www.pgadmin.org/support/ for example it suggests
> the right list.  I only see this one listed in the Translation section,
> as the place to ask to get added to the translators list.  Does anyone
> know where the tips section suggesting people send tech questions to
> pgsql-hackers he's referring to is at?  That seems like it should be
> cleaned up to point to the pgAdmin list instead if that's floating
> around there somewhere.
>

Sorry Greg, it's fixed now.

> Fred, if you could recall exactly what path you followed to end up here
> and let us know, we can try to keep someone else from being confused and
> instead directed to the right place more directly.  It would be a nice
> gesture on your part to end our conversation here having done something
> useful, rather than with you just venting at me.
>

Yeah, it would be interesting to know.


--
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com


Fwd: pgAdmin III: timestamp displayed in what time zone?

От
Fred Janon
Дата:
Looks like Andrew Dunstan didn't want to go public...

Fred

---------- Forwarded message ----------
From: Fred Janon <fjanon@gmail.com>
Date: Tue, Dec 15, 2009 at 10:03
Subject: Re: [HACKERS] pgAdmin III: timestamp displayed in what time zone?
To: Andrew Dunstan <andrew@dunslane.net>


Thanks for being so polite. At least Greg Smith suggested the right list to ask. I see that some people still know how to behave socially. BTW, this list is the list listed in the pgadmin tips for tech questions.

Fred


On Tue, Dec 15, 2009 at 00:07, Andrew Dunstan <andrew@dunslane.net> wrote:

That's no excuse at all. Please keep queries like this OFF the -hackers list.

cheers

andrew

Fred Janon wrote:
Sorry if if's a double post, but I thought that it would be more likely I would get an answer on the hackers list.

Thanks

Fred

---------- ----------
From: *Fred Janon* <fjanon@gmail.com <mailto:fjanon@gmail.com>>

Date: Mon, Dec 14, 2009 at 19:04
Subject: pgAdmin III: timestamp displayed in what time zone?
To: pgsql-general@postgresql.org <mailto:pgsql-general@postgresql.org>



Hi,

I am using Postgres 8.3. I have a table defined like this:

=======================
-- Table: timeson

-- DROP TABLE timeson;

CREATE TABLE timeson
(
 id bigint NOT NULL,
 enddatetime timestamp without time zone NOT NULL,
 startdatetime timestamp without time zone NOT NULL,
 times_id bigint,
 CONSTRAINT timeson_pkey PRIMARY KEY (id),
 CONSTRAINT fkb1af5ba5890cf3da FOREIGN KEY (times_id)
     REFERENCES times (id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (OIDS=FALSE);
ALTER TABLE timeson OWNER TO myfreo;

======================
I populate the table with some data and use pgAdmin III 1.8.4 to view the date "View date> first top100 rows". the question is: in what timezone are the fields showed in pgAdmin? no timezone (as stored), the server time zone or the time zone of the computer where pgAdmin runs?

Thanks

Fred



Re: Fwd: pgAdmin III: timestamp displayed in what time zone?

От
Andrew Dunstan
Дата:
*ahem*

You double-post a query *knowing* you shouldn't (otherwise why the 
"sorry"?), compounding the error by not picking the right list at all. I 
chide you for it privately, not to hide my actions but to keep 
irrelevant traffic on the list down, and you then decide it's proper to 
post my private reply publicly. I don't think you're in any position to 
offer me lessons in netiquette.

cheers

andrew




Fred Janon wrote:
> Looks like Andrew Dunstan didn't want to go public...
>
> Fred
>
> ---------- Forwarded message ----------
> From: *Fred Janon* <fjanon@gmail.com <mailto:fjanon@gmail.com>>
> Date: Tue, Dec 15, 2009 at 10:03
> Subject: Re: [HACKERS] pgAdmin III: timestamp displayed in what time zone?
> To: Andrew Dunstan <andrew@dunslane.net <mailto:andrew@dunslane.net>>
>
>
> Thanks for being so polite. At least Greg Smith suggested the right 
> list to ask. I see that some people still know how to behave socially. 
> BTW, this list is the list listed in the pgadmin tips for tech questions.
>
> Fred
>
>
> On Tue, Dec 15, 2009 at 00:07, Andrew Dunstan <andrew@dunslane.net 
> <mailto:andrew@dunslane.net>> wrote:
>
>
>     That's no excuse at all. Please keep queries like this OFF the
>     -hackers list.
>
>     cheers
>
>     andrew
>
>     Fred Janon wrote:
>
>         Sorry if if's a double post, but I thought that it would be
>         more likely I would get an answer on the hackers list.
>
>         Thanks
>
>         Fred
>
>         ---------- ----------
>         From: *Fred Janon* <fjanon@gmail.com <mailto:fjanon@gmail.com>
>         <mailto:fjanon@gmail.com <mailto:fjanon@gmail.com>>>
>
>         Date: Mon, Dec 14, 2009 at 19:04
>         Subject: pgAdmin III: timestamp displayed in what time zone?
>         To: pgsql-general@postgresql.org
>         <mailto:pgsql-general@postgresql.org>
>         <mailto:pgsql-general@postgresql.org
>         <mailto:pgsql-general@postgresql.org>>
>
>
>
>         Hi,
>
>         I am using Postgres 8.3. I have a table defined like this:
>
>         =======================
>         -- Table: timeson
>
>         -- DROP TABLE timeson;
>
>         CREATE TABLE timeson
>         (
>          id bigint NOT NULL,
>          enddatetime timestamp without time zone NOT NULL,
>          startdatetime timestamp without time zone NOT NULL,
>          times_id bigint,
>          CONSTRAINT timeson_pkey PRIMARY KEY (id),
>          CONSTRAINT fkb1af5ba5890cf3da FOREIGN KEY (times_id)
>              REFERENCES times (id) MATCH SIMPLE
>              ON UPDATE NO ACTION ON DELETE NO ACTION
>         )
>         WITH (OIDS=FALSE);
>         ALTER TABLE timeson OWNER TO myfreo;
>
>         ======================
>         I populate the table with some data and use pgAdmin III 1.8.4
>         to view the date "View date> first top100 rows". the question
>         is: in what timezone are the fields showed in pgAdmin? no
>         timezone (as stored), the server time zone or the time zone of
>         the computer where pgAdmin runs?
>
>         Thanks
>
>         Fred
>
>
>