Re: [HACKERS] initdb problem

On Tue, Aug 25, 1998 at 01:45:33PM -0400, Bruce Momjian wrote:
> That is the problem. I don't have an fmgr.h file in include, just in
> backend/fmgr.h. It is finding an old one first. It was not a problem
> as long as no one made changes to the system tables, but I did.
>
> That is why the clean cvsup worked for people. How the fmgr.h file got
> into include, I have no idea.
>
> The only 683 I get from the source are labels in gram.c.
>
> Remove the file and recompile.

I did and it works! Thanks a lot. I also tried the ecpg examples. Two ran
fine, but the perftest.pgc example gets:

postgres(at)feivel:~/pgsql/src/interfaces/ecpg.mm/test$ ./perftest
I needed 14 seconds and 618584 microseconds for the insert test.
sql error Error: ERROR: fmgr_info: function 28261: cache lookup failed

line 19.

line 19 is exec sql vacuum.

BTW the UNLISTEN symbol is undefined in gram.y and here's a minor patch to
be able to compile ecpg:

diff -rc ecpg/preproc/preproc.y ecpg.mm/preproc/preproc.y
*** ecpg/preproc/preproc.y Wed Aug 26 06:42:50 1998
--- ecpg.mm/preproc/preproc.y Wed Aug 26 08:17:24 1998
***************
*** 641,647 ****
%type <str> join_using where_clause relation_expr row_op sub_type
%type <str> opt_column_list insert_rest InsertStmt OptimizableStmt
%type <str> columnList DeleteStmt LockStmt UpdateStmt CursorStmt
! %type <str> NotifyStmt columnElem copy_dirn SubUnion c_expr
%type <str> copy_delimiter ListenStmt CopyStmt copy_file_name opt_binary
%type <str> opt_with_copy FetchStmt opt_direction fetch_how_many opt_portal_name
%type <str> ClosePortalStmt DestroyStmt VacuumStmt opt_verbose
--- 641,647 ----
%type <str> join_using where_clause relation_expr row_op sub_type
%type <str> opt_column_list insert_rest InsertStmt OptimizableStmt
%type <str> columnList DeleteStmt LockStmt UpdateStmt CursorStmt
! %type <str> NotifyStmt columnElem copy_dirn SubUnion c_expr UnlistenStmt
%type <str> copy_delimiter ListenStmt CopyStmt copy_file_name opt_binary
%type <str> opt_with_copy FetchStmt opt_direction fetch_how_many opt_portal_name
%type <str> ClosePortalStmt DestroyStmt VacuumStmt opt_verbose

Michael
--
Michael Meskes meskes(at)online-club(dot)de, meskes(at)debian(dot)org
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!