Re: [GENERAL] PostgreSQL trap, and assertion failed

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_flag

[GENERAL] Arrays of arrays

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 serializatio

Re: [GENERAL] Understanding Datum

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...

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 imag

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

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 Wi

[GENERAL] System trigger

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

[GENERAL] Implement timestamp pseudotype

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, out,

[GENERAL] XML Encoding problem

Hi, I have test database with UTF-8 encoding. I putted there XML ЁĄ¡, (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 e

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

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 s

[GENERAL] Query cancellation in JDBC

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 exception

Re: [GENERAL] Mixed client_encoding database ques tion

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 unsupported

Re: [GENERAL] Table design - postgresql solution

> 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 >

[GENERAL] Numeric2 - help with library

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 n

[GENERAL] Application user name attribute on connection pool

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 applicat