From: Scott Marlowe <scott.marlowe@gmail.com>
To: Erik Jones <erik@myemma.com>
Cc: Campbell, Lance <lance@uiuc.edu>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: work_mem and shared_buffers
Date: Fri, 9 Nov 2007 14:47:01 -0600
Message-ID: <dcc563d10711091247j206800ddtee35393b0fef324e@mail.gmail.com> (raw)
In-Reply-To: <3CE40232-B0A7-4603-806A-2912CE3E99F1@myemma.com>
References: <B10E6810AC2A2F4EA7550D072CDE8760197DE4@SAB-FENWICK.sab.uiuc.edu>
<47349F4E.5070204@enterprisedb.com>
<B10E6810AC2A2F4EA7550D072CDE8760197DE5@SAB-FENWICK.sab.uiuc.edu>
<dcc563d10711091112r73ef016dp56d01bd6dd04a1d3@mail.gmail.com>
<B10E6810AC2A2F4EA7550D072CDE8760197DEB@SAB-FENWICK.sab.uiuc.edu>
<dcc563d10711091124l4fadcc88n89254e25ff36de5@mail.gmail.com>
<3CE40232-B0A7-4603-806A-2912CE3E99F1@myemma.com>
On Nov 9, 2007 2:38 PM, Erik Jones <erik@myemma.com> wrote:
>
> >
> > I imagine in a few years, hardly anyone using postgresql will remember
> > the ancient art of having either apostrophes in a row inside your
> > plpgsql functions...
>
> Speaking of that devil, I started working with Postgres mere months
> after that particular evil went away but we still have a good bit of
> plpgsql with it in production. I've been meaning to convert it and
> clean it up for a while now. Would you, or anybody, happen to know
> of any scripts out there that I could grab to make a quick job, no
> brains required of it?
Man, I can't think of any. I'd assume you'd need to look for the
longest occurance of ' marks, and replace it with one field, say $1$
or something, then the next smaller set, with $2$ or something and so
on. I imagine one could write a script to do it. Luckily, we only
had one or two levels of ' marks in any of our stored procs, so it was
only a few minutes each time I edited one to switch it over.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, erik@myemma.com, lance@uiuc.edu, heikki@enterprisedb.com
Subject: Re: work_mem and shared_buffers
In-Reply-To: <dcc563d10711091247j206800ddtee35393b0fef324e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox