> Does anyone know of any good package for Linux for assisting with database
> design? I'd like to find a program that can be used to create/manipulate
> entity-relationship diagrams. It would be nice bonus if one could also
output
> the postgresql sql schemas from it.
Something like Dia would
I'm just getting into functions in postgres and I've bumped up against a
couple issues which I think I need explained. I've had a wee read of the
archives on this but haven't turned up to much. I think it may be a
conceptual problem on my part though :)
Is it possible on postgres, using pl/pgsql
>
> This is really an OS question, but I'm posting here as it is caused by
> pgsql backends and I suspect some of you have already dealt with it...
>
> My combination of apache and postgresql is quickly exceeding the
> maximum number of open files (4096) under linux RH6.1. In digging
> around for
> Not certain, but I think you get an error message like that when you
> rollback at inappropriate (but harmless?) times, as in when you are
> not in a transaction or have nothing pending on the current
> transaction.
The transaction goes though OK so I don't think it's that. I'll take a
closer
Hi.
I've been getting the following error in my scripts
using transactions to write to pg
NOTICE: EndTransactionBlock and not
inprogress/abort state
I didn't see much of it in the archives. I'm using
PHPLib and PHP3 which I suspect may be causing the problem, but I need a bit
more info.
