me a note.
Thanks in advance.
--
Ken Kinder
www.kenkinder.com
ged Postgres, I installed it myself.
On Sun, Jan 28, 2001 at 08:14:12PM -0500, Tom Lane wrote:
> Ken Kinder <[EMAIL PROTECTED]> writes:
> > After a few months of running, I have a database that consistantly stops
> > taking inserts. It isn't a high-use database, doesn't
insert in psql, it
acts like it did it, you select from the data, and it's simply not there.
If I dump and rebuild the database, the problem is solved.
Any suggestions?
psql (PostgreSQL) 7.0.0
--
Ken Kinder
www.kenkinder.com
Use a large object. See the Postgres docs.
--
Ken Kinder
www.kenkinder.com
On Tue, 22 Aug 2000, [iso-8859-9] Mustafa Timur Gökçe wrote:
> Hi!
>
> I'm trying to write a program in PHP/PostgreSQL.
>
> In my program when i insert a data bigger than 8K , i have an error like
Can anyone suggest how to get a big schema diagram for a Postgres
database? We want one for the wall.
--
Ken Kinder
www.kenkinder.com
select * from foo where col > datetime 'date literal' and col < datetime
'date literal'
datetime 'value'
casts the string to a datetime variable. You can also use timespans.
--
Ken Kinder
www.kenkinder.com
On Mon, 14 Aug 2000, Erik B. Flitman wrote:
>
Data Junction, and it may connect with PostgreSQL
if you have PG ODBC running.
I'm a little partial to the Python scripting. :)
--
Ken Kinder
www.kenkinder.com
On Sat, 29 Jul 2000, kumar iyer wrote:
> My name is Sreekumar.G.Iyer and I'm working as a software engineer
>
I like pgaccess's reporter.
--
Ken Kinder
www.kenkinder.com
On Tue, 25 Jul 2000, miguel valero wrote:
>
> Any good report generator for PostgreSQL out there ?
>
> I need something that is BSD-licensed, public domain, or LGPL
One way I think of is just grepping for postgres in your ps command. I
think each connection gets its on thread. On Linux, ps will show threads.
--
Ken Kinder
www.kenkinder.com
On Wed, 12 Jul 2000, Mario Simeone wrote:
> how can I count the number of current connections to a postgres DB ?
>
