I installed postgresql-v6.5.3 on my sparc64-linux from source.
When that was done, i tried to run initdb, and:
[postgres@sun2 pgsql]$ PATH=$PATH:/usr/local/pgsql/bin
[postgres@sun2 pgsql]$ initdb -r $PWD -l /usr/local/pgsql/lib/

We are initializing the database system with username postgres (uid=40).
This user will own all the files and must also own the server process.

Creating template database in /var/lib/pgsql/base/template1
ERROR:  Attribute 'aggtransfn1' is repeated
ERROR:  Attribute 'aggtransfn1' is repeated
initdb: could not create template database
initdb: cleaning up by wiping out /var/lib/pgsql/base/template1
>From $PGLIB/local1_template1.bki.source
create pg_aggregate
 (
 aggname = name ,
 aggowner = int4 ,
 aggtransfn1 = regproc ,
 aggtransfn2 = regproc ,
 aggfinalfn = regproc ,
 aggbasetype = oid ,
 aggtranstype1 = oid ,
 aggtranstype2 = oid ,
 aggfinaltype = oid ,
 agginitval1 = text ,
 agginitval2 = text
 )
So i try to change this:
--- local1_template1.bki.source.orig  Fri Jan 28 12:34:07 2000
+++ local1_template1.bki.source  Fri Jan 28 12:33:39 2000
@@ -2235,8 +2235,8 @@ create pg_aggregate
  aggowner = int4 ,
- aggtransfn1 = regproc ,
- aggtransfn2 = regproc ,
+ 1aggtransfn = regproc ,
+ 2aggtransfn = regproc ,
  aggfinalfn = regproc ,

And now the ERROR message changed:
ERROR:  Attribute 'agginitval1' is repeated
Maybe there are some problems, with length of field names, but the same
source works properly on a i586-linux.
I run configure script as:
./configure --enable-locale --with-template=linux_sparc

I had problems with daily snapshot too, but the error was something else.

Can anybody help me?

--
 nek;(


Fri, 28 Jan 2000 12:58:03 +0100 (CET)
Peter Vazsonyi <neko@kredit.sth.szif.hu>
Attribute 'aggtransfn1' is repeated
Opps... that was simple bug.
I don't understand why works on x86, why not on sparc (gcc?), but this small
patch should correct the error.

On Fri, 28 Jan 2000, Peter Vazsonyi wrote:

> [postgres@sun2 pgsql]$ initdb -r $PWD -l /usr/local/pgsql/lib/
> 
> We are initializing the database system with username postgres (uid=40).
> This user will own all the files and must also own the server process.
> 
> Creating template database in /var/lib/pgsql/base/template1
> ERROR:  Attribute 'aggtransfn1' is repeated
> ERROR:  Attribute 'aggtransfn1' is repeated

--
 nek;(
Mon, 31 Jan 2000 15:13:55 +0100 (CET)
Peter Vazsonyi <neko@kredit.sth.szif.hu>
Re: [ADMIN] Attribute 'aggtransfn1' is repeated
> Opps... that was simple bug.
> I don't understand why works on x86, why not on sparc (gcc?), but this small
> patch should correct the error.

Already patched in current tree.  Thanks.


> 
> On Fri, 28 Jan 2000, Peter Vazsonyi wrote:
> 
> > [postgres@sun2 pgsql]$ initdb -r $PWD -l /usr/local/pgsql/lib/
> > 
> > We are initializing the database system with username postgres (uid=40).
> > This user will own all the files and must also own the server process.
> > 
> > Creating template database in /var/lib/pgsql/base/template1
> > ERROR:  Attribute 'aggtransfn1' is repeated
> > ERROR:  Attribute 'aggtransfn1' is repeated
> 
> --
>  nek;(
> 
Content-Description: 

[Attachment, skipping...]


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 31 Jan 2000 20:51:55 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Re: [ADMIN] Attribute 'aggtransfn1' is repeated