-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm leaning slightly to the fold-it-into-PQprepare way, but am by
no means set on that. Comments anyone?
As a heavy user of libpq via DBD::Pg, +1 to folding in.
- --
Greg Sabino Mullane [EMAIL PROTECTED] [EMAIL PROTECTED]
End Point Corporation
such an information, can
reach it quite easily via PQdescribePrepared().
That's a good point, however, along with your other arguments. :) I
could live with either way.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200608110849
http://biglumber.com/x/web?pk
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What version of Bison is currently required to compile HEAD? 1.75
doesn't seem to work...
1.875
Search for Bison here:
http://projects.commandprompt.com/public/pgsql/browser/trunk/pgsql/doc/src/sgml/installation.sgml
- --
Greg Sabino Mullane
that REINDEX now does.
Right now, we have tables that are updated very frequently, and a
vacuum full just doesn't do much to reduce the disk space, as
the indexes keep growing until a REINDEX is done. Tried on HEAD
as well.
Thanks,
- --
Greg Sabino Mullane [EMAIL PROTECTED] [EMAIL PROTECTED]
End Point
nicer with underscores in patterns.
Hmph. I was just copying the surrounding code, in the theory that it
increases the chance of my patches being accepted. :)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200608182237
http://biglumber.com/x/web?pk
, but someone added a FIXME at some point, which led me to
ask exactly what should go in there. Not a big deal, I suppose - it looks
as though few, if any, other products are using those fields either.
Thanks for the reply.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key
existing ideas? Any objections
to giving this a try?
- --
Greg Sabino Mullane [EMAIL PROTECTED] [EMAIL PROTECTED]
End Point Corporation 610-983-9073
PGP Key: 0x14964AC8 200609021107
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iD8DBQFE+Z
a bit :-)
It will certainly make porting applications from MySQL to
Postgres a lot easier, and such porting is where a lot more
effort needs to be put, IMO. (I mean more people working
on porting applications, not adding mysqlisms to the code :)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point
another way to test that the schema was created by another process.
I agree that is_visible may not be ideal for most cases, but it should be okay
if we are simply using it to filter temporary schemas, right?
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8
was created by the same user, but in
another session.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200609041941
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iD8DBQFE/LsJvJuQZxSWSsgRAt5mAKDWAWmnljELeRJn
a is_visible clause to the query above. That or start
tracking which pg_temp_ schema belongs to whom.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200609061927
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
certainly help out with the
content when I can as well, but it seems we are still tying to hash
out some ground rules at the moment.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200609171112
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP
Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200609181159
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iD8DBQFFDsKgvJuQZxSWSsgRAn70AKCwa2jePz+wyJdFqzMvgqjYkRWFDwCeK6s/
TXJAHKinmRYXfT8o8eV1PYc=
=f5vT
-END PGP
SMALLINT NOT NULL,
person INTEGER NOT NULL,
rating SMALLINT NOT NULL,
viewed DATE NOT NULL
);
I also recommend not loading the entire file until you get further
along in the algorithm solution. :)
Not that I have time to really play with this
- --
Greg Sabino Mullane [EMAIL PROTECTED
objects is a fair one,
but I think we've morphed far beyond solving that problem.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200610092003
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
.
They are all listed at the top of the file, in case there is any confusion.
No need to worry about remembering things.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809031501
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
for core and
committers.
That problem needs a solution, but not the one you proposed.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809050953
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
, if not there already?
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200809081014
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkjFM2AACgkQvJuQZxSWSsiDvACdE6Wlrnu3uQH4mOpuEMvX0VQe
about we make it further
in the future (perhaps 2009-07-01, six months into the next year), and announce
the change far and wide?
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809180939
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP
including 7.4.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809181123
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkjScrkACgkQvJuQZxSWSshnKACg1+QxldUo8fHX/ULeDkWwclCh
SpkAoKkN6tOclSqWl3YIGTpfDRMoINNh
=Anux
as the PG project is releasing
point revisions to the 7.4 branch. As I said, I'm all for getting people
off 7.4, but it needs to be done with a definite date, and December is
way too soon.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809181205
http://biglumber.com/x/web?pk
, press release).
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809191537
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkjT/3YACgkQvJuQZxSWSsgFDwCff7IQVYz2q7GvHZEio51XUoq1
bkYAnRF1mYj8+A3cVzb4WxYw7VG28uRR
=VrxN
, there will be an ever-increasing tendency
to *not* upgrade to the latest and greatest, since the version they
have already kicks ass, thank you very much[1].
[1] 8.3 rocks, by the way, thanks to all involved.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809191545
http://biglumber.com
, such as October 1, 2009?
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809201226
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkjVJDgACgkQvJuQZxSWSsjCuACgxGqmADfgGlHekGI+TXfQTAnr
CroAnAuMs9sMcRvjBBDFlYV5+dY8wlra
Looks like the box-array semicolon got changed to a comma at some point -
attached patch changes it back (\054 to \073)
--
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 20080927
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
Index: src/include/catalog
nothing looks at
the value ... the element type's delimiter is what array_in/out use.
Ah, okay, that makes sense. Thanks for the explanation, I'll tweak
my code to do it the right way by looking at the base type.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809230934
http
it doesn't matter to the backend, and who knows what else it may break.
Kind of silly to spend too many cycles on this, of course, as it's
really only box at the moment that uses a non-standard delimiter. :)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200809231133
http
.
--
Greg Sabino Mullane
Index: command.c
===
RCS file: /projects/cvsroot/pgsql/src/bin/psql/command.c,v
retrieving revision 1.196
diff -c -r1.196 command.c
*** command.c 15 Sep 2008 12:18:00 - 1.196
--- command.c 7 Nov 2008 20:59
, per comments in this thread.
--
Greg Sabino Mullane
Index: command.c
===
RCS file: /projects/cvsroot/pgsql/src/bin/psql/command.c,v
retrieving revision 1.196
diff -c -r1.196 command.c
*** command.c 15 Sep 2008 12:18:00 - 1.196
Add in the tup_fetched column.
--
Greg Sabino Mullane
Index: doc/src/sgml/monitoring.sgml
===
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/monitoring.sgml,v
retrieving revision 1.62
diff -c -r1.62 monitoring.sgml
*** doc/src/sgml
is STATEMENT
--
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200811281627
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkkwY5AACgkQvJuQZxSWSsgK8gCeIeAJ1P45EOciwYOBlseezjMt
there is no way
to effect a statement-level trigger using an insert on a table that is
inherited from. My workaround is to insert and then update all the rows.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200812011030
http://biglumber.com/x/web?pk
officially okay with either solution then. Thanks!
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200812011431
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
need some real-world use cases involving payloads, let me know, I've
been waiting for this feature for some time and have it all mapped out.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 200911160902
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN
Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200911160910
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAksBXkAACgkQvJuQZxSWSsjEWACePcT+65HQ0dvx52PjjTkdMzVS
ELMAnAhR3Ll016/EwPdizzS5BcsuXaw9
=jds6
-END
when they hit 12 and get
random (and crappy) query plans. Is the value of 12 based on any
recent measurements? Thanks.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200911162121
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN
per second, tops. If someone knows an
easy way to measure such a thing and is really curious, I can see about
getting better numbers.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200911162127
http://biglumber.com/x/web?pk
as minimizing this unexpected foot gun for
future releases. Thanks.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200911170859
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
like the is the idea of a
notify that *may* work or may not - so let's keep it boolean: it either
works 100% of the time with 2PC, or doesn't at all. Should we throw
a warning or error if a client attempts to combine the two?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key
formatting from
parenthesization decisions in ruleutils.c. That's not going to be
me, though.
Comments, preferences?
Apply (2), and add the decoupling to the official todo list.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 200911201315
http://biglumber.com/x/web?pk
the advocacy team know so we can start work on it.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200912011122
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAksVQtgACgkQvJuQZxSWSsj26ACgr
it
hard to support raising the GEQO threshold, as most recently suggested
by Greg Sabino Mullane here (and previously by me on an earlier
thread):
What about 14? Could we at least raise it to 14? 1/2 :)
I'm worried this is going to get bogged down like so many of our
threads, where we worry about
to, but they can't easily afford the downtime to
upgrade. Cutting them off arbitrarily early won't win us any friends. Once
pg_migrator (or better, in-place upgrades) is working well, we can start setting
EOL on versions based on number of years of some other criteria.
- --
Greg Sabino Mullane g
it's probably
more of the second option.
The postgresql.conf file has been supporting a toaster for a
long time now, but we don't seem to recognize that the minimum
toaster^H^Hhardware encountered in the wild changes quite a
bit from year to year. IMHO.
- --
Greg Sabino Mullane g...@turnstep.com
in the
other direction. Even if I secretly agree with Tom 99% of the time. :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200912021705
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
. In other
words, if the average flat plan/execute speed for a 13-way on an average
box was 15 seconds in 2000, but 2 seconds in 2009, I would presume that
it would now be worth it to consider 13 as needing default geqo coverage.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key
always involves production downtime.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 200912040846
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAksZEqMACgkQvJuQZxSWSsgGyACdEyfIqwFsFrt9ZnQ2DNPVYIWP
j08AoK
that those in the machine readable output
should never be seen by human eyes camp will support my upcoming
patch to remove all extra whitespace, including newlines, from the
XML format. :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200912070727
http
.
(This goes for the person on this list concerned about the output
being too hard to parse. Yes, YAML has lots of tiny corner cases
and elaborate syntax, but we're not using any of those, so parsing
should be quite possible for any YAML parser out there).
- --
Greg Sabino Mullane g...@turnstep.com
End
particularly relevant.
I don't use JSON, but I do use YAML. Attached, please find a patch
that implements hstore_to_yaml().
just kidding. :)
I think we are getting the cart way before the horse.
+1. Smells like a solution in search of a problem, as they say.
- --
Greg Sabino Mullane g
don't have it, no harm, no foul.
We could even bundle DBI and DBD::Pg to ensure that the minimum versions
are there. All the prerequisites should be in place for 99% of the machines:
a C compiler and Perl are the biggies, and I can't see any buildfarm members
running without those. :)
- --
Greg Sabino
,
and the sooner we can get it out there the better. Those that are
waiting for SR might have to wait one more version, but my intuition
tells me that's a small minority compared to those waiting for HS.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201001071231
http://biglumber.com
need to test in order to have
confidence in a local build.
I thought we were leaning towards something separate.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201001071234
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
seems a safer way to go.
I'm still *very* interested in making a libpq-less pure perl driver,
if anyone feels like funding it, let me know! :)
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201001071236
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN
sure about that...
Well, I can state that we have plenty of clients that would be very
interested in HS, but none that would really care if it came without
SR. This power user knows a lot of people outside of -hackers and
- -general and they are what I'm basing my opinion on. :)
- --
Greg Sabino
if we're talking about an additional/optional
set of tests. Also, Tim Bunce and I are right here, so the maintenance
should not be that bad (and I'd hazard that a lot more people in
the community know Perl/DBI than zic or stemmers).
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8
the wiki?
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201001082147
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAktH7scACgkQvJuQZxSWSsjLPACgmof4H4ux/0qpOPbpHIfKrM5E
gm4AoKN9BhihZqZeS6rDQo1j8l9B+uVL
=cxEm
-END
is meant as a quick shorthand convenience, not a literal payload
of important information. On the other, it should at least match
the current rules for the listen and notify names themselves, which
means allowing more than ASCII.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8
quantity (DBI + Test::More).
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201001102316
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAktKplIACgkQvJuQZxSWSsj7TQCeMOXWS+uLIZE9QbeBWPxYv/rg
HhEAn0QZUzE2/8uyg5Oi+K8qL
of testing may be better.
http://search.cpan.org/~mergl/pgsql_perl5-1.9.0/Pg.pm
Works as well? Did you take a look at that link? The last update was
early 2000, which should give you an indication of just how dead
it is.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8
not got three valid options. :)
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201001151129
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAktQmI0ACgkQvJuQZxSWSsgNugCgjwkT9QwGpvhcIXCNYhRcTwSW
JZcAnjvrsjwpO/QvJ1LzU
and overloaded term.
On the other hand, it's a great buzzword, so we should use
the phrase as much as possible in the press releases. :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201001151257
http://biglumber.com/x/web?pk
they've implemented some sort of shortcuts
since the last time I used Oracle. Which seems very unlikely, as they
obviously have no love for sqlplus (Oracle's command line client), which
has been stuck technologically in place for decades (hello, readline?)
- --
Greg Sabino Mullane g...@turnstep.com
to do it.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201001210726
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAktYR90ACgkQvJuQZxSWSsjDmACfVud6mJMRDX5poG1c+Y+z4UYw
jUIAnR9+OaIHNDwT3ZhiCivMF3skGJwn
=fWzV
-END
as soon as possible, and undo the mistake of changing
it from Postgres in the first place. Changing it to coincide
with the interest bounce we'll get from the Oracle/MySQL
situation seems a no-brainer from an advocacy perspective.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8
surprised me,
but never enough to bother complaining about it. However, count me
as a +1 to make warn == elog(WARNING)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201001220941
http://biglumber.com/x/web?pk
are working on
other Postgres-related things, including, at times, advocacy.
I'll move this over to -advocacy where it belongs, along with some
more concrete discussion of how we would make the name change,
when and if it happens.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8
) is the time to
do it.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201002031233
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
of
the game. We didn't wait for every driver, app, and script to support
schemas before we added them in 7.4, for example. We certainly didn't
wait for applications to be implicit casting ready before 8.3, to (over?)use
another example.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I have written up a set of guidelines for driver development
based on what I learned working on ruby-pg:
http://wiki.postgresql.org/wiki/Driver_development
...
I would appreciate comments by anyone (Greg Sabino Mullane: I included
you
the types, inside the query itself. Having the driver indicate
the type should be the exception, not the rule.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201002091811
http://biglumber.com/x/web?pk
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
* We also discussed the idea of having a NOTIFY command that
would work from Primary to Standby.
Just curious, what's a use case for this?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key
};
}
Not sure what you mean by adapting interfaces to send payloads, I imagine
most if not all simply require a NOTIFY to be sent via PQexec.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201002171302
http
hack) will encompass
payloads as well.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201002181600
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
.
Is that immanent?
Barring sudden free time, funding, and/or a client request, no.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201002181711
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
. (One could count lines,
but that's presumes the order and number of items will never change).
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201003050945
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN
of production scripts. It wasn't meant to
produce machine-readable output, much less to give values that you could
rely on with respect to a running server.)
I mostly use it to check on the progress of a PITR slave: just curious,
is there a better/preferred way to get that information?
- --
Greg Sabino
?
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201004010941
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAku0oqQACgkQvJuQZxSWSsiJmACghUKR/i+uyJ2n+beuAid4w432
s0oAnArOf1npuMF/7QJ87ZVmSYMlJTRp
=/+yd
-END PGP
Patch attached to show the schema *and* table name when doing
a REINDEX DATABASE.
--
Greg Sabino Mullane g...@endpoint.com g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8
Index: backend/commands/indexcmds.c
===
RCS file
and -interfaces.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201004081214
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAku
this is such a thorny problem, and this is a temporary table, why
not just disallow ALTER completely for the first pass?
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201004241201
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
/regress/sql/copy2.sql
from a temp table to a real table, as I could not find an easy
way to represent a wild card temp schema name inside of the
test/regres/expected/copy2.out file.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
Index: src/backend/commands
= 'mm';
ERROR: invalid input syntax for integer: mm
LINE 1: delete from public.foo where id = 'mm';
Yes, I realize those are technically different context cases, but
from an application point of view, the COPY case is wrong and
needs fixing.
- --
Greg Sabino Mullane g...@turnstep.com
End
particular case can be solved by making the
servers be in time sync a prereq for HS working (in the traditional way).
And by prereq I mean a user beware documentation warning.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201005031539
http
Subject line kind of says it all: LANGUAGE replacement was
introduced in 9.0, but pg_dump is trying it on all versions.
--
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 201005121537
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
diff
a clearer distinction of list topics, I
might support such a move, but we don't, so I can't.
... and, for those that have been here awhile, who should know better,
why isn't there any self-management of this sort of stuff in the first
place?
What would you have us do?
- --
Greg Sabino Mullane
and -admin. Would anyone argue against rolling those
two (sql and admin) into -general as a first step?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201005141009
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
quickly database driver developers can adapt.
DBD::Pg is already patched, and will very likely be released before 9.0
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201005191105
http://biglumber.com/x/web?pk
to figure out how to represent that in
the form of tests.
No, that's exactly backwards. We can't define all the things a language
can do, but we can certainly lay out the things that it is not supposed to.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP
src/pl/plpython/plpython.c
src/pl/tcl/pltcl.c
src/timezone/pgtz.c
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201005211520
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
scheme, how would it be able to distinguish
between those two cases (nothing there yet vs. was there but purged)?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201005231646
http://biglumber.com/x/web?pk
will the *function* know, if a superuser and/or some
background process can purge records at any time?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201005240928
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
. But it looks like the
ship has already sailed upthread and we've more or less got a working
definition. David, I think you started this thread, I assume you have
some concrete reason for asking about this (new trusted language?).
May have been stated, but I missed it.
- --
Greg Sabino Mullane g
a cartridge_def
Now in T2 insert a cartridge replacement.
Works as expected in my schema when I tried it: T2 blocked at the insert,
waiting on T1. Once T1 committed, T2 threw an error, as the insert was no
longer valid. Using serializable or not, same result.
- --
Greg Sabino Mullane [EMAIL PROTECTED
?/archives/106-Putting-EXPLAIN-results-into-a-table.html
I'd rather see tables with a convert-to-XML function than direct XML FWIW.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200706131211
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
fragments.
+1 to this idea in general, but *please* don't consider the use of
XML. If we really need some sort of formatting, let's do CSV. Or
YAML. Or JSON. Anything but XML.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200908041806
http://biglumber.com/x/web?pk
Attached patch adds YAML output option to explain:
explain (format YAML) select * from information_schema.columns;
--
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 200908281414
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
Index: contrib/auto_explain
.
By the way, Magnus pointed out an error in the patch: the hunk at
- -1693,7 +1736,6 should be ignored.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 200908281552
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE
Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 200908281741
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAkqYT0QACgkQvJuQZxSWSshPMACg+ho+gTxeKR27pOJrbX7kTJ9E
kZIAnRIz57KzuLAAr6PtjupBwletuXRe
=ZJO7
-END PGP SIGNATURE
On 08/28/2009 02:16 PM, Greg Sabino Mullane wrote:
Attached patch adds YAML output option to explain:
explain (format YAML) select * from information_schema.columns;
Updated version of the patch attached, fixes two small errors.
--
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8
101 - 200 of 415 matches
Mail list logo