that all exhibit the same
behavior) and yes I've done ANALYZE and VACUUM and the
behavior doesn't change.
--
Bill Moran
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
sources of major
> bugs or instabilities in PostgreSQL 9.6.
Wow ... this may be the most unusual survey I've seen in a while.
--
Bill Moran
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
he problem is that the second error
masks the first one, hiding the real cause of the connection
failure, and causing a lot of confusion.
If we could keep both errors and report them both, I feel like
it would be an improvement to our client library behavior.
--
Bill Moran
--
Sent via pgs
you decide to
start actually writing code, please contact me so we don't double
up on the work.
--
Bill Moran
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
table.
Just my $.02 ...
--
Bill Moran
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
machine named localhost.
On posix systems, it's cusomary to put multiple names in the hosts file,
localhost included. I expect that Windows is the same, but I haven't used
it in so long that I can't be sure.
--
Bill Moran
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
On Wed, 4 Nov 2015 13:07:09 +0800
Craig Ringer <cr...@2ndquadrant.com> wrote:
> On 4 November 2015 at 10:58, Bill Moran <wmo...@potentialtech.com> wrote:
> > On Tue, 3 Nov 2015 18:34:39 -0800
> > Jeff Janes <jeff.ja...@gmail.com> wrote:
> >
> >>
one: https://github.com/williammoran/postgres
--
Bill Moran
diff -r --exclude=.git --exclude=src/test --exclude=README postgres_head/doc/src/sgml/config.sgml postgres_new/doc/src/sgml/config.sgml
6708a6709,6773
>
> TOAST
>
>
>
>
>
On Tue, 3 Nov 2015 18:34:39 -0800
Jeff Janes <jeff.ja...@gmail.com> wrote:
> On Tue, Nov 3, 2015 at 5:21 PM, Craig Ringer <cr...@2ndquadrant.com> wrote:
> > On 3 November 2015 at 23:04, Bill Moran <wmo...@potentialtech.com> wrote:
> >>
> >> Looking
See subject. Aside from them being divvied up by datatype, they seem
to be ordered randomly. Since I'm putting together a patch that will
add some GUCs, do I just add them to the end of the list?
--
Bill Moran
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
On Wed, 28 Oct 2015 16:58:30 -0400
Peter Eisentraut <pete...@gmx.net> wrote:
> On 10/28/15 10:27 AM, Bill Moran wrote:
> > See subject. Aside from them being divvied up by datatype, they seem
> > to be ordered randomly. Since I'm putting together a patch that will
> > a
rsy by actually rewording
> into the plural, where possible?
>
> So
>
> "any user can make such a change for his session."
>
> becomes
>
> "Users can make such a change for their individual sessions"
>
> or similar?
+1
As an American/
action you actually want to trigger, and call that
second in your background worker.
Cheers,
David.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
Bill Moran wmo
If not, I'm going to make a little personal project of them for myself
(targeting 9.6).
--
Bill Moran
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sat, 25 Jul 2015 11:39:15 -0700
Josh Berkus j...@agliodbs.com wrote:
On 07/25/2015 07:05 AM, Bill Moran wrote:
If not, I'm going to make a little personal project of them for myself
(targeting 9.6).
Nope. In fact, even the one which was 90% complete (replacing zlib with
lz4
On Sat, 25 Jul 2015 16:06:28 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Bill Moran wmo...@potentialtech.com writes:
On Sat, 25 Jul 2015 11:39:15 -0700
Josh Berkus j...@agliodbs.com wrote:
Nope. In fact, even the one which was 90% complete (replacing zlib with
lz4) completely dropped off
is the only example that
comes to mind, but it's a pretty common language) which may cause numbers
formatted thusly to be included in queries without the programmers prior
realization.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql
...
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
In response to Jeff Janes jeff.ja...@gmail.com:
On Fri, Dec 17, 2010 at 12:16 PM, Bill Moran wmo...@potentialtech.com wrote:
In response to Tom Lane t...@sss.pgh.pa.us:
Josh Berkus j...@agliodbs.com writes:
postgres=# select '1e+01'::Integer
postgres-# ;
ERROR: invalid input
walking.
When the decision is made to remove the standard_conforming_string
config option altogether ... that'll be a different story!
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
in for a few more releases until newer versions of FreeBSD are the
standard.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
ulimit?
I have a hard time believing that Windows doesn't have a ulimit equivalent.
I don't want to degrade this thread into MS-bashing, but if that were the
case, it would make Windows a pretty crippled OS.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran
irrelevant. Note the paragraph
that I didn't snip where Albe points this out.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
the party? ;)
In any event, happy birthday.
--
Bill Moran
http://www.potentialtech.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
for a long time
they didn't have proper foreign keys and referential integrity.
With proper foreign keys and ON DELETE CASCADE, why would supporting
such syntax even be necessary?
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-hackers
with a methodology for this is non-trivial, though.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
and
add users to the group as appropriate.
--
Bill Moran
http://www.potentialtech.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
In response to to...@tuxteam.de:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, Apr 23, 2009 at 10:38:55AM -0400, Bill Moran wrote:
[...]
It's possible that this could be accomplished by something like Veil,
or the built-in implementation that's coming in some future version
In response to to...@tuxteam.de:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, Apr 23, 2009 at 01:31:39PM -0700, Marc Munro wrote:
[...]
In principle it could be used in the way that Bill Moran suggests though
I have never used it that way. I am somewhat suspicious
queries to encrypted fields. Since each user has their own
key, the data is protected from all sorts of priv escalations, theft,
etc (really, just about every attack vector aside from password brute
forcing and social engineering ... and those will require other
methods of protection anyway.)
--
Bill
In response to to...@tuxteam.de:
On Thu, Apr 23, 2009 at 10:38:55AM -0400, Bill Moran wrote:
[...]
It's possible that this could be accomplished by something like Veil,
Veil? Care to share an URL?
Google knows :)
http://veil.projects.postgresql.org/curdocs/index.html
--
Bill Moran
it to create a utf8 encoded
database ...
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
In response to Tom Lane t...@sss.pgh.pa.us:
Bill Moran wmo...@potentialtech.com writes:
In response to Tom Lane t...@sss.pgh.pa.us:
We should presumably let the encoding be changed when cloning
from template0, and probably it's reasonable to trust the user
if either source or destination
people.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
query, on production systems, without too much
disruption of the rest of the work that's going on:
set log_temp_files = 0;
run suspect query
set log_temp_files = -1;
investigate logs
At least, those are my current plans ...
--
Bill Moran
Collaborative Fusion Inc
In response to Tom Lane [EMAIL PROTECTED]:
Bill Moran [EMAIL PROTECTED] writes:
Andrew Dunstan [EMAIL PROTECTED] wrote:
Might be more robust to say
if (trace_temp_files = 0)
I specified in the GUC config that minimum allowable value is -1.
I'd still tend to go with Andrew's
In response to Simon Riggs [EMAIL PROTECTED]:
On Tue, 2007-01-02 at 18:20 -0500, Tom Lane wrote:
Bill Moran [EMAIL PROTECTED] writes:
In response to Alvaro Herrera [EMAIL PROTECTED]:
Please change things to save the stat() syscall when the feature is not
in use.
Do you have
adding a GUC variable to submit a patch to allow tracing temp file
usage. Do I need to add it to both?
--
Bill Moran
Collaborative Fusion Inc.
---(end of broadcast)---
TIP 6: explain analyze is your friend
In response to Andrew Dunstan [EMAIL PROTECTED]:
Bill Moran wrote:
I see the above-mentioned files in src/backend/utils/misc. A diff shows
the following:
$ diff postgresql.conf.sample.orig postgresql.conf.sample
223a224
log_destination = 'syslog'
302a304
something such as file sparseness? Is this entire endeavour
doomed from the start? Or am I just making some sort of dumb mistake?
Any pointers are welcome.
--
Bill Moran
Collaborative Fusion Inc.
diff -r src.orig/backend/storage/file/fd.c src/backend/storage/file/fd.c
52a53
#include utils
Bruce Momjian wrote:
Bill Moran wrote:
Hey all,
I hope this isn't off-topic or inapropriate to this list ...
I'm not familiar with the PostgreSQL patch-submittal/development cycle.
I recently submitted a patch regarding \copy syntax in psql, and I'd
like to keep an eye on it to see that it gets
suggestions, or links to information would be equally welcome.
Thanks.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
42 matches
Mail list logo