Did massive amounts
of searching and read Tom Lane's post regarding the subject, but that was dated
January of 1999. Was wondering if anyone know if there was any progress on
the issue and what the resulting outcome was.
Is there a way to
select distinct on one column and sort by another?
I've seen brief posts regarding server loads, distrubution for heavy loads,
etc, but don't recall if there were any solutions...
Anyways...We are running a Postgres DB against multiple frontend
webservers. For most of the time, everything runs fine. Then, all of a
sudden, everything will sta
Looks like one of my tables got corrupted. Can someone explain how to
recover from this?? Trying to drop the table is not working...Postgres
hangs.
Any help is appreciated.
Arthur
Was wondering if there was a way to use an aggregate value in a single
select query to make a calculation within that query...
Example:
Table has column bool of type boolean with various random boolean
values.
Want to see if it is possible (in a single select query) to find the
percentage of ent
Had this rebooting problem before for a while and it drove me NUTZ! Installed RedHat
and FreeBSD and both rebooted periodically. Don't know if my solution will help or
not,
but what was causing my reboots was the system BIOS. The options for Power Management
in the system BIOS should have some
Can somebody tell me how to define a fixed length array? The manual is
pretty sparse on arrays.
I'm trying to create a fixed length boolean array by using:
CREATE TABLE test (apple boolean[5]);
This creates the array, but it is not fixed in length. Inserting and
retrieving larger arrays (grea