[HACKERS] Bittorrent test

2003-11-16 Thread David Fetter
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

[HACKERS] RPM building fun

2003-11-19 Thread David Fetter
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

Re: [HACKERS] RPM building fun

2003-11-20 Thread David Fetter
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

[HACKERS] Handy user/group hack

2003-11-20 Thread David Fetter
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

Re: [HACKERS] Updates for RPMS.

2003-11-24 Thread David Fetter
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

[HACKERS] Inside the Regex Engine

2003-12-02 Thread David Fetter
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

Re: [HACKERS] Inside the Regex Engine

2003-12-03 Thread David Fetter
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

[HACKERS] CSV hack

2003-12-10 Thread David Fetter
|| '','' || 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

Re: [Dbdpg-general] Re: [HACKERS] CSV hack

2003-12-10 Thread David Fetter
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

Re: [HACKERS] CSV hack

2003-12-11 Thread David Fetter
; 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

[HACKERS] WITH clause

2003-12-12 Thread David Fetter
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

Re: [HACKERS] WITH clause

2003-12-12 Thread David Fetter
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

Re: [HACKERS] WITH clause

2003-12-12 Thread David Fetter
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

Re: [HACKERS] WITH clause

2003-12-13 Thread David Fetter
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

Re: [HACKERS] Dates BC.

2003-12-18 Thread David Fetter
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

Re: [HACKERS] What do you want me to do?

2003-12-25 Thread David Fetter
, 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

Re: [HACKERS] What do you want me to do?

2003-12-26 Thread David Fetter
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

Re: [HACKERS] feature request: \qf datatype

2003-12-26 Thread David Fetter
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

Re: [HACKERS] feature request: \qf datatype

2003-12-26 Thread David Fetter
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

Re: [HACKERS] Named arguments in function calls

2004-01-25 Thread David Fetter
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

[HACKERS] ALTER SEQUENCE: Missing feature?

2004-02-01 Thread David Fetter
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

Re: [HACKERS] ALTER SEQUENCE: Missing feature?

2004-02-01 Thread David Fetter
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

[HACKERS] aliases, c in HAVING clause?

2004-02-23 Thread David Fetter
, 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

Re: [HACKERS] aliases, c in HAVING clause?

2004-02-23 Thread David Fetter
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

[HACKERS] HEAD compile troubles

2004-03-24 Thread David Fetter
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]

Re: [HACKERS] HEAD compile troubles

2004-03-25 Thread David Fetter
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

[HACKERS] Resource allocation?

2004-05-04 Thread David Fetter
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

Re: [HACKERS] 7.4.3 running a bit late ...

2004-06-15 Thread David Fetter
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

Re: [HACKERS] PlPerlNG - first alpha code

2004-06-16 Thread David Fetter
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

Re: [HACKERS] plperl status

2004-07-08 Thread David Fetter
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

[HACKERS] Statistical Lacunae in Interval type

2004-07-12 Thread David Fetter
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

Re: [HACKERS] Statistical Lacunae in Interval type

2004-07-12 Thread David Fetter
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

Re: [HACKERS] Vacuum Cost Documentation?

2004-07-18 Thread David Fetter
? 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

[HACKERS] Toward better documentation

2004-07-18 Thread David Fetter
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

Re: [HACKERS] Toward better documentation

2004-07-18 Thread David Fetter
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

Re: [HACKERS] How to display privileges in psql

2004-07-20 Thread David Fetter
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

[HACKERS] Tutorial

2004-07-22 Thread David Fetter
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

Re: [HACKERS] 8.0 beta status

2004-08-05 Thread David Fetter
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

Re: [HACKERS] Coming soon: PG 7.4.4, 7.3.7, 7.2.5

2004-08-11 Thread 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

[HACKERS] Calling PL functions with named parameters

2004-08-13 Thread David Fetter
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

HASHes [was Re: [HACKERS] Calling PL functions with named parameters]

2004-08-16 Thread David Fetter
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

[HACKERS] PostgreSQL on z/OS

2004-09-01 Thread David Fetter
) 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

Re: [HACKERS] version upgrade

2004-09-01 Thread David Fetter
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

Re: [HACKERS] FYI: Fujitsu

2004-09-08 Thread David Fetter
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

[HACKERS] Geometry regression test failure, CVS HEAD, Mac OS/X

2004-09-08 Thread David Fetter
) | (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

Re: [HACKERS] Geometry regression test failure, CVS HEAD, Mac OS/X

2004-09-08 Thread David Fetter
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

[HACKERS] Default value for stats_command_string (GUC)

2004-09-17 Thread David Fetter
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

[HACKERS] Variable assignment from dynamic SQL in PL/PgSQL

2004-09-21 Thread David Fetter
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

[HACKERS] PL/PgSQL for counting all rows in all tables.

2004-09-28 Thread David Fetter
; 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

[HACKERS] External Tabular Data Via SQL

2004-10-03 Thread David Fetter
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

Re: [pgsql-advocacy] [HACKERS] Call for BOFs Linux World Expo Boston

2004-10-07 Thread David Fetter
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

Re: [pgsql-advocacy] [HACKERS] Call for BOFs Linux World Expo Boston

2004-10-07 Thread David Fetter
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

Re: [HACKERS] libpq and prepared statements progress for 8.0

2004-10-18 Thread David Fetter
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

[HACKERS] DDL triggers [was Re: [GENERAL] database constraints]

2004-10-07 Thread David Fetter
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

Re: [HACKERS] Why frequently updated tables are an issue

2004-10-20 Thread David Fetter
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

[HACKERS] array_to_column function

2004-10-30 Thread David Fetter
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

Re: [HACKERS] array_to_column function

2004-10-31 Thread David Fetter
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

Re: [HACKERS] Suggestion: additional system views

2004-10-31 Thread David Fetter
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

Re: [HACKERS] Bittorrent

2004-11-07 Thread David Fetter
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

Re: [HACKERS] multiline CSV fields

2004-11-11 Thread David Fetter
. 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

Re: [HACKERS] need help on writing an aggregate function

2004-11-16 Thread David Fetter
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

Re: [Plperlng-devel] Re: [HACKERS] Concern about new PL/Perl

2004-11-19 Thread David Fetter
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

Re: [HACKERS] Beta5 now Available

2004-11-22 Thread David Fetter
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

Re: [HACKERS] Beta5 now Available

2004-11-22 Thread David Fetter
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

Re: [HACKERS] Beta5 now Available

2004-11-23 Thread David Fetter
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

Re: [HACKERS] Beta5 now Available

2004-11-23 Thread David Fetter
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

Re: [HACKERS] Beta5 now Available

2004-11-23 Thread David Fetter
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

Re: [HACKERS] [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)

2005-06-24 Thread David Fetter
-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

Re: [HACKERS] Proposal: associative arrays for plpgsql (concept)

2005-06-29 Thread David Fetter
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

Re: [HACKERS] Proposal: associative arrays for plpgsql (concept)

2005-06-29 Thread David Fetter
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

Re: [HACKERS] Backend working directories and absolute file paths

2005-06-30 Thread David Fetter
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

Re: [HACKERS] Backend working directories and absolute file paths

2005-06-30 Thread David Fetter
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

Re: [HACKERS] Backend working directories and absolute file paths

2005-06-30 Thread David Fetter
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

Re: [HACKERS] SQL99 - Nested Tables

2005-07-07 Thread David Fetter
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

Re: [HACKERS] SQL99 - Nested Tables

2005-07-07 Thread David Fetter
) 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

Re: [HACKERS] SQL99 - Nested Tables

2005-07-07 Thread David Fetter
. 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

Re: [HACKERS] Hide source code

2005-07-10 Thread David Fetter
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

Re: [HACKERS] Hide source code

2005-07-11 Thread David Fetter
-- 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

Re: [HACKERS] Hide source code

2005-07-11 Thread David Fetter
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

Re: [HACKERS] [PATCHES] thousands comma numeric formatting in psql

2005-07-12 Thread David Fetter
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

Re: [HACKERS] PL/Perl list value return causes segfault

2005-07-12 Thread David Fetter
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

[HACKERS] Toward pg_upgrade

2005-07-13 Thread David Fetter
, 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

[HACKERS] test

2005-07-13 Thread David Fetter
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

Re: [HACKERS] Toward pg_upgrade

2005-07-14 Thread David Fetter
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

Re: [HACKERS] Some new list.c primitives

2005-07-27 Thread David Fetter
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

Re: [HACKERS] PL/Perl list value return causes segfault

2005-07-29 Thread David Fetter
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

Re: [HACKERS] PL/Perl list value return causes segfault

2005-07-30 Thread David Fetter
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

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-03 Thread David Fetter
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

Re: [HACKERS] small proposal: pg_config record flag variables?

2005-08-09 Thread 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

Re: [HACKERS] SPARQL

2005-08-14 Thread David Fetter
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

Re: [HACKERS] pl/Ruby, deprecating plPython and Core

2005-08-16 Thread David Fetter
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

Re: [HACKERS] pl/Ruby, deprecating plPython and Core

2005-08-16 Thread David Fetter
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

Re: [HACKERS] pl/Ruby, deprecating plPython and Core

2005-08-16 Thread David Fetter
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

Re: [HACKERS] Welcome Core Team member Dave Page

2005-08-26 Thread David Fetter
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

Re: [HACKERS] Call for 7.5 feature completion

2005-08-26 Thread David Fetter
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

Re: [HACKERS] Stuff running slooow

2005-08-26 Thread David Fetter
... 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

[HACKERS] Improved \df(+) in psql + backward-compatibility

2005-08-28 Thread David Fetter
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

Re: [HACKERS] Improved \df(+) in psql + backward-compatibility

2005-08-29 Thread David Fetter
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

Re: [HACKERS] ALTER TABLE ( smallinto - boolean ) ...

2005-08-29 Thread David Fetter
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

Re: [HACKERS] Improved \df(+) in psql + backward-compatibility

2005-08-29 Thread David Fetter
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   2   3   4   5   6   7   8   9   10   >