Hi Everyone, I have created a function that creates a view. The function is designed touse the distinct values of one column of an existing view to...

George Weaver

04-22-2004 05:22 PM
Joe Conway

What happens when a vacuum full is canceled? Is any of the completed work retained, or is everything lost? ---------------------------(end of...

Michael Guerin

04-21-2004 03:14 PM
Tom Lane

I created a table with column named orderdate and a default of Now() by the following command: CREATE TABLE "trans_test" ( "orderdate" timestamp...

Christopher A. Goodfellow

04-21-2004 03:03 PM
Tom Lane

Salut, Je débute avec Linux et ce genre d'outil... J'ai installé postgresql aujourd'hui. En fait quand j'exécute /usr/local/pgsql/ > createdb...

jedi

04-21-2004 11:16 AM
JP Beaudry

Michal Lijowski <michal (AT) cvu (DOT) wustl.edu> writes: What you have on the right there is an integer expression with a value of -1 (one minus...

Tom Lane

04-20-2004 02:00 PM
Tom Lane

Christopher A. Goodfellow wrote: Read the docs at http://www.postgresql.org/docs/7.4/static/postmaster-start.html for instructions on how to...

Ron St-Pierre

04-20-2004 01:11 PM
Tom Lane

Michal Lijowski wrote: SELECT RabNo, ImplantDate, Comments FROM RabStudiesInfo where implantdate <> '0001-01-01';

Ron St-Pierre

04-20-2004 12:58 PM
Stephan Szabo

why is it bad to kill -9 the postmaster? any links? i'm wondering why is it bad... percy ---------------------------(end of...

shadowbox@punkass.com

04-20-2004 12:49 PM
Bruce Momjian

I have an older mysql implementation that is going to be upgraded soon. Rather than upgrade it to another version of mysql I was thinking...

Bryan Irvine

04-19-2004 09:43 PM
joseph speigle

Hello everybody, /*background info*/ I'm using Postgres for quite a while now from a programming and dba point of view, but I'm quite the noob if it...

Stijn Vanroye

04-19-2004 03:42 AM
Stijn Vanroye

Anyone?? ----- Original Message ----- From: "Iandé Coutinho" <iande (AT) br (DOT) inter.net> To: <pgsql-novice (AT) postgresql (DOT) org> Sent:...

Iandé Coutinho

04-16-2004 10:26 AM
Bruno Wolff III

thanks Colin, that worked just great!! :) ----- Original Message ----- From: "Colin Gillespie" <C.Gillespie (AT) newcastle (DOT) ac.uk> To: "Iandé...

Iandé Coutinho

04-16-2004 10:22 AM
Iandé Coutinho

Hi I am looking for some way how to get some ID variable that remains unchanged and unique throughout a connection, like MS SQL @@SPID. I am running...

Jan Blaha

04-16-2004 08:27 AM
Bruno Wolff III

On Tue, Apr 06, 2004 at 14:37:21 -0400, Manfred Koroschetz <mkoroschetz (AT) tekvoice (DOT) com> wrote: The "standard" way to do this is to make a...

Tom Lane

04-16-2004 06:53 AM
M. Bastin

Hi, We are developing visual basic application with postgres as back end.When we open ADODB recordset for particular recorset by using cursor type as...

R V Sreedharan

04-15-2004 02:49 PM
Iandé Coutinho

hello, I have lines in a csv like these: 07/09/2002,'ORDER POSTING',-5,'TMT',0.463,10.8,0 01/06/2003,'ORDER...

joseph speigle

04-15-2004 09:06 AM
Tom Lane

Postgres version: 7.3.4 Environment: Solaris (SunOS 5.9) Ultra-250 We use pg_dump to do a nightly export of all databases, via these commands: for...

David Rickard

04-12-2004 02:36 PM
Tom Lane

I'm confused. I have a bytea column that should be binary format (right?), yet PQfformat() says it is NOT binary (I did an insert as such: INSERT...

David Kitzinger ARA/SWD

04-10-2004 05:28 AM
M. Bastin

In short, I have not yet found a way to use pg_dump's text formatted file with psql to restore a database without generating some kind of error....

JP Beaudry

04-09-2004 01:39 AM
Tom Lane

Hello everyone, I have query that I could use some help with. I have three tables contact, people address. The contact table has a one to many...

Kevin Lohka

04-08-2004 03:17 PM
Sheeraz fazal

PostgreSQL Version: 7.3.4 Environment: Solaris (SunOS 5.9) Ultra-250 We do a nightly export-and-analyze of our databases, using these...

David Rickard

04-07-2004 09:17 PM
Tom Lane

Hi, I am getting the error "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." when I...

Ray Nassar

04-07-2004 05:52 PM
Ray Nassar

From my reading of previous posts here, and a bit of experimentation, I have concluded that if user A creates a database, they cannot prevent user B...

Richard Hayward

04-07-2004 05:02 PM
Richard Hayward

My database keeps growing, although the size of the data remains almost constant. The database is currently using 140GB, although I estimated the...

Michael Guerin

04-07-2004 03:59 PM
Bruno Wolff III

Hi all, I need some help optimizing a snowflaked :( db structure. I'm using 7.3.4 at the moment Scenario: I have only a few tables holding real...

Nabil Sayegh

04-07-2004 08:49 AM
Nabil Sayegh

Hi, is there something special to do to unistall postgres_beta4 on Windows ? ---------------------------(end of...

DAVANNE Eric - NTR

04-07-2004 05:31 AM
DAVANNE Eric - NTR

I'm trying to understand why the row count is way off, setting the statistics_target higher seems to make it worse. summary: INFO: "timeseries":...

Michael Guerin

04-07-2004 01:48 AM
Tom Lane

Hi Paul, I'm not sure if this is what you're looking for, but hopefully it will point you in the right direction. Create a stored procedure in...

George Weaver

04-06-2004 03:14 PM
PaulS

Colin Gillespie wrote: all your options, but you would use something along the lines of : select to_char(timestamp...

Ron St-Pierre

04-06-2004 11:00 AM
Ron St-Pierre

--- Manfred Koroschetz <mkoroschetz (AT) rkmus (DOT) com> wrote: Have a look in the docs, under "functions and operators", especially "string...

Jeff Eckermann

04-06-2004 10:51 AM
Jeff Eckermann

Benjamin <benjamin (AT) netyantra (DOT) com> writes: The UPDATE in your example does that already; I think you should just drop the LOCK...

Tom Lane

04-06-2004 12:31 AM
Tom Lane

hi i'd like to write C programs with embedded SQL commands - apparently i need to use ecpg preprocessor. i have the psql server(7.3.2-3) &...

stm23

04-04-2004 11:31 PM
stm23

I have a PHP script that captures the time using the PHP time() function. I want to insert this time into a postgresql table timestamp field. I am at...

Alan T. Miller

04-04-2004 10:33 PM
Tom Lane

Hi all, when i try to connect to the database with psql i get the following message : postgres@1$ psql installation psql: could not connect to...

alexandre ricciardi

04-04-2004 11:31 AM
joseph speigle

I have been trying to set up my first database using postgresql-7.3.4-11 on Red Hat Fedora Core 1 Linux. I setup database and I can access it from...

Michal

04-04-2004 01:19 AM
farqua

hi, sorry, but it works for me just cut and pasting dba=# CREATE USER janos WITH SYSID 801 PASSWORD 'netuddmi' CREATEDB dba-# ; CREATE USER dba=#...

joseph speigle

03-31-2004 08:20 PM
joseph speigle

hi, i am trying to install postgresql. i have unzipped the 7.4.1 source files into a folder & run ./configure. however when i enter: gmake i get...

stm23

03-06-2004 10:48 PM
Tom Lane

also where is it located? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

stm23

03-06-2004 07:26 PM
stm23

hi, cold some1 please tell me how to find out if i already have a version of postgresql installed, & how to find out the version? thanx,...

stm23

03-06-2004 07:14 PM
stm23

I'm trying to reinstall Postgresql on my Mac (running 10.3.2) and running into bizarre things that I haven't experienced before. Anyone here know...

Lola Lee

03-06-2004 05:27 PM
Stephan Hochhaus

Ok I copied include/pg_config.h.win32 to include/pg_config.h and it seems to have built ... phew it's been a long day and I missed those steps...

sashan

03-06-2004 02:04 AM
sashan

Hussein, In the future, please contact me through one of the mailing lists, such as pgsql-novice, which I have linked above. That way, if I'm too...

Josh Berkus

03-05-2004 02:42 PM
Josh Berkus

I create a data type as follows: create type baseobject as (grp integer, elem integer, len integer, dta bytea); I then wish to make a table of...

Brian OBrien

03-04-2004 04:45 PM
Brian OBrien

Need some help with the following example. I have email, people and people2email tables. The people2email table is a one-to-many with one person able...

Scott Goodwin

03-04-2004 09:21 AM
Scott Goodwin

Is there an option for psql to use the entry in Comments for "pretty" column headings in a report? For example, instead of printing the column name...

tully

03-03-2004 09:46 PM
tully

Hi, is there any documentation for Pg's UPDATE FROM (apparently non-standard) syntax? It is mentioned briefly in \h update and not at all in...

Paul Makepeace

03-03-2004 09:15 AM
Bruce Momjian

I have several tables of data represented as newline-delimited records of tab-delimited fields in flat files. What is the easiest way (e.g. in psql)...

kynn@panix.com

03-03-2004 12:35 AM
Joe

Hi, The "current_query" column in the "pg_stat_activity" system table seems to be limited to 255 characters. Is there a way to increase that limit,...

Oliver Fromme

03-02-2004 11:34 AM
Bruce Momjian

What's the simplest way (through psql?) to initialize PostgreSQL tables from data stored in flat files? (In this case the data is stored in several...

kynn@panix.com

03-02-2004 05:41 AM
kynn@panix.com

hi, thanx for yr previous advice. i have found that i do have openssl (0.9.7a) installed. could any1 help advise me how to get my system to...

stm23

03-02-2004 01:18 AM
joseph speigle