[EMAIL PROTECTED] writes:
>This is a multi-part message in MIME format...
>
>=_972603822-62422-5
>Content-Type: text/plain
>Content-Disposition: inline
>Content-Transfer-Encoding: binary
>Content-Description: Index
>Mime-Version: 1.0
>X-Mailer: MIME-tools 5.316 (Entity 5.212)
>
>Postg
Oops, sorry!
David
Bruce Momjian wrote:
> Trond Eivind Glomsrød wrote:
> > How compatible with 7.0 and 7.1 be from an application standpoint?
> > Will applications linked with libraries from 7.0 be able to talk to
> > the 7.1 database? Any changes in library major versions? The other
> > way?
> Historically, all
Did massive amounts
of searching and read Tom Lane's post regarding the subject, but that was dated
January of 1999. Was wondering if anyone know if there was any progress on
the issue and what the resulting outcome was.
Is there a way to
select distinct on one column and sort by another?
Steve Wolfe wrote:
> > Then upgrade the RPM's. It isn't hard.
> OK, here's a situation. One of the programmers at your company runs the
> disk out of space. You're going to go bonk him on the head, but first,
> there are more pressing matters. PostgreSQL 6.5 has horked up the tables,
> and
Hello,
upon making a call to ResultSet.getBigDecimal(String column_name) I get an
SQLException with the following message:
This method is not yet implemented.
Can this be ? getBigDecimal() is vital to most JDBC applications because it
is widely used as the primary key datatype.
I use the JDBC dr
-Original Message-
From: Brook Milligan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 4:05 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] index problems
I am getting the following messages when I VACUUM ANALYZE:
NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX
But I think he wants to know how to have 3 different databases in three
different locations.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Wade D. Oberpriller" <[EMAIL PROTECTED]>
To: "Brian C. Doyle" <[EMAIL PROTECTED]>
Cc: "general-help postgr
On Thu, Oct 26, 2000 at 10:14:13AM -0200, danyele wrote:
> Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
> user 'password=' is not in 'pg_shadow' in lib.inc.php on line 121
> Error - /www/servers/phpPgAdmin/index.php
What is on line 121 in lib.inc.php?
It seems you haven't
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 9:48 AM
To: danyele
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] phpPgAdmin
On Tue, 24 Oct 2000, danyele wrote:
> I'm trying to use phpPgAdmin, but it's showing a error like" Fa
>From root Thu Oct 26 14:44:32 2000
Received: from storage.network.com (storage.network.com [129.191.1.4])
by anubis.network.com (8.9.3/8.9.3) with ESMTP id OAA05733
for <[EMAIL PROTECTED]>; Thu, 26 Oct 2000 14:44:29 -0500 (CDT)
Received: from bush.rutgersinsurance.com (rutgersinsu
-Original Message-
From: Dominic J. Eidson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 5:10 PM
To: Robert Kernell
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] three things
On Tue, 24 Oct 2000, Robert Kernell wrote:
> 1.) Can someone point me to the Postgres User's Manua
To all,
I can't figure out how to provide access controls to individual
database files/regulate 'user's access to adding tables, etc... The
documentation says 'Someone needs to write this section.' Help!!!
-Robert
> Hmm so, if the local administrator wants to compile the source, it
>should go in /usr/local. If he wants to use a package manager, it should go
>somewhere else? Seems either pedantic or silly to me.
Perhaps, but such is how the FHS came out. FWIW, SCO (what I work on daily)
seems to res
-Original Message-
From: Frank Miles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 1:56 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] newbie debugging pl/pgsql : better way?
I have a simple function that isn't working. I've enabled debugging,
but the error message is still
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> On Wed, 25 Oct 2000, Holger Klawitter wrote:
>
> > Pawel Wegrzyn wrote:
> > >
> > > Hi,
> > > What is the latest version of PostgreSQL?
> > > Is there something like 7.1?
> >
> > The most recent version 7.0.2. 7.1 is about to come - I am looking
>You may want to use persistent connections, also.
Almost certainly you don't. The discussion sites are full of complaints that it
doesn't work properly. There is a tendency for the connections to not get reused, but
not released, either, such that you quickly run out of connections. This is
Which version of the driver are you using?
There's a problem with DatabaseMetadata.getTables(). As I'm rewriting all
the queries in that class on Saturday, this should dissapear in 7.1.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: [EMAIL PROTECTED]
WWW: htt
On Thu, 26 Oct 2000, danyele wrote:
> Brett and Ron said to me to rebuild php with the --with-pgsql option
> in the configuration step.
>
> I've already did what you recommend but another warning is appearing!
>
> Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
> user
You must use initlocation to initialize the location and have the path to the
location in an environment variable before postmaster is started.
For example:
> setenv PGDATA2 /home/someuser/data
> initlocation 'PGDATA2'
> pg_ctl -D /home/pgsql/data start
> createdb mydb -D 'PGDATA2'
This will st
How can I modify pgsql source to remove case-sensitive for query like this
one :
select "ARG1" from "TABLE1"
select "arg1" from "table1"
referer to the same table's name and argument's name ?
> Red Hat is a distribution. It should not put anything in /usr/local,
> which should be reserved for the _local_ adminstrator's use.
Hmm so, if the local administrator wants to compile the source, it
should go in /usr/local. If he wants to use a package manager, it should go
somewhere el
> > The last thing that a system admin needs when upgrading PostgreSQL is
"Oh,
> > crap, I forgot to uninstall the RPM of the old one first."
>
> Then upgrade the RPM's. It isn't hard.
OK, here's a situation. One of the programmers at your company runs the
disk out of space. You're going t
The problem is that you can't share the same port for different instance of
postmaster.
Start postmaster with the option -p can help. so,
$ nohup postmaster -i -p 5432 -D /home/user/database &
$ nohup postmaster -i -p 5433 -D /home/user1/database &
$ nohup postmaster -i -p 5434 -D /home/user2/dat
set digest
> No, I'm sorry, but there is no core file.
>
> You're probably running one of those setups where the postmaster is
> started with a ulimit setting that prevents core dumps. You might
> want to look into changing that for future debugging purposes.
Yes, you are right, I changed it in /etc/profi
On Thu, Oct 26, 2000 at 10:14:13AM -0200, danyele wrote:
> Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
> user 'password=' is not in 'pg_shadow' in lib.inc.php on line 121
> Error - /www/servers/phpPgAdmin/index.php
Yes. You've passed the username and password incorrect
> The last thing that a system admin needs when upgrading PostgreSQL is "Oh,
>crap, I forgot to uninstall the RPM of the old one first."
If you're switching from RPM to compiling source, that's your own damn
fault. If you're upgrading (rpm -U) then that isn't a concern, as it does it
for you.
Hi,
Brett and Ron said to me to rebuild php with the --with-pgsql option
in the configuration step.
I've already did what you recommend but another warning is appearing!
Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
user 'password=' is not in 'pg_shadow' in lib.inc
I 'm triyng to use JDBC driver with PostgreSQL, but I don't see the Indexes
of the tables.
Why ?
Hi, I have a par of questions.
1) I've read alot abot the 8K row limitation on pgsql. What would happen if I
had a table defined with two columns, one serial and the other TEXT, and in
one insert the texct that goes in the column with type TEXT has 80K or even
more?
2) Is it posible to storag
set digest
32 matches
Mail list logo
