Hi Greg,
What OS is this? Postgres is just using your OS's random()/srandom() calls.
On
some platforms these may be poorly implemented and not very random.
I'm using a debian linux as OS with a 2.4 kernel running on it.
Incidentally, are you reconnecting every time or is it that multiple calls
Arnau Rebassa wrote:
I don't know if there is the possibility to seed the random number
generator manually, anybody knows it?
setseed()
-Neil
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
Tom Lane wrote:
=?ISO-8859-1?Q?Sebastian_B=F6ck?= [EMAIL PROTECTED] writes:
I investigated a little bit further and can be more precisely
about the whole thing. This (wrong) behaviour only occurs, if
the view has an order by clause.
The bug is triggered by the combination of an inherited UPDATE
Hi,
I know we will be using at our own risk, I have read the
experimental warnings, but still PostgreSQL is a very attractive
RDBMS for the Windows application we are developing. Most customers
will want a simple single-machine version, where the program will be
storing its data in a local
Hi,
I've made up 2 plpgsql calls, the table and function schema is available at
http://www.bignose.ca/help/pg.txt
I call them like this
select ad_hits(33760);
select ad_inquiries(33760);
i did an update ad_base set hits = 0, inquiries = 0 to initialize both rows,
since i added them using
I've been using the Win32 port of PostgreSQL for several months now on a
pre-production test machine without much difficulty, in in my
environment I've had more trouble with MySQL in general than PostgreSQL
on Windows I'd recommend installing the beta and trying it out.
Depending on the
Is anybody using contrib/dbmirror in a production environment?
- DAP
==
David ParkerTazz Networks(401) 709-5130
---(end of broadcast)---
TIP 9: the planner will ignore your desire to
Arnau Rebassa [EMAIL PROTECTED] writes:
I'm using a debian linux as OS with a 2.4 kernel running on it.
Incidentally, are you reconnecting every time or is it that multiple calls
in a single session are returning the same record?
I'm reconnecting each time I want to retrieve a message.
Gaetano Mendola wrote:
Matthew T. O'Connor wrote:
Since you are running autovacuum I doubt the doing vacuumdb -a -z is 3
times a day buying you much. It's not a bad idea to do once in a while.
The reason is that I have few tables of about 5 milion with ~ 1
insert per
day. Even with setting
What would be the recommended server specs to use for a postgresql
database server that needs to be able to support upto 800 active
connections at one time, searching a table that in theory could be over
2G in size? We have attempted this with a supermicro superserver
dualproc Xeon 2.8G with
On Mon, 2004-10-04 at 08:59, Bryan wrote:
What would be the recommended server specs to use for a postgresql
database server that needs to be able to support upto 800 active
connections at one time, searching a table that in theory could be over
2G in size? We have attempted this with a
On Mon, Oct 04, 2004 at 10:14:19 -0400,
Tom Lane [EMAIL PROTECTED] wrote:
It occurs to me that you might be seeing predictability as an indirect
result of something else you are doing that somehow tends to synchronize
the backend start times. Are you connecting from a cron script that
On Mon, 4 Oct 2004, Tom Lane wrote:
Arnau Rebassa [EMAIL PROTECTED] writes:
I'm using a debian linux as OS with a 2.4 kernel running on it.
Incidentally, are you reconnecting every time or is it that multiple calls
in a single session are returning the same record?
I'm reconnecting each time
Am Freitag, 1. Oktober 2004 10:56 schrieb Richard Huxton:
Janning Vygen wrote:
tonight my database got corruppted. before it worked fine.
in the morning some sql queries failed. it seems only one table was
affected. i stopped all web access and tried to backup the current
database:
On Mon, Oct 04, 2004 at 18:58:41 +0200,
Marco Colombo [EMAIL PROTECTED] wrote:
Actually, that should be done each time the random() function
is evaluated. (I have no familiarity with the code, so please
That may be overkill, since I don't think that random has been advertised
as a secure or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew T. O'Connor wrote:
| Gaetano Mendola wrote:
|
| Matthew T. O'Connor wrote:
|
| Since you are running autovacuum I doubt the doing vacuumdb -a -z is 3
| times a day buying you much. It's not a bad idea to do once in a while.
|
|
|
| The reason
Referential Integrity on one of our production tables seems to have been
lost. I am running Postgres 7.1.3 embedded within Red Hat
kernel-2.4.9-e.49.
Within that I have a table with referential integrity constraints which
no longer work.
I do not know how to disable referential integrity on
I
have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server, the
other Windows XP Pro); I have Postgres up and running as a service on both
machines, no problem. Im even able to go into psql and putz around.
However, I am not able to log on remotely using pgAdmin III.
Hello,
When I attempt to run createlang plpgsql template1
I get the following error:
Error at or near createlang at character 1
Running psql 7.3.4 on redhat 9
Logged in as postgres
Verified existence of /usr/lib/pgsql/plpgsql.so
Any ideas on how to fix this problem?
Wiebe de
Jimmie H. Apsey [EMAIL PROTECTED] writes:
Referential Integrity on one of our production tables seems to have been
lost. I am running Postgres 7.1.3 embedded within Red Hat
kernel-2.4.9-e.49.
7.1 is mighty ancient, but ...
I do not know how to disable referential integrity on a column in
Taber, Mark [EMAIL PROTECTED] writes:
Error connecting to the server: could not connect to the server: Connection
refused (0x274D/10061)
That means the operating system rejected the connection, which probably
means a firewall/packet filter problem. If the request had made it as
far as the
Wiebe de Jong [EMAIL PROTECTED] writes:
When I attempt to run 'createlang plpgsql template1' I get the following
error:
Error at or near createlang at character 1
createlang is a shell script, not an SQL command. Run it from the shell.
regards, tom lane
Title: Meddelande
Make
sure the server actually listens on connections other than 127.0.0.1 - check
"listen_addresses" in postgresql.conf.
//Magnus
-Ursprungligt meddelande-Från: Taber, Mark
[mailto:[EMAIL PROTECTED] Skickat: den 4 oktober 2004
20:29Till: [EMAIL
Taber, Mark wrote:
I have Postgres 8.0-beta2 set up on two machines (one Windows 2000
Server, the other Windows XP Pro); I have Postgres up and running as a
service on both machines, no problem. Im even able to go into psql
and putz around. However, I am not able to log on remotely using
Tom Lane wrote:
Arnau Rebassa [EMAIL PROTECTED] writes:
I'm using a debian linux as OS with a 2.4 kernel running on it.
Incidentally, are you reconnecting every time or is it that multiple calls
in a single session are returning the same record?
I'm reconnecting each time I want to retrieve a
Tom Lane wrote:
"Jimmie H. Apsey" [EMAIL PROTECTED] writes:
Referential Integrity on one of our production tables seems to have been
lost. I am running Postgres 7.1.3 embedded within Red Hat
kernel-2.4.9-e.49.
7.1 is mighty ancient, but ...
I do not know
On P, 2004-10-03 at 20:24, Scott Marlowe wrote:
On Sun, 2004-10-03 at 06:33, stig erikson wrote:
Is there a tool, some add-in to apache perhaps that can run ASP code on
linux/unix, this would help to have the system running while we recode
the application.
There are a few tools I've
Thanks for your help. Over the protests of my network guys,
I did a port scan, and sure enough, port 5432 wasnt available. Also, my
.conf file was only looking for localhost. Having worked through this, now theres
something wrong with my pg_hba.conf file.
Again, thanks, all.
Mark
Jimmie H. Apsey [EMAIL PROTECTED] writes:
Each FK constraint should have three associated triggers (two on the
referencing table, one on the referenced table).
OH, that's very scary for me that triggers can vanish/be eliminated w/o
my direct action. Yes, I do now see that the triggers on my
I am trying to implement cursors using JDBC connector version
7.1b5 (postgresql-7.1b5.jar), but cant get it to work.
Could anybody suggest the proper way to do it, or even some
source code? I am stuck with this version and cant change it.
Thanks
Wiebe de Jong
Tom Lane wrote:
"Jimmie H. Apsey" [EMAIL PROTECTED] writes:
Each FK constraint should have three associated triggers (two on the
referencing table, one on the referenced table).
OH, that's very scary for me that triggers can vanish/be eliminated
On Mon, Oct 04, 2004 at 05:25:59PM -0400, Jimmie H. Apsey wrote:
I have kept up-to-date our Red Hat kernels as you can probably see from
the Linux 2.4.9-e.49smp kernel. Am I required to maintain my own
version of Postgres alongside and compiled into Red Hat's latest and
greatest kernel?
A final notewe are up and running. Thanks again
for all the help. So post mortem indicates that 1) Port 5432 was not
available, despite what our network guys told me; 2) In my rush to get things
up and running, I forgot to make relevant changes to the .conf files (problem
lay between the
On Mon, 4 Oct 2004, Wiebe de Jong wrote:
I am trying to implement cursors using JDBC connector version 7.1b5
(postgresql-7.1b5.jar), but can't get it to work.
Before saying anything else, I have to tell you to get off 7.1, especially
a beta version of it.
The first JDBC driver to have
Is there any on the site? Or I shall find in the tar file?
Mage
--
http://mage.hu
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
On Mon, Oct 04, 2004 at 11:58:53PM +0200, Mage wrote:
Is there any on the site? Or I shall find in the tar file?
It's on http://developer.postgresql.org/docs/postgres
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Este mail se entrega garantizadamente 100% libre de sarcasmo.
Alvaro Herrera wrote:
On Mon, Oct 04, 2004 at 11:58:53PM +0200, Mage wrote:
Is there any on the site? Or I shall find in the tar file?
It's on http://developer.postgresql.org/docs/postgres
Thank you. And is there some comparing 7.4 with 8.0 document? I mean a
simple new feature list
Jimmie H. Apsey [EMAIL PROTECTED] writes:
I'd recommend an upgrade to 7.4.5 at your earliest convenience.
I have kept up-to-date our Red Hat kernels as you can probably see from
the Linux 2.4.9-e.49smp kernel. Am I required to maintain my own
version of Postgres alongside and compiled
On Tue, 2004-10-05 at 09:08, Mage wrote:
Thank you. And is there some comparing 7.4 with 8.0 document? I mean a
simple new feature list or something like that.
http://developer.postgresql.org/docs/postgres/release.html#RELEASE-8-0
-Neil
---(end of
You could use Sun's ASP engine which was originally produced by chilisoft.
http://wwws.sun.com/software/chilisoft/
-Edwin
On Sun, 03 Oct 2004 11:24:28 -0600, Scott Marlowe [EMAIL PROTECTED] wrote:
On Sun, 2004-10-03 at 06:33, stig erikson wrote:
Hello.
i have an slightly off topic
40 matches
Mail list logo
