in my Postgres log file, I see something like this:
usename dbname, .., logtimestamp1... ... insert
then the next line:
username, dbname, ... logtimestamp2... duration: 0.2 ms
My questions:
1. Is this 0.2 ms how much time the insert takes to finish?
2. does "logtimestamp2 - logtimestamp
Tom Lane wrote:
Thomas Swan <[EMAIL PROTECTED]> writes:
No, it won't. If the user has TimeZone set to -05, as he should, then
his input of '2002-06-20 12:00:00' will be read as '2002-06-20 12:00:00-05'.
And it will be displayed to him that way. But if someone else who
has
Thomas Swan <[EMAIL PROTECTED]> writes:
>> No, it won't. If the user has TimeZone set to -05, as he should, then
>> his input of '2002-06-20 12:00:00' will be read as '2002-06-20 12:00:00-05'.
>> And it will be displayed to him that way. But if someone else who
>> has TimeZone set differently lo
Tom Lane wrote:
Felipe Nascimento <[EMAIL PROTECTED]> writes:
let's imagine that my server resides in Time Zone(TZ) "-00", and one user
resides in TZ "-05". Let=B4s say that 12p.m. to the user is 3p.m. to the
server, on the same day.
Let's say that the user inp
Title: RE: [ADMIN] time stamp
Is this valid for Web applications where the db server's client is the web server? (web server resides on the same machine of the db server!)
Or this is valid only for client x server applications?
Felipe
-Original Message-
From: Tom Lane [m
Felipe Nascimento <[EMAIL PROTECTED]> writes:
> let's imagine that my server resides in Time Zone(TZ) "-00", and one user
> resides in TZ "-05". Let=B4s say that 12p.m. to the user is 3p.m. to the
> server, on the same day.
> Let's say that the user inputs a date for a business meeting: "2002-06-
Title: Re: [ADMIN] time stamp
Anybody???
I used to manage a database without Time Zone. Now I use PG,
and this concept of using Time Zone in date data is new to me. I find it
intersting, but I have the following doubt:
let's imagine that my server resides in Time Zone(TZ)
Title: Re: [ADMIN] time stamp
Interesting point.
Original Message dated 21/06/02, 4:31:39
Author: Felipe Nascimento
<[EMAIL PROTECTED]>
Re: Re: [ADMIN] time stamp :
I used to manage a database without Time Zone. Now I
use PG, and this concept of using Time Zone in date data is new
ubject: Re: [ADMIN] time stamp
I used to manage a database without Time Zone. Now I use PG, and this
concept of using Time Zone in date data is new to me. I find it intersting,
but I have the following doubt:
let's imagine that my server resides in Time Zone(TZ) "-00", and one user
Title: RE: [ADMIN] time stamp
I used to manage a database without Time Zone. Now I use PG, and this concept of using Time Zone in date data is new to me. I find it intersting, but I have the following doubt:
let's imagine that my server resides in Time Zone(TZ) "-00", and o
"nimeshb" <[EMAIL PROTECTED]> writes:
> CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ; doesn't work.
Oh? I get
test72=# CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ;
CREATE
test72=# insert into test values(now());
INSERT 803798 1
test72=# insert into test values('2002-02-22 12:34:5
]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 20, 2002 10:54 AM
Subject: Re: [ADMIN] time stamp
> > CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ; doesn't work. It
> > creates that table but
> > when you insert a value without time zone it stll appends -05
"Gaetano Mendola" <[EMAIL PROTECTED]> wrote:
> Is it possible have on log file the time stamp ?
>
I find it !!! Thank you anyway.
It's enough send the SIGHUP to postmaster
for don't loose the existing connections?
Ciao
Gaetano
--
#exclude
#include
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t
Is it possible have on log file the time stamp ?
Ciao
Gaetano
--
#exclude
#include
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
14 matches
Mail list logo
