Attribute 'aggtransfn1' is repeated
Attribute 'aggtransfn1' is repeated
От:
Peter Vazsonyi <neko@kredit.sth.szif.hu>
Дата:
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;(
Re: [ADMIN] Attribute 'aggtransfn1' is repeated
От:
Peter Vazsonyi <neko@kredit.sth.szif.hu>
Дата:
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;(
Re: [HACKERS] Re: [ADMIN] Attribute 'aggtransfn1' is repeated
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
> 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