The first public beta for pgEdit is now available (see product description below). If you would like to participate in the beta program, evaluate the...

John DeSoi

11-21-2004 09:57 PM
John DeSoi

i have a table with a 'timstamp with time zone' column. when i insert into it: '18 Nov 2004 00:00:00 PST' ....it looks like: 2004-11-18...

P. George

11-21-2004 09:45 PM
P. George

I've been spending the last few days converting many databases into a single schema and have completed the process, but now I'm at somewhat of an...

Net Virtual Mailing Lists

11-21-2004 09:38 PM
Net Virtual Mailing Lists

I am wondering if it is possible to pick up a database from one computer and move it over to another and then just plug it back in. It appears that...

Kenneth Downs

11-21-2004 07:51 PM
Doug McNaught

I suspect that schemas are the best way to go, but gosh is it going to be a bear to re-engineer all this stuff... Unfortunately it was all done...

Net Virtual Mailing Lists

11-21-2004 06:18 PM
Tom Lane

I'm after a good report generator for a postgresql database. I am using Rekall at the moment which is quite good but I'm not quite able to do some...

Chris Green

11-21-2004 12:50 PM
Chris Green

Anyone know of a unit testing framework for plpgsql stored procedures? We are about to convert a bunch of stored procedures from Oracle over to...

Casey Duncan

11-21-2004 11:47 AM
Ben

--On Saturday, November 20, 2004 7:13 PM -0700 Scott Marlowe <smarlowe (AT) qwest (DOT) net> wrote: I had not thought of that. Thankfully, I don't...

Jason C. Wells

11-20-2004 09:13 PM
Scott Marlowe

Hello, I have situation where multiple databases need to use data from a common source and it would consume way too much disk space to reproduce...

Net Virtual Mailing Lists

11-20-2004 08:09 PM
Net Virtual Mailing Lists

On Fri, Nov 19, 2004 at 21:38:33 -0800, Baldeep Hira <baldeephira (AT) gmail (DOT) com> wrote: The simplest fix is to do the drop table outside of a...

Bruno Wolff III

11-20-2004 03:03 PM
Bruno Wolff III

=?ISO-8859-1?Q?Sebastian_B=F6ck?= <sebastianboeck (AT) freenet (DOT) de> writes: It's a bug. Thanks for the report. regards, tom...

Tom Lane

11-20-2004 01:01 PM
Tom Lane

I'm not sure if this is really on topic for this list but I'll start here. I'm trying to run phpPgAdmin, I've installed version 3.5, I...

Chris Green

11-20-2004 12:05 PM
Joshua D. Drake

Hello ! The RC2 is great but : I use an other filesystem for the data. So I have C:\Program file\PostgreSQL... and I have...

Secrétariat

11-19-2004 05:14 PM
GreyGeek

will an alter table that removes an oid type also remove all of the associated large objects. I've been using blobs but have converted to byte...

Jeremiah Jahn

11-19-2004 03:06 PM
Tom Lane

I share the same sequences across 3 tables and have a COPY that send data to one of those tables. That table has a before insert trigger function...

Robert Fitzpatrick

11-19-2004 02:12 PM
Robert Fitzpatrick

I posted this earlier, and got no responses. While using pg_dump and pg_restore (or attempting to restore, more precisely), the process failed...

Taber, Mark

11-19-2004 11:53 AM
Taber, Mark

I'm using PG 7.3.4 I've a table with a column of type int8 where I store date-based values, and an index exists for it. The problem is that the...

Marc Boucher

11-19-2004 10:20 AM
Stephan Szabo

I try to use lo_import and lo_export for manage large object on PostgreSQL. I found that all files must be process on server with...

Premsun Choltanwanich

11-19-2004 10:02 AM
Tom Lane

Well, yes, that's what I currently use. The dot output is very interesting, but I guess the complete database image will be 16 meters x 16 meters...

David Pradier

11-19-2004 04:34 AM
Richard Huxton

Hello. I have got old linux installation (i586 debian 2.2 kernel 2.2.19) and i can't upgrade it. My question is what version of postgres can run with...

jerzykut@poczta.onet.pl

11-18-2004 10:54 PM
Tom Lane

Helps me. Thanks for the clairification. On Wednesday 17 November 2004 06:49 am, Martijn van Oosterhout saith: -- Quote: 28 "Without question, we...

Leen Besselink

11-18-2004 09:21 PM
Jan Wieck

Hi, I am trying to import data using COPY, from a file containing thirty or so COPY commands each with 0 or more rows of data. Reason, I have...

Rachel McConnell

11-18-2004 05:25 PM
Terry Lee Tucker

Over the past couple days I started seeing errors like this in my server logs: WARNING: terminating connection because of crash of another server...

Mike Richards

11-18-2004 04:50 PM
Mike Richards

I have just installed Postgresql 7.3.4 on my slackware 9.1 system. The installation went fairly smoothly and the server process has started...

Chris Green

11-18-2004 04:48 PM
Tom Lane

On Thu, 18 Nov 2004 10:17:21 -0500, Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> wrote: Ok, it just happened again, and this is what showed up in the log...

Mike Richards

11-18-2004 10:56 AM
Tom Lane

frbn <frbn (AT) efbs-seafrigo (DOT) fr> writes: This is a 7.1-vintage pg_dump bug --- it's not putting quotes around the OID value. You really want...

Tom Lane

11-18-2004 10:51 AM
Tom Lane

hi all, we currently experience an original problem on a production server with a postgresql 7.1.3 ( a bit old, I know :\ ) We just want to know if...

frbn

11-18-2004 10:36 AM
frbn

Hi All... I'm been fighting this problem for a few days now, and it seems like it should be simple. But the solution has eluded me so far... I...

Jim Archer

11-18-2004 10:08 AM
Tom Lane

--On Thursday, November 18, 2004 3:15 PM +0900 Michael Glaesemann <grzm (AT) myrealbox (DOT) com> wrote: I had that idea too, and I have no idea....

Jim Archer

11-18-2004 01:33 AM
Jim Archer

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I had been running 7.x under cygwin (about 2 versions behind the latest cygwin has), but cygserver...

Bill Harris

11-17-2004 10:38 PM
Bill Harris

# > "Whenever a user-defined base data type is created, PostgreSQL # > automatically creates an associated array type, whose name consists # > of...

Jonathan Daugherty

11-17-2004 02:09 PM
Tom Lane

I have a view that used union all to merge three tables together. I was hoping to create a rule, one for each table using the WHERE condition of the...

Robert Fitzpatrick

11-17-2004 01:28 PM
Robert Fitzpatrick

Hi there, i have some troubles with my TSearch2 Installation. I have done this installation as described...

Timo Haberkern

11-17-2004 11:26 AM
Oleg Bartunov

Hello everyone! I have a question.. Does PostgreSQL have official certification? If yes, where can I find certification courses to get a...

Konstantin Danilov

11-17-2004 10:59 AM
Jeff Eckermann

Hi all, Is it possible to know when a row was last updated. Using 7.3.3. rgds Antony Paul ---------------------------(end of...

Antony Paul

11-17-2004 09:33 AM
Michael Fuhr

(PostgreSQL 8.0 beta 4 on Mac OS X 10.3.6) I'm working on a function which creates and populates a temporary table, then returns the number of...

Timothy Perrigo

11-17-2004 08:53 AM
Richard Huxton

Hi all I have to develop an embedded database using memory FLASH and memory RAM Some tables must be saved in RAM and some tables in FLASH ( RAM and...

Stefano Farina

11-17-2004 08:16 AM
Tino Wildenhain

Sorry, but no reply on pgsql-ports (AT) postgresql (DOT) org. ---------- Forwarded message ---------- From: Alejandro D. Burne <alejandro.dburne...

Alejandro D. Burne

11-17-2004 08:14 AM
Alejandro D. Burne

I have batch files with entries such as INSERT INTO country VALUES (248,'ALA','AX','Åland Islands'); INSERT INTO country VALUES...

matthias@cmklein.de

11-17-2004 06:53 AM
Magnus Hagander

I have a table that is essentially a log where new entries are streaming in continually and from time to time I throw old entries away to keep the...

Nils Rennebarth

11-17-2004 06:41 AM
David Helgason

On Wed, 10 Nov 2004 08:11:01 -0800 (PST) Jeff Eckermann <jeff_eckermann (AT) yahoo (DOT) com> wrote: Thanks. I'll look in the...

Liviu BURCUSEL

11-17-2004 06:29 AM
Martijn van Oosterhout

Long and rambling question, here -- we have a customer with a database that is outgrowing their original storage, and they want to upgrade storage as...

Joel

11-17-2004 03:55 AM
Joel

Hi all, I was hoping someone might be able to set me straight so that I can get some select performance improvements. The table in question has...

Harvey, Allan AC

11-16-2004 09:45 PM
Michael Fuhr

I have to execute fairly large batch files (200-300MB) with several million INSERT commands. When I do that from pgsql using the \i switch, I get...

matthias@cmklein.de

11-16-2004 08:27 PM
Michael Fuhr

Hy i have a problem with the following statement: SELECT MAX(id) FROM apconfig; if i send this statement i got the following error: ERROR:...

Sandro Daehler

11-16-2004 08:05 PM
Michael Fuhr

I'm working on a plpgsql function that creates and populates a temporary table. I would like the function to first drop the temp table, if it...

Timothy Perrigo

11-16-2004 04:54 PM
Timothy Perrigo

Hello, I'm working on a datatype which I call dnaseq. The basic stuff like input/output functions, comparison operators, etc., work well. I have...

Troels Arvin

11-16-2004 04:12 PM
Troels Arvin

guenter strubinsky <strubinsky (AT) acm (DOT) org> writes: None of this is coming from actual list members. As far as I can tell, it's just one...

Weiping

11-16-2004 01:29 PM
Tom Lane

I am creating a database which is supposed to contain many data entries (events) that differ only in the date they occur. So let's say event 1...

matthias@cmklein.de

11-16-2004 01:11 PM
Csaba Nagy

Karim.Nassar (AT) NAU (DOT) EDU (Karim Nassar) writes: The "problem" is that this requires modifications to the application, and communicating...

Ed L.

11-16-2004 12:02 PM
Richard_D_Levine@raytheon.com