there, and if we can help them I don't see
anything wrong with that.
The best help you can give these people is to get them onto a system
released since the end of the Clinton administration.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235
to is, IMHO, an *excellent*
idea. The whole thing is a giant foot-gun.
Just my $.02.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 6
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
be :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index
that this patch will break LO support
entirely on platforms that don't have working int64 arithmetic.
What platforms that PG supports don't have int64 arithmetic?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
things am I missing here?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Mon, Sep 26, 2005 at 01:13:08PM -0400, Christopher Petrilli wrote:
On 9/26/05, David Fetter [EMAIL PROTECTED] wrote:
I've run into something that concerns me. It's pretty much an 8.2
issue, but I'm hoping to stimulate some discussion on it. It's
PostgreSQL's log files. Right now
attached, as in:
PostgreSQL 8.1
Released: November 30, 2005
Community support ends: November 30, 2008
This could be softened a bit in a sentence or two below :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember
of
the code that could bear extra scrutiny? Ideas on how to fix same in
a cross-platform way?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 9
On Fri, Sep 30, 2005 at 05:54:49PM -0500, Jim C. Nasby wrote:
On Mon, Sep 26, 2005 at 10:57:54AM -0700, Ron Mayer wrote:
David Fetter wrote:
...log file formats in 8.0
* CSV
* YAML
* XML
* Piped logs, as Apache can do
* DB handle. I know this one will be controversial
they had happened. Is this
fixed in 1.4-to-be?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
debug_sort=true;
I'm a bit inclined to call it trace_sort instead, and to document it
under Developer Options. Comments?
+1
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end
in any clear consensus,
so it seems the best thing to do is throw the matter out for a vote on
pgsql-hackers.
The plausible alternatives seem to be:
1. Leave it as-is.
+1, for what it's worth.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1
a suggestion as to how to do that, or inform me if there is a way to
do thisa lready?
I have already consulted to other mailing lists for help, with no
results. I am a Windows 2003 user, version 8.0.1
You might want to upgrade to 8.0.4 :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http
, that might not be a bad thing. It will just
cause the warnings to be logged, although possibly a little
verbosely.
That change at least is trivial.
So what's the consensus? -w or just document?
+1 for -w. Documenting wouldn't hurt either.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http
| char | not null | A code defining the specific semantics of
this dependency relationship; see text.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast
On Wed, Oct 12, 2005 at 07:11:12PM -0400, Tom Lane wrote:
I wrote:
David Fetter [EMAIL PROTECTED] writes:
Before I dive into this, is there some reason why the
pg_catalog.* tables/views should not have comments that match the
descriptions in the docs? I can see where this could cause
are NULL, because we have not
got support for arrays with null elements. So we'd have to fix
that first.
+1 on fixing that. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end
and index the changes look like they
would be very modest indeed, and not enormously greater in the case
of a type, domain, conversion and schema.
Is this worth doing? Would it be acceptable?
Yes, and yes, in my case :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1
On Thu, Oct 13, 2005 at 08:59:51AM +, Andreas Pflug wrote:
David Fetter wrote:
Dept of second thoughts: actually, perhaps see if you can generate
the pg_description entries from the C comments in the
include/catalog header files. There's already a strong motivation
to hold those
people, and turn it off by default.
Is there some fairly simple way to find VIEWs that have this property
so they can be fixed?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end
inclined to treat this as an outright bug, not just a minor
performance issue, because it implies that a sufficiently long psql
script would probably crash a Windows machine.
Ouch. In light of this, are we *sure* what we've got a is a candidate
for release?
Cheers,
D
--
David Fetter [EMAIL
On Thu, Nov 10, 2005 at 04:08:29PM -0500, Andrew Dunstan wrote:
Tom Lane wrote:
I'm not convinced that using bigint-equivalent space for an enum is
a mortal sin...
at least venial ...
Heh.
Would ORDER BY somehow know about enums' given ordering?
Cheers,
D
--
David Fetter [EMAIL
On Thu, Nov 10, 2005 at 05:26:45PM -0500, Andrew Dunstan wrote:
David Fetter wrote:
On Thu, Nov 10, 2005 at 04:08:29PM -0500, Andrew Dunstan wrote:
Tom Lane wrote:
I'm not convinced that using bigint-equivalent space for an enum is
a mortal sin...
at least venial ...
Heh
the arrays in an order-insensitive comparison.
That sounds more like the SQL:2003 MULTISET, which is essentially
unordered. Any plans for these?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
with 7.2 documentation, moving them into the Manual
Archive http://www.postgresql.org/docs/manuals/archive.html. We can also
change the caption on the main documentation page to note these are manuals
for the current supported versions.
Excellent :)
Cheers,
D
--
David Fetter [EMAIL
On Wed, Nov 30, 2005 at 11:56:33PM -0400, Marc G. Fournier wrote:
On Wed, 30 Nov 2005, David Fetter wrote:
On Wed, Nov 30, 2005 at 01:23:38PM -0500, Robert Treat wrote:
On Wednesday 30 November 2005 11:40, Tom Lane wrote:
Personally I expect to keep supporting 7.3 for a long while,
because
On Thu, Dec 02, 2004 at 08:34:11PM -0600, Jim C. Nasby wrote:
I've tried emailling David Fetter to no avail; anyone know who's in
charge of the torrents or anyone who can answer my original
question?
I'm in charge, and re: your original question, perhaps some creative
use of wget could help
On Tue, Dec 21, 2004 at 01:56:38AM -0400, Marc G. Fournier wrote:
check her over ..
Torrents are ready whenever anyone else is. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
ARRAYs, but there has to be another way. Jan mentioned
doing something with REFCURSORS, but I'm not sure how those and this
problem might connect.
Are there standard ways to do this? If so, what might they be? Some
code or doc examples would be great. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
pg_groups
I don't know how this fits in, but it would be *very* nice to have
SQLSTATE meta-information available via SQL. I've sent in a patch for
this.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
namespace
collisions?) to be created in the appropriate language with
appropriate params, then the foo_trg on the table.
Does SQL:2003 have anything to say about this? Also, what kind of
development effort would be involved with an implementation, assuming
SQL:2003 doesn't forbid?
Cheers,
D
--
David
On Mon, Jan 24, 2005 at 08:40:30PM -0600, Jim C. Nasby wrote:
On Mon, Jan 24, 2005 at 08:12:49AM -0800, David Fetter wrote:
On Sun, Jan 23, 2005 at 03:49:22PM -0600, Jim C. Nasby wrote:
Sorry if this is old, but I couldn't find it in the archives...
How difficult would
the
columns are fixed. Nothing much to do w/triggers.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
server is on a plan that gets 1G free, and is billed
after that. Also, I am on a broadband line at my office, and
uploading the data would take days.
How about putting up a Bittorrent?
I'd be delighted to stick one up on http://bt.postgresql.org/ if
that's OK with you.
Cheers,
D
--
David
?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
*not* locking the table at the beginning of the
transaction, what procedure minimizes this risk and recovers well from
said race condition, should it occur?
TIA for any hints, tips or pointers on this :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415
ROW EXCLUSIVE MODE. other than that, it's a sucky solution
because it breaks concurrency. In pgsql 8, you can do it using
pl/pgsql exception handling.
Luckily, PG 8 is available for this. Do you have a short example?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510
.
Pursuant to an IRC discussion to which Dennis Bjorklund and
Christopher Kings-Lynne made most of the contributions, please find
enclosed an example patch demonstrating an UPSERT-like capability.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235
/interactive/auth-methods.html#AUTH-PAM
Do you have additions to it?
'pears so :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 5
with it?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
it, by design, from having application-
specific functionality.
Kudos to the New System Views people for their hard work thus far :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast
I'm checking to see whether I can post. Nothing to see here.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 6: Have you searched our
a syntax for this awhile back. I haven't found it in the
archives, but it goes like this:
EXECUTE IMMEDIATE $$
function body here
$$
LANGUAGE plfoo;
Similarly, a CREATE TEMPORARY FUNCTION could be quite handy.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893
, so how about PERFORM
IMMEDIATE? I also like the idea of functions whose scope is settable.
Something like this:
CREATE [OR REPLACE] [ TRANSACTION | SESSION ] FUNCTION ...
Cheers,
D
David Fetter wrote:
On Mon, May 09, 2005 at 11:44:23AM -0600, Jonah H. Harris wrote:
Hey everyone
be implementation-
specific information, and the information schema is, by design,
implementation-neutral.
Just my $.02 :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast
o nested schemas?
Well, some kind of nestable namespace for objects, anyhow.
I'll look over the SQL:2003 draft and see if I can find anything along
that line in there.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember
On Tue, May 10, 2005 at 09:49:13PM -0400, Bruce Momjian wrote:
David Fetter wrote:
On Tue, May 10, 2005 at 06:55:39PM -0400, Bruce Momjian wrote:
OK, so it seems we need:
o make private objects accessable only to objects in the same
schema
o Allow
developer has shown in this very thread that it is
extremely easy to screw up a query against those catalogs. Maybe
you're better than he is, but that's not a reason to keep something
simpler out.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1
unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
time I can spare.) I'm willing to take on the work. What's the
next step?
I suppose the first thing would be to look over the patches I
mentioned and the SQL:2003 specification, then put together a
preliminary patch and send it to -hackers.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http
, not the WITH patch. The WITH
patch, as far as I can tell, is in the public domain.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 9
Folks,
Josh Narins asked me to post this as he was unable to post it himself.
http://narins.net:4321/blog/subcountry.html
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end
On Fri, Jun 03, 2005 at 05:57:32PM +0200, Gevik Babakhani wrote:
Dear All,
PGDN has a new treeview face. I would like to know your opinion on
the current state of the website.
It's empty. Could you tell us a little bit about what you want to put
there?
Cheers,
D
--
David Fetter [EMAIL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
On Tue, Jun 07, 2005 at 09:35:56AM +0900, a_ogawa wrote:
Bruce Momjian wrote:
David Fetter wrote:
On Mon, Jun 06, 2005 at 12:02:18PM -0400, Bruce Momjian wrote:
Patch removed because we already have this functionality.
We don't yet have this functionality, as the patch allows
On Tue, Jun 07, 2005 at 10:27:28PM +0900, Atsushi Ogawa wrote:
David Fetter wrote:
On Tue, Jun 07, 2005 at 09:35:56AM +0900, a_ogawa wrote:
David Fetter wrote:
We don't yet have this functionality, as the patch allows for
using second and later regex matches () in the replacement
, DEFAULT),
COALESCE(NEW.foo_truth, DEFAULT),
NEW.foo_text_cap
);
ERROR: syntax error at or near DEFAULT at character 183
LINE 10: COALESCE(NEW.foo_id, DEFAULT),
^
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893
On Sun, Jun 12, 2005 at 10:56:22PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
At one time, INSERTing a NULL into a column with a DEFAULT used to
INSERT the DEFAULT. Is there some way to get this behavior back?
PG has *never* done that in any version that I can recall
On Sun, Jun 12, 2005 at 11:48:29PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
I believe this isn't just my problem. Without access to a the
underlying column's DEFAULT, how can people implement the automated
WRITEable VIEWs?
That's a reasonable question
of the SPI functions failed. But I can't think of what else to do,
either.
Thoughts?
I have some :)
If we figure this out for PL/Perl, the general method will be
applicable to PL/YourFavoriteLanguage, so even if you're not a fan of
Perl, it's worth looking into.
Cheers,
D
--
David Fetter [EMAIL
Folks,
Please find enclosed a patch that lets you use \c to connect
(optionally) to a new host and port without exiting psql.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/ref/psql-ref.sgml
to -patches?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Mon, Dec 12, 2005 at 10:19:00AM -0500, Tom Lane wrote:
Michael Glaesemann [EMAIL PROTECTED] writes:
On Dec 9, 2005, at 18:10 , David Fetter wrote:
Please find enclosed a patch that lets you use \c to connect
(optionally) to a new host and port without exiting psql.
I'm not familiar
object, it would contain all the DDL successfully
executed + a timestamp, so it would be possible to get a history on
any or all DB objects (modulo DROP/CREATE). How hard would it be to
get the raw text of the DDL and hold onto it until the DDL either
succeeds or fails?
Cheers,
D
--
David Fetter
On Tue, Dec 13, 2005 at 11:33:20PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
The idea is to make a new table in pg_catalog called pg_ddl.
This seems rather poorly thought out --- I can't even tell whether
your intention is to make a log of past operations,
Yes
to keep all the SQL for all previous versions in memory,
or...?
I'd much appeciate tips, specific RTFMs and feedback on this so I can
get cracking on a patch.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end
versions. Would this be possible that
way?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
is optional?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
to make the index check INITIALLY DEFERRABLE the way
a regular column/table constraint could be?
I'd much appreciate any insights into this :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end of broadcast
On Tue, Jan 03, 2006 at 11:17:16PM -0500, Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
David Fetter said:
Is there some way to make the index check INITIALLY DEFERRABLE
the way a regular column/table constraint could be?
The TODO list has: Allow DEFERRABLE UNIQUE constraints
install --schema=contrib # Option 2
make install --schema=foo # Option 3
What do you think?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end of broadcast
overhead (see eg _bt_formitem()). GIST
already got rid of this concept, or never had it.
Does anyone see a reason to keep this layer of struct definitions?
If you cut it out, what will the heap and index access methods
needed for SQL/MED use?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http
On Mon, Jan 16, 2006 at 04:02:07PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Mon, Jan 16, 2006 at 03:52:01PM -0500, Tom Lane wrote:
Does anyone see a reason to keep this layer of struct
definitions?
If you cut it out, what will the heap and index access methods
On Mon, Jan 16, 2006 at 04:21:50PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Mon, Jan 16, 2006 at 04:02:07PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
If you cut it out, what will the heap and index access
methods needed for SQL/MED use
and you
can't hang your own database design on the assumption that they
won't change.
Right :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 4: Have you searched
.
--copy-delimiter accepts any single byte other than '\r' or '\n'.
--copy-null accepts any input. The patched pg_dump ignores --copy-*
options in cases where COPY wouldn't happen anyway.
What do you folks think?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
On Thu, Jan 26, 2006 at 10:17:05PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
I have seed database scripts quasi-generated from pg_dump which
include COPY statements, but the data is hard to edit (especially
cut paste operations) when the COPY delimiter is some
non
. Content requires custom parsers.
aolI also think this would make a great pgfoundry project :)/aol
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
---(end of broadcast)---
TIP 6: explain analyze
for escaping the escape characters.
Just use tab separated data like man was meant to.
I'd say that the multiplicity of strong opinions on The Right
Delimiter is a pretty strong argument for having a switch to control
it.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1
. Are those in contrib/
somewhere? On GBorg? On PgFoundry? If not, could you put them
somewhere? As far as converting them from shell to Perl, I'm sure
you'll find a flock of volunteers to help.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember
On Wed, Feb 08, 2006 at 09:00:46AM -0500, Bruce Momjian wrote:
David Fetter wrote:
On Tue, Feb 07, 2006 at 11:43:40PM -0500, Bruce Momjian wrote:
You mentioned in-place upgrade scripts. Are those in contrib/
somewhere? On GBorg? On PgFoundry? If not, could you put them
if there's a use
case.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/ref/pg_dump.sgml
===
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v
On Wed, Mar 08, 2006 at 11:03:00AM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
From the earlier discussion, it appears that there is a variety of
opinions on what the COPY delimiter should be in pg_dump. This
patch allows people to set it and the NULL string.
Did
On Wed, Mar 08, 2006 at 11:10:04AM -0500, Neil Conway wrote:
On Wed, 2006-03-08 at 07:47 -0800, David Fetter wrote:
From the earlier discussion, it appears that there is a variety of
opinions on what the COPY delimiter should be in pg_dump. This patch
allows people to set it and the NULL
On Wed, Mar 08, 2006 at 11:26:00AM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Wed, Mar 08, 2006 at 11:03:00AM -0500, Tom Lane wrote:
Did anyone provide a convincing use case for this?
I've had one so far, and it was enough to cause me to make a
special patched
to withstand much more careful review if that were stated to be
the case.
I believe that this patch fixes the problem. Should there be
something in the regression tests for this?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
Index: src
to see a
pg_service.conf file. Can we put such a configuration directive
into the binary builds? Is this known to work?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote
On Wed, Mar 29, 2006 at 03:53:13PM -0500, Andrew Dunstan wrote:
David Fetter wrote:
Folks,
I'm trying to get pg_service.conf working on Windows so we can
standardize on a way of doing things cross-platform, and noticed
that
pg_config.exe --configure
why are you using this flag? if you
tool.
David Fetter
The patch seems not to behave very reasonably with respect to preserving
prior values for the newly-changeable connection parameters. I haven't
got time to look into it myself right now though --- do you want to?
regards, tom lane
,
(pg_stat_file('pg_hba.conf')).size
), '\n'),
1
)
) AS s(t)
) AS foo
WHERE
Line !~ '^#'
AND
Line !~ '^\s*$'
;
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
that?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 5: don't forget to increase your free
-offset
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
be
predicated on the wrong assumption that these PLs have more power
inside the database than SQL does.
That said, I believe it's a *great* idea not to include untrusted PLs
by default :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
On Mon, Apr 10, 2006 at 10:02:25PM -0400, Bruce Momjian wrote:
The patch wasn't ignored. It is just that I never got to applying it yet.
Neil's patch vs. psql supercedes this :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
On Tue, Apr 11, 2006 at 05:01:17PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Tue, Apr 11, 2006 at 04:35:05PM -0400, Tom Lane wrote:
More realistically, though, the theoretical point that you can do
arbitrary calculations by turning loops into recursive SQL
functions
101 - 200 of 2065 matches
Mail list logo