in that
if we want them to upgrade to take advantage of features, we have to
make it so the least amount of work possible is needed to make that
upgrade happen.
Rewriting many thousands of lines of dynamic sql to upgrade to 9.2 is
certainly not doing that :).
Sincerely,
Joshua D. Drake
On 01/03/2013 02:30 PM, Kevin Grittner wrote:
Andrew Dunstan wrote:
I don't especially have a horse in the race, but ISTM that if you want
the information you want it to be able to persist across dump/restore,
at least optionally. If you can happily lose it when you're forced to
recover
approach. What I am saying is that it should be THAT easy [1].
[2] Multi version rpms on the same box still need some help (lib issues)
[3] Bruce, you rock... pg_ugrade is the bomb
Joshua D. Drake
1. Obviously I am talking about the simplest of configuration and there
are a whole slew of other
On 12/18/2012 11:57 PM, Simon Riggs wrote:
On 19 December 2012 03:03, Josh Berkus j...@agliodbs.com wrote:
So, my question is:
1. should we detect for replication cycles? *Can* we?
2. should we warn the user, or refuse to start up?
Why not just monitor the config you just created?
On 12/19/2012 12:34 AM, Simon Riggs wrote:
My logic is that if you make a 1 minute test you will notice your
mistake, which is glaringly obvious. That is sufficient to prevent
that mistake, IMHO.
If you don't test your config and don't monitor either, good luck with HA.
I am not arguing
opportunity here is to make statistics non-user visible. I can't think
of any reason that they need to be visible to the standard user? Even if
when we set the statistics private, it makes just that column non-visible.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http
On 11/07/2012 02:46 PM, David Fetter wrote:
On Wed, Nov 07, 2012 at 12:55:03PM -0800, Joshua D. Drake wrote:
Hello,
So it is possible to do this in other ways but I thought it might be
interesting to allow people to define fifo or pipe as a
log_desination. This would allow a person to tail
On 11/07/2012 10:22 PM, Peter Eisentraut wrote:
On Wed, 2012-11-07 at 12:55 -0800, Joshua D. Drake wrote:
So it is possible to do this in other ways but I thought it might be
interesting to allow people to define fifo or pipe as a
log_desination.
You could do this with a logging hook
Hello,
So it is possible to do this in other ways but I thought it might be
interesting to allow people to define fifo or pipe as a log_desination.
This would allow a person to tail the fifo to receive the outputs of the
log as it happens but would not take up precious IO or space from the
On 10/18/2012 04:43 AM, Simon Riggs wrote:
On 18 October 2012 12:20, Magnus Hagander mag...@hagander.net wrote:
Since Simon stirred up a hornets nest suggesting deprecation of a
number of features, I figured I'd take it one step further and suggest
removal of some previously deprecated
should be deprecated and removed.
My suggestion for docs is:
Note: Do not use, use Triggers with Functions instead link
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability
On 10/17/2012 10:46 AM, Greg Stark wrote:
I dislike both of the explanations above which don't actually explain
why people shouldn't use rules (Josh does say they're tricky which is
a start). Just telling people we hate parts of the system doesn't
really come off well and leaves them wondering
On 10/17/2012 11:32 AM, Josh Berkus wrote:
I am not sure where to stick it but we should also include the fact that
rules are almost always slower that a trigger/function comparative.
That wouldn't be accurate, actually.
Let me add: when used with partitioning. I should have been more
On 10/11/2012 03:59 PM, Josh Berkus wrote:
I'm also not real keen on the idea that someone could dump a 9.2
database and be unable to load it into 9.3 because of the DDL trigger,
especially if they might not encounter it until halfway through a
restore. That seems rather user-hostile to me.
On 08/20/2012 01:21 PM, Josh Berkus wrote:
I don't think US export regulations are the only issue. Some other
countries (mostly the usual suspects) forbid the use of crypto software.
If we build more crypto functions into the core we make it harder to use
Postgres legally in those places.
it makes absolute sense to keep them in contrib or pgxn
but cryptography is pretty much a basic core feature set at this point.
MySQL, MSSQL, Oracle (not sure if integrated or as a pack) and not to
mention Java and Python all have them integrated.
Sincerely,
Joshua D. Drake
--
Command Prompt
visibly, I don't know that this argument would ever come up.
Sincerely,
Joshua D. Drake
cheers
andrew
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
On 07/24/2012 10:26 AM, Kevin Grittner wrote:
I have recently been laid up with a MRSA infection, which left me
suddenly unable to deal with even reading my email. (I took a shot
at catching up a week ago, and it was too taxing, resulting in a
relapse.) I'm trying to fight though the backlog
On 07/19/2012 01:04 PM, Pavel Stehule wrote:
I did a backport of temp_file_limit feature to 9.1, but when we tested
this patch, we found very restristrictive limit to 2GB.
2GB is nonsense, because this is session limit of temp files, and
these files should be longer than 2GB.
I haven't read
On 07/19/2012 01:48 PM, Christopher Browne wrote:
On Thu, Jul 19, 2012 at 4:29 PM, Joshua D. Drake j...@commandprompt.com wrote:
On 07/19/2012 01:04 PM, Pavel Stehule wrote:
I did a backport of temp_file_limit feature to 9.1, but when we tested
this patch, we found very restristrictive
On 07/09/2012 12:02 PM, Josh Berkus wrote:
Hackers,
So I want to repeat this because I think we are conflating several uses
for a bug tracker which aren't the same, and which really need to be
dealt with seperately.
-- Better CF App: to track feature submissions, discussion, revisions
and
On 04/27/2012 11:33 AM, Simon Riggs wrote:
Well, they all sound similar. My info was that Mammoth was not WAL-based.
Mammoth was transaction log based but not WAL based.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
://www.pgconf.eu
Lastly, there is a Denver PgDay in October. PgDay's are a great way to
meet locals and enjoy a smaller community setting but still maintain top
notch content.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional
On 04/18/2012 11:56 AM, Josh Berkus wrote:
On 4/18/12 11:53 AM, Joshua D. Drake wrote:
Lastly, there is a Denver PgDay in October. PgDay's are a great way to
meet locals and enjoy a smaller community setting but still maintain top
notch content.
Date? Hopefully not the same time as pg.EU
On 04/16/2012 09:24 AM, Alex wrote:
Jay, Alvaro, Dimitri (and whoever else wants to speak up) could you
please describe your ideal tool for the task?
Given that every other existing tool likely have pissed off someone
already, I guess our best bet is writing one from scratch.
Or maybe there
Hey,
Just a reminder that the CFP for PgNext in Denver is still open. Let's
get those talks in folks!
https://www.postgresqlconference.org/
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services
Hello,
It has been brought to my attention a few times over the last year that
I have been over the top in my presentation of myself and have in fact
alienated and offended many of the community. To be honest I am unaware
of everything I have done but I do take the opinion of those who have
Hello,
The call for papers for PgNext (the old PgWest/PgEast) is now open:
January 19th: Talk submission opens
April 15th: Talk submission closes
April 30th: Speaker notification
Submit: https://www.postgresqlconference.org/talk_types
Sincerely,
JD
--
Command Prompt, Inc. -
, by
far. That said, I am not really arguing against your other points except
to answer your question.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http
On 11/09/2011 03:56 PM, Josh Berkus wrote:
So that's my take on it. It's not a tomorrow severity release
(we've been living with the workaround for months, even though it is
blocking some things), but I would really appreciate an expedited
release to enable unattended hot-standby operation
On 11/09/2011 06:15 PM, Robert Haas wrote:
2011/11/9 Devrim GÜNDÜZdev...@gunduz.org:
On Wed, 2011-11-09 at 21:12 -0500, Robert Haas wrote:
The point is that all the packaging will be done *before* people leave
to go eat Turkey.
Eating me?
:-)
No, just your country.
I hear it is a
,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
--
Sent via pgsql-hackers mailing list (pgsql
* unite recovery.conf and postgresql.conf
This one also seems to be lacking consensus more than anything else.
What do we do about that?
AFAIR, the only person objecting is Simon. I'm not necessarily saying
that means we should drive it in over his objections, but OTOH there
were quite a
On 10/21/2011 05:42 PM, nrdb wrote:
Hi,
I am new to this list. I haven't ever contributed code before, and have
no idea on how to do this.
I have made some changes to my copy of the 9.1.1 code that
encrypts/decrypts the database files on the fly using AES256 cypher.
Very cool.
It passes
On 10/22/2011 11:39 AM, nrdb wrote:
Are you willing to submit a patch for people to review? I am not sure
if the community would want this as backend code or not but it is
definitely something to discuss.
Yes! but I don't know what the procedure is to do that.
On 10/07/2011 11:40 AM, Tom Lane wrote:
Robert Haasrobertmh...@gmail.com writes:
Please find attached a patch implementing a basic version of
index-only scans.
I'm making some progress with this, but I notice what seems like a
missing feature: there needs to be a way to turn it off.
with adding an include to postgresql.conf manually.
As Simon has already appropriately posted You would be incorrect.
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http
On 09/14/2011 05:12 AM, Hannu Krosing wrote:
On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote:
Complete isolation at the user level, allowing an ISP to support
multiple independent customers on a server without having to fiddle with
multiple back ends each running on a separate port
to
reinvent the wheel. Why would we support that?
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509
that?
There are other databases out there, too, why reinvent the wheel by
working on PostgreSQL? :-)
The question shoud be, would this be USEFUL?
Personally, I don't think so but others may disagree.
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support
Anyone on all of this?
On 09/09/2011 02:31 PM, Alvaro Herrera wrote:
Excerpts from Alvaro Herrera's message of mar ago 09 13:01:04 -0400 2011:
To implement this, we need to augment MultiXact to store the lock type
that each comprising Xid holds on the tuple. Two bits per Xid are
needed.
Hello,
We are in the final 48 hours of the CFP for PgWest. Let's get those
talks in.
https://www.postgresqlconference.org/talk_types
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
On 08/11/2011 01:57 PM, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
1. The way that nodeIndexscan.c builds up the faux heap tuple is
perhaps susceptible to improvement. I thought about building a
virtual tuple, but then what do I do with an OID column, if I
Hello Hackers!
The CFP for West has been extended until the 12th of August. Let's get
those talks in!
https://www.postgresqlconference.org/talk_types
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL
On 07/22/2011 05:00 PM, Josh Berkus wrote:
Arguments in favor of coding from scratch:
1) Does not introduce new dependencies into postgresql-client packages.
(note how much of a problem Readline has been)
Readline has license issues, this doesn't.
2) keeps psql as lightweight as possible
On 07/23/2011 03:39 AM, Andrew Dunstan wrote:
1. I think the proposed use is of very marginal value at best, and
certainly not worth importing an external library for.
2. Even if we have the feature, we do not need to parse URIs generally.
A small amount of hand written C code should suffice.
On 07/21/2011 11:13 AM, Tom Lane wrote:
Joshua D. Drakej...@commandprompt.com writes:
So I am looking intently on what it is going to take to get the URI
patch done for psql [1] and was digging around the web and have a URI
parser library. It is under the New BSD license and is strictly RFC
/msg01144.php
It is letting pgsql use URI syntax.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509
libssl or any other
such thing.
I would imagine that rolling our own code would likely be simpler but
the code itself would be dumber (not bad, just not as capable) and we
would be duplicating the effort of an already established project. Do we
really want to do that?
Sincerely,
Joshua D
not being sarcastic),
if we don't let's just throw some simple code together, if we do, I
think this library makes sense, whether in our tree or not.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services
/html/rfc3986
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
--
Sent via pgsql
RFC
3986 [2] compliant .
Surely we do not need a whole library to parse URIs.
Shrug, standards compliant, already runs on windows
Seems like a good idea to me?
http://uriparser.sourceforge.net/
Sincerely,
Joshua D. Drake
regards, tom lane
--
Command Prompt
RFC
3986 [2] compliant .
Surely we do not need a whole library to parse URIs.
Also:
http://uriparser.git.sourceforge.net/git/gitweb-index.cgi
Sincerely,
Joshua D. Drake
regards, tom lane
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support
Hey folks,
As a reminder, PgWest is in a few months and the CFP closes in two
weeks. Get those talks in!
https://www.postgresqlconference.org/talk_types
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services
On 07/03/2011 11:54 AM, Peter Eisentraut wrote:
On sön, 2011-07-03 at 13:42 -0500, Michael Gould wrote:
I would like to request that full support for the UUID data type can added.
I think that even though there is a contrib module, since this is a standard
datatype that Postgres ought to be the
On 07/12/2011 06:54 AM, Alvaro Herrera wrote:
Excerpts from Magnus Hagander's message of mar jul 12 09:34:56 -0400 2011:
Agreed. On one level I like the sponsor message, but on the other
having Sponsored by RedHat on every Tom Lane item will get tiring.
;-)
Create a macro ;)
Can we add
On 07/12/2011 11:56 AM, Josh Berkus wrote:
Thom,
The functions to produce UUIDs are in contrib, but the UUID data type
itself is in core. You get the type uuid whether you install the
contrib module or not.
http://www.postgresql.org/docs/current/static/datatype-uuid.html
Oh!
I guess that
On 07/12/2011 09:15 AM, Andrew Dunstan wrote:
On 07/12/2011 12:03 PM, Joshua D. Drake wrote:
On 07/03/2011 11:54 AM, Peter Eisentraut wrote:
On sön, 2011-07-03 at 13:42 -0500, Michael Gould wrote:
I would like to request that full support for the UUID data type can
added.
I think that even
On 07/12/2011 01:29 PM, Andrew Dunstan wrote:
On 07/12/2011 03:44 PM, Joshua D. Drake wrote:
What about extensions makes them less usable?
It is an extra step, that is less usable. Does it matter? Shrug, I
know I hate having to type apt-get just to use xyz, does it mean it is
a big deal
On 07/10/2011 11:59 AM, Josh Berkus wrote:
On 7/3/11 2:02 PM, Tom Lane wrote:
Yeah. If there were One True Way to create a UUID, I would probably
agree that we should push that functionality into core. But there are
a lot of ways (and the reason for that is that they all suck in one
fashion
Per:
http://archives.postgresql.org/pgsql-hackers/2010-11/msg02043.php
It seems we did come up with a use case in the procpid discussion. The
ability to change the names of columns/databases etc, to handle the
fixing of bad decision decisions during development over time.
Thoughts?
JD
--
.
This isn't just about a few characters in a query, it is about
consistency and providing an overall more sane user experience. Frankly
I don't care if we use procpid or pid but it should be one or the other
not both.
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com
it for 9.2, we have 18 months
to communicate the change.
Joshua D. Drake
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 6/11/2011 1:23 PM, Bruce Momjian wrote:
There is a difference between a project name and something that directly
affects usability. +1 on fixing this. IMO, we don't create a new pid
column, we just fix the problem. If we do it for 9.2, we have 18 months
to communicate the change.
Uh, I am
unsuspecting in the wings.
+1 for submitting for 9.2.
+1 for not comitting to 9.1.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org
patches during beta if they suck.
I think Alvaro's point isn't directed at you Robert but at the idea that
this should be applied to 9.1.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
On 05/31/2011 01:12 AM, Peter Eisentraut wrote:
On mån, 2011-05-30 at 21:52 -0400, Robert Haas wrote:
I have used RT and I found that the
web interface was both difficult to use and unwieldly for tickets
containing large numbers of messages. Maybe those those things have
been improved, but
in
workflow though.
Nor am I, I was mainly bringing it up as a (better) alternative to
bugzilla and rt.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http
allow it.
Yes, it is a long standing argument.
Yes, it is ridiculous.
Yes, it is something that MySQL gets to make fun of us about (inside joke).
You have done what you need to do to check the status. Someone who knows
something about the bug should speak up at some point.
Sincerely,
Joshua D
Hello,
The CFP for #PgWest is now open. We are holding it at the San Jose
Convention Center from September 27th - 30th. We look forward to seeing
your submissions.
http://www.postgresqlconference.org/
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support
On 05/17/2011 01:31 PM, Darren Duncan wrote:
I have missed it if this was discussed before but ...
Would now be a good time to start deprecating the contrib/ directory as
a way to distribute Pg add-ons, with favor given to PGXN and the like
instead?
If PGXN moves into .Org infrastructure
. It never hurts to consider an objective opinion.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Developement
Organizers of the PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc
On 04/25/2011 01:55 PM, Andrew Dunstan wrote:
Well, my solution would be to replace pgindent with a perl script
(among other advantages, it would then run everywhere we build,
including Windows), and filter the typedefs list so that we only use
the ones that appear in each file with that
On 04/20/2011 12:05 PM, Josh Berkus wrote:
On 4/20/11 12:00 PM, Robert Haas wrote:
Please provide the evidence that this is a problem that exists now, as
opposed to seven years ago.
Since you're clearly already made up your mind that no problem exists, I
don't have the energy to fight it out
On 04/20/2011 12:22 PM, Robert Haas wrote:
Well, you aren't fighting alone. We have significant problems in this area.
As you said, we always have. There is also a bizarre, almost insane
objection to using tools that aren't invented here to solve problems. The
problems you (Josh) present are
On 04/17/2011 11:07 PM, Tom Lane wrote:
BTW, another thing that should be in the try-try-again category is
seeing how close we could get to pgindent's results with GNU indent.
It seems clear to me that a process based on GNU indent would be a
lot easier for a lot of people. We tried that once
On 04/18/2011 06:38 PM, Robert Haas wrote:
On Mon, Apr 18, 2011 at 3:17 PM, Josh Berkusj...@agliodbs.com wrote:
In any case, I think the answer to this is constructive; better
documentation and tools to let submitters get their code into good shape
in the first place so that we don't have
On 04/15/2011 09:59 AM, Joshua Berkus wrote:
All,
While it would be nice to improve our performance on this workload, let me
point out that it's not a very important workload from the point of view of
real performance challenges. Yes, there are folks out there with 100MB
databases who only
On Sun, 2011-04-10 at 03:05 +0100, Greg Stark wrote:
On Sat, Apr 9, 2011 at 6:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
BTW, it sounded like your argument had to do with whether it would use
HashAgg or not -- that is *not* dependent on the per-palloc limit, and
never has been.
His
On Wed, 2011-04-06 at 07:47 +0300, Peter Eisentraut wrote:
On tis, 2011-04-05 at 16:04 -0700, Joshua D. Drake wrote:
Well any libpq app but yes. I actually wonder as to the legitmacy of
having both a pgpass and a pg_service. Why not just one of them?
So you can keep passwords in a safer
On Wed, 2011-04-06 at 09:10 +0200, Martijn van Oosterhout wrote:
On Tue, Apr 05, 2011 at 11:55:04PM -0700, Joshua D. Drake wrote:
I want to achieve two things:
1. More understandable .pgpass format. Yes, I understand our standard
format, most people won't. Like JoshB said, hard to debug
/template1/?username=jdpassword=foobarssl=true
But I don't know if we want to go there.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com
On Wed, 2011-04-06 at 13:35 -0500, Kevin Grittner wrote:
Joshua D. Drake j...@commandprompt.com wrote:
Many drivers support an extended syntax like:
postgres:ssl://localhost:5432/template1/?username=jdpassword=foobarssl=true
But I don't know if we want to go there.
We've been
The current structure of .pgpass is:
hostname:port:database:username:password
Bare, useful, but not really friendly nor flexible. I would love to be
able to do this:
If no ini block:
hostname:port:database:username:password
else:
[ecom]
hostname=
port=
database=
username=
password=
On Tue, 2011-04-05 at 15:38 -0700, David E. Wheeler wrote:
On Apr 5, 2011, at 3:34 PM, Joshua D. Drake wrote:
boom, I am in.
Thoughts?
boom, you have patch?
I'll write it, if I am not going to be tied up for months arguing about
it :P. Thus, I wanted to see if the community
On Tue, 2011-04-05 at 18:52 -0400, Aidan Van Dyk wrote:
On Tue, Apr 5, 2011 at 6:34 PM, Joshua D. Drake j...@commandprompt.com
wrote:
Bare, useful, but not really friendly nor flexible. I would love to be
able to do this:
[ecom]
hostname=
port=
database=
username=
password
On Tue, 2011-04-05 at 18:25 -0700, aaronenabs wrote:
Hi All,
I was wondering if anyone can tell me how i can access the transaction log
within postgresql 9.0.3.
I have carried out some updated and deletions within the database and am
hoping the transaction logs have records of this.
You
On Fri, 2011-04-01 at 08:13 -0400, Andrew Dunstan wrote:
That said, I do support adding this in the future, if only to keep up
with the Jones'.
So are the ones out there *already* even compatible, before we start
adding our own? For example, for JDBC I beleive it has to be
On Fri, 2011-04-01 at 12:04 -0500, Kevin Grittner wrote:
Joshua D. Drake j...@commandprompt.com wrote:
Well I would argue that if compatibility (as opposed to
familiarity) is our goal, we need to focus on one and only one
syntax, JDBC. It doesn't matter our particular bent, JDBC
Hello,
Most database connectors/frameworks nowadays support a URI style
connection string. Something like:
pgsql://user:pass@host/database
Do we think psql should support this style of connection string?
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http
On Thu, 2011-03-31 at 19:32 -0400, Andrew Dunstan wrote:
On 03/31/2011 07:25 PM, Joshua D. Drake wrote:
Hello,
Most database connectors/frameworks nowadays support a URI style
connection string. Something like:
pgsql://user:pass@host/database
Do we think psql should support
; I'm always looking
up the conninfo for the options I don't use frequently.
However, is there any standard for database URIs?
There is an IETF RFC for generic URI:
http://www.ietf.org/rfc/rfc2396.txt
http://www.ietf.org/rfc/rfc3986.txt
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major
On Sun, 2011-03-13 at 19:40 -0400, Tom Lane wrote:
I'm not planning to do anything about this idea right now, since I'm
still hip-deep in collations, but I thought I'd throw it out to get
it on the record.
Comments?
One question: Where is the overhead increase?
JD
Hey,
The schedule for #PgEast is up. It can be found here:
https://www.postgresqlconference.org/files/east_2011_schedule.html
As usually we have a increasingly wide selection of content.
Sincerely,
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ -
On Wed, 2011-03-02 at 14:26 -0600, Kevin Grittner wrote:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
All I'm saying is that if we end up shipping without that
parameter (implying allow_standalone_primary=on), we need to call
the feature something else. The GUCs and code
On Tue, 2011-03-01 at 14:26 -0500, Robert Haas wrote:
On Tue, Mar 1, 2011 at 2:12 PM, Josh Berkus j...@agliodbs.com wrote:
Since we appear to be still holding the commitfest open for Sync Rep,
I guess this ought to get reviewed.
Or else we should close the CommitFest and cut alpha4.
On Mon, 2011-02-28 at 11:39 -0800, Josh Berkus wrote:
Spitballing here, but could sqlite be an intermediate, compromise solution?
For a core PostgreSQL component ?!?!?
Sure, why not? It is ACID compliant, has the right kind of license, has
a standard API that we are all used to. It seems
Hello,
Per the customary URL:
https://www.postgresqlconference.org/
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc |
On Thu, 2011-02-17 at 10:49 +, Dave Page wrote:
On Thu, Feb 17, 2011 at 10:36 AM, Magnus Hagander mag...@hagander.net wrote:
Probably readline but does it matter? We distribute the source to the
click installers.
Actually, we don't. We used to, but we don't at this point.
Depends
not working
on PostgreSQL but instead working with it.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca
601 - 700 of 2933 matches
Mail list logo