db.postgresql.novice (thread)

Accessing database statistics, Tony Griffiths(RA)
- Re: Accessing database statistics, John Taylor
- Re: Accessing database statistics, Duncan Adams (DNS)
  - Re: Accessing database statistics, Tony Griffiths(RA)
- Re: Accessing database statistics, Duncan Adams (DNS)
  - Re: Accessing database statistics, Tony Griffiths(RA)
- Re: Accessing database statistics, Henshall, Stuart - WCP
  - Re: Accessing database statistics, Joshua b. Jore
    - Re: Accessing database statistics, Tony Griffiths(RA)
Enabling Auditing in Postgres, V R
- Re: Enabling Auditing in Postgres, Joel Burton
- Re: Enabling Auditing in Postgres, Henshall, Stuart - WCP
PL/PgSQL Cursors vs. Pl/SQL Cursors, Ludwig Lim
ideal filesystem layout, danix
- Re: ideal filesystem layout, Joshua b. Jore
[Fwd: Re: CPU types and queries...], Ron Johnson
Database Ownership, Jillian Carroll
- Re: Database Ownership, Josh Berkus
- Re: Database Ownership, Josh Berkus
- Re: Database Ownership, Josh Berkus
CPU types and queries..., James Kelty
psql without password prompt, Wei Weng
- Re: psql without password prompt, Joshua b. Jore
  - Re: psql without password prompt, Tom Lane
- psql without password prompt, brew
Change a database owner, Cédric Mallet
Fantasy Football complex select, Rory Campbell-Lange
- Re: Fantasy Football complex select, Ron Johnson
  - Re: Fantasy Football complex select, Rory Campbell-Lange
- Re: Fantasy Football complex select, Henshall, Stuart - WCP
- Re: Fantasy Football complex select, Duncan Adams (DNS)
remnants of deleted table causing problems, Tim Wilson
- 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
german decimal / locale, Volker Roehl
find functions, triggers, views and rules., Duncan Adams (DNS)
Possible use of a subselect?, Adam Erickson
- Re: Possible use of a subselect?, Joel Burton
- Re: Possible use of a subselect?, Manfred Koizar
  - Re: Possible use of a subselect?, Manfred Koizar
Re: Altering a table in Postgres to add a NOT NULL constraint, Ron Johnson
Copy Comand question, Sharon Cowling
- Re: Copy Comand question, Ron Johnson
  - Re: Copy Comand question, John Taylor
    - Re: Copy Comand question, Sharon Cowling
- Re: Copy Comand question, Rasmus Mohr
Nondestructive cluster, equivalent SQL?, Joshua b. Jore
- Re: Nondestructive cluster, equivalent SQL?, Tom Lane
  - Re: Nondestructive cluster, equivalent SQL?, Joshua b. Jore
    - Re: Nondestructive cluster, equivalent SQL?, Tom Lane
Using CASE with a boolean value, Tom Ansley
- Re: Using CASE with a boolean value, Joel Burton
- Re: Using CASE with a boolean value, Tom Lane
  - Re: Using CASE with a boolean value, Tom Ansley
- Re: Using CASE with a boolean value, Tom Ansley
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?, Andrew McMillan
    - Re: Why sequential scan when there's a supporting index?, Ron Johnson
    - Re: Why sequential scan when there's a supporting index?, Joshua b. Jore
- Re: Why sequential scan when there's a supporting index?, Henshall, Stuart - WCP
  - Re: Why sequential scan when there's a supporting index?, Ron Johnson
- Re: Why sequential scan when there's a supporting index?, Joshua b. Jore
script, Annissa Melhenas
- Re: script, Ewald Geschwinde
- Re: script, Ron Johnson
restoring pgsql database v7.0.3?, dionysus
- Re: restoring pgsql database v7.0.3?, Tom Lane
discovering an index definition, Ron Johnson
- Re: discovering an index definition, Tom Lane
  - Re: discovering an index definition, Ron Johnson
COPY returns Bad timestamp external rep.., Patrick Hatcher
- Re: COPY returns Bad timestamp external rep.., Ron Johnson
- Re: COPY returns Bad timestamp external rep.., Patrick Hatcher
- Re: COPY returns Bad timestamp external rep.., Ron Johnson
- Re: COPY returns Bad timestamp external rep.., Patrick Hatcher
query problem - get count in related table, Rory Campbell-Lange
- Re: query problem - get count in related table, Ron Johnson
  - Re: query problem - get count in related table, Rory Campbell-Lange
    - Re: query problem - get count in related table, Ron Johnson
    - Re: query problem - get count in related table, Manfred Koizar
use vi mode in psql, Rory Campbell-Lange
auto update dates, Rory Campbell-Lange
- Re: auto update dates, Joshua b. Jore
  - Re: auto update dates, Rory Campbell-Lange
- Re: auto update dates, Joel Burton
  - Re: auto update dates, Rory Campbell-Lange
    - Re: auto update dates, Joel Burton
    - Re: auto update dates, Rory Campbell-Lange
    - Re: auto update dates, Joel Burton
    - Re: auto update dates, Rory Campbell-Lange
when to use char, varchar or text, Rory Campbell-Lange
- Re: when to use char, varchar or text, Joshua b. Jore
- Re: when to use char, varchar or text, Adam Erickson
I WANT TO UNSUBSCRIBE, Pierre-Alexis PAQUIN
make default field entry NULL?, Rory Campbell-Lange
- Re: make default field entry NULL?, John Taylor
Moving data to different hard drive /or/ incremental backup, Brian Johnson
- Re: Moving data to different hard drive /or/ incremental backup, Josh Berkus
How to Identify a SERIAL column type?, Phillip J. Allen
SELECT DISTINCT, stev knowles
- Re: SELECT DISTINCT, Andrew McMillan
optimising data load, John Taylor
- Re: optimising data load, Ron Johnson
  - Re: optimising data load, John Taylor
    - Re: optimising data load, Ron Johnson
    - Re: optimising data load, John Taylor
    - Re: optimising data load, Ron Johnson
    - Re: optimising data load, John Taylor
    - Re: optimising data load, Andrew McMillan
    - Full Outer Joins, John Taylor
    - Re: Full Outer Joins, Joel Burton
    - 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: optimising data load, Rasmus Mohr
- Re: optimising data load, Patrick Hatcher
- Re: optimising data load, John Taylor
- Re: optimising data load, John Taylor
Undead record haunts my database, need exorcism, Kevin Sterner
- Re: Undead record haunts my database, need exorcism, Tom Lane
  - Re: Undead record haunts my database, need exorcism, Kevin Sterner
    - Re: Undead record haunts my database, need exorcism, Tom Lane
pl/perl Documentation, Duncan Adams (DNS)
- Re: pl/perl Documentation, Tom Lane
  - Re: pl/perl Documentation, Joshua b. Jore
    - Re: pl/perl Documentation, Tom Lane
    - Re: pl/perl Documentation, Thomas A. Lowery
- Re: pl/perl Documentation, Duncan Adams (DNS)
[Fwd: Re: PostgreSQL+Access97+Linux: How to..], Ron Johnson
PostgreSQL+Access97+Linux: How to.., Victor Manuel Torres Aguirre
- Re: PostgreSQL+Access97+Linux: How to.., Ron Johnson
- Re: PostgreSQL+Access97+Linux: How to.., Josh Berkus
Better way to bulk-load millions of CSV records into postgres?, Ron Johnson
- Re: Better way to bulk-load millions of CSV records into postgres?, Josh Berkus
- Re: Better way to bulk-load millions of CSV records into postgres?, Joel Burton
- Re: Better way to bulk-load millions of CSV records into postgres?, Tom Sheehan
  - Re: Better way to bulk-load millions of CSV records into postgres?, Marc Spitzer
    - Re: Better way to bulk-load millions of CSV records into, Ron Johnson
    - Re: Better way to bulk-load millions of CSV records into, Marc Spitzer
    - Re: Better way to bulk-load millions of CSV records into, Ron Johnson
    - Re: Better way to bulk-load millions of CSV records into, Marc Spitzer
  - Re: Better way to bulk-load millions of CSV records into, Ron Johnson
Large tables being split at 1GB boundary, Ron Johnson
- Re: Large tables being split at 1GB boundary, Tom Lane
Problem with inserting: attribute 'extended_reason', Wim
- Re: Problem with inserting: attribute 'extended_reason', Joel Burton
Re: [SQL] Guarantee uniqueness of PGP key, Joel Burton
Guarantee uniqueness of PGP key, andre
- Re: Guarantee uniqueness of PGP key, D. Duccini
- Re: Guarantee uniqueness of PGP key, Bruno Wolff III
  - Re: Guarantee uniqueness of PGP key, andre
Transactions over several db sessions, ghinchliffe
Accessing table attributes from within PlPgSQL, Ron Johnson
- Re: Accessing table attributes from within PlPgSQL, Henshall, Stuart - WCP
New features in PlPgSQL, Ron Johnson
Some CSV file-import questions, Ron Johnson
- Re: Some CSV file-import questions, Andrew McMillan
  - Is a randomized default value primary key possible?, April L
    - Re: Is a randomized default value primary key possible?, Ron Johnson
    - Re: Is a randomized default value primary key possible?, Josh Berkus
    - Re: Is a randomized default value primary key, April L
    - Re: Is a randomized default value primary key, Joel Burton
    - Re: Is a randomized default value primary key, ghaverla
    - Re: Is a randomized default value primary key, Josh Berkus
    - Re: Is a randomized default value primary key, Ron Johnson
Forgotten the master password of db, thiemo
- Re: Forgotten the master password of db, Tom Lane
  - Re: Forgotten the master password of db, thiemo
- Re: Forgotten the master password of db, Josh Berkus
Fw: Selecting random rows using weights, Masaru Sugawara
Re upgrading 7.1 to 7.2, bob parker
ADD CONSTRAINT NOT NULL, how?, Lutz Horn
- Re: ADD CONSTRAINT NOT NULL, how?, Tom Lane
Casting from varchar to numeric, Tom Ansley
- Re: Casting from varchar to numeric, Josh Berkus
- Re: Casting from varchar to numeric, Adam Erickson
- Re: Casting from varchar to numeric, Tom Ansley
- Re: Casting from varchar to numeric, Joel Burton
7.2 startup with md5 pass?, Rasputin
data-type for image files, sibusiso xolo
- Re: data-type for image files, Josh Berkus
  - Re: data-type for image files, john-paul delaney
Answering my own question, gerry . smit
- Re: Answering my own question, Manuel Sugawara
- Re: Answering my own question, ghaverla
- Answering my own question, gerry . smit
- Re: Answering my own question, gerry . smit
  - Re: Answering my own question, Francisco Reyes
  - Re: Answering my own question, Manuel Sugawara
  - Re: Answering my own question, Balazs Wellisch
  - Re: Answering my own question, Chris
- Re: Answering my own question, gerry . smit
  - Re: Answering my own question, Francisco Reyes
- Re: Answering my own question, gerry . smit
- Re: Answering my own question, gerry . smit
  - Re: Answering my own question, Adam Erickson
  - Re: Answering my own question, Francisco Reyes
- Re: Answering my own question, gerry . smit
- Re: Answering my own question, gerry . smit
- Re: Answering my own question, gerry . smit
Trouble with index in 7.1, gerry . smit
- Re: Trouble with index in 7.1, Adam Erickson
- Re: Trouble with index in 7.1, Tom Lane
- Re: Trouble with index in 7.1, gerry . smit
Catching errors inside transactions, John Taylor
- Re: Catching errors inside transactions, Manuel Sugawara
- Re: Catching errors inside transactions, John Taylor
trigger, transactions, eek, Chris Thompson
- Re: trigger, transactions, eek, Manuel Sugawara
Did I install version 7.2.1?, Patrick Hatcher
- Re: Did I install version 7.2.1?, Josh Berkus
Cascading Changes, Tom Ansley
- Re: Cascading Changes, Joel Burton
- Re: Cascading Changes, Oliver Elphick
pgsql on win98, Paulo Henrique Werly Gualberto
Description of Functions, Sharon Cowling
newbie: Column CHECK(col contains '@') ?, john-paul delaney
- Re: newbie: Column CHECK(col contains '@') ?, Josh Berkus
- Re: newbie: Column CHECK(col contains '@') ?, Joel Burton
  - Re: newbie: Column CHECK(col contains '@') ?, john-paul delaney
    - Re: newbie: Column CHECK(col contains '@') ?, Andrew McMillan
    - Re: newbie: Column CHECK(col contains '@') ?, john-paul delaney
    - Re: newbie: Column CHECK(col contains '@') ?, Joel Burton
    - Re: newbie: Column CHECK(col contains '@') ?, Josh Berkus
    - Re: newbie: Column CHECK(col contains '@') ?, john-paul delaney
    - Re: newbie: Column CHECK(col contains '@') ?, Josh Berkus
    - Re: newbie: Column CHECK(col contains '@') ?, Juliet May
Converting epoc number to timestamp, Doug Silver
- Selecting random rows using weights, G
- Re: Converting epoc number to timestamp, Oliver Elphick
Newbie Date Problems, John Nix
- Re: Newbie Date Problems, Josh Berkus
  - Re: Newbie Date Problems, John Nix
Ready to go live!!!, Tom Ansley
Database structure, Peter Goggin
- Re: Database structure, Josh Berkus
- Database Structure, Peter Goggin
- Database Structure, Peter Goggin
- Re: Database structure, Henshall, Stuart - WCP
  - Re: Database structure, Joshua b. Jore
Too many clients, Leandro Fanzone
- Re: Too many clients, Tom Lane
Partial table copy?, Mark Thomas
- Re: Partial table copy?, Tom Lane
View don't know table, Reinhard Hnat
Appending values non-destructively, Andre Dubuc
- Re: Appending values non-destructively, Joshua b. Jore
  - Re: Appending values non-destructively, Andre Dubuc
    - Re: Appending values non-destructively, Joshua b. Jore
- Re: Appending values non-destructively, Henshall, Stuart - WCP
- Re: Appending values non-destructively, Henshall, Stuart - WCP
  - Re: Appending values non-destructively, Andre Dubuc
Incorrect Query, Sharon Cowling
- Re: Incorrect Query, Andrew McMillan
  - Re: Incorrect Query, Sharon Cowling
- Re: Incorrect Query, Joshua b. Jore
- Re: Incorrect Query, Sharon Cowling
- Re: Incorrect Query, Sharon Cowling
Relation does not exist, Brian Schroeder
- Re: Relation does not exist, April L
  - Re: Relation does not exist, Tom Lane
- Re: Relation does not exist, Brian Schroeder
- Re: Relation does not exist, Brian Schroeder
- Re: Relation does not exist, Brian Schroeder
more voodoo planner bs :), D. Duccini
- voodoo planner update, D. Duccini
- Re: more voodoo planner bs :), Tom Lane
Functions replicating stored procedures, Joshua Moore-Oliva
- Re: Functions replicating stored procedures, Henshall, Stuart - WCP
Problems with psql : ERROR : pg_user: permission denied,and I can 't type \ in psql, Joseph . ROTHWELL
- Re: Problems with psql : ERROR : pg_user: permission, Josh Berkus
ERROR: $1 is declared CONSTANT in plpgsql, Hans Plum
- Re: ERROR: $1 is declared CONSTANT in plpgsql, Jason Davis
- Re: ERROR: $1 is declared CONSTANT in plpgsql, Tom Lane
- Re: ERROR: $1 is declared CONSTANT in plpgsql, Oliver Elphick
- Re: ERROR: $1 is declared CONSTANT in plpgsql, Henshall, Stuart - WCP
Cascaded updates / deletes don't work on inherited tables, Michael Barber
- Re: Cascaded updates / deletes don't work on inherited, Joshua b. Jore
Stored Procedures, Wendy Powley
- Re: Stored Procedures, Josh Berkus
- Re: Stored Procedures, Josh Berkus
search and replace possible on SQL?, Duncan Adams (DNS)
- Re: search and replace possible on SQL?, Bruno Wolff III
- Re: search and replace possible on SQL?, Andrew McMillan
Triggers in the db, Rob
- Re: Triggers in the db, Joshua b. Jore
insert multiple rows, G
- Re: insert multiple rows, Andrew McMillan
  - Altering columns without losing data, G
    - Re: Altering columns without losing data, Aarni Ruuhimäki / Megative Tmi / KYMI.com
Re: Tricky query, Vijay Deval
- Re: Tricky query, Joel Burton
Date Formatting, Tom Ansley
- Re: Date Formatting, Oliver Elphick
- Re: Date Formatting, hodges
- Re: Date Formatting, Doug Silver
  - Re: Date Formatting, Joel Burton
  - Re: Date Formatting, Richard A Lough
    - Time Formatting, hodges
    - Re: Time Formatting, Larry Rosenman
    - Re: Time Formatting, hodges
    - Re: Time Formatting, Andrew McMillan
    - Re: Time Formatting, hodges
    - Re: Time Formatting, Andrew McMillan
    - Re: Time Formatting, hodges
[Fwd: Re: SELECT INTO an array], Alberto Bolchini
Forte for Java & Postgres, Slawek Jarosz
SELECT INTO an array, Alberto Bolchini
- Re: SELECT INTO an array, Josh Berkus
(unknown), Kristian Skrede Gleditsch
- Re:, Tom Lane
  - (unknown), Kristian Skrede Gleditsch
- Re:, Aarni Ruuhimäki / Megative Tmi / KYMI.com
error on create rule., Duncan Adams (DNS)
Limiting number of records to show., Wim
- Re: Limiting number of records to show., Duncan Adams (DNS)
  - Re: Limiting number of records to show., Wim
    - Re: Limiting number of records to show., Joshua b. Jore
root of parent-child table with NOT NULL constraint, bill
- Re: root of parent-child table with NOT NULL, Josh Berkus
Transaction Question, mark lonsdale
- Re: Transaction Question, Masaru Sugawara
ALTER TABLE table DROP CONSTRAINT problem, Lewis Bergman
- Re: ALTER TABLE table DROP CONSTRAINT problem, Tom Lane
plpgsql - why it is not available by default ?, Emma
Window 98 and NT, Peter Goggin
- Re: Window 98 and NT, Warwick Hunter
- Re: Window 98 and NT, Henshall, Stuart - WCP
non-root installation of Postgresql?, Terrence Brannon
- Re: non-root installation of Postgresql?, Aarni Ruuhimäki / Megative Tmi / KYMI.com
  - Re: non-root installation of Postgresql?, Terrence Brannon
- Re: non-root installation of Postgresql?, Tom Lane
  - Re: non-root installation of Postgresql?, Terrence Brannon
Trying to reduce per tuple overhead, Manfred Koizar
- Re: Trying to reduce per tuple overhead, Rasmus Mohr
if postmaster is started on a certain port, should I be able to telnet there?, Terrence Brannon
- Re: if postmaster is started on a certain port, should I be able to telnet there?, Tom Lane
error messages, P. Jourdan
- Re: error messages, Oliver Elphick
- error messages, PJourdan
  - Re: error messages, Josh Berkus
    - Re: error messages, P. Jourdan
    - Re: error messages, P. Jourdan
Once again about 'OID', Denny Permana
- Re: Once again about 'OID', Josh Berkus
- Re: Once again about 'OID', Josh Berkus
What are schemas?, Francisco Reyes
- Re: What are schemas?, Tom Lane
  - Re: What are schemas?, Francisco Reyes
- Re: What are schemas?, Vijay Deval