On 18 January 2013 21:01, Tom Lane t...@sss.pgh.pa.us wrote:
Andres Freund and...@2ndquadrant.com writes:
On 2013-01-18 15:37:47 -0500, Tom Lane wrote:
I doubt it ever came up before. What use is logging only the content of
a buffer page? Surely you'd need to know, for example, which
On Fri, Jan 18, 2013 at 1:05 PM, Heikki Linnakangas
hlinnakan...@vmware.com wrote:
On 18.01.2013 13:41, Amit Kapila wrote:
On Friday, January 18, 2013 3:46 PM Heikki Linnakangas wrote:
On 18.01.2013 08:50, Amit Kapila wrote:
I think currently user has no way to specify TCP keepalive
On Fri, Jan 18, 2013 at 2:43 PM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Heikki Linnakangas hlinnakan...@vmware.com writes:
You could still use environment variables and a service file to do it, but
it's certainly more cumbersome. It clearly should be possible to pass a full
connection
On Friday, January 18, 2013 5:27 PM Heikki Linnakangas wrote:
Indeed, looking at the pg_xlog, it's not there (I did a couple of extra
timeline switches:
~/pgsql.master$ ls -l data-master/pg_xlog/
total 131084
-rw--- 1 heikki heikki 16777216 Jan 18 13:38 00010001
On 19 January 2013 13:45, Kohei KaiGai kai...@kaigai.gr.jp wrote:
I think, it is a time to investigate separation of database superuser
privileges
into several fine-grained capabilities, like as operating system doing.
Hi,
I change some code of extension cube in PostgreSQL to do some experiments.
The problem is that I want to make these changed code effective, and I am not
sure how to build it on windows.
After downloading the source code, I enter the postgresql-9.2.2\contrib\cube
to type 'nmake' with VS2010
On 01/19/2013 10:09 AM, 朱冯贶天 wrote:
Hi,
I change some code of extension cube in PostgreSQL to do some
experiments.
The problem is that I want to make these changed code effective, and I
am not sure how to build it on windows.
After downloading the source code, I enter the
On Sat, Jan 19, 2013 at 11:20:19AM -0500, Kevin Grittner wrote:
Bruce Momjian wrote:
I am wondering if we should make this query more widely used, perhaps by
putting it in our docs about reporting bugs, or on our website.
http://wiki.postgresql.org/wiki/Server_Configuration
Bruce Momjian br...@momjian.us writes:
I am wondering if we should make this query more widely used, perhaps by
putting it in our docs about reporting bugs, or on our website.
I find the manual exclusion list to be poor style, and not at all
future-proof. Maybe we could use
select name,
Andrew Dunstan and...@dunslane.net writes:
*sigh*. Don't post after midnight. Of course, this isn't relevant to a
cross-compiling environment, where repeated invocations of make
repeatedly build the executables.
The question is whether we care enough about this case to fix it.
I think we
On Jan 19, 2013 10:55 AM, Jon Erdman postgre...@thewickedtribe.net
wrote:
I did realize that since I moved it to + the doc should change, but I
didn't address that. I'll get on it this weekend.
As far as the column name and displayed values go, they're taken from the
CREATE FUNCTION syntax,
Magnus Hagander mag...@hagander.net writes:
FWIW, +1. I would consider it a bugfix (backpatch, etc).
While it's a feature I'd very much like to see, I really don't think
you can consider it a bugfix. It's functionality that was left out -
it's not like we tried to implement it and it didn't
Tom Lane wrote:
I find the manual exclusion list to be poor style, and not at all
future-proof. Maybe we could use
select name, setting, source from pg_settings
where source not in ('default', 'override');
This would print a few not-all-that-interesting settings made by initdb,
but not
Hello
2013/1/18 Tom Lane t...@sss.pgh.pa.us:
Stephen Frost sfr...@snowman.net writes:
[ quick review of patch ]
On reflection it seems to me that this is probably not a very good
approach overall. Our general theory for functions taking ANY has
been that the core system just computes the
* Tom Lane (t...@sss.pgh.pa.us) wrote:
I committed this with a couple of changes:
Great, thanks!
* I used GetLatestSnapshot rather than GetTransactionSnapshot. Since
we don't allow these operations inside transaction blocks, there
shouldn't be much difference, but in principle
* Phil Sorber (p...@omniti.com) wrote:
Stephen, I think Jon's column name and values make a lot of sense.
a'ight. I can't think of anything better.
Thanks,
Stephen
signature.asc
Description: Digital signature
Pavel,
While I certainly appreciate your enthusiasm, I don't think this is
going to make it into 9.3, which is what we're currently focused on.
I'd suggest that you put together a wiki page or similar which
outlines how this is going to work and be implemented and it can be
discussed
On Sat, Jan 19, 2013 at 12:58:35PM -0500, Kevin Grittner wrote:
Tom Lane wrote:
I find the manual exclusion list to be poor style, and not at all
future-proof. Maybe we could use
select name, setting, source from pg_settings
where source not in ('default', 'override');
This
2013/1/19 Stephen Frost sfr...@snowman.net:
Pavel,
While I certainly appreciate your enthusiasm, I don't think this is
going to make it into 9.3, which is what we're currently focused on.
I'd suggest that you put together a wiki page or similar which
outlines how this is going to
Tom Lane t...@sss.pgh.pa.us writes:
I don't think that argument holds any water at all. There would still
be differences in command line argument capabilities out there ---
they'd just be between minor versions not major ones. That's not any
easier for people to deal with. And what will you
On 01/19/2013 02:36 AM, Boszormenyi Zoltan wrote:
Cross-compiling is not really a supported platform. Why don't you
just build natively? This is know to work as shown by the buildfarm
animals doing it successfully.
Because I don't have a mingw setup on Windows. (Sorry.)
A long time
Pavel Stehule pavel.steh...@gmail.com writes:
2013/1/18 Tom Lane t...@sss.pgh.pa.us:
The approach is also inherently seriously inefficient. ...
What is important - for this use case - there is simple and perfect
possible optimization - in this case non variadic manner call of
variadic any
Bruce Momjian br...@momjian.us writes:
Tom Lane wrote:
select name, setting, source from pg_settings
where source not in ('default', 'override');
Here is my very wide output:
Why are you insisting on cramming version() into this? It could
just as easily be a different query.
On Sat, Jan 19, 2013 at 03:29:36PM -0500, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Tom Lane wrote:
select name, setting, source from pg_settings
where source not in ('default', 'override');
Here is my very wide output:
Why are you insisting on cramming version() into
On Wed, Nov 14, 2012 at 08:44:26PM +, Peter Geoghegan wrote:
http://commit-delay-results-ssd-insert.staticloud.com
http://commit-delay-stripe-insert.staticloud.com
http://commit-delay-results-stripe-tpcb.staticloud.com
2013/1/19 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
2013/1/18 Tom Lane t...@sss.pgh.pa.us:
The approach is also inherently seriously inefficient. ...
What is important - for this use case - there is simple and perfect
possible optimization - in this case non
On Thursday, January 17, 2013, Magnus Hagander wrote:
Would it help to step up a few developers and create a second line of
committers ? The commits by the second line committers will still be
reviewed by the first line committers before they make into the product,
but
may be at later
Josh Kupershmidt schmi...@gmail.com writes:
It seems the queries in ./src/tutorial/syscat.source use string
escaping with the assumption that standard_conforming_strings is off,
and thus give wrong results with modern versions. A simple fix is
attached.
I tweaked the comments a little bit and
On 13-01-09 03:07 PM, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
Well, I *did* benchmark it as noted elsewhere in the thread, but thats
obviously just machine (E5520 x 2) with one rather restricted workload
(pgbench -S -jc 40 -T60). At least its rather palloc heavy.
Here are
2013/1/18 Amit kapila amit.kap...@huawei.com:
Please find the rebased Patch for Compute MAX LSN.
The function 'remove_parent_refernces' couldn't be called
'remove_parent_references' ?
Why not an extension in PGXN instead of a contrib?
Regards,
--
Dickson S. Guedes
mail/xmpp:
2013/1/17 Alvaro Herrera alvhe...@2ndquadrant.com:
Kohei KaiGai escribió:
This attached patch is the rebased one towards the latest master branch.
Great, thanks. I played with it a bit and it looks almost done to me.
The only issue I can find is that it lets you rename an aggregate by
On Wednesday, January 9, 2013, Noah Misch wrote:
On Thu, Jan 10, 2013 at 02:45:36AM +, Simon Riggs wrote:
On 8 January 2013 02:49, Noah Misch n...@leadboat.com javascript:;
wrote:
There is a bug in lazy_scan_heap()'s
bookkeeping for the xid to place in that WAL record. Each call to
Pavan Deolasee pavan.deola...@gmail.com writes:
Sorry for posting on such an old thread. But here is a patch that
fixes this. I'm also adding to the next commitfest so that we don't
lose track of it again.
As submitted, this broke pg_dump for dumping from pre-8.0 servers.
(7.4 didn't accept
On 01/19/2013 02:51 AM, Boszormenyi Zoltan wrote:
Yes it rings a bell. See
http://people.planetpostgresql.org/andrew/index.php?/archives/264-Cross-compiling-PostgreSQL-for-WIndows.html
I wanted to add a comment to this blog entry but it wasn't accepted.
The blog is closed for comments. I
Kyotaro,
Are you planning to update this patch based on Heikki's comments? The
patch is listed in the commitfest and we're trying to make some
progress through all of those patches.
Thanks,
Stephen
* Heikki Linnakangas (hlinn...@iki.fi) wrote:
On 12.11.2012
Can someone comment on the attached patch? pg_upgrade was testing if
system() returned a non-zero value, while I am thinking I should be
adjusting system()'s return value with WEXITSTATUS().
Is there any possible bug in back branches just compariing system()'s
turn value to non-zero without
subscribe
end
On 13-01-14 08:38 PM, Andres Freund wrote:
Hi everyone,
Here is the newest version of logical changeset generation.
2) Currently the logical replication infrastructure assigns a 'slot-id'
when a new replica is setup. That slot id isn't really nice
(e.g. id-321578-3). It also requires that
The correct NULL check should use `*newval'; `newval' must be non-null.
---
src/backend/utils/cache/ts_cache.c |2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/src/backend/utils/cache/ts_cache.c
b/src/backend/utils/cache/ts_cache.c
index e688b1a..65a8ad7 100644
---
Don't write past the end of tborder; the size is width + 1.
---
src/interfaces/libpq/fe-print.c |2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/src/interfaces/libpq/fe-print.c b/src/interfaces/libpq/fe-print.c
index 076e1cc..7ed489a 100644
---
On Sunday, January 20, 2013 4:04 AM Dickson S. Guedes wrote:
2013/1/18 Amit kapila amit.kap...@huawei.com:
Please find the rebased Patch for Compute MAX LSN.
The function 'remove_parent_refernces' couldn't be called
'remove_parent_references' ?
Shall fix this.
Why not an extension in PGXN
Intel's icc and PathScale's pathcc compilers optimize away several
overflow checks, since they consider signed integer overflow as
undefined behavior. This leads to a vulnerable binary.
Currently we use -fwrapv to disable such (mis)optimizations in gcc,
but not in other compilers.
Examples
42 matches
Mail list logo