Re: [GENERAL] Scrolling/Updating Cursors

2013-11-22 Thread John Meyer
Why not both? I keep on searching even when I post up a question. On 11/22/2013 2:27 PM, Kevin Wooten wrote: On Nov 19, 2013, at 6:33 PM, Kevin Wooten kd...@me.com wrote: My apologies for posting what is almost certainly somewhat of a repeat question but I have searched and attempted

Re: [GENERAL] String reverse funtion?

2013-10-09 Thread John Meyer
On 10/9/2013 11:52 AM, David Johnston wrote: ginkgo36 wrote Hello everyone I have to reverse a string like EA;BX;CA to CA;BX;EA. or EA,BX,CA to CA,BX,EA Is there any function to do this? Thanks all! No. You will have to write your own. David J. Based upon the example, it's

Re: [GENERAL] String reverse funtion?

2013-10-09 Thread John Meyer
That works too. Point being ginkgo36 has his solution. On 10/9/2013 12:07 PM, Pavel Stehule wrote: 2013/10/9 John Meyer johnme...@pueblocomputing.com mailto:johnme...@pueblocomputing.com On 10/9/2013 11:52 AM, David Johnston wrote: ginkgo36 wrote Hello everyone

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-04 Thread John Meyer
On 9/4/2013 2:59 PM, Andreas 'ads' Scherbaum wrote: On 09/04/2013 10:55 PM, Erik Rijkers wrote: On Wed, September 4, 2013 22:26, Andreas 'ads' Scherbaum wrote: Do you have a cool idea? Please let us know. Either reply here or send http://imgur.com/eMyw6 Not really new (nor my own) but I

Re: [GENERAL] Why are stored procedures looked on so negatively?

2013-07-23 Thread John Meyer
Taking an absolutist position either way is pretty blind. What is the purpose of the procedure? Is it enforcing business rules? Are these rules that must be enforced against already existing data or are they more akin to validation of a credit card. How many people are accessing your

Re: [GENERAL] Postgres security article

2009-11-28 Thread John Meyer
On 11/28/2009 7:47 AM, Colin Streicher wrote: http://www.ibm.com/developerworks/opensource/library/os- postgresecurity/index.html Nice link, but it got broken for me: http://tinyurl.com/ylro9y9 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

[GENERAL] Is there any reason why edit PostgreSQL.conf should be on my menu

2008-08-01 Thread John Meyer
Especially when I haven't edited anything yet? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [SQL] subtract a day from the NOW function

2007-06-07 Thread John Meyer
Tom Lane wrote: Kevin Hunter [EMAIL PROTECTED] writes: At 5:57p -0400 on 07 Jun 2007, Michael Glaesemann wrote: It is a bit tricky. Datetime math is inherently so. So one wonders why the whole world doesn't migrate to a single timezone. Or at least get rid of

Re: [GENERAL] Postgres Printed Manuals

2007-05-13 Thread John Meyer
Robert James wrote: The Postgres docs are great. Unfortunatelty, at 1600 pages, my printer is a little weary. Are bound printed editions available? If not, has anyone had any good experience printing them via any of the online services? (The ones I contacted said it was too big for them

Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-22 Thread John Meyer
Ashish Karalkar wrote: Try pg_ctl -D /path to pg data home e.g. pg_ctl -D /usr/local/pgsql/data Hope this will help - Original Message - From: John Meyer [EMAIL PROTECTED] To: postgresql-general pgsql-general@postgresql.org Sent: Thursday, March 22, 2007 8:31 AM Subject: [GENERAL

Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-22 Thread John Meyer
Douglas McNaught wrote: John Meyer [EMAIL PROTECTED] writes: Maybe it was just understood, but I was typing in word for word the entry from pg_hba.conf, but I'll keep that for reference later on. pg_ctl needs either the data directory supplied on the command line, or PGDATA set

[GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-21 Thread John Meyer
I'm setting up phpPgAdmin and I finally get to the point where you reconfigure pg_hba.conf One of the lines says to reload the values, type the command pg_ctl reload. I try it as super user, no go, I su into postgres, it complains: pg_ctl reload pg_ctl: no database directory specified and

Re: [GENERAL] counting query

2007-01-28 Thread John Meyer
Joris Dobbelsteen wrote: CREATE TABLE attendance ( attendanceid serial primary key, Why you have this??? You already have (entered,timeperiod,studentid) that you can use, since that must be unique too. Try to avoid surrogate keys as much as possible (it really increases performance and

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

2007-01-20 Thread John Meyer
What I think bothers me is this whole concept that if PostgreSQL is to flourish, MySQL has to be beaten down. Folks, both products are free, both can be used in the same shop (maybe not on the same computer if your running them in production). Putting down MySQL will not make PostgreSQL any

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

2007-01-20 Thread John Meyer
I'd say fine, but why discuss the flaws of MySQL on a PostgreSQL list? If you want to correct it, why not put that flaw on a MySQL list. And yes, I agree, there is a difference between pointing out a legitimate flaw and simply bashing for bashing's sake. Joshua D. Drake wrote: John Meyer wrote

Re: [GENERAL] Male/female

2006-12-08 Thread John Meyer
Second method might be better. Of course, you could also do a one chracter gender M/F if you want to save space. Raymond O'Donnell wrote: Just wondering.how do list member represent gender when storing details of people in a database? I've done it two ways: * A bool column, with the

Re: [GENERAL] Male/female

2006-12-08 Thread John Meyer
COPY gender (gender_pk, gender) FROM stdin; 0(unknown) 1Male 2Female 3Trans \. Not to take this completely off track, but isn't transgendered not so much a gender as it is a process of moving from one gender to another? ---(end of

Re: [GENERAL] Male/female

2006-12-08 Thread John Meyer
Seven genders? Even San Fransisco thinks that's over the top. David Fetter wrote: On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote: Just wondering.how do list member represent gender when storing details of people in a database? I usually use a table called gender which

Re: [GENERAL] Male/female

2006-12-08 Thread John Meyer
I guess in the end it really depends on what the client wants to track and what they don't. But this does actually have a serious implication, and that is how do you code for something that is mutable vs. something that supposedly is or very nearly immutable (i.e. the alphabet).

[GENERAL] phpPgAdmin, cannot connect to server

2006-11-18 Thread John Meyer
Okay, I read the FAQ. I looked at my postgresql.conf file and didn't see #tcpip_socket set, either to true or false. I'm also attaching the tail of the log, even though I could connect to the database using the command line client. 2006-11-18 19:27:22 MST jmeyer jmeyer LOG: could not connect

Re: [GENERAL] phpPgAdmin, cannot connect to server

2006-11-18 Thread John Meyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 And while we're on it, setting that variable caused the PostgreSQL server to lock up Yast when I was restarting it that way. John Meyer wrote: Okay, I read the FAQ. I looked at my postgresql.conf file and didn't see #tcpip_socket set, either

Re: [GENERAL] vista

2006-09-19 Thread John Meyer
John Meyer wrote: has anybody gotten postgresql to install successfully under Windows Vista? ---(end of broadcast)--- TIP 6: explain analyze is your friend BTW, here's the issue at the pgFoundary http://pgfoundry.org/tracker/index.php?func

[GENERAL] vista

2006-09-18 Thread John Meyer
has anybody gotten postgresql to install successfully under Windows Vista? ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] vista

2006-09-18 Thread John Meyer
Tom Lane wrote: Ron Johnson [EMAIL PROTECTED] writes: On 09/18/06 22:32, Joshua D. Drake wrote: John Meyer wrote: has anybody gotten postgresql to install successfully under Windows Vista? It's not out yet ;) Release Candidates are, for the very purpose

[GENERAL] Windows Vista Starter

2006-09-17 Thread John Meyer
Has anybody had success installing PostgreSQL into Windows Vista (starter)? ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Automatic Backup Script

2006-08-12 Thread John Meyer
RPK wrote: Are there any ready-made backup scripts available that can backup PostgreSQL database? Have you checked out pgAdmin yet? -- John Meyer http://pueblonative.wordpress.com http://pueblonative.110mb.com/board ---(end of broadcast

Re: [GENERAL] Suse Linux 10.0

2006-01-08 Thread John Meyer
Jerome Lyles wrote: On Thursday 05 January 2006 10:57, Peter Eisentraut wrote: Am Donnerstag, 5. Januar 2006 21:15 schrieb Joseph M. Day: Has anyone been able to get the latest version of Postgres working on Suse 10.0 ? I just switched form Fedora and realized that this version is not

Re: [GENERAL] constraint on type object in oracle

2006-01-06 Thread John Meyer
Florent Garcin wrote: Hello! I've a project to implement in oracle using odmg and I'm stuck... Hi, I'm kind of new here, but shouldn't you be asking Oracle questions in oracle mailing lists? ---(end of broadcast)--- TIP 1: if posting/reading

[GENERAL] ACID compliance

2006-01-05 Thread John Meyer
Okay, what exactly is ACID compliance? ---(end of broadcast)--- TIP 6: explain analyze is your friend