Re: Fix pg_dump dependency on postgres.h - Mailing list pgsql-patches

From Zdenek Kotala
Subject Re: Fix pg_dump dependency on postgres.h
Date
Msg-id 473B57C6.4070805@sun.com
Whole thread Raw
In response to Re: Fix pg_dump dependency on postgres.h  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Fix pg_dump dependency on postgres.h
Re: Fix pg_dump dependency on postgres.h
List pgsql-patches
Tom Lane wrote:

<snip>
>
> AFAICT, therefore, the proposed patch should only define YYSTYPE and
> not anything else (there's no need to be afraid of YYLTYPE at present).

Thank your for Your and Alvaro's comments. I attached updated patch
version only with YYSTYPE definition.

        Thanks Zdenek
diff -rc pgsql_sugar.orig/src/backend/catalog/heap.c pgsql_sugar/src/backend/catalog/heap.c
*** pgsql_sugar.orig/src/backend/catalog/heap.c    Mon Oct 29 20:40:39 2007
--- pgsql_sugar/src/backend/catalog/heap.c    Tue Nov  6 12:47:46 2007
***************
*** 45,50 ****
--- 45,51 ----
  #include "catalog/pg_statistic.h"
  #include "catalog/pg_tablespace.h"
  #include "catalog/pg_type.h"
+ #include "catalog/pg_type_fn.h"
  #include "commands/tablecmds.h"
  #include "commands/typecmds.h"
  #include "miscadmin.h"
diff -rc pgsql_sugar.orig/src/backend/catalog/pg_aggregate.c pgsql_sugar/src/backend/catalog/pg_aggregate.c
*** pgsql_sugar.orig/src/backend/catalog/pg_aggregate.c    Mon Sep  3 02:39:14 2007
--- pgsql_sugar/src/backend/catalog/pg_aggregate.c    Tue Nov  6 12:47:46 2007
***************
*** 21,26 ****
--- 21,27 ----
  #include "catalog/pg_language.h"
  #include "catalog/pg_operator.h"
  #include "catalog/pg_proc.h"
+ #include "catalog/pg_proc_fn.h"
  #include "catalog/pg_type.h"
  #include "miscadmin.h"
  #include "parser/parse_coerce.h"
diff -rc pgsql_sugar.orig/src/backend/catalog/pg_proc.c pgsql_sugar/src/backend/catalog/pg_proc.c
*** pgsql_sugar.orig/src/backend/catalog/pg_proc.c    Mon Sep  3 02:39:14 2007
--- pgsql_sugar/src/backend/catalog/pg_proc.c    Tue Nov  6 12:47:46 2007
***************
*** 21,26 ****
--- 21,27 ----
  #include "catalog/pg_language.h"
  #include "catalog/pg_namespace.h"
  #include "catalog/pg_proc.h"
+ #include "catalog/pg_proc_fn.h"
  #include "catalog/pg_type.h"
  #include "executor/functions.h"
  #include "funcapi.h"
diff -rc pgsql_sugar.orig/src/backend/catalog/pg_type.c pgsql_sugar/src/backend/catalog/pg_type.c
*** pgsql_sugar.orig/src/backend/catalog/pg_type.c    Sat May 12 02:54:59 2007
--- pgsql_sugar/src/backend/catalog/pg_type.c    Tue Nov  6 12:47:46 2007
***************
*** 21,26 ****
--- 21,27 ----
  #include "catalog/pg_namespace.h"
  #include "catalog/pg_proc.h"
  #include "catalog/pg_type.h"
+ #include "catalog/pg_type_fn.h"
  #include "commands/typecmds.h"
  #include "miscadmin.h"
  #include "parser/scansup.h"
diff -rc pgsql_sugar.orig/src/backend/commands/functioncmds.c pgsql_sugar/src/backend/commands/functioncmds.c
*** pgsql_sugar.orig/src/backend/commands/functioncmds.c    Mon Sep  3 20:46:29 2007
--- pgsql_sugar/src/backend/commands/functioncmds.c    Tue Nov  6 12:47:46 2007
***************
*** 41,47 ****
--- 41,49 ----
  #include "catalog/pg_language.h"
  #include "catalog/pg_namespace.h"
  #include "catalog/pg_proc.h"
+ #include "catalog/pg_proc_fn.h"
  #include "catalog/pg_type.h"
+ #include "catalog/pg_type_fn.h"
  #include "commands/defrem.h"
  #include "commands/proclang.h"
  #include "miscadmin.h"
diff -rc pgsql_sugar.orig/src/backend/commands/proclang.c pgsql_sugar/src/backend/commands/proclang.c
*** pgsql_sugar.orig/src/backend/commands/proclang.c    Mon Sep  3 02:39:15 2007
--- pgsql_sugar/src/backend/commands/proclang.c    Tue Nov  6 12:47:46 2007
***************
*** 22,27 ****
--- 22,28 ----
  #include "catalog/pg_namespace.h"
  #include "catalog/pg_pltemplate.h"
  #include "catalog/pg_proc.h"
+ #include "catalog/pg_proc_fn.h"
  #include "catalog/pg_type.h"
  #include "commands/dbcommands.h"
  #include "commands/defrem.h"
diff -rc pgsql_sugar.orig/src/backend/commands/tablecmds.c pgsql_sugar/src/backend/commands/tablecmds.c
*** pgsql_sugar.orig/src/backend/commands/tablecmds.c    Fri Oct 12 20:55:12 2007
--- pgsql_sugar/src/backend/commands/tablecmds.c    Tue Nov  6 12:47:46 2007
***************
*** 32,37 ****
--- 32,38 ----
  #include "catalog/pg_tablespace.h"
  #include "catalog/pg_trigger.h"
  #include "catalog/pg_type.h"
+ #include "catalog/pg_type_fn.h"
  #include "catalog/toasting.h"
  #include "commands/cluster.h"
  #include "commands/defrem.h"
diff -rc pgsql_sugar.orig/src/backend/commands/typecmds.c pgsql_sugar/src/backend/commands/typecmds.c
*** pgsql_sugar.orig/src/backend/commands/typecmds.c    Mon Oct 29 20:40:39 2007
--- pgsql_sugar/src/backend/commands/typecmds.c    Tue Nov  6 12:47:46 2007
***************
*** 43,48 ****
--- 43,49 ----
  #include "catalog/pg_enum.h"
  #include "catalog/pg_namespace.h"
  #include "catalog/pg_type.h"
+ #include "catalog/pg_type_fn.h"
  #include "commands/defrem.h"
  #include "commands/tablecmds.h"
  #include "commands/typecmds.h"
diff -rc pgsql_sugar.orig/src/backend/parser/keywords.c pgsql_sugar/src/backend/parser/keywords.c
*** pgsql_sugar.orig/src/backend/parser/keywords.c    Mon Sep 24 03:29:29 2007
--- pgsql_sugar/src/backend/parser/keywords.c    Wed Nov 14 20:20:44 2007
***************
*** 12,23 ****
   *
   *-------------------------------------------------------------------------
   */
! #include "postgres.h"

  #include <ctype.h>

! #include "nodes/parsenodes.h"
! #include "parser/gramparse.h"    /* required before parser/parse.h! */
  #include "parser/keywords.h"
  #include "parser/parse.h"

--- 12,29 ----
   *
   *-------------------------------------------------------------------------
   */
! #include "c.h"

  #include <ctype.h>

! /* Following macro disables YYSTYPE union definition
!  * in parse.h which is unnecessary for this source and
!  * it cause useless dependency on another headers. It
!  * is very important for pg_dump which also share this
!  * piece of code and it cannot include postgres.h
!  */
! #define YYSTYPE int
!
  #include "parser/keywords.h"
  #include "parser/parse.h"

diff -rc pgsql_sugar.orig/src/backend/utils/hash/pg_crc.c pgsql_sugar/src/backend/utils/hash/pg_crc.c
*** pgsql_sugar.orig/src/backend/utils/hash/pg_crc.c    Fri Jan  5 23:19:43 2007
--- pgsql_sugar/src/backend/utils/hash/pg_crc.c    Wed Nov 14 14:24:06 2007
***************
*** 23,29 ****
   *
   *-------------------------------------------------------------------------
   */
! #include "postgres.h"



--- 23,29 ----
   *
   *-------------------------------------------------------------------------
   */
! #include "c.h"



diff -rc pgsql_sugar.orig/src/bin/pg_config/pg_config.c pgsql_sugar/src/bin/pg_config/pg_config.c
*** pgsql_sugar.orig/src/bin/pg_config/pg_config.c    Thu May 31 17:13:04 2007
--- pgsql_sugar/src/bin/pg_config/pg_config.c    Wed Nov 14 12:41:34 2007
***************
*** 22,28 ****
   *-------------------------------------------------------------------------
   */

! #include "postgres.h"

  #include "port.h"

--- 22,28 ----
   *-------------------------------------------------------------------------
   */

! #include "postgres_fe.h"

  #include "port.h"

diff -rc pgsql_sugar.orig/src/bin/pg_controldata/pg_controldata.c pgsql_sugar/src/bin/pg_controldata/pg_controldata.c
*** pgsql_sugar.orig/src/bin/pg_controldata/pg_controldata.c    Tue Apr  3 06:14:26 2007
--- pgsql_sugar/src/bin/pg_controldata/pg_controldata.c    Wed Nov 14 12:42:14 2007
***************
*** 8,14 ****
   *
   * $PostgreSQL: pgsql/src/bin/pg_controldata/pg_controldata.c,v 1.34 2007/03/18 16:50:43 neilc Exp $
   */
! #include "postgres.h"

  #include <unistd.h>
  #include <time.h>
--- 8,14 ----
   *
   * $PostgreSQL: pgsql/src/bin/pg_controldata/pg_controldata.c,v 1.34 2007/03/18 16:50:43 neilc Exp $
   */
! #include "postgres_fe.h"

  #include <unistd.h>
  #include <time.h>
diff -rc pgsql_sugar.orig/src/bin/pg_dump/common.c pgsql_sugar/src/bin/pg_dump/common.c
*** pgsql_sugar.orig/src/bin/pg_dump/common.c    Sun Oct 28 20:08:02 2007
--- pgsql_sugar/src/bin/pg_dump/common.c    Wed Nov 14 12:43:03 2007
***************
*** 19,25 ****
  #include "postgres_fe.h"
  #include "pg_backup_archiver.h"

- #include "postgres.h"
  #include "catalog/pg_class.h"

  #include <ctype.h>
--- 19,24 ----
diff -rc pgsql_sugar.orig/src/bin/pg_dump/pg_dump.c pgsql_sugar/src/bin/pg_dump/pg_dump.c
*** pgsql_sugar.orig/src/bin/pg_dump/pg_dump.c    Sat Oct 13 22:18:41 2007
--- pgsql_sugar/src/bin/pg_dump/pg_dump.c    Wed Nov 14 14:53:39 2007
***************
*** 17,28 ****
   *-------------------------------------------------------------------------
   */

! /*
!  * Although this is not a backend module, we must include postgres.h anyway
!  * so that we can include a bunch of backend include files.  pg_dump has
!  * never pretended to be very independent of the backend anyhow ...
!  */
! #include "postgres.h"

  #include <unistd.h>

--- 17,23 ----
   *-------------------------------------------------------------------------
   */

! #include "postgres_fe.h"

  #include <unistd.h>

***************
*** 41,51 ****
  #endif

  #include "access/htup.h"
  #include "catalog/pg_class.h"
  #include "catalog/pg_proc.h"
  #include "catalog/pg_trigger.h"
  #include "catalog/pg_type.h"
- #include "commands/sequence.h"
  #include "libpq/libpq-fs.h"

  #include "pg_backup_archiver.h"
--- 36,46 ----
  #endif

  #include "access/htup.h"
+ #include "access/attnum.h"
  #include "catalog/pg_class.h"
  #include "catalog/pg_proc.h"
  #include "catalog/pg_trigger.h"
  #include "catalog/pg_type.h"
  #include "libpq/libpq-fs.h"

  #include "pg_backup_archiver.h"
diff -rc pgsql_sugar.orig/src/bin/psql/print.c pgsql_sugar/src/bin/psql/print.c
*** pgsql_sugar.orig/src/bin/psql/print.c    Fri Jan  5 23:19:49 2007
--- pgsql_sugar/src/bin/psql/print.c    Wed Nov 14 12:44:02 2007
***************
*** 8,14 ****
   * Note: we include postgres.h not postgres_fe.h so that we can include
   * catalog/pg_type.h, and thereby have access to INT4OID and similar macros.
   */
! #include "postgres.h"
  #include "print.h"
  #include "catalog/pg_type.h"

--- 8,14 ----
   * Note: we include postgres.h not postgres_fe.h so that we can include
   * catalog/pg_type.h, and thereby have access to INT4OID and similar macros.
   */
! #include "postgres_fe.h"
  #include "print.h"
  #include "catalog/pg_type.h"

diff -rc pgsql_sugar.orig/src/include/pg_config_manual.h pgsql_sugar/src/include/pg_config_manual.h
*** pgsql_sugar.orig/src/include/pg_config_manual.h    Fri Jun  8 20:23:53 2007
--- pgsql_sugar/src/include/pg_config_manual.h    Tue Nov  6 12:47:46 2007
***************
*** 197,203 ****
--- 197,214 ----
   */
  #define MAX_RANDOM_VALUE  (0x7FFFFFFF)

+ /*
+  * Set the upper and lower bounds of a sequence
+  */
+ #ifndef INT64_IS_BUSTED
+ #define SEQ_MAXVALUE    INT64CONST(0x7FFFFFFFFFFFFFFF)
+ #else                                                   /* INT64_IS_BUSTED */
+ #define SEQ_MAXVALUE    ((int64) 0x7FFFFFFF)
+ #endif   /* INT64_IS_BUSTED */

+ #define SEQ_MINVALUE    (-SEQ_MAXVALUE)
+
+
  /*
   *------------------------------------------------------------------------
   * The following symbols are for enabling debugging code, not for
diff -rc pgsql_sugar.orig/src/include/postgres.h pgsql_sugar/src/include/postgres.h
*** pgsql_sugar.orig/src/include/postgres.h    Mon Oct  1 18:25:56 2007
--- pgsql_sugar/src/include/postgres.h    Tue Nov  6 12:51:45 2007
***************
*** 26,32 ****
   *        1)        variable-length datatypes (TOAST support)
   *        2)        datum type + support macros
   *        3)        exception handling definitions
-  *        4)        genbki macros used by catalog/pg_xxx.h files
   *
   *     NOTES
   *
--- 26,31 ----
***************
*** 710,730 ****
                                  const char *errorType,
                                  const char *fileName, int lineNumber);

- /* ----------------------------------------------------------------
-  *                Section 4: genbki macros used by catalog/pg_xxx.h files
-  * ----------------------------------------------------------------
-  */
- #define CATALOG(name,oid)    typedef struct CppConcat(FormData_,name)
-
- #define BKI_BOOTSTRAP
- #define BKI_SHARED_RELATION
- #define BKI_WITHOUT_OIDS
-
- /* these need to expand into some harmless, repeatable declaration */
- #define DATA(x)   extern int no_such_variable
- #define DESCR(x)  extern int no_such_variable
- #define SHDESCR(x) extern int no_such_variable
-
- typedef int4 aclitem;            /* PHONY definition for catalog use only */
-
  #endif   /* POSTGRES_H */
--- 709,712 ----
diff -rc pgsql_sugar.orig/src/include/catalog/genbki.h pgsql_sugar/src/include/catalog/genbki.h
*** pgsql_sugar.orig/src/include/catalog/genbki.h    Tue Nov  6 12:50:26 2007
--- pgsql_sugar/src/include/catalog/genbki.h    Tue Nov  6 13:19:36 2007
***************
*** 0 ****
--- 1,35 ----
+ /*-------------------------------------------------------------------------
+  *
+  * genbki.h
+  *      Primary include file for all catalog header files
+  *
+  * genbki.h contains the CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so
+  * this file can be read by both genbki.sh and the C compiler.
+  *
+  *
+  * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
+  * Portions Copyright (c) 1995, Regents of the University of California
+  *
+  * $PostgreSQL:  $
+  *
+  *-------------------------------------------------------------------------
+  */
+ #ifndef GENBKI_H
+ #define GENBKI_H
+
+ #include "c.h"
+
+ #define CATALOG(name,oid)    typedef struct CppConcat(FormData_,name)
+
+ #define BKI_BOOTSTRAP
+ #define BKI_SHARED_RELATION
+ #define BKI_WITHOUT_OIDS
+
+ /* these need to expand into some harmless, repeatable declaration */
+ #define DATA(x)   extern int no_such_variable
+ #define DESCR(x)  extern int no_such_variable
+ #define SHDESCR(x) extern int no_such_variable
+
+ typedef int4 aclitem;            /* PHONY definition for catalog use only */
+
+ #endif   /* GENBKI_H */
diff -rc pgsql_sugar.orig/src/include/catalog/pg_aggregate.h pgsql_sugar/src/include/catalog/pg_aggregate.h
*** pgsql_sugar.orig/src/include/catalog/pg_aggregate.h    Wed Oct 24 04:24:47 2007
--- pgsql_sugar/src/include/catalog/pg_aggregate.h    Tue Nov  6 12:47:46 2007
***************
*** 19,24 ****
--- 19,25 ----
  #ifndef PG_AGGREGATE_H
  #define PG_AGGREGATE_H

+ #include "catalog/genbki.h"
  #include "nodes/pg_list.h"

  /* ----------------
diff -rc pgsql_sugar.orig/src/include/catalog/pg_am.h pgsql_sugar/src/include/catalog/pg_am.h
*** pgsql_sugar.orig/src/include/catalog/pg_am.h    Sat Apr  7 00:33:43 2007
--- pgsql_sugar/src/include/catalog/pg_am.h    Tue Nov  6 12:47:46 2007
***************
*** 22,33 ****
  #ifndef PG_AM_H
  #define PG_AM_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_am definition.  cpp turns this into
--- 22,28 ----
  #ifndef PG_AM_H
  #define PG_AM_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_am definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_amop.h pgsql_sugar/src/include/catalog/pg_amop.h
*** pgsql_sugar.orig/src/include/catalog/pg_amop.h    Tue Aug 21 03:11:25 2007
--- pgsql_sugar/src/include/catalog/pg_amop.h    Tue Nov  6 12:47:46 2007
***************
*** 40,51 ****
  #ifndef PG_AMOP_H
  #define PG_AMOP_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_amop definition.  cpp turns this into
--- 40,46 ----
  #ifndef PG_AMOP_H
  #define PG_AMOP_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_amop definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_amproc.h pgsql_sugar/src/include/catalog/pg_amproc.h
*** pgsql_sugar.orig/src/include/catalog/pg_amproc.h    Mon Sep  3 03:18:33 2007
--- pgsql_sugar/src/include/catalog/pg_amproc.h    Tue Nov  6 12:47:46 2007
***************
*** 33,44 ****
  #ifndef PG_AMPROC_H
  #define PG_AMPROC_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_amproc definition.  cpp turns this into
--- 33,39 ----
  #ifndef PG_AMPROC_H
  #define PG_AMPROC_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_amproc definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_attrdef.h pgsql_sugar/src/include/catalog/pg_attrdef.h
*** pgsql_sugar.orig/src/include/catalog/pg_attrdef.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_attrdef.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_ATTRDEF_H
  #define PG_ATTRDEF_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_attrdef definition.    cpp turns this into
--- 19,25 ----
  #ifndef PG_ATTRDEF_H
  #define PG_ATTRDEF_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_attrdef definition.    cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_attribute.h pgsql_sugar/src/include/catalog/pg_attribute.h
*** pgsql_sugar.orig/src/include/catalog/pg_attribute.h    Thu Sep 20 19:56:32 2007
--- pgsql_sugar/src/include/catalog/pg_attribute.h    Tue Nov  6 12:47:46 2007
***************
*** 24,35 ****
  #ifndef PG_ATTRIBUTE_H
  #define PG_ATTRIBUTE_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_attribute definition.  cpp turns this into
--- 24,30 ----
  #ifndef PG_ATTRIBUTE_H
  #define PG_ATTRIBUTE_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_attribute definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_auth_members.h pgsql_sugar/src/include/catalog/pg_auth_members.h
*** pgsql_sugar.orig/src/include/catalog/pg_auth_members.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_auth_members.h    Wed Nov 14 14:41:07 2007
***************
*** 19,24 ****
--- 19,26 ----
  #ifndef PG_AUTH_MEMBERS_H
  #define PG_AUTH_MEMBERS_H

+ #include "catalog/genbki.h"
+
  /* ----------------
   *        pg_auth_members definition.  cpp turns this into
   *        typedef struct FormData_pg_auth_members
diff -rc pgsql_sugar.orig/src/include/catalog/pg_authid.h pgsql_sugar/src/include/catalog/pg_authid.h
*** pgsql_sugar.orig/src/include/catalog/pg_authid.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_authid.h    Tue Nov  6 12:47:46 2007
***************
*** 21,26 ****
--- 21,28 ----
  #ifndef PG_AUTHID_H
  #define PG_AUTHID_H

+ #include "catalog/genbki.h"
+
  /*
   * The CATALOG definition has to refer to the type of rolvaliduntil as
   * "timestamptz" (lower case) so that bootstrap mode recognizes it.  But
diff -rc pgsql_sugar.orig/src/include/catalog/pg_autovacuum.h pgsql_sugar/src/include/catalog/pg_autovacuum.h
*** pgsql_sugar.orig/src/include/catalog/pg_autovacuum.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_autovacuum.h    Tue Nov  6 12:47:46 2007
***************
*** 13,24 ****
  #ifndef PG_AUTOVACUUM_H
  #define PG_AUTOVACUUM_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_autovacuum definition.    cpp turns this into
--- 13,19 ----
  #ifndef PG_AUTOVACUUM_H
  #define PG_AUTOVACUUM_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_autovacuum definition.    cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_cast.h pgsql_sugar/src/include/catalog/pg_cast.h
*** pgsql_sugar.orig/src/include/catalog/pg_cast.h    Tue Aug 21 03:11:25 2007
--- pgsql_sugar/src/include/catalog/pg_cast.h    Tue Nov  6 12:47:46 2007
***************
*** 21,26 ****
--- 21,28 ----
  #ifndef PG_CAST_H
  #define PG_CAST_H

+ #include "catalog/genbki.h"
+
  #define CastRelationId    2605

  CATALOG(pg_cast,2605)
diff -rc pgsql_sugar.orig/src/include/catalog/pg_class.h pgsql_sugar/src/include/catalog/pg_class.h
*** pgsql_sugar.orig/src/include/catalog/pg_class.h    Mon Sep  3 02:39:21 2007
--- pgsql_sugar/src/include/catalog/pg_class.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_CLASS_H
  #define PG_CLASS_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_class definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_CLASS_H
  #define PG_CLASS_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_class definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_constraint.h pgsql_sugar/src/include/catalog/pg_constraint.h
*** pgsql_sugar.orig/src/include/catalog/pg_constraint.h    Wed Feb 14 02:58:58 2007
--- pgsql_sugar/src/include/catalog/pg_constraint.h    Tue Nov  6 12:47:46 2007
***************
*** 19,34 ****
  #ifndef PG_CONSTRAINT_H
  #define PG_CONSTRAINT_H

  #include "nodes/pg_list.h"

  /* ----------------
-  *        postgres.h contains the system type definitions and the
-  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
-  *        can be read by both genbki.sh and the C compiler.
-  * ----------------
-  */
-
- /* ----------------
   *        pg_constraint definition.  cpp turns this into
   *        typedef struct FormData_pg_constraint
   * ----------------
--- 19,28 ----
  #ifndef PG_CONSTRAINT_H
  #define PG_CONSTRAINT_H

+ #include "catalog/genbki.h"
  #include "nodes/pg_list.h"

  /* ----------------
   *        pg_constraint definition.  cpp turns this into
   *        typedef struct FormData_pg_constraint
   * ----------------
diff -rc pgsql_sugar.orig/src/include/catalog/pg_conversion.h pgsql_sugar/src/include/catalog/pg_conversion.h
*** pgsql_sugar.orig/src/include/catalog/pg_conversion.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_conversion.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_CONVERSION_H
  #define PG_CONVERSION_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------------------------------------------------------
   *        pg_conversion definition.
--- 19,25 ----
  #ifndef PG_CONVERSION_H
  #define PG_CONVERSION_H

! #include "catalog/genbki.h"

  /* ----------------------------------------------------------------
   *        pg_conversion definition.
diff -rc pgsql_sugar.orig/src/include/catalog/pg_database.h pgsql_sugar/src/include/catalog/pg_database.h
*** pgsql_sugar.orig/src/include/catalog/pg_database.h    Mon Sep  3 04:30:43 2007
--- pgsql_sugar/src/include/catalog/pg_database.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_DATABASE_H
  #define PG_DATABASE_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_database definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_DATABASE_H
  #define PG_DATABASE_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_database definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_depend.h pgsql_sugar/src/include/catalog/pg_depend.h
*** pgsql_sugar.orig/src/include/catalog/pg_depend.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_depend.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_DEPEND_H
  #define PG_DEPEND_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_depend definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_DEPEND_H
  #define PG_DEPEND_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_depend definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_description.h pgsql_sugar/src/include/catalog/pg_description.h
*** pgsql_sugar.orig/src/include/catalog/pg_description.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_description.h    Tue Nov  6 12:47:46 2007
***************
*** 36,47 ****
  #ifndef PG_DESCRIPTION_H
  #define PG_DESCRIPTION_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_description definition.    cpp turns this into
--- 36,42 ----
  #ifndef PG_DESCRIPTION_H
  #define PG_DESCRIPTION_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_description definition.    cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_enum.h pgsql_sugar/src/include/catalog/pg_enum.h
*** pgsql_sugar.orig/src/include/catalog/pg_enum.h    Mon Apr  2 05:49:40 2007
--- pgsql_sugar/src/include/catalog/pg_enum.h    Tue Nov  6 12:47:46 2007
***************
*** 21,36 ****
  #ifndef PG_ENUM_H
  #define PG_ENUM_H

  #include "nodes/pg_list.h"

  /* ----------------
-  *        postgres.h contains the system type definitions and the
-  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
-  *        can be read by both genbki.sh and the C compiler.
-  * ----------------
-  */
-
- /* ----------------
   *        pg_enum definition.  cpp turns this into
   *        typedef struct FormData_pg_enum
   * ----------------
--- 21,30 ----
  #ifndef PG_ENUM_H
  #define PG_ENUM_H

+ #include "catalog/genbki.h"
  #include "nodes/pg_list.h"

  /* ----------------
   *        pg_enum definition.  cpp turns this into
   *        typedef struct FormData_pg_enum
   * ----------------
diff -rc pgsql_sugar.orig/src/include/catalog/pg_index.h pgsql_sugar/src/include/catalog/pg_index.h
*** pgsql_sugar.orig/src/include/catalog/pg_index.h    Thu Sep 20 19:56:32 2007
--- pgsql_sugar/src/include/catalog/pg_index.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_INDEX_H
  #define PG_INDEX_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_index definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_INDEX_H
  #define PG_INDEX_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_index definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_inherits.h pgsql_sugar/src/include/catalog/pg_inherits.h
*** pgsql_sugar.orig/src/include/catalog/pg_inherits.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_inherits.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_INHERITS_H
  #define PG_INHERITS_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_inherits definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_INHERITS_H
  #define PG_INHERITS_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_inherits definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_language.h pgsql_sugar/src/include/catalog/pg_language.h
*** pgsql_sugar.orig/src/include/catalog/pg_language.h    Mon Sep  3 04:30:43 2007
--- pgsql_sugar/src/include/catalog/pg_language.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_LANGUAGE_H
  #define PG_LANGUAGE_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_language definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_LANGUAGE_H
  #define PG_LANGUAGE_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_language definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_largeobject.h pgsql_sugar/src/include/catalog/pg_largeobject.h
*** pgsql_sugar.orig/src/include/catalog/pg_largeobject.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_largeobject.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_LARGEOBJECT_H
  #define PG_LARGEOBJECT_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_largeobject definition.    cpp turns this into
--- 19,25 ----
  #ifndef PG_LARGEOBJECT_H
  #define PG_LARGEOBJECT_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_largeobject definition.    cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_listener.h pgsql_sugar/src/include/catalog/pg_listener.h
*** pgsql_sugar.orig/src/include/catalog/pg_listener.h    Fri Jan  5 23:19:52 2007
--- pgsql_sugar/src/include/catalog/pg_listener.h    Tue Nov  6 12:47:46 2007
***************
*** 18,29 ****
  #ifndef PG_LISTENER_H
  #define PG_LISTENER_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------------------------------------------------------
   *        pg_listener definition.
--- 18,24 ----
  #ifndef PG_LISTENER_H
  #define PG_LISTENER_H

! #include "catalog/genbki.h"

  /* ----------------------------------------------------------------
   *        pg_listener definition.
diff -rc pgsql_sugar.orig/src/include/catalog/pg_namespace.h pgsql_sugar/src/include/catalog/pg_namespace.h
*** pgsql_sugar.orig/src/include/catalog/pg_namespace.h    Mon Sep  3 04:30:43 2007
--- pgsql_sugar/src/include/catalog/pg_namespace.h    Tue Nov  6 12:47:46 2007
***************
*** 19,30 ****
  #ifndef PG_NAMESPACE_H
  #define PG_NAMESPACE_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------------------------------------------------------
   *        pg_namespace definition.
--- 19,25 ----
  #ifndef PG_NAMESPACE_H
  #define PG_NAMESPACE_H

! #include "catalog/genbki.h"

  /* ----------------------------------------------------------------
   *        pg_namespace definition.
diff -rc pgsql_sugar.orig/src/include/catalog/pg_opclass.h pgsql_sugar/src/include/catalog/pg_opclass.h
*** pgsql_sugar.orig/src/include/catalog/pg_opclass.h    Tue Aug 21 03:11:25 2007
--- pgsql_sugar/src/include/catalog/pg_opclass.h    Tue Nov  6 12:47:46 2007
***************
*** 39,50 ****
  #ifndef PG_OPCLASS_H
  #define PG_OPCLASS_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_opclass definition.    cpp turns this into
--- 39,45 ----
  #ifndef PG_OPCLASS_H
  #define PG_OPCLASS_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_opclass definition.    cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_operator.h pgsql_sugar/src/include/catalog/pg_operator.h
*** pgsql_sugar.orig/src/include/catalog/pg_operator.h    Mon Aug 27 03:39:24 2007
--- pgsql_sugar/src/include/catalog/pg_operator.h    Tue Nov  6 12:47:47 2007
***************
*** 22,37 ****
  #ifndef PG_OPERATOR_H
  #define PG_OPERATOR_H

  #include "nodes/pg_list.h"

  /* ----------------
-  *        postgres.h contains the system type definitions and the
-  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
-  *        can be read by both genbki.sh and the C compiler.
-  * ----------------
-  */
-
- /* ----------------
   *        pg_operator definition.  cpp turns this into
   *        typedef struct FormData_pg_operator
   * ----------------
--- 22,31 ----
  #ifndef PG_OPERATOR_H
  #define PG_OPERATOR_H

+ #include "catalog/genbki.h"
  #include "nodes/pg_list.h"

  /* ----------------
   *        pg_operator definition.  cpp turns this into
   *        typedef struct FormData_pg_operator
   * ----------------
diff -rc pgsql_sugar.orig/src/include/catalog/pg_opfamily.h pgsql_sugar/src/include/catalog/pg_opfamily.h
*** pgsql_sugar.orig/src/include/catalog/pg_opfamily.h    Tue Aug 21 03:11:25 2007
--- pgsql_sugar/src/include/catalog/pg_opfamily.h    Tue Nov  6 12:47:47 2007
***************
*** 19,32 ****
  #ifndef PG_OPFAMILY_H
  #define PG_OPFAMILY_H

  /* ----------------
-  *        postgres.h contains the system type definitions and the
-  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
-  *        can be read by both genbki.sh and the C compiler.
-  * ----------------
-  */
-
- /* ----------------
   *        pg_opfamily definition. cpp turns this into
   *        typedef struct FormData_pg_opfamily
   * ----------------
--- 19,26 ----
  #ifndef PG_OPFAMILY_H
  #define PG_OPFAMILY_H

+ #include "catalog/genbki.h"
  /* ----------------
   *        pg_opfamily definition. cpp turns this into
   *        typedef struct FormData_pg_opfamily
   * ----------------
diff -rc pgsql_sugar.orig/src/include/catalog/pg_pltemplate.h pgsql_sugar/src/include/catalog/pg_pltemplate.h
*** pgsql_sugar.orig/src/include/catalog/pg_pltemplate.h    Mon Mar 26 18:58:41 2007
--- pgsql_sugar/src/include/catalog/pg_pltemplate.h    Tue Nov  6 12:47:47 2007
***************
*** 19,30 ****
  #ifndef PG_PLTEMPLATE_H
  #define PG_PLTEMPLATE_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_pltemplate definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_PLTEMPLATE_H
  #define PG_PLTEMPLATE_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_pltemplate definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_proc.h pgsql_sugar/src/include/catalog/pg_proc.h
*** pgsql_sugar.orig/src/include/catalog/pg_proc.h    Wed Oct 24 04:24:47 2007
--- pgsql_sugar/src/include/catalog/pg_proc.h    Tue Nov  6 12:47:47 2007
***************
*** 23,36 ****
  #ifndef PG_PROC_H
  #define PG_PROC_H

  /* ----------------
-  *        postgres.h contains the system type definitions and the
-  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
-  *        can be read by both genbki.sh and the C compiler.
-  * ----------------
-  */
-
- /* ----------------
   *        pg_proc definition.  cpp turns this into
   *        typedef struct FormData_pg_proc
   * ----------------
--- 23,30 ----
  #ifndef PG_PROC_H
  #define PG_PROC_H

+ #include "catalog/genbki.h"
  /* ----------------
   *        pg_proc definition.  cpp turns this into
   *        typedef struct FormData_pg_proc
   * ----------------
***************
*** 4436,4465 ****
  #define PROARGMODE_INOUT    'b'


- /*
-  * prototypes for functions in pg_proc.c
-  */
- extern Oid ProcedureCreate(const char *procedureName,
-                 Oid procNamespace,
-                 bool replace,
-                 bool returnsSet,
-                 Oid returnType,
-                 Oid languageObjectId,
-                 Oid languageValidator,
-                 const char *prosrc,
-                 const char *probin,
-                 bool isAgg,
-                 bool security_definer,
-                 bool isStrict,
-                 char volatility,
-                 oidvector *parameterTypes,
-                 Datum allParameterTypes,
-                 Datum parameterModes,
-                 Datum parameterNames,
-                 Datum proconfig,
-                 float4 procost,
-                 float4 prorows);
-
- extern bool function_parse_error_transpose(const char *prosrc);
-
  #endif   /* PG_PROC_H */
--- 4430,4433 ----
diff -rc pgsql_sugar.orig/src/include/catalog/pg_proc_fn.h pgsql_sugar/src/include/catalog/pg_proc_fn.h
*** pgsql_sugar.orig/src/include/catalog/pg_proc_fn.h    Tue Nov  6 12:50:37 2007
--- pgsql_sugar/src/include/catalog/pg_proc_fn.h    Tue Nov  6 13:29:18 2007
***************
*** 0 ****
--- 1,40 ----
+ /*-------------------------------------------------------------------------
+  *
+  * pg_proc_fn.h
+  *      prototypes for functions in pg_proc.c
+  *
+  * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
+  * Portions Copyright (c) 1994, Regents of the University of California
+  *
+  * $PostgreSQL:  $
+  *
+  *
+  *-------------------------------------------------------------------------
+  */
+ #ifndef PG_PROC_FN_H
+ #define PG_PROC_FN_H
+
+ extern Oid ProcedureCreate(const char *procedureName,
+                 Oid procNamespace,
+                 bool replace,
+                 bool returnsSet,
+                 Oid returnType,
+                 Oid languageObjectId,
+                 Oid languageValidator,
+                 const char *prosrc,
+                 const char *probin,
+                 bool isAgg,
+                 bool security_definer,
+                 bool isStrict,
+                 char volatility,
+                 oidvector *parameterTypes,
+                 Datum allParameterTypes,
+                 Datum parameterModes,
+                 Datum parameterNames,
+                 Datum proconfig,
+                 float4 procost,
+                 float4 prorows);
+
+ extern bool function_parse_error_transpose(const char *prosrc);
+
+ #endif   /* PG_PROC_FN_H */
diff -rc pgsql_sugar.orig/src/include/catalog/pg_rewrite.h pgsql_sugar/src/include/catalog/pg_rewrite.h
*** pgsql_sugar.orig/src/include/catalog/pg_rewrite.h    Tue Mar 20 00:38:31 2007
--- pgsql_sugar/src/include/catalog/pg_rewrite.h    Tue Nov  6 12:47:47 2007
***************
*** 22,33 ****
  #ifndef PG_REWRITE_H
  #define PG_REWRITE_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_rewrite definition.    cpp turns this into
--- 22,28 ----
  #ifndef PG_REWRITE_H
  #define PG_REWRITE_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_rewrite definition.    cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_shdepend.h pgsql_sugar/src/include/catalog/pg_shdepend.h
*** pgsql_sugar.orig/src/include/catalog/pg_shdepend.h    Fri Jan  5 23:19:53 2007
--- pgsql_sugar/src/include/catalog/pg_shdepend.h    Tue Nov  6 12:47:47 2007
***************
*** 19,30 ****
  #ifndef PG_SHDEPEND_H
  #define PG_SHDEPEND_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_shdepend definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_SHDEPEND_H
  #define PG_SHDEPEND_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_shdepend definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_shdescription.h pgsql_sugar/src/include/catalog/pg_shdescription.h
*** pgsql_sugar.orig/src/include/catalog/pg_shdescription.h    Fri Jan  5 23:19:53 2007
--- pgsql_sugar/src/include/catalog/pg_shdescription.h    Tue Nov  6 12:47:47 2007
***************
*** 29,40 ****
  #ifndef PG_SHDESCRIPTION_H
  #define PG_SHDESCRIPTION_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_shdescription definition.    cpp turns this into
--- 29,35 ----
  #ifndef PG_SHDESCRIPTION_H
  #define PG_SHDESCRIPTION_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_shdescription definition.    cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_statistic.h pgsql_sugar/src/include/catalog/pg_statistic.h
*** pgsql_sugar.orig/src/include/catalog/pg_statistic.h    Tue May  8 21:13:52 2007
--- pgsql_sugar/src/include/catalog/pg_statistic.h    Tue Nov  6 12:47:47 2007
***************
*** 19,30 ****
  #ifndef PG_STATISTIC_H
  #define PG_STATISTIC_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /*
   * Keep C compiler happy with anyarray, below.    This will need to go elsewhere
--- 19,25 ----
  #ifndef PG_STATISTIC_H
  #define PG_STATISTIC_H

! #include "catalog/genbki.h"

  /*
   * Keep C compiler happy with anyarray, below.    This will need to go elsewhere
diff -rc pgsql_sugar.orig/src/include/catalog/pg_tablespace.h pgsql_sugar/src/include/catalog/pg_tablespace.h
*** pgsql_sugar.orig/src/include/catalog/pg_tablespace.h    Fri Jan  5 23:19:53 2007
--- pgsql_sugar/src/include/catalog/pg_tablespace.h    Tue Nov  6 12:47:47 2007
***************
*** 19,30 ****
  #ifndef PG_TABLESPACE_H
  #define PG_TABLESPACE_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_tablespace definition.  cpp turns this into
--- 19,25 ----
  #ifndef PG_TABLESPACE_H
  #define PG_TABLESPACE_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_tablespace definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_trigger.h pgsql_sugar/src/include/catalog/pg_trigger.h
*** pgsql_sugar.orig/src/include/catalog/pg_trigger.h    Tue Mar 20 00:38:31 2007
--- pgsql_sugar/src/include/catalog/pg_trigger.h    Tue Nov  6 12:47:47 2007
***************
*** 19,30 ****
  #ifndef PG_TRIGGER_H
  #define PG_TRIGGER_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_trigger definition.    cpp turns this into
--- 19,25 ----
  #ifndef PG_TRIGGER_H
  #define PG_TRIGGER_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_trigger definition.    cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_ts_config.h pgsql_sugar/src/include/catalog/pg_ts_config.h
*** pgsql_sugar.orig/src/include/catalog/pg_ts_config.h    Tue Aug 21 03:11:27 2007
--- pgsql_sugar/src/include/catalog/pg_ts_config.h    Tue Nov  6 12:47:47 2007
***************
*** 21,32 ****
  #ifndef PG_TS_CONFIG_H
  #define PG_TS_CONFIG_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_ts_config definition.  cpp turns this into
--- 21,27 ----
  #ifndef PG_TS_CONFIG_H
  #define PG_TS_CONFIG_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_ts_config definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_ts_config_map.h pgsql_sugar/src/include/catalog/pg_ts_config_map.h
*** pgsql_sugar.orig/src/include/catalog/pg_ts_config_map.h    Tue Aug 21 03:11:27 2007
--- pgsql_sugar/src/include/catalog/pg_ts_config_map.h    Tue Nov  6 12:47:47 2007
***************
*** 21,32 ****
  #ifndef PG_TS_CONFIG_MAP_H
  #define PG_TS_CONFIG_MAP_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_ts_config_map definition.  cpp turns this into
--- 21,27 ----
  #ifndef PG_TS_CONFIG_MAP_H
  #define PG_TS_CONFIG_MAP_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_ts_config_map definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_ts_dict.h pgsql_sugar/src/include/catalog/pg_ts_dict.h
*** pgsql_sugar.orig/src/include/catalog/pg_ts_dict.h    Tue Aug 21 03:11:27 2007
--- pgsql_sugar/src/include/catalog/pg_ts_dict.h    Tue Nov  6 12:47:47 2007
***************
*** 21,32 ****
  #ifndef PG_TS_DICT_H
  #define PG_TS_DICT_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_ts_dict definition.  cpp turns this into
--- 21,27 ----
  #ifndef PG_TS_DICT_H
  #define PG_TS_DICT_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_ts_dict definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_ts_parser.h pgsql_sugar/src/include/catalog/pg_ts_parser.h
*** pgsql_sugar.orig/src/include/catalog/pg_ts_parser.h    Tue Aug 21 03:11:27 2007
--- pgsql_sugar/src/include/catalog/pg_ts_parser.h    Tue Nov  6 12:47:47 2007
***************
*** 21,32 ****
  #ifndef PG_TS_PARSER_H
  #define PG_TS_PARSER_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_ts_parser definition.  cpp turns this into
--- 21,27 ----
  #ifndef PG_TS_PARSER_H
  #define PG_TS_PARSER_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_ts_parser definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_ts_template.h pgsql_sugar/src/include/catalog/pg_ts_template.h
*** pgsql_sugar.orig/src/include/catalog/pg_ts_template.h    Mon Sep  3 04:30:45 2007
--- pgsql_sugar/src/include/catalog/pg_ts_template.h    Tue Nov  6 12:47:47 2007
***************
*** 21,32 ****
  #ifndef PG_TS_TEMPLATE_H
  #define PG_TS_TEMPLATE_H

! /* ----------------
!  *        postgres.h contains the system type definitions and the
!  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
!  *        can be read by both genbki.sh and the C compiler.
!  * ----------------
!  */

  /* ----------------
   *        pg_ts_template definition.  cpp turns this into
--- 21,27 ----
  #ifndef PG_TS_TEMPLATE_H
  #define PG_TS_TEMPLATE_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_ts_template definition.  cpp turns this into
diff -rc pgsql_sugar.orig/src/include/catalog/pg_type.h pgsql_sugar/src/include/catalog/pg_type.h
*** pgsql_sugar.orig/src/include/catalog/pg_type.h    Sun Oct 14 01:06:27 2007
--- pgsql_sugar/src/include/catalog/pg_type.h    Tue Nov  6 12:47:47 2007
***************
*** 19,34 ****
  #ifndef PG_TYPE_H
  #define PG_TYPE_H

! #include "nodes/nodes.h"

  /* ----------------
-  *        postgres.h contains the system type definitions and the
-  *        CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
-  *        can be read by both genbki.sh and the C compiler.
-  * ----------------
-  */
-
- /* ----------------
   *        pg_type definition.  cpp turns this into
   *        typedef struct FormData_pg_type
   *
--- 19,27 ----
  #ifndef PG_TYPE_H
  #define PG_TYPE_H

! #include "catalog/genbki.h"

  /* ----------------
   *        pg_type definition.  cpp turns this into
   *        typedef struct FormData_pg_type
   *
***************
*** 631,693 ****
       (typid) == ANYNONARRAYOID || \
       (typid) == ANYENUMOID)

- /*
-  * prototypes for functions in pg_type.c
-  */
- extern Oid    TypeShellMake(const char *typeName, Oid typeNamespace);

- extern Oid TypeCreate(Oid newTypeOid,
-            const char *typeName,
-            Oid typeNamespace,
-            Oid relationOid,
-            char relationKind,
-            int16 internalSize,
-            char typeType,
-            char typDelim,
-            Oid inputProcedure,
-            Oid outputProcedure,
-            Oid receiveProcedure,
-            Oid sendProcedure,
-            Oid typmodinProcedure,
-            Oid typmodoutProcedure,
-            Oid analyzeProcedure,
-            Oid elementType,
-            bool isImplicitArray,
-            Oid arrayType,
-            Oid baseType,
-            const char *defaultTypeValue,
-            char *defaultTypeBin,
-            bool passedByValue,
-            char alignment,
-            char storage,
-            int32 typeMod,
-            int32 typNDims,
-            bool typeNotNull);
-
- extern void GenerateTypeDependencies(Oid typeNamespace,
-                          Oid typeObjectId,
-                          Oid relationOid,
-                          char relationKind,
-                          Oid owner,
-                          Oid inputProcedure,
-                          Oid outputProcedure,
-                          Oid receiveProcedure,
-                          Oid sendProcedure,
-                             Oid typmodinProcedure,
-                             Oid typmodoutProcedure,
-                          Oid analyzeProcedure,
-                          Oid elementType,
-                          bool isImplicitArray,
-                          Oid baseType,
-                          Node *defaultExpr,
-                          bool rebuild);
-
- extern void TypeRename(Oid typeOid, const char *newTypeName,
-                        Oid typeNamespace);
-
- extern char *makeArrayTypeName(const char *typeName, Oid typeNamespace);
-
- extern bool moveArrayTypeName(Oid typeOid, const char *typeName,
-                               Oid typeNamespace);
-
  #endif   /* PG_TYPE_H */
--- 624,628 ----
diff -rc pgsql_sugar.orig/src/include/catalog/pg_type_fn.h pgsql_sugar/src/include/catalog/pg_type_fn.h
*** pgsql_sugar.orig/src/include/catalog/pg_type_fn.h    Tue Nov  6 12:50:50 2007
--- pgsql_sugar/src/include/catalog/pg_type_fn.h    Tue Nov  6 13:23:16 2007
***************
*** 0 ****
--- 1,77 ----
+ /*-------------------------------------------------------------------------
+  *
+  * pg_type_fn.h
+  *      prototypes for functions in pg_type.c
+  *
+  *
+  * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
+  * Portions Copyright (c) 1994, Regents of the University of California
+  *
+  * $PostgreSQL: $
+  *
+  *
+  *-------------------------------------------------------------------------
+  */
+ #ifndef PG_TYPE_FN_H
+ #define PG_TYPE_FN_H
+
+ #include "nodes/nodes.h"
+
+ extern Oid    TypeShellMake(const char *typeName, Oid typeNamespace);
+
+ extern Oid TypeCreate(Oid newTypeOid,
+                  const char *typeName,
+                  Oid typeNamespace,
+                  Oid relationOid,
+                  char relationKind,
+                  int16 internalSize,
+                  char typeType,
+                  char typDelim,
+                  Oid inputProcedure,
+                  Oid outputProcedure,
+                  Oid receiveProcedure,
+                  Oid sendProcedure,
+                  Oid typmodinProcedure,
+                  Oid typmodoutProcedure,
+                  Oid analyzeProcedure,
+                  Oid elementType,
+                  bool isImplicitArray,
+                  Oid arrayType,
+                  Oid baseType,
+                  const char *defaultTypeValue,
+                  char *defaultTypeBin,
+                  bool passedByValue,
+                  char alignment,
+                  char storage,
+                  int32 typeMod,
+                  int32 typNDims,
+                  bool typeNotNull);
+
+ extern void GenerateTypeDependencies(Oid typeNamespace,
+                                                Oid typeObjectId,
+                                                Oid relationOid,
+                                                char relationKind,
+                                                Oid owner,
+                                                Oid inputProcedure,
+                                                Oid outputProcedure,
+                                                Oid receiveProcedure,
+                                                Oid sendProcedure,
+                                                Oid typmodinProcedure,
+                                                Oid typmodoutProcedure,
+                                                Oid analyzeProcedure,
+                                                Oid elementType,
+                                                bool isImplicitArray,
+                                                Oid baseType,
+                                                Node *defaultExpr,
+                                                bool rebuild);
+
+ extern void TypeRename(Oid typeOid, const char *newTypeName,
+                                          Oid typeNamespace);
+
+ extern char *makeArrayTypeName(const char *typeName, Oid typeNamespace);
+
+ extern bool moveArrayTypeName(Oid typeOid, const char *typeName,
+                                                         Oid typeNamespace);
+
+
+ #endif   /* PG_TYPE_FN_H */
diff -rc pgsql_sugar.orig/src/include/commands/sequence.h pgsql_sugar/src/include/commands/sequence.h
*** pgsql_sugar.orig/src/include/commands/sequence.h    Fri Jan  5 23:19:54 2007
--- pgsql_sugar/src/include/commands/sequence.h    Tue Nov  6 12:47:47 2007
***************
*** 94,106 ****
  extern void seq_redo(XLogRecPtr lsn, XLogRecord *rptr);
  extern void seq_desc(StringInfo buf, uint8 xl_info, char *rec);

- /* Set the upper and lower bounds of a sequence */
- #ifndef INT64_IS_BUSTED
- #define SEQ_MAXVALUE    INT64CONST(0x7FFFFFFFFFFFFFFF)
- #else                            /* INT64_IS_BUSTED */
- #define SEQ_MAXVALUE    ((int64) 0x7FFFFFFF)
- #endif   /* INT64_IS_BUSTED */
-
- #define SEQ_MINVALUE    (-SEQ_MAXVALUE)
-
  #endif   /* SEQUENCE_H */
--- 94,97 ----
diff -rc pgsql_sugar.orig/src/pl/plpgsql/src/pl_comp.c pgsql_sugar/src/pl/plpgsql/src/pl_comp.c
*** pgsql_sugar.orig/src/pl/plpgsql/src/pl_comp.c    Mon Jul 16 19:01:10 2007
--- pgsql_sugar/src/pl/plpgsql/src/pl_comp.c    Tue Nov  6 12:47:47 2007
***************
*** 25,30 ****
--- 25,31 ----
  #include "catalog/pg_attribute.h"
  #include "catalog/pg_class.h"
  #include "catalog/pg_proc.h"
+ #include "catalog/pg_proc_fn.h"
  #include "catalog/pg_type.h"
  #include "funcapi.h"
  #include "nodes/makefuncs.h"

pgsql-patches by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: a tsearch2 (8.2.4) dictionary that only filters out stopwords
Next
From: Tom Lane
Date:
Subject: Re: Miscalculation in IsCheckpointOnSchedule()