PgSql

proposal - custom format for date, timestamp
Pavel Stehule <pavel.stehule(a)gmail.com> writes: I thinking about request on custom datetime format. My first idea is: a) add new datestyle format "custom" b) add new GUC variables - custom_date_format, custom_time_format, custom_timestamp_format Ick. Why not just put them in one variable. datestyle ... 2 Jun 2010 12:02

[HACKERS] proposal - custom format for date, timestamp
Hello I thinking about request on custom datetime format. My first idea is: a) add new datestyle format "custom" b) add new GUC variables - custom_date_format, custom_time_format, custom_timestamp_format There are some questions: a) what is good behave when datestyle = custom, but some necessary custom_*_f... 2 Jun 2010 08:44

[BUGS] BUG #5487: dblink failed with 63 bytes connectionnames
On 02/06/10 09:46, Takahiro Itagaki wrote: Heikki Linnakangas<heikki.linnakangas(a)enterprisedb.com> wrote: Hmm, seems that dblink should call truncate_identifier() for the truncation, to be consistent with truncation of table names etc. Hmmm, we need the same routine with truncate_identifier(), b... 2 Jun 2010 07:38

Performance Enhancement/Fix for Array Utility Functions
On Wed, Mar 31, 2010 at 9:47 AM, Mike Lewis <mikelikespie(a)gmail.com> wrote: Thanks. Added it. https://commitfest.postgresql.org/action/patch_view?id=292 I have reviewed this patch; this is my review: Regression tests pass with assertions enabled. Performance gains reported by author confirmed. The ... 16 Jun 2010 03:27

[HACKERS] CommitFest FAQ (was: dividing money by money)
[moving to -www list with bc to -hackers] Alvaro Herrera <alvherre(a)commandprompt.com> wrote: BTW maybe the developer faq could use all the info gathered in this thread. I wound up putting a few sentences from this thread into the CommitFest Wiki page, and linking to that from the "Submitting a Patch" ... 1 Jun 2010 15:18

VACUUM messages without newlines
Excerpts from Thom Brown's message of mar jun 01 11:16:33 -0400 2010: This has annoyed me for some time, but it appears that in the VACUUM log, the line which says... INFO: analyzing "%s.%s" ...( and appears in pgsql/src/backend/commands/analyze.c lines 282 and 287 ) doesn't terminate with a new... 1 Jun 2010 13:05

[HACKERS] VACUUM messages without newlines
This has annoyed me for some time, but it appears that in the VACUUM log, the line which says... INFO: analyzing "%s.%s" ....( and appears in pgsql/src/backend/commands/analyze.c lines 282 and 287 ) doesn't terminate with a newline, meaning the next message appears immediately after it. Either the errmsg fun... 1 Jun 2010 11:58

Trigger function in a multi-threaded environment behavior
On Tue, Jun 1, 2010 at 7:10 AM, Hardik Belani <hardikbelani(a)gmail.com> wrote: If we introduce postgres triggers (trigger functions) on some of the tables to track insert/update/delete operations, (This is done by keeping and updating a counter field for every insert, update and delete operation performed on... 1 Jun 2010 10:51

Trigger function in a multi-threaded environmentbehavior
On tis, 2010-06-01 at 16:40 +0530, Hardik Belani wrote: If we introduce postgres triggers (trigger functions) on some of the tables to track insert/update/delete operations, (This is done by keeping and updating a counter field for every insert, update and delete operation performed on a set of tables ins... 1 Jun 2010 07:33

[HACKERS] Trigger function in a multi-threaded environment behavior
We have a multi-threaded environment in linux where multiple threads are performing database operations(insert, update, select and at times delete as well) in transaction mode (which may span across stored procedures) using unixodbc. Now this as is, works fine. If we introduce postgres triggers (trigger fun... 1 Jun 2010 07:33