PgSql
in [SQL]
|
[HACKERS] permission inconsistency with functions Hello, I am writing a blog on backups with postgresql, which I plan at some point (if someone doesn't beat me to it) on turning into a patch for the docs but I found this inconsistency: The docs state that: "In particular, it must have read access to all tables that you want to back up, so in practice you a... 23 Jul 2010 18:02
non-overlapping, consecutive partitions On 7/23/2010 11:04 PM, Hans-J�rgen Sch�nig wrote: does anybody see a solution to this problem? what are the main showstoppers to make something like this work? I think we should absolutely make this work when we have a good partitioning implementation. That said, I don't think it's wise to put a lot of ef... 30 Jul 2010 16:21
[HACKERS] non-overlapping, consecutive partitions hello everybody, i have just come across some issue which has been bugging me for a while. consider: SELECT * FROM foo ORDER BY bar; if we have an index on bar, we can nicely optimize away the sort step by consulting the index - a btree will return sorted output. under normal circumstances it will be seq->s... 23 Jul 2010 16:56
CommitFest 2010-07 week one progress report Markus Wanner <markus(a)bluegap.ch> wrote: On 07/22/2010 08:51 PM, Robert Haas wrote: It seems to me that the discussion is Alvaro and I are having with Markus is tilted toward having Markus rewrite the imessages interface to use an SLRU, in which case neither of them will go in this CF. I'm hopeful... 29 Jul 2010 11:53
[HACKERS] reminder... beta4 is coming I've just added a couple of recently-reported bugs here: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items These aren't all 9.0-specific, but we still need to fix them. Also, the steady trickle of 9.0 bug reports that we were getting before seems to have dried up. Does that mean there are no more bug... 23 Jul 2010 16:56
Rewrite, normal execution vs. EXPLAIN ANALYZE On Fri, Jul 23, 2010 at 3:31 PM, David Fetter <david(a)fetter.org> wrote: On Fri, Jul 23, 2010 at 03:30:03PM -0400, Robert Haas wrote: On Fri, Jul 23, 2010 at 3:19 PM, Marko Tiikkaja <marko.tiikkaja(a)cs.helsinki.fi> wrote: This may be a bit hard to follow, but essentially what happens is that in EXP... 4 Aug 2010 16:54
patch: Add JSON datatype to PostgreSQL (GSoC, WIP) On Fri, Jul 23, 2010 at 2:34 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: - elog() must be used except for "can't happen" situations. �Compare the way numeric_in() throws an error message versus json_in(). Er... that should have said "elog() must NOT be used except for can't happen situations". Also, I w... 25 Jul 2010 02:18
including backend ID in relpath of temp rels - updated patch On Thu, Jun 10, 2010 at 3:39 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: I believe that this patch will clear away one major obstacle to implementing global temporary and unlogged tables: it enables us to be sure of cleaning up properly after a crash without relying on catalog entries or XLOG. Bas... 5 Aug 2010 19:10
ALTER TABLE...ALTER COLUMN vs inheritance --On 16. Juni 2010 14:31:00 +0200 Bernd Helmle <mailings(a)oopsware.de> wrote: There are some spelling and grammar errors in comments that I can help fix if you want the help. You're welcome. I have pushed my branch to my git repos as well, if you like to start from there: <http://git.postgre... 23 Jul 2010 03:48
SQL/MED security 2010/7/22 Pavel Stehule <pavel.stehule(a)gmail.com>: I see a SQL/MED security very unclean - it have to be very vell documented :( ERROR: password is required DETAIL: Non-superuser cannot connect if the server does not request a password. The security model of current FDW heavily depends on implementation o... 23 Jul 2010 02:43 |