Re: [HACKERS] PGXS: REGRESS_OPTS=--load-language=plpgsql

2010-02-18 Thread David Fetter
On Thu, Feb 18, 2010 at 06:27:30PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: While hacking on PL/Parrot, I ran across an issue where when trying to load PL/pgsql, it's done unconditionally and fails. How do we fix pg_regress to be a little more subtle about this? Why

Re: [HACKERS] PGXS: REGRESS_OPTS=--load-language=plpgsql

2010-02-18 Thread David Fetter
On Fri, Feb 19, 2010 at 12:26:29AM -0200, Euler Taveira de Oliveira wrote: David Fetter escreveu: OK, I know it's late, but having PL/pgsql on by default has caused an unforeseen need: --require-language. Why? IMHO pg_regress should be used with the same postgres version it was built

Re: [HACKERS] PGXS: REGRESS_OPTS=--load-language=plpgsql

2010-02-19 Thread David Fetter
On Fri, Feb 19, 2010 at 01:34:46PM -0500, Robert Haas wrote: On Thu, Feb 18, 2010 at 11:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes: David Fetter da...@fetter.org wrote: support both pre-9.0 and post-9.0 PostgreSQLs.  David Wheeler has

Re: [HACKERS] PGXS: REGRESS_OPTS=--load-language=plpgsql

2010-02-21 Thread David Fetter
On Thu, Feb 18, 2010 at 01:51:08PM -0800, David Fetter wrote: Folks, While hacking on PL/Parrot, I ran across an issue where when trying to load PL/pgsql, it's done unconditionally and fails. How do we fix pg_regress to be a little more subtle about this? For now, and for the archives

Re: [HACKERS] pg_stop_backup does not complete

2010-02-23 Thread David Fetter
have been reversed. Perhaps we should put something in the docs to say and test. The correct resolution is to put in an archive_command that works. +1 for clarifying and extending the docs. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] pg_stop_backup does not complete

2010-02-24 Thread David Fetter
. Although Greg is correct that a NOTICE wouldn't be logged at default log levels, lots of people don't use that default. Comments? As I see it, the clarity concern trumps the log spam one. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] strict version of version_stamp.pl

2010-02-25 Thread David Fetter
, and perlcritic -4 Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating

Re: [HACKERS] contrib/xml2 vs core xml in 8.3

2010-02-28 Thread David Fetter
testing to suggest that 8.4 is no worse than 8.3 as far as the core xml operations go. Comments? +1 for back-patching. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [HACKERS] psql with Function Type in \df

2010-02-28 Thread David Fetter
On Thu, Feb 25, 2010 at 07:20:58PM -0500, Bruce Momjian wrote: Did we ever get tab completion support for these backslash commands? Nope :/ Not sure if I'll be able to get to it this week, either. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

[HACKERS] Re: [COMMITTERS] pgsql: Instead of trying (and failing) to allow label at the end of

2010-03-02 Thread David Fetter
that the label must go before DECLARE. with the docs saying another thing, this couldn't be considered as a bug fix and therefore backpatchable +1 for back-patching. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] SQL compatibility reminder: MySQL vs PostgreSQL

2010-03-05 Thread David Fetter
, but by no means all, developers of some little project by introducing massive bugs. That is never going to happen, and you need to stop asking. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] SQL compatibility reminder: MySQL vs PostgreSQL

2010-03-05 Thread David Fetter
On Fri, Mar 05, 2010 at 03:10:59PM -0500, Andrew Dunstan wrote: David Fetter wrote: On Fri, Mar 05, 2010 at 02:56:23PM +0100, François Pérou wrote: Dear friends, As a reminder, I took part in the development of pgAdmin and I am not looking for a flame war. You're doing a poor job

Re: [HACKERS] SQL compatibility reminder: MySQL vs PostgreSQL

2010-03-08 Thread David Fetter
then we have to find time to learn to do things wrong? seems like a nosense argument to me Indeed. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] SQL compatibility reminder: MySQL vs PostgreSQL

2010-03-08 Thread David Fetter
On Mon, Mar 08, 2010 at 12:18:31PM -0500, Robert Haas wrote: On Mon, Mar 8, 2010 at 12:10 PM, David Fetter da...@fetter.org wrote: On Mon, Mar 08, 2010 at 11:58:20AM -0500, Jaime Casanova wrote: On Mon, Mar 8, 2010 at 4:17 AM, Pierre C li...@peufeu.com wrote: My opinion

Re: [HACKERS] [patch] build issues on Win32

2010-03-10 Thread David Fetter
to contort our source code in order to make a marginal improvement in the ability to coexist with random other code that is also polluting the link-time namespace. +1 for de-supporting this option. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] Dyamic updates of NEW with pl/pgsql

2010-03-11 Thread David Fetter
On Thu, Mar 11, 2010 at 03:27:23PM +0100, strk wrote: On Wed, Mar 10, 2010 at 07:50:16AM -0500, Andrew Dunstan wrote: Using an hstore in 9.0 it's not too bad, Does it still have a limit of 65535 bytes per field ? No. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] [patch] build issues on Win32

2010-03-11 Thread David Fetter
. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org

Re: [HACKERS] Dyamic updates of NEW with pl/pgsql

2010-03-12 Thread David Fetter
. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org

Re: [HACKERS] Dyamic updates of NEW with pl/pgsql

2010-03-12 Thread David Fetter
On Fri, Mar 12, 2010 at 07:35:41PM +0100, Pavel Stehule wrote: 2010/3/12 David Fetter da...@fetter.org: This is, by the way, an excellent argument for including hstore in core in 9.1. :) I like it - but it looking little bit strange - I thinking we need only one function (maybe

Re: [HACKERS] Dyamic updates of NEW with pl/pgsql

2010-03-13 Thread David Fetter
of reflection ] ISTM that in most cases where this is a serious issue, the trigger functions are doing the *same* thing to different tables. Yes. Well, at least the same base type. I don't suppose now is a great time to get into the second class status of domains. :P Cheers, David. -- David

Re: [HACKERS] Partitioning syntax

2010-03-17 Thread David Fetter
-Is-Such-Sweet-Sorrow.html Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

Re: [HACKERS] Order of pg_stat_activity timestamp columns

2010-03-17 Thread David Fetter
, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

2010-03-22 Thread David Fetter
. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

2010-03-22 Thread David Fetter
On Mon, Mar 22, 2010 at 04:47:37PM +, Simon Riggs wrote: On Mon, 2010-03-22 at 09:00 -0700, David Fetter wrote: Yes, for most people touching != overlap. So it just looks like a bug. I don't know which people you've surveyed, but at least in my math classes, one point in common

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

2010-03-22 Thread David Fetter
On Mon, Mar 22, 2010 at 01:46:51PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: I'm seeing a lot of places where this might be documented. Any ideas as to which ones are appropriate? I would think Geometric Functions and Operators would be the most appropriate spot

Re: [HACKERS] Comments on Exclusion Constraints and related datatypes

2010-03-22 Thread David Fetter
On Mon, Mar 22, 2010 at 04:04:16PM -0300, Alvaro Herrera wrote: David Fetter wrote: diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 9881ff4..9313112 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -7134,7 +7134,7 @@ CREATE TYPE rainbow AS ENUM

Re: [HACKERS] 9.0 release notes done

2010-03-22 Thread David Fetter
to the alphas ... in raw SGML. While not a WYSIWYG, shelling out to make after each disk write should do what you want. Which editor(s) do you like to use? Emacs and vim both have ways to do this. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

[HACKERS] Re: [GENERAL] question (or feature-request): over ( partition by ... order by LIMIT N)

2010-03-25 Thread David Fetter
most of them discarded. That sounds like the optimizer's falling down on the job. Would this be difficult to fix? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread David Fetter
like a much better idea. Andrew, do you have some notes on this? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [HACKERS] pgindent excluded files list

2010-03-31 Thread David Fetter
/pgindent/typedefs.list which is shorter and more efficient and less error prone than the way it's done in the current instructions (which puts the patterns to be excluded in a series of egrep pipes). Thoughts? +1 for simplifying and consolidating. Cheers, David. -- David Fetter da

Re: [HACKERS] [RFC] nodeToString format and exporting the SQL parser

2010-04-04 Thread David Fetter
. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Thoughts on pg_hba.conf rejection

2010-04-15 Thread David Fetter
pg_hba.conf just to dismiss it. Such a person might exist, but we don't need to bend things around a case so rare that it makes being struck by lightning look like a certainty. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-18 Thread David Fetter
around access to the head of the array. v2 patch attached If you've committed this, or any other patch you've sent here, *please* mention so on the same thread. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-18 Thread David Fetter
On Sun, Apr 18, 2010 at 09:22:21PM +0100, Simon Riggs wrote: On Sun, 2010-04-18 at 13:16 -0700, David Fetter wrote: On Sun, Apr 18, 2010 at 12:01:05PM +0100, Simon Riggs wrote: On Sun, 2010-04-18 at 08:24 +0100, Simon Riggs wrote: On Sat, 2010-04-17 at 18:52 -0400, Tom Lane wrote

Re: [HACKERS] Need to contact driver authors about change in index naming behavior ...

2010-05-04 Thread David Fetter
a to alpha; ALTER TABLE complexer RENAME b to bravo; Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember

Re: [HACKERS] Need to contact driver authors about change in index naming behavior ...

2010-05-04 Thread David Fetter
On Tue, May 04, 2010 at 10:00:52PM -0400, Andrew Dunstan wrote: David Fetter wrote: On Tue, May 04, 2010 at 04:40:22PM -0700, Josh Berkus wrote: Hackers, Driver maintainers, The 9.0 don't rename index cols behavior has already broken JDBC. We need to get in touch with other driver

Re: [HACKERS] 9.0b1: ERROR: btree index keys must be ordered by attribute

2010-05-09 Thread David Fetter
Ian Barwick -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] primary/secondary/master/slave/standby

2010-05-12 Thread David Fetter
primary/secondary, and less tied to a particular model of interaction. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people

Re: [HACKERS] Retiring from the PostgreSQL core team

2010-05-13 Thread David Fetter
serious hacking. I hope to see many of you in Ottawa. You can run, but you can't hide ;) Thanks for your deep and broad contributions so far, and I'm sure I speak for many when I say we're looking forward to upcoming ones. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] [PATCH] Add SIGCHLD catch to psql

2010-05-15 Thread David Fetter
this to the next commit-fest: https://commitfest.postgresql.org/action/commitfest_view/inprogress Thanks. Wouldn't this count as a bug fix? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

[HACKERS] Specification for Trusted PLs?

2010-05-21 Thread David Fetter
Folks, I feel dumb. I have been looking for a document which specifies what trusted and untrusted PLs must do and forbid, so far without result. Where do we document this, and if we don't where *should* we document this? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] Specification for Trusted PLs?

2010-05-21 Thread David Fetter
yu really need something like cannot communicate with outside processes? These need to be testable conditions, and new tests need to get added any time we find that we've missed something. Making this concept fuzzier is exactly the wrong direction to go. Cheers, David. -- David Fetter da

Re: [HACKERS] Specification for Trusted PLs?

2010-05-21 Thread David Fetter
On Fri, May 21, 2010 at 12:26:24PM -0400, Stephen Frost wrote: * David Fetter (da...@fetter.org) wrote: These need to be testable conditions, and new tests need to get added any time we find that we've missed something. Making this concept fuzzier is exactly the wrong direction to go

Re: [HACKERS] Specification for Trusted PLs?

2010-05-21 Thread David Fetter
On Fri, May 21, 2010 at 01:45:45PM -0400, Stephen Frost wrote: * David Fetter (da...@fetter.org) wrote: That is *precisely* the business we need to be in, at least for the languages we ship, and it would behoove us to test languages we don't ship so we can warn people when they don't pass

Re: [HACKERS] Specification for Trusted PLs?

2010-05-21 Thread David Fetter
(who is not, at this point, going to suggest that a trusted boolean may inadequately reflect users' needs) -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com

Re: [HACKERS] Specification for Trusted PLs?

2010-05-21 Thread David Fetter
On Fri, May 21, 2010 at 12:36:50PM -0700, David Fetter wrote: On Fri, May 21, 2010 at 03:15:27PM -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Fri, May 21, 2010 at 2:21 PM, Tom Lane t...@sss.pgh.pa.us wrote: (1) no access to system calls (including file and network I

Re: [HACKERS] Arrays of Complex Types

2007-03-27 Thread David Fetter
On Tue, Mar 27, 2007 at 11:08:44AM -0700, David Fetter wrote: On Sun, Mar 25, 2007 at 10:18:14PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: I've written up a patch intended to implement this on the non-pg_catalog tables and VIEWs, but while it builds, it doesn't

Re: [HACKERS] Arrays of Complex Types

2007-03-28 Thread David Fetter
On Wed, Mar 28, 2007 at 07:05:24AM -, Andrew - Supernews wrote: On 2007-03-27, David Fetter [EMAIL PROTECTED] wrote: Per further discussion with Andrew of Supernews and Merlin Moncure, I've added a check for compound types and moved the creation of the array type from DefineRelation

Re: [HACKERS] Arrays of Complex Types

2007-03-28 Thread David Fetter
On Wed, Mar 28, 2007 at 01:33:56PM -0400, Andrew Dunstan wrote: Alvaro Herrera wrote: David Fetter wrote: The first is in type_sanity, which basically doesn't understand that complex types now have array types associated with them and thinks they're orphan array types, so it's actually

Re: [HACKERS] Arrays of Complex Types

2007-03-28 Thread David Fetter
, but let's not go there just now ;) in the form of MULTISET, and that, too, should eventually be in the above mix. I'm not advocating the idea that people should *store* those compositions--if it were just up to me, I'd disallow it--but they're very handy for input and output :) Cheers, D -- David

Re: [HACKERS] Arrays of Complex Types

2007-03-30 Thread David Fetter
On Fri, Mar 02, 2007 at 03:40:16PM -0800, David Fetter wrote: Folks, I'd like to take the TODO item that reads, Add support for arrays of complex types, but before I start patching, I'd like to see whether what I'm about to do makes any sense: After several rounds of patches, it appears

Re: Macros for typtype (was Re: [HACKERS] Arrays of Complex Types)

2007-03-31 Thread David Fetter
On Sat, Mar 31, 2007 at 07:13:20PM -0400, Bruce Momjian wrote: Tom Lane wrote: I wrote: David Fetter [EMAIL PROTECTED] writes: What parts of the code would need a once-over? A lot :-( ... probably every place that touches typtype or typelem would need at least a look. It'd

Re: Macros for typtype (was Re: [HACKERS] Arrays of Complex Types)

2007-03-31 Thread David Fetter
On Sat, Mar 31, 2007 at 07:58:34PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: What say we put one in pre-emptively for TYPTYPE_ARRAY? When and if the patch appears, you can add it ;-). I'm just intending a search-and-replace at the moment. Like this? Cheers, D

Re: [HACKERS] Arrays of Complex Types

2007-04-02 Thread David Fetter
On Fri, Mar 30, 2007 at 05:08:42PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: After several rounds of patches, it appears that it might be easier to create a new typtype entry, which I'll tentatively call 'a' because it seems a little fragile and a lot inelegant and hard

Re: [HACKERS] Arrays of Complex Types

2007-04-03 Thread David Fetter
. :) It's a lot simpler to have them always, and it fits in with the larger picture of making arrays fully composable with other operations like DOMAIN, ENUM and TYPE. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

Re: [PATCHES] [HACKERS] Arrays of Complex Types

2007-04-03 Thread David Fetter
On Tue, Apr 03, 2007 at 02:30:07AM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Mon, Apr 02, 2007 at 10:01:44PM -0400, Alvaro Herrera wrote: So, hum, what happened to the idea of creating the array types only on demand? Scotched, as far as I could tell, More like

Re: [HACKERS] Auto Partitioning

2007-04-04 Thread David Fetter
steam ahead. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate ---(end

Re: [HACKERS] Auto Partitioning

2007-04-06 Thread David Fetter
you can show it's not your fault when the mature hits the fan, I agree. If you mean, taking a precaution that will actually prevent a problem from occurring in the first place, it definitely does. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM

Re: [PATCHES] [HACKERS] Arrays of Complex Types

2007-04-08 Thread David Fetter
in an array-of-composite be something smaller than full tuples? It's not going to be anything but a toy unless you can get the per-entry overhead down to something sane. Perhaps the MinimalTuple representation would work. Sounds neat, too :) Cheers, D -- David Fetter [EMAIL PROTECTED] http

Re: [PATCHES] [HACKERS] Arrays of Complex Types

2007-04-09 Thread David Fetter
be great :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate ---(end

Re: [HACKERS] Can't ri_KeysEqual() consider two nulls as equal?

2007-04-18 Thread David Fetter
expect it to act like normal equality (with nulls being different). How about NotDistinct as in SQL's IS NOT DISTINCT FROM ? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember

Re: [HACKERS] temporal variants of generate_series()

2007-04-28 Thread David Fetter
Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate ---(end of broadcast

Re: [HACKERS] temporal variants of generate_series()

2007-05-01 Thread David Fetter
$2) - extract('epoch' FROM $1) )::int8 ) AS s(i) ORDER BY s.i ASC ; $$; -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http

Re: [PATCHES] [HACKERS] Arrays of Complex Types

2007-05-06 Thread David Fetter
should prevent direct operations on array types, and they should live or die by their parent types. Thoughts? +1 on binding the array types tightly to the parent types. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

[HACKERS] Problem with CREATE LANGUAGE in CVS TIP

2007-05-09 Thread David Fetter
that PL/PerlU wasn't available, even though createlang had succeeded. I think this is a bug in CREATE LANGUAGE, as CREATE LANGUAGE should have failed when it found no PL/Perl compiled in. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

Re: [HACKERS] Testing concurrent psql

2007-05-16 Thread David Fetter
. I seem to recall there was a way to construct scenarios that returned multiple result sets via rules but I don't know how to arrange that. Anyone remember? I don't know about rules, but you can have a SRF return SETOF REFCURSOR. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org

Re: [HACKERS] Not ready for 8.3

2007-05-17 Thread David Fetter
? You're uniquely qualified because your shins still smart from all the things you barked them on :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating

Re: [HACKERS] Command tags in create/drop scripts

2007-06-09 Thread David Fetter
to STDERR if called by a name that doesn't have the pg_ prefix. Default to symlinking the old names for backwards compatibility until 9.0. +1 +1 It's a lot easier just to prefix the names than to do something clever. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone

Re: [HACKERS] Rethinking user-defined-typmod before it's too late

2007-06-15 Thread David Fetter
a nonintegral typmod. Note that the typmodout side is already OK since it is defined to return a string. Comments? +1 :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote

Re: [HACKERS] [Pgbuildfarm-members] time to play ...

2007-06-29 Thread David Fetter
___ Pgbuildfarm-members mailing list [EMAIL PROTECTED] http://pgfoundry.org/mailman/listinfo/pgbuildfarm-members -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating

Re: [HACKERS] [EMAIL PROTECTED]: Re: [GENERAL] array_to_set functions]

2007-08-14 Thread David Fetter
:/ Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate ---(end

Re: [HACKERS] Per-function search_path = per-function GUC settings

2007-09-01 Thread David Fetter
to create a secure SECURITY DEFINER function. With the extended syntax I proposed it could take just one command to create such a function :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype

Re: [HACKERS] synchronous_commit: Developer's View

2007-09-01 Thread David Fetter
. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate ---(end of broadcast

Re: [HACKERS] synchronous_commit: Developer's View

2007-09-01 Thread David Fetter
On Sat, Sep 01, 2007 at 10:51:48PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: While we're at it, it would be very nice to be able to set default per-role, per-database settings. Er ... what deficiency do you see in ALTER ROLE SET and ALTER DATABASE SET? You can't set

Re: [HACKERS] synchronous_commit: Developer's View

2007-09-01 Thread David Fetter
On Sat, Sep 01, 2007 at 11:07:55PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Sat, Sep 01, 2007 at 10:51:48PM -0400, Tom Lane wrote: Er ... what deficiency do you see in ALTER ROLE SET and ALTER DATABASE SET? You can't set both at once. Oh, you mean the cross

Re: [HACKERS] pg_dump and insert multi-rows option

2007-09-04 Thread David Fetter
. I'm pretty sure it does in the current versions of most other DBMSs. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http

Re: [HACKERS] pg_proc.probin should become text?

2009-08-03 Thread David Fetter
could I have been so dense? ;) I think that the least painful solution might be to change pg_proc.probin to be declared as text. Otherwise we're going to need version-specific klugery in pg_dump and who knows where else. Comments? +1 on changing it to text. Cheers, David. -- David Fetter

Re: [HACKERS] SE-PostgreSQL Specifications

2009-08-03 Thread David Fetter
. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] the case for machine-readable error fields

2009-08-04 Thread David Fetter
of inner platform effect. http://en.wikipedia.org/wiki/Inner-platform_effect Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating

Re: [HACKERS] the case for machine-readable error fields

2009-08-04 Thread David Fetter
. Anyone want to vote ASN.1 for world domination? Can we set up some kind of cage match between the dueling standards? I love standards. There are so many to choose from :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Alpha releases: How to tag

2009-08-04 Thread David Fetter
On Tue, Aug 04, 2009 at 05:19:16PM +0300, Peter Eisentraut wrote: On Monday 03 August 2009 22:52:55 David Fetter wrote: On Mon, Aug 03, 2009 at 09:22:52PM +0300, Peter Eisentraut wrote: On Monday 03 August 2009 21:07:00 David Fetter wrote: We require that people supply docs

Re: [HACKERS] dblink bulk operations

2009-08-06 Thread David Fetter
it's worth, DBI-Link provides a lot of this. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org

Re: [HACKERS] dblink bulk operations

2009-08-06 Thread David Fetter
On Thu, Aug 06, 2009 at 12:28:15PM -0400, Andrew Dunstan wrote: David Fetter wrote: For what it's worth, DBI-Link provides a lot of this. Indeed, but that assumes that perl+DBI+DBD::Pg is available, which is by no means always the case. If we're going to have a dblink module ISTM

Re: [HACKERS] Alpha releases: How to tag

2009-08-07 Thread David Fetter
On Fri, Aug 07, 2009 at 04:07:08PM -0400, Bruce Momjian wrote: David Fetter wrote: On Mon, Aug 03, 2009 at 12:19:40PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Mon, Aug 03, 2009 at 11:32:48AM -0400, Tom Lane wrote: And I doubt we'd bother generating pg_migrator

Re: [HACKERS] Alpha releases: How to tag

2009-08-07 Thread David Fetter
On Fri, Aug 07, 2009 at 05:32:13PM -0400, Alvaro Herrera wrote: David Fetter wrote: This is a pretty serious drawback. If we're going to require that people send migration scripts when they change the on-disk format, this needs to be easy. But, are we? This is an area where we have

Re: [HACKERS] Alpha releases: How to tag

2009-08-07 Thread David Fetter
that this change be immediate, and it's not ivory tower. It's just how everybody else does it. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider

Re: [HACKERS] hot standby - merged up to CVS HEAD

2009-08-10 Thread David Fetter
any change, is the way to keep it shared. Working off in splendid isolation, while it may appeal to you, is the wrong move. Guaranteed tears. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Hot standby?

2009-08-11 Thread David Fetter
creative in the naming. How about warm replica? Other ideas? Warm Read Streamed Copy Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating

[HACKERS] Collation

2009-08-11 Thread David Fetter
such an approach? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via

Re: [HACKERS] FDW-based dblink

2009-08-13 Thread David Fetter
. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing

Re: [HACKERS] [COMMITTERS] pgsql: Remove tabs from SGML.

2009-08-15 Thread David Fetter
use a CVS (later git) pre-commit hook to look for tabs and reject any commit in this directory or lower that has tabs in it. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] REGRESS_OPTS versus MSVC build scripts

2009-08-18 Thread David Fetter
list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember

Re: [HACKERS] Geometric bewilderment

2009-08-19 Thread David Fetter
On Wed, Aug 19, 2009 at 07:29:43PM +1000, Paul Matthews wrote: Suspect that attaching large amounts of code is a breach of etiquette. Code attachments aren't, but HTML messages are, so in future, please send only text :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] Feedback about Drupal SQL debugging

2009-08-21 Thread David Fetter
, David (grateful he's with a project that doesn't just gratuitously go around breaking stuff) -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating

Re: [HACKERS] WIP: generalized index constraints

2009-08-22 Thread David Fetter
the unique constraint) would be unfriendly. Unless the SQL spec demands that we do so? SQL:2008, like its predecessors, does not mention indexing at all. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Slaying the HYPOTamus

2009-08-24 Thread David Fetter
are a teensy bit baroque. Is there some significant speed increase that would justify them? if (x == 0.0) return 0.0; else { yx = y/x; return x*sqrt(1.0+yx*yx); } } Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

[HACKERS] Bug in date arithmetic

2009-08-24 Thread David Fetter
: date/time field value out of range: 90 HINT: Perhaps you need a different datestyle setting. I'd be tempted to call it a flat-out bug in the first case. Adding a string literal to a timestamptz should just result in an error, IMHO. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Slaying the HYPOTamus

2009-08-24 Thread David Fetter
On Mon, Aug 24, 2009 at 12:47:42PM -0500, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: On Mon, Aug 24, 2009 at 11:14:19PM +1000, Paul Matthews wrote: These next two lines are a teensy bit baroque. Is there some significant speed increase that would justify them

Re: [HACKERS] Bug in date arithmetic

2009-08-24 Thread David Fetter
* this to do? You obviously weren't expecting the literal to be taken as interval, but its contents are not very sane for any other likely interpretation. The gentleman in IRC was the one who was using the construct. I spell out my date arithmetic. :) Cheers, David. -- David Fetter da

Re: [HACKERS] Bug in date arithmetic

2009-08-24 Thread David Fetter
On Mon, Aug 24, 2009 at 02:05:38PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Mon, Aug 24, 2009 at 01:18:46PM -0400, Tom Lane wrote: Just out of curiosity, what were you *expecting* this to do? The gentleman in IRC was the one who was using the construct. Well

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