Mailing lists [pgsql-novice]

1 August 2005

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

2 August 2005

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

3 August 2005

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

4 August 2005

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

5 August 2005

• 01:04   Re: change varchar(10) to varchar() Gnanavel S
• 02:04   Re: change varchar(10) to varchar() 
• 15:41   Monitoring postmaster.log Walker, Jed S
• 20:04   CREATE CAST question Robert Wimmer

6 August 2005

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

7 August 2005

• 20:45   Uploading and loading Sean
• 23:06   Re: Uploading and loading Pascual De Ruvo

8 August 2005

• 01:13   Tables view? Walker, Jed S
• 01:26   Re: Tables view? Tom Lane
• 12:04   postgresql with ssl on windows babu
• 17:26   Date Arithmetic in PL/pgSql Lane Van Ingen
• 17:45   Re: Date Arithmetic in PL/pgSql John DeSoi
• 18:09   Re: Date Arithmetic in PL/pgSql Tom Lane
• 20:48   Re: Uploading and loading Jeff Eckermann
• 21:42   Re: Date Arithmetic in PL/pgSql Lane Van Ingen
• 21:44   Re: Uploading and loading Jason Wong
• 22:19   Re: Date Arithmetic in PL/pgSql Tom Lane

9 August 2005

• 10:14   Suspend Referential Integrity? Jim Jarrett
• 10:31   Re: Suspend Referential Integrity? Michael Fuhr
• 10:32   Re: Suspend Referential Integrity? Sean Davis
• 20:13   Getting exception information (SQLERRM, SQLSTATE, etc.) Lance Arlaus
• 20:58   loading data for newb James Nobles
• 23:38   Re: Getting exception information (SQLERRM, SQLSTATE, etc.) Tom Lane
• 23:52   Re: loading data for newb Tom Lane

10 August 2005

• 10:40   Transaction blocks Alexander Kotelnikov
• 12:14   Re: Transaction blocks Alexander Kotelnikov
• 15:59   Re: using interval in a query with a column for the interval value? Bruno Wolff III
• 21:26   Re: Transaction blocks Michael Fuhr

11 August 2005

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

12 August 2005

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

14 August 2005

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

15 August 2005

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

16 August 2005

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

17 August 2005

• 01:47   Re: Modifiable sequence column? Bruno Wolff III
• 14:10   Re: how to rename an unnamed uniqueness constraint? Oliver Kullmann
• 14:18   Re: how to rename an unnamed uniqueness constraint? Oliver Kullmann

18 August 2005

• 12:31   My First Stored Procedure 

19 August 2005

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

21 August 2005

• 11:53   Re: My First Stored Procedure 
• 12:31   Need a "development DB" 
• 13:58   Re: Need a "development DB" Kretschmer Andreas

22 August 2005

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

23 August 2005

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

24 August 2005

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

25 August 2005

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

26 August 2005

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

27 August 2005

• 00:32   Re: SQL safe input? Bruno Wolff III
• 00:34   Re: SQL safe input? Bruno Wolff III
• 01:47   Created objects not visible Alex du Plessis
• 01:47   LOG entries: "could not receive data from client" ? 
• 02:19   Re: LOG entries: "could not receive data from client" ? Michael Fuhr
• 03:43   Re: Created objects not visible Kretschmer Andreas
• 11:40   Re: Created objects not visible Tom Lane
• 12:34   index: specify sort order? 
• 12:52   Re: index: specify sort order? Stephan Szabo
• 13:25   Re: index: specify sort order? 
• 16:46   Re: index: specify sort order? Stephan Szabo
• 18:11   pgdata, pg_ctl wont start Dane Ensign
• 20:22   Re: SQL safe input? 
• 20:54   Re: SQL safe input? Bruno Wolff III
• 22:55   Re: SQL safe input? 
• 23:48   Re: SQL safe input? Bruno Wolff III

28 August 2005

• 08:45   see all queries incoming Flávio Brito
• 09:34   Re: see all queries incoming Kretschmer Andreas
• 10:19   Re: see all queries incoming Michael Fuhr
• 10:32   Re: see all queries incoming Kretschmer Andreas
• 10:44   Re: see all queries incoming Flávio Brito
• 11:23   Re: see all queries incoming Kretschmer Andreas
• 18:19   Re: query optimization Tom Lane
• 18:43   question - plpgsql and query on table given by variable  Jaromír Kamler
• 18:56   Re: question - plpgsql and query on table given by variable Michael Fuhr

29 August 2005

• 06:13   Fwd: Re: question - plpgsql and query on table given by variable  Jaromír Kamler
• 15:43   array vs flat tables performance Oren Mazor
• 16:11   understanding the interaction with delete/select/vacuum Alan Stange
• 16:18   Re: understanding the interaction with delete/select/vacuum Oren Mazor
• 16:52   Re: understanding the interaction with delete/select/vacuum Tom Lane
• 17:10   Re: understanding the interaction with delete/select/vacuum Alan Stange
• 17:34   message dupes anyone ? Andreas
• 21:54   triggers: how to check if a field changed? 

30 August 2005

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

31 August 2005

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