Re: [HACKERS] [PROPOSAL] Temporal query processing with range types

2017-10-06 Thread Mike Rylander
On Fri, Oct 6, 2017 at 1:22 PM, Paul A Jungwirth wrote: > On Fri, Jul 22, 2016 at 4:15 AM, Anton Dignös wrote: >> We would like to contribute to PostgreSQL a solution that supports the query >> processing of "at each time point". The basic

Re: [HACKERS] Fuzzy substring searching with the pg_trgm extension

2016-02-11 Thread Mike Rylander
_string_similarity? > At least for this English speaker, substring_similarity is not confusing even if it's not internally accurate, but English is a strange language. Because I want the bike shed to be blue, how does query_string_similarity sound instead? If that's overly precise, then word_simila

Re: [HACKERS] old bug in full text parser

2016-02-10 Thread Mike Rylander
this by pre-normalizing strings matching /(\d+)-(\d+)/ into two numbers separated by a space instead of a hyphen, but if fixing this bug would remove the need for such a preprocessing step it would be a great help to us. Would such strings be parsed "properly" into lexems of the form o

Re: [HACKERS] xpath changes in the recent back branches

2015-03-04 Thread Mike Rylander
On Thu, Feb 19, 2015 at 5:53 AM, Marko Tiikkaja ma...@joh.to wrote: Hi, Commit 79af9a1d2668c9edc8171f03c39e7fed571eeb98 changed xpath handling with regard to namespaces, and it seems to be fixing an actual issue. However, it was also backpatched to all branches despite it breaking for

Re: [HACKERS] standby registration (was: is sync rep stalled?)

2010-10-04 Thread Mike Rylander
standbys to be named in this fashion.   This role could be provided on connect of the standby is more-or-less tangential to the specific registration issue. Big +1 FWIW. -- Mike Rylander -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Issue: Deprecation of the XML2 module 'xml_is_well_formed' function

2010-06-28 Thread Mike Rylander
FUNCTION my_xml_is_valid ( x TEXT ) RETURNS BOOL AS $$ BEGIN PERFORM XMLPARSE( DOCUMENT x::XML ); RETURN TRUE; EXCEPTION WHEN OTHERS THEN RETURN FALSE; END; $$ LANGUAGE PLPGSQL; -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN

Re: [HACKERS] JSON manipulation functions

2010-05-14 Thread Mike Rylander
be extremely useful to me when creating or persisting raw class instances of these sorts. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com -- Sent via

Re: [HACKERS] max_standby_delay considered harmful

2010-05-10 Thread Mike Rylander
*conflict*, and it's less surprising that the standby can fall indefinitely behind in the worst case. If we name the setting along those lines, I could live with that. +1 from the peanut gallery. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone

Re: [HACKERS] Proposal: Add JSON support

2010-04-03 Thread Mike Rylander
is what more people would expect, I'd think. +1 -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Proposal: Add JSON support

2010-03-28 Thread Mike Rylander
and fast code I could share, if it's needed, though I suspect it's not. :) UPDATE: Thanks, Robert, for pointing to the RFC. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web

Re: [HACKERS] Proposal: Add JSON support

2010-03-28 Thread Mike Rylander
On Sun, Mar 28, 2010 at 8:33 PM, Robert Haas robertmh...@gmail.com wrote: On Sun, Mar 28, 2010 at 8:23 PM, Mike Rylander mrylan...@gmail.com wrote: In practice, every parser/serializer I've used (including the one I helped write) allows (and, often, forces) any non-ASCII character

Re: [HACKERS] Probably badly timed suggestion: pl/perl calling style same as C style

2010-02-24 Thread Mike Rylander
    AS 'DIRECTORY/funcs', 'add_one'     LANGUAGE C STRICT; CREATE FUNCTION add_one(integer) RETURNS integer     AS 'My::Package', 'add_one'     LANGUAGE plperl STRICT; +1, fwiw -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS

Re: [HACKERS] remove contrib/xml2

2010-01-28 Thread Mike Rylander
functions I use, they are lightly edited to remove the use of wrappers I've created to paper over the transition from xpath_nodeset() to core XPATH(). -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi

Re: [HACKERS] xpath not a good replacement for xpath_string

2009-07-28 Thread Mike Rylander
] as uuid from table; Not as clean, but it produces the same result as xpath_string(). Combined with array_to_string() could can collapse the array instead of just grabbing the first element (in cases other than uuid, of course). -- Mike Rylander | VP, Research and Design | Equinox Software, Inc

Re: [HACKERS] xpath not a good replacement for xpath_string

2009-07-28 Thread Mike Rylander
be easier to use for those not familiar with more advanced XPath, but it also has non-standard default actions. That being said, I'd love to see wrapper functions that provide the older api but leverage the core code. --miker -- Mike Rylander | VP, Research and Design | Equinox Software, Inc

Fwd: [HACKERS] tsvector extraction patch

2009-07-08 Thread Mike Rylander
Sorry, forgot to reply-all. -- Forwarded message -- From: Mike Rylander mrylan...@gmail.com Date: Wed, Jul 8, 2009 at 4:17 PM Subject: Re: [HACKERS] tsvector extraction patch To: Alvaro Herrera alvhe...@commandprompt.com On Wed, Jul 8, 2009 at 3:38 PM, Alvaro Herreraalvhe

Re: [HACKERS] tsvector extraction patch

2009-07-06 Thread Mike Rylander
sure   |    4 (4 rows) This looks very useful! I wonder if providing a weight column would be relatively simple? I think this would present problems with the cast-to-text[] idea that Peter suggests, though. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen

Re: [HACKERS] sun blade 1000 donation

2009-05-27 Thread Mike Rylander
; it would be interesting old HW / old Solaris for us. Would you like an IPC instead? Though building PG on it might take longer than the average release cycle. ;) -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-31 Thread Mike Rylander
rotate a logfile every minute this still transfers 16*60*24 = ~23 GB a day. I archived 1965 logs yesterday on one instance of my app totalling 8.5GB ... not to bad, really. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673

Re: [HACKERS] Spoofing as the postmaster

2007-12-22 Thread Mike Rylander
On Dec 22, 2007 1:04 PM, Tom Lane [EMAIL PROTECTED] wrote: Peter Eisentraut [EMAIL PROTECTED] writes: Wouldn't SSL work over Unix-domain sockets as well? The API only deals with file descriptors. Hmm ... we've always thought of SSL as being primarily comm security and thus useless on a

Re: [HACKERS] tsearch2 in PostgreSQL 8.3?

2007-08-17 Thread Mike Rylander
On 8/18/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Aug 17, 2007 at 04:06:15PM -0700, Josh Berkus wrote: Bruce, Oh, so you want the config inside each tsvector value. Interesting idea. Yeah, hasn't anyone suggested this

Re: [HACKERS] Another idea for index-only scans

2007-08-15 Thread Mike Rylander
On 8/15/07, Bruce Momjian [EMAIL PROTECTED] wrote: I have added another idea for index-only scans to the TODO list: A third idea would be for a heap scan to check if all rows are visible and if so set a per-table flag which can be checked by index scans. Any change to the table would

Re: [HACKERS] default_text_search_config and expression indexes

2007-08-14 Thread Mike Rylander
On 8/13/07, Bruce Momjian [EMAIL PROTECTED] wrote: Heikki Linnakangas wrote: Bruce Momjian wrote: Heikki Linnakangas wrote: Removing the default configuration setting altogether removes the 2nd problem, but that's not good from a usability point of view. And it doesn't solve the

Re: [HACKERS] default_text_search_config and expression indexes

2007-08-14 Thread Mike Rylander
On 8/14/07, Heikki Linnakangas [EMAIL PROTECTED] wrote: Mike Rylander wrote: [snip] Don't you need to use the right configuration to parse the query into a tsquery as well? Only if the user (or user agent) can supply enough information to move away from the configured default of, say, en-US

Re: [HACKERS] tsearch2 in PostgreSQL 8.3?

2007-08-14 Thread Mike Rylander
On 8/14/07, Alvaro Herrera [EMAIL PROTECTED] wrote: Bruce Momjian wrote: Basically, the default GUC doesn't work because of: error prone if super-user only, non-super-user doesn't work on restore if non-super-user, can cause mismatch (perhaps this is the best

Re: [HACKERS] default_text_search_config and expression indexes

2007-08-14 Thread Mike Rylander
On 8/14/07, Alvaro Herrera [EMAIL PROTECTED] wrote: Oleg Bartunov wrote: On Tue, 14 Aug 2007, Alvaro Herrera wrote: Oleg Bartunov wrote: On Thu, 9 Aug 2007, [EMAIL PROTECTED] wrote: Maybe I'm missing something, but it seems to me that the configuration is more attached to a

Re: [HACKERS] default_text_search_config and expression indexes

2007-08-14 Thread Mike Rylander
On 8/14/07, Gregory Stark [EMAIL PROTECTED] wrote: Mike Rylander [EMAIL PROTECTED] writes: My application (http://open-ils.org, which run 80% of the public libraries in Georgia, USA, http://gapines.org and http://georgialibraries.org/lib/pines.html) requires that I be able to search

Re: [Fwd: Re: [HACKERS] tsearch in core patch]

2007-06-25 Thread Mike Rylander
for listening (and for all the great work on getting tsearch into core! :) ... -- Mike Rylander ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [Fwd: Re: [HACKERS] tsearch in core patch]

2007-06-25 Thread Mike Rylander
On 6/25/07, Tom Lane [EMAIL PROTECTED] wrote: Mike Rylander [EMAIL PROTECTED] writes: I can certainly understand the benefit of making the default configuration a simple locale to language map, but there are definitely uses for searching using different stemmers/stop-lists even within

Re: [HACKERS] [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-06-01 Thread Mike Rylander
On 6/1/07, Peter Eisentraut [EMAIL PROTECTED] wrote: Mike Rylander wrote: I understand that XML support is planned and at least partially implemented for 8.3, but many production instances will be unable (or, in fact, unwilling) to upgrade to 8.3 for quite some time. Because this patch

Re: [HACKERS] [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-03-22 Thread Mike Rylander
with, and no, I can't change that) will have exactly the same problems using the new mechanisms as with the current xml2 contrib module. I ask because, based on the design emails I've seen on -hackers, nothing surrounding explicit support for said issue jumped out at me. Thanks again. -- Mike Rylander

Re: [HACKERS] [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-03-18 Thread Mike Rylander
On 3/6/07, Mike Rylander [EMAIL PROTECTED] wrote: On 3/6/07, Peter Eisentraut [EMAIL PROTECTED] wrote: Mike Rylander wrote: The patch adds support for default XML namespaces in xml2 by providing a mechanism for supplying a prefix to a named namespace URI. How does it support multiple

Re: [HACKERS] CLUSTER and MVCC

2007-03-09 Thread Mike Rylander
://www.postgresql.org/docs/faq -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-03-06 Thread Mike Rylander
On 3/6/07, Peter Eisentraut [EMAIL PROTECTED] wrote: Mike Rylander wrote: The patch adds support for default XML namespaces in xml2 by providing a mechanism for supplying a prefix to a named namespace URI. How does it support multiple namespaces in one document? It supports one default

Re: [HACKERS] [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-03-06 Thread Mike Rylander
On 3/6/07, Nikolay Samokhvalov [EMAIL PROTECTED] wrote: On 3/6/07, Mike Rylander [EMAIL PROTECTED] wrote: Attatched you'll find a patch that I've been kicking around for a while that I'd like to propose for inclusion in 8.3. I attempted to submit this through the original xml2 author (as far

[HACKERS] xml2 contrib patch supporting default XML namespaces

2007-03-05 Thread Mike Rylander
if there is any more I can/need-to do to help this patch along! -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org xml2-namespaces.patch Description: Binary data ---(end of broadcast)--- TIP 1: if posting

Re: [HACKERS] May, can, might

2007-01-30 Thread Mike Rylander
---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Mike Rylander [EMAIL

Re: [HACKERS] Ontology on PostgreSQL - is there something?

2006-11-18 Thread Mike Rylander
de Informática do Paraná - Brasil http://www.pr.gov.br -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [HACKERS] Support Parallel Query Execution in Executor

2006-04-07 Thread Mike Rylander
. Thanks again, Qingqing, for the work on this. I'm very excited about where this could go. :) Regards, Qingqing ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org -- Mike

Re: [HACKERS] First Aggregate Funtion?

2006-03-31 Thread Mike Rylander
an aggreagate around it CREATE AGGREGATE public.last ( sfunc= public.last_agg, basetype = anyelement, stype= anyelement ); Hope that helps! -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end

Re: [HACKERS] Surrogate keys (Was: enums)

2006-01-20 Thread Mike Rylander
of representation of their DNA? Unless the person in question happens to be a chimera (yes, they do exist). ;-) -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 4: Have

Re: [HACKERS] Surrogate keys

2006-01-20 Thread Mike Rylander
it look like the dog did it. -- Unknown ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast

Re: [HACKERS] Why don't we allow DNS names in pg_hba.conf?

2006-01-02 Thread Mike Rylander
://www.postgresql.org/docs/faq -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [HACKERS] Reducing the overhead of NUMERIC data

2005-11-02 Thread Mike Rylander
of enquiry. Best Regards, Simon Riggs ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org

[HACKERS] platform test

2005-10-31 Thread Mike Rylander
-- == All 98 tests passed. == -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] LDAP Authentication?

2005-10-10 Thread Mike Rylander
PAM to Windows, and then everybody wins. Well, for one that's going to be a *lot* more work. I'm not even sure how many of the concepts would apply to win32, but then I don't really know PAM... Most of the work has already been done: http://pgina.xpasystems.com/ -- Mike Rylander [EMAIL

Re: [HACKERS] Found small issue with OUT params

2005-09-30 Thread Mike Rylander
functions look like RETURNS functions. If that were removed then we'd have what, at least by counting the responses on this thread, seems to be the desired (and expected) behaviour. Or I could just be misunderstanding the implementation again. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES

Re: [HACKERS] Found small issue with OUT params

2005-09-29 Thread Mike Rylander
, and the one column in such a rowtype certainly has a name of it's own. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

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

2005-06-24 Thread Mike Rylander
)? [snip] Please, if You think, so Oracle way is good, correct it. I'm still favoring non-strict but it deserves more than two votes. Anybody else have an opinion? regards, tom lane My $0.02: I'd prefer the non-strict version. -- Mike Rylander [EMAIL

Re: [HACKERS] bitmap scans, btree scans, and tid order

2005-05-16 Thread Mike Rylander
outweighed by the bitmap setup overhead. TIA -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] FunctionCallN improvement.

2005-02-01 Thread Mike Rylander
0m3.347s user0m3.343s sys 0m0.000s Hope the numbers help! -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] FunctionCallN improvement.

2005-02-01 Thread Mike Rylander
Sorry, forgot the compiler version. gcc (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6) On Wed, 2 Feb 2005 01:12:04 +, Mike Rylander [EMAIL PROTECTED] wrote: On Tue, 01 Feb 2005 16:23:56 -0500, Tom Lane [EMAIL PROTECTED] wrote: a_ogawa [EMAIL PROTECTED] writes: I

Re: [HACKERS] Implementing Bitmap Indexes

2005-01-29 Thread Mike Rylander
and completely sidestep the need for precalculated cross-column correlations. Am I getting that right? -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 6: Have you searched our

Re: [HACKERS] Implementing Bitmap Indexes

2005-01-29 Thread Mike Rylander
On Sun, 30 Jan 2005 11:07:59 +1100, Neil Conway [EMAIL PROTECTED] wrote: Mike Rylander wrote: For on-disk bitmap indexes, yes. I don't see any reason this couldn't be done with GiST It might be possible to do it with GiST, but GiST is designed for implementing tree-structured indexes; I

Re: [HACKERS] Implementing Bitmap Indexes

2005-01-29 Thread Mike Rylander
bitwise a OR on bitmaps 1 and 3, find the possition of the 1s, jump to those possitions in the ctid array, and bounce to the heap for the value. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread Mike Rylander
: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread Mike Rylander
On Mon, 6 Dec 2004 08:17:29 -0500 (EST), [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: On Mon, 6 Dec 2004, Mike Rylander wrote: Just so that you have some info, I've been using DBD::PgSPI with Pg 8.0 since beta 1. The only restriction I've run into with the old code is that it doesn't like

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-01 Thread Mike Rylander
. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED

Re: [HACKERS] patch: plpgsql - access records with rec.(expr)

2004-11-23 Thread Mike Rylander
. Please, CORE, include this one! As an alternative, what would be the possibility of creating a new PL as a contrib module, say PLPGSQL_NG, to move forward with extensions like this and perhaps EVALUATE? -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer On 23 Nov

Re: [HACKERS] Odd plpgsql behaviour

2004-11-15 Thread Mike Rylander
= 'INSERT' OR (TG_OP = 'UPDATE' AND NEW.name != OLD.name) IS TRUE) ... In this case, since OLD.name does not exist during INSERT it cannot be replaced. Perhaps someone else can shed a little more light on this. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer

Re: [HACKERS] APR 1.0 released

2004-10-08 Thread Mike Rylander
A while back I was looking the backend code in preparation to start beginning to look at parallelization techniques for PG ;)... My thought was instead of trying to parallelize each individual plan node (multi-process sort, etc.) I would look at creating worker threads/processes for each plan node

Re: [HACKERS] Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?)

2004-10-03 Thread Mike Rylander
Not that my 2c is worth 1c, but I second this. I'd rather initdb now than get bitten by some catalog difference when I move my DB into production. :) --miker On Sat, 02 Oct 2004 14:22:50 -0400, Tom Lane [EMAIL PROTECTED] wrote: [...] I'd prefer if all users of 8.0 were guaranteed to have

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-29 Thread Mike Rylander
Tom Lane wrote: Just so you know --- core has agreed that it's about time for beta2. If you've got any must fix issues, please get 'em in over the weekend. Will we be looking at a re-initdb with beta2? I didn't notice any changes that would force it, but just to be clear... regards, tom

[HACKERS] nntp server craziness

2004-08-06 Thread Mike Rylander
Seems the NNTP server went wonky again... TIA! -- Mike Rylander [EMAIL PROTECTED] Indentation is a wonderful form of commentary from programmer to programmer, but its symbology is largely wasted on the computer. We don't tell poets how to format their poetry. -- Larry Wall

Re: [HACKERS] Portals and nested transactions

2004-07-14 Thread Mike Rylander
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote: I've been thinking about what to do with cursors in subtransactions. So within this proposal, a query executed by normal means will get its resources saved in the transaction

Re: [HACKERS] Portals and nested transactions

2004-07-14 Thread Mike Rylander
Mike Rylander wrote: Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote: I've been thinking about what to do with cursors in subtransactions. So within this proposal, a query executed by normal means will get its resources

Re: [HACKERS] plperl (7.5)

2004-07-13 Thread Mike Rylander
posted mailed Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: On Sat, Jul 10, 2004 at 09:18:28PM -0700, elein wrote: The new plperl returns sets by having the function return an array. I think RETURN NEXT does the same thing anyway ... they just store tuples in a Tuplestore and

Re: [HACKERS] Nested Transactions, Abort All

2004-07-13 Thread Mike Rylander
posted mailed Dennis Bjorklund wrote: On Sat, 10 Jul 2004, Mike Rylander wrote: They do, if only to make particular constructs easier to write. This is an opinion, but for example an EXCEPTION framework for plpgsql would be easier to implement and use if it used the nested transactions

Re: [HACKERS] Nested Transactions, Abort All

2004-07-13 Thread Mike Rylander
posted mailed Dennsnippetssklund wrote: On Fri, 9 Jul 2004, Mike Rylander wrote: Nested transactions and savepoints serve two different purposes. They have some overlap, but for the most part solve two distinct problems. Then show some examples that illustrait the difference. So far

Re: [HACKERS] Nested Transactions, Abort All

2004-07-09 Thread Mike Rylander
Dennis Bjorklund wrote: On Fri, 9 Jul 2004, Bruce Momjian wrote: I think we agreed on BEGIN NESTED/COMMIT NESTED, and START NESTED TRANSACTION and COMMIT NESTED TRANSACTION. Should I read this as pg will get its own implementation of sub transactions and not implement the almost

Re: [HACKERS] Quick question regarding tablespaces

2004-07-08 Thread Mike Rylander
On Thursday 01 July 2004 09:26 pm, Scott Marlowe wrote: On Thu, 2004-07-01 at 18:54, Gavin Sherry wrote: On Thu, 1 Jul 2004, Mike Rylander wrote: On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote: Hi Mike, In this release, unfortunately not. That't too bad, but it's

Re: [HACKERS] Quick question regarding tablespaces

2004-07-08 Thread Mike Rylander
On Thursday 01 July 2004 08:54 pm, Gavin Sherry wrote: On Thu, 1 Jul 2004, Mike Rylander wrote: On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote: Hi Mike, In this release, unfortunately not. That't too bad, but it's not that urgent I suppose. I had some idea early

[HACKERS] Quick question regarding tablespaces

2004-07-01 Thread Mike Rylander
Now that PG will have tablespaces I can stick my really high I/O data on a fiberchannel array, and save some money by putting the rest of it (also the majority of it) on less expensive SCSI RAID sets. Will I also be able to tune individual tablespaces with the likes of random_page_cost? Sorry if

Re: [HACKERS] MERGE-esque Functionallity (was: Adding MERGE to the TODO list (resend with subject))

2004-05-14 Thread Mike Rylander
On Tuesday 11 May 2004 09:44 am, Bruce Momjian wrote: [snip] Bruce Momjian kirjutas E, 10.05.2004 kell 06:58: Added to TODO: * Add MERGE command that does UPDATE, or on failure, INSERT [snip] Hello all. I have been lurking here for a bit and the MERGE topic (on