[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

[HACKERS] FW: postgres shmat request fails on win98 (cygwin)

2004-08-08 Thread Mike G
Hello, I will bring it up with the postgresql hackers. PS - Sorry for the new posting. I read these via digest. Mike * From: Jason Tishler * To: cygwin at cygwin dot com * Date: Sun, 8 Aug 2004 11:07:56 -0400 * Subject: Re: Initdb FATAL error shmat - Win98 Cygwin

Re: [HACKERS] FW: postgres shmat request fails on win98 (cygwin)

2004-08-08 Thread mike g
r 14." I don't see any mention of XP, whether the Pro or Home version, will be supported in version 8 at the moment either. Mike On Sun, 2004-08-08 at 13:28, Doug McNaught wrote: > Mike G <[EMAIL PROTECTED]> writes: > > > Hello, > > > > I will bring it

Re: [HACKERS] monetary bug

2004-08-22 Thread Mike Mascari
Tom Lane wrote: Mahmoud Taghizadeh <[EMAIL PROTECTED]> writes: a dirty method to fix this bug is to replace following Are you aware that the monetary type is deprecated and is going to be dropped entirely pretty soon? What's taking so long? ;-) Mike Mascari ---

Re: [HACKERS] monetary bug

2004-08-23 Thread Mike Mascari
7;8.13 inches' And of course, the various types would be constrained appropriately. One couldn't have a negative LENGTH or a TEMPERATURE under absolute zero, as examples. I think it would be neat to have an external library supporting a large set of types like these.

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,

Re: [HACKERS] 2-phase commit

2003-09-26 Thread Mike Mascari
abase or a BEA Tuxedo TPM acting as the coordinator. So PostgreSQL won't have an opportunity to modify the protocol in any meaningful way if it wishes to interoperate with XA-based transaction managers. If it is being used only amongst other PostgreSQL backends for replication, then why

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-03 Thread Mike Mascari
inheritance, which of course, are in PostgreSQL. It's a very provocative read. At a minimum, one can learn what to avoid with SQL. The language looks neat on paper. Perhaps one day someone will provide an open source implementation. One could envision a "D" project along

Re: [HACKERS] Index/Function organized table layout

2003-10-05 Thread Mike Mascari
y), and how > one should treat them as such, especially for large data volumes. Too bad PostgreSQL is misspelled ("Postgress") and MySQL dominates the open source discussion. And the MySQL questions are coming from: "David Patterson, who holds the Pardee Chair of Computer Science

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Mike Sherrill
nQuer". I don't know the details, but I think Date's latest edition refers to it in a note. Halpin's working on Visio at Microsoft now, I think. -- Mike Sherrill Information Management Systems ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] 2-phase commit

2003-10-09 Thread Mike Mascari
PostgreSQL? 1) XA-compatibility/interoperability or 2) Robustness in the face of network failure The implementation choosen depends upon the answer, does it not? Is there an implementation (e.g. 3PC) that can simulate 2PC behavior for interoperability purposes and satisfy both requirem

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-14 Thread Mike Preece
[EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message news:<[EMAIL PROTECTED]>... > Bob Badour" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > > "Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > Thank you, Seun, for asking your question wit

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-15 Thread Mike Preece
"Bob Badour" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > "Mike Preece" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > [EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message > news:<[EMAIL PROTE

Re: [HACKERS] Some thoughts about i/o priorities and throttling vacuum

2003-10-17 Thread Mike Mascari
al traffic. er, yeah, that's the ticket. Except who ever > heard of having express lanes for local traffic. Hm. All I know is that Jan Wieck would have each car filled to the brim with spikes Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Mike Preece
"Bob Badour" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... [snip] > > Actually, Bob pointed out ... [snip] > Why don't you go and bang your heads together Bob. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, p

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Mike Mascari
; internals. > > Darren I've learned that a feed into the postgresql-hackers mailing list from comp.databases.postgresql.hackers can be easily spotted by its astonishing lack of civility and intelligent discourse... :-( Mike Mascari [EMAIL PROTECTED] ---(en

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-17 Thread Mike Mascari
viewed as window dressing... Could be wrong, though... 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] Is there going to be a port to Solaris 9 x86 in the

2003-11-18 Thread Mike Mascari
Robert Treat wrote: > http://www-inst.eecs.berkeley.edu/~cs186/hwk0/index.html > > Are these screenshots of PgAccess on Mac OSX? It's pretty sad that "Mike Stonebraker" only has a salary of $15,000. ;-) I also thought this SIGMOD article was a nice read: http://w

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-19 Thread Mike Mascari
of the disk, you will get 500 times more bandwidth—you can read or write the disk in a day. So programmers have to start thinking of the disk as a sequential device rather than a random access device." Isn't a TID-List-Fetch implementation a crucial first step in the right direction?

[HACKERS] Date bug in PG

2003-11-28 Thread Mike Macaskill
of whether or not this big can be fixed, and/or when it can be fixed it would be of great interest to us.   Thanks,   Mike Macaskill   Mike Macaskill NCC Computing Support Tel 9669 4265 Fax 9669 4760      

Re: [HACKERS] initdb should create a warning message [was Re: [ADMIN]

2003-12-01 Thread Mike Mascari
eads along >>>it. >> >>How about changing the names of those directories? > > > I thought about that, but what would we call them? We could change xlog > to wal, I guess. That might actually be clearer. xlog could become > xstatus or xactstatus or just x

Re: [HACKERS] IEEE 754

2003-12-29 Thread Mike Mascari
://www.ecommercetax.com/official_docs/SSTP%20-%20Rounding.pdf Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Preventing stack-overflow crashes (improving on max_expr_depth)

2003-12-30 Thread Mike Mascari
rsing? Mike Mascari [EMAIL PROTECTED] Tom Lane wrote: It occurred to me today that it would not be difficult to implement a direct check on the physical size of the execution stack. ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] CTTAS w/ DISTINCT ON crashes backend

2004-01-21 Thread Mike Mascari
problem is in adding OIDs to rows that initially did not have 'em when returned from the SELECT DISTINCT plan. Okay. So your best immediate workaround is to create the first temp table with oids, or create the second one without. Thanks! Mike Mascari --

Re: [HACKERS] returning PGresult as xml

2004-01-25 Thread Mike Mascari
last time this subject was dicussed, I believe it was Mike Mascari who proposed and implemented another solution which is more client-side oriented. I humbly confess it wasn't me. We use CORBA.... Mike Mascari ---(end of broadcast)---

Re: [HACKERS] lock related issues...

2004-01-28 Thread Mike Mascari
er installing PostgreSQL, a message should be output to read it: http://conferences.oreillynet.com/presentations/os2002/lane_tom.tar.gz Mike Mascari ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Summary of Changes since last release (7.4.1)

2004-02-10 Thread Mike Mascari
Simon Riggs wrote: - All operations on TEMP relations are no longer logged in WAL, nor are they involved in checkpoints, thus improving performance. (Tom) That is great news! Looking forward to 7.5 already, Mike Mascari ---(end of broadcast

Re: [HACKERS] Summary of Changes since last release (7.4.1)

2004-02-10 Thread Mike Mascari
pgsql-server/src/backend/storage/smgr/smgr.c?rev=1.58&content-type=text/x-cvsweb-markup Mike Mascari ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Summary of Changes since last release (7.4.1)

2004-02-10 Thread Mike Mascari
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/storage/smgr/smgr.c?rev=1.58&content-type=text/x-cvsweb-markup Actually, that was an Aug 6, 2002 commit, not 2003 which would make it 7.3, right? So Simon, my I humbly ask from where you culled this change in CVS tip? Mik

Re: [HACKERS] Summary of Changes since last release (7.4.1)

2004-02-11 Thread Mike Benoit
Simon, Excellent job, your summaries have saved me hours of reading the hackers mailing list. Keep up the good work! On Wed, 2004-02-11 at 00:21, Simon Riggs wrote: > >Mike Mascari > > Actually, that was an Aug 6, 2002 commit, not 2003 which would make > > it 7.3, rig

Re: [HACKERS] Is indexing broken for bigint columns?

2004-02-24 Thread Mike Mascari
x27;t assuming 32-bit quantities that will break once ~4.2 billion is reached and I get index scans without quoting or casting free. But IIRC there's a change in the development tree to jettison the requirement for quoting/casting... Mike Mascari ---(end of

Re: [HACKERS] Is indexing broken for bigint columns?

2004-02-24 Thread Mike Mascari
ql This is SQL*Server syntax: == ... select * from foo where bar = 1 ... This is Oracle syntax: == SQL> select * from foo where bar = 1; ... mysql> select * from foo where bar = 1; Mike Mascari -

Re: [HACKERS] COMMENT ON [GROUP/USER]

2004-03-08 Thread Mike Mascari
TED] select count(*) from pg_description; count --- 1542 (1 row) [EMAIL PROTECTED] select count(*) from pg_description; count --- 1541 (1 row) Mike Mascari ---(end of broadcast)--- TIP 6: Have you searched our list arc

Re: [HACKERS] COMMENT ON [GROUP/USER]

2004-03-08 Thread Mike Mascari
't know if Rod has plans to change attempts to COMMENT ON non-local databases to an ERROR in 7.5 or not. It was my fault from the beginning - but once I'd implemented COMMENT ON for tables and columns I just couldn't stop... :-) Mike Mascari Mike Mascari wrote: .. The comments are s

[HACKERS] Confusion over Copy.c/Count rows from file patch

2004-03-15 Thread mike g
Hi, I am trying to revise my patch for counting the number of rows inserted when using a COPY statement. I set it up a printf to see the results in the log file. When I execute a COPY the first time it reports 0 rows inserted(but actually inserts all rows). If I execute again it reports the num

Re: [HACKERS] COPY formatting

2004-03-17 Thread mike g
I deal with this daily in a cygwin environment. I wrote a simple c++ program where I hardcoded the input file name/location and output file name/location. I strip the quotation marks out where they are used for identifying text fields and change the comma's used as CSV's to pipes. I use a comb

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

2006-01-19 Thread Pollard, Mike
discussions such as this) in deciding how best to represent your data to aide in performance, ease of use, and adaptability. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc. ---(end of broadcast)--- TIP 1: if posting/readi

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

2006-01-20 Thread Mike Rylander
On 1/19/06, Pollard, Mike <[EMAIL PROTECTED]> wrote: > Martijn van Oosterhout wrote: > > > Please provides natural keys for any of the following: > > > > - A Person > > - A phone call: (from,to,date,time,duration) is not enough > > - A physical addres

Re: [HACKERS] Surrogate keys

2006-01-20 Thread Mike Rylander
On 1/21/06, Christopher Browne <[EMAIL PROTECTED]> wrote: > > On 1/19/06, Pollard, Mike <[EMAIL PROTECTED]> wrote: > >> Martijn van Oosterhout wrote: > >> > >> > Please provides natural keys for any of the following: > >> > > >>

Re: [HACKERS] First Aggregate Funtion?

2006-03-31 Thread Mike Rylander
2; $$ LANGUAGE SQL STABLE; -- And then wrap 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 Develop

Re: [HACKERS] Support Parallel Query Execution in Executor

2006-04-07 Thread Mike Rylander
> > > ---(end of broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.postgresql.org > -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] BEGIN inside transaction should be an error

2006-05-10 Thread Mike Benoit
valid transaction state - active SQL-transaction." > > /Dennis > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend -- Mike Benoit <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part

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

2006-06-03 Thread Mike Benoit
... if we did, we could have told > people how to use it to set the variables already. I'm very very > suspicious of any suggestion that it's easy to derive appropriate > numbers for these settings from one magic benchmark. > > regards, tom lane > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend -- Mike Benoit <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part

Re: [HACKERS] Call for 7.5 feature completion

2005-08-25 Thread Mike Mascari
er vendors' database products due to their parallel feature set (make -j 9 is nice too), but behaves like the boat-anchor it is w.r.t. PostgreSQL. Mike Mascari ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Found small issue with OUT params

2005-09-29 Thread Mike Rylander
functions with one OUT param would be the same as a function returning a rowtype with only one column, 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

Re: [HACKERS] Found small issue with OUT params

2005-09-30 Thread Mike Rylander
d of special casing single-OUT functions? If I understand correctly, Tom has just added a test to make single-OUT 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) beh

Re: [HACKERS] LDAP Authentication?

2005-10-10 Thread Mike Rylander
't really > know PAM... > Most of the work has already been done: http://pgina.xpasystems.com/ -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[HACKERS] platform test

2005-10-31 Thread Mike Rylander
dl -lm -lbsd VERSION = PostgreSQL 8.1RC1 -- == 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] Reducing the overhead of NUMERIC data

2005-11-02 Thread Mike Rylander
. > We cannot decide this sort of thing just by debate alone. So, I'll leave > this as a less potentially fruitful line of enquiry. > > Best Regards, Simon Riggs > > > ---(end of broadcast)--- > TIP 5: don't forget to

Re: [HACKERS] Reducing the overhead of NUMERIC data

2005-11-02 Thread Pollard, Mike
now of any trig functions, so they would need to be written If any one is interested, I would be happy to discuss this further. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc ---(end of broadcast)--- TIP 4: Have you se

Re: [HACKERS] Supporting NULL elements in arrays

2005-11-08 Thread Pollard, Mike
t, is the array element default. I'm not sure I like this or not, but it's an idea. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Supporting NULL elements in arrays

2005-11-08 Thread Pollard, Mike
t, is the array element default. I'm not sure I like this or not, but it's an idea. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Running PostGre on DVD

2005-11-15 Thread Pollard, Mike
asy. Go into src/backend/main/main.c and find the line if (pgwin32_is_admin()) and change it to if (false && pgwin32_is_admin()) Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Running PostGre on DVD

2005-11-15 Thread Pollard, Mike
new user and set myself up on that one. But come on, my old laptop was so old, and I was so excited... sorry, TMI. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] question about count(b) where b is a custom type

2005-11-16 Thread Pollard, Mike
> Firstly, if you just want a count, what's wrong with count(1) or > count(*). > Because unless the column does not allow nulls, they will not return the same value. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc. Be

Re: [HACKERS] question about count(b) where b is a custom type

2005-11-16 Thread Pollard, Mike
Richard Huxton wrote: > Pollard, Mike wrote: > >>Firstly, if you just want a count, what's wrong with count(1) or > >>count(*). > >> > > > > > > Because unless the column does not allow nulls, they will not return the > > same value. >

Re: [HACKERS] question about count(b) where b is a custom type

2005-11-16 Thread Pollard, Mike
, it's moot idea since it appears Postgres already does that. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc. Better to remain silent and be thought a fool than to speak out and remove all doubt. Abraham Lincoln > -

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Pollard, Mike
ers1, 1, 4) || '-' || SUBSTRING(numbers1, 5, 12); return(formatted_id); END;$$ LANGUAGE plpgsql; CREATE DOMAIN sqlserver.uniqueidentifier AS char(36) DEFAULT sqlserver.newid(); Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc.

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-24 Thread Pollard, Mike
If you're referring to my procedure for newid(), then it was just because of pure laziness; it was an internal proof of concept project, and I was still concentrating on getting it working. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems

Re: [HACKERS] Doubt

2005-11-25 Thread Pollard, Mike
It Seems To Me.   Here’s a decent list of common acronyms:   http://www.fun-with-words.com/acronyms.html   Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc.  Better to remain silent and be thought a fool than to speak

Re: [HACKERS] ice-broker scan thread

2005-11-29 Thread Pollard, Mike
+ (user->) (<-readahead) (<-readahead) (<-readaehead) so above, the user threads is starting low in the table and working high; the readahead threads are starting higher (but not at the end of the table), and working low. Like I said, this worked very well for me. M

Re: [HACKERS] ice-broker scan thread

2005-11-29 Thread Pollard, Mike
w pages to read. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc. Better to remain silent and be thought a fool than to speak out and remove all doubt. Abraham Lincoln -Original Message- From: Martijn van Oosterhout [mai

Re: [HACKERS] ice-broker scan thread

2005-11-30 Thread Pollard, Mike
to fit it into Postgres. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc. Better to remain silent and be thought a fool than to speak out and remove all doubt. Abraham Lincoln -Original Message- From: Simon Riggs [mai

Re: [HACKERS] generalizing the planner knobs

2005-12-01 Thread Pollard, Mike
the benefit of the fix. Remember, the purpose of SQL is to isolate the end user from having to care about how the data is retrieved; that is the RDBMS' problem. (the other thing forgotten was that it was supposed to be a natural language. NVL. Bah.) Mike Pollard SUPRA Server SQL Engineerin

Re: [HACKERS] generalizing the planner knobs

2005-12-01 Thread Pollard, Mike
I'd like when trying to track down exactly where the > optimiser has gone wrong. Point conceded. Any information that can help diagnose an issue is good information. I like the idea of only allowing it on explain. Mike Pollard SUPRA Server SQL Engineering

Re: [HACKERS] generalizing the planner knobs

2005-12-02 Thread Pollard, Mike
true that in the real world sometimes we still have to do some of the thinking for the computer. It's just that I've seen code absolutely littered with optimizer hints, and that really bothers me. But you can't not build a useful tool just because some would abuse it. Mike Pollard SUPR

Re: [HACKERS] generalizing the planner knobs

2005-12-04 Thread Pollard, Mike
index)? You can continue to plan up until the first parameter that can affect the plan. At that point, you save off the plan, and when you get actual values (on the execute command), continue with the planning. You can do the same thing with correlated subqueries Mike Pollard SUPRA Server S

Re: [HACKERS] Different length lines in COPY CSV

2005-12-12 Thread Pollard, Mike
ave to read and write the data, then read it again to load it into the database. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Different length lines in COPY CSV

2005-12-12 Thread Mike G.
hich can handle importing of Excel files directly thus don't have to deal with this issue. A file conversion utility would be very helpful for supporting Postgres with Windows especially if it could handle Excel files in their native format. Mike On Mon, Dec 12, 2005 at 07:58:52P

[HACKERS] PgInstaller error on upgrade

2005-12-12 Thread Mike G.
seems to have worked. I executed the command using the runas and did remember to extract the files before proceeding. Mike ---(end of broadcast)--- TIP 6: explain analyze is your friend

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

2006-01-02 Thread Mike Rylander
TL for the DNS record, and not a reload of our config. just my $0.02. > > Jon > > -- > Jon Jensen > End Point Corporation > http://www.endpoint.com/ > Software development with Interchange, Perl, PostgreSQL, Apache, Linux, ... > > ---(end of broadcast)--

Re: [HACKERS] PostgreSQL Core Committee Welcomes New Member

2004-09-15 Thread Mike Mascari
ackers Emeritus section? Eh? Mike Mascari ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

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 hav

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] making pdf of docs

2004-10-26 Thread Mike Mascari
image onto the next page, discover it is too large to fit on the next page, generate a page break, and the process continues ad infinitum. Maybe a recent large image was added to the docs? FWIW, Mike Mascari ---(end of broadcast)--- TIP 7: don'

Re: [HACKERS] Odd plpgsql behaviour

2004-11-15 Thread Mike Rylander
ECT statement after replacing the TG_* identifiers with their respective values. Your first example is essentially IF (SELECT (TG_OP = '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

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

2004-11-23 Thread Mike Rylander
work, Matt. 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

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-01 Thread Mike Rylander
developer to use 'eval', but that is a familiar concept to defensive developers. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 3: if posting/reading through Usenet,

Re: [HACKERS] 8.0RC1 tomorrow

2004-12-02 Thread Mike Mascari
data is composed entirely of NULL in 8.0? http://archives.postgresql.org/pgsql-performance/2004-11/msg00363.php Mike Mascari ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread Mike Rylander
#x27;re merrie than you know. :) > -alex > > ---(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 l

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 int

[HACKERS] Dump from cygwin directly to windows

2004-12-17 Thread Mike G.
sert statements option seems to be working fine. Not sure if this would be considered a bug or new feature. Mike ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PRO

Re: [HACKERS] Dump from cygwin directly to windows

2004-12-17 Thread Mike G
It looks like it started off as a permissions problem. I added the users to the database before trying again and this time it worked fine. I have attached the log from the original attempt if you wish to have a look. Mike On Fri, 2004-12-17 at 22:35, Tom Lane wrote: > "Mike G.&

Re: [HACKERS] Dump from cygwin directly to windows

2004-12-20 Thread Mike G
-superuser domain account. When I first saw all the \N errors I thought it was a unix to windows end of line character conversion error. Thanks for your help. Mike On Sat, 2004-12-18 at 11:00, Tom Lane wrote: > Mike G <[EMAIL PROTECTED]> writes: > > It looks like it started off

Re: [HACKERS] psql 8.0 final not working on NT 4.0sp6

2005-01-18 Thread Mike Mascari
BEN-US%3BQ241733 My code expects to find an shfolder.dll on < Windows 2000 systems and a shell32.dll on >= Windows 2000 systems. As I said, I *believe* you can guarantee success by just shipping shfolder.dll with the application. Hope that helps, Mike Mascari ---(end

Re: [HACKERS] Implementing Bitmap Indexes

2005-01-29 Thread Mike Rylander
tats. The planner would be able to choose a multi index scan based on multiple single column stat entries 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:/

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 design

Re: [HACKERS] Implementing Bitmap Indexes

2005-01-29 Thread Mike Rylander
001001000 2 | 1001011 3 | 010110100010110 ctids 1 | {2,5,8,11} 2 | {0,7,9,14} 3 | {1,3,4,6,10,12,13} The index scan would do bitwise a OR on bitmaps 1 and 3, find the possition of the "1"s, jump to those possitions in the ctid array, and bounce to t

Re: [HACKERS] FunctionCallN improvement.

2005-02-01 Thread Mike Rylander
time ./pg_test -unrolled 10 test Unrolled(5): 10 real0m3.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)

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_og

Re: [HACKERS] SQL99 Hierarchical queries

2005-02-28 Thread Mike Benoit
gt; 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 -- Mike Benoit <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part

Re: [HACKERS] tds_fdw for Sybase and MS SQL Server

2014-04-07 Thread Mike Blackwell
Excellent! I have an application for this. I'll give it a look. Thanks! Mike ______ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL

Re: [HACKERS] Congrats Andres Freund, the newest PostgreSQL Commiter!

2014-05-23 Thread Mike Blackwell
​Congrats Andres! Mike​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http

[HACKERS] Java and Postgresql

2000-12-29 Thread Mike S. Avelar
Hey... I'm just learning how to do all this db stuff and I'm kinda crippled because I've never used SQL. Here is what I'm doing. I've got pgaccess working, it works greate, I create databases and sql queries with it. I've got JRun running for my servlet engine, it also works great. Now when try

[HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Mike Cannon-Brookes
Any change of getting a 7.1 RC1 RPM? I'm using the beta4 RPMs at the moment but don't seem to be any more recent ones. It would seem dangerous to me to produce a 7.1 RPM without testing the RPM build process? -mike ---(end of broadcast)-

<    1   2   3   4   5