From: | Peter Vazsonyi <neko(at)kredit(dot)sth(dot)szif(dot)hu> |
---|---|
To: | pgsql-admin(at)hub(dot)org |
Subject: | Attribute 'aggtransfn1' is repeated |
Date: | 2000-01-28 11:58:03 |
Message-ID: | Pine.LNX.4.10.10001281234500.18016-100000@kredit.sth.szif.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
I installed postgresql-v6.5.3 on my sparc64-linux from source.
When that was done, i tried to run initdb, and:
[postgres(at)sun2 pgsql]$ PATH=$PATH:/usr/local/pgsql/bin
[postgres(at)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;(
From | Date | Subject | |
---|---|---|---|
Next Message | Ruben Fagundo | 2000-01-28 16:38:49 | Fwd: Re: fun with postgresql |
Previous Message | hgrgto | 2000-01-27 17:18:07 | 18 yr. old blonde 8358 |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris | 2000-01-28 13:17:27 | postgres under gdb |
Previous Message | Chris | 2000-01-28 11:13:44 | OO and tuples of different types |