Re: PostgreSQL 8.1.0 RHEL / Debian incompatible packages
Richard van den Berg <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general,gmane.comp.db.postgresql.ports |
|---|---|
| Organization | Trust Factory |
| Message-ID | <[email protected]> |
Martijn van Oosterhout wrote:
> Just be glad the server didn't startup and subsequently crash the first
> time you read a timestamp value.
I was pleasantly surprised that PostgreSQL gave such a detailed error
message. Even down to the compile option that was different, good job.
I'll just do a pg_dump / pg_restore cycle, as I was planning to do. Is
there any guarantee for compatability the pg_dump format? Say, can a
8.1.0 pg_dump made using a 64 bit Solaris SPARC binary be read using a
32 bit Intel Linux pg_restore 8.1.0 binary? ;-)
--
Richard van den Berg, CISSP
-------------------------------------------
Trust Factory B.V. | www.dna-portal.net
Bazarstraat 44a | www.trust-factory.com
2518AK The Hague | Phone: +31 70 3620684
The Netherlands | Fax : +31 70 3603009
-------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match