What packages do I need for PostgreSQL 7.xx? I went to rpmfind.net and there
were too many files. I am running a Pentium. Can someone please tell me what
packages I need to install POstgreSQL 7.xx.
P.S I am going to have a fresh install
Thanks
When stress test Postgres, It can only hold about 200 cocurrent connection
while keep calling DriverManager.getConnection()
Is this number configurable? Or it is the limitation of postgres?
Any suggestion?
Thanks
Feng
On Fri, 2 Feb 2001, Michael Miyabara-McCaskey wrote:
Francisco,
Excellent idea.
Thanks for the info. Is this what you are doing now? And if so, since the
current version does not appear to have replication, have you found a
workaround?
-Michael
I am new to PostgreSQL so I haven't
I'm having a problem doing a select on an Order with a where clause below,
getting a preparedStatemtnt and calling
preparedStatement.setObject(timeStamp);
Its return nothing and I know there is a row with that orderDate.
SQL: select
hi,
can anyone help me ? i need to convert a ms access .mdb file into
somthing readable so i can insert it into my postgreSQL db...
does anyone have any experiance? (preferably using PHP)
Robert Korteweg
The Netherlands
export the .mdb file in comma seperated format and import in
On Tuesday 6 February 2001, at 10 h 50, the keyboard of DaVinci
[EMAIL PROTECTED] wrote:
I have tried to install experimental Debian packages of Postgresql
7.1beta4, but get a dependency error with libssl09.
My system is Debian inestable.
You mean 'unstable' :-)
The PostgreSQL version
Hi,
How can I extract parts (e.g. month or day) from date values?
--
Hubert Palme
[EMAIL PROTECTED]
Hi John,
It can't find one of the header files it needs to compile that file. I
looked around and cannot find the header containing the definition of
va_args anywhere -- these developers will know.
Did you download gcc for Solaris 8 as a binary or package?
If so,
Bad idea -- and here's why:
Dear,
I am trying to design a database in SQL Server ver7, using
relationships between tables so that when I enter data in a particular
field in one table, it will update a related field in another table.
Also apply to deleting inserting fields.
I have set up the tables their relationships but
The best one I like is pgaccess, but it does not support Copy/Paste.
Hopefully it will later on!
Check out: http://flex.flex.ro/pgaccess/
Art Taylor wrote in message
[EMAIL PROTECTED]...
Can anyone tell me what open source GUI clients are available for
PostgreSQL
and where they can be
Tim Barnard:
The program '/usr/local/pgsql/bin/postgres' needed by initdb does
not belong to PostgreSQL version 7.1beta4. Check your installation.
Any ideas?
Yes, happened to me, too. You need not to be root, but an unprivileged
user (i.e. postgres). That's the strangest error message in a
DaVinci wrote:
I have tried to install experimental Debian packages of Postgresql
7.1beta4, but get a dependency error with libssl09.
My system is Debian inestable. I have a installed package of name
libssl096, but dependency is broken.
What is the problem?. Thanks.
Has anyone had any luck interfacing StarOffice to PostgreSQL using JDBC?
Here is what I have tried:
1. Created a pgsql database called test2 on our linux machine (rh
6.2/postgresql 7.0.3).
2. Placed the jdbc7.0-1.2.jar file in the class path on my windows machine
and renamed it to
Is there any idea of when is PostgreSQL 7.1 going to be released?
Thanks in advance,
Roberto "Wolfox" Amorim
Hi!
You know, does Psql support for 4GL anyway?
This is a good opportunity to promote PostgreSQL and I think we
should utilize it. I'm not sure I'll have a chance to take part
in the conference, but I'd like somebody describe GiST extension and
presents tutorial how to use it. We could prepare some materials and
examples from real life. I
I am trying to design a database in SQL Server ver7, using
Can anyone PLEASE HELP??
Possibly, but you'd be more likely to find an answer on an SQL Server
mailing list. This list is for the PostgreSQL database.
Greg
Hi there,
I would like to do a query in order to retrieve a complete row
of a table maching a number of requirements being stored
in another table. The best I could think of was:
select
x.id, x.1, x.2, ..., x.30
from
x, y
where
x.id = y.id and x.name like 'bla%'
As soon as its ready? :)
Seriously, we did a beta4 just before Linuxworld, and should be doing a
beta5 relatively shortly as things have starrted to quiet down ... Thomas
has his "two weeks grace" for docs, which will most likely start on the
15th of Feb, so we're looking at March 1st for a
Well you wouldn't want to start building these kind of rules in your
application - better to have them in the search engine. The fulltextindex
in the contrib package does of course not offer anything like this, it
would be nice to see a third party addon provide fulltext capabilities for
On Thu, Feb 01, 2001 at 11:23:53AM +0700, [EMAIL PROTECTED] wrote:
2. How to startup postgres with NT startup?
The (klugey) procedure I used to setup up PostgreSQL as an NT service
is documented in
http://www.ontosys.com/reports/postgresql.html
I've since patched a version of ipc-daemon so
Alfonso Peniche [EMAIL PROTECTED] writes:
NOTICE: plpgsql: ERROR during compile of registrarconexion near line 1
"RROR: parse error at or near "
The overwriting of the initial "E" suggests that the thing is
trying to complain about a carriage return (\r). Probably you
saved your script from
Two other widely used GUI interfaces are hosted at GreatBridge.org:
PgAdmin is a Windows-based GUI:
http://www.greatbridge.org/project/pgadmin/projdisplay.php
phpPgAdmin is a cross-platform Web-based GUI:
http://www.greatbridge.org/project/phppgadmin/projdisplay.php
They're both
"Mark Alliban" [EMAIL PROTECTED] writes:
I am having problems with the number of open files on Redhat 6.1. The value
of /proc/sys/fs/file-max is 4096 (the default), but this value is reached
with about 50 ODBC connections. Increasing the file-max value would only
temporarily improve matters
Hello
A few weeks ago I was interested in this question. My results were:
- Yes, this is a sorrowful but true fact that if you enable access to
someone to a database, she is automatically enabled to create
objects in it.
- Yes, the developers know it, and they said: there is a patch
Hi,
I'm fairly new to PostreSQL, coming from MySQL. My Python application
generates these MySQL commands:
drop database if exists Foo;
create database Foo;
use Foo;
Using the PostgreSQL online docs, my closest translation is:
drop database Foo;
create
I'm fairly new to PostreSQL, coming from MySQL. My Python application
generates these MySQL commands:
drop database if exists Foo;
create database Foo;
use Foo;
Using the PostgreSQL online docs, my closest translation is:
drop database Foo;
create database Foo;
You supply the database
Hi all,
I am the super user of my DBMS and if create a database for a simple user,
I do :
= create database formyuser;
But If this user connects to the database and tries to create a table, he
has no rights. I must (the super user) create the table for him and then
give him all the permissions
On Tue, 6 Feb 2001, Tressens Lionel wrote:
I am the super user of my DBMS and if create a database for a simple user,
I do :
= create database formyuser;
But If this user connects to the database and tries to create a table, he
has no rights. I must (the super user) create the table for
On Wed, 31 Jan 2001, Raymond Chui wrote:
I have three tables:
CREATE TABLE table1 (
idchar(8) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE table2 (
idchar(8) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (id) REFERENCES table1 (id) ON DELETE CASCADE
);
CREATE TABLE
Any suggestions on how to select a random record from
any given table?
Culley
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
"Mitch Vincent" [EMAIL PROTECTED] writes:
Well, the search engine isn't the database, IMHO. The search "engine" is
your application... The database will go get anything you tell it to, you
just have to know how to tell it and make sure that your application tells
it in the correct way.
Greetings.
I have a smallish sized database that's getting alot of update transactions
to it. It's been running fine over the past several weeks, but suddenly I'm
starting to see :
NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause.
NOTICE: current transaction is
I've been thinking on some new pesudo-types like SERIAL.
1) LAST_MODIFIED is the timestamp of that last time this row was
modified. Easy enough to do currently with triggers.
2) TIME_CREATED is the timestamp of when this row was first created with
an INSERT. I'm not sure how to do this because
At 03:43 PM 2/6/2001 -0500, Joseph Shraibman wrote:
I've been thinking on some new pesudo-types like SERIAL.
1) LAST_MODIFIED is the timestamp of that last time this row was
modified. Easy enough to do currently with triggers.
2) TIME_CREATED is the timestamp of when this row was first created
Can this be done in the framework of plpgsql? I know
I can do it in the front end (java) but it would be
nice to aviod having to grab the rowcount first. I
haven't seen a random function in the documentation.
I could install another language but boy am I lazy :)
--- Mark Lane [EMAIL
36 matches
Mail list logo