Re: pg_dump compatibility between 7.3 and 7.2?

Lists: pgsql-hackers
From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump compatibility between 7.3 and 7.2?
Date: 2002-09-02 06:55:08
Message-ID: 200209020855.08278.mweilguni@sime.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi,

I've tried to evaluate the compatibility of the current CVS version to our current 7.2.1 version, and noticed that 7.2.x dumps are not compatible with 7.3, not even in cleartext format.
Timestamps in 7.2.x are this format: 2002-07-04 15:19:11.363562+02
7.3 expects a timestamp per default in this format: 2002-09-02 08:51:27,223455+02

I found no way to import this database, experimenting with "set datestyle ..." did not help. Will 7.3 really be that incompatible regarding timestamps? Or is this simply a problem with my current locale?

Best regards,
Mario Weilguni

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Mario Weilguni" <mweilguni(at)sime(dot)com>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump compatibility between 7.3 and 7.2?
Date: 2002-09-02 06:57:30
Message-ID: GNELIHDDFBOCMGBFGEFOAEAACEAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Looks like a locale problem to me, Mario...

That comma is a non-USA (or oz, uk, canada) decimal separator...

Chris

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Mario Weilguni
> Sent: Monday, 2 September 2002 2:55 PM
> To: Hackers
> Subject: [HACKERS] pg_dump compatibility between 7.3 and 7.2?
>
>
> Hi,
>
> I've tried to evaluate the compatibility of the current CVS
> version to our current 7.2.1 version, and noticed that 7.2.x
> dumps are not compatible with 7.3, not even in cleartext format.
> Timestamps in 7.2.x are this format: 2002-07-04 15:19:11.363562+02
> 7.3 expects a timestamp per default in this format: 2002-09-02
> 08:51:27,223455+02
>
> I found no way to import this database, experimenting with "set
> datestyle ..." did not help. Will 7.3 really be that incompatible
> regarding timestamps? Or is this simply a problem with my current locale?
>
> Best regards,
> Mario Weilguni
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Mario Weilguni <mweilguni(at)sime(dot)com>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump compatibility between 7.3 and 7.2?
Date: 2002-09-02 22:26:31
Message-ID: Pine.LNX.4.44.0209022039580.1134-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Mario Weilguni writes:

> Timestamps in 7.2.x are this format: 2002-07-04 15:19:11.363562+02
> 7.3 expects a timestamp per default in this format: 2002-09-02 08:51:27,223455+02

If you're not running the reallly latest 7.3 tip, update and try again.
Something related to this was fixed recently.

--
Peter Eisentraut peter_e(at)gmx(dot)net

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump compatibility between 7.3 and 7.2?
Date: 2002-09-03 07:00:22
Message-ID: 200209030900.22997.mweilguni@sime.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Am Dienstag, 3. September 2002 00:26 schrieb Peter Eisentraut:
> Mario Weilguni writes:
> > Timestamps in 7.2.x are this format: 2002-07-04 15:19:11.363562+02
> > 7.3 expects a timestamp per default in this format: 2002-09-02
> > 08:51:27,223455+02
>
> If you're not running the reallly latest 7.3 tip, update and try again.
> Something related to this was fixed recently.

It seems to work now, thanks. My last update was yesterday morning, so I thought it was fresh enough.

Thanks!