Re: [GENERAL] WIN1251 localization

2013-06-15 Thread Adrian Klaver
On 06/15/2013 12:04 PM, Yuriy Rusinov wrote: Postgres 9.1 utf-8 How was Postgres installed? Is there more than one instance of Postgres on the machine? The conversion should be possible, so it would seem either the conversion library is not there or it cannot be found by the server.

Re: [GENERAL] WIN1251 localization

2013-06-15 Thread Yuriy Rusinov
Postgres 9.1 utf-8 On Sat, Jun 15, 2013 at 5:53 PM, Adrian Klaver wrote: > On 06/15/2013 02:16 AM, Yuriy Rusinov wrote: > >> >> Hello, All ! >> >> I am developing database. Initial scripts contains information in >> win1251 encoding. Now I have received problem >> >> c_db1=# \encoding WIN1251 >

Re: [GENERAL] WIN1251 localization

2013-06-15 Thread Adrian Klaver
On 06/15/2013 02:16 AM, Yuriy Rusinov wrote: Hello, All ! I am developing database. Initial scripts contains information in win1251 encoding. Now I have received problem c_db1=# \encoding WIN1251 WIN1251: invalid encoding name or conversion procedure not found c_db1=# locale in system was def

[GENERAL] WIN1251 localization

2013-06-15 Thread Yuriy Rusinov
Hello, All ! I am developing database. Initial scripts contains information in win1251 encoding. Now I have received problem c_db1=# \encoding WIN1251 WIN1251: invalid encoding name or conversion procedure not found c_db1=# locale in system was defined by this $ sudo localedef -c -i ru_RU -f CP1

[GENERAL] Dynamic SQL in Lua

2013-06-15 Thread Marc Balmer
The PostgreSQL Lua binding found on https://github.com/mbalmer/luapgsql has been extended to make it a bit easier to create SQL commands dynamically and still be able to use execParams(). Imagine a table with user information that contains usernames, hostnames, locations (e.g. building a user work