Mailing lists [pgsql-novice]

1 April 2006

• 21:07   Encoding problem in psql (Windows) Markus Reinhold
• 21:09   Two configuration issues... E. Matthew Finnin

2 April 2006

• 06:48   Semaphore trouble for installation Yadnyesh Joshi

3 April 2006

• 14:17   Re: Semaphore trouble for installation Brad Nicholson
• 17:38   Re: Two configuration issues... george young

4 April 2006

• 06:58   compare month shakil tanvir
• 07:05   compare month[modified] shakil tanvir
• 07:09   Re: compare month A. Kretschmer
• 07:10   Re: compare month Michael Glaesemann
• 07:44   Re: compare month Kaloyan Iliev
• 07:45   Re: compare month[modified] Kaloyan Iliev
• 12:46   BYTEA: insert query max size inner
• 13:43   Re: BYTEA: insert query max size Tom Lane
• 15:22   Re: compare month[modified] george young
• 16:45   Re: BYTEA: insert query max size inner
• 19:53   query to return hourly snapshot Richard Broersma Jr
• 20:03   Re: BYTEA: insert query max size Tom Lane
• 21:00   Re: BYTEA: insert query max size inner
• 21:23   Re: BYTEA: insert query max size Tom Lane
• 21:55   Re: Semaphore trouble for installation Tomeh, Husam
• 22:34   WAL to get back data in 7.4. doris riedl
• 23:01   for loop help Luis Silva

5 April 2006

• 02:48   Re: WAL to get back data in 7.4. Tom Lane
• 09:25   Re: for loop help A. Kretschmer

6 April 2006

• 12:04   Layout question Jan Danielsson
• 12:15   Re: Layout question Sean Davis
• 21:12   On "linking" the types of two columns 
• 21:24   Re: On "linking" the types of two columns Richard Broersma Jr
• 23:02   Re: On "linking" the types of two columns 

7 April 2006

• 02:35   Foreign keys and inheritance Pierre Thibaudeau
• 04:18   Re: Layout question Pierre Thibaudeau
• 04:54   Scheduled Job at PostgreSQL shakil tanvir
• 05:08   Re: Scheduled Job at PostgreSQL A. Kretschmer
• 05:37   Re: Foreign keys and inheritance Richard Broersma Jr
• 05:41   Re: Scheduled Job at PostgreSQL Richard Broersma Jr
• 06:42   Re: On "linking" the types of two columns Christoph Della Valle
• 15:33   Re: Scheduled Job at PostgreSQL Kevin Crenshaw

8 April 2006

• 03:02   Re: Foreign keys and inheritance Michael Glaesemann
• 07:55   out or memory error Moginraj Mohandas
• 15:09   How to append records into a file which has serial unique IDs? James Long
• 16:19   Re: out or memory error Tom Lane

9 April 2006

• 02:21   Re: How to append records into a file which has serial george young
• 02:30   Re: How to append records into a file which has serial Michael Glaesemann
• 03:29   Re: Problems using PostgreSQL command line tools Bruce Momjian
• 03:38   Re: PostgreSQL a slow DB? Bruce Momjian
• 12:27   Re: PostgreSQL a slow DB? Mike
• 13:52   Re: PostgreSQL a slow DB? Sid Murthy
• 19:01   Restoring Database problem, tsearch Mag Gam
• 20:30   replication Tom Allison
• 20:55   Re: replication Alan Hodgson

10 April 2006

• 05:28   select id,count(imdb_id) problem Ntina Papadopoulou
• 05:38   Re: select id,count(imdb_id) problem A. Kretschmer
• 05:52   Re: select id,count(imdb_id) problem Ntina Papadopoulou
• 06:00   Re: select id,count(imdb_id) problem A. Kretschmer
• 06:05   Re: select id,count(imdb_id) problem Bruno Wolff III
• 06:07   Re: select id,count(imdb_id) problem Ntina Papadopoulou
• 06:26   Re: select id,count(imdb_id) problem Ntina Papadopoulou
• 17:51   Re: select id,count(imdb_id) problem Bruno Wolff III
• 18:03   Re: PostgreSQL a slow DB? 
• 20:44   Partitioning table - explain said that all partition tables are scanned Pazargic Antonel Ernest
• 20:44   Sequence Current Value Resetting Douglas Doolittle
• 20:44   how to encrypt trigger function Winson Yung
• 20:44   WAL - recovery of updated dataset doris riedl
• 20:44   BYTEA: insert query max size Dmitry
• 20:44   How to append records into a file which has serial unique IDs? James Long
• 20:44   Explain query on table with partition tables Pazargic Antonel Ernest
• 20:44   Explain query on table with partition tables is strange Pazargic Ernest Antonel
• 20:45   Postgresql module for freeradius on Debian lmyho
• 20:45   Re: How to append records into a file which has serial James Long
• 20:52   count(imdb_id) problem William Wallace
• 20:52   Re: PostgreSQL a slow DB? Relaxin
• 20:52   advice on setting up schema sought danmcb
• 20:53   Re: Plain ANSI C Compiled on Win32 Relaxin
• 20:53   Re: How to append records into a file which has serial James Long
• 20:53   Re: PostgreSQL a slow DB? Relaxin
• 22:10   Re: PostgreSQL a slow DB? Terry Lee Tucker
• 22:18   Re: PostgreSQL a slow DB? 
• 22:34   Re: Transfer from MySQL to PostgreSQL Bruce Momjian
• 22:44   Re: Explain query on table with partition tables Tom Lane
• 23:10   Re: Partitioning table - explain said that all partition tables are scanned Tom Lane
• 23:32   Re: PostgreSQL a slow DB? Richard Broersma Jr

11 April 2006

• 00:09   Re: PostgreSQL a slow DB? 
• 00:45   Re: PostgreSQL a slow DB? 
• 01:05   Triggering a table id from a sequence Lan Barnes
• 01:49   Re: PostgreSQL a slow DB? 
• 02:08   Re: PostgreSQL a slow DB? Alan Hodgson
• 02:22   Re: Sequence Current Value Resetting John DeSoi
• 02:23   Re: how to encrypt trigger function John DeSoi
• 02:30   Re: PostgreSQL a slow DB? Richard Broersma Jr
• 03:20   Re: Triggering a table id from a sequence Richard Broersma Jr
• 05:08   Re: How to append records into a file which has serial unique IDs? John DeSoi
• 05:27   Re: Triggering a table id from a sequence A. Kretschmer
• 05:30   Re: advice on setting up schema sought 
• 05:46   Re: PostgreSQL a slow DB? Christoph Della Valle
• 09:12   Postgres Config/Tuning problem Andrew Walmsley
• 12:37   Re: how to encrypt trigger function John DeSoi
• 14:10   Re: Postgres Config/Tuning problem Tom Lane
• 14:43   Re: How to append records into a file which has serial george young
• 16:40   Re: advice on setting up schema sought Bruno Wolff III
• 16:46   SELECT of a glob Lan Barnes
• 17:12   transaction identifier Luis Silva
• 17:56   Re: SELECT of a glob Lan Barnes
• 18:07   Indexes slower when used in decending vs. ascending order? Alasdair Young
• 18:25   Re: Indexes slower when used in decending vs. ascending order? Tom Lane
• 19:11   Curses interface Andre Majorel
• 19:22   Re: advice on setting up schema sought 
• 20:31   Re: Curses interface 
• 20:47   Re: Indexes slower when used in decending vs. ascending Alasdair Young
• 20:53   Re: Indexes slower when used in decending vs. ascending order? Tom Lane
• 20:54   Re: advice on setting up schema sought Bruno Wolff III
• 20:59   Re: Indexes slower when used in decending vs. ascending Alasdair Young
• 21:04   How to query for Interval Vishal Kashyap
• 21:06   Re: Indexes slower when used in decending vs. ascending order? Tom Lane
• 21:13   Re: advice on setting up schema sought 
• 21:25   Re: How to query for Interval Richard Broersma Jr
• 21:40   Re: How to query for Interval Richard Broersma Jr
• 22:26   Re: Curses interface Andre Majorel
• 23:47   Re: Indexes slower when used in decending vs. ascending order? Alasdair Young
• 23:52   Re: Indexes slower when used in decending vs. ascending order? Alasdair Young
• 23:54   Re: Sequence Current Value Resetting John DeSoi

12 April 2006

• 03:00   Re: advice on setting up schema sought Bruno Wolff III
• 03:19   Re: Indexes slower when used in decending vs. ascending order? Tom Lane
• 05:30   Re: How to query for Interval A. Kretschmer
• 06:05   Re: advice on setting up schema sought 
• 07:03   Configure command from a precompiled package Jonathan Tse
• 09:10   Re: Configure command from a precompiled package Jonathan Tse
• 11:40   Removing Tsearch2 Mag Gam
• 13:07   Re: How to query for Interval Vishal Kashyap
• 14:01   Re: Configure command from a precompiled package Tom Lane
• 15:30   Re: Removing Tsearch2 Nikolay Samokhvalov
• 16:43   Re: Indexes slower when used in decending vs. ascending Steve Crawford
• 18:16   Re: Indexes slower when used in decending vs. ascending order? Alasdair Young
• 18:52   The COPY command and csv files E. Matthew Finnin

13 April 2006

• 00:37   In plpgsql: difference between := and = David
• 00:43   Re: In plpgsql: difference between := and = Tom Lane
• 01:47   Re: Configure command from a precompiled package Jonathan Tse
• 02:37   Re: In plpgsql: difference between := and = David
• 04:24   Re: In plpgsql: difference between := and = Tom Lane
• 13:13   Re: PostgreSQL a slow DB? Bruce Momjian
• 15:08   mutually exclusive subtypes Olinga K. Abbott
• 15:57   Re: mutually exclusive subtypes Daniel T. Staal
• 17:06   Re: mutually exclusive subtypes Richard Broersma Jr
• 18:09   Colors/bold chars in a select? Ennio-Sr
• 20:49   Re: Colors/bold chars in a select? 
• 21:08   Steps to open or import a data file from Pg 8.1.3? James.M.Jocius@skf.com
• 21:22   Re: Steps to open or import a data file from Pg 8.1.3? 
• 22:11   Re: Colors/bold chars in a select? Ennio-Sr
• 22:29   Re: The COPY command and csv files Bruce Momjian
• 23:13   Re: Colors/bold chars in a select? 

14 April 2006

• 21:25   Re: Colors/bold chars in a select? Ennio-Sr
• 22:08   On the subject of inheritance Martin Foster
• 22:49   Re: On the subject of inheritance Tom Lane

15 April 2006

• 00:03   Re: On the subject of inheritance Martin Foster
• 02:37   Crontab problem with backup Kirti
• 03:24   Re: Crontab problem with backup Alan Hodgson
• 04:19   Re: Crontab problem with backup Tom Lane
• 04:29   Re: Crontab problem with backup Bruce Momjian
• 14:22   Re: Colors/bold chars in a select? Andrew Chambers

16 April 2006

• 12:20   Re: Crontab problem with backup Frank Bax

17 April 2006

• 00:40   Renaming unnamed FK constraints Vincent Frison
• 01:43   Re: Renaming unnamed FK constraints Tom Lane
• 12:02   Re: how to encrypt trigger function Winson Yung
• 12:02   Re: PostgreSQL a slow DB? Chris Browne
• 12:02   Re: advice on setting up schema sought Daniel McBrearty
• 12:03   Re: PostgreSQL a slow DB? Relaxin
• 12:03   Re: PostgreSQL a slow DB? Sean McCune
• 12:03   Re: Curses interface Chris Browne
• 12:03   mutually exclusive subtypes Olinga K. Abbott
• 12:03   Re: PostgreSQL a slow DB? Relaxin
• 12:03   Re: PostgreSQL a slow DB? Christopher Browne
• 12:03   Re: PostgreSQL a slow DB? Relaxin
• 12:03   Install password not recognized none
• 12:12   Re: Install password not recognized Shoaib Mir
• 13:12   Re: PostgreSQL a slow DB? Mike Ellsworth
• 13:20   Re: PostgreSQL a slow DB? Frank Bax
• 14:10   Re: Crontab problem with backup Frank Bax
• 14:53   Re: PostgreSQL a slow DB? Tom Lane
• 15:26   Re: Renaming unnamed FK constraints Vincent Frison
• 15:26   Re: PostgreSQL a slow DB? Bruce Momjian
• 15:28   Re: PostgreSQL a slow DB? Mike
• 16:13   Re: Renaming unnamed FK constraints Tom Lane
• 16:38   Re: Renaming unnamed FK constraints Vincent Frison
• 16:45   Re: PostgreSQL a slow DB? Brant Fitzsimmons
• 17:26   Re: Renaming unnamed FK constraints Tom Lane
• 17:34   Re: PostgreSQL a slow DB? Relaxin
• 17:56   Re: PostgreSQL a slow DB? Richard Broersma Jr
• 18:02   Re: PostgreSQL a slow DB? Richard Broersma Jr
• 18:07   Re: PostgreSQL a slow DB? Bruce Momjian
• 18:11   Re: PostgreSQL a slow DB? Guido Barosio
• 18:13   Re: PostgreSQL a slow DB? Daniel T. Staal
• 18:17   Re: Renaming unnamed FK constraints Vincent Frison
• 18:27   Re: PostgreSQL a slow DB? Guido Barosio
• 19:37   Re: PostgreSQL a slow DB? Aarni Ruuhimäki
• 22:28   Re: PostgreSQL a slow DB? Bruce Momjian
• 23:27   Re: PostgreSQL a slow DB? 

18 April 2006

• 00:03   returning from a trigger Luis Silva
• 00:08   Re: returning from a trigger Luis Silva
• 00:25   Re: PostgreSQL a slow DB? richard
• 00:25   Re: PostgreSQL a slow DB? Relaxin
• 00:25   Re: PostgreSQL a slow DB? Relaxin
• 01:40   Re: PostgreSQL a slow DB? Greg Sabino Mullane
• 06:32   Re: PostgreSQL a slow DB? Christoph Della Valle
• 07:06   Re: The COPY command and csv files E. Matthew Finnin
• 07:24   Re: PostgreSQL a slow DB? 
• 10:50   Re: The COPY command and csv files Sean Davis
• 14:02   Re: The COPY command and csv files Tom Lane
• 14:13   Re: The COPY command and csv files Florian Reiser
• 14:31   Find all foreign keys and dropping them from a script. Robert Landsmeer
• 14:53   Re: Find all foreign keys and dropping them from a script. Michael Fuhr
• 15:51   Re: Find all foreign keys and dropping them from a script. Robert Landsmeer
• 17:37   Accessing fields in a function that returns a set of composite type - How? Matt Arnilo S. Baluyos (Mailing Lists)
• 17:45   Re: Accessing fields in a function that returns a set of composite type - How? Matt Arnilo S. Baluyos (Mailing Lists)
• 17:46   Re: Accessing fields in a function that returns a set of composite type - How? Alan Hodgson
• 17:58   Re: The COPY command and csv files Eric Matthew Finnin
• 17:59   Re: Find all foreign keys and dropping them from a script. George Young
• 19:27   Re: The COPY command and csv files Tom Lane
• 21:12   Maximum database size Reza Razavipour
• 21:16   Re: Maximum database size Richard Broersma Jr
• 23:41   postgresql connection problems Frances Collier
• 23:45   Re: Maximum database size Richard Broersma Jr

19 April 2006

• 00:03   Re: postgresql connection problems Richard Broersma Jr
• 00:08   Logging problem Michael Talbot-Wilson
• 01:41   Re: Logging problem Tom Lane
• 02:44   Re: postgresql connection problems Shane Ambler
• 02:50   Re: Maximum database size Shane Ambler
• 04:07   Re: Logging problem Michael Talbot-Wilson
• 04:16   Defining the same relation in another database Michael Talbot-Wilson
• 04:27   Schema 'public' Michael Talbot-Wilson
• 04:58   Re: Schema 'public' Richard Broersma Jr
• 05:11   Re: Schema 'public' Michael Talbot-Wilson
• 05:19   Re: Schema 'public' Richard Broersma Jr
• 05:31   Re: Schema 'public' Tom Lane
• 05:42   Re: Schema 'public' Tom Lane
• 08:17   Re: Defining the same relation in another database Shoaib Mir
• 08:55   Re: Defining the same relation in another database Guido Barosio
• 09:10   Re: Find all foreign keys and dropping them from a script. Robert Landsmeer
• 20:58   Re: Defining the same relation in another database Michael Talbot-Wilson

20 April 2006

• 02:29   pg_dump and restore - views Wang, Marcus
• 02:39   Re: pg_dump and restore - views Tom Lane
• 05:13   Re: pg_dump and restore - views Wang, Marcus
• 15:48   Re: postgresql connection problems Frances Collier
• 20:39   Re: Colors/bold chars in a select? Ennio-Sr
• 21:17   Constraining future rows based on past rows Ketema Harris

21 April 2006

• 08:18   retrieving specified rows kadil
• 08:27   Re: retrieving specified rows A. Kretschmer
• 11:52   Re: Colors/bold chars in a select? Andrew Chambers
• 17:22   Re: Colors/bold chars in a select? Ennio-Sr
• 20:51   need help 
• 20:58   Oracle Analytic Functions for PostreSQL Jean-Christophe Roux
• 21:08   Oracle Analytic Functions for PostreSQL John Christopher
• 21:13   Re: Oracle Analytic Functions for PostreSQL Richard Broersma Jr
• 21:49   Re: need help Tom Lane

22 April 2006

• 19:58   Using PostgresQL as a database back-end Amadeus Zilfinski
• 20:16   Re: Using PostgresQL as a database back-end Richard Broersma Jr

23 April 2006

• 08:58   Re: Oracle Analytic Functions for PostreSQL Andrew Chambers
• 17:45   Re: Oracle Analytic Functions for PostreSQL Nikolay Samokhvalov

24 April 2006

• 00:01   Temporarily disable strict UTF-8 checking Matt Arnilo S. Baluyos (Mailing Lists)
• 05:41   Re: Temporarily disable strict UTF-8 checking Tom Lane
• 19:39   stress tests problems Luis Silva
• 20:17   Re: stress tests problems Richard Broersma Jr
• 20:59   Re: stress tests problems Andrew Chambers

25 April 2006

• 15:24   probable faq: internal format of numerics Brian Hurt
• 15:41   Re: probable faq: internal format of numerics Tom Lane
• 16:05   Re: probable faq: internal format of numerics Brian Hurt
• 18:10   Re: probable faq: internal format of numerics Tom Lane
• 20:08   How to obtain algebraic sum of equal lines Ennio-Sr
• 20:42   Re: How to obtain algebraic sum of equal lines Frank Bax
• 20:56   Re: How to obtain algebraic sum of equal lines Oisin Glynn
• 21:17   Re: How to obtain algebraic sum of equal lines Ennio-Sr
• 21:25   Re: How to obtain algebraic sum of equal lines Oisin Glynn
• 21:25   Re: How to obtain algebraic sum of equal lines Frank Bax
• 21:57   Re: How to obtain algebraic sum of equal lines Ennio-Sr
• 21:57   Re: How to obtain algebraic sum of equal lines Ennio-Sr

26 April 2006

• 12:40   Perl and psql variables Mark Campbell
• 13:05   Re: Perl and psql variables Sean Davis
• 14:52   Re: How to obtain algebraic sum of equal lines Oscar Rodriguez Fonseca
• 16:38   Re: Perl and psql variables Tom Lane

27 April 2006

• 09:23   Re: Perl and psql variables Mark Campbell
• 13:56   error handling Verena Ruff
• 14:17   Re: error handling Terry Lee Tucker
• 15:28   Re: error handling Oscar Rodriguez Fonseca
• 16:56   Getting the indexes of a table Christian Hofmann
• 17:16   Re: Getting the indexes of a table Andreas Kretschmer
• 17:35   Re: Getting the indexes of a table Christian Hofmann
• 19:45   Re: error handling Bruno Wolff III

28 April 2006

• 01:30   8.1 (win32): partial index not used? 
• 01:39   Re: 8.1 (win32): partial index not used? Michael Artz
• 01:42   Re: 8.1 (win32): partial index not used? 
• 01:45   Re: 8.1 (win32): partial index not used? 
• 01:49   Re: 8.1 (win32): partial index not used? Tom Lane
• 15:27   WAL-related Problem? Lane Van Ingen
• 16:59   Re: WAL-related Problem? Lane Van Ingen

29 April 2006

• 20:04   Re: Oracle Analytic Functions for PostreSQL Christopher Browne
• 20:05   Re: Using PostgresQL as a database back-end Christopher Browne
• 20:05   Perl and psql variables Mark Campbell
• 20:05   Trigger to force fields to lowercase at insert/update Leonardo Boiko
• 20:05   running pg_dumpall as a cron job richard
• 20:17   Re: Trigger to force fields to lowercase at insert/update Andreas Kretschmer
• 20:18   Re: running pg_dumpall as a cron job Andreas Kretschmer
• 20:19   Re: Trigger to force fields to lowercase at insert/update Bruno Wolff III
• 21:33   PGAdmin3 Permisions 
• 21:37   Re: PGAdmin3 Permisions Andrej Ricnik-Bay
• 21:56   Re: PGAdmin3 Permisions 
• 22:01   Re: PGAdmin3 Permisions 
• 22:07   Multiple Postmasters (Linux) 
• 22:08   Re: PGAdmin3 Permisions Andrej Ricnik-Bay
• 22:22   Re: Multiple Postmasters (Linux) Tom Lane
• 23:58   Re: Multiple Postmasters (Linux) 

30 April 2006

• 07:36   Re: error handling Robert Wimmer