Search Discussions
-
It sure would be nice to have this in core. Yeah, there's pgcrypto, but it's a bit overkill for people who simply want to do a SHA1, especially when they see we already have a md5(). I also realize ...
Greg Sabino Mullane
Jan 20, 2008 at 5:23 pm
Apr 6, 2008 at 6:29 pm -
Happy New Year, everybody. This proposal follows on from previous thinking about partitioning, where I've taken up Andrew Sullivan's suggestion to re-examine the current partitioning concept of using ...
Simon Riggs
Jan 2, 2008 at 5:55 pm
Jan 12, 2008 at 1:53 am -
[ redirecting thread to -hackers ] Neil Conway <neilc@samurai.com writes: We have enable_seqscan already, so that last choice seems to fit in. regards, tom lane
Tom Lane
Jan 28, 2008 at 2:04 am
Feb 5, 2008 at 7:46 pm -
Dear Friends, In my past development projects, I always used the concept of Materialized VIEW to speed-up SELECTs over INSERTs. You are well aware of Jonathan Gardner preliminary work: ...
Jean-Michel Pouré
Jan 12, 2008 at 12:27 pm
Jan 17, 2008 at 11:31 am -
Hi all, Many of you will have read the dynamic partitioning thread here: http://archives.postgresql.org/pgsql-hackers/2008-01/msg00028.php I've proposed an alternative approach, which we've called ...
Gavin Sherry
Jan 11, 2008 at 11:13 pm
Jan 20, 2008 at 12:57 pm -
(for 8.4 ...) I'd like to introduce triggers that fire when we issue a truncate: CREATE TRIGGER name [BEFORE | AFTER ] TRUNCATE ON table FOR EACH STATEMENT EXECUTE PROCEDURE function (arguments); The ...
Simon Riggs
Jan 25, 2008 at 11:39 am
Feb 11, 2008 at 5:39 pm -
Using the attached patch, SSL will act over Unix-domain sockets. AFAICT, this just works. I didn't find a way to sniff a Unix-domain socket, however. How should we proceed with this? -- Peter ...
Peter Eisentraut
Jan 4, 2008 at 4:13 pm
Jan 17, 2008 at 1:44 pm -
Hi, May be i am reposting something which has been discussed to end in this forum. I have made a search in the archives and i couldn't find any immediately. With my relatively small experience in ...
Gokulakannan Somasundaram
Jan 9, 2008 at 10:39 am
Jan 16, 2008 at 9:21 pm -
Further poking around shows that the "unrecognized locktag" is because lmgr.c:DescribeLockTag was never taught about virtual xids. Ie something like this (untested): --- lmgr.c 04 Jan 2008 15:12:37 ...
Gregory Stark
Jan 7, 2008 at 4:21 pm
Jan 15, 2008 at 7:24 pm -
Now that we have a txid_snapshot datatype, it seems easy to imagine that we might use that to pass snapshot information around between sessions. If we had a function ...
Simon Riggs
Jan 11, 2008 at 4:14 pm
Mar 28, 2008 at 6:57 pm -
There was a serious performance regression in OUTER JOIN planning going from 8.2.4 to 8.2.5. I know Tom came up with some patches to mitigate the issues in 8.2.5, but my testing shows that problems ...
Kevin Grittner
Jan 4, 2008 at 6:16 pm
Jan 17, 2008 at 10:25 pm -
After chewing on this for awhile, it seems to me that pg_aggregate.c is using enforce_generic_type_consistency() in a rather fundamentally different way than it's being used anywhere else. Everywhere ...
Tom Lane
Jan 6, 2008 at 7:45 pm
Jan 11, 2008 at 6:43 pm -
I really needed this functionality in PostgreSQL. A common use for autonomous transactions is error logging. I want to log sqlerrm in a function and raise an exception so the calling application ...
Roberts, Jon
Jan 22, 2008 at 4:03 pm
Jan 30, 2008 at 5:12 pm -
Hello I found so PL/SQL support CASE statement http://download-east.oracle.com/docs/cd/B10500_01/appdev.920/a96624/04_struc.htm#484 I propose add this statement to PL/pgSQL too. Reasons: a) it's ...
Pavel Stehule
Jan 17, 2008 at 3:01 pm
Mar 28, 2008 at 3:30 am -
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=mastodon&dt=2008-01-30%2020:00:00 /D
Dave Page
Jan 30, 2008 at 8:29 pm
Jan 31, 2008 at 4:28 pm -
It occurred to me the other day that synchronized scans could play havoc with clustered tables. When you dump and reload a table even if it was recently clustered if any other sequential scans are ...
Gregory Stark
Jan 27, 2008 at 3:02 pm
Jan 28, 2008 at 10:45 pm -
Here (@sophos.com) we run machine cluster tests using FreeBSD jails. A jail is halfway between a chroot and a VM. Jails blow a number of assumptions about a unix environment: sysv ipc's are global to ...
Mischa Sandberg
Jan 16, 2008 at 4:41 pm
May 8, 2008 at 2:24 am -
Hello, I spent the better part of this evening tracking down a problem with a high velocity database. The database had entered the point of no return by invoking xidStopLimit. This by itself isn't a ...
Joshua D. Drake
Jan 6, 2008 at 8:37 am
Jan 14, 2008 at 11:48 pm -
Hello, Table "pg_catalog.pg_autovacuum" Column | Type | Modifiers - ------------------+---------+----------- vacrelid | oid | not null enabled | boolean | not null vac_base_thresh | integer | not ...
Joshua D. Drake
Jan 17, 2008 at 9:16 pm
Mar 7, 2008 at 7:04 pm -
When we split an index page we perform a multi-block operation that is both fairly expensive and complex to reconstruct should we crash partway through. If we could log *only* the insert that caused ...
Simon Riggs
Jan 1, 2008 at 1:06 pm
Jan 8, 2008 at 7:06 am -
On Oracle: SQL select to_date('31-DEC-200700:00:00', 'dd-mon-yyyy hh24:mi:ss') from dual; TO_DATE(' --------- 31-DEC-07 On PostgreSQL: select to_date('31-DEC-200700:00:00', 'dd-mon-yyyy hh24:mi:ss'); ...
Peter Eisentraut
Jan 10, 2008 at 12:41 pm
Jan 17, 2008 at 9:16 am -
Hi, IMO, the lengthy discussion about Segment Exclusion and Segment Visibility Maps has long turned into a discussion about partitioning in general. I'm thankful for all the new insights it has ...
Markus Schiltknecht
Jan 8, 2008 at 7:08 pm
Jan 10, 2008 at 10:21 am -
I suggest one more standard date/time operator, to divide one interval by another with numeric (or float, for example) result. I.e. something like that: database=# SELECT '5400 seconds'::interval / ...
Ilya A. Kovalenko
Jan 9, 2008 at 10:34 am
Jan 10, 2008 at 7:25 am -
Some thought about bug #3847 led me to the following test case: create table t1(f1 int); create or replace function t1trig() returns trigger as $$ begin raise notice 'f1 = %', new.f1; return new; ...
Tom Lane
Jan 1, 2008 at 9:09 pm
Jun 2, 2008 at 1:59 pm -
Is it possible to authenticate using GSSAPI over the V2 protocol? Is there any documentation on the message formats for V2? Kris Jurka
Kris Jurka
Jan 29, 2008 at 8:34 am
Feb 8, 2008 at 6:24 pm -
Hello is any chance to share standard Makefile and RH Makefile? I am sorry. I don't understand to Makefile absolutely. It's look so global Makefile need some changes. Any help is welcome. Regards ...
Pavel Stehule
Jan 21, 2008 at 11:01 am
Jan 22, 2008 at 12:34 pm -
Hi, I'd like to implement some simple data logging via triggers on a small number of infrequently updated tables and I'm wondering if there are some helpful functions, plugins or idioms that would ...
Ivan Voras
Jan 26, 2008 at 5:35 pm
Jan 27, 2008 at 5:39 pm -
Hi, While translating the backend's message catalog I found several things that should probably be improved. For example, in regis.c there are several strings talking about "regis pattern". I had ...
Alvaro Herrera
Jan 20, 2008 at 12:13 am
Jan 21, 2008 at 2:59 am -
Regarding to Robert Mach's work during Google SOC on data integrity check. I would like to improve storage module and implement some Robert's code into the core. I would like to make following ...
Zdenek Kotala
Jan 25, 2008 at 4:57 pm
May 12, 2008 at 7:14 pm -
select to_char(date, 'yyyy-mm-dd hh24:mi:ss.ms') as char, date from (select timestamp'2008-01-30 15:06:21.560' as date) sub "2008-01-30 15:06:21.560";"2008-01-30 15:06:21.56" Why does the timestamp ...
Roberts, Jon
Jan 31, 2008 at 3:36 pm
Feb 1, 2008 at 1:58 am -
We previously tried to send this proposal/patch, but it never showed up. We tried twice in a 16 hour period. It might be something with the attachment, who knows. This time, we are providing a URL ...
Andrew Chernow
Jan 8, 2008 at 2:50 pm
Jan 9, 2008 at 8:11 am -
Hi everyone, I believe that there is a small bug in src/port/rint.c when the input parameter has a fractional part of 0.5 which is demonstrated by the attached program. It appears that the PG version ...
Mark Cave-Ayland
Jan 20, 2008 at 9:14 pm
Mar 25, 2008 at 12:56 pm -
Hi, I'm following the 8.3 beta releases for some time now, mostly using the Win32 with Installer package. 8.3beta3 and 4 have worked perfectly with the provided pljava ddl, just with 8.3-rc1 it ...
Jan Ischebeck
Jan 10, 2008 at 10:40 pm
Jan 22, 2008 at 3:46 am -
Hello I propose two kinds of functions: a) generic functions - this function allows any params without any implicit casting (it can implemented only in C language). This function have to have ...
Pavel Stehule
Jan 18, 2008 at 6:34 pm
Jan 20, 2008 at 10:26 pm -
http://www.scientificcomputing.com/ShowPR~PUBCODE~030~ACCT~3000000100~IS SUE~0801~RELTYPE~HPCC~PRODCODE~00000000~PRODLETT~C.html http://www.nvidia.com/object/cuda_learn.html ...
Dann Corbit
Jan 30, 2008 at 6:13 am
Jan 31, 2008 at 1:36 pm -
Hello all, I have a ~150GB sized server, containing two databases that are active in mostly read mode. I have noticed lately that the global/pgstat.stat file is somewhere around 1MB freshly after a ...
Cristian Gafton
Jan 29, 2008 at 4:39 pm
Jan 29, 2008 at 10:37 pm -
I was just noticing that $SUBJECT is hard --- the entry in current_query looks exactly like a manual vacuum command, and there's not anything in the other fields that looks different either. Since ...
Tom Lane
Jan 13, 2008 at 9:59 pm
Jan 14, 2008 at 2:24 am -
I recently noticed that SQL:200n[1] defines a new aggregate function, array_agg(). The relevant portions of the spec are: p. 66: "If ARRAY_AGG is specified, then an array value with one element ...
Neil Conway
Jan 28, 2008 at 6:11 am
Mar 25, 2008 at 2:58 am -
I came across some rather strange choices of lock levels in pg_shdepend.c. Why does shdepDropOwned() take AccessExclusiveLock on pg_shdepend? Seems like RowExclusiveLock should be sufficient. If it ...
Tom Lane
Jan 21, 2008 at 9:58 pm
Jan 28, 2008 at 11:59 pm -
Hi -hackers, While testing RC2 on the new servers of one of our customers, I found a query really slow on the new server which is quite fast on the old box currently in production (production is 8.1 ...
Guillaume Smet
Jan 22, 2008 at 6:52 pm
Jan 23, 2008 at 2:34 pm -
Who decided this part of pg_regress.c was a good idea? /* try to create the test tablespace dir if it doesn't exist */ snprintf(testtablespace, MAXPGPATH, "%s/testtablespace", abs_builddir); if ...
Tom Lane
Jan 18, 2008 at 7:33 pm
Jan 19, 2008 at 3:06 pm -
There was some discussion today about restoring pg_dump output as a non-superuser: http://archives.postgresql.org/pgsql-admin/2008-01/msg00128.php In 8.3 we have eliminated one of the major ...
Tom Lane
Jan 13, 2008 at 1:56 am
Jan 13, 2008 at 6:09 pm -
In my striving towards more effective partitioning for Postgres, I see we have one main decision to make and that all other sub-tasks are driven directly by this one issue. The issue is: At what ...
Simon Riggs
Jan 11, 2008 at 10:25 am
Jan 11, 2008 at 1:26 pm -
I am using tsearch2 with pgsql 8.2.5 and get the following error when calling to_tsvector : "translation failed from server encoding to wchar_t" My database is UTF8 encoded and the data sent to ...
Ilanco
Jan 7, 2008 at 7:22 pm
Jan 8, 2008 at 12:53 pm -
Greetings, Attached is a rather small change to src/bin/psql/describe.c to show database size and permissions when using the psql \l command. Typical output would be: List of databases Name | Owner | ...
Andrew Gilligan
Jan 20, 2008 at 1:12 am
Mar 30, 2008 at 6:11 pm -
In reading our array documentation I came across two unusual behaviors. The issue relates to slices: We can also access arbitrary rectangular slices of an array, or subarrays. An array slice is ...
Bruce Momjian
Jan 15, 2008 at 4:31 am
Mar 26, 2008 at 2:43 pm -
Greetings, In doing some test on 8.3RC2, I was dismayed to discover that the pl/pgsql plan invalidation logic added doesn't consider changing the search_path to invalidate a plan. Our case is where ...
Stephen Frost
Jan 28, 2008 at 3:17 am
Mar 26, 2008 at 2:40 am -
Whilst trying to reproduce bug #3902 I noticed that the code doesn't work with an abbreviated host name: $ psql -l -h rh2.sss.pgh.pa.us List of databases ... everything's fine ... $ psql -l -h rh2 ...
Tom Lane
Jan 28, 2008 at 12:02 am
Jan 30, 2008 at 10:27 pm -
I need to set a basic password policy for accounts but I don't see any documentation on how to do it. I'm assuming there is a way to do this, maybe even with a trigger. The policy would be something ...
Roberts, Jon
Jan 15, 2008 at 10:11 pm
Jan 22, 2008 at 5:01 pm -
Hi Simon, and Dave,Magnus. About pg_standby, a link option cause a problem in windows(XP and 2k,2k3). It is because the call of mklink is needed. Then, they are the new programs of VISTA and 2008. It ...
Hiroshi Saito
Jan 21, 2008 at 6:36 am
Jan 21, 2008 at 1:17 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 134 |
posts | 1,219 |
users | 148 |
website | postgresql.org... |
irc | #postgresql |
148 users for January 2008
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)