On Tuesday 03 November 2009 05:09:26 pm Craig Ringer wrote:
> Mike Diehl wrote:
> > It sounds to me like I've got some "stuck" connections, but I don't know
> > how to confirm this. Any other suggestions would be welcome, also.
>
> Have a look at pg_catal
stuck" connections, but I don't know how
to confirm this. Any other suggestions would be welcome, also.
--
Take care and have fun,
Mike Diehl.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Friday 09 October 2009 08:22:52 pm Tom Lane wrote:
> Mike Diehl writes:
> > I'm doing a routine vacuum on my database and it seems to be getting
> > "stuck."
> >
> > I've got a "servers" table with only a few rows and columns in it
eral minutes. It's beginning to
sound like a hard drive problem. Any other ideas?
--
Take care and have fun,
Mike Diehl.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all.
I've encountered an SQL problem that I think is beyond my skills...
I've got a table full of records relating to events (phone calls, in
this case) and I need to find the largest number of events (calls)
occurring at the same time.
The table had a start timestamp and a duration field whi
On Tuesday 30 September 2008 10:46:46 am Merlin Moncure wrote:
> On Mon, Sep 29, 2008 at 8:02 PM, Mike Diehl <[EMAIL PROTECTED]> wrote:
> > That fixed it. If you are ever in Albuquerque, NM., let me know. I'll
> > be happy to buy you a beer.
>
> Tom probably has
That fixed it. If you are ever in Albuquerque, NM., let me know. I'll be
happy to buy you a beer.
Mike.
On Monday 29 September 2008 05:26:43 pm Tom Lane wrote:
> Mike Diehl <[EMAIL PROTECTED]> writes:
> > For example, I'm trying to do this:
> >
> > inse
t number/id to an actuall customer.)
When I run this query, I get:
ERROR: column "block_number" is of type integer but expression is of type
character varying
What am I doing wrong?
TIA,
--
Mike Diehl
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
ment, but might make management more difficult.
Design #2 is easy to manage, but the SQL needed to generate reports would
be "tricky." I'm intending to provide a report generator, so the complexity
of the reporting SQL can be mitigated.
So, which road should I travel down?
TIA,
