Re: Missing file from CVS?

Joe,

I've been told by Tom Lane that the problem is related to having Perl
working, so I'm assuming theres a change that needs to go into the win32
makefile that builds this file using perl.

I'm going to have a go at finding the relevant commands and create a patch.

I've also attached the output of a CVS update and a compile so you can see
where my problem comes from. The compile error is near the bottom of this
text and reads;

help.c(31) : fatal error C1083: Cannot open include file: 'sql_help.h': No
such
file or directory

Regards,

Al.

C:\Projects\pgsql\src>cvs update -dP
cvs server: Updating .
cvs server: Updating backend
cvs server: Updating backend/access
cvs server: Updating backend/access/common
cvs server: Updating backend/access/gist
cvs server: Updating backend/access/hash
cvs server: Updating backend/access/heap
cvs server: Updating backend/access/index
cvs server: Updating backend/access/nbtree
cvs server: Updating backend/access/rtree
cvs server: Updating backend/access/transam
cvs server: Updating backend/bootstrap
cvs server: Updating backend/catalog
cvs server: Updating backend/commands
cvs server: Updating backend/commands/_deadcode
cvs server: Updating backend/executor
cvs server: Updating backend/executor/_deadcode
cvs server: Updating backend/include
cvs server: Updating backend/lib
cvs server: Updating backend/libpq
cvs server: Updating backend/main
cvs server: Updating backend/nodes
cvs server: Updating backend/optimizer
cvs server: Updating backend/optimizer/geqo
cvs server: Updating backend/optimizer/path
cvs server: Updating backend/optimizer/path/_deadcode
cvs server: Updating backend/optimizer/plan
cvs server: Updating backend/optimizer/prep
cvs server: Updating backend/optimizer/prep/_deadcode
cvs server: Updating backend/optimizer/util
cvs server: Updating backend/parser
cvs server: Updating backend/po
cvs server: Updating backend/port
cvs server: Updating backend/port/BSD44_derived
cvs server: Updating backend/port/aix
cvs server: Updating backend/port/alpha
cvs server: Updating backend/port/beos
cvs server: Updating backend/port/bsdi
cvs server: Updating backend/port/bsdi_2_1
cvs server: Updating backend/port/common
cvs server: Updating backend/port/darwin
cvs server: Updating backend/port/dgux
cvs server: Updating backend/port/dynloader
cvs server: Updating backend/port/hpux
cvs server: Updating backend/port/i386_solaris
cvs server: Updating backend/port/irix5
cvs server: Updating backend/port/linux
cvs server: Updating backend/port/linux/asm
cvs server: Updating backend/port/linux_alpha
cvs server: Updating backend/port/linux_i386
cvs server: Updating backend/port/linuxalpha
cvs server: Updating backend/port/next
cvs server: Updating backend/port/nextstep
cvs server: Updating backend/port/qnx
cvs server: Updating backend/port/qnx4
cvs server: Updating backend/port/sco
cvs server: Updating backend/port/sparc
cvs server: Updating backend/port/sparc_solaris
cvs server: Updating backend/port/sunos4
cvs server: Updating backend/port/svr4
cvs server: Updating backend/port/tas
cvs server: Updating backend/port/ultrix4
cvs server: Updating backend/port/univel
cvs server: Updating backend/port/win32
cvs server: Updating backend/port/win32/regex
cvs server: Updating backend/port/win32/sys
cvs server: Updating backend/postmaster
cvs server: Updating backend/regex
cvs server: Updating backend/rewrite
cvs server: Updating backend/storage
cvs server: Updating backend/storage/buffer
cvs server: Updating backend/storage/file
cvs server: Updating backend/storage/freespace
cvs server: Updating backend/storage/ipc
cvs server: Updating backend/storage/large_object
cvs server: Updating backend/storage/lmgr
cvs server: Updating backend/storage/page
cvs server: Updating backend/storage/smgr
cvs server: Updating backend/tcop
cvs server: Updating backend/tioga
cvs server: Updating backend/utils
cvs server: Updating backend/utils/adt
cvs server: Updating backend/utils/cache
cvs server: Updating backend/utils/error
cvs server: Updating backend/utils/fmgr
cvs server: Updating backend/utils/hash
cvs server: Updating backend/utils/init
cvs server: Updating backend/utils/mb
cvs server: Updating backend/utils/mb/Unicode
cvs server: Updating backend/utils/mb/conversion_procs
cvs server: Updating backend/utils/mb/conversion_procs/ascii_and_mic
cvs server: Updating backend/utils/mb/conversion_procs/cyrillic_and_mic
cvs server: Updating backend/utils/mb/conversion_procs/euc_cn_and_mic
cvs server: Updating backend/utils/mb/conversion_procs/euc_jp_and_sjis
cvs server: Updating backend/utils/mb/conversion_procs/euc_kr_and_mic
cvs server: Updating backend/utils/mb/conversion_procs/euc_tw_and_big5
cvs server: Updating backend/utils/mb/conversion_procs/latin2_and_win1250
cvs server: Updating backend/utils/mb/conversion_procs/latin_and_mic
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_ascii
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_big5
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_cyrillic
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_euc_cn
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_euc_jp
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_euc_kr
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_euc_tw
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_gb18030
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_gbk
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_iso8859
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_iso8859_1
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_johab
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_sjis
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_tcvn
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_uhc
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_win1250
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_win1256
cvs server: Updating backend/utils/mb/conversion_procs/utf8_and_win874
cvs server: Updating backend/utils/misc
cvs server: Updating backend/utils/mmgr
cvs server: Updating backend/utils/sort
cvs server: Updating backend/utils/time
cvs server: Updating bin
cvs server: Updating bin/cleardbdir
cvs server: Updating bin/createdb
cvs server: Updating bin/createlang
cvs server: Updating bin/createuser
cvs server: Updating bin/destroydb
cvs server: Updating bin/destroylang
cvs server: Updating bin/destroyuser
cvs server: Updating bin/initdb
cvs server: Updating bin/initlocation
cvs server: Updating bin/ipcclean
cvs server: Updating bin/monitor
cvs server: Updating bin/pg-config
cvs server: Updating bin/pg4_dump
cvs server: Updating bin/pg_config
cvs server: Updating bin/pg_controldata
cvs server: Updating bin/pg_controldata/po
cvs server: Updating bin/pg_ctl
cvs server: Updating bin/pg_dump
cvs server: Updating bin/pg_dump/po
cvs server: Updating bin/pg_encoding
cvs server: Updating bin/pg_id
cvs server: Updating bin/pg_passwd
cvs server: Updating bin/pg_resetxlog
cvs server: Updating bin/pg_resetxlog/po
cvs server: Updating bin/pg_version
cvs server: Updating bin/pgaccess
cvs server: Updating bin/pgaccess/demo
cvs server: Updating bin/pgaccess/doc
cvs server: Updating bin/pgaccess/doc/html
cvs server: Updating bin/pgaccess/doc/html/tutorial
cvs server: Updating bin/pgaccess/images
cvs server: Updating bin/pgaccess/lib
cvs server: Updating bin/pgaccess/lib/help
cvs server: Updating bin/pgaccess/lib/languages
cvs server: Updating bin/pgaccess/win32
cvs server: Updating bin/pgaccess/win32/dll
cvs server: Updating bin/pgtclsh
cvs server: Updating bin/psql
cvs server: Updating bin/psql/po
cvs server: Updating bin/scripts
cvs server: Updating bin/vacuumdb
cvs server: Updating corba
cvs server: Updating data
cvs server: Updating extend
cvs server: Updating extend/array
cvs server: Updating extend/datetime
cvs server: Updating extend/pginsert
cvs server: Updating extend/soundex
cvs server: Updating extend/string
cvs server: Updating include
cvs server: Updating include/access
cvs server: Updating include/bootstrap
cvs server: Updating include/catalog
cvs server: Updating include/commands
cvs server: Updating include/executor
cvs server: Updating include/lib
cvs server: Updating include/libpq
cvs server: Updating include/mb
cvs server: Updating include/nodes
cvs server: Updating include/optimizer
cvs server: Updating include/optimizer/_deadcode
cvs server: Updating include/parser
cvs server: Updating include/port
cvs server: Updating include/port/darwin
cvs server: Updating include/regex
cvs server: Updating include/rewrite
cvs server: Updating include/storage
cvs server: Updating include/tcop
cvs server: Updating include/utils
cvs server: Updating interfaces
cvs server: Updating interfaces/cli
cvs server: Updating interfaces/ecpg
cvs server: Updating interfaces/ecpg/doc
cvs server: Updating interfaces/ecpg/include
cvs server: Updating interfaces/ecpg/lib
cvs server: Updating interfaces/ecpg/preproc
cvs server: Updating interfaces/ecpg/src
cvs server: Updating interfaces/ecpg/src/include
cvs server: Updating interfaces/ecpg/src/lib
cvs server: Updating interfaces/ecpg/src/preproc
cvs server: Updating interfaces/ecpg/src/test
cvs server: Updating interfaces/ecpg/test
cvs server: Updating interfaces/jdbc
cvs server: Updating interfaces/jdbc/example
cvs server: Updating interfaces/jdbc/example/corba
cvs server: Updating interfaces/jdbc/org
cvs server: Updating interfaces/jdbc/org/postgresql
cvs server: Updating interfaces/jdbc/org/postgresql/core
cvs server: Updating interfaces/jdbc/org/postgresql/fastpath
cvs server: Updating interfaces/jdbc/org/postgresql/geometric
cvs server: Updating interfaces/jdbc/org/postgresql/jdbc1
cvs server: Updating interfaces/jdbc/org/postgresql/jdbc2
cvs server: Updating interfaces/jdbc/org/postgresql/jdbc2/optional
cvs server: Updating interfaces/jdbc/org/postgresql/jdbc3
cvs server: Updating interfaces/jdbc/org/postgresql/largeobject
cvs server: Updating interfaces/jdbc/org/postgresql/test
cvs server: Updating interfaces/jdbc/org/postgresql/test/jdbc2
cvs server: Updating interfaces/jdbc/org/postgresql/test/jdbc2/optional
cvs server: Updating interfaces/jdbc/org/postgresql/test/jdbc3
cvs server: Updating interfaces/jdbc/org/postgresql/test/util
cvs server: Updating interfaces/jdbc/org/postgresql/util
cvs server: Updating interfaces/jdbc/org/postgresql/xa
cvs server: Updating interfaces/jdbc/postgresql
cvs server: Updating interfaces/jdbc/postgresql/fastpath
cvs server: Updating interfaces/jdbc/postgresql/geometric
cvs server: Updating interfaces/jdbc/postgresql/jdbc1
cvs server: Updating interfaces/jdbc/postgresql/jdbc2
cvs server: Updating interfaces/jdbc/postgresql/largeobject
cvs server: Updating interfaces/jdbc/postgresql/util
cvs server: Updating interfaces/jdbc/utils
cvs server: Updating interfaces/libpgeasy
cvs server: Updating interfaces/libpgeasy/examples
cvs server: Updating interfaces/libpgtcl
cvs server: Updating interfaces/libpq
cvs server: Updating interfaces/libpq/po
cvs server: Updating interfaces/libpq++
cvs server: Updating interfaces/libpq++/examples
cvs server: Updating interfaces/libpq++/man
cvs server: Updating interfaces/odbc
cvs server: Updating interfaces/odbc/windev
cvs server: Updating interfaces/perl5
cvs server: Updating interfaces/perl5/eg
cvs server: Updating interfaces/perl5/examples
cvs server: Updating interfaces/pgeasy
cvs server: Updating interfaces/pgeasy/examples
cvs server: Updating interfaces/python
cvs server: Updating interfaces/python/tutorial
cvs server: Updating interfaces/ssl
cvs server: Updating lextest
cvs server: Updating makefiles
cvs server: Updating man
cvs server: Updating mk
cvs server: Updating mk/port
cvs server: Updating pl
cvs server: Updating pl/plperl
cvs server: Updating pl/plpgsql
cvs server: Updating pl/plpgsql/doc
cvs server: Updating pl/plpgsql/src
cvs server: Updating pl/plpgsql/test
cvs server: Updating pl/plpgsql/test/expected
cvs server: Updating pl/plpython
cvs server: Updating pl/tcl
cvs server: Updating pl/tcl/modules
cvs server: Updating pl/tcl/test
cvs server: Updating port
cvs server: Updating scripts
cvs server: Updating template
cvs server: Updating test
cvs server: Updating test/bench
cvs server: Updating test/examples
cvs server: Updating test/locale
cvs server: Updating test/locale/de_DE.ISO8859-1
cvs server: Updating test/locale/de_DE.ISO8859-1/expected
cvs server: Updating test/locale/gr_GR.ISO8859-7
cvs server: Updating test/locale/gr_GR.ISO8859-7/expected
cvs server: Updating test/locale/koi8-r
cvs server: Updating test/locale/koi8-r/expected
cvs server: Updating test/locale/koi8-to-win1251
cvs server: Updating test/locale/koi8-to-win1251/expected
cvs server: Updating test/mb
cvs server: Updating test/mb/expected
cvs server: Updating test/mb/sql
cvs server: Updating test/performance
cvs server: Updating test/performance/results
cvs server: Updating test/performance/sqls
cvs server: Updating test/regress
cvs server: Updating test/regress/data
cvs server: Updating test/regress/expected
cvs server: Updating test/regress/input
cvs server: Updating test/regress/output
cvs server: Updating test/regress/sql
cvs server: Updating test/suite
cvs server: Updating test/suite/results
cvs server: Updating tools
cvs server: Updating tools/backend
cvs server: Updating tools/entab
cvs server: Updating tools/make_diff
cvs server: Updating tools/mkldexport
cvs server: Updating tools/pginclude
cvs server: Updating tools/pgindent
cvs server: Updating tools/pgindent.dir
cvs server: Updating tutorial
cvs server: Updating tutorial/C-code
cvs server: Updating utils
cvs server: Updating win32

C:\Projects\pgsql\src>nmake -f win32.mak

Microsoft (R) Program Maintenance Utility Version 7.00.9466
Copyright (C) Microsoft Corporation. All rights reserved.

cd include
if not exist pg_config.h copy pg_config.h.win32 pg_config.h
1 file(s) copied.
cd ..
cd interfaces\libpq
nmake /f win32.mak

Microsoft (R) Program Maintenance Utility Version 7.00.9466
Copyright (C) Microsoft Corporation. All rights reserved.

Building the Win32 static library...

if not exist ".\Release/" mkdir ".\Release"
cl.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1C0.tmp
dllist.c
cl.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1C1.tmp
md5.c
cl.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1C2.tmp
wchar.c
cl.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1C3.tmp
encnames.c
cl.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1C4.tmp
win32.c
fe-auth.c
fe-connect.c
fe-exec.c
fe-lobj.c
fe-misc.c
fe-print.c
fe-secure.c
pqexpbuffer.c
link.exe -lib @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1C5.tmp
cl.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1C6.tmp
libpqdll.c
rc.exe /l 0x409 /fo".\Release\libpq.res" libpq.rc
link.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1C7.tmp
Creating library .\Release\libpqdll.lib and object .\Release\libpqdll.exp
cd ..\..\bin\psql
nmake /f win32.mak

Microsoft (R) Program Maintenance Utility Version 7.00.9466
Copyright (C) Microsoft Corporation. All rights reserved.

if not exist ".\Release/" mkdir ".\Release"
cl.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1CD.tmp
getopt.c
cl.exe @C:\DOCUME~1\Al\LOCALS~1\Temp\nm1CE.tmp
command.c
command.c(497) : warning C4244: 'function' : conversion from 'unsigned
short' to
'bool', possible loss of data
common.c
help.c
help.c(31) : fatal error C1083: Cannot open include file: 'sql_help.h': No
such
file or directory
input.c
stringutils.c
mainloop.c
copy.c
startup.c
prompt.c
sprompt.c
variables.c
large_obj.c
print.c
print.c(1009) : warning C4244: 'function' : conversion from 'const unsigned
shor
t' to 'bool', possible loss of data
describe.c
tab-complete.c
mbprint.c
NMAKE : fatal error U1077: 'cl.exe' : return code '0x2'
Stop.
NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual Studio
.NET\VC7\B
IN\nmake.exe"' : return code '0x2'
Stop.

C:\Projects\pgsql\src>

----- Original Message -----
From: "Joe Conway" <mail(at)joeconway(dot)com>
To: "Al Sutton" <al(at)alsutton(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Sent: Sunday, November 17, 2002 4:17 AM
Subject: Re: [HACKERS] Missing file from CVS?

> Al Sutton wrote:
> > All,
> >
> > I've just tried to build the Win32 components under Visual Studio's C++
> > compiler from the win32.mak CVS archive at
> > :pserver:anoncvs(at)anoncvs(dot)postgresql(dot)org:/projects/cvsroot and found that
the
> > following file was missing;
> >
> > src\bin\psql\sql_help.h
> >
> > I've copied the file from the the source tree of version 7.2.3 and the
> > compile works with out any problems.
> >
> > Should the file be in CVS?
> >
>
> I'm not seeing a problem here with cvs tip and VS .Net's C++, although I
am
> now getting a few pedantic warnings that I wasn't seeing a few weeks ago.
>
> Where exactly are you getting an error?
>
> Joe
>
> p.s. here's my output:
>
> C:\Documents and Settings\jconway\My Documents\Visual Studio
> Projects\pgsql\src>nmake -f win32.mak
>
> Microsoft (R) Program Maintenance Utility Version 7.00.9466
> Copyright (C) Microsoft Corporation. All rights reserved.
>
> cd include
> if not exist pg_config.h copy pg_config.h.win32 pg_config.h
> 1 file(s) copied.
> cd ..
> cd interfaces\libpq
> nmake /f win32.mak
>
> Microsoft (R) Program Maintenance Utility Version 7.00.9466
> Copyright (C) Microsoft Corporation. All rights reserved.
>
> Building the Win32 static library...
>
> if not exist ".\Release/" mkdir ".\Release"
> cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1A.tmp
> dllist.c
> cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1B.tmp
> md5.c
> cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1C.tmp
> wchar.c
> cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1D.tmp
> encnames.c
> cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1E.tmp
> win32.c
> fe-auth.c
> fe-connect.c
> fe-exec.c
> fe-lobj.c
> fe-misc.c
> fe-print.c
> fe-secure.c
> pqexpbuffer.c
> link.exe -lib @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm1F.tmp
> cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm20.tmp
> libpqdll.c
> rc.exe /l 0x409 /fo".\Release\libpq.res" libpq.rc
> link.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm21.tmp
> Creating library .\Release\libpqdll.lib and object
.\Release\libpqdll.exp
> cd ..\..\bin\psql
> nmake /f win32.mak
>
> Microsoft (R) Program Maintenance Utility Version 7.00.9466
> Copyright (C) Microsoft Corporation. All rights reserved.
>
> if not exist ".\Release/" mkdir ".\Release"
> cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm27.tmp
> getopt.c
> cl.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm28.tmp
> command.c
> command.c(497) : warning C4244: 'function' : conversion from 'unsigned
short'
> to 'bool', possible loss of data
> common.c
> help.c
> help.c(166) : warning C4244: 'function' : conversion from 'unsigned short'
to
> 'bool', possible loss of data
> input.c
> stringutils.c
> mainloop.c
> copy.c
> startup.c
> prompt.c
> sprompt.c
> variables.c
> large_obj.c
> print.c
> print.c(1009) : warning C4244: 'function' : conversion from 'const
unsigned
> short' to 'bool', possible loss of data
> describe.c
> tab-complete.c
> mbprint.c
> link.exe @C:\DOCUME~1\jconway\LOCALS~1\Temp\nm29.tmp
> cd ..\..
> echo All Win32 parts have been built!
> All Win32 parts have been built!
>
>
>