[HACKERS] Current CVS is broken

2002-10-22 Thread Teodor Sigaev
%gmake

bison -y -d  preproc.y
preproc.y:5560: fatal error: maximum table size (32767) exceeded
gmake[4]: *** [preproc.h] Error 1
gmake[4]: Leaving directory `/spool/home/teodor/pgsql/src/interfaces/ecpg/preproc'
gmake[3]: *** [all] Error 2
gmake[3]: Leaving directory `/spool/home/teodor/pgsql/src/interfaces/ecpg'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/spool/home/teodor/pgsql/src/interfaces'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/spool/home/teodor/pgsql/src'
gmake: *** [all] Error 2
% bison -V
bison (GNU Bison) 1.35

Copyright 1984, 1986, 1989, 1992, 2000, 2001, 2002
Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
% uname -a
FreeBSD xor 4.6-STABLE FreeBSD 4.6-STABLE #2: Tue Jun 18 20:48:48 MSD 2002 
teodor@xor:/usr/src/sys/compile/XOR  i386

--
Teodor Sigaev
[EMAIL PROTECTED]



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [HACKERS] Current CVS is broken

2002-10-22 Thread Michael Paesold
Teodor Sigaev [EMAIL PROTECTED] wrote:

 %gmake
 
 bison -y -d  preproc.y
 preproc.y:5560: fatal error: maximum table size (32767) exceeded
 gmake[4]: *** [preproc.h] Error 1
 gmake[4]: Leaving directory
`/spool/home/teodor/pgsql/src/interfaces/ecpg/preproc'
 gmake[3]: *** [all] Error 2
 gmake[3]: Leaving directory `/spool/home/teodor/pgsql/src/interfaces/ecpg'
 gmake[2]: *** [all] Error 2
 gmake[2]: Leaving directory `/spool/home/teodor/pgsql/src/interfaces'
 gmake[1]: *** [all] Error 2
 gmake[1]: Leaving directory `/spool/home/teodor/pgsql/src'
 gmake: *** [all] Error 2
 % bison -V
 bison (GNU Bison) 1.35

Although I am not a hacker, I think you just need to upgrade
bison to version 1.75 if you want to build from CVS. The ecpg
interface is broken with version 1.35 of bison.

Best Regards,
Michael Paesold


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [HACKERS] Current CVS is broken

2002-10-22 Thread Tom Lane
Oleg Bartunov [EMAIL PROTECTED] writes:
 install bison 1.75

I've fixed the INSTALL and installation.sgml docs to say you need bison
1.50 or later (it used to say 1.28 or later).  Is there anyplace else we
should point this out?

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] Current CVS is broken

2002-10-22 Thread Oleg Bartunov
install bison 1.75


On Tue, 22 Oct 2002, Teodor Sigaev wrote:

 %gmake
 
 bison -y -d  preproc.y
 preproc.y:5560: fatal error: maximum table size (32767) exceeded
 gmake[4]: *** [preproc.h] Error 1
 gmake[4]: Leaving directory `/spool/home/teodor/pgsql/src/interfaces/ecpg/preproc'
 gmake[3]: *** [all] Error 2
 gmake[3]: Leaving directory `/spool/home/teodor/pgsql/src/interfaces/ecpg'
 gmake[2]: *** [all] Error 2
 gmake[2]: Leaving directory `/spool/home/teodor/pgsql/src/interfaces'
 gmake[1]: *** [all] Error 2
 gmake[1]: Leaving directory `/spool/home/teodor/pgsql/src'
 gmake: *** [all] Error 2
 % bison -V
 bison (GNU Bison) 1.35

 Copyright 1984, 1986, 1989, 1992, 2000, 2001, 2002
 Free Software Foundation, Inc.
 This is free software; see the source for copying conditions.  There is NO
 warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 % uname -a
 FreeBSD xor 4.6-STABLE FreeBSD 4.6-STABLE #2: Tue Jun 18 20:48:48 MSD 2002
 teodor@xor:/usr/src/sys/compile/XOR  i386



Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



[HACKERS] Current CVS - something broken in contrib

2002-10-15 Thread Teodor Sigaev

In any contrib module 'make installcheck' runs infinite time...

For example, contrib/ltree
% gmake installcheck
gmake -C ../../src/test/regress pg_regress
gmake[1]: ÷ÈÏÄ × ËÁÔÁÌÏÇ `/spool/home/teodor/pgsql/src/test/regress'
gmake[1]: `pg_regress' ÎÅ ÔÒÅÂÕÅÔ ÏÂÎÏ×ÌÅÎÉÑ.
gmake[1]: ÷ÙÈÏÄ ÉÚ ËÁÔÁÌÏÇ `/spool/home/teodor/pgsql/src/test/regress'
../../src/test/regress/pg_regress ltree
(using postmaster on Unix socket, default port)
== dropping database regression ==
DROP DATABASE
== creating database regression ==
CREATE DATABASE
ALTER DATABASE
== dropping regression test user accounts ==
== installing PL/pgSQL==
== running regression test queries==
test ltree...

In this time in top:
CPU states:  100% user,  0.0% nice,  0.0% system,  0.0% interrupt,  0.0% idle
Mem: 116M Active, 33M Inact, 24M Wired, 11M Cache, 29M Buf, 1528K Free
Swap: 510M Total, 32M Used, 477M Free, 6% Inuse
kill
   PID USERNAME PRI NICE  SIZERES STATETIME   WCPUCPU COMMAND
18180 teodor64   0  1852K  1248K RUN  1:15 95.07% 93.65% psql

postmaster doesn't take a CPU time...


-- 
Teodor Sigaev
[EMAIL PROTECTED]



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [HACKERS] Current CVS - something broken in contrib

2002-10-15 Thread Tom Lane

Teodor Sigaev [EMAIL PROTECTED] writes:
 In any contrib module 'make installcheck' runs infinite time...

Looks like my fault :-( ... will have it fixed in a few minutes
(I seem to have broken psql for COPY FROM STDIN :-()

regards, tom lane

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Current CVS - something broken in contrib

2002-10-15 Thread Tom Lane

Teodor Sigaev [EMAIL PROTECTED] writes:
 In any contrib module 'make installcheck' runs infinite time...

Actually, I had managed to break \copy, not COPY --- it seems the
main regression tests exercise COPY but not \copy.  It might be
a good idea to change copy2.sql to exercise both ...

Anyway, fix committed.

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



[HACKERS] Current CVS is broken

2002-09-20 Thread Teodor Sigaev

% uname -a
FreeBSD xor 4.6-STABLE FreeBSD 4.6-STABLE #2: Tue Jun 18 20:48:48 MSD 2002 
teodor@xor:/usr/src/sys/compile/XOR  i386
...

gmake[3]:  `/spool/home/teodor/pgsql/src/backend/commands'
gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
-I../../../src/include   -c -o aggregatecmds.o aggregatecmds.c
gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
-I../../../src/include   -c -o analyze.o analyze.c
gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
-I../../../src/include   -c -o async.o async.c
gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
-I../../../src/include   -c -o cluster.o cluster.c
gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
-I../../../src/include   -c -o comment.o comment.c
gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
-I../../../src/include   -c -o conversioncmds.o conversioncmds.c
gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
-I../../../src/include   -c -o copy.o copy.c
copy.c: In function `CopyFrom':
copy.c:1130: warning: passing arg 1 of `coerce_type_constraints' from 
incompatible pointer type
copy.c:1130: warning: passing arg 2 of `coerce_type_constraints' makes integer 
from pointer without a cast
copy.c:1130: too many arguments to function `coerce_type_constraints'

-- 
Teodor Sigaev
[EMAIL PROTECTED]



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [HACKERS] Current CVS is broken

2002-09-20 Thread Tom Lane

Teodor Sigaev [EMAIL PROTECTED] writes:
 gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
 -I../../../src/include   -c -o copy.o copy.c
 copy.c: In function `CopyFrom':
 copy.c:1130: warning: passing arg 1 of `coerce_type_constraints' from 
 incompatible pointer type
 copy.c:1130: warning: passing arg 2 of `coerce_type_constraints' makes integer 
 from pointer without a cast
 copy.c:1130: too many arguments to function `coerce_type_constraints'

Looks like Rod's domain-constraints-in-COPY patch was stale after my
recent casting changes.  Will work on it ...

(Bruce, you really oughta do some minimal testing on patches before
committing 'em.)

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] Current CVS is broken

2002-09-20 Thread Bruce Momjian

Tom Lane wrote:
 Teodor Sigaev [EMAIL PROTECTED] writes:
  gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
  -I../../../src/include   -c -o copy.o copy.c
  copy.c: In function `CopyFrom':
  copy.c:1130: warning: passing arg 1 of `coerce_type_constraints' from 
  incompatible pointer type
  copy.c:1130: warning: passing arg 2 of `coerce_type_constraints' makes integer 
  from pointer without a cast
  copy.c:1130: too many arguments to function `coerce_type_constraints'
 
 Looks like Rod's domain-constraints-in-COPY patch was stale after my
 recent casting changes.  Will work on it ...
 
 (Bruce, you really oughta do some minimal testing on patches before
 committing 'em.)

Sorry, forgot this time.  I do normally test.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Current CVS is broken

2002-09-20 Thread Bruce Momjian

Tom Lane wrote:
 Teodor Sigaev [EMAIL PROTECTED] writes:
  gcc -g -O -Wall -Wmissing-prototypes -Wmissing-declarations 
  -I../../../src/include   -c -o copy.o copy.c
  copy.c: In function `CopyFrom':
  copy.c:1130: warning: passing arg 1 of `coerce_type_constraints' from 
  incompatible pointer type
  copy.c:1130: warning: passing arg 2 of `coerce_type_constraints' makes integer 
  from pointer without a cast
  copy.c:1130: too many arguments to function `coerce_type_constraints'
 
 Looks like Rod's domain-constraints-in-COPY patch was stale after my
 recent casting changes.  Will work on it ...
 
 (Bruce, you really oughta do some minimal testing on patches before
 committing 'em.)

OK, patch attached. Tom, what is the proper third parameter in COPY,
COERCE_DONTCARE?

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073


Index: src/backend/commands/copy.c
===
RCS file: /cvsroot/pgsql-server/src/backend/commands/copy.c,v
retrieving revision 1.172
diff -c -c -r1.172 copy.c
*** src/backend/commands/copy.c 20 Sep 2002 03:52:50 -  1.172
--- src/backend/commands/copy.c 20 Sep 2002 15:28:42 -
***
*** 1126,1133 
false); /* not 
coerced */
  
/* Process constraints */
!   node = coerce_type_constraints(pstate, (Node *) con,
!  
attr[m]-atttypid, true);
  
values[m] = ExecEvalExpr(node, econtext,
 
isNull, NULL);
--- 1126,1133 
false); /* not 
coerced */
  
/* Process constraints */
!   node = coerce_type_constraints((Node *) con, 
attr[m]-atttypid,
!  
 COERCE_DONTCARE);
  
values[m] = ExecEvalExpr(node, econtext,
 
isNull, NULL);



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Current CVS is broken

2002-09-20 Thread Tom Lane

Bruce Momjian [EMAIL PROTECTED] writes:
 OK, patch attached. Tom, what is the proper third parameter in COPY,
 COERCE_DONTCARE?

It would be COERCE_IMPLICIT_CAST.  But I don't like the patch as it
stands anyway, because it is repeating a ton of catalog lookups for
every input row.  I have more extensive changes in mind ...

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Current CVS is broken

2002-09-20 Thread Bruce Momjian

Tom Lane wrote:
 Bruce Momjian [EMAIL PROTECTED] writes:
  OK, patch attached. Tom, what is the proper third parameter in COPY,
  COERCE_DONTCARE?
 
 It would be COERCE_IMPLICIT_CAST.  But I don't like the patch as it
 stands anyway, because it is repeating a ton of catalog lookups for
 every input row.  I have more extensive changes in mind ...

OK, I changed it to COERCE_IMPLICIT_CAST.  The patch did fix a COPY
failure for NULL's and DOMAIN so I didn't remove the patch.  Feel free
to wack it around.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[HACKERS] Current CVS is broken

2001-08-21 Thread Teodor Sigaev

gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include 
   -c -o auth.o auth.c
In file included from auth.c:22:
/usr/include/sys/ucred.h:50: `NGROUPS' undeclared here (not in a function)

% uname -a
FreeBSD xor 4.3-STABLE FreeBSD 4.3-STABLE #2: Thu May 24 14:05:34 MSD 2001 
teodor@xor:/usr/src/sys/compile/XOR  i386

-- 
Teodor Sigaev
[EMAIL PROTECTED]



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]