Postgres Pro
Downloads
Home   >   mailing lists

Thread: create database warning

create database warning

From
Mykola Stryebkov
Date:
Hi,

# psql83 template1
Password:
Welcome to psql83 8.3.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
        \h for help with SQL commands
        \? for help with psql commands
        \g or terminate with semicolon to execute query
        \q to quit

template1=# drop database inf;
DROP DATABASE
template1=# create database inf with encoding 'windows-1251';
WARNING:  could not determine encoding for locale "uk_UA.KOI8-U":
codeset is "KOI8-U"
DETAIL:  Please report this to <pgsql-bugs@postgresql.org>.
CREATE DATABASE
template1=#

What's wrong with it?

--
Nick Strebkov
Public key: http://humgat.org/~nick/pubkey.txt
fpr: 552C 88D6 895B 6E64 F277 D367 8A70 8132 47F5 C1B6

Re: create database warning

From
Peter Eisentraut
Date:
Mykola Stryebkov wrote:
> Hi,
>
> # psql83 template1
> Password:
> Welcome to psql83 8.3.5, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>
> template1=# drop database inf;
> DROP DATABASE
> template1=# create database inf with encoding 'windows-1251';
> WARNING:  could not determine encoding for locale "uk_UA.KOI8-U":
> codeset is "KOI8-U"
> DETAIL:  Please report this to <pgsql-bugs@postgresql.org>.
> CREATE DATABASE
> template1=#
>
> What's wrong with it?

PostgreSQL does not support the KOI8-U encoding.  You could try to use
uk_UA.utf8.