db.postgresql.novice (date)

db.postgresql.novice (date)

May 30, 2002

psql without password prompt, brew
Re: Database Ownership, Josh Berkus
Re: Enabling Auditing in Postgres, Joel Burton
Re: Accessing database statistics, Tony Griffiths(RA)
Re: Accessing database statistics, Joshua b. Jore
Re: Accessing database statistics, Henshall, Stuart - WCP
Re: Accessing database statistics, Tony Griffiths(RA)
Re: Enabling Auditing in Postgres, Henshall, Stuart - WCP
Re: Accessing database statistics, Tony Griffiths(RA)
Re: Accessing database statistics, Duncan Adams (DNS)
Re: Accessing database statistics, John Taylor
Re: Accessing database statistics, Duncan Adams (DNS)
Accessing database statistics, Tony Griffiths(RA)
Enabling Auditing in Postgres, V R
Re: Fantasy Football complex select, Duncan Adams (DNS)
Re: Fantasy Football complex select, Henshall, Stuart - WCP
Re: ideal filesystem layout, Joshua b. Jore
PL/PgSQL Cursors vs. Pl/SQL Cursors, Ludwig Lim
ideal filesystem layout, danix

May 29, 2002

[Fwd: Re: CPU types and queries...], Ron Johnson
Re: Database Ownership, Josh Berkus
Re: Database Ownership, Josh Berkus
Database Ownership, Jillian Carroll
Re: Fantasy Football complex select, Rory Campbell-Lange
Re: psql without password prompt, Tom Lane
CPU types and queries..., James Kelty
Re: psql without password prompt, Joshua b. Jore
psql without password prompt, Wei Weng
Change a database owner, Cédric Mallet
Re: Fantasy Football complex select, Ron Johnson
Fantasy Football complex select, Rory Campbell-Lange

May 28, 2002

Re: remnants of deleted table causing problems, Tom Lane
Re: remnants of deleted table causing problems, Tim Wilson
Re: remnants of deleted table causing problems, Tom Lane
remnants of deleted table causing problems, Tim Wilson
Re: Copy Comand question, Sharon Cowling

May 27, 2002

german decimal / locale, Volker Roehl
Re: Full Outer Joins, John Taylor
Re: Full Outer Joins, Tom Lane
Re: Full Outer Joins, John Taylor
Re: Full Outer Joins, Tom Lane
Re: Full Outer Joins, John Taylor
Re: Full Outer Joins, Joel Burton
find functions, triggers, views and rules., Duncan Adams (DNS)
Full Outer Joins, John Taylor
Re: Possible use of a subselect?, Manfred Koizar
Re: Possible use of a subselect?, Manfred Koizar
Re: Copy Comand question, Rasmus Mohr
Re: Copy Comand question, John Taylor
Re: Possible use of a subselect?, Joel Burton
Possible use of a subselect?, Adam Erickson
Re: Altering a table in Postgres to add a NOT NULL constraint, Ron Johnson

May 26, 2002

Re: Copy Comand question, Ron Johnson

May 25, 2002

Copy Comand question, Sharon Cowling
Re: Why sequential scan when there's a supporting index?, Joshua b. Jore
Re: Why sequential scan when there's a supporting index?, Joshua b. Jore
Re: Why sequential scan when there's a supporting index?, Ron Johnson
Re: Why sequential scan when there's a supporting index?, Andrew McMillan

May 24, 2002

Re: Nondestructive cluster, equivalent SQL?, Tom Lane
Re: Nondestructive cluster, equivalent SQL?, Joshua b. Jore
Re: Nondestructive cluster, equivalent SQL?, Tom Lane
Nondestructive cluster, equivalent SQL?, Joshua b. Jore
Re: Using CASE with a boolean value, Tom Ansley
Re: Using CASE with a boolean value, Tom Lane
Re: query problem - get count in related table, Manfred Koizar
Re: Using CASE with a boolean value, Tom Ansley
Re: Using CASE with a boolean value, Joel Burton
Using CASE with a boolean value, Tom Ansley
Re: auto update dates, Rory Campbell-Lange
Re: auto update dates, Joel Burton
Re: COPY returns Bad timestamp external rep.., Patrick Hatcher
Re: Why sequential scan when there's a supporting index?, Ron Johnson
Re: Why sequential scan when there's a supporting index?, Tom Lane
Re: Why sequential scan when there's a supporting index?, Ron Johnson
Re: Why sequential scan when there's a supporting index?, Henshall, Stuart - WCP
Why sequential scan when there's a supporting index?, Ron Johnson
Re: script, Ron Johnson
Re: discovering an index definition, Ron Johnson
Re: script, Ewald Geschwinde
script, Annissa Melhenas
Re: restoring pgsql database v7.0.3?, Tom Lane
Re: discovering an index definition, Tom Lane
restoring pgsql database v7.0.3?, dionysus

May 23, 2002

Re: query problem - get count in related table, Ron Johnson
Re: COPY returns Bad timestamp external rep.., Ron Johnson
discovering an index definition, Ron Johnson
Re: COPY returns Bad timestamp external rep.., Patrick Hatcher
Re: auto update dates, Rory Campbell-Lange
Re: query problem - get count in related table, Rory Campbell-Lange
Re: COPY returns Bad timestamp external rep.., Ron Johnson
COPY returns Bad timestamp external rep.., Patrick Hatcher
Re: query problem - get count in related table, Ron Johnson
Re: when to use char, varchar or text, Adam Erickson
query problem - get count in related table, Rory Campbell-Lange
Re: auto update dates, Joel Burton
use vi mode in psql, Rory Campbell-Lange
Re: auto update dates, Rory Campbell-Lange
Re: auto update dates, Rory Campbell-Lange
Re: auto update dates, Joel Burton
Re: auto update dates, Joshua b. Jore
auto update dates, Rory Campbell-Lange
Re: optimising data load, John Taylor
Re: Undead record haunts my database, need exorcism, Kevin Sterner
Re: SELECT DISTINCT, Andrew McMillan
Re: optimising data load, Andrew McMillan
Re: when to use char, varchar or text, Joshua b. Jore
when to use char, varchar or text, Rory Campbell-Lange
I WANT TO UNSUBSCRIBE, Pierre-Alexis PAQUIN
Re: make default field entry NULL?, John Taylor
make default field entry NULL?, Rory Campbell-Lange
Re: optimising data load, John Taylor
Re: pl/perl Documentation, Duncan Adams (DNS)
Re: optimising data load, Ron Johnson
Re: optimising data load, John Taylor
Re: pl/perl Documentation, Thomas A. Lowery
Re: optimising data load, Ron Johnson
Re: Moving data to different hard drive /or/ incremental backup, Josh Berkus
Moving data to different hard drive /or/ incremental backup, Brian Johnson

May 22, 2002

Re: Better way to bulk-load millions of CSV records into, Marc Spitzer
Re: optimising data load, John Taylor
Re: Better way to bulk-load millions of CSV records into, Ron Johnson
How to Identify a SERIAL column type?, Phillip J. Allen
Re: Better way to bulk-load millions of CSV records into, Marc Spitzer
SELECT DISTINCT, stev knowles
Re: Better way to bulk-load millions of CSV records into, Ron Johnson
Re: optimising data load, Ron Johnson
Re: Better way to bulk-load millions of CSV records into, Ron Johnson
Re: pl/perl Documentation, Tom Lane
Re: Better way to bulk-load millions of CSV records into postgres?, Marc Spitzer
Re: optimising data load, John Taylor
Re: pl/perl Documentation, Joshua b. Jore
Re: optimising data load, Patrick Hatcher
Re: Undead record haunts my database, need exorcism, Tom Lane
Re: optimising data load, Rasmus Mohr
Re: pl/perl Documentation, Tom Lane
Re: Better way to bulk-load millions of CSV records into postgres?, Tom Sheehan
Re: Undead record haunts my database, need exorcism, Tom Lane
optimising data load, John Taylor
Undead record haunts my database, need exorcism, Kevin Sterner
Re: Guarantee uniqueness of PGP key, andre
pl/perl Documentation, Duncan Adams (DNS)
Re: PostgreSQL+Access97+Linux: How to.., Josh Berkus
[Fwd: Re: PostgreSQL+Access97+Linux: How to..], Ron Johnson
Re: PostgreSQL+Access97+Linux: How to.., Ron Johnson
Re: Better way to bulk-load millions of CSV records into postgres?, Joel Burton
PostgreSQL+Access97+Linux: How to.., Victor Manuel Torres Aguirre
Re: Better way to bulk-load millions of CSV records into postgres?, Josh Berkus
Re: Large tables being split at 1GB boundary, Tom Lane

May 21, 2002

Better way to bulk-load millions of CSV records into postgres?, Ron Johnson
Large tables being split at 1GB boundary, Ron Johnson
Re: Problem with inserting: attribute 'extended_reason', Joel Burton
Problem with inserting: attribute 'extended_reason', Wim
Re: Guarantee uniqueness of PGP key, Bruno Wolff III
Re: Guarantee uniqueness of PGP key, D. Duccini
Re: [SQL] Guarantee uniqueness of PGP key, Joel Burton
Guarantee uniqueness of PGP key, andre

May 20, 2002

Transactions over several db sessions, ghinchliffe
Re: Accessing table attributes from within PlPgSQL, Henshall, Stuart - WCP
Re: Is a randomized default value primary key, Ron Johnson

May 19, 2002

Accessing table attributes from within PlPgSQL, Ron Johnson
Re: Is a randomized default value primary key, Josh Berkus
Re: Is a randomized default value primary key, ghaverla
Re: Is a randomized default value primary key, Joel Burton
Re: Is a randomized default value primary key, April L
New features in PlPgSQL, Ron Johnson
Re: Is a randomized default value primary key possible?, Josh Berkus
Re: Is a randomized default value primary key possible?, Ron Johnson
Re: Forgotten the master password of db, Josh Berkus
Re: Forgotten the master password of db, thiemo
Re: Forgotten the master password of db, Tom Lane
Is a randomized default value primary key possible?, April L
Re: Some CSV file-import questions, Andrew McMillan
Some CSV file-import questions, Ron Johnson
Forgotten the master password of db, thiemo
Fw: Selecting random rows using weights, Masaru Sugawara

May 18, 2002

Re: ADD CONSTRAINT NOT NULL, how?, Tom Lane
Re upgrading 7.1 to 7.2, bob parker
ADD CONSTRAINT NOT NULL, how?, Lutz Horn

May 17, 2002

Re: Answering my own question, gerry . smit
Re: Answering my own question, Francisco Reyes
Re: Answering my own question, Francisco Reyes

May 16, 2002

Re: newbie: Column CHECK(col contains '@') ?, Joel Burton
Re: newbie: Column CHECK(col contains '@') ?, john-paul delaney
Re: Casting from varchar to numeric, Joel Burton
Re: Casting from varchar to numeric, Tom Ansley
Re: Trouble with index in 7.1, gerry . smit
Re: Answering my own question, gerry . smit
Re: Casting from varchar to numeric, Adam Erickson
Re: Answering my own question, gerry . smit
Re: Casting from varchar to numeric, Josh Berkus
Re: Answering my own question, Adam Erickson
Casting from varchar to numeric, Tom Ansley
Re: Answering my own question, gerry . smit
Re: Answering my own question, gerry . smit
Re: Catching errors inside transactions, John Taylor
7.2 startup with md5 pass?, Rasputin
Re: data-type for image files, john-paul delaney
Re: Trouble with index in 7.1, Tom Lane
Re: Answering my own question, Chris
Re: Answering my own question, Balazs Wellisch
Re: Answering my own question, Manuel Sugawara
Re: Answering my own question, gerry . smit
Re: data-type for image files, Josh Berkus
Re: Answering my own question, Francisco Reyes
data-type for image files, sibusiso xolo

May 15, 2002

Re: Answering my own question, gerry . smit
Re: Answering my own question, ghaverla
Answering my own question, gerry . smit
Re: Answering my own question, Manuel Sugawara
Answering my own question, gerry . smit
Re: trigger, transactions, eek, Manuel Sugawara
Re: Catching errors inside transactions, Manuel Sugawara
Re: Trouble with index in 7.1, Adam Erickson
Trouble with index in 7.1, gerry . smit
Catching errors inside transactions, John Taylor
trigger, transactions, eek, Chris Thompson
Re: Did I install version 7.2.1?, Josh Berkus
Did I install version 7.2.1?, Patrick Hatcher

May 14, 2002

Re: Cascading Changes, Oliver Elphick
Re: Cascading Changes, Joel Burton
Cascading Changes, Tom Ansley
Re: newbie: Column CHECK(col contains '@') ?, Juliet May

May 13, 2002

Re: newbie: Column CHECK(col contains '@') ?, Josh Berkus
pgsql on win98, Paulo Henrique Werly Gualberto
Re: newbie: Column CHECK(col contains '@') ?, john-paul delaney
Re: newbie: Column CHECK(col contains '@') ?, Josh Berkus
Description of Functions, Sharon Cowling

May 12, 2002

Re: newbie: Column CHECK(col contains '@') ?, Andrew McMillan
Re: Relation does not exist, Brian Schroeder
Re: newbie: Column CHECK(col contains '@') ?, john-paul delaney
Re: newbie: Column CHECK(col contains '@') ?, Joel Burton
Selecting random rows using weights, G
Re: newbie: Column CHECK(col contains '@') ?, Josh Berkus
newbie: Column CHECK(col contains '@') ?, john-paul delaney
Re: What are schemas?, Vijay Deval

May 11, 2002

Re: Time Formatting, hodges
Re: Time Formatting, Andrew McMillan
Re: Time Formatting, hodges

May 10, 2002

Re: Altering columns without losing data, Aarni Ruuhimäki / Megative Tmi / KYMI.com
Re: Time Formatting, Andrew McMillan
Re: Converting epoc number to timestamp, Oliver Elphick
Re: Time Formatting, hodges
Re: Time Formatting, Larry Rosenman
Time Formatting, hodges
Converting epoc number to timestamp, Doug Silver

May 09, 2002

Re: Newbie Date Problems, John Nix
Re: Newbie Date Problems, Josh Berkus
Newbie Date Problems, John Nix
Altering columns without losing data, G
Re: Database structure, Joshua b. Jore
Ready to go live!!!, Tom Ansley
Re: Database structure, Henshall, Stuart - WCP
Re: Database structure, Josh Berkus
Database Structure, Peter Goggin
Database Structure, Peter Goggin
Database structure, Peter Goggin
Re: Relation does not exist, Brian Schroeder

May 08, 2002

Re: Incorrect Query, Sharon Cowling
Re: Too many clients, Tom Lane
Re: Appending values non-destructively, Joshua b. Jore
Re: Partial table copy?, Tom Lane
Re: Incorrect Query, Sharon Cowling
Re: Appending values non-destructively, Andre Dubuc
Re: Appending values non-destructively, Henshall, Stuart - WCP
Re: Appending values non-destructively, Andre Dubuc
Too many clients, Leandro Fanzone
Partial table copy?, Mark Thomas
View don't know table, Reinhard Hnat
Re: Appending values non-destructively, Henshall, Stuart - WCP
Re: Appending values non-destructively, Joshua b. Jore
Re: Incorrect Query, Joshua b. Jore
Appending values non-destructively, Andre Dubuc
Re: Functions replicating stored procedures, Henshall, Stuart - WCP
Re: Incorrect Query, Sharon Cowling
Re: Incorrect Query, Andrew McMillan
Incorrect Query, Sharon Cowling
Re: more voodoo planner bs :), Tom Lane
Re: Relation does not exist, Tom Lane
Re: Relation does not exist, Brian Schroeder
Re: Relation does not exist, April L
Relation does not exist, Brian Schroeder
voodoo planner update, D. Duccini
more voodoo planner bs :), D. Duccini

May 07, 2002

Functions replicating stored procedures, Joshua Moore-Oliva
Re: Stored Procedures, Josh Berkus
Re: Problems with psql : ERROR : pg_user: permission, Josh Berkus
Re: Stored Procedures, Josh Berkus
Re: ERROR: $1 is declared CONSTANT in plpgsql, Henshall, Stuart - WCP
Re: ERROR: $1 is declared CONSTANT in plpgsql, Oliver Elphick
Re: ERROR: $1 is declared CONSTANT in plpgsql, Tom Lane
Re: Cascaded updates / deletes don't work on inherited, Joshua b. Jore
Re: ERROR: $1 is declared CONSTANT in plpgsql, Jason Davis
Problems with psql : ERROR : pg_user: permission denied,and I can 't type \ in psql, Joseph . ROTHWELL
ERROR: $1 is declared CONSTANT in plpgsql, Hans Plum
Cascaded updates / deletes don't work on inherited tables, Michael Barber
Stored Procedures, Wendy Powley

May 06, 2002

Re: Date Formatting, Richard A Lough
Re: search and replace possible on SQL?, Andrew McMillan
Re: search and replace possible on SQL?, Bruno Wolff III
Re: Triggers in the db, Joshua b. Jore
Re: Date Formatting, Joel Burton
search and replace possible on SQL?, Duncan Adams (DNS)
Triggers in the db, Rob
Re: Date Formatting, Doug Silver
(unknown), Kristian Skrede Gleditsch
Re: Transaction Question, Masaru Sugawara

May 05, 2002

Re: Date Formatting, hodges
Re:, Aarni Ruuhimäki / Megative Tmi / KYMI.com
Re: insert multiple rows, Andrew McMillan
Re: Limiting number of records to show., Joshua b. Jore

May 04, 2002

insert multiple rows, G
Re: Tricky query, Joel Burton
Re: Tricky query, Vijay Deval

May 03, 2002

Re: Date Formatting, Oliver Elphick
Date Formatting, Tom Ansley
[Fwd: Re: SELECT INTO an array], Alberto Bolchini
Re: SELECT INTO an array, Josh Berkus
Forte for Java & Postgres, Slawek Jarosz
SELECT INTO an array, Alberto Bolchini
Re:, Tom Lane
(unknown), Kristian Skrede Gleditsch
error on create rule., Duncan Adams (DNS)
Re: Limiting number of records to show., Wim
Re: Limiting number of records to show., Duncan Adams (DNS)
Limiting number of records to show., Wim
Re: root of parent-child table with NOT NULL, Josh Berkus

May 02, 2002

Re: ALTER TABLE table DROP CONSTRAINT problem, Tom Lane
Re: non-root installation of Postgresql?, Terrence Brannon
root of parent-child table with NOT NULL constraint, bill
Re: error messages, P. Jourdan
Re: error messages, P. Jourdan
Re: error messages, Josh Berkus
Transaction Question, mark lonsdale
Re: non-root installation of Postgresql?, Tom Lane
Re: non-root installation of Postgresql?, Terrence Brannon
ALTER TABLE table DROP CONSTRAINT problem, Lewis Bergman
Re: non-root installation of Postgresql?, Aarni Ruuhimäki / Megative Tmi / KYMI.com
plpgsql - why it is not available by default ?, Emma
error messages, PJourdan
Re: Window 98 and NT, Henshall, Stuart - WCP
Re: Window 98 and NT, Warwick Hunter
Window 98 and NT, Peter Goggin
non-root installation of Postgresql?, Terrence Brannon
Re: Trying to reduce per tuple overhead, Rasmus Mohr
Trying to reduce per tuple overhead, Manfred Koizar
Re: if postmaster is started on a certain port, should I be able to telnet there?, Tom Lane
if postmaster is started on a certain port, should I be able to telnet there?, Terrence Brannon

May 01, 2002

Re: error messages, Oliver Elphick
Re: Once again about 'OID', Josh Berkus
error messages, P. Jourdan
Re: What are schemas?, Francisco Reyes
Re: Once again about 'OID', Josh Berkus
Once again about 'OID', Denny Permana
Re: What are schemas?, Tom Lane
What are schemas?, Francisco Reyes

News | FAQ | advertise