[HACKERS] PostgreSQL / PHP Overrun Error

2001-09-26 Thread Mike Rogers
ghts? I can provide any further system information if needed. I have tried recompiling pgsql, php and apache with different optimizations [including none at all and debug mode on as i have now] with little change in the result. Thanks in advance; -- Mike cc: pgsql-hackers; p

Re: [HACKERS] [BUGS] PostgreSQL / PHP Overrun Error

2001-09-26 Thread Mike Rogers
Well it really isn't your code (true), but the only thing that is changed is the 7.0-7.1- Was a data length changed on the return or something that could affect this? -- Mike - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Mike Rogers"

Re: [HACKERS] [BUGS] PostgreSQL / PHP Overrun Error

2001-09-26 Thread Mike Rogers
Sorry: PHP 4.0.6 (with memory leak patch [download listed right below php-4.0.6.tar.gz download- It was a problem]) PostgreSQL 7.1.3 Apache 1.3.20 (with mod_ssl- but it does the same thing without mod_ssl) -- Mike - Original Message - From: "mlw" <[EMAIL PROTECTE

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

2001-10-09 Thread Mike Mascari
ailable connections. Like Jan's resource statistics collector, Oracle's profiles must be enabled in the initSID.ora configuration file since it takes a few cycles to actually account for user activity. Mike Mascari [EMAIL PROTECTED] > > Tom Lane writes: > > > > > I b

Re: [HACKERS] Setting Password

2001-10-10 Thread Mike Mascari
You need to change the pg_hba.conf file in your PostgreSQL installation so that "password" authentication is used. Check out: http://www.postgresql.org/idocs/index.php?client-authentication.html for details. Hope that helps, Mike Mascari [EMAIL PROTECTED] > Balaji Venkatesan w

Re: [HACKERS] Suggestion for optimization

2002-04-05 Thread Mike Mascari
es it inappropriate for data warehousing would imply that Oracle is also inappropriate. However, in your defense, Oracle did apparently find enough customer demand for a MVCC-compatible hack of COUNT() to implement a short-cut route to calculate its value... Mike Mascari [EMAIL PROTECTED] ---

[HACKERS] problem with timestamps ?

2000-12-05 Thread Mike Haberman
ng -0n gets appended. thanks mike

[HACKERS] Re: MySQL conversion utility

2000-12-20 Thread Mike Sears
where and is this already availiable? Mike > I've committed to contrib/mysql/ a utility called mysql2pgsql to help > with database conversions from MySQL. It requires perl5 and not much > else besides a MySQL schema dump file. > > Thanks to Tim Perdue for

[HACKERS] Interesting CERT advisory

2001-01-10 Thread Mike Mascari
FYI, CERT Advisory CA-2001-01 Interbase Server Contains Compiled-in Back Door Account Original release date: January 10, 2001 Last revised: -- Source: CERT/CC A complete revision history is at the end of this file. Systems Affected * Borland/Inprise Interbase 4.x and 5.x

RE: [HACKERS] MS Access vs IS NULL (was Re: [BUGS] Bug in SQL functions that use a NULL parameter directly)

2001-01-14 Thread Mike Mascari
I don't have Office 2000, but I can confirm Access 97 generates such queries. The query-builder doesn't generate the 'key = NULL' query, but the use of the Forms interface does. Mike Mascari [EMAIL PROTECTED] -Original Message- From: Tom Lane [SMTP:[EMAIL PROTEC

[GENERAL] Re: Re: INIT DB FAILURE

2001-01-16 Thread Mike Miller
GNU sed version 3.02.80 >From: Tom Lane <[EMAIL PROTECTED]> >To: "Mike Miller" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED], [EMAIL PROTECTED] >Subject: Re: Re: INIT DB FAILURE >Date: Tue, 16 Jan 2001 16:21:31 -0500 > >"Mike Miller" <[EMAIL

[GENERAL] Re: Re: grant privileges to a database [URGENT]

2001-01-31 Thread Mike Miller
. Maybe only allowed to acess DBs you create or are assigned permission to -- Mike >From: "Martin A. Marques" <[EMAIL PROTECTED]> >To: Michael Fork <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED], [EMAIL PROTECTED] >Subject: Re: Re: grant privileges to a databas

[GENERAL] Re: [HACKERS] Re: Re: grant privileges to a database [URGENT]

2001-02-05 Thread Mike Miller
user is the database owner [or if they have the superuser ID set]? Am I not seeing the big picture? -- Mike >From: Kovacs Baldvin <[EMAIL PROTECTED]> >To: Mike Miller <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED], [EMAIL PROTECTED], >[EMAIL PROTECTED],[EMAIL PROTE

[HACKERS] MATCH PARTIAL

2001-02-16 Thread Mike Mascari
MATCH PARTIAL isn't in 7.1. Is it? Mike Mascari [EMAIL PROTECTED]

RE: [HACKERS] mailing list messages

2001-03-06 Thread Mike Mascari
I like this idea too. How about TIP #1: Don't 'kill -9' the postmaster ;-) Mike Mascari [EMAIL PROTECTED] -Original Message- From: The Hermit Hacker [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 1:57 PM To: Andrew McMillan Cc: PostgreSQL-deve

RE: [HACKERS] Performance monitor

2001-03-07 Thread Mike Mascari
. FWIW, Mike Mascari [EMAIL PROTECTED] -Original Message- From: Philip Warner [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 7:42 PM To: Justin Clift Cc: Bruce Momjian; Tom Lane; The Hermit Hacker; PostgreSQL-development Subject:Re: [HACKERS] Performance monitor

RE: [HACKERS] Performance monitor

2001-03-13 Thread Mike Mascari
stmaster option which would enable/disable the use of accumulating performance statistics in shared memory might ease the hesitation against it? Mike Mascari [EMAIL PROTECTED] -Original Message- From: Denis Perchine [SMTP:[EMAIL PROTECTED]] That's bad. Cause it will be unusef

RE: [HACKERS] 7.1 pg_dump fails for user-defined types (release stopper?)

2001-03-30 Thread Mike Mascari
. Its hard to come up with examples where an object dependent upon another in a *working* database has a lesser OID. So the regression suite really did its job in this case. Mike Mascari [EMAIL PROTECTED] -Original Message- From: Darren King [SMTP:[EMAIL PROTECTED]] Sent: Friday,

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Mike Aubury
On Wednesday 19 February 2003 8:18 pm, Dave Cramer wrote: > I have a customer with a rather large application which uses this > syntax, because they were using informix. There is also a rather > interesting 4GL project called aubit which is on sourceforge. They would > also like to see this support

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-20 Thread Mike Aubury
Informix supports 2 different styles for the update - your one would have to be written : UPDATE djp SET(col1, col2) = ((SELECT col1,col2 FROM some_other_table)) Notice the double brackets ! The first signifies a list of values - the second is the brackets around the subquery... (NB If you tr

Re: [HACKERS] SQL parser error

2003-03-07 Thread Mike Aubury
Isn't there a space missing in there ? limit10 - limit 10 All you've done is alias the tablename On Friday 07 March 2003 11:25 am, Teodor Sigaev wrote: > Query > select * from TABLE limit10; > returns all rows, but it seems to me this is a syntax error... > > pgsql 7.3.2 and current CVS has

Re: [HACKERS] Roadmap for FE/BE protocol redesign

2003-03-12 Thread Mike Mascari
etc. A far-reaching, wild suggestion would be to replace the postmaster with a CORBA-based server process with a well defined interface. At a minimum, if a binary protocol is the ultimate destination, perhaps some of the mapping of various types could be borrowed from the specs. Mike

[HACKERS] Threaded Python vs. PostGreSQL plpython

2003-03-23 Thread Mike Meyer
Ok, I was a good boy and tried -interfaces first. No answer. I'm trying to get a functioning version of plpython on FreeBSD, while using python from the ports system. The problem is that the ports system build python with thread support. postmaster doesn't have thread support, so when the libpyth

Re: [HACKERS] Threaded Python vs. PostGreSQL plpython

2003-03-25 Thread Mike Meyer
In <[EMAIL PROTECTED]>, Shridhar Daithankar <[EMAIL PROTECTED]> typed: > On 24 Mar 2003 at 11:45, Mike Meyer wrote: Just to clarify, the current situation is that I have things working, but I also have a libpython.so that isn't threaded. I'm not happy about the latter, a

Re: [HACKERS] Broken RR?

2003-06-06 Thread Mike Mascari
RIALIZABLE Whoops. Sorry. I though this was confusion regarding phantom rowsand READ COMMITTED vs. SERIALIZABLE. Nevertheless, I cannot repeat the above... Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Use

Re: [HACKERS] Broken RR?

2003-06-06 Thread Mike Mascari
r to a question and it is likely that only a developer will know the answer, you may re-post that question here. You must try elsewhere first!" HTH, Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Use

[HACKERS] A few notes

2003-05-31 Thread Mike Mascari
ook 5 minutes. I then disabled GEQO and the queries ran in around a second. I noticed that the explicit join syntax will no longer confine planning choices in 7.4, but is it possible the GEQO threshold, as a default, is too low? Mike Mascari [EMAIL PROTECTED] ---(end of broa

Re: [HACKERS] ss_family in hba.c

2003-06-17 Thread Mike Aubury
My system has the same problem - struct sockaddr_storage is defined in /usr/include/bits/socket.h : struct sockaddr_storage { __SOCKADDR_COMMON (__ss_); /* Address family, etc. */ __ss_aligntype __ss_align; /* Force desired alignment. */ char __ss_padding[_SS_PADSIZE]; }; Whe

[HACKERS] a problem with index and user define type

2003-06-21 Thread Wang Mike
Hi all: I write a use define type (UUID) typedef struct uuid { uint32 time_low; uint16 time_mid; uint16 time_hi_and_version; uint8 clock_seq_hi_and_reserved; uint8 clock_seq_low; uint8 node[6]; } uuid; make all btree index function and operator, suc

Re: [HACKERS] Two weeks to feature freeze

2003-06-21 Thread Mike Mascari
lack of an enthusiastic response by any of the core members. Distributed query (not replication) would have been a very nice feature. It's what separates, in part, Oracle Enterprise Edition from the Standard Edition, and it appeared someone (Satoshi Nagayasu) was more than willing to get the ball

Re: [HACKERS] Two weeks to feature freeze

2003-06-22 Thread Mike Mascari
The Hermit Hacker wrote: > On Sun, 22 Jun 2003, Bruce Momjian wrote: > >>Mike Mascari wrote: >> >>>I was disappointed that Satoshi Nagayasu's two-phase commit >>>patches seemed to be implicitly rejected by lack of an >>>enthusiastic response by

Re: [HACKERS] Two weeks to feature freeze

2003-06-22 Thread Mike Mascari
ort will block waiting for the coordinator. We're not talking asynchronous multi-master replication of 4 databases distributed over low-speed communication lines across the country. We're talking about the sales dept. database having a few linked tables to the accounting dept. database, where i

Re: [HACKERS] Two weeks to feature freeze

2003-06-22 Thread Mike Mascari
itting the database changes associated with the > COMMIT-VOTE response it supplied to the coordinator's PREPARE. It > seems this would require REDO? And yet there are thousands of > installed distributed databases running enterprises every day. Please ignore the REDO remark. It&

Re: [HACKERS] Two Phase Commit WAS: Re: Two weeks to feature freeze

2003-06-23 Thread Mike Mascari
6 months ago, that the 2PC work being done by Satoshi Nagayasu was going to be allowed to die on the vine. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] clock_timestamp() and transcation_timestamp() patch

2003-07-15 Thread Wang Mike
.h --- ../postgresql-snapshot/src/include/utils/timestamp.h 2003-05-13 07:08:52.0 +0800 +++ ../pgsql/src/include/utils/timestamp.h 2003-07-15 20:44:35.0 +0800 @@ -233,20 +233,24 @@ extern Datum now(PG_FUNCTION_ARGS); -/* Internal routines (not fmgr-callable) */ +/* Add by Xi

[HACKERS] CREATE TYPE

2003-07-18 Thread Mike Aubury
Can someone point me at some detailed instructions for creating new datatypes.. I've found quite a few web pages that mention it (in passing) and give brief examples - but nothing much I can actually work with for my purposes.. Ideally I'd like to use C as the language and the datatype will nee

Re: [HACKERS] CREATE TYPE

2003-07-18 Thread Mike Aubury
OK - i've got the basic input/output working now - but how to I do the extent bit ? eg. allow : create table ( something a4gl_datime(15) ) On Friday 18 July 2003 6:53 pm, [EMAIL PROTECTED] wrote: > Programmers Guide , Chap 10 > http://www.postgresql.org/docs/7.3/static/xtypes.html > > c

Re: [HACKERS] how do i turn off the html tags??

2003-07-23 Thread Mike Mascari
Jenny - wrote: http://www.expita.com/nomime.html Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] this is in plain text (row level locks)

2003-07-23 Thread Mike Mascari
his is actually an issue though. Row-level shared locks would be > really nice to have for foreign-key handling. Right now we have to > use X locks for those, and that leads to deadlocking problems for > applications. Yes! Yes! It's the last big hurdle for an otherwise excellent RI imple

Re: [HACKERS] Farewell

2003-08-11 Thread Mike Mascari
is can be directly > atttributed to your work. Thank you. And thank you for the personal help > back when I was working on the PostgreSQL trigger documentation. It's hard to imagine PostgreSQL with out MVCC, WAL, subselects, etc. You know, maybe on the Developer's page there should

Re: [HACKERS] Adjustment of spinlock sleep delays

2003-08-14 Thread Mike Mascari
we still time out after a minute's total delay. > > Comments? Should there be any correlation between the manner by which the backoff occurs and the number of active backends? Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] Single-file DBs WAS: Need concrete "Why Postgres

2003-08-22 Thread Mike Mascari
, etc. Just because Oracle and MS do something doesn't necessary make it wrong. :-) Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] 2-phase commit

2003-09-09 Thread Mike Mascari
consistent." So it seems, for Oracle 8 at least, PITR is the method of recovery for cohorts after unrecoverable coordinator failure. Ugly and yet probably a prerequisite. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

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

2006-11-18 Thread Mike Rylander
ll.org/~hjort CELEPAR - Cia 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 chec

[HACKERS] Typo in pg_dump documentation and new suggestion for Release Notes

2006-12-18 Thread Mike G
In the online documentation for 8.2, pg_dump page, --table=table section, in the second "Note:" paragraph, "rather than the old locution of -n sch -t tab" probably should be "rather than the old location of -n sch -t tab" Also maybe this section on pg_dump in the release notes page for 8.2 shou

Re: [HACKERS] "May", "can", "might"

2007-01-30 Thread Mike Rylander
tp://www.enterprisedb.com ---(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

[HACKERS] xml2 contrib patch supporting default XML namespaces

2007-03-05 Thread Mike Rylander
t. Please let me know 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)

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

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 t

Re: [HACKERS] CLUSTER and MVCC

2007-03-09 Thread Mike Rylander
s, Florian Pflug ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://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

[HACKERS] Install on Windows XP

2006-09-28 Thread Mike Bassett
d. I then tried ./configure –prefix=c:/mingw/local –with-includes=c:/mingw/local/include –with-libs=c:/mingw/local/lib make && make install but it had an issue with make. Mike Bassett ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[HACKERS] Did this issue ever get resolved?

2005-04-06 Thread Mike G.
under the data directory (I have found a folder 17269 that contains similiar names to 1677179) then it would seem postgres is trying to write data to a file that does not exist. Mike ---(end of broadcast)--- TIP 6: Have you searched ou

Re: [HACKERS] [COMMITTERS] pgsql: Install some slightly realistic cost estimation

2005-04-21 Thread Mike Rylander
the new code did to your test query...), or a seq scan. > Things will get more interesting once we can AND the results of > unrelated indexes ... I can't wait! How close to initial testing is the AND stuff for unrelated indexes? Could this bitmapping code be used to combine indexes

Re: [HACKERS] [COMMITTERS] pgsql: Install some slightly realistic cost estimation

2005-04-21 Thread Mike Rylander
BALLY UNIQUE (unique_column); That could use a bitmapped OR scan of indexes on "unique_column" on the base table and all descendant tables to check for a unique value across a "partitioned table". Hmmm... thinking more, I suppose it could just to a quick scan of

Re: [HACKERS] pl/pgsql enabled by default

2005-05-07 Thread Mike Mascari
gm, cannot allow users to create functions with side effects. Mike Mascari ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] pl/pgsql enabled by default

2005-05-07 Thread Mike Mascari
Neil Conway wrote: Mike Mascari wrote: People who use views to achieve row security, which is a rather common paradigm, cannot allow users to create functions with side effects. Can you elaborate? I'm not sure I follow you. (I'll note anyway that (1) SQL functions can have side effec

Re: [HACKERS] pl/pgsql enabled by default

2005-05-07 Thread Mike Mascari
Andrew Dunstan wrote: Mike Mascari wrote: but the side effect function will only run (unless you set it with security definer) with the privileges of the caller - it won't grant visibility to things that user can't otherwise see. If the visibility is determined by view definition

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

2005-05-16 Thread Mike Rylander
query for tenk2 from above? I'd be very interested to see if the bitmap forced TID order fetch actually does help, or if it's outweighed by the bitmap setup overhead. TIA -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org --

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

2005-06-24 Thread Mike Rylander
t/smallest of the non-null inputs)? > [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

Re: [HACKERS] Must be owner to truncate?

2005-07-09 Thread Mike Mascari
aborts after step 3, but newer transactions commit? Mike Mascari ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Returning number of rows - Copy In function

2004-03-25 Thread mike g
Hello, I was looking at putting the code for this in copy.c CopyReadLineFunction. If I do a printf at point A it compiles, installs, runs, doesn't display any data after running initdb and returns a result when a COPY FROM is executed in psql. If I do a printf at point B it compiles, installs, a

Re: [HACKERS] Fuzzy cost comparison to eliminate redundant planning

2004-03-28 Thread Mike Mascari
rom eleven to twelve. With your new fuzzy comparison patch is twelve still the appropriate number? Or does the fuzzy comparison scale all planning time down and therefore the default threshold should remain where it is? Mike Mascari ---(end of broadcast)-

Re: [HACKERS] Function to kill backend

2004-04-03 Thread Mike Mascari
way queries on Oracle is only a necessity if the DBA hasn't made use of resource limits - PROFILEs. ;-) Mike Mascari ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] Duplicate variable declared?

2004-04-20 Thread mike g
s checkins or copy/paste mistakes. I will continue to scan the output. Hope this helps. Mike On Tue, 2004-04-20 at 22:51, Matthew T. O'Connor wrote: > Tom Lane wrote: > > >"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes: > > > > > >

Re: [HACKERS] Duplicate variable declared?

2004-04-22 Thread mike g
Joe Conway wrote: mike g wrote: In file postgresql-7.4.2/src/backend/utils/fmgrtab.c This is an automatically generated file. The reason for duplicate array_push declarations is that one-and-the-same array_push function is used to implement two SQL functions, array_append and

Re: [HACKERS] SPI and bytea columns

2004-05-11 Thread Mike Mascari
nctions to read the image file from disk? PostgreSQL really needs a maintained type library as a single project where people can contribute types, functions, operators, and aggregates, such as the recently discussed email type. Mike Mascari Just be sure not to actually compress/decompress t

Re: [HACKERS] The features I'm waiting for.

2004-05-04 Thread Mike Mascari
ped 20% of the bits in the postgres binary you'd not find it to be more buggy than the Postgres95/early 6.x series... Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] I need Help

2004-05-03 Thread mike g
Yes it is possible for both to be on the same pc. Please send mail to the general or novice list if you need more help. On Mon, 2004-05-03 at 11:05, olivia jurado wrote: > Hi. > > I'm from Panama. > > I don't speak english very well but I'm learning > english. > > I Need help. > > I installe

Re: [HACKERS] PITR Phase 2 - Design Planning

2004-04-29 Thread Mike Mascari
ciated with the comment. Example: COMMIT WORK COMMENT 'A complex distributed Tx'; Perhaps there is some common ground between the 2PC implementation and PITR? Mike Mascari ---(end of broadcast)--- TIP 2: you can get off all lists at once wi

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

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Mike Mascari
it does become data. Has the advocacy group performed any polling in this area that might shed some light as to what users and potential users might want? Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensiv

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Mike Mascari
eased to not hold up important features like the IN optimization and a quick 7.5 would have Win32 and PITR. It's almost as if a cron job reposts this thread every 6 - 12 months. For those of us that are desirous of PITR, it's a 6 month reposting that is becoming p

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Mike Mascari
Marc G. Fournier wrote: On Mon, 17 May 2004, Mike Mascari wrote: A quick google of "7.4 Win32 release" will reveal that the above was precisely what was said about 7.4: it would be released to not hold up important features like the IN optimization and a quick 7.5 would have Win32 and

[HACKERS] Call for 7.5 feature completion

2004-05-17 Thread mike g
not a cygwin programmer but making sure changes to the cygwin dll are compatible with windows and all the individual packages it also supports can't be very easy. I will continue to patiently wait for windows version. Even if it means 8.0. If only I was skilled enough to help out...

Re: [HACKERS] Win32, PITR, nested transactions, tablespaces

2004-05-28 Thread Mike Mascari
nerability: http://www.us-cert.gov/cas/techalerts/TA04-147A.html For what it's worth, Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Official Freeze Date for 7.5: July 1st, 2004

2004-06-01 Thread Mike Benoit
l somewhere ... > > In any case, I think a target date should be set at the beginning of a > dev cycle and a hard date should be set closer to the end of the cycle. > Trying to adhere rigidly to a date set nine or twelve months previously > doesn't strike me as good p

[HACKERS] upper() / lower() regression test case needed?

2004-06-03 Thread mike g
these test cases to strings.sql? Mike ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] I just got it: PostgreSQL Application Server -- a new

2004-06-12 Thread Mike Mascari
ly. I think it's Bill Gates leading a secret life... Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] placeholder syntax

2004-06-21 Thread Mike Mascari
L Later versions of one of the Access components (jet, mdac, access.exe - who knows where) changed its behavior and never performed similarly... Mike Mascari ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] warning missing

2004-06-25 Thread Mike Mascari
Inheritance: No I think it'd be a fair statement that Date & Darwen would have the relvar inheritance ripped out of PostgreSQL as an experiment gone bad... Mike Mascari P.S.: D is the language of the future: http://www.digitalmars.com/d Ha! ---(end of

[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] Nested Transactions, Abort All

2004-07-01 Thread Mike Benoit
sub-transaction aren't we? To me that sounds just as bad. "ABORT ALL" sure would be nice. -- Mike Benoit <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Nested Transactions, Abort All

2004-07-02 Thread Mike Mascari
WORK ] [ AND[ NO ] CHAIN ] [ ] ::= TO SAVEPOINT Mike Mascari ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get th

Re: [HACKERS] LinuxTag wrapup

2004-07-03 Thread Mike Mascari
he possibility as a solution in the enterprise if they think they'll look like a fool pronouncing the name aloud. I remember back in '94 being "corrected" when talking about Linux in the enterprise - and I was corrected in the wrong direction. Someone needs to poke the propaga

Re: [HACKERS] Recovery Features

2004-07-05 Thread Mike Mascari
IMHO, Mike Mascari ---(end of broadcast)--- TIP 3: 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

Re: [HACKERS] Recovery Features

2004-07-05 Thread Mike Mascari
Simon Riggs wrote: On Mon, 2004-07-05 at 23:40, Mike Mascari wrote: hmmm...not sure I know what you mean. It is very-very-close-to-impossible to edit the transaction logs manually, unless some form of special-format editor were written for the purpose. Is it clear that the PITR features are

Re: [HACKERS] Quick question regarding tablespaces

2004-07-08 Thread Mike Rylander
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 on of putting rand_page_cost in pg_tablespace and > having the planner have access

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, > > > >

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

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] Anoncvs down?

2004-07-12 Thread Mike Mascari
&ie=UTF-8&selm=40B74B73.6080702%40mascari.com Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] plperl (7.5)

2004-07-13 Thread Mike Rylander
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 an

Re: [HACKERS] Nested Transactions, Abort All

2004-07-13 Thread Mike Rylander
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 ne

Re: [HACKERS] Nested Transactions, Abort All

2004-07-13 Thread Mike Rylander
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 th

Re: Release planning (was: Re: [HACKERS] Status report)

2004-07-13 Thread Mike Benoit
. Then the "big installations" can see that a major feature has been in two stable releases (even if the time period was only a year) and feel much more comfortable in upgrading. Why would they have to upgrade more often then necessary anyways? Assuming security exploits are back ported of

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

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

Re: [HACKERS] ffunc called multiple for same value

2004-07-23 Thread Mike Mascari
aggregate functions, I agree with your analysis, so long as the fact that an ffunc may be invoked more than once is well documented, (i.e. an SGML section might be nice.) Mike Mascari ---(end of broadcast)--- TIP 7: don't forget to inc

Re: [HACKERS] Preliminary PITR documentation available

2004-08-03 Thread Mike Mascari
ates some complexities that are akin to science-fiction stories about time travel and parallel universes." Is it science-fiction, or just relativity? Mike Mascari ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unr

Re: [HACKERS] Tom in Doom3?

2004-08-05 Thread Mike Mascari
which determined the major contributors to open source software and it read something like: 1. UC Berkeley 2. MIT 3. Tom Lane 4. Carnegie Mellon 5. IBM I wish I had the link... Mike Mascari ---(end of broadcast)--- TIP 7: don't forget to increase

<    1   2   3   4   5   >