NOTICE: DateStyle is Postgres with Eropean convention

Started by Marcosalmost 26 years ago3 messagesgeneral
Jump to latest
#1Marcos
marcos@second.ival.es

hi list,

i have restart postgresql with

postmaster -i -o -e &

and every time the servlets (via web) are accesing to posgres
database it shows, in the shell, this:

NOTICE: DateStyle is Postgres with European conventions

thanks

marcos
marcos@ival.es

#2Thomas Lockhart
lockhart@alumni.caltech.edu
In reply to: Marcos (#1)
Re: NOTICE: DateStyle is Postgres with Eropean convention

and every time the servlets (via web) are accesing to posgres
database it shows, in the shell, this:
NOTICE: DateStyle is Postgres with European conventions

Servlets? So are you using JDBC? Some of the interfaces (JDBC is one of
them, afaik) explicitly set the date/time style because they are
responsible for manipulating date/time strings coming back from the
server, and need to ensure that these strings are in a known format.

The notice comes from an explicit "SET DATESTYLE", and should be
considered normal behavior when using some interfaces. Not all
interfaces need to do this automatically, so you will have to be more
specific on your exact scenerio to tell for sure whether you can safely
supress this.

- Thomas

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Marcos (#1)
Re: NOTICE: DateStyle is Postgres with Eropean convention

Marcos Lloret <marcos@second.ival.es> writes:

i have restart postgresql with

postmaster -i -o -e &

and every time the servlets (via web) are accesing to posgres
database it shows, in the shell, this:

NOTICE: DateStyle is Postgres with European conventions

As Thomas pointed out, NOTICE traffic on the postmaster log is pretty
common (just try a vacuum or an explain verbose if you want to see a
lot more...). I think your mistake is in not redirecting the
postmaster's log output somewhere else than your terminal. See for
example http://www.postgresql.org/docs/postgres/postmaster.htm

regards, tom lane