Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-26 Thread Richard Troy
On Fri, 23 Feb 2007, David Fetter wrote: > On Fri, Feb 23, 2007 at 08:28:06AM -0800, Richard Troy wrote: > > On Fri, 23 Feb 2007, David Fetter wrote: > > > On Fri, Feb 23, 2007 at 10:23:56AM +0100, Ben Edwards wrote: > > > > Anyone know of any guidelines for

Re: [GENERAL] Writing oracle/postgress generic SQL

2007-02-23 Thread Richard Troy
er versions. (We support versions of all five since about 1997 and, as there were so many small changes along the way, we provide a configuration mechanism where you can tell it the limitations of your version such as attribute length, maximum length of varchar, etc.) Regards, Richard -- Richa

Re: [GENERAL] Problems shutting down Postmaster

2007-02-08 Thread Richard Troy
hut down. Try telling Postgres about your new pg_hba.cfg file by using pg_ctl reload I'm not aware why you couldn't just stop it with pg_ctl stop even with the wrong pg_hba.conf file. HTH, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-

[GENERAL] Production systems beware: U.S. Daylight Savings Time comes at a new time this year

2007-02-01 Thread Richard Troy
at are NTP clients. Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Any Plans for cross database queries on the same server?

2007-01-31 Thread Richard Troy
likely find a summary and some URLs to more complete information. Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Any Plans for cross database queries on the same server?

2007-01-31 Thread Richard Troy
On Wed, 31 Jan 2007, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > On Tue, Jan 30, 2007 at 04:43:14PM -0800, Richard Troy wrote: > >> ... different in my opinion if only Unix didn't have this asenine view > >> that the choice between a

Re: [GENERAL] Any Plans for cross database queries on the same server?

2007-01-30 Thread Richard Troy
tem was down. > It ticked me off because we ended up eating at some pricey cafe next > door. I guess I'm a typical dumb American, traveling all the way to > Paris to eat at McDonald's. > > > Richard Troy wrote: > > On Tue, 30 Jan 2007, Mark Walker wrote: > >

Re: [GENERAL] Any Plans for cross database queries on the same server?

2007-01-30 Thread Richard Troy
aved! Sure wish the Open Source OS people would get a clue; paying a percent or so for reliability pays for itself thousands of times over and most people, if knowledgeable, would choose to spend the overhead to have a system that really is reliable. Richard -- Richard Troy, Chief Scienti

Re: [GENERAL] Any Plans for cross database queries on the same server?

2007-01-30 Thread Richard Troy
;t mean it's always good to go hog wild with any particular tool set just because you can. Sometimes people over-use engine-side features, forgetting that there are nearly always more cycles available on clients than servers... Richard -- Richard Troy, Chief Scientist Science Tools Cor

Re: [GENERAL] Password encryption method

2007-01-23 Thread Richard Troy
o do this cleanly is to use a program that has the suid bit set so it runs as the program's file owner (optionally group), and this program accesses the password and provides the database access. Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EM

Re: [GENERAL] Spam from EnterpriseDB?

2007-01-19 Thread Richard Troy
e matter is a substantial penalty for the offending party as this community is their target customer base, so your obvious anger can be at least somewhat satiated. Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com

Re: [GENERAL] Spam from EnterpriseDB?

2007-01-18 Thread Richard Troy
es material." So, rest assured. Richard > > Sincerely, > > Joshua D. Drake > > > > -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)

Re: [GENERAL] index type for indexing long texts

2007-01-13 Thread Richard Troy
ny > > potential hits against the main table. And if > > something like that does not exist yet, how difficult would it be to > > construct such a solution out of many "spare parts" > > that come with PG? > Try moving where the hash takes place - ie, us

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-11 Thread Richard Troy
the source code. Best would be in the official documentation/on a web page.) On occasion, I could *really* use such a list! (If such already exists, please point me at it!) Thing is, Tom, not everybody has the same level of information you have on the subject... Regards, Richard -- Richard Troy, Chief S

Re: [GENERAL] TIMESTAMP WITHOUT TIME ZONE

2006-12-15 Thread Richard Troy
> Richard Troy <[EMAIL PROTECTED]> writes: > > See my post from a few minutes ago, but simply put, time/date is at least > > as challenging as money or multibyte character. And, simply put, the > > Postgres implementation of timezone is INSUFFICIENT. > > Reall

Re: [GENERAL] TIMESTAMP WITHOUT TIME ZONE

2006-12-15 Thread Richard Troy
at it'll always give me back the _same_exact_bits_ as what I gave it! Anything else is horribly broken and is, to quote Tom Lane, "about as good a definition of corrupted data as I can think of." - with appologies to Tom, of course. Regards, Richard -- Richard Troy, Chief Scien

Re: [GENERAL] TIMESTAMP WITHOUT TIME ZONE

2006-12-15 Thread Richard Troy
nothing broken about "timestamp without timezone" within either the engine or the JDBC drivers, but I'd also caution to always punt on the question of whether or not someone should or shouldn't use Postgres' time zone feature. Perhaps a "for most people" qualifie

[GENERAL] Proposed ISO solution to Male/female

2006-12-08 Thread Richard Troy
7 = hermaphrodite 8 = declined to state 9 = Neuter - Not applicable Hmmm... Easy to write the various functions making this a new datatype... Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ -

Re: [GENERAL] Male/female

2006-12-08 Thread Richard Troy
sible in English anyway? There are dozens if not hundreds of androgenous names - Pat and Tracy come immediately to mind, and there are countless others! RT -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

2006-11-29 Thread Richard Troy
On Wed, 29 Nov 2006, Ritesh Nadhani wrote: > > Hello > > I have been working with wxWidgets and I didnt face a problem. What > specific thing were broken in wxWidgets for Windows? > > Ritesh PLEASE take this offline - it's not even close to Postgres related. Richar

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

2006-11-26 Thread Richard Troy
t do the job? The answer is, it won't have the user base you're looking for. Seems to me, you need to get back to square one: What problem(s) are you trying to solve? And an answer that says, "Oh, all this DBMS admin stuff and - eventually! - an app builder too!" is not

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

2006-11-25 Thread Richard Troy
sion RDBMS in a way that's easily extensible, or configurable, if you will. I think it's a lot harder to do than might sound. > > I am cross posting this to various db mailing lists as well as relevant > newsgroups to get maximum idea about it. You can also contact me > direct

Re: [GENERAL] Counting records in a PL/pgsql cursor

2006-11-03 Thread Richard Troy
f course be wrong, though! OTOH, it would be much faster. If the only down-side is occasionally giving users an incorrect count, then perhaps call it a "row estimate", and let them marvel at how accurate the estimate is most of hte time! Good luck, Richard -- Richard Troy, Chief Scie

Re: [GENERAL] Is there anyway to...

2006-11-02 Thread Richard Troy
ely database and OS portable (or can be, at least), there's no need for any super-user capability of any kind, you can use any kind of trigger you like, and there's no permission leakage problem, either... I guess all you need is functioning nohup capability (which Windows systems ma

Re: [GENERAL] Modifying SQL parser with extensions?

2006-10-29 Thread Richard Troy
+0100 > From: Matthias Lüdtke <[EMAIL PROTECTED]> > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Modifying SQL parser with extensions? > > > Richard Troy wrote: > > Our package lets you pass individual statements or entire files full > > of SQL with emb

Re: [GENERAL] Modifying SQL parser with extensions?

2006-10-29 Thread Richard Troy
ts you pass individual statements or entire files full of SQL with embeded comments as it's not that uncommon among SQL dialects - they're just stripped out before getting to the engine, as Alvaro suggested. Regards, Richard -- Richard Troy, Chief Scientist Science Tools

Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???

2006-10-27 Thread Richard Troy
itches; the library that does this magic is written in Java, and, it's not free. -smile- Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Postgres history and the 30th Anniv. of Ingres, gathering at UCB...

2006-10-25 Thread Richard Troy
ty, some twelve plus years after the company's demise, still hangs to gether as Ex-Ingres - "Ingres Corporate Culture without the corporation!" In closing, I'd very much enjoy meeting folks from the PostgreSql team, especially the core members. You'll find me at this talk/reception -