Mailing List Archive For pgsql-novice@postgresql.org Jan 2008 By Thread

• [NOVICE] PostGreSQL size configurations chrisr(at)hawaii.rr.com (Thu Jan 31 2008 - 15:29:58 EST)
• [NOVICE] postgres 2 other databases Michael Lush (Thu Jan 31 2008 - 08:16:23 EST)
  • Re: [NOVICE] postgres 2 other databases Sean Davis (Thu Jan 31 2008 - 08:31:20 EST)
• [NOVICE] Table changes logging Didier Gasser-Morlay (Thu Jan 31 2008 - 04:07:05 EST)
• [NOVICE] postgresql-8.3RC2 and the continuing saga of libreadline G. J. Walsh (Wed Jan 30 2008 - 22:38:44 EST)
• [NOVICE] Protecting a web app from Postgresql injection Mary Anderson (Wed Jan 30 2008 - 16:48:59 EST)
  • Re: [NOVICE] Protecting a web app from Postgresql injection Josh (Wed Jan 30 2008 - 17:27:20 EST)
  • Re: [NOVICE] Protecting a web app from Postgresql injection A. Kretschmer (Thu Jan 31 2008 - 00:53:53 EST)
  • Re: [NOVICE] Protecting a web app from Postgresql injection Michael Lush (Thu Jan 31 2008 - 03:41:47 EST)
• [NOVICE] database row count Isaac Vetter (Wed Jan 30 2008 - 15:10:50 EST)
  • Re: [NOVICE] database row count Carol Cheung (Wed Jan 30 2008 - 16:14:29 EST)
    • Re: [NOVICE] database row count Jonah H. Harris (Wed Jan 30 2008 - 16:19:50 EST)
      • Re: [NOVICE] database row count Isaac Vetter (Wed Jan 30 2008 - 17:05:53 EST)
• [NOVICE] Update from other tables slow Carlo Stonebanks (Mon Jan 28 2008 - 20:18:04 EST)
  • Re: [NOVICE] Update from other tables slow Tom Lane (Mon Jan 28 2008 - 21:56:44 EST)
• [NOVICE] maths functions and spreadsheet e-letter (Mon Jan 28 2008 - 15:42:49 EST)
  • Re: [NOVICE] maths functions and spreadsheet Richard Broersma Jr (Mon Jan 28 2008 - 20:32:37 EST)
  • Re: [NOVICE] maths functions and spreadsheet Andrej Ricnik-Bay (Mon Jan 28 2008 - 21:27:35 EST)
  • Re: [NOVICE] maths functions and spreadsheet e-letter (Tue Jan 29 2008 - 04:46:18 EST)
    • Re: [NOVICE] maths functions and spreadsheet Andrej Ricnik-Bay (Tue Jan 29 2008 - 12:44:51 EST)
• [NOVICE] 2Q: Vacuuming and making queries case insensitive sdger erger (Sun Jan 27 2008 - 20:07:24 EST)
  • Re: [NOVICE] 2Q: Vacuuming and making queries case insensitive Sean Davis (Sun Jan 27 2008 - 20:11:49 EST)
    • Re: [NOVICE] 2Q: Vacuuming and making queries case insensitive Tom Lane (Sun Jan 27 2008 - 20:49:26 EST)
  • Re: [NOVICE] 2Q: Vacuuming and making queries case insensitive Tom Lane (Mon Jan 28 2008 - 15:27:45 EST)
• [NOVICE] view database, tables, columns e-letter (Sun Jan 27 2008 - 04:24:57 EST)
  • Re: [NOVICE] view database, tables, columns A. Kretschmer (Sun Jan 27 2008 - 04:54:25 EST)
• [NOVICE] Indexes to speed sorting Jeff Willden (Sat Jan 26 2008 - 11:21:19 EST)
  • Re: [NOVICE] Indexes to speed sorting Jaime Casanova (Sat Jan 26 2008 - 21:20:14 EST)
• [NOVICE] Newbie just starting on charting with PHP - and seeking advice on options/approaches Greg Cocks (Fri Jan 25 2008 - 16:01:18 EST)
  • Re: [NOVICE] Newbie just starting on charting with PHP - and seeking advice on options/approaches Mike Ellsworth (Fri Jan 25 2008 - 16:39:06 EST)
    • Re: [NOVICE] Newbie just starting on charting with PHP - and seeking advice on options/approaches Steve Crawford (Fri Jan 25 2008 - 17:58:13 EST)
  • Re: [NOVICE] Newbie just starting on charting with PHP - and seeking advice on options/approaches Isaac Vetter (Fri Jan 25 2008 - 17:07:36 EST)
    • Re: [NOVICE] Newbie just starting on charting with PHP - and seeking advice on options/approaches Mike Ellsworth (Fri Jan 25 2008 - 17:23:34 EST)
    • Re: [NOVICE] Newbie just starting on charting with PHP - and seeking advice on options/approaches Greg Cocks (Tue Jan 29 2008 - 14:22:04 EST)
  • Re: [NOVICE] Newbie just starting on charting with PHP - and seeking advice on options/approaches Ilan Volow (Fri Jan 25 2008 - 17:47:20 EST)
• [NOVICE] Greg Cocks (Fri Jan 25 2008 - 16:00:12 EST)
• [NOVICE] pg_cancel_backend and pg_ctl kill Mija Lee (Fri Jan 25 2008 - 12:57:16 EST)
  • Re: [NOVICE] pg_cancel_backend and pg_ctl kill Chander Ganesan (Tue Jan 29 2008 - 22:48:34 EST)
    • Re: [NOVICE] pg_cancel_backend and pg_ctl kill Mija Lee (Wed Jan 30 2008 - 13:02:59 EST)
• [NOVICE] Creating diff scripts for upgrades Mag Gam (Thu Jan 24 2008 - 23:07:03 EST)
  • Re: [NOVICE] Creating diff scripts for upgrades Josh Tolley (Sat Jan 26 2008 - 08:11:28 EST)
• [NOVICE] Order of triggers Didier Gasser-Morlay (Thu Jan 24 2008 - 09:50:12 EST)
  • Re: [NOVICE] Order of triggers A. Kretschmer (Thu Jan 24 2008 - 09:59:29 EST)
• [NOVICE] using column alias to make operations Raimon Fernandez (Wed Jan 23 2008 - 03:10:09 EST)
  • Re: [NOVICE] using column alias to make operations A. Kretschmer (Wed Jan 23 2008 - 04:36:34 EST)
  • Re: [NOVICE] using column alias to make operations A. Kretschmer (Wed Jan 23 2008 - 05:12:59 EST)
• [NOVICE] Need help with a function boolean --> text or array Andreas (Tue Jan 22 2008 - 23:19:58 EST)
  • Re: [NOVICE] Need help with a function boolean --> text or array Vyacheslav Kalinin (Wed Jan 23 2008 - 00:03:39 EST)
    • Re: [NOVICE] Need help with a function boolean --> text or array Vyacheslav Kalinin (Wed Jan 23 2008 - 00:09:20 EST)
  • Re: [NOVICE] Need help with a function boolean --> text or array Andrej Ricnik-Bay (Wed Jan 23 2008 - 03:24:23 EST)
    • Re: [NOVICE] Need help with a function boolean --> text or array Andreas (Wed Jan 23 2008 - 09:07:49 EST)
      • Re: [NOVICE] Need help with a function boolean --> text or array Andrej Ricnik-Bay (Wed Jan 23 2008 - 14:24:09 EST)
• [NOVICE] Reason(s) not to use a stored procedure Mag Gam (Tue Jan 22 2008 - 08:49:39 EST)
  • Re: [NOVICE] Reason(s) not to use a stored procedure A. Kretschmer (Tue Jan 22 2008 - 09:33:56 EST)
  • Re: [NOVICE] Reason(s) not to use a stored procedure Nick Nick (Tue Jan 22 2008 - 10:23:41 EST)
  • Re: [NOVICE] Reason(s) not to use a stored procedure Christoph Frick (Tue Jan 22 2008 - 10:29:20 EST)
  • Re: [NOVICE] Reason(s) not to use a stored procedure Jonah H. Harris (Tue Jan 22 2008 - 10:33:21 EST)
  • Re: [NOVICE] Reason(s) not to use a stored procedure Ilan Volow (Tue Jan 22 2008 - 12:19:18 EST)
  • Re: [NOVICE] Reason(s) not to use a stored procedure Andrew Winkler (Tue Jan 22 2008 - 13:31:58 EST)
• [NOVICE] Indexes and sequences Jeff Willden (Sat Jan 19 2008 - 17:04:34 EST)
  • Re: [NOVICE] Indexes and sequences Sean Davis (Sat Jan 19 2008 - 17:26:11 EST)
    • [NOVICE] Function in function Lukas (Sun Jan 20 2008 - 15:24:37 EST)
      • Re: [NOVICE] Function in function Tom Lane (Sun Jan 20 2008 - 16:27:54 EST)
• [NOVICE] Synchronization of records in multiple databases norman (Fri Jan 18 2008 - 12:55:23 EST)
  • [NOVICE] pgsql 7.3.2 updating FOREIGN KEYS after transaction Tjibbe (Fri Jan 18 2008 - 15:48:25 EST)
• [NOVICE] Duplicate primary keys Jason Tan Boon Teck (Thu Jan 17 2008 - 21:33:43 EST)
  • Re: [NOVICE] Duplicate primary keys Tom Lane (Thu Jan 17 2008 - 22:22:55 EST)
    • Re: [NOVICE] Duplicate primary keys Jason Tan Boon Teck (Thu Jan 17 2008 - 23:47:33 EST)
• [NOVICE] Changing 'on update' actions on existing FK constraints Greg Cocks (Wed Jan 16 2008 - 12:38:29 EST)
• [NOVICE] Thanks everybody. LWATCDR (Wed Jan 16 2008 - 10:22:15 EST)
• [NOVICE] High CPU utilization with various index combinations Durgaprasad Pawar (Wed Jan 16 2008 - 01:22:23 EST)
• [NOVICE] domains, types, constraints Andrew Winkler (Tue Jan 15 2008 - 23:12:28 EST)
  • Re: [NOVICE] domains, types, constraints Tom Lane (Tue Jan 15 2008 - 23:55:34 EST)
  • Re: [NOVICE] domains, types, constraints Andrew Winkler (Thu Jan 17 2008 - 11:23:41 EST)
    • Re: [NOVICE] domains, types, constraints Tom Lane (Thu Jan 17 2008 - 11:30:22 EST)
  • Re: [NOVICE] domains, types, constraints Andrew Winkler (Fri Jan 18 2008 - 21:45:01 EST)
  • Re: [NOVICE] domains, types, constraints Andrew Winkler (Tue Jan 22 2008 - 13:43:59 EST)
    • Re: [NOVICE] domains, types, constraints Tom Lane (Tue Jan 22 2008 - 14:06:33 EST)
• [NOVICE] msaccess to postgre Peter Jackson (Tue Jan 15 2008 - 08:12:40 EST)
  • Re: [NOVICE] msaccess to postgre Obe, Regina (Tue Jan 15 2008 - 08:54:47 EST)
    • Re: [NOVICE] msaccess to postgre Peter Jackson (Tue Jan 15 2008 - 18:57:45 EST)
• [NOVICE] - Automatically insertion Cedric BUSCHINI (Tue Jan 15 2008 - 03:28:45 EST)
  • Re: [NOVICE] - Automatically insertion A. Kretschmer (Tue Jan 15 2008 - 03:50:43 EST)
• [NOVICE] SQL state: 42P01 David Monarchi (Mon Jan 14 2008 - 19:00:03 EST)
  • Re: [NOVICE] SQL state: 42P01 Tom Lane (Mon Jan 14 2008 - 19:27:19 EST)
    • [NOVICE] SQL to extract column metadata Scott Ford (Tue Jan 15 2008 - 18:46:38 EST)
      • Re: [NOVICE] SQL to extract column metadata Tom Lane (Tue Jan 15 2008 - 20:04:03 EST)
      • [NOVICE] WITH ENCRYPTION feature ? Robert Bernabe (Thu Jan 24 2008 - 04:32:29 EST)
      • Re: [NOVICE] WITH ENCRYPTION feature ? Jonah H. Harris (Thu Jan 24 2008 - 08:36:33 EST)
      • [NOVICE] WITH ENCRYPTION Robert Bernabe (Thu Jan 24 2008 - 03:39:20 EST)
      • Re: [NOVICE] WITH ENCRYPTION Sean Davis (Thu Jan 24 2008 - 06:39:34 EST)
• [NOVICE] Avoiding a seq scan on a table. LWATCDR (Mon Jan 14 2008 - 11:21:37 EST)
  • Re: [NOVICE] Avoiding a seq scan on a table. LWATCDR (Mon Jan 14 2008 - 11:45:53 EST)
    • Re: [NOVICE] Avoiding a seq scan on a table. Sean Davis (Mon Jan 14 2008 - 11:54:30 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. LWATCDR (Mon Jan 14 2008 - 12:14:14 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. Daniel T. Staal (Mon Jan 14 2008 - 12:22:57 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. LWATCDR (Mon Jan 14 2008 - 12:35:30 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. Daniel T. Staal (Mon Jan 14 2008 - 12:55:58 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. Sean Davis (Mon Jan 14 2008 - 12:25:43 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. Alan Hodgson (Mon Jan 14 2008 - 12:30:30 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. Brian Hurt (Mon Jan 14 2008 - 12:28:09 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. Tom Lane (Mon Jan 14 2008 - 14:06:58 EST)
      • Re: [NOVICE] Avoiding a seq scan on a table. LWATCDR (Mon Jan 14 2008 - 14:31:13 EST)
    • Re: [NOVICE] Avoiding a seq scan on a table. Brian Hurt (Mon Jan 14 2008 - 12:03:58 EST)
• [NOVICE] distributed databases? Mike Dorin (Sat Jan 12 2008 - 21:27:07 EST)
  • Re: [NOVICE] distributed databases? Sean Davis (Sat Jan 12 2008 - 21:37:17 EST)
    • Re: [NOVICE] distributed databases? Mike Dorin (Sat Jan 12 2008 - 23:06:45 EST)
• [NOVICE] max_connections, solaris semaphores and initdb Isaac Vetter (Fri Jan 11 2008 - 12:08:27 EST)
  • Re: [NOVICE] max_connections, solaris semaphores and initdb Tom Lane (Fri Jan 11 2008 - 13:55:51 EST)
    • Re: [NOVICE] max_connections, solaris semaphores and initdb Isaac Vetter (Fri Jan 11 2008 - 14:17:41 EST)
      • Re: [NOVICE] max_connections, solaris semaphores and initdb Tom Lane (Fri Jan 11 2008 - 15:20:11 EST)
      • Re: [NOVICE] max_connections, solaris semaphores and initdb Isaac Vetter (Fri Jan 11 2008 - 15:51:52 EST)
      • Re: [NOVICE] max_connections, solaris semaphores and initdb Tom Lane (Fri Jan 11 2008 - 19:14:57 EST)
  • Re: [NOVICE] max_connections, solaris semaphores and initdb - solved Isaac Vetter (Sat Jan 12 2008 - 00:50:46 EST)
    • Re: [NOVICE] max_connections, solaris semaphores and initdb - solved Tom Lane (Sat Jan 12 2008 - 01:24:07 EST)
• [NOVICE] Connecting to the database server LWATCDR (Fri Jan 11 2008 - 11:22:46 EST)
  • Re: [NOVICE] Connecting to the database server johnf (Fri Jan 11 2008 - 11:30:05 EST)
    • Re: [NOVICE] Connecting to the database server LWATCDR (Fri Jan 11 2008 - 13:58:23 EST)
      • Re: [NOVICE] Connecting to the database server Andrej Ricnik-Bay (Fri Jan 11 2008 - 16:04:10 EST)
      • Re: [NOVICE] Connecting to the database server LWATCDR (Fri Jan 11 2008 - 16:53:05 EST)
• [NOVICE] question: n:m association between three tables Adam Å indelář (Thu Jan 10 2008 - 15:16:10 EST)
  • Re: [NOVICE] question: n:m association between three tables Rodrigo E. De León Plicet (Fri Jan 11 2008 - 02:50:40 EST)
• [NOVICE] moving a database. LWATCDR (Thu Jan 10 2008 - 10:45:36 EST)
  • Re: [NOVICE] moving a database. Tom Lane (Thu Jan 10 2008 - 11:44:30 EST)
    • Re: [NOVICE] moving a database. LWATCDR (Thu Jan 10 2008 - 15:24:23 EST)
  • Re: [NOVICE] moving a database. Frank Bax (Thu Jan 10 2008 - 11:56:29 EST)
    • Re: [NOVICE] moving a database. Chuck (Thu Jan 10 2008 - 18:16:41 EST)
      • Re: [NOVICE] moving a database. Frank Bax (Fri Jan 11 2008 - 11:00:41 EST)
• [NOVICE] Error in make for postgresql8.3RC1 G. J. Walsh (Wed Jan 09 2008 - 23:51:51 EST)
  • Re: [NOVICE] Error in make for postgresql8.3RC1 Tom Lane (Thu Jan 10 2008 - 00:47:59 EST)
• [NOVICE] psql record separator Charley Tiggs (Wed Jan 09 2008 - 17:06:40 EST)
  • Re: [NOVICE] psql record separator Tom Lane (Wed Jan 09 2008 - 17:13:13 EST)
    • Re: [NOVICE] psql record separator Charley Tiggs (Wed Jan 09 2008 - 17:44:23 EST)
      • Re: [NOVICE] psql record separator Andrej Ricnik-Bay (Wed Jan 09 2008 - 20:55:44 EST)
      • Re: [NOVICE] psql record separator Charley Tiggs (Thu Jan 10 2008 - 08:58:33 EST)
• [NOVICE] Order by sub-select Daniel T. Staal (Wed Jan 09 2008 - 12:12:21 EST)
  • Re: [NOVICE] Order by sub-select Rodrigo E. De León Plicet (Wed Jan 09 2008 - 12:39:26 EST)
    • Re: [NOVICE] Order by sub-select Daniel T. Staal (Wed Jan 09 2008 - 13:09:44 EST)
• [NOVICE] two postgres binaries kenneth d'souza (Wed Jan 09 2008 - 06:52:43 EST)
  • Re: [NOVICE] two postgres binaries Tom Lane (Wed Jan 09 2008 - 10:24:32 EST)
  • Re: [NOVICE] two postgres binaries kenneth d'souza (Thu Jan 10 2008 - 07:15:28 EST)
• [NOVICE] Creating a tablespace on an external server in Windows Michael Smith (Tue Jan 08 2008 - 19:16:12 EST)
  • Re: [NOVICE] Creating a tablespace on an external server in Windows Obe, Regina (Wed Jan 09 2008 - 09:28:18 EST)
    • Re: [NOVICE] Creating a tablespace on an external server in Windows Michael Smith (Wed Jan 09 2008 - 17:01:17 EST)
• [NOVICE] Problem restoring database Oeschey, Lars (I/EK-142, extern) (Tue Jan 08 2008 - 04:51:11 EST)
  • Re: [NOVICE] Problem restoring database Tom Lane (Tue Jan 08 2008 - 11:19:32 EST)
    • Re: [NOVICE] Problem restoring database Oeschey, Lars (I/EK-142, extern) (Thu Jan 10 2008 - 10:29:12 EST)
• [NOVICE] autoincrement question Jack Albright (Mon Jan 07 2008 - 15:57:50 EST)
  • Re: [NOVICE] autoincrement question Sean Davis (Mon Jan 07 2008 - 16:12:36 EST)
    • Re: [NOVICE] autoincrement question Richard Broersma Jr (Mon Jan 07 2008 - 17:39:39 EST)
      • Re: [NOVICE] autoincrement question Greg Cocks (Mon Jan 07 2008 - 17:52:45 EST)
• [NOVICE] Command line output - How to output values only? sdger erger (Sun Jan 06 2008 - 04:53:58 EST)
  • Re: [NOVICE] Command line output - How to output values only? Andreas Kretschmer (Sun Jan 06 2008 - 05:09:49 EST)
  • Re: [NOVICE] Command line output - How to output values only? Charley Tiggs (Wed Jan 09 2008 - 17:03:55 EST)
• [NOVICE] Combined PITR/pg_dump backups? Brian Hurt (Wed Jan 02 2008 - 12:32:51 EST)
  • Re: [NOVICE] Combined PITR/pg_dump backups? Tom Lane (Wed Jan 02 2008 - 12:42:32 EST)
  • Re: [NOVICE] Setting a FK to look at only selected rows in the 'look-up' table... Greg Cocks (Thu Jan 03 2008 - 13:54:06 EST)
  • Re: [NOVICE] Can't get MS Access via ODBC (or MapServer) to 'see' the data unless the user is a 'super user'... Chander Ganesan (Thu Jan 31 2008 - 22:01:13 EST)
  • Re: [NOVICE] Group Roles are now Login Roles in pgAdmin? Chander Ganesan (Thu Jan 31 2008 - 21:47:23 EST)