Re: Segmentation fault while COPY in 7.3

Nicolai Tufar wrote:
> From: "Tom Lane" <tgl@sss.pgh.pa.us>
>>I have a sneaking suspicion that it can only be reproduced with Nicolai's
>>locale setting.  Not sure exactly what aspect of the locale is causing
>>the problem though ...
>
> I am trying to reproduce the same on another server with no success.
> Locale is what also comes to my mind. I have compiled PostgreSQL
> with --with-nls option. All databases, including template0 are in
> LATIN5 encoding. My postgresql.conf contains:
>
> LC_MESSAGES = 'tr_TR'
> LC_MONETARY = 'tr_TR'
> LC_NUMERIC = 'tr_TR'
> LC_TIME = 'tr_TR'
> datestyle = 'European'
>

Here's what I have:
$ pg_config --configure
'--with-tcl' '--enable-integer-datetimes' '--enable-debug' '--enable-cassert'
'--enable-nls' '--enable-depend'
'DOCBOOKSTYLE=/usr/share/sgml/docbook/dsssl-stylesheets-1.76'

testl5=# select * from pg_settings where name like 'lc%' or name = 'DateStyle';
     name     |            setting
-------------+-------------------------------
  DateStyle   | ISO with European conventions
  lc_messages | tr_TR
  lc_monetary | tr_TR
  lc_numeric  | tr_TR
  lc_time     | tr_TR
(5 rows)

testl5=# \l
          List of databases
     Name    |  Owner   | Encoding
------------+----------+-----------
  parts      | postgres | SQL_ASCII
  regression | postgres | SQL_ASCII
  template0  | postgres | SQL_ASCII
  template1  | postgres | SQL_ASCII
  test       | postgres | SQL_ASCII
  testjp     | postgres | EUC_JP
  testl5     | postgres | LATIN5
(7 rows)

testl5=#  copy foo(bsvr_no,yyn_tur,yyn_no,yyn_syf,yyn_trh) to stdout;
a       a       1.0     1.0     2002-11-30

Still works for me. Could it be related to --enable-integer-datetimes?

Joe