On Tue, Dec 07, 2004 at 01:20:07PM +0530, Nageshwar Rao wrote:
Not able to drop a table,though nobody is accessing the table.I am able to
insert the records and delete the records.When I give drop table it just
hangs there .No error message.
Another transaction might be holding a lock on the
Hi,
Citing Greg Stark [EMAIL PROTECTED]:
Martijn van Oosterhout [EMAIL PROTECTED] writes:
Actually, hard disk encryption is useful for one thing: so if somebody
kills the power and takes the hard disk/computer, the data is safe.
While it's running it's vulnerable though...
Where do you
You could convert your timestamp into an integer (number of seconds since
the epoch).
Also, under certain conditions, you can cheat and use a sequence instead
of a timestamp.
Hi,
I need an index on a postgis-point and a timestamp.
I'm using an GiST index on the geometry. But the creation
The Problem is, that I need the milliseconds and the information of the
Timezone.
-Ursprüngliche Nachricht-
Von: Pierre-Frédéric Caillaud [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 7. Dezember 2004 09:48
An: Werdin Jens; [EMAIL PROTECTED]
Betreff: Re: [GENERAL] Index on geometry and
Hi all!
I posted this on pgsql-performance but got no reply, so here it is:
thanks!
ps
-- Forwarded message --
From: Postgres Learner [EMAIL PROTECTED]
Date: Mon, 6 Dec 2004 14:58:46 +0530
Subject: 8.0 vs. 7.4 benchmarks
To: [EMAIL PROTECTED]
Hi all!
Has anyone done any
On Tue, Dec 07, 2004 at 02:41:37PM +0800, cheng shan wrote:
In the first version, the function destroy_object_type( ) just drop
the table only. But when I find the triggers havn't been actived
yet, I add the delete setense. This time it becomes even worse,
the system throws error
I got some problem on PostgreSQL 8 for windows so I uninstall and
reinstall it again. Before I uninstall PostgreSQL 8 I already backup all
files and folders (copy all to other place).
The problem is how can I restore by use files and folders that I
already backup. If I try to restore by put all
Hi!
You can't. You'll have to restore your erroneous version first, then dump your
data, the reinstall and use restore to restore the data you want.
Kind regards
Markus
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von
Premsun
My problem is I cannot start PostgreSQL service on Windows 2000 Advance
Server. For more information it's work fine for all 3 - 4 months ago.
The error message that show when I try to start PostgreSQL service is:
Microsoft Management Console
Could not start the PostgreSQL Database Server
On Tue, 7 Dec 2004, Werdin Jens wrote:
Hi,
I need an index on a postgis-point and a timestamp.
I'm using an GiST index on the geometry. But the creation of an GiST index
on geometry and timestamp seems to be impossible, because GiST doesn't
support Timestamps.
Is there a possibility to solve my
On Tue, 7 Dec 2004, cheng shan wrote:
In the first version, the function destroy_object_type( ) just drop the
table only. But when I find the triggers havn't
been actived yet, I add the delete setense. This time it becomes even
worse, the system throws error message.ERROR: could
not open
On Mon, 6 Dec 2004, Stephen Frost wrote:
* Stephan Szabo ([EMAIL PROTECTED]) wrote:
On Mon, 6 Dec 2004, Per Jensen wrote:
select count(*)
from accesslog
where time between (timeofday()::timestamp - INTERVAL '30 d') and
timeofday()::timestamp;
Besides the type issue,
There are many reports of kernel problems with memory allocation
(too agressive) and swap issues with RHEL 3.0 on both RAID
and non-RAID systems. I hope folks have worked through all
those issues before blaming postgresql.
Tom Lane wrote:
If I thought that a 200% error in memory usage were cause
L.S.
I noticed the following :
Workstation used to build RC1:
2.4.21-260-athlon, i686 athlon i386 GNU/Linux
Configured with :
./configure
--enable-thread-safety
--disable-shared
--prefix=/usr/src/postgresql/install
What do you show for PTHREAD_* in Makefile.global?
Is this another platform where the library doesn't remember dependencies
used when it was built? It is Linux so I wouldn't think so.
---
Frank van Vugt wrote:
L.S.
I
On Tue, Dec 07, 2004 at 14:47:58 +0530,
Postgres Learner [EMAIL PROTECTED] wrote:
Has anyone done any performance benchmarking of postgresql 7.4 vs 8.0?
Are there any scenarios where 8.0 can be expected to be faster?
Have you read the release notes?
I would love to get my hands on any
What do you show for PTHREAD_* in Makefile.global?
PTHREAD_CFLAGS = -pthread -D_REENTRANT -D_THREAD_SAFE
-D_POSIX_PTHREAD_SEMANTICS
PTHREAD_LIBS= -lpthread
Is this another platform where the library doesn't remember dependencies
used when it was built? It is Linux so
Does anyone know how to connect _javascript_ to a postgresql
database
Please send example if anyone has done it
thanks
Robert Stewart
Network Eng
Commonwealth Office of Technology
Finance and Administration Cabinet
101 Cold Harbor
Work # 502 564 9696
Cell # 502 330 5991
hello to all
the scene is following:
/psql someDatabase
vaccum full verbose;
but nothing informs.
in which cases vacuum do not inform anything?
postgresql 7.4 on red hat 9.0
any clue be appreciate.
best regards
klingon
PS: the application has problems for that reason it
wanted to
19 matches
Mail list logo