Mailing lists [pgsql-novice]

1 August 2005

• 17:18   qucik timestamp questions 
• 17:29   timestamp timezone problem 
• 17:37   Re: timestamp timezone problem Afton & Ray Still
• 21:35   os x and initdb data directory Dane Ensign
• 23:04   Re: timestamp timezone problem John DeSoi
• 23:09   Re: os x and initdb data directory John DeSoi

2 August 2005

• 08:05   Retrieving images from Postgres with C++ Johan C. de Koning
• 15:49   Make year 01/01/0001 but leave timestamp alone Walker, Jed S
• 16:15   Re: Make year 01/01/0001 but leave timestamp alone Keith Worthington
• 16:38   Re: Make year 01/01/0001 but leave timestamp alone John DeSoi
• 17:05   Re: Make year 01/01/0001 but leave timestamp alone Walker, Jed S
• 17:31   boolean or int2 
• 17:57   Strange Error on Table Creation Attempt 
• 18:36   Re: Strange Error on Table Creation Attempt Jeffrey Melloy
• 18:52   Re: boolean or int2 Keith Worthington
• 20:57   Re: Make year 01/01/0001 but leave timestamp alone Tom Lane
• 21:45   Re: Make year 01/01/0001 but leave timestamp alone Walker, Jed S

3 August 2005

• 12:53   SQL error code -601  jason.ctr.alburger@faa.gov
• 14:19   Fw: SQL error code -601  jason.ctr.alburger@faa.gov
• 16:18   Vacuum with Views John J. Urbaniak
• 16:28   sql question 
• 18:37   Re: Vacuum with Views Michael Fuhr
• 20:01   Re: Vacuum with Views John J. Urbaniak
• 21:12   Re: boolean or int2 
• 21:24   Leading Zeros 
• 21:56   Re: Leading Zeros Gordon Haverland

4 August 2005

• 03:57   Re: Leading Zeros 
• 04:34   Re: Leading Zeros David
• 04:41   string concatenation errors Dane Ensign
• 04:55   Re: Leading Zeros Gnanavel S
• 04:58   Re: string concatenation errors Gnanavel S
• 05:16   Re: string concatenation errors Gnanavel S
• 13:33   Re: Vacuum with Views Michael Fuhr
• 14:02   Re: Vacuum with Views John J. Urbaniak
• 15:53   using interval in a query with a column for the interval value? Walker, Jed S
• 16:19   change varchar(10) to varchar() 
• 16:35   connection string - DNS Adam O'Toole
• 18:07   Re: change varchar(10) to varchar() Jaime Casanova
• 19:24   using interval in a query with a column for the interval value? Walker, Jed S
• 19:56   Handling Daylight Savings Walker, Jed S
• 20:04   Re: using interval in a query with a column for the interval value? Michael Fuhr
• 20:21   Re: using interval in a query with a column for the interval value? Walker, Jed S
• 20:34   Re: Handling Daylight Savings Michael Fuhr
• 21:10   Re: Handling Daylight Savings Frank Bax
• 21:36   Re: Handling Daylight Savings Michael Fuhr

5 August 2005

• 04:04   Re: change varchar(10) to varchar() Gnanavel S
• 05:04   Re: change varchar(10) to varchar() 
• 18:41   Monitoring postmaster.log Walker, Jed S
• 23:04   CREATE CAST question Robert Wimmer

6 August 2005

• 04:20   Re: CREATE CAST question Tom Lane
• 04:50   Re: Monitoring postmaster.log Tom Lane

7 August 2005

• 23:45   Uploading and loading Sean

8 August 2005

• 02:06   Re: Uploading and loading Pascual De Ruvo
• 04:13   Tables view? Walker, Jed S
• 04:26   Re: Tables view? Tom Lane
• 15:04   postgresql with ssl on windows babu
• 20:26   Date Arithmetic in PL/pgSql Lane Van Ingen
• 20:45   Re: Date Arithmetic in PL/pgSql John DeSoi
• 21:09   Re: Date Arithmetic in PL/pgSql Tom Lane
• 23:48   Re: Uploading and loading Jeff Eckermann

9 August 2005

• 00:42   Re: Date Arithmetic in PL/pgSql Lane Van Ingen
• 00:44   Re: Uploading and loading Jason Wong
• 01:19   Re: Date Arithmetic in PL/pgSql Tom Lane
• 13:14   Suspend Referential Integrity? Jim Jarrett
• 13:31   Re: Suspend Referential Integrity? Michael Fuhr
• 13:32   Re: Suspend Referential Integrity? Sean Davis
• 23:13   Getting exception information (SQLERRM, SQLSTATE, etc.) Lance Arlaus
• 23:58   loading data for newb James Nobles

10 August 2005

• 02:38   Re: Getting exception information (SQLERRM, SQLSTATE, etc.) Tom Lane
• 02:52   Re: loading data for newb Tom Lane
• 13:40   Transaction blocks Alexander Kotelnikov
• 15:14   Re: Transaction blocks Alexander Kotelnikov
• 18:59   Re: using interval in a query with a column for the interval value? Bruno Wolff III

11 August 2005

• 00:26   Re: Transaction blocks Michael Fuhr
• 10:11   connection trouble Vanessa Conchodon
• 10:51   passing column name to a PL/pgsql function for ALTER TABLE ADD Alexander Kotelnikov
• 12:05   Re: Transaction blocks Alexander Kotelnikov
• 12:26   Index choice Sean Davis
• 12:53   Re: postgresql with ssl on windows Sivakumar K
• 13:25   Re: Transaction blocks Michael Fuhr
• 13:45   Re: connection trouble Michael Fuhr
• 14:39   Forcing WAL switch Walker, Jed S
• 14:40   Re: connection trouble Vanessa Conchodon
• 14:42   Re: connection trouble Tom Lane
• 14:57   Re: passing column name to a PL/pgsql function for ALTER TABLE ADD Michael Fuhr
• 16:09   Re: connection trouble Tom Lane
• 16:16   Re: Forcing WAL switch Tom Lane
• 16:19   Re: Forcing WAL switch Bruce Momjian
• 17:29   Re: loading data for newb tgoodaire@linux.ca (Tim Goodaire)
• 17:35   Re: Index choice 
• 18:43   Re: Forcing WAL switch Walker, Jed S
• 19:09   Cast Problem 
• 19:52   Re: Cast Problem Michael Fuhr
• 19:53   Select problems Lucas Grijander
• 20:04   Re: Select problems Michael Fuhr
• 21:14   Re: Cast Problem 
• 21:16   Re: Cast Problem - varchar() problem 
• 21:31   Re: Cast Problem Michael Fuhr
• 21:38   Re: Forcing WAL switch Tom Lane
• 21:49   Re: Cast Problem - varchar() problem Tom Lane
• 22:06   Re: Forcing WAL switch Walker, Jed S
• 22:11   Re: Forcing WAL switch Tom Lane
• 22:16   Re: Forcing WAL switch Walker, Jed S
• 22:20   Re: Forcing WAL switch Bruce Momjian
• 22:22   Re: Forcing WAL switch Tom Lane
• 23:11   Re: Forcing WAL switch Tom Lane

12 August 2005

• 00:25   Re: Forcing WAL switch Bruce Momjian
• 09:10   Alter table command is pretty slow Sreenivas K
• 12:45   CFMX7 / Linux / PgSQL Aarni Ruuhimäki
• 12:58   Re: connection trouble Vanessa Conchodon
• 14:30   Re: Forcing WAL switch Walker, Jed S
• 16:04   Re: Forcing WAL switch Bruce Momjian
• 16:08   ... Adam O'Toole
• 16:23   Re: [despammed] Kretschmer Andreas
• 17:23   Re: [GENERAL] Adam O'Toole

14 August 2005

• 11:10   Re: [despammed] Re: [GENERAL] Kretschmer Andreas
• 17:03   Re: [despammed] Re: [GENERAL] Adam O'Toole
• 22:12   Re: [GENERAL] Richard Huxton
• 22:15   Re: [GENERAL] Richard Huxton
• 22:23   Re: Alter table command is pretty slow Chris Browne
• 22:25   Re: postgresql with ssl on windows Sivakumar K
• 22:27   How to apply patches Pit Müller
• 22:29   passing column name to a plpgsql function for ALTER TABLE ADD Alexander Kotelnikov
• 22:36   SQL query question Alloni Kramer
• 22:38   Uploading and loading Sean Montague
• 22:44   PHP App Install Scripts and PostgreSQL Google Mike
• 22:47   Suspend Referential Integrity? Jim Jarrett
• 23:25   Re: Uploading and loading Steve Poe

15 August 2005

• 00:31   Re: SQL query question Tom Lane
• 14:10   restart postgres 7.3.2 problem Saranya Sivakumar
• 14:49   Re: restart postgres 7.3.2 problem Tom Lane
• 15:22   Re: restart postgres 7.3.2 problem Saranya Sivakumar
• 15:35   Re: restart postgres 7.3.2 problem Sean Davis
• 16:50   How to use vacuum on windows? Audrey Bergeron-Morin
• 17:22   Re: restart postgres 7.3.2 problem Tom Lane
• 17:29   Re: Suspend Referential Integrity? Bruno Wolff III
• 17:38   Re: Suspend Referential Integrity? Sean Davis
• 18:36   "external" variables and triggers Andrej Ricnik-Bay
• 19:58   Re: "external" variables and triggers Tom Lane
• 20:27   Adding variable intervals to timestamps Walker, Jed S
• 20:42   Re: Adding variable intervals to timestamps Bruno Wolff III
• 20:52   Re: Adding variable intervals to timestamps Walker, Jed S

16 August 2005

• 08:32   Re: Cron jobs and backup Aarni Ruuhimäki
• 15:25   Re: [pgsql-novice] Daily digest v1.1520 (14 messages) Saranya Sivakumar
• 18:01   how to rename an unnamed uniqueness constraint? Oliver Kullmann
• 22:14   Re: how to rename an unnamed uniqueness constraint? Oliver Elphick
• 22:16   Re: how to rename an unnamed uniqueness constraint? Oliver Elphick

17 August 2005

• 01:01   Modifiable sequence column? Leif K-Brooks
• 04:47   Re: Modifiable sequence column? Bruno Wolff III
• 17:10   Re: how to rename an unnamed uniqueness constraint? Oliver Kullmann
• 17:18   Re: how to rename an unnamed uniqueness constraint? Oliver Kullmann

18 August 2005

• 15:31   My First Stored Procedure 

19 August 2005

• 04:23   Intsall 8.03 on Redhat ES 3 rbradley
• 04:23   Tables are not being updated properly through Trigger Venkatesh Krishnamurthy
• 05:57   how to rename an unnamed uniqueness constraint? Oliver Kullmann
• 06:41   Re: how to rename an unnamed uniqueness constraint? Stuart Bishop
• 07:30   Re: Tables are not being updated properly through Trigger Oliver Elphick
• 14:44   Re: Intsall 8.03 on Redhat ES 3 Bruno Wolff III
• 14:54   Re: Intsall 8.03 on Redhat ES 3 Devrim GUNDUZ
• 15:31   Transaction Questions 
• 16:40   Re: Transaction Questions Josh Berkus

21 August 2005

• 14:53   Re: My First Stored Procedure 
• 15:31   Need a "development DB" 
• 16:58   Re: Need a "development DB" Kretschmer Andreas

22 August 2005

• 18:29   Password Authentication Mike
• 18:49   doubt Mogin Mohandas
• 19:14   How to list all databases? cbraden
• 19:36   Re: How to list all databases? Philip Hallstrom
• 19:55   Re: How to list all databases? Kretschmer Andreas
• 20:18   Re: How to list all databases? Steve Poe
• 22:17   New-B Question #2 cbraden

23 August 2005

• 05:24   Re: doubt Sivakumar K
• 06:07   Re: Password Authentication Oliver Elphick
• 06:09   Re: doubt Oliver Elphick
• 06:12   Re: New-B Question #2 Oliver Elphick
• 13:25   Removing PostGreSQL Services and Accounts Adam Bickford
• 16:31   Re: New-B Question #2 Philip Hallstrom

24 August 2005

• 13:39   function to escape single quotes Saranya Sivakumar
• 15:17   Re: function to escape single quotes Tom Lane
• 16:37   Re: Transaction Questions Josh Berkus
• 16:53   SQL problem? cbraden
• 17:14   Re: SQL problem? Kretschmer Andreas
• 17:44   Re: SQL problem? Stephan Szabo

25 August 2005

• 11:43   Re: Transaction Questions William Yu
• 18:46   Copy Failure 
• 19:31   Selective authentication? 
• 20:10   Re: Selective authentication? Charley L. Tiggs
• 20:11   Superuser can execute but not view function Mike G.
• 20:25   query optimization Saranya Sivakumar
• 21:05   Re: query optimization Josh Berkus
• 21:44   Re: Superuser can execute but not view function Michael Fuhr
• 23:48   Re: SQL problem? 

26 August 2005

• 02:23   Re: SQL problem? Bruno Wolff III
• 04:18   Re: Copy Failure Tom Lane
• 04:36   Re: Selective authentication? Tom Lane
• 15:00   Re: SQL problem? Charley L. Tiggs
• 15:11   Re: SQL problem? Bruno Wolff III
• 16:10   Packet sizes on transfers between client/server Walker, Jed S
• 16:18   Form to populate a pg table with data Ennio-Sr
• 16:54   Re: Packet sizes on transfers between client/server Tom Lane
• 17:08   Re: Copy Failure 
• 17:10   Re: Packet sizes on transfers between client/server Michael Fuhr
• 17:51   Re: SQL problem? 
• 18:35   Re: Packet sizes on transfers between client/server Michael Fuhr
• 19:19   Re: Packet sizes on transfers between client/server Walker, Jed S
• 19:55   SQL safe input? cbraden
• 19:58   SQL "OR" Problem 
• 20:20   Re: SQL "OR" Problem Frank Bax
• 20:21   Re: SQL "OR" Problem Philip Hallstrom
• 20:30   Re: SQL "OR" Problem Tom Lane
• 20:33   Re: SQL "OR" Problem Stephan Szabo
• 20:44   Re: SQL safe input? Bruno Wolff III
• 21:01   Re: SQL safe input? Philip Hallstrom
• 21:32   Re: SQL "OR" Problem 
• 21:46   Re: SQL "OR" Problem - Small Update 
• 22:06   Re: SQL "OR" Problem Steve Crawford
• 22:08   Re: SQL safe input? Charley L. Tiggs
• 22:53   Prepare() Value 
• 22:58   Re: SQL safe input? 

27 August 2005

• 01:28   digest TheHiddenDragon
• 03:32   Re: SQL safe input? Bruno Wolff III
• 03:34   Re: SQL safe input? Bruno Wolff III
• 04:47   Created objects not visible Alex du Plessis
• 04:47   LOG entries: "could not receive data from client" ? 
• 05:19   Re: LOG entries: "could not receive data from client" ? Michael Fuhr
• 06:43   Re: Created objects not visible Kretschmer Andreas
• 14:40   Re: Created objects not visible Tom Lane
• 15:34   index: specify sort order? 
• 15:52   Re: index: specify sort order? Stephan Szabo
• 16:25   Re: index: specify sort order? 
• 19:46   Re: index: specify sort order? Stephan Szabo
• 21:11   pgdata, pg_ctl wont start Dane Ensign
• 23:22   Re: SQL safe input? 
• 23:54   Re: SQL safe input? Bruno Wolff III

28 August 2005

• 01:55   Re: SQL safe input? 
• 02:48   Re: SQL safe input? Bruno Wolff III
• 11:45   see all queries incoming Flávio Brito
• 12:34   Re: see all queries incoming Kretschmer Andreas
• 13:19   Re: see all queries incoming Michael Fuhr
• 13:32   Re: see all queries incoming Kretschmer Andreas
• 13:44   Re: see all queries incoming Flávio Brito
• 14:23   Re: see all queries incoming Kretschmer Andreas
• 21:19   Re: query optimization Tom Lane
• 21:43   question - plpgsql and query on table given by variable  Jaromír Kamler
• 21:56   Re: question - plpgsql and query on table given by variable Michael Fuhr

29 August 2005

• 09:13   Fwd: Re: question - plpgsql and query on table given by variable  Jaromír Kamler
• 18:43   array vs flat tables performance Oren Mazor
• 19:11   understanding the interaction with delete/select/vacuum Alan Stange
• 19:18   Re: understanding the interaction with delete/select/vacuum Oren Mazor
• 19:52   Re: understanding the interaction with delete/select/vacuum Tom Lane
• 20:10   Re: understanding the interaction with delete/select/vacuum Alan Stange
• 20:34   message dupes anyone ? Andreas

30 August 2005

• 00:54   triggers: how to check if a field changed? 
• 03:00   Disabling Trigger Prasad dev
• 03:18   Re: Fwd: Re: question - plpgsql and query on table given by variable Michael Fuhr
• 04:25   Re: triggers: how to check if a field changed? Lance Arlaus
• 04:42   Re: Disabling Trigger Tom Lane
• 06:30   Fwd: Re: Fwd: Re: question - plpgsql and query on table given by variable  Jaromír Kamler
• 14:42   Re: array vs flat tables performance Oren Mazor
• 16:23   Copy function syntax on 8.1 Mike G.
• 16:35   Re: Copy function syntax on 8.1 Bruce Momjian
• 16:39   Re: Copy function syntax on 8.1 Tom Lane
• 17:25   Re: Copy function syntax on 8.1 Mike G.
• 17:32   New PGSQL and Linux Setup on Old Box 
• 17:54   Re: Copy function syntax on 8.1 Tom Lane
• 18:58   Re: New PGSQL and Linux Setup on Old Box Bruno Wolff III
• 19:53   Re: Copy function syntax on 8.1 Mike G.
• 21:16   pgsql installation problem! Ricardo Gamero
• 21:33   Re: Disabling Trigger Prasad dev
• 21:36   Re: pgsql installation problem! Tom Lane
• 21:40   Re: Disabling Trigger Tom Lane
• 22:27   Re: Copy Failure 
• 22:57   Re: Copy function syntax on 8.1 Bruce Momjian
• 22:58   Sorting Challenge 
• 23:14   Re: Copy function syntax on 8.1 Tom Lane
• 23:24   Re: Copy function syntax on 8.1 Bruce Momjian

31 August 2005

• 03:26   Re: pgsql installation problem! Bruno Wolff III
• 03:34   Re: Sorting Challenge Bruno Wolff III
• 05:51   Re: Sorting Challenge 
• 06:29   PGSQL, Fedora core 3 and a PII 400 MHz Box 
• 12:18   psql commandline dIGITx
• 12:23   psql commandline digit-x@gmx.net
• 14:27   Re: psql commandline Charley L. Tiggs
• 18:09   Re: Sorting Challenge Bruno Wolff III
• 20:31   SQL Time Issue 
• 22:03   Re: SQL Time Issue Michael Glaesemann
• 23:47   Re: SQL Time Issue