Rob, The problem is our last release coincided poorly with the Potato (or was it Woody?) release of Debian. As a result, the PostgreSQL offered...

Rob Mosher

02-04-2004 09:33 PM
Rob Mosher

Thanks to all for your replies, you have helped me sort out the problem! Regards Janet

Bantamess

02-04-2004 12:51 PM
Bantamess

Thanks to all for your replies, you have helped me sort out the problem! Regards Janet

Janet Cullen

02-04-2004 12:48 PM
Janet Cullen

Hello can any body tell me how to code a table with dual primary keys? The table 'borrower' has two PKs each one has been used in other tables within...

Bantamess

02-04-2004 12:31 PM
Josh Berkus

Hello, In my query: select * from experimentinfo where expid='1'; here data type of expid is int. My question is: if I change expid ='xyz', error...

LIANHE SHAO

02-04-2004 09:22 AM
george young

Hi, I'm trying to get a list of all the rows in the Parts table, with the integer indexes of man_id, case_id, and desc_id, replaced with text from...

Russell Shaw

02-03-2004 05:48 PM
Nabil Sayegh

Hello, I've installed redhat enterprise 3 on a system to use as a db server. Manually I can install and run postgresql 7.3 (the one on the...

Remi

02-02-2004 04:30 PM
Christian Armeanu

Thiemo Kellner <thiemo (AT) thiam (DOT) ch> writes: It's not trying to insert a row of nulls; it's simply not inserting any row at all. The...

Thiemo Kellner

02-02-2004 09:24 AM
Iandé Coutinho

hi, this simple update closes the connection. I use the database to dynamically update titles and directory on my web pages. I show table...

joseph speigle

02-01-2004 05:27 PM
Tom Lane

I sent this one a little over a week ago, hadn't seen it posted yet, and was just wondering if it got lost in the fray...? Thanks for your...

Lynn.Tilby@asu.edu

02-01-2004 02:18 PM
Tom Lane

hi, I can't seem to find the comment for an sql file drop function dups(); -- joe speigle -- Feb 1 2004 CREATE FUNCTION dups() RETURNS int4 AS...

joseph speigle

02-01-2004 11:16 AM
Tom Lane

If I insert a large amount of data into a Postgres table, so that the data file (or files) grow by a large amount (something in the gigabyte range),...

Lawrence Smith

02-01-2004 11:00 AM
Lawrence Smith

Hi, Is there a way to make postgresql report an error if when inserting data, a multiple-column combination is duplicated? CREATE TABLE...

Russell Shaw

02-01-2004 04:46 AM
Russell Shaw

Hi all, I'm using the PostreSQL30 ODBC driver to hook a Windows app to a 7.4.1 PostreSQL DB. Might be the driver, or it might be the app itself (I...

Michael J. Conroy

01-31-2004 07:08 PM
Tom Lane

On Wed, 28 Jan 2004, Ben Burkhart wrote: Well, you'd probably be best off writing a function to go over the rows or doing this in a front...

Stephan Szabo

01-31-2004 12:06 PM
Tom Lane

Hi, I need to develop my database so when a record is entered through a browser, it will automatically email a list of interested parties. I am ok...

Nick Tew

01-31-2004 02:18 AM
Derrick Betts

Hello All, I'm a virgin newbie to Linux and PostgreSQL but have very much experience in - (whispered) sssh, Windows. I have downloaded the Red Hat...

Phil Seretti

01-30-2004 05:42 PM
Markus Bertheau

George Weaver <gweaver (AT) shaw (DOT) ca> writes: PostgreSQL uses the OS clock for date/time issues. If you can change the date on your system,...

Manuel Sugawara

01-29-2004 01:00 PM
Tom Lane

I have an application that will only ever run locally on a development box. The application writes a text file to the hard drive, and then issues...

Alan T. Miller

01-29-2004 08:14 AM
Bruno Wolff III

Hi all, Could I have guidelines on how to store and display (generic ?) Russian characters right, and Spanish as well, for that matter, alongside...

Aarni Ruuhimäki

01-29-2004 06:44 AM
Aarni Ruuhimäki

Hi, How can I install PostgreSQL 7.4 in a directory other than the --prefix directory without having to recompile the code. Note that, I have...

Saket Bagade

01-29-2004 06:40 AM
Saket Bagade

I have switched identification method from 'trust' to 'md5' for all local requests, ie: - local all all trust + local all all md5 But that creates...

Marcin Gil

01-28-2004 02:01 PM
Bruno Wolff III

Guys & Gals What is the best way to get a list of tables in a database? Is there a syntax for getting from the database after I connect or do I have...

Marcel Wolf

01-28-2004 11:33 AM
George Weaver

I have written a pl/pgsql function as follows: create function aufloesung(varchar,varchar) returns integer as ' declare tabnam alias for $1; proj...

Reinhard Hnat

01-28-2004 11:23 AM
Stephan Szabo

What can cause such an error: 'unexpected eof on client connection'. I can find it in logs, all the connections I make to the db are from...

Marcin Gil

01-28-2004 03:23 AM
Marcin Gil

I have two tables. The first will contain recent records that are used on a daily basis. The other table is identical but only exists to archive...

Alan T. Miller

01-27-2004 09:40 PM
Alan T. Miller

Hello group I am trying to follow through on advice I received from you earlier. I would like to check for my database when I logon and if it is not...

Marcel Wolf

01-27-2004 06:23 PM
Andre Dubuc

hi, i've install postgre on winNT. i've initialise it and run the server. then i've try to use pgadmin3 but i get an error as...

thierry

01-27-2004 09:19 AM
thierry

Is there any bad side effect in recompiling PG with increased stored procedures maximum parameters count, for example, to 128? Thank you in...

lnd@hnit.is

01-27-2004 08:58 AM
lnd@hnit.is

Hello All, I have a problem when starting postgre under solaris 8 : bash-2.03# su - postgres -c "/usr/local/pgsql/bin/pg_ctl -D /dat/pgsql/data -l...

Patrice Durosay

01-27-2004 06:04 AM
Patrice Durosay

Hello, I am trying to create a database on FreeBSD 5.2-RELEASE, This is inside a jail. I had it working in 5.1 and now am having a problem. The...

Paul Bauer

01-26-2004 05:26 PM
April Carvalho

I would like my application to start up and see if the database is there if not create it. I am not sure how to do it. When I try and query...

Marcel Wolf

01-26-2004 03:53 PM
Jeff Eckermann

I realize this is a classic problem, but I'm a NOVICE after all. I want to represent hierarchal topics (just like dmoz.org). I've seen two ways to...

Bill Moseley

01-26-2004 03:25 PM
glenn

What is the best method to implement pgplsql global variables with "per connection"(i.e. session) scope? (one way is to use temporary tables - but...

lnd@hnit.is

01-26-2004 12:03 PM
lnd@hnit.is

Hi, Is a long field ok for a primary key, or should i use a unique integer?: create table parts ( manufacturers_code char(40) primary...

Russell Shaw

01-25-2004 07:34 PM
Tom Lane

Hi, I'm making my first database. I have a list of parts, each of which is sold by multiple vendors. I also have a list of vendors, each of which...

Russell Shaw

01-25-2004 01:33 AM
Michael Glaesemann

Hi! Can someone pls help me? I was trying to install postgresql7.4, when I run ./configure, I got this weird error: ./src/template/linux: No such...

Peggy Go

01-24-2004 04:04 PM
Tom Lane

Hi all, Just noticed that 7.4.1 template1 has 40 views / tables in it and copies all of them to new databases. Tried to DROP them in template1 and...

Aarni Ruuhimäki

01-23-2004 01:12 PM
Aarni Ruuhimäki

Hi there, I am having a hard time installing PostgreSQL for the first time. I worked my way through the INSTALL instructions upto the...

Christian Poecher

01-23-2004 10:27 AM
Tom Lane

Hello all #> I hope you can help me. I am a novice to postgreSQL. #> I'm tying to write a little shellscript/SQL application on unix system. #> I...

Francois PUSSAULT

01-23-2004 05:09 AM
Francois PUSSAULT

chris (AT) vote4ad (DOT) com writes: I assure you there is something relevant in config.log. For example, I get the following trace for <dld.h>,...

chris@goforit.de

01-23-2004 02:01 AM
Tom Lane

Hi all, I'm trying to delete from a table which has 42Mill rows, using a foreign key, which is index. The delete has been going three days now :(...

Noel

01-22-2004 10:49 AM
Tom Lane

I have a trigger that sets an expires column to last_access+expiry::interval if expires IS NULL or if the expires value isn't being set or...

Paul Makepeace

01-22-2004 10:25 AM
Marcus Andree S. Magalhaes

Does postgres have a data type such as mysql to encrypt and store passwords?

Chris

01-21-2004 04:12 PM
Tom Lane

hi, I am having trouble with the following SQL insert $createtbl = "CREATE TABLE $table ("; $createtbl .= "UTCTime timestamptz,"; $createtbl .=...

Seader, Cameron

01-19-2004 06:00 PM
Tom Lane

I ahve red hat enterprise linux 3. This came with PostgreSQL already installed. An online book says that I should have the following directoreies...

Lduren02@aol.com

01-19-2004 03:49 PM
Tom Lane

Hi Roman, Comments are stored in the system catalog table pg_description. To select a column comment ("description" in pg_description) you need the...

George Weaver

01-19-2004 10:54 AM
Tom Lane

Hi, I am relatively new to postgres. I want to know if there are tables (Meta data tables) that give me information abt all the tables that exist in...

Raghu

01-19-2004 09:02 AM
glenn

create temp table foo (name text, rank int unique); insert into foo values ('Joe', 1); insert into foo values ('Matt', 2); insert into foo values...

Timo

01-19-2004 02:50 AM
Tom Lane

Lduren02 (AT) aol (DOT) com writes: RHEL3 by default includes only the client-side programs for Postgres, not the Postgres server. If you want to...

Tom Lane

01-18-2004 11:32 PM
Tom Lane