Re: [HACKERS] UTF8 national character data type support WIP patch and list of open issues.

2013-09-22 Thread Valentine Gogichashvili
n array of types when writing a lot of data, that could be unpacked afterwords directly in the DB as normal database types). I hope I made my point a little bit clearer. Regards, Valentine Gogichashvili

Re: [HACKERS] UTF8 national character data type support WIP patch and list of open issues.

2013-09-19 Thread Valentine Gogichashvili
bs or protbufs for much more compact type storage. Regards, -- Valentine Gogichashvili

Re: [HACKERS] Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

2011-11-02 Thread Valentine Gogichashvili
s completely stupid and makes code unreadable. So I would definitely like to have a syntax, that you are suggesting in case it would give a possibility to construct ROWs (RECORDs). Regards, -- Valentine Gogichashvili

Re: [HACKERS] confusing invalid UTF8 byte sequence error

2011-08-29 Thread Valentine Gogichashvili
t; Otherwise it looks like a codepoint or a 16-bit word (endianness?) or > who knows what. Talking about this error, I find the lack of context in this error message more confusing... relative position or surrounding charachters would be really helpful, when searching for a problem with encoding... -- Valentine Gogichashvili

Re: [HACKERS] How to define global variable in postgresql

2011-08-19 Thread Valentine Gogichashvili
> Hello. How can we define a global variable in postgresql? you can also use global structure in plpython for example: http://www.postgresql.org/docs/9.0/static/plpython-sharing.html

Re: [HACKERS] Backup's from standby

2011-08-19 Thread Valentine Gogichashvili
on slave, and issues pg_stop_backup() on master again? As far as I remember this approach was working for me, considering, that all needed WAL files are transferred to the newly created DB copy as well. -- Valentine Gogichashvili

Re: [HACKERS] DELETE with LIMIT (or my first hack)

2010-12-01 Thread Valentine Gogichashvili
ol to have for that usecase as well... With best regards, -- Valentine Gogichashvili

Re: [HACKERS] Improved JDBC driver part 2

2010-12-01 Thread Valentine Gogichashvili
Hi, I cannot get the file: wget http://www.rsmogura.net/pgsql/pgjdbc_exp_20101130_C.tar.gz --2010-12-01 12:05:28-- http://www.rsmogura.net/pgsql/pgjdbc_exp_20101130_C.tar.gz Resolving www.rsmogura.net... 64.120.14.83 Connecting to www.rsmogura.net|64.120.14.83|:80... connected. HTTP request sent,

Re: [HACKERS] final patch - plpgsql: for-in-array

2010-11-22 Thread Valentine Gogichashvili
Hi, with the FOR e IN SELECT UNNEST(a) construct there is an issue again related to the unresting of composite type arrays: BEGIN; CREATE TYPE truple AS (i integer, a text, b text); DO $SQL$ DECLARE start_time timestamp; t truple; ta truple[] := ARRAY( select ROW(s.i, 'A' || (s.i)::text, '

Re: [HACKERS] [PERFORM] Cannot make GIN intarray index be used by the planner

2007-05-10 Thread Valentine Gogichashvili
07, Tom Lane <[EMAIL PROTECTED]> wrote: [cc'ing to pgsql-hackers since this is looking like a contrib/intarray bug] "Valentine Gogichashvili" <[EMAIL PROTECTED]> writes: > here is the DT That works fine for me in 8.2: regression=# explain SELECT id, (myintarray_i