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 ve
> 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
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 a
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.
>
>
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
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 f
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
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 r
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 pro
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 8.0-beta
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 Cholt
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 of
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 message.
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 perfor
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
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 of
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...
>
> W
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 th
19 matches
Mail list logo
