Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id DEF18476660 for ; Fri, 31 May 2002 13:57:18 -0400 (EDT) Received: from hotmail.com (oe29.law4.hotmail.com [216.33.148.22]) by postgresql.org (Postfix) with ESMTP id D825A476393 for ; Fri, 31 May 2002 13:57:17 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 31 May 2002 10:57:18 -0700 X-Originating-IP: [212.9.66.13] From: "Areski Belaid" To: References: <3CCE936B.245D870C@juliana-multimedia.com> <200204301522.44037.jm.poure@freesurf.fr> <3CCECCD8.A11B8F8C@juliana-multimedia.com> Subject: Incompatibility Postgres 7.1 - Postgres 7.3 Date: Fri, 31 May 2002 19:57:16 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: X-OriginalArrivalTime: 31 May 2002 17:57:18.0108 (UTC) FILETIME=[9AAB8DC0:01C208CC] X-Archive-Number: 200205/120 X-Sequence-Number: 1252 Someone can help me .... I have a compatibility problem between Postgres 7.1 - Postgres 7.3... Guess !!! It's --- timestamptz --- When I create a field with timestamp type... the new postgresql replace that by timestamptz.... I use phpPgAdmin, I don't know where is from the problem... Simple example, If I execute that : CREATE TABLE "statistic" ( "Id" int4 NOT NULL, "DATE" timestamp); I shall have that on the database: CREATE TABLE "statistic" ( "Id" int4 NOT NULL, "DATE" timestamptz); Grrrrrr, =) Helpsssssss, Areski