Re: [GENERAL] Writing oracle/postgress generic SQL

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 writing SQL which works under Oracle witch

Re: [GENERAL] Writing oracle/postgress generic SQL

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 -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com

Re: [GENERAL] Problems shutting down Postmaster

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-747-1263 [EMAIL PROTECTED], http

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

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?

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 memory management strategy that kills random

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

, Jeff Davis ...Back in, oh, October perhaps it was, I did some research on this subjet and posted my findings on one of the PG lists, so you can look into the PG archives for OOM and my name and likely find a summary and some URLs to more complete information. Richard -- Richard Troy, Chief

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

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

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

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. /rant Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http

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

. Richard Troy wrote: On Tue, 30 Jan 2007, Mark Walker wrote: LOL, I remember those days. Uh, can you hold on? My computer just went down. or you need to fill out form 1203-B, send us $25 and we'll get you the information you need in six weeks. Just kidding, but certainly reliability

Re: [GENERAL] Password encryption method

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 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast

Re: [GENERAL] Spam from EnterpriseDB?

the biggest risk to an organization in this regard). Either way, I'm sure their embarassment on the 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

Re: [GENERAL] Spam from EnterpriseDB?

email all the time to potentials. It is common practice but I do it, directly as me. Josh, under the law, that's not spam. Individually written emails are never spam even if they may be unsolicited sales material. So, rest assured. Richard Sincerely, Joshua D. Drake -- Richard Troy

Re: [GENERAL] index type for indexing long texts

spare parts that come with PG? Try moving where the hash takes place - ie, use your own hash function to create the key. RT -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end

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

/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 Scientist Science Tools Corporation 510-924-1363 or 202-747

Re: [GENERAL] TIMESTAMP WITHOUT TIME ZONE

a for most people qualifier, or, when every user is in an hour-offset from GMT timezone, etc., but even then, multi-time-zone applications need to be VERY warry. Respectfully, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http

Re: [GENERAL] TIMESTAMP WITHOUT TIME ZONE

. 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 2: Don't 'kill -9' the postmaster

Re: [GENERAL] TIMESTAMP WITHOUT TIME ZONE

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. Really? We do all the things you have listed

Re: [GENERAL] Male/female

- 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/ ---(end of broadcast)--- TIP 2: Don't

[GENERAL] Proposed ISO solution to Male/female

might be useful: 0 = unknown 1 = male 2 = female 3 = 4 = female to male transgender 5 = male to female transgender 6 = 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

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

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. Richard -- Richard Troy, Chief Scientist

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

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 an answer I can believe as it's too ambitious, and not focused on any core user group. Good luck, Richard -- Richard Troy, Chief Scientist Science

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

separately. -shrug- Waiting for your comments. -- Ritesh All that said, I'd use such a tool if one were available... Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end

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

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 Scientist Science Tools Corporation 510-924-1363 or 202-747-1263

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

no permission leakage problem, either... I guess all you need is functioning nohup capability (which Windows systems may have trouble with, I don't know). Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com

Re: [GENERAL] Modifying SQL parser with extensions?

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 Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end

Re: [GENERAL] Modifying SQL parser with extensions?

: 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 embeded comments as it's not that uncommon among SQL dialects

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

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