|
Priority of timezone names vs abbreviations in AT TIME ZONE I've been thinking about the complaint here: http://archives.postgresql.org/pgsql-general/2008-07/msg00201.php and I think that the real issue boils down to the fact that timestamp input checks a name against the timezone abbrevs list first, and the zic database second; whereas the various forms of AT TIME ZONE do... 6 Jul 2008 18:06
Solaris ident authentication using unix domainsockets Robert Treat wrote: On Thursday 03 July 2008 14:01:22 Tom Lane wrote: Garick Hamlin <ghamlin(a)isc.upenn.edu> writes: I have a patch that I have been using to support postgresql's notion of ident authentication when using unix domain sockets on Solaris. This patch basically just... 5 Jul 2008 19:40
time_stamp type What's the deal with this type? Is it used internally? It's the only type that seems to have anything meaningfull in typdefaultbin and typdefault columns in pg_type. -- Sincerely, Stephen R. van den Berg. WARNING: Do not look into laser with remaining eye -- Sent via pgsql-hackers mailing list... 6 Jul 2008 01:46
introduction of WIP window function patch Hi, As I proposed a month before, I am working on window function. Although this work is at quite early step, I would like to introduce it since a part of it have been finished. If you can afford and are interested in it, please review the document and patch, or compile the applied source to execute an attached ... 6 Jul 2008 06:51
pgsql: Fix a couple of bugs in win32 shmem namegeneration: * Don't cut Alvaro Herrera wrote: Magnus Hagander wrote: Tom Lane wrote: According to what you just told me, the original coding is storing the name in a "local namespace", which presumably means it won't conflict anyway. Ergo, the existing coding is simply broken and there's nothing we can do about... 5 Jul 2008 06:24
Explain XML patch v2 Peter Eisentraut <peter_e(a)gmx.net> writes: Am Freitag, 4. Juli 2008 schrieb Tom Raney: Regarding the XML datum, in order to support that, will all users need � to compile with libxml? �Are there any lighter weight solutions to � serialize other than libxml? You can create XML without libxml. Seem... 4 Jul 2008 12:03
Review: DTrace probes (merged version) I performed review of merged patch from Robert Treat. At first point the patch does not work (SunOS 5.11 snv_86 sun4u sparc SUNW,Sun-Fire-V240) truncate ... ok alter_table ... FAILED (test process exited with exit code 2) sequence ... ok polymorphism ... 4 Jul 2008 14:06
Adding variables for segment_size, wal_segment_sizeand block sizes On Thu, 2008-07-03 at 16:36 +0200, Bernd Helmle wrote: --On Montag, Juni 30, 2008 18:47:33 -0400 Bruce Momjian <bruce(a)momjian.us> wrote: I'd like to implement them if we agree on them Bernd, have you made any progress on this? Here's a patch for this. I'll add it to the commit ... 4 Jul 2008 05:55
log_rotation_age integer overflow display quirk I just noticed that setting log_rotation_age to a value larger than 24 days results in rather weird output (I have not actually tested yet if that affects the functionality too or just the output): test=# show log_rotation_age; log_rotation_age ------------------ -2134967296ms (1 row) this is a 64bi... 6 Jul 2008 16:03
Multi-column GIN Dumb question: What's the benefit of a multi-column GIN index over multiple single-column GIN indexes? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresq... 4 Jul 2008 04:53
Truncated queries when select * frompg_stat_activity - wishlist / feature request Dave Witt wrote: ..but Postgres only shows the first ~1000 chars from each queued/running query. I know this is a long-standing issue (from reading other posts/sites), but I'd like to throw in my vote for showing the entire query, in some future version (easier said than done, I know). After 5 ... 3 Jul 2008 22:46
Truncated queries when select * from pg_stat_activity - wishlist/ feature request Hi Everyone, My first posting to the group.. I came from a mysql background (~7 years, small/mid database, about 55gig), where I could do "SHOW FULL PROCESSLIST;" to see all the queries currently queued/running on the system. I found it a very useful feature. The Postgres equivalent is (roughly) "SELECT *... 3 Jul 2008 22:46
CommitFest rules it concerns me that despite it being day 3 of the July commit fest, people are still being advised to add new items to the wiki page. To make the idea work, we need to stick to the rules we defined when we came up with the concept - specifically, no new patches once the fest begins! So please - new patches to ... 6 Jul 2008 11:57
Switching between terminals On Thu, 2008-07-03 at 19:56 +0530, cinu wrote: Could anyone please tell me where I am going wrong and if there is a way I can get the same behaviour that I am getting while I am executing the through psql prompt. You're mistake is that you think a transaction is related to your terminal, but it is in fact ... 3 Jul 2008 11:28
Command execution Hi guys, I have been following the mailing list and reading the source code for a little while, and was wandering if someone could fill in the gaps for me. Does PostgresQL view updates and inserts performed in a function as part of the same transaction or are they considered separate transactions: F... 3 Jul 2008 10:26
Resolving polymorphic functions with relateddatatypes On Thu, 2008-07-03 at 12:22 +0200, Pavel Stehule wrote: 2008/7/3 Simon Riggs <simon(a)2ndquadrant.com>: I'm using the nvl() function from the orafce package. It is defined as a polymorphic function so its function signature is nvl(anyelement, anyelement) Now if I try to use the function in ... 3 Jul 2008 14:34 |