What does it mean when you drop a database and then recreate with the same name and all the objects are still there. I want to wipe out the db and...

Robert Fitzpatrick

11-11-2004 04:14 PM
Tom Lane

Hi, We have an app which uses the latest version of perl DBI and DBD::Pg to execute a query, using placeholders. It fails to cast the float I...

Tom Larard

11-11-2004 03:15 PM
Greg Stark

Dear PostgreSQL experts, This is with version 7.4.2. My database has grown a bit recently, mostly in number of tables but also their size, and I...

Phil Endecott

11-11-2004 02:14 PM
Tom Lane

Lionel Lauer UPDATED HOME ADDRESS: 58 Gore Street Fitzroy, Victoria Australia 3065 UPDATED HOME NUMBER: (03) 9419 0533 Same mobile number: (0419)...

gsstark@mit.edu

11-11-2004 01:50 PM
Richard Welty

What is the relationship between the "-d" parameter to postmaster and the various "log_*" directives in the postgresql.conf? Specifically, does a...

David Parker

11-11-2004 01:32 PM
Bruce Momjian

We are starting to ramp-up testing of our application, and we started getting these messages in our log file: LOG: checkpoints are occurring too...

David Parker

11-11-2004 09:49 AM
David Parker

Greetings. Is it possible to modify a foreign key constraint and force it to cascade on update? If there is no such SQL command, then is it...

Oleg Lebedev

11-11-2004 09:42 AM
Stephan Szabo

Hi, Just spotted it on LinuxToday. I don't think there would be many 8-way configurations for opterons out...

Shridhar Daithankar

11-11-2004 07:16 AM
Shridhar Daithankar

On Thu, Nov 11, 2004 at 08:13:16AM +0100, Bjoern Platzen wrote: The foreign key constraint on T_OEPNV_HST_LIN.HST_NR references the wrong field in...

Michael Fuhr

11-11-2004 03:34 AM
gnari

On 7.4.6 and earlier, we use apache's log rotation program as follows: pg_ctl start | rotatelogs ... If we have a configuration failure, say a bad...

Ed L.

11-11-2004 02:13 AM
Ed L.

I'd like to propose that certain GRANTs on a table cascade to the table's implicit sequences. In the current implementation (as of 7.4.5 and...

Michael Fuhr

11-10-2004 11:44 PM
Bruce Momjian

It is ok. I fetch the row with no problem. The error is only in update types like updateString , updateRow, updateInt... ps.You are right JDBC list...

Suha Onay

11-10-2004 11:24 PM
Kris Jurka

I am proposing some new changes for this list. 1) Black spook jiggaboo watermelon-eating niggers may not post 2) Penny-pinching Jewish kikes may...

Mike Cox

11-10-2004 09:56 PM
Marc G. Fournier

From the 7.4 docs: A column can be referenced in the form correlation.columnname correlation is the name of a table (possibly qualified with a...

John Fabiani

11-10-2004 07:23 PM
Tom Lane

I have a database with a btree index on the 'removed' field, which is of type 'date'. However it isn't being used: techdb2=> explain select * from...

Miquel van Smoorenburg

11-10-2004 06:05 PM
Miquel van Smoorenburg

Yeah.. I'm with you.. I don't really know what all of this is about - I like the way the Postgres mailing list works as it is.... Are any of...

Net Virtual Mailing Lists

11-10-2004 06:01 PM
Net Virtual Mailing Lists

Cheers, I have a problem with postgresql7.4.1 on a SuSE machine. I use the database for a C#-application for a small company to store their clients,...

Jonathan Weiss

11-10-2004 05:25 PM
Jonathan Weiss

Hello, I get an error in my log when connecting to postgres server on Windows. Postgres version : 8.0.0-beta4 LOG TEXT 2004-11-10 11:22:47 LOG: ...

Goutam Paruchuri

11-10-2004 04:23 PM
Russell Smith

Look it at: ~/usr/local/pgsql Libs: ~/usr/libs/postgresql Francisco Jose Bernabe Pellicer wrote: ---------------------------(end of...

Sídar LC

11-10-2004 03:48 PM
Sídar LC

My understanding was it means ip range of 1 to 254. 192.168.2.1 to 192.168.1.254 Confidentiality Notice The information contained in this e-mail...

Goutam Paruchuri

11-10-2004 01:41 PM
Tom Lane

Is it possible to undo a transaction after it has completed (using 8 beta1) ---------------------------(end of...

mike

11-10-2004 10:39 AM
Peter Eisentraut

I've had it up to my testicles with this fucking RFD. I can't take it no more. Somebody really needs to take over for me. God damn...

Mike Cox

11-10-2004 10:25 AM
Marc G. Fournier

Hi all. I'm working (well, rather, reworking) a database schema that, in part, models a company organizational structure. For...

Michael Glaesemann

11-10-2004 10:20 AM
Robert Treat

Hey Mike Cocks!!! Kiss my bullocks you bloody wanker! Go bugger off and take your yank arse to Burger King, you uncultured American cretin. Twits...

Oliver Elphick

11-10-2004 10:03 AM
Holger Klawitter

Hi, I'm using PostgreSQL 8. I have two tables that I am doing a join on, and the join executes very slowly. The table called Notification has a...

Mike Wertheim

11-10-2004 06:20 AM
Martijn van Oosterhout

I was going to write something similar, but seeing as you got there first, 'I agree!' Regard,s dave ---------------------------(end of...

Dave Page

11-10-2004 03:27 AM
Dave Page

Hi, I've got clients connected to pgsql via ODBC. If they lose their connection abruptly, all un-committed transactions are automatically...

A. Mous

11-09-2004 10:15 PM
David Helgason

Hi! My 8.0beta2 database was initialized with option "-E UNICODE". Psql sets client encoding to Big5: database1=# \encoding big5 I get this error...

CN

11-09-2004 08:44 PM
CN

When i write code in C to create the functions that define a new data type, how can i set a value so that the user sees a null value...

Alexander Cohen

11-09-2004 08:43 PM
Michael Fuhr

Sigh, I can't read what I write... The correct homepage for PgBrowse is: http://homepage.mac.com/levanj/TclTk I guess the correction was probably...

Jerry LeVan

11-09-2004 07:34 PM
Jerry LeVan

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 A bad link in the ftp source directory inspired me to check the rest of it out: * Main README file...

Greg Sabino Mullane

11-09-2004 07:25 PM
Greg Sabino Mullane

On Tuesday November 9 2004 1:37, Tom Lane wrote: Just realizing we do start multiple postmasters under same user id when upgrading a cluster (one on...

Ed L.

11-09-2004 07:20 PM
Ed L.

The Bricolage development team is pleased to announce the release of Bricolage 1.8.3. This maintenance release addresses quite a large number of...

David Wheeler

11-09-2004 06:56 PM
David Wheeler

Hi folks. I'm creating a database using the following command: createdb -U pablo -W pablotest1 I'm prompted to enter the password to create the...

Pablo Gosse

11-09-2004 04:38 PM
Tom Lane

I'm wrestling with tracking down a deadlock. Here's a 7.4.6 deadlock message: ERROR: deadlock detected DETAIL: Process 15655 waits for ShareLock...

Ed L.

11-09-2004 03:48 PM
Ed L.

PG: 7.4.5 RH 7.3 Vac_Mem=12mg Doing a Vacuum Analyze on a table and it's been hanging for at least 2 hours. I could see no other users hitting the...

Patrick Hatcher

11-09-2004 03:03 PM
Patrick Hatcher

PgBrowser is a postgresql database browser written in a more or less platform independent fashion. I appears to work in a Mac OSX environment, Linux,...

Jerry LeVan

11-09-2004 01:05 PM
Jerry LeVan

I've made some functions, an i want these functions to be used by a specified user, but i don't want this user can see the code of the functions....

Tk421

11-09-2004 12:33 PM
Tk421

I have a simple function which I use to set up a users' expiry date. If a field in a table contains an interval then this function returns a...

Ron St-Pierre

11-09-2004 12:07 PM
Ron St-Pierre

Hi I'd like to know if there is a way to specify different transaction isolation levels for different tables in the db. The reason i'm asking this...

Florian G. Pflug

11-09-2004 05:23 AM
Martijn van Oosterhout

I need help to connect DBDesigner4 linux in ODBC to postgres. I'm having a problem connecting to a remote Postgres db using ODBC from my Debian...

Eric

11-09-2004 03:23 AM
Eric

Is there a visual designer (open source) in linux for database? I would like to developp my data model on the computer... I see "dia" with uml...

Eric

11-08-2004 11:12 PM
Gary G. Taylor

Is there a way to create an index that would make this query be efficient and not perform a sequential scan? SELECT count(*) AS count,id FROM...

Net Virtual Mailing Lists

11-08-2004 09:18 PM
Bruno Wolff III

Hi guys, I'm wondering what the easy way to grant user/group access on all tables in a db. I just migrated about 200 tables from my MySQL database...

Kenji Morishige

11-08-2004 08:44 PM
Michael Fuhr

Hello everyone, I have received any error message in my Postgres error log as follows: "The Postmaster has informed me that some other backend died...

Bob Powell

11-08-2004 07:58 PM
Tom Lane

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Mon, 1 Nov 2004, Marcel Gsteiger wrote: python-2.2.3-5 should have distuils module...

Devrim GUNDUZ

11-08-2004 06:12 PM
Devrim GUNDUZ

Mike Cox <mikecoxlinux (AT) yahoo (DOT) com> wrote in news:2va7aaF2jfll7U2 (AT) uni-berlin (DOT) de: You frighten me. ;-) -- Bill

Woodchuck Bill

11-08-2004 04:50 PM
Woodchuck Bill

Hello, 2 questions ! Question 1 Iam trying to load binary data from sql server to postges. Do i have to write a script .. ?? Question 2 How i...

Goutam Paruchuri

11-08-2004 02:55 PM
Goutam Paruchuri

Why can you not use simple insert statements (sql insert). Copy is meant to transfer large amount of data from text files to databases and vice...

Goutam Paruchuri

11-08-2004 02:04 PM
Goutam Paruchuri

I have a CSV file with 400,000 lines of email mailing list information that I need to migrate to a new PostgreSQL database. Each line has all the...

Hunter Hillegas

11-08-2004 01:54 PM
Goutam Paruchuri