Re: [HACKERS] [GENERAL] Updating column on row update

2009-11-22 Thread Craig Ringer
LANGUAGE ... IF NOT EXISTS. Maybe even CREATE ROLE ... IF NOT EXISTS and CREATE USER ... IF NOT EXISTS - I know I'd find them really handy. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] [GENERAL] Updating column on row update

2009-11-22 Thread Craig Ringer
with default-installed PL/PgSQL) would be nicer and safer than having ... IF EXISTS for users/roles. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] [GENERAL] Updating column on row update

2009-11-23 Thread Craig Ringer
On 23/11/2009 11:35 PM, Tom Lane wrote: Andrew Gierth and...@tao11.riddles.org.uk writes: Tom == Tom Lane t...@sss.pgh.pa.us writes: Tom Well, that's pretty much exactly the question --- are there? It Tom would certainly make it easier for someone to exploit any other Tom security

Re: [HACKERS] draft RFC: concept for partial, wal-based replication

2009-11-29 Thread Craig Ringer
it worth mentioning as something that may be worth keeping in mind - or considering and disregarding - while looking at the WAL changes involved in partial replication. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] draft RFC: concept for partial, wal-based replication

2009-11-30 Thread Craig Ringer
tablespaces? You can't apply the changes out-of-order. Argh, good point, and one that should've been blindingly obvious. At a database level something like that may still be handy, though I haven't the foggiest how one would handle the shared system catalogs. -- Craig Ringer -- Sent via

[HACKERS] Kernel changes to O_SYNC / O_DSYNC

2009-12-16 Thread Craig Ringer
Hi folks It looks like there are some upcoming changes to the Linux kernel's handling of O_SYNC and O_DSYNC that I thought might be worth pointing out: http://lwn.net/Articles/350219/ -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Cancelling idle in transaction state

2009-12-30 Thread Craig Ringer
, there is no transaction in progress is only reported as a SQLWarning via getWarnings(), so I'd be surprised if anything used it for more than logging or debugging purposes. Are you saying that the client should send rollback and that it should generate no message? -- Craig Ringer -- Sent via pgsql-hackers

Re: [HACKERS] Thoughts on statistics for continuously advancing columns

2009-12-30 Thread Craig Ringer
for such continuously advancing columns. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Thoughts on statistics for continuously advancing columns

2009-12-30 Thread Craig Ringer
. Sorry for the noise. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] about some parameters

2010-01-01 Thread Craig Ringer
it personally, but then I don't have apps where losing the last few minutes' data is in case of failure is acceptable. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] libpq naming on Win64

2010-01-05 Thread Craig Ringer
be somewhat concerned about building and shipping libp64 with VC++ 2005. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Streaming replication and postmaster signaling

2010-01-06 Thread Craig Ringer
those (like the Debian-derived Linux distros) who already try to support more than one Pg version installed in parallel. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] libpq naming on Win64

2010-01-06 Thread Craig Ringer
to surprise or horrify any Windows developer. They're used to much, much, much worse. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] libpq naming on Win64

2010-01-06 Thread Craig Ringer
See: http://msdn.microsoft.com/en-us/library/aa376307%28VS.85%29.aspx http://msdn.microsoft.com/en-us/library/aa375155%28VS.85%29.aspx Oh, and: http://blogs.msdn.com/jonwis/archive/2005/12/28/507863.aspx -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Testing with concurrent sessions

2010-01-07 Thread Craig Ringer
and post a tool for evaluation, but if it must be plain C ... well, I'll avoid scarring you with the sight of what I'd produce. I suspect that a custom tool for this job could actually be fairly simple. A lot simpler than a proper, clean and usable parallel psql, anyway. -- Craig Ringer -- Sent

Re: [HACKERS] Testing with concurrent sessions

2010-01-09 Thread Craig Ringer
procs I have. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Streaming replication status

2010-01-11 Thread Craig Ringer
to the admin for help, something's wrong and forced to act, slave is holding up the master. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] MySQL-ism help patch for psql

2010-01-19 Thread Craig Ringer
DATABASES the help should suggest: \l - list databases; or \dn - list schema ? -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] pg_listener entries deleted under heavy NOTIFY load only on Windows

2010-01-25 Thread Craig Ringer
- but I'm worried it'll get missed again and want to make sure it doesn't.) -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] C function accepting/returning cstring vs. text

2010-01-27 Thread Craig Ringer
too. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Avoiding bad prepared-statement plans.

2010-02-27 Thread Craig Ringer
it for them, etc. So: Would it be easier to handle control of replan vs no-replan at PREPARE time? Or would that have very much the same protocol/pl change issues? -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Visual Studio 2005, C-language function - avoiding hacks?

2010-03-04 Thread Craig Ringer
triggered - so again, it makes me wonder if Pg knows it's building for win32. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Visual Studio 2005, C-language function - avoiding hacks?

2010-03-05 Thread Craig Ringer
Dave Page wrote: On Fri, Mar 5, 2010 at 4:02 AM, Craig Ringer cr...@postnewspapers.com.au wrote: Kevin Flanagan wrote: the compiler complained about various missing include files, starting with ‘libintl.h’. Having read the post at http://archives.postgresql.org/pgsql-general/2009-03

Re: [HACKERS] Visual Studio 2005, C-language function - avoiding hacks?

2010-03-05 Thread Craig Ringer
Dave Page wrote: On Fri, Mar 5, 2010 at 9:05 AM, Craig Ringer cr...@postnewspapers.com.au wrote: How do _you_ go about building server extensions for Pg? Where do you get the headers for gettext etc? Same place I get the binaries - gnuwin32 mostly. I'm increasingly thinking the win32

Re: [HACKERS] Visual Studio 2005, C-language function - avoiding hacks?

2010-03-05 Thread Craig Ringer
Dave Page wrote: On Fri, Mar 5, 2010 at 9:31 AM, Craig Ringer cr...@postnewspapers.com.au wrote: Why _not_ distribute gettext headers, though? Sources I can understand for size reasons, but the headers are small and fuss free, and you need the _right_ _versions_ to build against the Pg

Re: [HACKERS] Visual Studio 2005, C-language function - avoiding hacks?

2010-03-05 Thread Craig Ringer
on the matter. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] SQL compatibility reminder: MySQL vs PostgreSQL

2010-03-06 Thread Craig Ringer
be written as 'GROUP BY', though, isn't so clear. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] proposal: more practical view on function's source code

2010-03-21 Thread Craig Ringer
still a pain, and if the output format is to be changed it might be nice to see it change in a way that makes it easier to re-use that source listing. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] proposal: more practical view on function's source code

2010-03-21 Thread Craig Ringer
something useful with it. there is \ef statement now ... which I completely missed. My apologies; that problem is already solved. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] WIP: preloading of ispell dictionary

2010-03-23 Thread Craig Ringer
difference here. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Re: [COMMITTERS] pgsql: Add connection messages for streaming replication.

2010-03-24 Thread Craig Ringer
database template0; ERROR: database template0 already exists template1=# create database TEMPLATE0; CREATE DATABASE -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] [Fwd: [BUGS] build error: strlcat/strlcpy used from heimdal libroken.so]

2010-04-14 Thread Craig Ringer
Hi I've passed your report, and proposed fix, on to the -hackers list for consideration. Thanks for taking the time to investigate this and report it in detail. -- Craig Ringer ---BeginMessage--- Dear maintainers of PostgreSQL, Build errors for PostgreSQL have been reported on Gentoo Linux, see

Re: [HACKERS] Differential backup

2010-04-27 Thread Craig Ringer
for individual append-only tables. I was trying to figure out how to handle updates/deletes but quickly found myself completely stumped. I'd be surprised if this hasn't been looked at and put in the impossible or too hard pile, but thought it was worth mentioning on the off chance. -- Craig Ringer

Re: [HACKERS] no universally correct setting for fsync

2010-05-08 Thread Craig Ringer
-docs. It's probably worth mentioning that people who want to turn off fsync to gain a performance boost should instead look at a RAID controller with a BBU so they can safely enable write-back caching, getting most of the benefits of fsync=off safely. -- Craig Ringer -- Sent via pgsql-hackers

Re: [HACKERS] Specification for Trusted PLs?

2010-05-23 Thread Craig Ringer
directly. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Specification for Trusted PLs?

2010-05-23 Thread Craig Ringer
features that're dangerous - in fact, the core language doesn't even *have* those features. PL/PgSQL is the same, and works well as a trusted language for that reason. Java's SecurityManager is whitelist based (allowed classes, allowed operations), and has proved very secure. -- Craig Ringer

Re: [HACKERS] Patch committers

2009-11-13 Thread Craig Ringer
good patch quality. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] libpq should not be using SSL_CTX_set_client_cert_cb

2010-05-26 Thread Craig Ringer
' in terms of hostname/ip checking? It *is* possible in more sophisticated APIs (Java, NSS too I think) but it's hard to imagine client-side reasons to use it. (Or have I misunderstood what you're describing?) -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-13 Thread Craig Ringer
) but as it seems Pg generally prefers bigger headers over more little headers, I popped it in port.h . From de9a1f0e0f4ccfd8b33f37212aea61fd6ba29a89 Mon Sep 17 00:00:00 2001 From: Craig Ringer cr...@ayaki.(none) Date: Tue, 14 Dec 2010 13:47:09 +0800 Subject: [PATCH] Add support for generating a crash dump

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-15 Thread Craig Ringer
style - too much time with C++, though long ago now. I think I got the PostgreSQL rules for code formatting right, but missed the void param rule. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-16 Thread Craig Ringer
find this patch at: https://github.com/ringerc/postgres/tree/crashdump ie git://github.com/ringerc/postgres.git, branch crashdump . -- System Network Administrator POST Newspapers From b6b3052fab356971cf38a48d675c68b1767a7ad5 Mon Sep 17 00:00:00 2001 From: Craig Ringer cr...@ayaki.(none) Date

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-16 Thread Craig Ringer
BTW, related to the crash dump work: I wanted to see if I could get any integration into Windows Error Reporting for Pg, because it'd be nice to be able to use Microsoft's servers to aggregate crash reports and collect data on problems. WER (on Windows 7 and Vista) also provides automatic

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-16 Thread Craig Ringer
On 16/12/10 21:01, Magnus Hagander wrote: Found another problem in it: when running with an older version of dbghelp.dll (which I was), it simply didn't work. We need to grab the version of dbghelp.dll at runtime and pick which things we're going to dump based on that. I was about to suggest

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-17 Thread Craig Ringer
On 17/12/2010 3:46 PM, Magnus Hagander wrote: On Dec 17, 2010 8:02 AM, Craig Ringer cr...@postnewspapers.com.au mailto:cr...@postnewspapers.com.au wrote: On 16/12/10 21:01, Magnus Hagander wrote: Found another problem in it: when running with an older version of dbghelp.dll (which I

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-17 Thread Craig Ringer
be much use for a Pg compiled with Borland or the like either if that were ever supported. -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-18 Thread Craig Ringer
whether you got far into startup before crashing. -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-18 Thread Craig Ringer
\crtexe.c @ 586] 00bcf7f0 7715b495 kernel32!BaseThreadInitThunk+0xe 00bcf830 7715b468 ntdll!__RtlUserThreadStart+0x70 00bcf848 ntdll!_RtlUserThreadStart+0x1b -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-19 Thread Craig Ringer
on real-world end-user systems, and I'm aware that few Windows users will build Pg for themselves. (That said, the Perl-based build scripts are some of the least painful build tools I've ever worked with on Windows. Only CMake can rival them for low-pain Windows compilation.) -- Craig Ringer

Re: [HACKERS] Re: Proposed Windows-specific change: Enable crash dumps (like core files)

2010-12-19 Thread Craig Ringer
. If it was a security concern our fallback would be an attempt to load %WINDIR%\system32\dbghelp.dll by full path, rather than using an unqualified name to search the path. So: I agree. We should just let Windows find dbghelp.dll on the normal search path; building an explicit path isn't necessary. -- Craig

Re: [HACKERS] WIP patch: add (PRE|POST)PROCESSOR options to COPY

2012-11-14 Thread Craig Ringer
$HOME)') ); ? Something extensible would be good, as somebody is *inevitably* going to ask so how do I set environment variables before I call the command and how do I control which return values are considered success. -- Craig Ringer regards, tom lane -- Craig

Re: [HACKERS] WIP patch: add (PRE|POST)PROCESSOR options to COPY

2012-11-14 Thread Craig Ringer
, and to leave room for extending the syntax for environment, separate args vector, etc when they're called for. Like VACUUM, where VACUUM VERBOSE ANALYZE became VACUUM (VERBOSE, ANALYZE) to make room for (BUFFERS), etc. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development

Re: [HACKERS] feature proposal - triggers by semantics

2012-11-15 Thread Craig Ringer
to have, and both options can be given explicitly to override any config option. What advantage would that have over using DELETE when you want DELETE, and TRUNCATE when you want TRUNCATE? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support

Re: [HACKERS] Doc patch making firm recommendation for setting the value of commit_delay

2012-11-15 Thread Craig Ringer
hardware, and slow down initdb (and thus testing). I'd be all for making it part of a test my hardware and tune my DB tool, but not such a fan of doing it at initdb time. Making initdb less predictable and more complicated sounds like asking for trouble. -- Craig Ringer http://www

Re: [HACKERS] feature proposal - triggers by semantics

2012-11-15 Thread Craig Ringer
On 11/15/2012 06:25 PM, Hannu Krosing wrote: On 11/15/2012 09:48 AM, Craig Ringer wrote: If you want to prevent TRUNCATE, deny the privilege or add a trigger that aborts the command. You can abort the transaction but not skip action as currently it is only possible to skip in ROW level

Re: [HACKERS] another idea for changing global configuration settings from SQL

2012-11-15 Thread Craig Ringer
significant pg_catalog hacking expertise to pull out user-specific settings. A system information function like settings_for_user('username') would certainly be welcome, showing: setting_name setting_valuesetting_origin -- Craig Ringer http://www.2ndQuadrant.com

Re: [HACKERS] feature proposal - triggers by semantics

2012-11-15 Thread Craig Ringer
, with results I'd expect to be both faster and simpler. I can see using the same facility to optimise foreign key validity checks in the absence of an index on the foreign key column, too. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training

Re: [HACKERS] WIP patch: add (PRE|POST)PROCESSOR options to COPY

2012-11-15 Thread Craig Ringer
users and feed them into a superuser command they already have security problems. I'd still be much happier to have COPY ... FROM PROGRAM - or something - to clearly make the two different, for clarity as much as security. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL

Re: [HACKERS] Timing events WIP v1

2012-11-16 Thread Craig Ringer
understood by client applications. Not that implementing `hstore_to_json` is exactly hard, mind you, as a quick search shows: https://gist.github.com/2318757 -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [HACKERS] Parser - Query Analyser

2012-11-18 Thread Craig Ringer
as CREATE TABLE and INSERT statements, mock output, explanation of how you'd get that output, what problem you're trying to solve, etc. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Parser - Query Analyser

2012-11-18 Thread Craig Ringer
with the 'CREATE TYPE' and 'CREATE FUNCTION' commands in order to see what I can get out of them! I have replied on pgsql-general. Please do not top-post, and reply to the list not directly to me. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support

Re: [HACKERS] Timing events WIP v1

2012-11-20 Thread Craig Ringer
On 11/20/2012 04:48 PM, Pavel Stehule wrote: 2012/11/20 Greg Smith g...@2ndquadrant.com: On 11/16/12 12:20 AM, Craig Ringer wrote: Not that implementing `hstore_to_json` is exactly hard, mind you, as a quick search shows: https://gist.github.com/2318757 Both pulling hstore more firmly

[HACKERS] Master fails to build without ldap headers

2012-12-03 Thread Craig Ringer
aa2fec0a18e4d23272c78916ef318078c920611a Author: Peter Eisentraut pete...@gmx.net Date: Mon Dec 3 23:29:56 2012 -0500 Add support for LDAP URLs Allow specifying LDAP authentication parameters as RFC 4516 LDAP URLs. -- Craig Ringer http://www.2ndQuadrant.com

[HACKERS] Fix fmgroids.h not regenerated after clean (not clean dist) on Windows

2012-12-11 Thread Craig Ringer
patch fixes the issue. -- Craig Ringer From 29aa537a8e5ef50f620e104eb98bca74538b5ac7 Mon Sep 17 00:00:00 2001 From: Craig Ringer ring...@ringerc.id.au Date: Thu, 6 Dec 2012 03:25:17 -0800 Subject: [PATCH] Win32: replace fmgroids.h if removed by clean.bat Fix a win32 build issue clean.bat was removing

[HACKERS] [PATCH] Change Windows build docs to point to flex and bison from msys

2012-12-30 Thread Craig Ringer
to find out about the issue. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services From 1430b3df7f571a4bc27e39bf3d64810e0e7c2900 Mon Sep 17 00:00:00 2001 From: Craig Ringer ring...@ringerc.id.au Date: Mon, 31 Dec 2012 14:46:40 +0800

Re: [HACKERS] Problematic dependency in plpython Makefile [Windows]

2013-01-02 Thread Craig Ringer
msys make from mingw? I'm a bit puzzled as to why you'd be using cygwin make. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Bug: Windows installer modifies ACLs on the whole volume

2013-01-10 Thread Craig Ringer
a full list of installed software, service packs, etc, along with the exact Windows version. I've CC'd Sandeep at EnterpriseDB, who IIRC is looking after the installer at the moment. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training

Re: [HACKERS] CF3+4 (was Re: Parallel query execution)

2013-01-16 Thread Craig Ringer
On 01/16/2013 10:02 PM, Stephen Frost wrote: * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: I would like to nominate Craig Ringer to be independent CF mgr for Jan2013 CF. Seconded. I particularly like the fact that Craig is not already a PG developer, so he's not going to be working

Re: [HACKERS] CF3+4 (was Re: Parallel query execution)

2013-01-16 Thread Craig Ringer
On 01/16/2013 08:12 PM, Simon Riggs wrote: I would like to nominate Craig Ringer to be independent CF mgr for Jan2013 CF. I'm happy to step up and help out. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via

Re: [HACKERS] CF3+4 (was Re: Parallel query execution)

2013-01-16 Thread Craig Ringer
On 01/17/2013 06:01 AM, Robert Haas wrote: On Wed, Jan 16, 2013 at 12:36 PM, Josh Berkus j...@agliodbs.com wrote: I would like to nominate Craig Ringer to be independent CF mgr for Jan2013 CF. +1, although I'll suggest that we should have *two* CF managers for this one to keep the workload

Re: [HACKERS] CF3+4

2013-01-16 Thread Craig Ringer
is gone, whether truly finished or not, and if everyone's OK with it I'd like to move all open work into 2013-01, close 2012-11, and open 2013-03 for post-9.3 work. That'll at least provide a place for post-9.3 patches and consolodate everything for somewhat easier tracking. -- Craig Ringer

Re: [HACKERS] CF3+4

2013-01-17 Thread Craig Ringer
for aliveness and start chasing things up; in the mean time, any chance of closing 2012-11? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [HACKERS] PATCH: optimized DROP of multiple tables within a transaction

2013-01-17 Thread Craig Ringer
;h=279628a0a7cf582f7dfb68e25b7b76183dd8ff2f Flagged as committed. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

[HACKERS] Status of patches

2013-01-17 Thread Craig Ringer
. I'm in the process of going through the backlog, but there's a lot of it, and anyone who can update their own work directly would be making a significant contribution by making it much easier to chase up live, in-progress work. -- Craig Ringer http://www.2ndQuadrant.com

Re: [HACKERS] Event Triggers: adding information

2013-01-17 Thread Craig Ringer
if we can give this the same kind of compatibility requirements, where it must not break within a given major version but may break between them. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers

Re: [HACKERS] Event Triggers: adding information

2013-01-17 Thread Craig Ringer
they didn't know? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Event Triggers: adding information

2013-01-17 Thread Craig Ringer
On 01/18/2013 10:34 AM, Andres Freund wrote: On 2013-01-18 10:31:28 +0800, Craig Ringer wrote: On 01/18/2013 09:33 AM, Andres Freund wrote: I have no problem requiring C code to use the even data, be it via hooks or via C functions called from event triggers. The problem I have with putting

[HACKERS] Writable Foreign Tables

2013-01-17 Thread Craig Ringer
. Is anyone willing to commit this or do you want further testing? https://commitfest.postgresql.org/action/patch_view?id=919 -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [HACKERS] Move postgresql_fdw_validator into dblink

2013-01-17 Thread Craig Ringer
-- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

[HACKERS] Variadic any fix

2013-01-17 Thread Craig Ringer
it for 9.3? https://commitfest.postgresql.org/action/patch_view?id=970 I've pushed it to my GitHub in case that's easier than applying the patch: https://github.com/ringerc/postgres/tree/variadic_functions_any -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development

[HACKERS] FOR KEY SHARE patch ready to commit?

2013-01-17 Thread Craig Ringer
should be commited with it. Any chance of committing? https://commitfest.postgresql.org/action/patch_view?id=987 -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [HACKERS] Patch for removng unused targets

2013-01-18 Thread Craig Ringer
any headway on this? Is there work in a state that's likely to be committable for 9.3, or is it perhaps best to defer this to post-9.3 pending further work and review? https://commitfest.postgresql.org/action/patch_view?id=980 -- Craig Ringer http://www.2ndQuadrant.com

Re: [HACKERS] WIP patch for hint bit i/o mitigation

2013-01-18 Thread Craig Ringer
if possible. I think if we can improve performance for bulk-insert case, then this patch has much more value. Has there been any movement in this - more benchmarks and data showing that it really does improve performance, or that it really isn't helpful? -- Craig Ringer http

Re: [HACKERS] WIP patch for hint bit i/o mitigation

2013-01-20 Thread Craig Ringer
time as they say :-). Amen. OK, bumped to the next CF. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Making testing on Windows easier

2013-01-20 Thread Craig Ringer
be adding git URLs and branch names to the commitfest app, so it could ping a continuous integration server to build-test any new patch added to the CF. Right now I'm doing that manually when I have time, but it's slow going. -- Craig Ringer http://www.2ndQuadrant.com

Re: [HACKERS] Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]

2013-01-20 Thread Craig Ringer
sure that libpq works on Cygwin, but is there any reason at all to run a Pg server backend on Cygwin rather than as native Windows binaries? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing

Re: [HACKERS] Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]

2013-01-20 Thread Craig Ringer
On 01/21/2013 10:03 AM, Craig Ringer wrote: On 01/19/2013 04:08 AM, Boszormenyi Zoltan wrote: However, I am not sure whether Cygwin provides the mkstemp() call or not. Searching... Found bugzilla reports against mkstemp on Cygwin. Is Cygwin a platform that should be targeted for the server

Re: [HACKERS] How to build contrib module separately in PostgreSQL on windows

2013-01-20 Thread Craig Ringer
the whole PostgreSQL from source code. But it is not convenient. As far as I know it's your best option right now. I've tried to make it a bit more convenient with this code and documentation: https://github.com/2ndQuadrant/pg_build_win -- Craig Ringer http://www

Re: [HACKERS] Contrib PROGRAM problem

2013-01-20 Thread Craig Ringer
hosted instances with bundled licenses are available for peanuts or you can download a Windows DVD and install it in a KVM instance if you have a license sticker sticking to a now-running-Linux box somewhere. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development

Re: [HACKERS] patch to add \watch to psql

2013-01-20 Thread Craig Ringer
. Windows doesn't have line-editing (sadly) so it won't do anything at all. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] dividing privileges for replication role.

2013-01-20 Thread Craig Ringer
that entry up to date with any revised patches you get and any reviews people write that will be rather helpful. I'll keep an eye on it and update it when I see something change, but you're paying attention to this one patch so you'll notice first. -- Craig Ringer http://www

Re: [HACKERS] [WIP] pg_ping utility

2013-01-20 Thread Craig Ringer
? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Visual Studio 2012 RC

2013-01-21 Thread Craig Ringer
Visual Studio, the SDK, and service pack, then reinstall the newer runtime to get the programs that require it to work again. I've written more about both of these in the TROUBLESHOOTING section of https://github.com/2ndQuadrant/pg_build_win/blob/master/README.md -- Craig Ringer

Re: [HACKERS] parallel pg_dump

2013-01-21 Thread Craig Ringer
assistance as I have build environments set up for a variety of Windows compiler variants. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Visual Studio 2012 RC

2013-01-21 Thread Craig Ringer
On 01/21/2013 07:23 PM, Noah Misch wrote: What fun. Thanks for working that out. It's made even more fun by Microsoft's answer to how do I silent-install the VS 2012 SP1 compiler update - you don't. Yeah, it's great. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL

Re: [HACKERS] parallel pg_dump

2013-01-21 Thread Craig Ringer
On 01/21/2013 06:02 PM, Craig Ringer wrote: On 12/09/2012 04:05 AM, Bruce Momjian wrote: FYI, I will be posting pg_upgrade performance numbers using Unix processes. I will try to get the Windows code working but will also need help. I'm interested ... or at least willing to help ... re

Re: [HACKERS] Making testing on Windows easier

2013-01-21 Thread Craig Ringer
On 01/21/2013 08:55 PM, Noah Misch wrote: On Mon, Jan 21, 2013 at 10:01:29AM +0800, Craig Ringer wrote: I've found EC2 to be unusably slow for Windows builds, with a medium instance taking an hour and a half to do a simple build and vcregress check. They're also restrictive in disk space terms

Re: [HACKERS] Visual Studio 2012 RC

2013-01-21 Thread Craig Ringer
On 01/21/2013 08:44 PM, Andrew Dunstan wrote: On 01/21/2013 04:32 AM, Craig Ringer wrote: On 01/01/2013 10:54 AM, Noah Misch wrote: On Mon, Oct 15, 2012 at 07:53:51AM -0400, Noah Misch wrote: The only matter still requiring attention is a fix for IsoLocaleName(). Following off-list

Re: [HACKERS] Patch for removng unused targets

2013-01-21 Thread Craig Ringer
On 01/22/2013 01:24 PM, Etsuro Fujita wrote: I'd like to rework on this optimization and submit a patch at the next CF. Is that okay? That sounds very sensible to me, given how busy CF2013-01 is and the remaining time before 9.3. -- Craig Ringer http://www.2ndQuadrant.com

Re: [HACKERS] Patch: clean up addRangeTableEntryForFunction

2013-01-22 Thread Craig Ringer
, reducing the call to a Single Point of Truth for lateral-ness, very likely improving the efficiency of calls to that function. Added to CF 2013-next. https://commitfest.postgresql.org/action/patch_view?id=1073 -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development

[HACKERS] .gitignore additions

2013-01-22 Thread Craig Ringer
Hi all Would a committer be willing to pop some entries in .gitignore for Windows native build outputs? *.sln *.vcproj *.vcxproj It'd make life easier when testing Windows changes. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training

  1   2   3   4   5   6   7   8   9   10   >