Re: [HACKERS] plpgsql by default

2006-04-11 Thread David Fetter
On Tue, Apr 11, 2006 at 05:20:02PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: I don't get your not getting this 'cause you're a very smart guy. Are you under the impression that an attacker will stop because he has to try a few times? No, I'm saying that having access

Re: [HACKERS] plpgsql by default

2006-04-12 Thread David Fetter
cause? 5. What costs and tradeoffs does the security solution impose? Let's start with step 1 and go forward from there. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember

Re: [PATCHES] [HACKERS] Automatically setting work_mem

2006-04-22 Thread David Fetter
/104185/. HTH :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 4: Have you searched our list

Re: [HACKERS] pseudo-type record arguments for PL-functions

2006-05-04 Thread David Fetter
just finalizing a new, more flexible, type mapping implementation for PL/Java and it would be easy to add support for more pseudo types too. But what others would make sense? Ideally, some way to get all kinds of user-defined types. DOMAINs, too. :) Cheers, D -- David Fetter [EMAIL PROTECTED

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-18 Thread David Fetter
=# create domain clob as text; CREATE DOMAIN postgres=# create domain blob as bytea; CREATE DOMAIN postgres=# create domain number as integer; CREATE DOMAIN postgres=# postgres=# CREATE TABLE dual(); CREATE TABLE Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-18 Thread David Fetter
the misapprehension that this transition can be made painlessly or at low cost. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-18 Thread David Fetter
On Thu, May 18, 2006 at 01:22:55PM -0500, Jim C. Nasby wrote: On Thu, May 18, 2006 at 11:09:28AM -0700, David Fetter wrote: postgres=# CREATE TABLE dual(); CREATE TABLE You forgot to populate it. Oh, right. :) postgres=# CREATE TABLE dual AS SELECT 1; SELECT Cheers, D -- David Fetter

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

2006-05-18 Thread David Fetter
departments. PGDG doesn't have one, and if it did, it wouldn't have the power to drive features. So you better focus on advertising where PostgreSQL shines instead of poking fun at something you apparently do not follow. You've made some sweeping allegations here and no specifics. Cheers, D -- David

Re: [HACKERS] Gborg and pgfoundry

2006-05-25 Thread David Fetter
this possible. Which parts of it are you volunteering to do? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

Re: [HACKERS] Gborg and pgfoundry

2006-05-25 Thread David Fetter
On Thu, May 25, 2006 at 10:11:13AM -0700, Joshua D. Drake wrote: Bruce Momjian wrote: David Fetter wrote: On Wed, May 24, 2006 at 10:33:53PM -0400, Bruce Momjian wrote: I am asking again: what is the timetable for merging gborg and pgfoundry, and if not, can we set a date to shut down

Re: [HACKERS] Possible TODO item: copy to/from pipe

2006-05-31 Thread David Fetter
-- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Possible TODO item: copy to/from pipe

2006-05-31 Thread David Fetter
) PostgreSQL database, it may be impossible to get space for twice or more that. Giving people the option to stream COPYs through a pipe would alleviate a lot of pain. Cheers, D [1] A feature people seem to think we don't need, although convincing cases have been made for it. -- David Fetter [EMAIL

Re: [HACKERS] More thoughts about planner's cost estimates

2006-06-01 Thread David Fetter
clauses based on two columns, and x some simple value that can be easily calculated by looking at the data in advance. That would be neat :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter

Re: [HACKERS] More thoughts about planner's cost estimates

2006-06-02 Thread David Fetter
of some sort, and other, which are always biased, and never good. What's at issue here is a biased estimator, not a biased sample. If you know an unbiased estimator of multiplicity based on a random sample, that would be a great :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org

Re: [HACKERS] COPY (query) TO file

2006-06-02 Thread David Fetter
strongly favor the second option as being more flexible than the first. +1 :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

[HACKERS] Version-aware psql?

2003-08-01 Thread David Fetter
on this :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778 ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] New function: epoch_to_timestamp...

2003-08-15 Thread David Fetter
On Fri, Aug 15, 2003 at 06:57:24AM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: Is there a reasonable way to add an optional param or two to mark time zones, or should that just the application programmer's hassle? The return type should be timestamptz, which makes

Re: [HACKERS] 7.4RC1 planned for Monday

2003-10-30 Thread David Fetter
On Thu, Oct 30, 2003 at 09:51:24PM -0500, Doug McNaught wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Thu, 30 Oct 2003, David Fetter wrote: Any chance of putting up a torrent for it? I'd be happy to host, but I'd have to get the link on the downloads page somehow

Re: [HACKERS] [PATCHES] drop if exists remainder

2006-06-08 Thread David Fetter
people didn't speak up when this was first raised. :-) I did :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

Re: [HACKERS] [GENERAL] [ppa][PATCHES] Argument handling improvements

2006-06-21 Thread David Fetter
. It provides support for both JS and JS deficient users. I think you are writing to the wrong mailing list for phpPgAdmin issues. I think he's writing to the right lists to get testers. If he's not, it's my fault for suggesting it to him :) Cheers, D -- David Fetter [EMAIL PROTECTED] http

Re: [HACKERS] vacuum, performance, and MVCC

2006-06-22 Thread David Fetter
. Even if there were zero overhead for this, which there couldn't be, you'd have a real problem auditing attempted actions. This would be a very big problem when trying to track down a rogue app and/or a denial of service attack. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone

Re: [HACKERS] vacuum, performance, and MVCC

2006-06-23 Thread David Fetter
the database, there are some sticky situations that need to be considered, but it shouldn't break much. We're eagerly awaiting your patch. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter

Re: [HACKERS] request for feature: psql 'DSN' option

2006-07-07 Thread David Fetter
than using the service file? What Andrew asked. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

Re: [HACKERS] Removing AddDepends; should I bother with a project?

2006-07-10 Thread David Fetter
orbit. It's the only way to be sure. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 4

Re: [HACKERS] Three weeks left until feature freeze

2006-07-11 Thread David Fetter
as needed. What plans do we have to integrate PL/J? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

Re: [HACKERS] pgsql-patches considered harmful

2006-07-11 Thread David Fetter
of it. I'd need some help, though :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 6

Re: [HACKERS] Three weeks left until feature freeze

2006-07-12 Thread David Fetter
/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

Re: [HACKERS] 8.2 features?

2006-07-13 Thread David Fetter
On Thu, Jul 13, 2006 at 05:09:32PM -0400, Jonah H. Harris wrote: On 7/13/06, Andrew Dunstan [EMAIL PROTECTED] wrote: . multiple values clauses for INSERT I would be very happy to see it accepted. Same here. aolMe, too!/aol Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org

Re: [HACKERS] [COMMITTERS] pgsql: Done: o -Display IN, INOUT, and OUT parameters in \df

2006-07-18 Thread David Fetter
On Tue, Jul 18, 2006 at 06:07:01PM -0400, Bruce Momjian wrote: David Fetter wrote: On Tue, Jul 18, 2006 at 03:20:51PM -0300, Bruce Momjian wrote: Log Message: --- Done: o -Display IN, INOUT, and OUT parameters in \df Oops! Should I change the patch to say

Re: [HACKERS] Units in postgresql.conf

2006-07-20 Thread David Fetter
to calculate right now (you'd need = 65536). I haven't thought yet how to parse or implement this, but would people find this useful? Absolutely! :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype

Re: [HACKERS] Units in postgresql.conf -- How to report?

2006-07-24 Thread David Fetter
that gives an integer (4) seems the most reasonable to me in terms of interface and implementation. I'm for (4), as it's also what people are used to from things like GNU's -h option. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM

Re: [HACKERS] [PATCHES] New variable server_version_num

2006-07-30 Thread David Fetter
version from about 6.4 forward ... See above for why it's good also to have it surfaced to SQL :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote

Re: [HACKERS] [PATCHES] New variable server_version_num

2006-07-30 Thread David Fetter
On Sun, Jul 30, 2006 at 11:27:33AM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Sat, Jul 29, 2006 at 09:44:10PM -0400, Tom Lane wrote: The correct solution is for client-side libraries to provide the feature. Not if the app is written in SQL, as the bootstrap

Re: [HACKERS] [PATCHES] New variable server_version_num

2006-07-30 Thread David Fetter
On Sun, Jul 30, 2006 at 12:17:57PM -0400, Jonah H. Harris wrote: On 7/30/06, David Fetter [EMAIL PROTECTED] wrote: Failure to parse means the transaction bails out, which is just what I want in my case, as it disallows people attempting to run the programs--they're for DBI-Link--on too early

[HACKERS] Let psql process files with 4,294,967,295 lines

2006-07-30 Thread David Fetter
in order to get 64-bit arithmetic, but I figure it's good enough to get a discussion started. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Index: src/bin/psql/common.c

Re: [HACKERS] request: support of array in plperl OUT arguments

2006-07-30 Thread David Fetter
with { or dimension information postgres=# I starting work on it. I hope It will be done before current feature freeze. Regards Pavel Stehule It seems Pavel missed sending the preliminary patch, so here it is :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778

Re: [HACKERS] Let psql process files with 4,294,967,295 lines

2006-07-30 Thread David Fetter
On Sun, Jul 30, 2006 at 05:40:16PM -0400, Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: David Fetter wrote: This patch changes the data type from unsigned int to unsigned long long, which is probably not the correct thing in order to get 64-bit arithmetic, but I figure it's

[HACKERS] Volunteer for -patches summary

2006-08-01 Thread David Fetter
out the PostgreSQL Weekly News. Thanks in advance for your help with this :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end

Re: [HACKERS] [PATCHES] New variable server_version_num

2006-08-01 Thread David Fetter
On Tue, Aug 01, 2006 at 12:37:48PM -0500, Jim C. Nasby wrote: On Sun, Jul 30, 2006 at 11:27:33AM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Sat, Jul 29, 2006 at 09:44:10PM -0400, Tom Lane wrote: The correct solution is for client-side libraries to provide

Re: [HACKERS] [BUGS] Patch to allow C extension modules to initialize/finish

2006-08-03 Thread David Fetter
-backend, i.e. when the function is invoked. There's also some possibility that something might go into %_SHARED. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote

Re: [HACKERS] 8.2 features status

2006-08-04 Thread David Fetter
honored Postgres tradition: Breaking New Ground. We're definitely not done yet. :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end

Re: [HACKERS] 8.2 features status

2006-08-04 Thread David Fetter
available to others to claim. 3. Should the person claiming the feature not communicate to -hackers for some period--I'm thinking 3 weeks is about right--the item goes back in the unclaimed pool with a message to -hackers saying that that's what's happened. What say? Cheers, D -- David Fetter

Re: [HACKERS] 8.2 features status

2006-08-04 Thread David Fetter
( EXECUTE IMMEDIATE LANGUAGE plperl $$...$$ ) AS (a int, b point, c text) JOIN ... Anyhow, the idea is to be able to call PL functionality in-line without having to create a function in advance. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM

Re: [HACKERS] 8.2 features status

2006-08-04 Thread David Fetter
to call other versions, too, like SELECT CALL IMMEDIATE LANGUAGE plpython $$...$$ (a, LOWER(b)) AS wacky_python_output FROM ... Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype

Re: [HACKERS] 8.2 features status

2006-08-04 Thread David Fetter
On Fri, Aug 04, 2006 at 02:37:56PM -0700, Neil Conway wrote: On Fri, 2006-08-04 at 12:40 -0700, David Fetter wrote: While I am not going to reopen the can of worms labeled 'bug tracker', I think it would be good to have a little more formality as far as claiming items goes. What say

Re: [HACKERS] 8.2 features status

2006-08-04 Thread David Fetter
to PostgreSQL can generally choose their place of work and to a large degree, their salaries, so let's not get too excited about how this is only a matter of selfless generosity. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

Re: [HACKERS] TODO system WAS: 8.2 features status

2006-08-06 Thread David Fetter
to find out what's going on. This thing is why I've been continuing the patches review on PostgreSQL Weekly News :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote

Re: [HACKERS] [PATCHES] [DOCS] Values list-of-targetlists patch for comments (was Re:

2006-08-09 Thread David Fetter
() statement and to its columns when the VALUES() statement is by itself? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

Re: [HACKERS] new job

2006-08-09 Thread David Fetter
On Wed, Aug 09, 2006 at 01:58:14PM -0400, Jonah H. Harris wrote: On 8/9/06, Devrim GUNDUZ [EMAIL PROTECTED] wrote: Congratulations for your new job. Seconded! We now have a quorum. ;) I vote yes! Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778

Re: [HACKERS] libpq Describe Extension [WAS: Bytea and perl]

2006-08-10 Thread David Fetter
? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] [PATCHES] New variable server_version_num

2006-08-11 Thread David Fetter
On Sat, Jul 29, 2006 at 09:14:16PM -0400, Greg Sabino Mullane wrote: Today on IRC David Fetter and some others were discussing version numbers and we realized that although libpq now provides the version of Postgres as a number, this is still a wheel that is being reinvented by apps many times

Re: [HACKERS] psql and INSERT/UPDATE/DELETE RETURNING

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

Re: [HACKERS] [PATCHES] extension for sql update

2006-08-12 Thread David Fetter
. Glad someone else replied. ;-) If you're looking for votes, +1. I'll gladly take a subset of the SQL standard UPDATE table SET (...) = (...) over having nothing. +1 here, too. :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread David Fetter
people figure out what to do with them from there. If no one demands full inclusion in a couple of versions, let's take it out. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember

Re: [HACKERS] [PATCHES] Adding fulldisjunctions to the contrib

2006-08-13 Thread David Fetter
On Sun, Aug 13, 2006 at 11:45:43AM -0400, Bruce Momjian wrote: David Fetter wrote: Our distribution is not a place to experiment with things. That's what separate pgfoundry projects are for. The fact we have some unusual things in /contrib is not a reason to add more. If it's

Re: [HACKERS] [PATCHES] selecting large result sets in psql using

2006-08-18 Thread David Fetter
that a \set variable lets people use minimal intrusiveness on scripts, etc., as they'll just set it when they start needing cursor-ized result sets and unset it when finished. Just my $.02 :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM

[HACKERS] PL/Perl: spi_prepare() and RETURNING

2006-08-24 Thread David Fetter
to? Cheers, D -- 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

Re: [HACKERS] PL/Perl: spi_prepare() and RETURNING

2006-08-24 Thread David Fetter
On Thu, Aug 24, 2006 at 11:31:02AM -0700, David Fetter wrote: Folks, I've found a little lacuna in the RETURNING feature, that being in PL/Perl's spi_prepare()/spi_execute_prepared() as illustrated in the attached file on CVS TIP. I think that fixing this is a matter of post-RETURNING

Re: [HACKERS] New XML section for documentation

2006-08-25 Thread David Fetter
(Object Language Binding) Part 11: SQL/Schemata Part 13: SQL/JRT (Java Routines and Types) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-26 Thread David Fetter
On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote: David Fetter wrote: On Fri, Aug 25, 2006 at 07:46:57PM -0400, Bruce Momjian wrote: Here is an new XML section for our SGML documentation. It explains the various XML capabilities, if we support them, and how to use them

Re: [HACKERS] Tricky bugs in concurrent index build

2006-08-26 Thread David Fetter
to double check the results of my ad-hoc updates before committing them saved me more headaches than I can count with Oracle. Autocommit off only became practical for interactive use with postgres when savepoints showed up. +1 +1 here, too :) Cheers, D -- David Fetter [EMAIL PROTECTED

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-26 Thread David Fetter
On Sat, Aug 26, 2006 at 12:48:32PM -0400, Bruce Momjian wrote: David Fetter wrote: On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote: Speaking of other parts of the SQL:2003 standard, how about one section each that mentions them? There's Part 4: SQL/PSM

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-26 Thread David Fetter
On Sat, Aug 26, 2006 at 01:16:06PM -0400, Bruce Momjian wrote: David Fetter wrote: On Sat, Aug 26, 2006 at 12:48:32PM -0400, Bruce Momjian wrote: David Fetter wrote: On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote: Speaking of other parts of the SQL:2003 standard

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-26 Thread David Fetter
On Sat, Aug 26, 2006 at 08:38:43PM +0200, Peter Eisentraut wrote: David Fetter wrote: We claim SQL standard compliance, No, we don't. And SQL conformance doesn't require you to implement all parts anyway. Right. It'd be nice to be able to tell what level of conformance we have to which

Re: [HACKERS] Coding style for emacs

2006-08-30 Thread David Fetter
and .vimrc files in the source (in, say, src.tools). The docs/FAQ would just say that we use BSD style with tab space 4 and refer to the sample files. thoughts? If we put them in a place that's visible before you get the source, we can help people use the settings globally :) Cheers, D -- David

Re: [HACKERS] Coding style for emacs

2006-08-30 Thread David Fetter
On Wed, Aug 30, 2006 at 06:28:06PM -0400, Andrew Dunstan wrote: David Fetter wrote: thoughts? If we put them in a place that's visible before you get the source, we can help people use the settings globally :) The likely level of our influence on someone who hasn't used the settings

Re: [HACKERS] Getting a move on for 8.2 beta

2006-09-02 Thread David Fetter
to the infamous tarbaby of bug/issue trackers. It's time we took that head-on instead of dancing around it. As expressed many times earlier, such a system must be accessible, both for read and write, by email. What other things must it do? Should it do? Must it avoid? Cheers, D -- David Fetter [EMAIL

Re: [HACKERS] Getting a move on for 8.2 beta

2006-09-02 Thread David Fetter
on that's silently down for a week with no ETAs in sight for getting any piece of it back on line. Bruce, are you ready to help create a more bus-proof situation? If so, what specific steps would you like to take in that direction? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone

Re: [HACKERS] updatable views and default values

2006-09-05 Thread David Fetter
-- 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 space map settings

Re: [HACKERS] log_duration is redundant, no?

2006-09-07 Thread David Fetter
avoid redundancy). I don't find this very persuasive --- it sounds awfully messy, and in fact isn't that exactly the old behavior we got rid of because no one could understand it? Guillaume's the author of pgfouine, which understands it and helps others to do same. Cheers, D -- David Fetter

Re: [HACKERS] log_duration is redundant, no?

2006-09-09 Thread David Fetter
values over the duration of an anonymous set of queries. How heavily loaded is the server is a perfectly legitimate metric to have available, especially when more detailed, i.e. more invasive probes could bring it down. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415

Re: [HACKERS] -HEAD planner issue wrt hash_joins on dbt3 ?

2006-09-13 Thread David Fetter
same. :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [HACKERS] Units in postgresql.conf.sample

2006-09-20 Thread David Fetter
= 1MB # min 64kB (The native units are of course still shown in the documentation for reference.) +1 for the change :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype

Re: [HACKERS] 8.3 Development Cycle

2006-09-22 Thread David Fetter
should probably move this forward or back one day. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

Re: [HACKERS] pgsql: We're going to have to spell dotless i

2006-09-24 Thread David Fetter
compelling enough to force a switch, it is a substantive difference that we can actually see. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-25 Thread David Fetter
will be in 1.6 at http://www.pgadmin.org/development/changelog.php Could you clarify this a bit? As far as I can tell, it's not possible to set up slony initially with pgadmin 1.4.latest. Has this changed in 1.6? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778

Re: [HACKERS] psql service parameter

2006-09-27 Thread David Fetter
switch too. Small 8.3 TODO item? The hack I've used so far is PGSERVICE=/path/to/pg_service.conf psql Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread David Fetter
as a bug fix and should go in 8.2 :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast)--- TIP 6

[HACKERS] Numeric overflow problem + patch

2006-09-28 Thread David Fetter
Folks, Dennis Björklund and I discovered a little problem with how CVS TIP reports overflows on cast. Please find enclosed a patch which fixes it. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype

Re: [HACKERS] Numeric overflow problem + patch

2006-09-28 Thread David Fetter
On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1. [ becomes ] ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1 - 5

Re: [HACKERS] Numeric overflow problem + patch

2006-09-28 Thread David Fetter
On Thu, Sep 28, 2006 at 11:16:56PM +0200, Martijn van Oosterhout wrote: On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1. [ becomes ] ! DETAIL

Re: [HACKERS] Nulls, arrays, records, IS NULL, IS DISTINCT FROM

2006-09-29 Thread David Fetter
. Is there one available? If there is none, which behavior do we think is most useful/consistent? My reading of the (provisional) spec is that a complex type (ROW, ARRAY, MULTISET) is NULL iff all of its elements are NULL or the whole of it is NULL. Cheers, D -- David Fetter [EMAIL PROTECTED

[HACKERS] Per-database search_path

2006-09-29 Thread David Fetter
by connecting. What would be involved with making this so? So far, I can see: * Storing this information in pg_catalog somehow * Setting the search_path when a login role connects Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

Re: [HACKERS] Per-database search_path

2006-09-29 Thread David Fetter
is the ability to write to the filesystem, which means that there's no boundary really possible. Maybe some kind of tiered system of users with more than 2 tiers...but that sounds pretty byzantine to me. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM

Re: [HACKERS] Per-database search_path

2006-09-29 Thread David Fetter
On Fri, Sep 29, 2006 at 05:41:35PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Fri, Sep 29, 2006 at 01:06:09PM -0700, Josh Berkus wrote: However, it almost seems like this would become a piece of the other per-database-user stuff we'd like to do, like local superuser

Re: [HACKERS] New version of money type

2006-09-29 Thread David Fetter
in such a way that the relationships are not always transitive :P Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

Re: [HACKERS] New version of money type

2006-09-30 Thread David Fetter
to take time, inflation/deflation, pairwise exchange rates, etc. into account. It would look more like a schema with a large data set and a large body of code loaded into it than it would a data type. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM

Re: [HACKERS] Digging gram.y

2006-10-04 Thread David Fetter
for example. I can't imagine column setof text. It's part of the SQL:2003 standard as MULTISET :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote

Re: [HACKERS] pg_dump exclusion switches and functions/types

2006-10-07 Thread David Fetter
including everything if there are none), then apply all the exclusion switches. +1 :) Order-dependent switches are a giant foot gun. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter

Re: [HACKERS] pg_dump exclusion switches and functions/types

2006-10-09 Thread David Fetter
On Mon, Oct 09, 2006 at 12:07:29PM -0500, Jim C. Nasby wrote: On Sat, Oct 07, 2006 at 06:22:19PM -0700, David Fetter wrote: On Fri, Oct 06, 2006 at 10:28:21PM -0400, Gregory Stark wrote: Tom Lane [EMAIL PROTECTED] writes: The existing patch's behavior is that the rightmost switch

Re: [HACKERS] pg_dump exclusion switches and functions/types

2006-10-09 Thread David Fetter
On Mon, Oct 09, 2006 at 02:34:09PM -0500, Jim C. Nasby wrote: On Mon, Oct 09, 2006 at 01:59:18PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: On Sat, Oct 07, 2006 at 06:22:19PM -0700, David Fetter wrote: On Fri, Oct 06, 2006 at 10:28:21PM -0400, Gregory Stark wrote: My

Re: [HACKERS] Is this really really as designed or defined in some standard

2008-08-31 Thread David Fetter
) Is this defined by some standard or just an oversight ? This looks like a bug. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres

Re: [HACKERS] Window functions patch v04 for the September commit fest

2008-08-31 Thread David Fetter
On Mon, Sep 01, 2008 at 12:15:19PM +0900, Hitoshi Harada wrote: README is updated. http://umitanuki.net/pgsql/wfv04/design.html Please add link to commit fest wiki. Added :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Window functions patch v04 for the September commit fest

2008-09-01 Thread David Fetter
. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Window functions patch v04 for the September commit fest

2008-09-02 Thread David Fetter
On Tue, Sep 02, 2008 at 02:42:25AM -0400, Tom Lane wrote: Heikki Linnakangas [EMAIL PROTECTED] writes: David Fetter wrote: On Mon, Sep 01, 2008 at 09:00:47PM +0300, Heikki Linnakangas wrote: Ok, I'm starting to read up on SQL2003 window functions, Maybe it would be better to read

Re: [HACKERS] Window functions patch v04 for the September commit fest

2008-09-02 Thread David Fetter
On Tue, Sep 02, 2008 at 12:42:45PM +0100, Simon Riggs wrote: On Tue, 2008-09-02 at 03:14 -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Tue, Sep 02, 2008 at 02:42:25AM -0400, Tom Lane wrote: It's not like we haven't seen a SQL draft go down in flames before

Re: [HACKERS] Proposed patch: make pg_dump --data-only consider FK constraints

2008-09-07 Thread David Fetter
On Sun, Sep 07, 2008 at 02:06:40PM -0400, Tom Lane wrote: Okay, I got tired of seeing people complain about foreign-key constraint violations in data-only dumps. Isn't this something solved in the more general case by having pre-data, data, and post-data dump options? Cheers, David. -- David

Re: [HACKERS] Keeping creation time of objects

2008-09-09 Thread David Fetter
--failures. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers

Re: [HACKERS] Keeping creation time of objects

2008-09-10 Thread David Fetter
resistant, should I refuse them on principle? See above. Why? See above. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres

[HACKERS] Better auth errors from libpq

2008-09-11 Thread David Fetter
this would be most welcome :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ? GNUmakefile

<    1   2   3   4   5   6   7   8   9   10   >