Kind people,
I think that the bittorrent (cf http://bitconjurer.org/BitTorrent)
server is ready to go at http://bt.postgresql.org. Bug/failure
reports more than welcome :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
to remove this piece of sh^H^Hlegacy from the
configure script? Does anybody actually use info?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
---(end of broadcast)---
TIP 2: you can get off
it as html..
Roight. How to tell it to get the right prefix, then?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
---(end of broadcast)---
TIP 2: you can get off all lists at once
RETURN false;
END IF;
END;
' LANGUAGE 'plpgsql' STRICT IMMUTABLE;
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
---(end of broadcast)---
TIP 7: don't forget to increase your free space
should come soon, once I see what Sander has done.
Woohoo!!! :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
One trend that bothers me is the glorification of stupidity, that the
media is reassuring people it's all right
way to get access to them?
TIA for any pointers on this :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
Civil government, so far as it is instituted for the security of
property, is in reality instituted for the defense of the rich
Andrew Dunstan [EMAIL PROTECTED] wrote:
Tom Lane wrote:
[EMAIL PROTECTED] (David Fetter) writes:
While PL/Perl is great, it's not available everywhere, and I'd like
to be able to grab atoms from a regex match in, say, a SELECT. Is
there some way to get access to them?
There's a three
|| '','' || temp_string;
END IF;
END LOOP;
RETURN quoted_string;
END;
' LANGUAGE 'plpgsql';
Those DBD::Pg users among us who'd like to be able to bind_columns to
postgresql arrays may have a leg up with Text::CSV_XS.
Other middleware should be able to handle such things, too. :)
Cheers,
D
--
David
On Wed, Dec 10, 2003 at 05:08:19PM -0800, Joe Conway wrote:
David Fetter wrote:
I've come up with yet another little hack, this time for turning 1-d
arrays into CSV format.
You mean like this (which is new in 7.4)?
regression=# select array_to_string (array[1,2,3
;
END IF;
IF i = array_lower(in_array, 1)
THEN
quoted_string := temp_string;
ELSE
quoted_string := quoted_string || '','' || temp_string;
END IF;
END LOOP;
RETURN quoted_string;
END;
' LANGUAGE 'plpgsql';
--
David Fetter [EMAIL
that follows the match, respectively.
Perl weenies may think of $, $1, ... $n, $` and $'.
Comments, ideas, brickbats, and you're on crack comments welcome. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
On Fri, Dec 12, 2003 at 07:47:26PM +0100, Peter Eisentraut wrote:
David Fetter wrote:
I'm looking to the SQL WITH clause as a way to get better regex
support in PostgreSQL. I've been chatting a little bit about
this, and here's an idea for a behavior. Implementation details
TBD
In article [EMAIL PROTECTED] you wrote:
On Fri, Dec 12, 2003 at 10:13:56AM -0800, David Fetter wrote:
I'm looking to the SQL WITH clause as a way to get better regex
support in PostgreSQL. I've been chatting a little bit about this,
and here's an idea for a behavior. Implementation details
On Sat, Dec 13, 2003 at 10:58:59PM +0200, Hannu Krosing wrote:
David Fetter kirjutas R, 12.12.2003 kell 20:13:
Kind people,
I'm looking to the SQL WITH clause as a way to get better regex
support in PostgreSQL. I've been chatting a little bit about
this, and here's an idea
the mathematical concept of 0 until ~ 598 CE, by which
time the Roman Empire had fallen (depending on whether you believe it
actually fell). We'll just have to live with some weirdness on this
one. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235
, or performing complicated
tasks by hand.
I guess that's OK, but it shows up like a beacon to all kinds of
hostile gear. Passive systems are usually a better bet.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
Information causes change
On Fri, Dec 26, 2003 at 10:48:20AM -, Dave Page wrote:
It's rumoured that David Fetter once said:
I guess that's OK, but it shows up like a beacon to all kinds of
hostile gear. Passive systems are usually a better bet.
Are there many hostile forces in your hallway?
Most days
and not of code bases.
Just my $0.02 :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
Who is wise? He who learns from all.
Ben Zoma, Pirkei Avot 4:1
---(end
On Fri, Dec 26, 2003 at 06:34:47PM -0500, Alex J. Avriette wrote:
On Fri, Dec 26, 2003 at 11:49:20AM -0600, David Fetter wrote:
The latter is harder to answer than the former. For the former,
I propose a macro in psql, \qf (query function). Obviously,
the name implies a broader scope
in the No! you
almost always pipe up with. It's getting boring.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
America is like a melting pot: The people on the bottom get burned
and the scum floats to the top.
---(end
SEQUENCE? What else might this impact?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
Before you try to play the history card, make sure it's in your hand.
---(end of broadcast)---
TIP 4
On Sun, Feb 01, 2004 at 02:53:18PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (David Fetter) writes:
The fine folks in #postgresql brought this up, and it seems like,
well, a bug. In order to make certain kinds of changes on a
SEQUENCE, you have to issue an ALTER TABLE statement. Shouldn't
, and that replacing the alias/number with its referent clears
this up, but what do later standards have to say about doing or not
doing the above? If they're ambiguous, are there good reasons why the
above shouldn't work?
TIA for any pointers on this :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED
On Mon, Feb 23, 2004 at 06:36:48PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (David Fetter) writes:
I bumped across this several times, and am wondering what SQL99
and SQL200x have to say about column numbers or aliases in HAVING.
SQL99 not only does not allow them in GROUP BY or HAVING
buggered up?
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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Thu, Mar 25, 2004 at 04:48:59PM -0500, Bruce Momjian wrote:
David Fetter wrote:
Kind people,
I just tried to compile HEAD on fedora, and it broke as per
http://rafb.net/paste/results/W1942548.html
Any ideas what i buggered up?
Fixed. Not sure why I didn't see the problem
resources be
able to allocate from that.
Does PostgreSQL have facilities for such a thing?
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 4
Marc G. Fournier [EMAIL PROTECTED] wrote:
got everything built this evening, just giving it a bit of time to
propogate out to the mirrors before announcing ...
BitTorrent http://bt.postgresql.org is up, and thanks for putting
the tarballs on that VM :)
Cheers,
D
--
David Fetter [EMAIL
wants me to give a
talk about this. PostgreSQL will get even more traction out of a
fully functional PL/Perl.
Big kudos to Andrew Dunstan, Josh Drake team. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100mobile: +1 415 235 3778
There is nothing more
to date with
my tree before I leave.
Yay!
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 1: subscribe and unsubscribe commands go
for any pointers in the right direction...
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: you can get off all lists at once
like (oddly) interval can have a std. deviation,
which is measured in seconds, but not a variance. Is that pretty
close?
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
?
You are not missing anything. I already nagged Jan about this
once...
Of course, this is hardly the only seriously-underdocumented thing
in CVS tip ;-). We'll need to make a major push on docs soon.
Do tell. :)
Cheers,
D(oc writer ordinaire)
--
David Fetter [EMAIL PROTECTED] http
base to update maintain
* Disk space
What do you all think?
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
On Sun, Jul 18, 2004 at 10:14:23PM +0200, Peter Eisentraut wrote:
David Fetter wrote:
It's been pointed out to me that I tend to document by example
Documenting by example is like proving by example -- it helps
understanding, but it doesn't replace the actual thing.
Nonetheless, no one
the exact same thing. I was hoping that \dD+ would
show all CONSTRAINTs.
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
Not Though Of.
What do you all think?
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
essentially have 8.0beta1 code.
The documentation, however, desperately needs work still; and Marc
would like to get some of the postgresql.org domains shifted over to
the newly-installed venus server before we go beta.
Which docs are in the most desparate need of help?
Cheers,
D
--
David Fetter
related topic, I'm thinking I should only put the
latest, greatest on the bt server, but if others think otherwise, I'd
be happy to put up more.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
in. On a related note, it would also be nice to have default
parameters and some way to say to use them.
Well, that's my thoughts so far. What are yours?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
the scripting languages, and an ability to deal with
data structures to and from queries that more closely matches what the
middleware/front end needs to do.
How big a can of worms am I opening here?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile
) 435-6134 Fax (845) 432-9132 Tie Line 8-295-6134
Building 708 Office 2C3
[EMAIL PROTECTED]
US Mail:
IBM Systems and Technology Group, Dept. Q5CA Mail Station P389
2455 South Road, Poughkeepsie NY 12601-5400
- End forwarded message -
--
David Fetter [EMAIL PROTECTED] http
biblically.
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?
http://www.postgresql.org
FAST. I'm grateful to Fujitsu for
giving me the opportunity to do this, and I look forward to doing
what I can to improve PostgreSQL over the next year.
Congratulations! Have fun in Sydney :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415
)
| (5.1,34.5) | [(0,0),(6,6)] | (6,6)
==
Any clues?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
On Wed, Sep 08, 2004 at 04:20:11PM -0400, Andrew Dunstan wrote:
David Fetter wrote:
Kind people,
Lately (past 3 days or so, but I don't know exactly how far back
this goes), I've been getting some regression test failures for
geometry with CVS HEAD on OS/X.
We have seen a number
that as the default setting?
Looking forward to a lively discussion on this,
I remain,
Yr. obd't ser't,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast
as it needs
a big overhaul?
Anyway, thanks for taking the time to read this.
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
;
r.table_name := t_name.relname;
r.num_rows := the_count.count;
RETURN NEXT r;
END LOOP;
RETURN;
END;
' LANGUAGE plpgsql;
COMMENT ON FUNCTION count_em_all () IS 'Spits out all tables in the public schema and
the exact row counts for each.';
--
David Fetter [EMAIL PROTECTED] http
details.
This should go into a new section of contrib/ like sql_utils or some
such.
Big TIA for any hints, tips or pointers, especially to things I've
missed here. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
of it. I could talk about our 8.0
features and perhaps what we expect for 8.1.
Is there a separate list for features that missed the 8.0 cutoff and
are slated for 8.1? For non-specific 8.n, n0?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235
On Thu, Oct 07, 2004 at 03:29:59PM -0400, Bruce Momjian wrote:
David Fetter wrote:
On Thu, Oct 07, 2004 at 02:28:37PM -0400, Bruce Momjian wrote:
Mark Wong wrote:
I'd like to set up a BOF with any of the developers who are
interested in Boston at the Linux World Expo coming up
On Mon, Oct 18, 2004 at 06:12:29PM -0400, Bruce Momjian wrote:
It was just added to CVS!
Woohooo!
Big, BIG kudos to all involved :) :)
Cheers,
D(BD::Pg)
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
it be to have generalized DDL triggers? Apart
from resource allocation, what are some downsides of providing such a
facility?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end
and (of course) Tom
Lane for the infrastructure that makes this doable. :)
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: you can get
Bertheau aka ska-fan for help with removing an
unneeded regex compare and with spelling. :)
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
On Sat, Oct 30, 2004 at 11:55:48PM +0200, Markus Bertheau wrote:
В Сбт, 30.10.2004, в 21:54, David Fetter пишет:
Kind people,
CREATE OR REPLACE FUNCTION array_to_column (ANYARRAY)
You want to see that function distributed with PostgreSQL? It would
probably have to be implemented in C
for after
8.0 PR is done.
I suggest to add on pg_functions and on pg_views too, the list of
dependencies with other objects.
pg_keywords
pg_sqlstates
Attached is a rough draft of the latter.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1
On Sun, Nov 07, 2004 at 10:53:22PM +0100, Gaetano Mendola wrote:
Hi all,
it seems that the tracker is down or at least not reachable.
Started again. Thanks for the notice. :)
BTW, do you have some (semi-)automated way to monitor this?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http
. It lets you query against DBI data
sources including DBD::Excel :)
http://pgfoundry.org/projects/dbi-link/
Bug reports welcome.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end
AND
r.person_id = a.person_id
)
),
', '
) AS email(s)
FROM
people a;
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broadcast
it's a case of bad documentation, which we will fix very shortly. Sorry
for the noise.
Please find attached a patch that fixes this.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/plperl.sgml
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 4: Don't 'kill -9' the postmaster
On Mon, Nov 22, 2004 at 12:49:25PM -0400, Marc G. Fournier wrote:
On Mon, 22 Nov 2004, David Fetter wrote:
On Sun, Nov 21, 2004 at 11:40:29PM -0400, Marc G. Fournier wrote:
Check her out and let me know if there are any problems ... I've
changed the mk script to pull in the beta3 man pages
On Tue, Nov 23, 2004 at 05:33:15PM +0100, Peter Eisentraut wrote:
Am Montag, 22. November 2004 17:40 schrieb David Fetter:
A much slimmed-down bt.postgresql.org is now serving it. :)
Out of curiosity, what purpose does a bittorrent source serve in
this case?
BitTorrent was designed to take
it the time most people use it is when
something is hot off the presses).
^^^
The above is precisely the use case I set the thing up for. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember
elsewhere.
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 4: Don't 'kill -9' the postmaster
-null inputs)?
I'd say non-strict unless SQL:2003 says different.
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
of having associative arrays as a 1st-class data type
in PostgreSQL. How much harder would it be to make these generally
available vs. tied to one particular language?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
On Wed, Jun 29, 2005 at 01:20:17PM -0400, Douglas McNaught wrote:
David Fetter [EMAIL PROTECTED] writes:
I'm all in favor of having associative arrays as a 1st-class data
type in PostgreSQL. How much harder would it be to make these
generally available vs. tied to one particular language
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
On Thu, Jun 30, 2005 at 11:42:59AM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Thu, Jun 30, 2005 at 10:55:58AM -0400, Tom Lane wrote:
Ciprian Popovici discovered an entirely new way to break the safety
interlocks that are meant to prevent you from starting a postmaster
On Thu, Jun 30, 2005 at 02:31:01PM -0400, Andrew Dunstan wrote:
David Fetter wrote:
On Thu, Jun 30, 2005 at 11:42:59AM -0400, Tom Lane wrote:
Renaming data directories around is not that uncommon,
With all due respect, I believe that this falls under the category
of prying
implement the SQL:2003 standard for UNNEST, MULTISET, FUSION, COLLECT
and INTERSECT.
In re: the relational model, that's already broken, although Date's
excellent new book from O'Reilly encourages people to implement
Tutorial D. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1
) though :)
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
. Ask a new DBA what she
expects table inheritance to do or not to do, for example.
And it's not like they'll be trivial to implement.
Probably not, but implementing them will very likely open the door to
implementing other parts of the SQL standard that really are fun. :)
Cheers,
D
--
David
to take, use the copyright
and license system, which works, not the obfuscation system, which is
amazingly fragile. And besides, what's so embarrassing about this
code that you don't want people to see it?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile
--
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: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
is fragile, often disastrously so, e.g. the
Enigma machine friends.
There is no good reason for us to help perpetuate the myth of security
by obscurity, and plenty of good reasons for us *not* to do so.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1
features here. What do we do for to_char() with such separators?
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: explain analyze
that documents could help avert in some
useful 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 4: Have you searched our list archives
, by their nature, be
neither.
Advantages of making this policy change:
* Pg_upgrade actually happens as a matter of routine
* It's testable one change at a time
Disadvantages:
* Increased work on the front-end for new changes
* Higher barriers to entry
Cheers,
D
--
David Fetter [EMAIL PROTECTED
My last one appears to have vanished. Did this get through?
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 1: if posting/reading
On Thu, Jul 14, 2005 at 02:41:13PM +1000, Neil Conway wrote:
David Fetter wrote:
As background, I'd like to go over our policy of, The code patch
must be accompanied by any doc patches that it implies.
Although it is worth noting this policy is not religiously followed
anyway (e.g
list;
else
return lappend(list, datum);
}
How about list_push for both of these? This opens the door for
possible future functionality like list_pop, list_shift,
list_unshift...
Just my uneducated $.02.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510
that these will all go
into memory.
That's no longer true. Please find enclosed a new patch :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/plperl.sgml
On Sat, Jul 30, 2005 at 09:47:58AM -0400, Andrew Dunstan wrote:
David Fetter wrote:
You have rolled 2 problems into one - spi_query+spi_fetchrow does not
address the issue of returning large data sets.
Suggest instead:
[suggestion]
Revised patch attached. Thanks for catching
On Wed, Aug 03, 2005 at 05:00:16PM -0400, Mark Woodward wrote:
I just finished converting and loading the US census data into PostgreSQL
would anyone be interested in it for testing purposes?
It's a *LOT* of data (about 40+ Gig in PostgreSQL)
Sure. Got a torrent?
Cheers,
D
--
David Fetter
On Tue, Aug 09, 2005 at 04:10:08PM -0400, Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
--all would be fine. In fact, why not make it the default?
We could do that. Any objections out there?
+1 in favor of making '--all' the default behavior :)
Cheers,
D
--
David Fetter [EMAIL
of these days.
I'm interested in the SQL format so that I can implement it in
phpPgAdmin - can you give me an example, or docs on it?
It's in 5WD-14-XML-2003-09.pdf which is available at
http://wiscorp.com/SQLStandards.html
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone
greater than the work required
to fix the issues with pl/python. :)
Are you certain? See above in re: what Guido had to say.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end
On Tue, Aug 16, 2005 at 11:39:04PM +0300, Marko Kreen wrote:
On Tue, Aug 16, 2005 at 10:38:37AM -0700, David Fetter wrote:
If somebody has figured out a way to make a PL/Python (without the
U), that's great, but nothing has happened on this front in a
couple of years, and Guido said
On Tue, Aug 16, 2005 at 05:09:24PM -0400, Gregory Maxwell wrote:
On 8/16/05, David Fetter [EMAIL PROTECTED] wrote:
It's not. In PL/parlance, trusted means prevented from ever
opening a filehandle or a socket, and PL/PythonU is called
PL/Python*U* (U for *un*trusted) because it cannot be so
the project
for a few years will agree.
So, welcome Dave Page as the newest member of Core!
Congratulations, Dave! :)
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
things that would make it easier to implement)
* Debugging hooks into all the PLs
* Some way of estimating a query progress meter for long-running queries
* MULTISET, COLLECT, UNNEST, FUSION, INTERSECT
oh, and
MERGE! MERGE! MERGE! MERGE! MERGE! MERGE!
Cheers,
D
--
David Fetter [EMAIL PROTECTED
...
This should explain it:
http://homepages.nildram.co.uk/~blagger/the_duel.html
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
to be introducing things,
but I consider this a bug, and would like to send in more fixes.
What do you all think?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: src/bin/psql/describe.c
On Mon, Aug 29, 2005 at 08:12:37AM -0400, Robert Treat wrote:
On Monday 29 August 2005 00:33, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On a slightly related note, I've noticed that psql isn't
backward compatible.
We have never expected psql's \d commands to work against
the whole table?
ALTER TABLE table ALTER COLUMN field1 TYPE boolean
USING CASE field1 WHEN 0 THEN false ELSE true END;
/* or something to this effect */
HTH :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote
On Mon, Aug 29, 2005 at 11:13:29AM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
I've noticed that \df doesn't do quite what it might when a
function is created with named input parameters. Please find
enclosed a patch against CVS TIP that does this better.
Meanwhile
1 - 100 of 2065 matches
Mail list logo