Title: [952] trunk: Update PostgreSQL type definitions
- Revision
- 952
- Author
- cito
- Date
- 2019-01-03 10:20:00 -0500 (Thu, 03 Jan 2019)
Log Message
Update PostgreSQL type definitions
Modified Paths
Diff
Modified: trunk/pgmodule.c (951 => 952)
--- trunk/pgmodule.c 2019-01-02 19:21:48 UTC (rev 951)
+++ trunk/pgmodule.c 2019-01-03 15:20:00 UTC (rev 952)
@@ -323,7 +323,7 @@
t = array_as_text ? PYGRES_TEXT : (PYGRES_DECIMAL | PYGRES_ARRAY);
break;
- case CASHARRAYOID:
+ case MONEYARRAYOID:
t = array_as_text ? PYGRES_TEXT : ((decimal_point ?
PYGRES_MONEY : PYGRES_TEXT) | PYGRES_ARRAY);
break;
Modified: trunk/pgtypes.h (951 => 952)
--- trunk/pgtypes.h 2019-01-02 19:21:48 UTC (rev 951)
+++ trunk/pgtypes.h 2019-01-03 15:20:00 UTC (rev 952)
@@ -1,14 +1,14 @@
/*
pgtypes - PostgreSQL type definitions
- These are the standard PostgreSQL 9.5 built-in types,
- extracted from src/include/catalog/pg_type.h,
+ These are the standard PostgreSQL 11.1 built-in types,
+ extracted from src/backend/catalog/pg_type_d.h,
because that header file is sometimes not available
or needs other header files to get properly included.
You can also query pg_type to get this information.
*/
-#ifndef PG_TYPE_H
+#ifndef PG_TYPE_D_H
#define BOOLOID 16
#define BYTEAOID 17
@@ -27,8 +27,13 @@
#define OIDVECTOROID 30
#define JSONOID 114
#define XMLOID 142
+#define XMLARRAYOID 143
+#define JSONARRAYOID 199
#define PGNODETREEOID 194
+#define PGNDISTINCTOID 3361
+#define PGDEPENDENCIESOID 3402
#define PGDDLCOMMANDOID 32
+#define SMGROID 210
#define POINTOID 600
#define LSEGOID 601
#define PATHOID 602
@@ -35,6 +40,7 @@
#define BOXOID 603
#define POLYGONOID 604
#define LINEOID 628
+#define LINEARRAYOID 629
#define FLOAT4OID 700
#define FLOAT8OID 701
#define ABSTIMEOID 702
@@ -42,16 +48,46 @@
#define TINTERVALOID 704
#define UNKNOWNOID 705
#define CIRCLEOID 718
+#define CIRCLEARRAYOID 719
#define CASHOID 790
+#define MONEYARRAYOID 791
#define MACADDROID 829
#define INETOID 869
#define CIDROID 650
+#define MACADDR8OID 774
+#define BOOLARRAYOID 1000
+#define BYTEAARRAYOID 1001
+#define CHARARRAYOID 1002
+#define NAMEARRAYOID 1003
#define INT2ARRAYOID 1005
+#define INT2VECTORARRAYOID 1006
#define INT4ARRAYOID 1007
+#define REGPROCARRAYOID 1008
#define TEXTARRAYOID 1009
#define OIDARRAYOID 1028
+#define TIDARRAYOID 1010
+#define XIDARRAYOID 1011
+#define CIDARRAYOID 1012
+#define OIDVECTORARRAYOID 1013
+#define BPCHARARRAYOID 1014
+#define VARCHARARRAYOID 1015
+#define INT8ARRAYOID 1016
+#define POINTARRAYOID 1017
+#define LSEGARRAYOID 1018
+#define PATHARRAYOID 1019
+#define BOXARRAYOID 1020
#define FLOAT4ARRAYOID 1021
+#define FLOAT8ARRAYOID 1022
+#define ABSTIMEARRAYOID 1023
+#define RELTIMEARRAYOID 1024
+#define TINTERVALARRAYOID 1025
+#define POLYGONARRAYOID 1027
#define ACLITEMOID 1033
+#define ACLITEMARRAYOID 1034
+#define MACADDRARRAYOID 1040
+#define MACADDR8ARRAYOID 775
+#define INETARRAYOID 1041
+#define CIDRARRAYOID 651
#define CSTRINGARRAYOID 1263
#define BPCHAROID 1042
#define VARCHAROID 1043
@@ -58,13 +94,23 @@
#define DATEOID 1082
#define TIMEOID 1083
#define TIMESTAMPOID 1114
+#define TIMESTAMPARRAYOID 1115
+#define DATEARRAYOID 1182
+#define TIMEARRAYOID 1183
#define TIMESTAMPTZOID 1184
+#define TIMESTAMPTZARRAYOID 1185
#define INTERVALOID 1186
+#define INTERVALARRAYOID 1187
+#define NUMERICARRAYOID 1231
#define TIMETZOID 1266
+#define TIMETZARRAYOID 1270
#define BITOID 1560
+#define BITARRAYOID 1561
#define VARBITOID 1562
+#define VARBITARRAYOID 1563
#define NUMERICOID 1700
#define REFCURSOROID 1790
+#define REFCURSORARRAYOID 2201
#define REGPROCEDUREOID 2202
#define REGOPEROID 2203
#define REGOPERATOROID 2204
@@ -72,16 +118,43 @@
#define REGTYPEOID 2206
#define REGROLEOID 4096
#define REGNAMESPACEOID 4089
+#define REGPROCEDUREARRAYOID 2207
+#define REGOPERARRAYOID 2208
+#define REGOPERATORARRAYOID 2209
+#define REGCLASSARRAYOID 2210
#define REGTYPEARRAYOID 2211
+#define REGROLEARRAYOID 4097
+#define REGNAMESPACEARRAYOID 4090
#define UUIDOID 2950
+#define UUIDARRAYOID 2951
#define LSNOID 3220
+#define PG_LSNARRAYOID 3221
#define TSVECTOROID 3614
#define GTSVECTOROID 3642
#define TSQUERYOID 3615
#define REGCONFIGOID 3734
#define REGDICTIONARYOID 3769
+#define TSVECTORARRAYOID 3643
+#define GTSVECTORARRAYOID 3644
+#define TSQUERYARRAYOID 3645
+#define REGCONFIGARRAYOID 3735
+#define REGDICTIONARYARRAYOID 3770
#define JSONBOID 3802
+#define JSONBARRAYOID 3807
+#define TXID_SNAPSHOTOID 2970
+#define TXID_SNAPSHOTARRAYOID 2949
#define INT4RANGEOID 3904
+#define INT4RANGEARRAYOID 3905
+#define NUMRANGEOID 3906
+#define NUMRANGEARRAYOID 3907
+#define TSRANGEOID 3908
+#define TSRANGEARRAYOID 3909
+#define TSTZRANGEOID 3910
+#define TSTZRANGEARRAYOID 3911
+#define DATERANGEOID 3912
+#define DATERANGEARRAYOID 3913
+#define INT8RANGEOID 3926
+#define INT8RANGEARRAYOID 3927
#define RECORDOID 2249
#define RECORDARRAYOID 2287
#define CSTRINGOID 2275
@@ -97,32 +170,8 @@
#define ANYNONARRAYOID 2776
#define ANYENUMOID 3500
#define FDW_HANDLEROID 3115
+#define INDEX_AM_HANDLEROID 325
#define TSM_HANDLEROID 3310
#define ANYRANGEOID 3831
-/* more types */
-
-#define JSONARRAYOID 199
-#define CASHARRAYOID 791
-#define BOOLARRAYOID 1000
-#define BYTEAARRAYOID 1001
-#define CHARARRAYOID 1002
-#define NAMEARRAYOID 1003
-#define XIDARRAYOID 1011
-#define CIDARRAYOID 1012
-#define BPCHARARRAYOID 1014
-#define VARCHARARRAYOID 1015
-#define INT8ARRAYOID 1016
-#define FLOAT8ARRAYOID 1022
-#define ABSTIMEARRAYOID 1023
-#define RELTIMEARRAYOID 1024
-#define TIMESTAMPARRAYOID 1115
-#define DATEARRAYOID 1182
-#define TIMEARRAYOID 1183
-#define TIMESTAMPTZARRAYOID 1185
-#define INTERVALARRAYOID 1187
-#define NUMERICARRAYOID 1231
-#define TIMETZARRAYOID 1270
-#define JSONBARRAYOID 3807
-
-#endif /* PG_TYPE_H */
+#endif /* PG_TYPE_D_H */
_______________________________________________
PyGreSQL mailing list
[email protected]
https://mail.vex.net/mailman/listinfo/pygresql
