ncrease the pool of people
with checksums enabled.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201701211522
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEG
or nothing, it is for increasing reliability by detecting
(and pinpointing!) corruption as early as possible.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201701211513
http://biglumber.com/x/web?pk=2529DF6AB8F79407E9444
language would be immense.
C++ would be the least painful option, probably.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201701080905
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B9067149
ised on July 25th, and the OP has
gone out of his way to present the case and provide patches. It's hardly
fair to discard it now.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201608071606
http://biglumber.
e of cool feature X and reason Y"
we would get the rare message like this:
"We don't really have much for this release, maybe it should just be 11.1?"
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0
it, or even ensure they
are machine-parseable, but I would like to see a few fields encouraged.
I think it also helps the committers to not forget some important
things, the way the free-form text can.
tl;dr be like Alvaro, please
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
/postgres_all_versions.html#version_9.4.5
which leads to:
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-5289
It's also possible the wrong CVE was entered, but I don't see
one that seems to pertain to the issue described (and
CVE-2015-5288, -3166, -3167, -0243, -0244 are in the same boat).
--
Greg Sabino
ers files (appears to have wrapped, then truncated)"
http://www.postgresql.org/message-id/flat/20150406192130.2573.22...@wrigleys.postgresql.org#20150406192130.2573.22...@wrigleys.postgresql.org
or:
http://goo.gl/4lKYOC
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.en
.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201505191718
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlVbq4AACgkQvJuQZxSWSsgrXgCaA6MTvbDeg2aMf+/HFnxutrqH
P1sAoLZB1w5
alternatives
like the (very verbose) vendor escape clauses, but settled on the simplicity of
a single backslash in the end. See part of the discussion here:
http://www.nntp.perl.org/group/perl.dbi.users/2014/12/msg37057.html
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http
if you're not constrained by 63 chars.
That's silly. We (third-party tools) already have to work around lots
of things constrained by namedatalen.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201505182138
http://biglumber.com/x
:
http://blog.endpoint.com/2015/01/dbdpg-escaping-placeholders-with.html
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201505171212
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
Just a little thing that's been bugging me. If one side of the
pg_upgrade has checksums and the other does not, give a less
cryptic error message.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
diff --git a/contrib/pg_upgrade/controldata.c b/contrib
be awesome.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201502021555
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlTP5EQACgkQvJuQZxSWSsj13QCfTrKBKDlOm0E5K4+2ib7F8Tjl
is: SELECT 'DBD::Pg ping test'
Which also means the inverse is true: simple blank queries
are guaranteed to *not* be coming from DBD::Pg.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201412301041
http://biglumber.com/x/web?pk
is bad (for example, PQerrorMessage gives a
could not receive data from server: Bad file descriptor). Being that we
cannot do a rollback before calling the PQexec, is this a decent solution?
Can we depend on really serious errors always trumping the expected 25P02?
- --
Greg Sabino Mullane g
the patches process. We have git, let's use it
as it was intended.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201412141011
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
not advocating changing the default behavior, but I would not want
to see bad client libraries used a reason for any change we make. Clients
should not be doing this, period, and there is no reason for us to
support that.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http
statement to start a serializable transaction, rather
than simply a BEGIN, is ugly.and error prone. Perhaps their app
assumes (or even requires) that BEGIN starts the snapshot.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8
in utility statements, or if not, if anyone has any ideas
about the feasibility of adding such support.
I don't think that's a hill you want to conquer. Let that code
relying on v2 behavior get rewritten, or make the driver smart
enough to handle it automagically the best it can.
- --
Greg Sabino
are dismal
No arguments there.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201408271200
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlP+AKgACgkQvJuQZxSWSsjf7gCg00BwRbwRi
git integration based on subsytems
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201401261211
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
was an extremely
poor choice of word. This American English speaker certainly has a
hard time viewing it as affectionate. I think the whole thread would
have been better received with a subject line of Commitfest needs help.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201307032150
current reviewers,
put the names in the release notes, after each item. Full stop.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201306271636
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
a lot of work to make things usable, despite their having a
non-email-centric workflow already.
Maybe we can identify specific issues with our current app instead?
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201302081106
http://biglumber.com/x/web?pk
that. Especially the signing up for the commitfest app.
Of course, Gerrit doesn't actually address most of the issues above, but
it could be part of a step forward.
More of a step sideways. It doesn't address the bigger problems.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201302081124
- emulating some other system. Could be
replication, QA box, disaster recovery, etc. I'd be
cool with a warning, but do not think we should disallow it.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201212022133
http://biglumber.com
four months, if that makes you feel better! :)
Congrats!
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201210271914
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlCMau4ACgkQvJuQZxSWSshdoQCg6eJ14LLcJrn04rN2/efO14iz
of what rules give us
that SQL standard features do not?
Even if the answer is nothing, if we do not implement the SQL standard
feature yet (exhibit A: updateable views), it's a moot point unless
the goal is to spur development of those features just so we can
deprecate rules.
- --
Greg Sabino
that logins are working? :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201210101310
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
the up to point A or not, where point A is usually
a simple query such as SELECT 1. Knowing various failure states
as returned by PQping* does not seem to fit into such tools -
any failure needs to be handled manually.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http
, but that's an alternative
interpretation that doesn't involve our beloved pgfoundry. :)
Oh, and -1 for putting it in core. Way too early, and not
important enough.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201209222334
http://biglumber.com/x/web?pk
certainly generate a pile of
application compatibility problems.
Okay, but what about a more targeted solution to the original
poster's problem? That seems doable without causing major
breakage elsewhere
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http
already, once could argue a limited test case - but it seems
difficult to design some pg_bench options generic and powerful enough
to handle other cases outside of the one software this change is aimed at.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP
a purposefully slow hashing function like bcrypt.
but I disagree: I don't like any scheme that encourages use of low
entropy passwords.
Perhaps off-topic, but how to do you figure that?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8
, md.c:631
(5 times) Cache lookup failure:
XX000: cache lookup failed for relation 1554847255
LOCATION: has_subclass, plancat.c:921
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpBH51gd5sgI.pgp
Description: PGP signature
if this related to the relatively recent btree errors, but figured
I would get it out there. There is also an even rarer sprinkling of:
ERROR: relation with OID 3924107573 does not exist
but I figured that was probably a variant of the first error.
--
Greg Sabino Mullane g...@endpoint.com
End Point
: UPDATE mytable SET foobar = 'T' WHERE id IN ($1,$2,$3,$4)
I'll start the wheels rolling for upping the verbosity.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgp1V3duXPAQS.pgp
Description: PGP signature
place.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpSmpP1G2bZT.pgp
Description: PGP signature
(work_mem is 24MB). I'm not sure I understand
what could be causing both the 'read 0' and btree errors for the
same query - bad blocks on disk for one of the underlying tables?
I'll work next on checking each of the tables the view is using.
--
Greg Sabino Mullane g...@endpoint.com
End Point
and reindexed twice an hour during the times
this happens (which is, during normal business hours). There is a lot
in churn in pg_class, pg_attribute, and pg_depend in particular from
all the temp stuff being created and torn down all day, as well as
some Bucardo pg_class updating.
--
Greg Sabino
On Mon, Jun 04, 2012 at 02:09:44PM -0400, Tom Lane wrote:
Greg Sabino Mullane g...@endpoint.com writes:
We have a 8.3.18 system (yes, the same one from the previous
thread, finally upgraded!) that gave us this error yesterday:
ERROR: index pg_class_oid_index is not a btree
That means
proactively do? No other system catalog problems have been seen
before it or since.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgp83Kexp6hqX.pgp
Description: PGP signature
.
For the record, same here. We do *lots* of DDL (hence the cronjobs
to vac/reindex system catalogs).
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpuQRprn1huB.pgp
Description: PGP signature
.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpGtYKGLr70y.pgp
Description: PGP signature
On Sat, May 26, 2012 at 12:17:04PM -0400, Tom Lane wrote:
If you see any block numbers above about 20 then maybe the triggering
condition is a row relocation after all.
Highest was 13.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpa6XGTGTEIZ.pgp
On Sat, May 26, 2012 at 01:25:29PM -0400, Tom Lane wrote:
Greg Sabino Mullane g...@endpoint.com writes:
On Sat, May 26, 2012 at 12:17:04PM -0400, Tom Lane wrote:
If you see any block numbers above about 20 then maybe the triggering
condition is a row relocation after all.
Highest was 13
know if you think of anything particular I can test while it is
happening again. I'll try to arrange a (netapp) snapshot the next time
it happens as well (this system is too busy and too large to do anything
else).
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key
was).
* Did anything in the 8.3 series fix this? I saw nothing relevant in
the release notes for everything up to 8.3.18 (which it will be on soon).
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpwbxRekkZQf.pgp
Description: PGP signature
|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x2ac062cd9000
12:18:40 write(13, ...
...(normalish looking strace output after this)...
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpgvtyJ9p6Fs.pgp
Description: PGP signature
appeared.
Let me know if you'd like any of those warnings from the logs.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgp9P2W8oU7Y8.pgp
Description: PGP signature
were significantly invested
in [re]writing the patch, you get a name. Reviewers, I love you dearly,
but you don't belong next to the patch. Group them all at the bottom
if we must have them there.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key
thread, but the answer to the above is yes.
Release notes are very public, plain text, easy to read, very archived
and searchable. Commit messages might as well be a black hole as far as
visibility to anyone not a developer in the project.
- --
Greg Sabino Mullane g...@turnstep.com
End Point
but
little free time.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201204191031
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk
.
That's about the same amount that I have.
I have no spam at all, despite being a fairly early github adopter.
Wonder what the difference is?
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201204191044
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
.
...
Someone mentioned upthread that github spam was a problem. I'm not sure
I see the issue here - wouldn't mail from them still go through our lists
and out current anti-spam measures anyway?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key
as we have someone
to take ownership.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201204172131
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk+OL/0ACgkQvJuQZxSWSshMxACeJdr+WO4ttA2mkrGLv98PTTSH
not the same.
pgsql-commit-di...@postgresql.org, anyone?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201204121121
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
really care about
sub-second resolutions.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201204091345
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk
: relink `libxml2mod.la' with the
above command before installing it
I don't have time/inclination to track down why the make is failing, but
may have some time to run any Postgres-specific tests, if anyone wishes
me to.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8
but
libxml was being *really* problematic so I abandoned the install, but
I guess it left some pieces around. I will see if I can clean it up.
BTW, right at the moment you seem to have git issues, too.
Thanks, I will check on that.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8
, but
really need a strong argument for conceding things like LPAD.
* Your = everyone else, not just M. Haas.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201202181145
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
! :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201202101157
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk81TI4ACgkQvJuQZxSWSsivRQCfcze1WMq81rE+mtrOReHBQ6eV
me the other day.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgprM9aFgot2o.pgp
Description: PGP signature
.
Thanks for all replying to this thread, it's been very helpful.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpkFVkl3Xl3T.pgp
Description: PGP signature
Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpsMUli41Pnm.pgp
Description: PGP signature
people should
pay when going to 9.1, rather than adding some switch now.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgp7jN6DSMohw.pgp
Description: PGP signature
talking insignificant overhead? Minor? Is it measurable? Hard to say without
knowing the number of txns, number of locks, etc.?
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpXfFQOk4fgH.pgp
Description: PGP signature
noreturn()
RETURNS VOID
LANGUAGE plperl
AS $$ while (1) { select (undef,undef,undef,0.1) } $$;
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201109191104
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
with a little bit of SQL, e.g.
DELETE FROM pg_description WHERE objoid 5;
(test first, your system may vary and 5 may not work)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201109191143
http://biglumber.com/x/web?pk
for each
database. As shell scripts all over the world have been doing for years,
but it would be nice if it was simply built in.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201109012139
http://biglumber.com/x/web?pk
how it does it
check_postgres queries the system catalogs, normalizes some things based
on the version, and creates a Perl object representation of the database.
It then compares that to the same thing from a different database/server,
or to a frozen version of an earlier scan.
- --
Greg Sabino
) that needs
parsing, there is an existing tool:
http://blog.endpoint.com/2010/01/splitting-postgres-pgdump-into-pre-and.html
Once these new flags and the ability to custom format dump pg_dumpall
is done, I'll have very little left to complain about with pg_dump :)
- --
Greg Sabino Mullane g
other way altogether.
Maybe it's time to finally remove the been-deprecated-for-a-while OIDs?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201108111654
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN
feature, why not now?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201108112140
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
are doing something that it matters enough which
tables are shared, you really oughtta know about them anyway.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201106212323
http://biglumber.com/x/web?pk
of the
items most closely associated with pg_stat_activity)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201106161132
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
fix as much as we can in one
swoop.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201106151246
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
current_query 'IDLE'
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201106142300
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
by other processes. I'm sure of this because Bucardo
went through the same questioning some time ago. We basically rewrote
the app a bit to use the on-disk PID files to replace some of the
lost functionality, and sucked up the rest. :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point
Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201105282322
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk3hvCgACgkQvJuQZxSWSsi8gwCfQq/2WRhtnN8HJKoup5KxTrI6
. :)
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201105082230
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk3HU0IACgkQvJuQZxSWSshp2gCeLzjdXPQ0NkwDzby0f8DzUErz
FUEAoLNkIzJ5jWxVP2Ck3BZgxhd6HUhq
=yALY
-END PGP
problem to diagnose, but I also think it will
affect less code and thus not elicit as much whining. Besides,
I never recommend clients use SMALLINT anyway. (That type you are
using: I do not think it's as efficient as you think it is)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
).
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201105012153
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk2+DqsACgkQvJuQZxSWSshRfQCgzX5JlnCmKTndA7WcF/mt0Kpk
into retraining equal() or touch any other parts of the code.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201104262139
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Sounds good to me ... who's volunteering?
(Andrew) I will as well. Github perhaps, Andrew? I'll be happy to get
some unit tests written.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key
bug that caused
this was fixed in llvm's HEAD, but HEAD will not compile for me yet, so
I cannot verify it yet. There's a separate bug concerning usage of
plperl, but that's for another day.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key
with clang. Getting that
removed does allow me to do a working make and make check. The make
takes orders of magnitude longer than gcc does, but that's an
issue for another day.
--
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201011160940
http://biglumber.com/x/web?pk
the
trick.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201011161302
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkzix3IACgkQvJuQZxSWSsgKxQCgl2vbUGS9plb1Zm7Sg+sdKR+5
oIUAn0CI9Dky2bQsYkoPhV6yZrQWosvQ
=f0+q
-END
version numbering. :) I think we got it right the first time.
David Fetter:
We're using Postgre 8
See also all the flocks of tools that claim to support Postgres 8
Flocks? Handful at best, and no reason we should be catering to
their inaccuracies.
- --
Greg Sabino Mullane g...@turnstep.com
). For the record,
I'm with Tom on this: -1 to any changes.
I do like the Ubuntu/Debian way of naming the releases
with some sort of non-numeric name though. :)
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201008202036
http://biglumber.com/x/web?pk
to persuasion. :)
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201008202130
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkxvLGQACgkQvJuQZxSWSsjIoQCfY4ANKov5TV/PDV+mc0Rhda5O
wskAoMjZ4y9t+VOlP+84NMfz7Ws1aNVV
=qRMV
.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201008202135
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkxvLZAACgkQvJuQZxSWSsjFcQCeMQX9fQcLZVv6q1wssFIsIMQE
INAAoJPEsMRsezdT2bAWP8xLZ7wSpxvh
=yKn1
-END PGP SIGNATURE
.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201008202330
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkxvSS0ACgkQvJuQZxSWSsjQ0QCfW/2l065L0XEO6kmnARpjgqJ5
t2EAn3xM8w5f5xmHl3EZAmXhxXFpEREo
=/CYr
-END PGP
like the plague.
The existing solution works fine as long as we explain that caveat (which
is a little bit of a corner case, else we'd have heard more complaints
before now).
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8
of awfulness.
They should be querying information_schema.
I'd sure like to be able to write queries that *don't* involve
array smashing or using grep on \z output to analyze object
permissions.
Yeah, that would be a better information_schema. :)
- --
Greg Sabino Mullane g...@turnstep.com
End
a bunch of views to abstract
away most of the current complexity for these usecases?
Yep, agreed. Now, if we can just agree to put information_schema in the default
search_path, because nobody enjoys having to type out information_schema...
- --
Greg Sabino Mullane g...@turnstep.com
End Point
a GUI (or a new driver) should be expected to be familiar
with the system catalogs. Moreover, a GUI relies on an underlying
driver, and every driver should already be providing things like
a list of tables natively.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http
% of cases where people are not using psql.
Yes, and everything else already has a show tables. See
for example, PPA:
http://phppgadmin.sourceforge.net/images/4.png
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201007191342
http
alleviate what may
be a gotcha for some.
This one is more doable, assuming we are really talking about:
SELECT * FROM tab_completion WHERE btab
Keep in mind it will show up in a list if you do the following:
SELECT * FROM tab_completion WHERE tab
- --
Greg Sabino Mullane g...@turnstep.com
End
1 - 100 of 415 matches
Mail list logo