Thread: NOTICE: DateStyle is Postgres with Eropean convention

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

>     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

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