Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-14 Thread Vick Khera
On Thu, Feb 14, 2013 at 3:15 AM, Albe Laurenz wrote: > Vick Khera wrote: > > There are some implicit casting changes that broke some of my code > > when 8.2 came out. > > You mean 8.3, right? > Based on further discussion in this thread, yes.

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-14 Thread Albe Laurenz
Vick Khera wrote: > There are some implicit casting changes that broke some of my code > when 8.2 came out. You mean 8.3, right? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pg

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-13 Thread Vick Khera
On Feb 11, 2013, at 8:18 PM, John R Pierce wrote: > are you sure it requires this old version? most software works with newer > versions with little or no changes. There are some implicit casting changes that broke some of my code when 8.2 came out. Ever since then there have been no issues f

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-12 Thread Wan Hashim
Postgresql 8.0.5 has been successfully installed in Ubuntu 10 . thank you to all > > second line should be > > sudo apt-get install libreadline-dev > > of course. unless you're logged in as root. > > On Tue, Feb 12, 2013 at 12:26 AM, Scott Marlowe > wrote: >> Not from a package. I don't think

[GENERAL] Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread whas...@gmail.com
Thank you Scot. I will try Sent from my HTC - Reply message - From: "Scott Marlowe" To: "whas...@gmail.com" Cc: "Adrian Klaver" , "pgsql-general@postgresql.org" Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12 Date: Tue, Feb 12, 2013 3:27 pm second line should be sudo

[GENERAL] Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread whas...@gmail.com
Thank you @ Sent from my HTC - Reply message - From: "Scott Marlowe" To: "whas...@gmail.com" Cc: "Adrian Klaver" , "pgsql-general@postgresql.org" Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12 Date: Tue, Feb 12, 2013 3:27 pm second line should be sudo apt-get install

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread John R Pierce
On 2/11/2013 11:26 PM, Scott Marlowe wrote: ./configure --prefix=/opt/postgres# or wherever you want pg to install and depending on your application's requirements, you may want to enable perl, python or whatever and whatever other optional stuff you may need.. -- john r pierce

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Scott Marlowe
second line should be sudo apt-get install libreadline-dev of course. unless you're logged in as root. On Tue, Feb 12, 2013 at 12:26 AM, Scott Marlowe wrote: > Not from a package. I don't think any recent distros have a repo with > 8.0 in it, so you'll have to build from source. HOWEVER, bui

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Scott Marlowe
Not from a package. I don't think any recent distros have a repo with 8.0 in it, so you'll have to build from source. HOWEVER, building from source is REAL easy with postgresql. sudo apt-get install build-essential # ubuntu build tools apt-get install libreadline-dev # used by pgsql to have an

[GENERAL] Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread whas...@gmail.com
I believe the software can work with any postgresql 8.0.* . It is possible to install pg 8.0 in current release of linux? Sent from my HTC - Reply message - From: "Scott Marlowe" To: "Wan Hashim" Cc: "Adrian Klaver" , Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12 Date

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Scott Marlowe
On Mon, Feb 11, 2013 at 5:29 PM, Wan Hashim wrote: > our legacy system required postgresql 8.0 to run. we are in the > process of upgrading the application and database. > we must have postgresql 8.8 to keep the system running at this moment . > if possible , we want to run in Ubuntu 12. we can co

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Adrian Klaver
On 02/11/2013 06:59 PM, Scott Marlowe wrote: Wait I think it was 8.2 wasn't it? http://www.postgresql.org/docs/8.3/interactive/release-8-3.html E.24.2.1. General Non-character data types are no longer automatically cast to TEXT (Peter, Tom) Previously, if a non-character value was supplied

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Tom Lane
Scott Marlowe writes: > The change from 8.0 to 8.1 that removed implicit casts broke a LOT of > poorly written software. That was 8.3, not 8.1. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Scott Marlowe
Wait I think it was 8.2 wasn't it? On Mon, Feb 11, 2013 at 7:58 PM, Tom Lane wrote: > Scott Marlowe writes: >> The change from 8.0 to 8.1 that removed implicit casts broke a LOT of >> poorly written software. > > That was 8.3, not 8.1. > > regards, tom lane -- To unde

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Scott Marlowe
The change from 8.0 to 8.1 that removed implicit casts broke a LOT of poorly written software. For OP: Install from source, if you don't need EXACTLY the old 8.0.5 version at least look at the bug fixed version 8.0.latest (28 or so?) On Mon, Feb 11, 2013 at 6:17 PM, John R Pierce wrote: > On 2/1

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread John R Pierce
On 2/11/2013 4:29 PM, Wan Hashim wrote: our legacy system required postgresql 8.0 to run. are you sure it requires this old version? most software works with newer versions with little or no changes. -- john r pierce 37N 122W somewhere on the middle

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Adrian Klaver
On 02/11/2013 04:29 PM, Wan Hashim wrote: our legacy system required postgresql 8.0 to run. we are in the process of upgrading the application and database. we must have postgresql 8.8 to keep the system running at this moment . if possible , we want to run in Ubuntu 12. we can consider older ver

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Wan Hashim
our legacy system required postgresql 8.0 to run. we are in the process of upgrading the application and database. we must have postgresql 8.8 to keep the system running at this moment . if possible , we want to run in Ubuntu 12. we can consider older version of OS if it can help . tq On Tue, Feb

Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

2013-02-11 Thread Adrian Klaver
On 02/11/2013 03:40 PM, Wan Hashim wrote: Hi all; Im looking for in information and resources to setup postgresql 8.0.5 in Ubuntu server . tq Is there a reason you want to install a version that is no longer supported? Also I believe you mean Ubuntu 12.10, correct? -- Adrian Klaver ad