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@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@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!    Use Debian GNU/Linux!