Re: Problem with special character � on - Mailing list pgsql-general

Hi

Thanks for the tips.  Locale are the same ...  unless I don`t look at
the right thing...


Production ENV
-----------------
lc_collate                     | C
lc_ctype                       | C
lc_messages                    | C
lc_monetary                    | C
lc_numeric                     | C
lc_time                        | C


Dev ENV
----------
"lc_collate";"C"
"lc_ctype";"C"
"lc_messages";"C"
"lc_monetary";"C"
"lc_numeric";"C"
"lc_time";"C"


Thanks for your help
/David

PROD ALL VARIABLES
---------------------------
"add_missing_from";"on"
"australian_timezones";"off"
"authentication_timeout";"60"
"check_function_bodies";"on"
"checkpoint_segments";"3"
"checkpoint_timeout";"300"
"checkpoint_warning";"30"
"client_encoding";"UNICODE"
"client_min_messages";"notice"
"commit_delay";"0"
"commit_siblings";"5"
"cpu_index_tuple_cost";"0.001"
"cpu_operator_cost";"0.0025"
"cpu_tuple_cost";"0.01"
"DateStyle";"ISO, MDY"
"db_user_namespace";"off"
"deadlock_timeout";"1000"
"debug_pretty_print";"off"
"debug_print_parse";"off"
"debug_print_plan";"off"
"debug_print_rewritten";"off"
"default_statistics_target";"10"
"default_transaction_isolation";"read committed"
"default_transaction_read_only";"off"
"dynamic_library_path";"$libdir"
"effective_cache_size";"1000"
"enable_hashagg";"on"
"enable_hashjoin";"on"
"enable_indexscan";"on"
"enable_mergejoin";"on"
"enable_nestloop";"on"
"enable_seqscan";"on"
"enable_sort";"on"
"enable_tidscan";"on"
"explain_pretty_print";"on"
"extra_float_digits";"0"
"from_collapse_limit";"8"
"fsync";"on"
"geqo";"on"
"geqo_effort";"1"
"geqo_generations";"0"
"geqo_pool_size";"0"
"geqo_selection_bias";"2"
"geqo_threshold";"11"
"join_collapse_limit";"8"
"krb_server_keyfile";"FILE:/etc/sysconfig/pgsql/krb5.keytab"
"lc_collate";"C"
"lc_ctype";"C"
"lc_messages";"C"
"lc_monetary";"C"
"lc_numeric";"C"
"lc_time";"C"
"log_connections";"off"
"log_duration";"off"
"log_error_verbosity";"default"
"log_executor_stats";"off"
"log_hostname";"off"
"log_min_duration_statement";"-1"
"log_min_error_statement";"panic"
"log_min_messages";"notice"
"log_parser_stats";"off"
"log_pid";"off"
"log_planner_stats";"off"
"log_source_port";"off"
"log_statement";"off"
"log_statement_stats";"off"
"log_timestamp";"off"
"max_connections";"100"
"max_expr_depth";"10000"
"max_files_per_process";"1000"
"max_fsm_pages";"20000"
"max_fsm_relations";"1000"
"max_locks_per_transaction";"64"
"password_encryption";"on"
"port";"5432"
"pre_auth_delay";"0"
"preload_libraries";"unset"
"random_page_cost";"4"
"regex_flavor";"advanced"
"rendezvous_name";"unset"
"search_path";"$user,public"
"server_encoding";"UNICODE"
"server_version";"7.4.7"
"shared_buffers";"1000"
"silent_mode";"off"
"sort_mem";"1024"
"sql_inheritance";"on"
"ssl";"off"
"statement_timeout";"0"
"stats_block_level";"off"
"stats_command_string";"off"
"stats_reset_on_server_start";"on"
"stats_row_level";"off"
"stats_start_collector";"on"
"superuser_reserved_connections";"2"
"syslog";"0"
"syslog_facility";"LOCAL0"
"syslog_ident";"postgres"
"tcpip_socket";"on"
"TimeZone";"unknown"
"trace_notify";"off"
"transaction_isolation";"read committed"
"transaction_read_only";"off"
"transform_null_equals";"off"
"unix_socket_directory";"unset"
"unix_socket_group";"unset"
"unix_socket_permissions";"511"
"vacuum_mem";"8192"
"virtual_host";"unset"
"wal_buffers";"8"
"wal_debug";"0"
"wal_sync_method";"fdatasync"
"zero_damaged_pages";"off"


DEV ENV FULL VARIABLE
-------------------------------
"add_missing_from";"on"
"australian_timezones";"off"
"authentication_timeout";"60"
"check_function_bodies";"on"
"checkpoint_segments";"3"
"checkpoint_timeout";"300"
"checkpoint_warning";"30"
"client_encoding";"UNICODE"
"client_min_messages";"notice"
"commit_delay";"0"
"commit_siblings";"5"
"cpu_index_tuple_cost";"0.001"
"cpu_operator_cost";"0.0025"
"cpu_tuple_cost";"0.01"
"DateStyle";"ISO, MDY"
"db_user_namespace";"off"
"deadlock_timeout";"1000"
"debug_pretty_print";"off"
"debug_print_parse";"off"
"debug_print_plan";"off"
"debug_print_rewritten";"off"
"default_statistics_target";"10"
"default_transaction_isolation";"read committed"
"default_transaction_read_only";"off"
"dynamic_library_path";"$libdir"
"effective_cache_size";"1000"
"enable_hashagg";"on"
"enable_hashjoin";"on"
"enable_indexscan";"on"
"enable_mergejoin";"on"
"enable_nestloop";"on"
"enable_seqscan";"on"
"enable_sort";"on"
"enable_tidscan";"on"
"explain_pretty_print";"on"
"extra_float_digits";"0"
"from_collapse_limit";"8"
"fsync";"on"
"geqo";"on"
"geqo_effort";"1"
"geqo_generations";"0"
"geqo_pool_size";"0"
"geqo_selection_bias";"2"
"geqo_threshold";"11"
"join_collapse_limit";"8"
"krb_server_keyfile";"unset"
"lc_collate";"C"
"lc_ctype";"C"
"lc_messages";"C"
"lc_monetary";"C"
"lc_numeric";"C"
"lc_time";"C"
"log_connections";"off"
"log_duration";"off"
"log_error_verbosity";"default"
"log_executor_stats";"off"
"log_hostname";"off"
"log_min_duration_statement";"-1"
"log_min_error_statement";"panic"
"log_min_messages";"notice"
"log_parser_stats";"off"
"log_pid";"off"
"log_planner_stats";"off"
"log_source_port";"off"
"log_statement";"off"
"log_statement_stats";"off"
"log_timestamp";"off"
"max_connections";"40"
"max_expr_depth";"10000"
"max_files_per_process";"1000"
"max_fsm_pages";"20000"
"max_fsm_relations";"1000"
"max_locks_per_transaction";"64"
"password_encryption";"on"
"port";"5432"
"pre_auth_delay";"0"
"preload_libraries";"unset"
"random_page_cost";"4"
"regex_flavor";"advanced"
"rendezvous_name";"unset"
"search_path";"$user,public"
"server_encoding";"UNICODE"
"server_version";"7.4.5"
"shared_buffers";"1000"
"silent_mode";"off"
"sort_mem";"1024"
"sql_inheritance";"on"
"ssl";"off"
"statement_timeout";"0"
"stats_block_level";"off"
"stats_command_string";"off"
"stats_reset_on_server_start";"on"
"stats_row_level";"off"
"stats_start_collector";"on"
"superuser_reserved_connections";"2"
"syslog";"0"
"syslog_facility";"LOCAL0"
"syslog_ident";"postgres"
"tcpip_socket";"on"
"TimeZone";"   5   4,M4.1.0/2,M10.5.0/2"
"trace_notify";"off"
"transaction_isolation";"read committed"
"transaction_read_only";"off"
"transform_null_equals";"off"
"unix_socket_directory";"unset"
"unix_socket_group";"unset"
"unix_socket_permissions";"511"
"vacuum_mem";"8192"
"virtual_host";"unset"
"wal_buffers";"8"
"wal_debug";"0"
"wal_sync_method";"fsync"
"zero_damaged_pages";"off"







Miroslav Šulc wrote:

> David Gagnon wrote:
>
>> Thanks for your answer.
>>
>>  The ISP created the db fom me .. So I don't have this information. I
>> search the web to know how to get this info via PgadminIII and I
>> haven't found :-(  Is there a way to get this information once the
>> database have been created ?  I looked via psql .. I haven`t found
>> either
>
>
> David, you can try 'SHOW ALL' command.
>
>>
>> Thanks
>> /David
>
>
> Miroslav