= create table t(id int4 primary key);
= explain select min(id) from t;
NOTICE: QUERY PLAN:
Aggregate (cost=43.00 rows=1000 width=4)
- Seq Scan on t (cost=43.00 rows=1000 width=4)
EXPLAIN
Is it possible to make postgresql to use index scan when it calculate
MIN(id).
On Tue, 29 Feb 2000, Andrei N.Sobchuck wrote:
Is it possible to make postgresql to use index scan when it calculate
MIN(id).
Not currently, but it's on the todo list.
--
Peter Eisentraut Sernanders vaeg 10:115
[EMAIL PROTECTED] 75262 Uppsala
Hi Carla and Chris,
I have the following Perl Script (with Postgres code):
[ stuff deleted]
This Script will run from the command line, and inserts values into the
existing DB and table. When it is run via the web browser, nothing happens
(browser hangs). The script is in the
Hi,
I think the problem is the web process user.
The cgi script is run in name of the web process, you should check what
name is assigned for your web process, normally it is named as nobody,
webwww, then
grant access privileges (like select, insert, delete) on that table to
your web
Hi All,
Im trying to access the archives without success :(
Sorry if a common question...
Well, Im trying to run postgres 6.5.3 or 7Beta1 on my 2.0.36 linux.
server.log returns :
IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
size=1063936, per
mission=600
FATAL 1: