On Fri, January 3, 2014 00:09, Erik Rijkers wrote:
connection to server was lost
So, to repeat, this runs fine on a server compiled for speed.
I forgot to append the log messages:
2014-01-03 00:19:17.073 CET 14054 LOG: database system is ready to accept
connections
TRAP: FailedAssertion
generate_series(1, 100) g(n) | psql
ERROR: XX000: cache lookup failed for type 0
LOCATION: get_typlenbyval, lsyscache.c:1895
Time: 2.752 ms
Is there a way I can use the existing database and avoid both initdb and this
error?
Thanks,
Erik Rijkers
See also:
[1]
http://www.postgresql.org/message-id/flat
On Tue, December 24, 2013 15:19, Andres Freund wrote:
Hi,
On 2013-12-24 02:05:23 +0100, Erik Rijkers wrote:
With \timing on, a trailing comment yields a timing.
# test.sql
select 1;
/*
select 2
*/
$ psql -f test.sql
?column?
--
1
(1 row)
Time: 0.651 ms
Time
such trailing ghost-timings
can be removed?
BTW:
$ cat ~/.psqlrc
\set QUIET on
\timing on
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
.; every combination
yielded this same compile error )
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
but that's easily ignored for now.
I'll do some testing later,
Thanks
Erik Rijkers
--
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, December 21, 2013 12:52, David Rowley wrote:
On Sun, Dec 22, 2013 at 12:49 AM, Erik Rijkers e...@xs4all.nl wrote:
On Sat, December 21, 2013 12:38, David Rowley wrote:
[ inverse_transition_functions_v1.2.patch.gz ]
Please find attached an updated patch which should remove
In case it has gone unnoticed: The buidlfarm has gone red across the board.
http://buildfarm.postgresql.org/cgi-bin/show_status.pl
(and sure enough I can't build either...)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On Fri, November 8, 2013 21:11, Alvaro Herrera wrote:
Here's a version 7 of the patch, which fixes these bugs and adds
opclasses for a bunch more types (timestamp, timestamptz, date, time,
timetz), courtesy of Martín Marqués. It's also been rebased to apply
cleanly on top of today's master
On Mon, November 11, 2013 09:53, Erik Rijkers wrote:
On Fri, November 8, 2013 21:11, Alvaro Herrera wrote:
Here's a version 7 of the patch, which fixes these bugs and adds
opclasses for a bunch more types (timestamp, timestamptz, date, time,
timetz), courtesy of Martín Marqués. It's also
On Thu, September 26, 2013 00:34, Erik Rijkers wrote:
On Wed, September 25, 2013 22:34, Alvaro Herrera wrote:
[minmax-5.patch]
I have the impression it's not quite working correctly.
The attached program returns different results for different values of
enable_bitmapscan (consistently
but expected 0
ERROR: invalid page in block 1 of relation base/21324/26267_vm
it happens reliably. every time I run the program.
Below is the whole program that I used.
Thanks,
Erik Rijkers
#!/bin/sh
t=t
if [[ 1 -eq 1 ]]; then
echo
drop table if exists $t ;
create table
not have a Postgres 9.3
installation on Linux yet, so that I can't test it.
On 9.3 and 9.4devel, on linux (centos 6.4), that statement / regex returns
after ~2 minutes (on a modest desktop) with that
same error, but not crashing.
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql
On Wed, September 25, 2013 22:34, Alvaro Herrera wrote:
[minmax-5.patch]
I have the impression it's not quite working correctly.
The attached program returns different results for different values of
enable_bitmapscan (consistently).
( Btw, I had to make the max_locks_per_transaction higher
==
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
for table t
Could it be added there too?
Thanks,
Erik Rijkers
#!/bin/sh
schema=restore_verbose_test
table=t
t=$schema.$table
rm -rf $schema.dump
echo
echo
drop schema if exists $schema cascade;
create schema $schema;
drop table if exists $t;
create table $t(c text, i serial primary key
)
Needless to say, YMMV ...
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
style is unicode.
Null display is NULL.
Pager is used for long output.
Record separator is newline.
So that it also serves a reminder on how to subsequently
change them
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
for 9.4 get a prize, such as a t-shirt, as a
promotion to increase the number of non-submitter reviewers?
b) no
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Fri, June 21, 2013 05:25, Tom Lane wrote:
Erik Rijkers e...@xs4all.nl writes:
In a 112 MB test table (containing random generated text) with a trgm index
(gin_trgm_ops), I consistently get these
timings:
select txt from azjunk6 where txt ~ '^abcd';
130 ms
select txt from azjunk6
On Fri, June 21, 2013 15:11, Alexander Korotkov wrote:
On Fri, Jun 21, 2013 at 2:40 PM, Erik Rijkers e...@xs4all.nl wrote:
On Fri, June 21, 2013 05:25, Tom Lane wrote:
Erik Rijkers e...@xs4all.nl writes:
In a 112 MB test table (containing random generated text) with a trgm
index
WHERE txt ~ 'abcd$'
is as fast as the non-anchored variant )
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Thu, June 13, 2013 22:19, Alexander Korotkov wrote:
[index_on_regexes.1.patch.gz ]
Hi,
Compile of core is OK, but contrib compilation fails:
-- [2013.06.13 23:23:14 idxregex] make contrib
trgm_gin.c: In function gin_regexp_trgm_config:
trgm_gin.c:410:2: error: unknown type name
tested PGAPPNAME, but it doesn't work.
It does work:
$ PGAPPNAME=splunk psql -c select application_name from pg_stat_activity;
application_name
--
splunk
(1 row)
But perhaps I misunderstood your intention?
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql
,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Wed, May 1, 2013 20:13, Joshua D. Drake wrote:
I don't think ePub is a problem here, we will have the same problem with
PDF. The issue is the sheer size of the manual. If we can solve the
cross referencing issue, breaking them up makes sense I would think.
I like the one-huge-chunk pdf:
it in case it is
overlooked.
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
should be
added to psql. It
would save time going back and forth between different views (especially with
broad tables). I
would be glad to have the possibility. It would have to be optional, of course.
In short: +1 from me.
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list
think including a materialized view under views or tables is
appropriate.
Right. I think adding pg_matviews covers the stated use-case
enough to answer Erik's concern.
Absolutely - I agree pg_matviews is much better than adding deviating
information_schema stuff.
Thank you,
Erik Rijkers
this:
SELECT n.nspname, c.relname
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('m','')
and n.nspname = 'myschema'
which seems rather ugly.
Also, some documentation typos: please see attached.
Thanks,
Erik Rijkers
On Wed, February 13, 2013 21:23, Stephen Frost wrote:
* Pavel Stehule (pavel.steh...@gmail.com) wrote:
SELECT * FROM some_relation LIMIT 10
what do you thinking about creating special statement for this purpose?
I'd rather extend TABLE to support a limit clause or something.
No need; that
|
$
The trailing empty line here makes almost as little sense as in the now amended
case where there
are zero rows ...
(Of course, I realise that it's much more likely to break existing scripts, but
should we then
keep such illogical things forever at all cost?)
Thanks,
Erik Rijkers
Branch
On Fri, February 1, 2013 21:22, Peter Eisentraut wrote:
I have encountered two unrelated flaws in the psql table output.
First, when using unaligned vertical mode (\a \x on), there is always an
empty line after the last record. This also means that an empty result
set prints an empty line,
On Wed, January 23, 2013 08:36, Alexander Korotkov wrote:
Hi!
Some quick answers to the part of notes/issues. I will provide rest of
answers soon.
[...]
trgm-regexp-0.10.patch.gz27 k
Trying to build this I get, after 'make install' in contrib/ :
/usr/bin/install: cannot stat
,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sun, January 13, 2013 22:09, Tom Lane wrote:
BTW, although Erik claimed this behaved more sanely in 9.2, a closer
look at the commit logs says that the bogus commit shipped in 9.2,
so AFAICS it's broken there too. But earlier releases would have
rejected the SET as expected. I think we
Connections
/tmp:6000 - No Response
which looks unusual to me, could we please make it all lower-case?
TYhanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
that uses
these new options. I
can hack something together myself, but I just thought I'd ask.
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
am also
trying to get your patch to fall over ;-))
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
between HEAD,
versions 6, 7, 8. (BTW, is v6 still interesting?)
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, December 17, 2012 09:54, Pavel Stehule wrote:
Helllo
I try to search simple solution and I didn't find anything. It is possible?
Perhaps not strictly 1 commandline but I often use this:
echo '\timing on \\ select 1+2' | psql
Erik Rijkers
--
Sent via pgsql-hackers mailing list
to diversify the test program; it
is now too simple.
Thanks,
Erik Rijkers
trgmre_6_7_9.txt.gz
Description: GNU Zip compressed data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
backup completed
Thanks,
Erik Rijkers
--
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, December 15, 2012 14:10, Magnus Hagander wrote:
On Sat, Dec 15, 2012 at 11:39 AM, Erik Rijkers e...@xs4all.nl wrote:
from 9.3devel (this morning):
The truncated name in parentheses only shows up during the filling of the
new PGDATA; when 100%
is
reached that part of the displayed
and then part 2 does not.
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
'generalise' them, but for now I'll
send them as they are.
Erik Rijkers
create_data.sh
Description: application/shellscript
trgm_regex_test.pl
Description: Perl program
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
versions 0.6,
and 0.7.
Erik Rijkers
trgm_compare.txt.gz
Description: GNU Zip compressed data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
]: *** [trgm_regexp.o] Error 1
make: *** [all-pg_trgm-recurse] Error 2
trgm_regexp.c:73:2: error: unknown type name TrgmStateKey
make[1]: *** [trgm_regexp.o] Error 1
make: *** [install-pg_trgm-recurse] Error 2
Did I forget something?
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing
pg_archivecleanup deleting files, it
would seem that some
bug exists but I haven't followed changes regarding WAL too closely.
(My apologies if it's a config mistake on my part after all; but in that case:
I cannot find it
and would be thankful for a hint)
Thanks,
Erik Rijkers
--
Sent via
VERSION
integer_value|
character_value | 09.02.
comments |
I would expect 9.2.1 to contain '09.02.0001' (not '09.02.').
Unless, of course, I have overlooked some step in the upgrade...
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list
On Fri, October 19, 2012 11:00, Kohei KaiGai wrote:
I confirmed I could apply the latest patch cleanly.
FWIW, I spent a few sessions (amounting to a few hours) trying to break, or get
past SET ROW LEVEL
SECURITY and have not yet succeeded. So far so good.
(I haven't looked at code)
Erik
\\ \echo :y
1
2
testdb=# select 1,2 \gset x,y \\ \echo :x
\gset: syntax error
testdb=#
It'd be nice if it could be made to work
Thanks
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
algorithm used? (What happened to
text_position() anyway?)
2. Shouldn't there be, for 'advocacy' reasons, a mention of this well-known
algorithm in the
manual proper? (I can make a doc-patch if needed)
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
On Thu, May 31, 2012 13:14, Robert Haas wrote:
On Thu, May 31, 2012 at 1:06 AM, Erik Rijkers e...@xs4all.nl wrote:
In my test, I run the bash code (the bits that I posted earlier) in a while
loop so that the
table
is CREATEd, COPYied into, and DROPped every few seconds -- perhaps
On Wed, May 30, 2012 22:25, Robert Haas wrote:
On Wed, May 30, 2012 at 2:52 PM, Robert Haas robertmh...@gmail.com wrote:
On Wed, May 30, 2012 at 1:47 PM, Robert Haas robertmh...@gmail.com wrote:
The process holding the AccessExclusiveLock is the startup process. It's
holding the lock on behalf
On Thu, May 31, 2012 03:30, Robert Haas wrote:
On Wed, May 30, 2012 at 6:00 PM, Erik Rijkers e...@xs4all.nl wrote:
directory
2012-05-30 23:40:57.909 CEST 3909 CONTEXT: writing block 5152 of relation
base/21268/26569
xlog redo multi-insert (init): rel 1663/21268/26581; blk 3852; 35
was disabled), and how the crash came
quickly when I
switched it on (to add the select count(*) statements).
Erik Rijkers
logfile.head2
Description: Binary data
logfile.head1
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
not a likely scenario, but surely such a deviating rowcount on a sync
replica should not
be possible?
thank you,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
: synchronous_commit = on
Thanks,
Erik Rijkers
- Original Message -
AMD FX 8120 / centos 6.2 / latest source (git head)
It seems to be quite easy to force a 'sync' replica to not be equal
to master by
recreating+loading a table in a while loop.
For this test I compiled+checked+installed three
On Thu, May 17, 2012 16:10, Ants Aasma wrote:
On Thu, May 17, 2012 at 4:53 PM, Erik Rijkers e...@xs4all.nl wrote:
The count(*) was done in the way that I showed, i.e. *after* psql had
exited. My understanding
is
that, with synchronous replication 'on' and configured properly, psql could
)
And perhaps (same paragraph):
The previous query values are preserved, allowing for enhanced analysis.
would be clearer as:
The last query values are preserved, allowing for enhanced analysis.
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
are somewhat arbitrary, it does show some of the
good, the bad and
the ugly of the patch(es). (Also: I've limited the tests to a range of
'workable' regexps, i.e.
avoiding unbounded regexps)
hth (and thanks, great work!),
Erik Rijkers
trgm_regex_test.out.20120429_1300.txt.gz
Description: GNU Zip
keystrokes and errors.
Tab-completion is great and this search_path-annoyance happens to me all the
time; my fingers
can't seem to learn this exception.
(pgsql 9.2devel, problem also in latest 9.1.3)
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers
]: *** [pg_backup_archiver.o] Error 1
make[2]: *** [all-pg_dump-recurse] Error 2
make[2]: *** Waiting for unfinished jobs
make[1]: *** [all-bin-recurse] Error 2
make: *** [all-src-recurse] Error 2
-- make returned 2 - abort
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
] Error 2
make: *** [all-src-recurse] Error 2
-- make returned 2 - abort
I should add: Centos 5.8, gcc 4.6.3
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ecpg.sgml: the the - the--- doc/src/sgml/ecpg.sgml.orig 2012-03-11 10:15:20.0 +0100
+++ doc/src/sgml/ecpg.sgml 2012-03-11 10:15:37.0 +0100
@@ -4038,7 +4038,7 @@
termliteralsqlname//term
listitem
para
-The the name of the field.
+
', 'Type',
'Description') would not be 3 columns of the same width, like they seem to be
now: the 'Type'
column take fully one third of page-width, for short words like 'text' and
'bigint'. The
'Column' values too are almost always more narrow than 1/3 of the page.
Erik Rijkers
--
Sent via
2 0 16 1562 1562
_null_ _null_ _null_ _null_ bitge _null_ _null_ _null_ ));
I'd like to try this out a bit; could you see if you can fix it?
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
:
This utility, like most other PostgreSQL utilities, also uses the environment
variables supported
by libpq (see Section 31.13).
I could look into fixing one (binary) or the other (docs), but what /is/ the
preferred behavior?
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list
On Sun, February 19, 2012 06:27, Robert Haas wrote:
On Sat, Feb 18, 2012 at 11:58 AM, Erik Rijkers e...@xs4all.nl wrote:
pg_restore ignores environment variable PGDATABASE.
What exactly do you mean by ignores? pg_restore prints results to
standard output unless a database name is specified
this is the mystery bug that I
encountered repeatedly
already in 9.0devel; but I was never able to reproduce it reliably. But I
don't think it was ever
solved.
http://archives.postgresql.org/pgsql-hackers/2010-03/msg00223.php
Erik Rijkers
In another test run I had
- set full page
On Sat, January 21, 2012 06:26, Alexander Korotkov wrote:
Hi!
Thank you for your feedback!
On Fri, Jan 20, 2012 at 3:33 AM, Erik Rijkers e...@xs4all.nl wrote:
The patch yields spectacular speedups with small, simple-enough regexen.
But it does not do a
good enough job when guessing where
the code, esp. the regex engine hard to understand sofar, so all
the above are
somewhat inconclusive remarks; I hope nonetheless they are useful.
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
ranges? As with these comparison functions, throwing an error
seems like a fairly unpleasant definition to work with in practice.
+1
much better, IMHO.
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
---
0001-10-29 BC
(1 row)
without double quotes. It's not important, perhaps; it just looks ugly to me.
Do they serve a purpose?
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
| 2
(2 rows)
I'm not sure it is actually a bug; but it seems an unneccessary error.
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Tue, October 25, 2011 19:49, Kerem Kat wrote:
On Mon, Oct 24, 2011 at 20:52, Erik Rijkers e...@xs4all.nl wrote:
On Wed, October 19, 2011 15:01, Kerem Kat wrote:
Adding CORRESPONDING to Set Operations
I have corrected the ordering of the targetlists of subqueries. And
added 12 regression
rows)
i.e., I think it should show columns in the order c, b (and not b, c); the
order of the
CORRESPONDING BY phrase.
(but maybe I'm misreading the text of the standard; I find it often difficult
to follow)
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql
below changes that to accept NULL for INF and -INF
in the string-form construction. (not complete: it still is
case-sensitive).
Thanks,
Erik Rijkers
--- src/backend/utils/adt/rangetypes.c.orig 2011-09-18 12:35:29.0 +0200
+++ src/backend/utils/adt/rangetypes.c 2011-09-18 16:03
than the second,
they are automatically swapped, similar to SYMMETRIC in the BETWEEN clause.
Admittedly, I don't have a specific 'use case' -- it might just often prevent
'manual' swapping
before range construction calls.
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql
the error
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
be set to a
non-empty value.
( the 'must be set' part )
Two questions:
1. How to query a session to make absolutely sure that replication is actually
synchronous?
2. Does sync-repl really need synchronous_standby_names to be set?
Thank you,
Erik Rijkers
--
Sent via pgsql-hackers mailing
connections
-- logfile 2:
LOG: shutting down
LOG: database system is shut down
FATAL: lock file postmaster.pid already exists
HINT: Is another postmaster (PID 20519) running in data directory
/var/data1/pg_stuff/pg_installations/pgsql.vanilla_1/data?
thanks,
Erik Rijkers
split_vanilla.sh
'-'::int4range -|- range(200,300);
ERROR: empty range
I'm not sure if that is deliberate behavior, but they seem
almost bugs to me.
Wouldn't it be better (and more practical) if these would
return false (or perhaps NULL, for 'unknown') ?
(the same goes for all the other range types, btw.)
Erik
On Fri, February 11, 2011 19:02, Josh Berkus wrote:
empty range
=
Zero length?
If so, is it fixed at some point, but empty?
'(x,x)'?
'[x,x)'?
Neither of the above should be possible, I think. The expression (x
logically excludes the expression x).
However, [x,x]
cleanly.
Erik Rijkers
As always, my repo is here:
http://git.postgresql.org/gitweb?p=users/jdavis/postgres.git;a=log;h=refs/heads/rangetypes
Regards,
Jeff Davis
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
() = infinite lower bound, inclusive upper bound
I still want to do Performance review and Coding review.
FWIW, I would like to repeat that my impression is that the patch is very
stable, especially with
regard to the intranges (tested extensively).
regards,
Erik Rijkers
--
Sent via pgsql
I realize that
... WHERE ir @ range(5);
fixes the problem, but it would be
really nice to have it work on integers)
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
];
==
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Tue, December 21, 2010 09:57, Dimitri Fontaine wrote:
Erik Rijkers e...@xs4all.nl writes:
I might be mistaken but it looks like a
doc/src/sgml/ref/alter_extension.sgml is missing?
Mmm, it seems that git was agreeing with you, so here's it:
git ls-files doc/src/sgml/ref
, installs and runs OK.
(obviously I haven't
tested anything yet)
Linux Centos 5.4
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, December 20, 2010 22:55, Erik Rijkers wrote:
On Mon, December 20, 2010 22:35, Dimitri Fontaine wrote:
During configure I spotted this:
[...]
checking for bison... /usr/bin/bison
configure: using bison (GNU Bison) 2.3
gawk: { if ($4 1.875-extension) exit 0; else exit 1;}
gawk
On Mon, December 20, 2010 22:35, Dimitri Fontaine wrote:
I might be mistaken but it looks like a doc/src/sgml/ref/alter_extension.sgml
is missing?
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
:
trailing
whitespace.
error: patch failed: src/backend/optimizer/plan/planner.c:739
error: src/backend/optimizer/plan/planner.c: patch does not apply
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
at ./check_rules.pl line 18.
make: *** [all-src-recursive] Error 2
( A similar effect I see on a dual core fedora system (2.6.27.5-117.fc10.i686),
where -j 16 always
ran, but now it needs -j 4 or less (it also has make 3.81) )
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers
for me... )
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
nevermind... I see standbys.conf is now used.
sorry for the noise...
Erik Rijkers
On Thu, September 16, 2010 01:12, Erik Rijkers wrote:
On Wed, September 15, 2010 11:58, Fujii Masao wrote:
On Wed, Sep 15, 2010 at 6:38 AM, David Fetter da...@fetter.org wrote:
Now that the latch patch
On Tue, August 24, 2010 08:32, Itagaki Takahiro wrote:
I applied the attached patch to HEAD. concat(), concat_ws(), left(),
right(), and reverse() are in it, but format() and sprintf() are not.
+1 to add also sprintf
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers
On Sun, August 22, 2010 17:54, Tom Lane wrote:
Erik Rijkers e...@xs4all.nl writes:
If only for consistency, this patch adds the path info to that message.
Seems reasonable, but speaking of consistency:
+#ifdef WIN32
+snprintf(WALFilePath, MAXPGPATH, %s\\%s
to not see the full path in the 'keep WAL
file'-message (esp. when it is
repeated many screenfulls).
If only for consistency, this patch adds the path info to that message.
Erik Rijkers--- contrib/pg_archivecleanup/pg_archivecleanup.c.orig 2010-08-22 00:05:06.0 +0200
+++ contrib
201 - 300 of 353 matches
Mail list logo