to ensure that test_factory 0.1.1
is what gets installed.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers
relation "pg_depend" page 88 is uninitialized --- fixing
WARNING: relation "pg_depend" page 89 is uninitialized --- fixing
WARNING: relation "pg_depend" page 90 is uninitialized --- fixing
WARNING: relation "pg_depend" page 91 is uninitialized ---
ir old behavior. So I think
it's safe to just force paging.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-h
to diagnose them?
In any case, thanks Simon for the summary. I really like the idea and
will help with it if I can.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
On 9/2/15 2:56 PM, Jim Nasby wrote:
On 9/2/15 2:17 PM, Alvaro Herrera wrote:
Michael Paquier wrote:
I haven't written yet a test case but I think that we could reproduce
that simply by having a relation referenced in the exception block of
a first function, calling a second function
involving pgTap. So I suspect you need to have a named
cursor in the mix as well.
Let me make another attempt at something simpler.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http
ay || anything -> array,
object || array -> error.
That definitely doesn't sound like a good default.
It might be useful to have a concat function that would concatinate
anything into an array. But if we don't provide one by default users
could always create their own with json__typeof
ing it deeper.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subsc
that have added COMMENT
functionality to see what they did.
BTW, I'm also interested in this but I'm not sure when I'd have time to
work on it.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble
guessing this isn't covered by ANSI but maybe there's
already an industry consensus.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing
believe there is some code in the planner to remove useless
ORDER-BYs.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers
is
probably pretty rare now. I don't think it's worth a bunch of extra work
to speed them up.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers
.
Are we certain that no index type could ever support an index on (f1,
f2, f3) UNIQUE(f1, f3)? Even if it doesn't make sense for btree, perhaps
some other index could handle it.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
On 9/15/15 8:43 AM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
I'm not sure SGML is the way to go anymore anyways. Asciidoc offers a
lot of what our SGML does in a much easier to support toolchain. It's
also natively supported by github, which makes it nice for others t
sues in the past with making catalog changes due to
fear of breaking user scripts. Instead of doubling down on that with RLS
on top of catalog tables, would it be better to move the tables to a
different schema, make them accessible only to superusers and put views
in pg_catalog?
--
Jim Nasby
[2] http://asciidoctor.org/docs/asciidoc-asciidoctor-diffs/
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To ma
On 9/27/15 2:25 PM, Andres Freund wrote:
On 2015-09-27 14:21:08 -0500, Jim Nasby wrote:
IMHO doing just a log of something this serious; it should at least be a
WARNING.
In postgres LOG, somewhat confusingly, is more severe than WARNING.
Ahh, right. Which in this case stinks, because
Has anyone ever run cachegrind [1] against Postgres? I see little about
it on the mailing list so I'm guessing no...
[1] http://valgrind.org/docs/manual/cg-manual.html
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data
know if an old copy accidentally got put in place.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
aintaining CommitFest and buildfarm and
could also replace mediawiki.
If people are hell-bent on every tool being separate then fine, but I
get the distinct impression that everyone is discarding GitLab out of
hand based on completely bogus information.
--
Jim Nasby, Data Architect, Blue Treble
could be driven that way. I suspect it's
unnecessary though.
BTW, the docs are at http://doc.gitlab.com/ce/.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Se
On 9/30/15 4:31 PM, Josh Berkus wrote:
On 09/30/2015 12:02 AM, Jim Nasby wrote:
I wish people would at least consider this as an option because it
integrates a ton of different features together. It has *the potential*
to eliminate our need to keep maintaining CommitFest and buildfarm and
could
when this is backpatched, would it be safer to just leave this alone?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pg
to be the responsibility of the reply sending backend in the
end: to create and release the DSM *at some point*.
What's wrong with just releasing it at the end of the statement? When
the statement is done there's no point to reading it asynchronously anymore.
--
Jim Nasby, Data Architect, Blue
ome of our current stand-alone
tools with a single integrated solution, depending on how much time we
spend maintaining all the separate stuff.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Tr
could be tied in as well. Presumably each commitfest would be
a milestone (http://doc.gitlab.com/ce/api/milestones.html) and each
submission an issue.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in
a viable option.
[1] https://gitlab.com/gitlab-org/gitlab-ce/blob/master/LICENSE
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql
WAL from an older primary."),
errhint("Upgrade the primary, it is
susceptible to data corruption.")));
shouldn't rather be a PANIC. (The main reason not to, I think, is that
once you see this, there is no way to put the standby in a working state
without recloning).
-
jects."
So looking at it now I'd say it's come a long way in 2 years.
[1]
https://about.gitlab.com/2013/08/22/introducing-gitlab-6-0-enterprise-edition/
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Tr
the stack any time we enter the module. If
folks think that's a good idea I'll pursue it as a separate patch.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
diff --git
On 9/22/15 5:58 PM, Peter Geoghegan wrote:
On Tue, Sep 22, 2015 at 3:16 PM, Jim Nasby <jim.na...@bluetreble.com> wrote:
At first I thought the lack of context indicated a palloc had failed during
ereport() (since we apparently just toss the previous error when that
happens), but it tur
is not displayed,
IIRC this is the second problem related to autovacuum... is there some
way to regression test that? Maybe disable autovac on a table, dirty it,
then re-enable (all with an absurdly low autovacuum naptime)?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts
it, or the different -O
level.)
Do we officially not support anything > -O2? If so it'd be nice if
configure threw at least a warning (if not an error that you had to
explicitly over-ride).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architect
umeric->decimal is a good idea since it can overflow. I'm
not sure that the other direction is safe either... I can't remember
offhand if casting correctly obeys typmod or not.
BTW, have you talked to Pavel about making these changes to his code?
Seems a shame to needlessly fork it. :/
--
other
intelligently, yet still keep them as 3 separate bodies.
They're also based here in Austin so we've got community folks that can
interface with them directly if that's ever needed.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture
w our scheduling is consistent at least!
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
On 9/22/15 6:27 PM, Jim Nasby wrote:
+ ereport(LOG,
+ (errcode(ERRCODE_OUT_OF_MEMORY),
+ errmsg("out of memory attempting to pg_stat_statement
file"),
+ errdetail("file \"%s\": size %lld", PGSS_TEXT_FILE,
stat.st_size))
but MaxAllocSize, unless there's some
other failure mode in malloc I don't know about.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing
/BlueTreble/test_factory/tree/crash
[2] https://github.com/theory/pgtap/blob/master/sql/pgtap.sql.in#L746
[3] https://github.com/theory/pgtap/blob/master/sql/pgtap.sql.in#L6541
which is being called by
https://github.com/theory/pgtap/blob/master/sql/pgtap.sql.in#L6591
--
Jim Nasby, Data Architect
it is included or excluded. The problem
here is exploding the logic in order to deal with both a system and a
user rc file.
If we had a \i variation that didn't fail if the file wasn't readable
you could use that to pull a system psqlrc in from your custom one.
--
Jim Nasby, Data Architect, Blue
\conninfo inside of psql
and do something with it. If instead this was exposed as a variable, you
could handle it in SQL if you wanted to.
All that said, the patch already adds significant value and you could
always parse the URI if you really needed to.
--
Jim Nasby, Data Architect, Blue Treble
On 8/25/15 6:28 PM, Tom Lane wrote:
Jim Nasby jim.na...@bluetreble.com writes:
This works:
CREATE TYPE c AS (r float, i float);
CREATE FUNCTION mag(c c) RETURNS float LANGUAGE sql AS $$
SELECT sqrt(c.r^2 + c.i^2)
$$;
SELECT mag( (2.2, 2.2) );
mag
--
3.11126983722081
non-interactive use.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
Looks like a 98k file won't get through the list...
Forwarded Message
Subject: Core dump with nested CREATE TEMP TABLE
Date: Thu, 27 Aug 2015 19:45:12 -0500
From: Jim Nasby jim.na...@bluetreble.com
To: Pg Hackers pgsql-hackers@postgresql.org
I don't have an independent
, easy way to figure out
whether a query would be expensive enough to go the whole 9 yards on
planning it but at this point I suspect a simple GUC would be a big
improvement.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and Postg
On 12/7/15 9:54 AM, Tom Lane wrote:
Jim Nasby<jim.na...@bluetreble.com> writes:
>On 12/6/15 10:38 AM, Tom Lane wrote:
>>I said "in most cases". You can find example cases to support almost any
>>weird planner optimization no matter how expensive and single-p
that would be.
Maybe a better starting point would be a planner timeout.
I definitely agree we need some method to limit planning time when
necessary (ie: OLTP). Without that we'll never be able to start testing
more complex optimizations.
--
Jim Nasby, Data Architect, Blue Treble Consulting
On 11/15/15 7:37 PM, Peter Eisentraut wrote:
On 11/15/15 3:20 PM, Jim Nasby wrote:
As to the argument about displaying a check or an X, why should that
capability only exist for boolean types? For example, why not allow psql
to convert a numeric value into a bar of varying sizes? I've
REVOKE/GRANT/COMMENT on
statements. Even worse, not all the options of CREATE FUNCTION are
supported in those other commands, so often you can't even just cut and
paste.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data
. If we do this, I think we need to change both places
that are affected, so ResourceOwnerCreate() in resowner.c would
need a line or two added.
ResourceOwnerCreate() sets ResourceOwnerData.nextchild, not
MemoryContextData.nextchild.
Anything ever happen with this?
--
Jim Nasby, Data Architect
s mostly a
separate matter.
Though, it would probably be nice if all of this stuff (along with the
regprocedure input function) could be factored into a single piece of
code...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
the brawn, but we're not willing to add the brain. If this is the case
then it's a shame, as I think we can have both. So I very much agree on
the fact that we must find a way to maintain support and high
performance of small OLTP databases too.
+1
--
Jim Nasby, Data Architect, Blue Treble Consulting
. If that ever gets built it might be useful for what you
propose as well.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql
On 12/8/15 1:36 PM, Robert Haas wrote:
Your point is also valid, so I don't mean to detract from that. But
the status quo is definitely annoying.
+1, and I even use -S.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data
can't get postgres to run under valgrind
on my laptop, but maybe someone that's been successful at valgrind can
try cachegrind (It's just another mode of valgrind).
[1] http://valgrind.org/docs/manual/cg-manual.html
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts
On 12/4/15 5:14 PM, Peter Geoghegan wrote:
On Fri, Dec 4, 2015 at 2:44 PM, Jim Nasby<jim.na...@bluetreble.com> wrote:
>I suspect Cachegrind[1] would answer a lot of these questions (though I've
>never actually used it). I can't get postgres to run under valgrind on my
>la
On 12/10/15 7:03 PM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
Is there any reason we couldn't/shouldn't support IS DISTINCT in
subquery_Op? (Or really, just add support to ANY()/ALL()/(SELECT ...)?)
It's not an operator (in the sense of something with a pg_operat
to the index at the end of an INSERT should
be safe though because none of those tuples are visible yet, though I'd
have to make sure your backend didn't try to use the index for anything
while the command was running... like as part of a trigger.)
--
Jim Nasby, Data Architect, Blue Treble
varlena to 8 byte as needed.
And we're not painting ourselves in the corner - if we decide to
increase the varlena header size in the future, this patch does not make
it any more complicated.
True.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data
On 12/16/15 6:01 PM, Robert Haas wrote:
On Tue, Dec 15, 2015 at 1:26 AM, Michael Paquier
<michael.paqu...@gmail.com> wrote:
On Tue, Dec 15, 2015 at 2:57 AM, Jim Nasby <jim.na...@bluetreble.com> wrote:
On 12/11/15 2:57 PM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com&g
On 12/11/15 6:25 PM, Jim Nasby wrote:
On 12/10/15 7:09 PM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
AFAICT the problem is that missing wasn't included in install or
uninstall in config/Makefile. Attached patch fixes that, and results in
missing being properly ins
On 12/10/15 7:09 PM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
AFAICT the problem is that missing wasn't included in install or
uninstall in config/Makefile. Attached patch fixes that, and results in
missing being properly installed in lib/pgxs/config.
I thought we'
-compatible.html
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
the server. Maybe they wouldn't be that bad. I suspect the audience for
this code would be much larger if it was in the server as opposed to a C
library.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Tr
all in config/Makefile. Attached patch fixes that, and results in
missing being properly installed in lib/pgxs/config.
Forwarded Message
Subject: [GENERAL] pgxs/config/missing is... missing
Date: Wed, 28 Oct 2015 12:54:54 -0500
From: Jim Nasby <jim.na...@bluetreble.com>
Is there any reason we couldn't/shouldn't support IS DISTINCT in
subquery_Op? (Or really, just add support to ANY()/ALL()/(SELECT ...)?)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http
search and repalace arrays instead of Datums?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
On 12/11/15 2:57 PM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
A quick doc search indicates this config was created in 9.0, though the
docs state it's for a change that happened in 8.2[1].
Don't know what you're looking at, but the GUC is definitely there (and
docu
then maybe that's enough.
The other thing this might buy us are a few bits that could be used to
support Datum versioning for other purposes, such as when the binary
format of something changes. I would think that at some point we'll need
that for pg_upgrade.
--
Jim Nasby, Data Architect, Blue Treble
rge amount of deletes;
I'll check with them tomorrow.
IMHO we need to change the messages so they are explicit about line
pointers vs actual tuples. Trying to obfuscate that just leads to
confusion. heap_page_prune needs to report only non-rootlp tuples that
were pruned. (None of the other c
this is actually a good luck sign. ;P
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
aving some set of queries you can test
against and call it good.
FWIW, I also don't see the use case for disabling maintenance on an
index. Just drop it and if you know you'll want to recreate it squirrel
away pg_get_indexdef() before you do.
--
Jim Nasby, Data Architect, Blue Treble Cons
'::regclass;
ERROR: invalid name syntax
LINE 1: select 'with spaces'::regclass;
select '"with spaces"'::regclass;
regclass
---
"with spaces"
(1 row)
I think this needs to be fixed before 9.5 releases. :(
--
Jim Nasby, Data Architect, Blue Treble Consultin
/regress/pg_regress
--inputdir=./ --psqldir=/Users/decibel/pgsql/9.4/i/bin
REGRESS_OPTS = --inputdir=test --load-language=plpgsql
--dbname=contrib_regression
REGRESS = all build
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
size of the test. Not a huge deal though...
Also, I don't think anything is testing multiples of whatever value...
how 'bout change the generate_series CASE statement to >40 instead of <>40?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Archite
On 1/3/16 9:23 PM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
regrole and regnamespace don't run their output through quote_ident().
That's contrary to all the other reg* operators.
Worse, they also don't *allow* quoted input. Not only is that different
from reg*
hacker to handle, so I'm going to figure out what
we're doing with those things now-a-days and put it there.
If no one picks it up I'll get it into the last commitfest.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data
On 1/4/16 12:53 PM, Atri Sharma wrote:
Please don't top-post.
On 5 Jan 2016 12:20 am, "Jim Nasby" <jim.na...@bluetreble.com
<mailto:jim.na...@bluetreble.com>> wrote:
On 1/4/16 12:07 PM, Atri Sharma wrote:
Hi All,
I wanted to check if it is possible
that need to change.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
On 1/3/16 10:20 PM, Jim Nasby wrote:
What I went with. Now to figure out why this is happening...
Nevermind, see my stupidity now. Should have full patch soon.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble
you miss it... I was inconsistent with the list
length_names checks... one is
if (list_length(names) > 1)
the other is
if (list_length(names) != 1)
(stringToQualifiedNameList() can't actually return a 0 length list and
IIRC there was another place doing a > check.)
--
Jim Nasby, Data
On 1/3/16 10:46 PM, Jim Nasby wrote:
Added. I'm gonna call this good for now. Note this is just against HEAD
since I don't have 9.5 setup yet. Presumably the patch should still
apply...
BTW, in case it's helpful...
https://github.com/decibel/postgres/tree/regquote
--
Jim Nasby, Data
to me. FWIW, RhodiumToad and macdice looked at my patch
as well and didn't see any problems you didn't mention.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent
ed the same syntax used elsewhere...
whoever commits feel free to editorialize...
A couple of tests in regproc.sql would be a good addition as well.
Added. I'm gonna call this good for now. Note this is just against HEAD
since I don't have 9.5 setup yet. Presumably the patch should still
On 1/3/16 9:43 PM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
On 1/3/16 9:23 PM, Tom Lane wrote:
Another potential problem for regnamespace is that it doesn't allow an
entry for the catalog. I'm not sure what the spec says about that, but
every other function
On 1/3/16 9:23 PM, Tom Lane wrote:
(Though at least in HEAD we ought to
fix them to take type text as input. Using cstring for ordinary functions
is just sloppy.)
BTW, *all* the reg*in() functions do that...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics
On 1/3/16 10:23 PM, Pavel Stehule wrote:
Hi
2016-01-03 22:49 GMT+01:00 Jim Nasby <jim.na...@bluetreble.com
<mailto:jim.na...@bluetreble.com>>:
On 1/3/16 2:37 PM, Pavel Stehule wrote:
+ /* num_nulls(VARIADIC NULL) is def
On 1/2/16 5:57 PM, Jim Nasby wrote:
Attached patch clarifies that %-related error messages with hints as
well as (IMHO) improving the clarity of the message:
Sorry, forgot to update regression tests. New patch attached.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts
elect format( '% moo');
ERROR: unrecognized format() type specifier " "
HINT: For a single "%" use "%%"
I also made the use of "format()" consistent in all the other error
messages.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Anal
On 1/5/16 9:16 PM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
FWIW, I suspect very few people know about the verbosity setting (I
didn't until a few months ago...) Maybe psql should hint about it the
first time an error is reported in a session.
Actually, what'd be
On 1/5/16 8:41 PM, Tom Lane wrote:
Jim Nasby<jim.na...@bluetreble.com> writes:
>does psql do anything with those fields? ISTM the biggest use for this
>info is someone sitting at psql or pgAdmin.
Sure, if you turn up the error verbosity.
FWIW, I suspect very few peopl
is someone sitting at psql or pgAdmin.
Maybe schema info could be presented in HINT or DETAIL messages as well?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via
On 1/6/16 9:22 PM, Michael Paquier wrote:
On Thu, Jan 7, 2016 at 9:28 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
Somewhat related to that, I don't believe there's any reason why commit
fest managers need to be committers; it seems
On 1/6/16 6:18 PM, Greg Stark wrote:
On Wed, Jan 6, 2016 at 11:42 PM, Jim Nasby <jim.na...@bluetreble.com> wrote:
Right. Personally, I feel the TODO has pretty much outlived it's usefulness.
An issue tracker would make maintaining items like this a lot more
reasonable, but it certainly wo
On 12/10/15 6:25 PM, Jim Nasby wrote:
Recently I had need of removing occurrences of a number of values from
an array. Obviously I could have nested array_remove() call or wrapped
the whole thing in a SELECT unnest(), but that seems rather silly and
inefficient.
Any one have objections
On 1/7/16 8:47 AM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
However, if I do this:
mv test/sql/acl_type.sql test/sql/acl.sql
mv test/expected/acl_type.out test/expected/acl.out
And change acl_type to acl in that pg_regress command:
/Users/decibel/pgsql/HEAD/i/lib/pg
On 1/6/16 11:54 AM, Tom Lane wrote:
Robert Haas <robertmh...@gmail.com> writes:
On Sun, Jan 3, 2016 at 5:22 PM, Jim Nasby <jim.na...@bluetreble.com> wrote:
The rule that gets executed if you do `make installcheck` with something
using PGXS is
pgxs.mk:$(pg_regress_
On 1/7/16 9:12 AM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
On 1/7/16 8:47 AM, Tom Lane wrote:
That's pretty hard to believe. There's nothing in pg_regress that looks
in places other than the given --inputdir.
Actually, I think it does... from pg_regress_
ey wouldn't have to do the gruntwork. If,
say, the Ops teams at 2nd Quadrant, CMD, and EDB wanted to work together
on improving infrastructure, that's pretty much community at that point,
and not a dependence on a single external entity.
--
Jim Nasby, Data Architect, Blue Treble Consulting, A
On 1/7/16 9:56 AM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
On 1/7/16 9:12 AM, Tom Lane wrote:
(I'm also wondering how convert_sourcefiles() works at all in a vpath
build, considering that I don't see it doing anything like this ...)
It's only looking at outputdir,
1401 - 1500 of 2196 matches
Mail list logo