src/backend/utils/mb/conversion_procs/Makefile

   1 #-------------------------------------------------------------------------
   2 #
   3 # Makefile--
   4 #    Makefile for utils/mb/conversion_procs
   5 #
   6 # IDENTIFICATION
   7 #    $PostgreSQL$
   8 #
   9 #-------------------------------------------------------------------------
  10
  11 subdir = src/backend/utils/mb/conversion_procs
  12 top_builddir = ../../../../..
  13 include $(top_builddir)/src/Makefile.global
  14
  15 SQLSCRIPT = conversion_create.sql
  16
  17 # This file can be placed as src/test/regress/conversion.sql
  18 REGRESSION_SCRIPT = conversion.sql
  19
  20 DIRS = \
  21         ascii_and_mic cyrillic_and_mic euc_cn_and_mic euc_jp_and_sjis \
  22         euc_kr_and_mic euc_tw_and_big5 latin2_and_win1250 latin_and_mic \
  23         utf8_and_ascii utf8_and_big5 utf8_and_cyrillic utf8_and_euc_cn \
  24         utf8_and_euc_jp utf8_and_euc_kr utf8_and_euc_tw utf8_and_gb18030 \
  25         utf8_and_gbk utf8_and_iso8859 utf8_and_iso8859_1 utf8_and_johab \
  26         utf8_and_sjis utf8_and_win utf8_and_uhc \
  27         utf8_and_euc_jis_2004 utf8_and_shift_jis_2004 euc_jis_2004_and_shift_jis_2004
  28
  29 # conversion_name source_encoding destination_encoding function object
  30 CONVERSIONS = \
  31                 ascii_to_mic    SQL_ASCII MULE_INTERNAL ascii_to_mic ascii_and_mic \
  32                 mic_to_ascii    MULE_INTERNAL SQL_ASCII mic_to_ascii ascii_and_mic \
  33                 koi8_r_to_mic   KOI8R MULE_INTERNAL koi8r_to_mic cyrillic_and_mic \
  34                 mic_to_koi8_r   MULE_INTERNAL KOI8R mic_to_koi8r cyrillic_and_mic \
  35                 iso_8859_5_to_mic       ISO-8859-5 MULE_INTERNAL iso_to_mic cyrillic_and_mic \
  36                 mic_to_iso_8859_5       MULE_INTERNAL ISO-8859-5 mic_to_iso cyrillic_and_mic \
  37                 windows_1251_to_mic     WIN1251 MULE_INTERNAL win1251_to_mic cyrillic_and_mic \
  38                 mic_to_windows_1251     MULE_INTERNAL WIN1251 mic_to_win1251 cyrillic_and_mic \
  39                 windows_866_to_mic      WIN866 MULE_INTERNAL win866_to_mic cyrillic_and_mic \
  40                 mic_to_windows_866      MULE_INTERNAL WIN866 mic_to_win866 cyrillic_and_mic \
  41                 koi8_r_to_windows_1251   KOI8R WIN1251 koi8r_to_win1251 cyrillic_and_mic \
  42                 windows_1251_to_koi8_r   WIN1251 KOI8R win1251_to_koi8r cyrillic_and_mic \
  43                 koi8_r_to_windows_866   KOI8R WIN866 koi8r_to_win866 cyrillic_and_mic \
  44                 windows_866_to_koi8_r   WIN866 KOI8R win866_to_koi8r cyrillic_and_mic \
  45                 windows_866_to_windows_1251     WIN866 WIN1251 win866_to_win1251 cyrillic_and_mic \
  46                 windows_1251_to_windows_866     WIN1251 WIN866 win1251_to_win866 cyrillic_and_mic \
  47                 iso_8859_5_to_koi8_r    ISO-8859-5 KOI8R iso_to_koi8r cyrillic_and_mic \
  48                 koi8_r_to_iso_8859_5    KOI8R ISO-8859-5 koi8r_to_iso cyrillic_and_mic \
  49                 iso_8859_5_to_windows_1251      ISO-8859-5 WIN1251 iso_to_win1251 cyrillic_and_mic \
  50                 windows_1251_to_iso_8859_5      WIN1251 ISO-8859-5 win1251_to_iso cyrillic_and_mic \
  51                 iso_8859_5_to_windows_866       ISO-8859-5 WIN866 iso_to_win866 cyrillic_and_mic \
  52                 windows_866_to_iso_8859_5       WIN866 ISO-8859-5 win866_to_iso cyrillic_and_mic \
  53                 euc_cn_to_mic   EUC_CN MULE_INTERNAL euc_cn_to_mic euc_cn_and_mic \
  54                 mic_to_euc_cn   MULE_INTERNAL EUC_CN mic_to_euc_cn euc_cn_and_mic \
  55                 euc_jp_to_sjis  EUC_JP SJIS euc_jp_to_sjis euc_jp_and_sjis \
  56                 sjis_to_euc_jp  SJIS EUC_JP sjis_to_euc_jp euc_jp_and_sjis \
  57                 euc_jp_to_mic   EUC_JP MULE_INTERNAL euc_jp_to_mic euc_jp_and_sjis \
  58                 sjis_to_mic     SJIS MULE_INTERNAL sjis_to_mic euc_jp_and_sjis \
  59                 mic_to_euc_jp   MULE_INTERNAL EUC_JP mic_to_euc_jp euc_jp_and_sjis \
  60                 mic_to_sjis     MULE_INTERNAL SJIS mic_to_sjis euc_jp_and_sjis \
  61                 euc_kr_to_mic   EUC_KR MULE_INTERNAL euc_kr_to_mic euc_kr_and_mic \
  62                 mic_to_euc_kr   MULE_INTERNAL EUC_KR mic_to_euc_kr euc_kr_and_mic \
  63                 euc_tw_to_big5  EUC_TW BIG5 euc_tw_to_big5 euc_tw_and_big5 \
  64                 big5_to_euc_tw  BIG5 EUC_TW big5_to_euc_tw euc_tw_and_big5 \
  65                 euc_tw_to_mic   EUC_TW MULE_INTERNAL euc_tw_to_mic euc_tw_and_big5 \
  66                 big5_to_mic     BIG5 MULE_INTERNAL big5_to_mic euc_tw_and_big5 \
  67                 mic_to_euc_tw   MULE_INTERNAL EUC_TW mic_to_euc_tw euc_tw_and_big5 \
  68                 mic_to_big5     MULE_INTERNAL BIG5 mic_to_big5 euc_tw_and_big5 \
  69                 iso_8859_2_to_mic       LATIN2 MULE_INTERNAL latin2_to_mic latin2_and_win1250 \
  70                 mic_to_iso_8859_2       MULE_INTERNAL LATIN2 mic_to_latin2 latin2_and_win1250 \
  71                 windows_1250_to_mic     WIN1250 MULE_INTERNAL win1250_to_mic latin2_and_win1250 \
  72                 mic_to_windows_1250     MULE_INTERNAL WIN1250 mic_to_win1250 latin2_and_win1250 \
  73                 iso_8859_2_to_windows_1250  LATIN2 WIN1250 latin2_to_win1250 latin2_and_win1250 \
  74                 windows_1250_to_iso_8859_2  WIN1250 LATIN2 win1250_to_latin2 latin2_and_win1250 \
  75                 iso_8859_1_to_mic       LATIN1 MULE_INTERNAL latin1_to_mic latin_and_mic \
  76                 mic_to_iso_8859_1       MULE_INTERNAL LATIN1 mic_to_latin1 latin_and_mic \
  77                 iso_8859_3_to_mic       LATIN3 MULE_INTERNAL latin3_to_mic latin_and_mic \
  78                 mic_to_iso_8859_3       MULE_INTERNAL LATIN3 mic_to_latin3 latin_and_mic \
  79                 iso_8859_4_to_mic       LATIN4 MULE_INTERNAL latin4_to_mic latin_and_mic \
  80                 mic_to_iso_8859_4       MULE_INTERNAL LATIN4 mic_to_latin4 latin_and_mic \
  81                 ascii_to_utf8 SQL_ASCII UTF8 ascii_to_utf8 utf8_and_ascii \
  82                 utf8_to_ascii UTF8 SQL_ASCII utf8_to_ascii utf8_and_ascii \
  83                 big5_to_utf8 BIG5 UTF8 big5_to_utf8 utf8_and_big5 \
  84                 utf8_to_big5 UTF8 BIG5 utf8_to_big5 utf8_and_big5 \
  85                 utf8_to_koi8_r  UTF8 KOI8R utf8_to_koi8r utf8_and_cyrillic \
  86                 koi8_r_to_utf8  KOI8R UTF8 koi8r_to_utf8 utf8_and_cyrillic \
  87                 utf8_to_windows_866 UTF8 WIN866 utf8_to_win utf8_and_win \
  88                 windows_866_to_utf8 WIN866 UTF8 win_to_utf8 utf8_and_win \
  89                 utf8_to_windows_874 UTF8 WIN874 utf8_to_win utf8_and_win \
  90                 windows_874_to_utf8 WIN874 UTF8 win_to_utf8 utf8_and_win \
  91                 utf8_to_windows_1250 UTF8 WIN1250 utf8_to_win utf8_and_win \
  92                 windows_1250_to_utf8 WIN1250 UTF8 win_to_utf8 utf8_and_win \
  93                 utf8_to_windows_1251 UTF8 WIN1251 utf8_to_win utf8_and_win \
  94                 windows_1251_to_utf8 WIN1251 UTF8 win_to_utf8 utf8_and_win \
  95                 utf8_to_windows_1252 UTF8 WIN1252 utf8_to_win utf8_and_win \
  96                 windows_1252_to_utf8 WIN1252 UTF8 win_to_utf8 utf8_and_win \
  97                 utf8_to_windows_1253 UTF8 WIN1253 utf8_to_win utf8_and_win \
  98                 windows_1253_to_utf8 WIN1253 UTF8 win_to_utf8 utf8_and_win \
  99                 utf8_to_windows_1254 UTF8 WIN1254 utf8_to_win utf8_and_win \
 100                 windows_1254_to_utf8 WIN1254 UTF8 win_to_utf8 utf8_and_win \
 101                 utf8_to_windows_1255 UTF8 WIN1255 utf8_to_win utf8_and_win \
 102                 windows_1255_to_utf8 WIN1255 UTF8 win_to_utf8 utf8_and_win \
 103                 utf8_to_windows_1256 UTF8 WIN1256 utf8_to_win utf8_and_win \
 104                 windows_1256_to_utf8 WIN1256 UTF8 win_to_utf8 utf8_and_win \
 105                 utf8_to_windows_1257 UTF8 WIN1257 utf8_to_win utf8_and_win \
 106                 windows_1257_to_utf8 WIN1257 UTF8 win_to_utf8 utf8_and_win \
 107                 utf8_to_windows_1258 UTF8 WIN1258 utf8_to_win utf8_and_win \
 108                 windows_1258_to_utf8 WIN1258 UTF8 win_to_utf8 utf8_and_win \
 109                 euc_cn_to_utf8 EUC_CN UTF8 euc_cn_to_utf8 utf8_and_euc_cn \
 110                 utf8_to_euc_cn UTF8 EUC_CN utf8_to_euc_cn utf8_and_euc_cn \
 111                 euc_jp_to_utf8 EUC_JP UTF8 euc_jp_to_utf8 utf8_and_euc_jp \
 112                 utf8_to_euc_jp UTF8 EUC_JP utf8_to_euc_jp utf8_and_euc_jp \
 113                 euc_kr_to_utf8 EUC_KR UTF8 euc_kr_to_utf8 utf8_and_euc_kr \
 114                 utf8_to_euc_kr UTF8 EUC_KR utf8_to_euc_kr utf8_and_euc_kr \
 115                 euc_tw_to_utf8 EUC_TW UTF8 euc_tw_to_utf8 utf8_and_euc_tw \
 116                 utf8_to_euc_tw UTF8 EUC_TW utf8_to_euc_tw utf8_and_euc_tw \
 117                 gb18030_to_utf8 GB18030 UTF8 gb18030_to_utf8 utf8_and_gb18030 \
 118                 utf8_to_gb18030 UTF8 GB18030 utf8_to_gb18030 utf8_and_gb18030 \
 119                 gbk_to_utf8 GBK UTF8 gbk_to_utf8 utf8_and_gbk \
 120                 utf8_to_gbk UTF8 GBK utf8_to_gbk utf8_and_gbk \
 121                 utf8_to_iso_8859_2 UTF8 LATIN2 utf8_to_iso8859 utf8_and_iso8859 \
 122                 iso_8859_2_to_utf8 LATIN2 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 123                 utf8_to_iso_8859_3 UTF8 LATIN3 utf8_to_iso8859 utf8_and_iso8859 \
 124                 iso_8859_3_to_utf8 LATIN3 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 125                 utf8_to_iso_8859_4 UTF8 LATIN4 utf8_to_iso8859 utf8_and_iso8859 \
 126                 iso_8859_4_to_utf8 LATIN4 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 127                 utf8_to_iso_8859_9 UTF8 LATIN5 utf8_to_iso8859 utf8_and_iso8859 \
 128                 iso_8859_9_to_utf8 LATIN5 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 129                 utf8_to_iso_8859_10 UTF8 LATIN6 utf8_to_iso8859 utf8_and_iso8859 \
 130                 iso_8859_10_to_utf8 LATIN6 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 131                 utf8_to_iso_8859_13 UTF8 LATIN7 utf8_to_iso8859 utf8_and_iso8859 \
 132                 iso_8859_13_to_utf8 LATIN7 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 133                 utf8_to_iso_8859_14 UTF8 LATIN8 utf8_to_iso8859 utf8_and_iso8859 \
 134                 iso_8859_14_to_utf8 LATIN8 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 135                 utf8_to_iso_8859_15 UTF8 LATIN9 utf8_to_iso8859 utf8_and_iso8859 \
 136                 iso_8859_15_to_utf8 LATIN9 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 137                 utf8_to_iso_8859_16 UTF8 LATIN10 utf8_to_iso8859 utf8_and_iso8859 \
 138                 iso_8859_16_to_utf8 LATIN10 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 139                 utf8_to_iso_8859_5 UTF8 ISO-8859-5 utf8_to_iso8859 utf8_and_iso8859 \
 140                 iso_8859_5_to_utf8 ISO-8859-5 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 141                 utf8_to_iso_8859_6 UTF8 ISO-8859-6 utf8_to_iso8859 utf8_and_iso8859 \
 142                 iso_8859_6_to_utf8 ISO-8859-6 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 143                 utf8_to_iso_8859_7 UTF8 ISO-8859-7 utf8_to_iso8859 utf8_and_iso8859 \
 144                 iso_8859_7_to_utf8 ISO-8859-7 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 145                 utf8_to_iso_8859_8 UTF8 ISO-8859-8 utf8_to_iso8859 utf8_and_iso8859 \
 146                 iso_8859_8_to_utf8 ISO-8859-8 UTF8 iso8859_to_utf8 utf8_and_iso8859 \
 147                 iso_8859_1_to_utf8 LATIN1 UTF8 iso8859_1_to_utf8 utf8_and_iso8859_1 \
 148                 utf8_to_iso_8859_1 UTF8 LATIN1 utf8_to_iso8859_1 utf8_and_iso8859_1 \
 149                 johab_to_utf8 JOHAB UTF8 johab_to_utf8 utf8_and_johab \
 150                 utf8_to_johab UTF8 JOHAB utf8_to_johab utf8_and_johab \
 151                 sjis_to_utf8 SJIS UTF8 sjis_to_utf8 utf8_and_sjis \
 152                 utf8_to_sjis UTF8 SJIS utf8_to_sjis utf8_and_sjis \
 153                 uhc_to_utf8 UHC UTF8 uhc_to_utf8 utf8_and_uhc \
 154                 utf8_to_uhc UTF8 UHC utf8_to_uhc utf8_and_uhc \
 155                 euc_jis_2004_to_utf8 EUC_JIS_2004 UTF8 euc_jis_2004_to_utf8 utf8_and_euc_jis_2004 \
 156                 utf8_to_euc_jis_2004 UTF8 EUC_JIS_2004 utf8_to_euc_jis_2004 utf8_and_euc_jis_2004 \
 157                 shift_jis_2004_to_utf8 SHIFT_JIS_2004 UTF8 shift_jis_2004_to_utf8 utf8_and_shift_jis_2004 \
 158                 utf8_to_shift_jis_2004 UTF8 SHIFT_JIS_2004 utf8_to_shift_jis_2004 utf8_and_shift_jis_2004 \
 159                 euc_jis_2004_to_shift_jis_2004 EUC_JIS_2004 SHIFT_JIS_2004 euc_jis_2004_to_shift_jis_2004 euc_jis_2004_and_shift_jis_2004 \
 160                 shift_jis_2004_to_euc_jis_2004 SHIFT_JIS_2004 EUC_JIS_2004 shift_jis_2004_to_euc_jis_2004 euc_jis_2004_and_shift_jis_2004
 161
 162 all: $(SQLSCRIPT)
 163         @for dir in $(DIRS); do $(MAKE) -C $$dir $@ || exit; done
 164
 165 $(SQLSCRIPT): Makefile
 166 ifeq ($(enable_shared), yes)
 167         @set -e; \
 168         set $(CONVERSIONS) ; \
 169         while [ "$$#" -gt 0 ] ; \
 170         do \
 171                 name=$$1;shift; \
 172                 se=$$1;shift; \
 173                 de=$$1; shift; \
 174                 func=$$1; shift; \
 175                 obj=$$1; shift; \
 176                 echo "-- $$se --> $$de"; \
 177                 echo "CREATE OR REPLACE FUNCTION $$func (INTEGER, INTEGER, CSTRING, INTERNAL, INTEGER) RETURNS VOID AS '$$"libdir"/$$obj', '$$func' LANGUAGE C STRICT;"; \
 178                 echo "COMMENT ON FUNCTION $$func(INTEGER, INTEGER, CSTRING, INTERNAL, INTEGER) IS 'internal conversion function for $$se to $$de';"; \
 179                 echo "DROP CONVERSION pg_catalog.$$name;"; \
 180                 echo "CREATE DEFAULT CONVERSION pg_catalog.$$name FOR '$$se' TO '$$de' FROM $$func;"; \
 181                 echo "COMMENT ON CONVERSION pg_catalog.$$name IS 'conversion for $$se to $$de';"; \
 182         done > $@
 183 else
 184         echo "-- No conversion support, for lack of shared library support" > $@
 185 endif
 186
 187 $(REGRESSION_SCRIPT): Makefile
 188         @set -e; \
 189         cp regress_prolog $@; \
 190         set $(CONVERSIONS) ; \
 191         while [ "$$#" -gt 0 ] ; \
 192         do \
 193                 name=$$1;shift; \
 194                 se=$$1;shift; \
 195                 de=$$1; shift; \
 196                 func=$$1; shift; \
 197                 obj=$$1; shift; \
 198                 echo "-- $$se --> $$de"; \
 199                 echo "SELECT CONVERT('foo' USING $$name);"; \
 200                 echo "SELECT CONVERT('foo', '$$se', '$$de');"; \
 201         done >> $@; \
 202         cat regress_epilogue >> $@;
 203
 204 install: $(SQLSCRIPT) installdirs
 205         $(INSTALL_DATA) $(SQLSCRIPT) '$(DESTDIR)$(datadir)'
 206         @for dir in $(DIRS); do $(MAKE) -C $$dir $@ || exit; done
 207
 208 installdirs:
 209         $(mkinstalldirs) '$(DESTDIR)$(datadir)' '$(DESTDIR)$(pkglibdir)'
 210
 211 uninstall:
 212         rm -f '$(DESTDIR)$(datadir)/$(SQLSCRIPT)'
 213         @for dir in $(DIRS); do $(MAKE) -C $$dir $@ || exit; done
 214
 215 clean distclean maintainer-clean:
 216         rm -f $(SQLSCRIPT)
 217         @for dir in $(DIRS); do $(MAKE) -C $$dir $@ || exit; done
 218