[BUGS] Postgres 7 on Alpha

2000-11-07 Thread Roger Wernersson
Hi! I have an old Alpha system which I use as a database server. I have successufully run Postgres 6.5 on it but needed to upgrade to Postgres 7 to solve some problems. I downloaded the source of 7.0.2 as I could not find any RPM of Postgres 7 for Alpha. I compiled and installed it without a

Re: [BUGS] Postgres 7 on Alpha

2000-11-07 Thread Tom Lane
Roger Wernersson <[EMAIL PROTECTED]> writes: > I have an old Alpha system which I use as a database server. I have > successufully run Postgres 6.5 on it but needed to upgrade to Postgres 7 > to solve some problems. I downloaded the source of 7.0.2 as I could not > find any RPM of Postgres 7 fo

Re: [BUGS] Postgres 7 on Alpha

2000-11-07 Thread Lamar Owen
Roger Wernersson wrote: > I run Red Hat Linux release 6.2 (Zoot), Kernel 2.2.14-6.0 on an alpha. > What do I do now? What is a spinlock? Apply Ryan Kirkpatrick's patches for PostgreSQL 7.0.x, available at http://www.rkirkpat.net/software/#linux-alpha and rebuild. You will need to start with a fr

[BUGS] to_date problems (Re: Favor for Postgres User at WSI)

2000-11-07 Thread Tom Lane
Kate Collins <[EMAIL PROTECTED]> writes: >> In other words it is defaulting to the year 0 (actually year 1 BC, since >> there is no year 0) instead of 2000. Hmm, you're right: regression=# select to_date( '001112', 'YYMMDD'); to_date --- 0001-11-12 BC (1 row) >> Now I run the e