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
i
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
joi
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 datab
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 alt
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 featur
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 ch
"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
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 6G
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 t
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 secur
-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.
|>
|>
|>
|> Th
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 a
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. I’m even able to go into psql and putz around.
However, I am not able to log on remotely using pgAdmin III. When
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?
W
"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 col
"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
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 PROTE
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. I’m even able to go into psql
and putz around. However, I am not able to log on remotely using
pgAdm
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 retriev
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
"D. Stimits" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Hmm. postmaster.c does this during startup of each backend process:
>>
>> gettimeofday(&now, &tz);
>> srandom((unsigned int) now.tv_usec);
> If it uses the same seed from the connection, then all randoms within a
> connect that has n
Thanks for your help. Over the protests of my network guys,
I did a port scan, and sure enough, port 5432 wasn’t available. Also, my
.conf file was only looking for localhost. Having worked through this, now there’s
something wrong with my pg_hba.conf file.
Again, thanks, all.
"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 trigg
I am trying to implement cursors using JDBC connector version
7.1b5 (postgresql-7.1b5.jar), but can’t 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 can’t 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 note…we 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 curs
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 ()
Este mail se entrega garantizadamente 100% libre de sarcasmo.
---(end of broadca
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 co
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 broadcast)
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 qu
Hi:
After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
are having intermitent issues with certain online PHP transactions,
returning this error:
"Warning: pg_exec() query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block"
Half th
42 matches
Mail list logo