Re: [GENERAL] PostgreSQL trap, and assertion failed

2011-04-14 Thread rsmogura
On Thu, 14 Apr 2011 16:57:01 +0800, Craig Ringer wrote: On 14/04/2011 2:06 PM, Radosław Smogura wrote: Hello, I have small crash reporting code, which I use during mmap-ing database. After last merge with master I got TRAP: FailedAssertion(!(slot 0 slot= PMSignalState-num_child_flags),

[GENERAL] Arrays of arrays

2011-04-07 Thread rsmogura
Hello, May I ask if PostgreSQL supports arrays of arrays directly or indirectly, or if such support is planned? I'm interested about pseudo constructs like: 1. Directly - (integer[4])[5] - this is equivalent to multidimensional array, but may be differently represented on protocol

Re: [GENERAL] Understanding Datum

2011-03-24 Thread rsmogura
On Thu, 24 Mar 2011 10:50:32 +0530, Nick Raj wrote: If Datum contains only the value (not having type specific info.), then Suppose i want to print the Datum V value (already defined in postgres) then printf(%??, V); Because V is assigned by PG_GETARG_POINTER(1); I dont having the information

Re: [GENERAL] Using bytea field...

2011-03-09 Thread rsmogura
On Wed, 09 Mar 2011 13:27:16 +0200, Sim Zacks wrote: MD5 is not collision resistant (using the immortal words of wikipedia http://en.wikipedia.org/wiki/MD5). This means that it is possible that multiple images will return the same md5 hash. The question is, if it screws up and says that an

Re: [GENERAL] unexpected EOF on client connection vs 9.0.3

2011-03-08 Thread rsmogura
On Tue, 08 Mar 2011 11:30:10 +0800, Craig Ringer wrote: On 08/03/11 02:49, Piotr Czekalski wrote: I've checked and verified that all connections are closed within the code, what's more, the problem has appeared just as I've moved server from Fedora Linux x86_64 running Postgres 8.4.2 to the

[GENERAL] System trigger

2011-02-22 Thread rsmogura
Hi, Is any solution (I mean in code and internal based), any API. That allows to create system trigger or handle on table. I'm interested in tracking changes and coercing values on row change/insert/remove - user may not to disable such trigger. In addition It is possible to track changes to

[GENERAL] Implement timestamp pseudotype

2011-02-17 Thread rsmogura
In order to implement sending in binary mode timestamps with / without timezone I want to create pseudo type. Driver should create this autmaticly, if it will have enough permissions. What method should I implement? 1) Of course cast to timestamp, date, time with / without time zone, in,

[GENERAL] XML Encoding problem

2011-02-07 Thread rsmogura
Hi, I have test database with UTF-8 encoding. I putted there XML aЁĄ¡/a, (U+0401, U+0104, U+00A1). I changed client encoding to iso8859-2, as the result of select I got ERROR: character 0xd081 of encoding UTF8 has no equivalent in LATIN2 Stan SQL:22P05. I should got result with characters

Re: [GENERAL] Store base64 in database. Use bytea or text?

2011-01-28 Thread rsmogura
Hi, In means of database, it is impossible. If you want to cache, add version or last modified column, then ask for changes and cache data locally. Kind regards, Radosław Smogura http://softperience.eu On Fri, 28 Jan 2011 13:32:31 +, Andre Lopes wrote: Hi, Another question about this

[GENERAL] Query cancellation in JDBC

2011-01-25 Thread rsmogura
Hi, I done in JDBC driver barrier preventing of execution of query until the cancel will not return, but future queries after cancellation are occasionally terminated. The query cancel sends following 16, 123456789, pid, key, flush, after this it tries to read EOF, I got and ignore

Re: [GENERAL] Mixed client_encoding database ques tion

2011-01-11 Thread rsmogura
Hi, I suggest you to recreate database in WIN1521 encoding, so Java will not write unsupported characters. As well you can configure JDBC in way it will allow You to change client encoding, so you can change it to WIN. In both of above You will get error when you will try to write

Re: [GENERAL] Table design - postgresql solution

2010-12-05 Thread rsmogura
Hi, I have a bit of a DB design question, associated with postgresql in particular, hopefully thinking it could solve my dilemma. This is my setup of 3 tables: Table_1 id_t1 name date_of_discovery history Table_2 id_t2 name type size Table_3 id_t3 name location color I

[GENERAL] Numeric2 - help with library

2010-08-10 Thread rsmogura
Hi, I have a problem with running attached type numeric2 on PostgreSQL (8.4). The file is compiled and loaded properly into database. I can create table with this column, and store values there, but when I try to read those values I got segmentation fault. The PostgreSQL doesn't even call method

[GENERAL] Application user name attribute on connection pool

2010-08-02 Thread rsmogura
Hello, I'm not member of this list, but because the 9th version of PostgreSQL is incoming, I would like to ask if there is possibility to add session property of application user - this property, in contrast to login name, should be setted by driver (e.g. JDBC) to current user logged into