Well that's odd, since 7.2 has a pg_user table. hrm... On Wed, 2 Jul 2003, S.Peppe wrote: ---------------------------(end of...

scott.marlowe

07-02-2003 10:40 AM
S.Peppe

hi, fairly new to postgres admin stuff...... i have a production machine that is running postgresql 7.1.3 also, there's a test machine which...

andy morrow

07-02-2003 10:16 AM
andy morrow

Hi, I've a problem with some of my stored procs. My config is: RH7.1, Postgres 7.3.2 I have converted a few fields of a few tables from one type to...

Együd Csaba

07-02-2003 05:53 AM
Együd Csaba

I think anything longer than some number, either 256 or 512, is interpreted as memo datatype, in which case you could truncate the excess part of the...

Fernando Flores Prior

07-02-2003 05:08 AM
btober@seaworthysys.com

Hi, Will it be a good idea for vacuum command to allow vacumming specific schemas? eg we have a schema for archiving purposes which we do not want...

Rajesh Kumar Mallah

07-02-2003 03:32 AM
Rajesh Kumar Mallah

Hi all, I am writing a pl/psql function with a temp table right now. It creates the temp table inside. Whenever I call this function in a session for...

Harry Yau

07-02-2003 03:13 AM
Harry Yau

Hi all, I am writing a pl/psql function with a temp table right now. It creates the temp table inside. Whenever I call this function in a session for...

Harry Yau

07-02-2003 03:06 AM
Harry Yau

Hi there! I'm really new at this game, so please forgive me if my request is at all irritating. I have installed PostgreSQL onto a Debian/Linux...

S.Peppe

07-02-2003 02:56 AM
S.Peppe

Welcome to the light. Ulisses Ponticelli Giorgi wrote: So (not really related to the preceding statement), you will have to rewrite your Stored...

DeJuan Jackson

07-02-2003 02:01 AM
Shridhar Daithankar

--- Bruno Wolff III <bruno (AT) wolff (DOT) to> wrote: I solved it by using pgAdminII remotely through ssh port forwarding. I'm curious though, as...

Rudy Koento

07-01-2003 11:03 PM
Rudy Koento

I do the following as the user "postgres" alberts=# CREATE FUNCTION foobar(CSTRING) alberts-# RETURNS opaque alberts-# AS '$libdir/mystuff' ,...

Chris Albertson

07-01-2003 09:57 PM
Joe Conway

If you link to a library on your system that is not in your library path, you will get this problem. The solutions is basically one of: - Create a...

Martijn van Oosterhout

07-01-2003 09:16 PM
Martijn van Oosterhout

On Tue, Jul 01, 2003 at 07:03:35PM -0400, Rich Cullingford wrote: Well, it's quite simple: stop the postmaster, do a "make install" (or whatever...

Alvaro Herrera

07-01-2003 07:13 PM
Alvaro Herrera

We've had a 7.3 PG installation running for awhile now, and would like to upgrade to 7.3.3. The doc implies that you can do something other than dump...

Rich Cullingford

07-01-2003 07:03 PM
Rich Cullingford

Its setup and ppl have been using it to read news ... can you confirm the IP/hostname you are trying to connect from? So that I can check the...

The Hermit Hacker

07-01-2003 06:34 PM
The Hermit Hacker

The query that I'm trying to execute is as...

Christoph

06-29-2003 12:18 PM
Christoph

I have a text file caled db_def.sql. Right now (during initial development of a site) it looks kinda like this: DROP TABLES AND SEQUENCES...

Alexander Ross

06-27-2003 07:12 PM
Alexander Ross

He wants SUPPORT? Try PostgreSQL, Inc. The are in Nova Scotia and offer 24/7/365 support if you need it. "Simon Ashford" <simon (AT) netlinkdata...

Hal Davison

06-26-2003 07:22 PM
Hal Davison

I'm not going to bore you with the what's, why's and where for's and I'm not looking for the suggestion of upgrade the other server. I have a server...

Simon Ashford

06-26-2003 04:32 PM
Simon Ashford