Home > mailing lists

Mailing lists [pgsql-sql]

1 February 2006

06:32 Re: how is searchable email archive on Achilleus Mantzios
14:26 executing dynamic commands christian.michels@eifelgeist.com
14:44 Re: executing dynamic commands codeWarrior
14:46 CREATE INDEX with order clause Daniel Caune
15:16 Re: CREATE INDEX with order clause Tom Lane
15:44 Re: executing dynamic commands christian.michels@eifelgeist.com
16:10 Re: executing dynamic commands Stephan Szabo
21:53 Does PostgreSQL support job? Daniel Caune
21:56 Re: Does PostgreSQL support job? Bruce Momjian
21:59 Re: Does PostgreSQL support job? Daniel Caune
21:59 Re: Does PostgreSQL support job? Owen Jacobson
22:00 Re: Does PostgreSQL support job? Andrew Sullivan
22:25 Re: Does PostgreSQL support job? Daniel Caune
23:28 Re: Does PostgreSQL support job? Alvaro Herrera

2 February 2006

01:53 Re: Does PostgreSQL support job? Daniel CAUNE
05:31 Function Dependency Padam J Singh
07:49 Re: Does PostgreSQL support job? Magnus Hagander
07:49 Re: executing dynamic commands christian.michels@eifelgeist.com
13:16 Re: Does PostgreSQL support job? Markus Schaber
13:19 Re: Changing the transaction isolation level within the stored Markus Schaber
13:19 Re: Does PostgreSQL support job? Daniel Caune
13:25 Re: Does PostgreSQL support job? Markus Schaber
14:21 Re: Does PostgreSQL support job? Daniel Caune
14:31 Re: Does PostgreSQL support job? Achilleus Mantzios
14:38 Re: Does PostgreSQL support job? Markus Schaber
14:46 Re: Does PostgreSQL support job? Achilleus Mantzios
17:51 strange quoted csv behavior with COPY George Pavlov

3 February 2006

04:35 ... padmanabha konkodi
08:21 Re: CREATE INDEX with order clause Ragnar
09:46 Help writing a piece of SQL Nigel Bishop
10:01 Re: Help writing a piece of SQL Richard Huxton
10:14 Re: Help writing a piece of SQL Nigel Bishop
12:04 Re: Help writing a piece of SQL Niklas Johansson
12:09 Re: Help writing a piece of SQL Nigel Bishop
12:21 Re: Help writing a piece of SQL Niklas Johansson

4 February 2006

19:58 UnixODBC-2.2.8-2.3.0 driver Philly Mandiza
23:59 Re: UnixODBC-2.2.8-2.3.0 driver Tom Lane

5 February 2006

11:01 new rule syntax? A. R. Van Hook
12:17 Re: new rule syntax? A. Kretschmer
12:20 Re: new rule syntax? Milen A. Radev
15:20 Re: new rule syntax? Jim Buttafuoco

6 February 2006

01:18 Re: Function Dependency Tony Wasson
08:50 Re: new rule syntax? Richard Huxton
09:02 Trigger on a column Josep Sanmartí
09:48 Re: Trigger on a column Josep Sanmartí
10:01 Re: Trigger on a column Richard Huxton
10:29 Re: Function Dependency Karsten Hilbert
10:58 no notnull values, invalid stats? Markus Schaber
11:48 Trigger efficiency Josep Sanmartí
13:02 Re: no notnull values, invalid stats? Alvaro Herrera
13:32 Re: no notnull values, invalid stats? Markus Schaber
14:14 Re: Trigger efficiency Craig Servin
16:35 Re: no notnull values, invalid stats? Michael Fuhr

7 February 2006

08:45 query superboy143 (sent by Nabble.com)
09:38 Re: query Richard Huxton
09:43 passing array to database function padmanabha konkodi
09:53 Re: passing array to database function Richard Huxton
10:08 Re: passing array to database function Achilleus Mantzios
12:45 problem referencing an attrib which is not unique Vic Rowan
13:17 Re: problem referencing an attrib which is not unique Richard Huxton
13:27 Re: problem referencing an attrib which is not unique Patrick JACQUOT
14:14 Re: problem referencing an attrib which is not unique Vic Rowan
14:41 Filtering data based on timestamp Panos Kassianidis
14:49 Re: Filtering data based on timestamp Richard Huxton
14:52 Re: executing dynamic commands codeWarrior
16:01 trecherous subselect needs warning? george young
16:03 Re: Filtering data based on timestamp Richard Huxton
16:45 Re: trecherous subselect needs warning? Tom Lane
18:18 Re: trecherous subselect needs warning? george young
18:39 Re: trecherous subselect needs warning? Tom Lane

8 February 2006

16:14 Delete with join -- deleting related table entries? Bryce Nesbitt
16:26 Re: Delete with join -- deleting related table entries? BigSmoke
16:27 Re: (NONE) BigSmoke
16:32 Re: Delete with join -- deleting related table entries? Owen Jacobson
16:33 Re: Delete with join -- deleting related table entries? Bryce Nesbitt
16:35 Re: Delete with join -- deleting related table entries? Owen Jacobson
16:36 Re: regarding debugging? BigSmoke
16:41 Re: Delete with join -- deleting related table entries? Bryce Nesbitt
16:55 Re: Delete with join -- deleting related table entries? Markus Schaber
16:56 Re: Delete with join -- deleting related table entries? Owen Jacobson
17:11 Re: Delete with join -- deleting related table entries? Bryce Nesbitt
17:18 Re: Delete with join -- deleting related table entries? Owen Jacobson
20:15 Non Matching Records in Two Tables Ken Hill
20:27 Re: Non Matching Records in Two Tables Frank Bax
20:31 Re: Non Matching Records in Two Tables Markus Schaber
20:31 Re: Non Matching Records in Two Tables Owen Jacobson
21:18 Re: Non Matching Records in Two Tables Ken Hill
22:12 Syntax for "IF" clause in SELECT pgsql@yukonho.de
22:20 Re: Syntax for "IF" clause in SELECT Bricklen Anderson

9 February 2006

00:58 Column Index vs Record Insert Trade-off? Ken Hill
01:05 unique constraint instead of primary key? what disadvantage(ODBC usage)? george young
01:05 Re: Syntax for "IF" clause in SELECT Ken Hill
01:34 Re: unique constraint instead of primary key? what Ken Hill
06:45 Re: unique constraint instead of primary key? what george young
08:00 Re: Non Matching Records in Two Tables Patrick JACQUOT
08:35 Concatenate strings using GROUP BY Philippe Lang
08:53 Re: Concatenate strings using GROUP BY A. Kretschmer
09:26 Re: Column Index vs Record Insert Trade-off? Richard Huxton
09:33 Re: unique constraint instead of primary key? what Richard Huxton
12:32 Re: Syntax for "IF" clause in SELECT Andrew Sullivan
15:16 Re: Non Matching Records in Two Tables BigSmoke
15:23 Re: unique constraint instead of primary key? what disadvantage(ODBC usage)? BigSmoke
16:11 Change definition of a view Andreas Roth
16:12 Re: unique constraint instead of primary key? what disadvantage(ODBC usage)? Tom Lane
17:09 Re: Change definition of a view Keith Worthington
18:38 UNIQUE, btree index allows duplicate records, if some fields are null Bryce Nesbitt
18:59 Re: UNIQUE, btree index allows duplicate records, if some fields are null Tom Lane
19:10 Re: unique constraint instead of primary key? what george young
19:41 Re: unique constraint instead of primary key? what BigSmoke

10 February 2006

05:02 Re: query Bruno Wolff III
05:18 date superboy143 (sent by Nabble.com)
05:38 Re: date A. Kretschmer
15:16 Re: date Ken Hill
15:21 Re: query Ken Hill
15:59 Re: date Tom Lane
16:52 Deleting rows in a file based on condition Ken Hill
16:59 Re: Deleting rows in a file based on condition Ken Hill
18:47 Re: date Osvaldo Rosário Kussama
20:01 Very slow updates when using IN syntax subselect Bryce Nesbitt
20:04 Re: unique constraint instead of primary key? what Chris Browne
20:33 Re: Very slow updates when using IN syntax subselect Tom Lane

11 February 2006

04:12 Re: Very slow updates when using IN syntax subselect Bryce Nesbitt
14:47 Re: Very slow updates when using IN syntax subselect Tom Lane
18:48 Re: Very slow updates when using IN syntax subselect Bryce Nesbitt
19:35 Re: Very slow updates when using IN syntax subselect Peter Eisentraut
21:43 Re: Very slow updates when using IN syntax subselect Bryce Nesbitt
23:37 Re: Very slow updates when using IN syntax subselect Tom Lane

12 February 2006

21:27 Trigger/Sequence headache Foster, Stephen
22:10 Re: Trigger/Sequence headache Stephan Szabo
22:20 Re: Trigger/Sequence headache Foster, Stephen

13 February 2006

14:35 ORDER BY CASE ... Mario Splivalo
14:39 Re: ORDER BY CASE ... Mathieu Arnold
14:47 Re: ORDER BY CASE ... Mario Splivalo
15:01 Re: ORDER BY CASE ... Reinoud van Leeuwen
15:10 Re: ORDER BY CASE ... Mathieu Arnold
16:27 Re: Very slow updates when using IN syntax subselect Bryce Nesbitt
16:33 Re: CREATE VIEW form stored in database? George Weaver
18:19 Problems with distinct Andreas Joseph Krogh
18:22 Re: Problems with distinct Tom Lane
18:24 Re: Problems with distinct Owen Jacobson
18:29 Re: Problems with distinct Andreas Joseph Krogh
20:30 Re: ORDER BY CASE ... Mario Splivalo
23:14 group by complications Mark Fenbers

14 February 2006

00:48 Slow update SQL Ken Hill
01:14 Re: Slow update SQL Michael Fuhr
01:29 Re: group by complications chester c young
04:17 Re: Slow update SQL Michael Fuhr
07:44 Re: Trigger/Sequence headache Markus Schaber
15:35 Re: Slow update SQL Ken Hill
15:39 Re: Slow update SQL Markus Schaber
19:54 Re: Non Matching Records in Two Tables Ken Hill
20:07 Re: Non Matching Records in Two Tables Tom Lane
20:08 Re: Non Matching Records in Two Tables chester c young
20:12 create table and data types Maciej Piekielniak
20:24 Re: Non Matching Records in Two Tables Ken Hill
20:25 Re: Non Matching Records in Two Tables Ken Hill
20:30 Re: create table and data types Ken Hill
21:03 Re: create table and data types Maciej Piekielniak
21:06 Re: create table and data types Tom Lane
21:41 Re: create table and data types Ken Hill
23:17 Re: create table and data types Bath, David

15 February 2006

00:46 Re: Non Matching Records in Two Tables Ken Hill
05:58 Re: Non Matching Records in Two Tables Bryce Nesbitt
14:45 Re: Non Matching Records in Two Tables Ken Hill
15:15 Modifying postgresql.org file Ken Hill
15:20 Re: Modifying postgresql.org file Andrew Sullivan
15:21 Re: Modifying postgresql.org file Devrim GUNDUZ
15:35 Re: Modifying postgresql.org file Ken Hill
15:47 Re: Modifying postgresql.org file Andrew Sullivan
16:09 Re: Modifying postgresql.org file Peter Eisentraut
16:13 Re: Modifying postgresql.org file Owen Jacobson
16:36 Re: Modifying postgresql.org file Ken Hill
16:38 Re: Modifying postgresql.org file Alvaro Herrera
17:12 alter table Maciej Piekielniak
17:54 Re: alter table Andreas Kretschmer
18:23 Re: alter table Maciej Piekielniak
18:26 Re: alter table Andreas Kretschmer
18:30 Re: alter table Maciej Piekielniak
18:31 Re: alter table Owen Jacobson
18:45 Re: alter table Maciej Piekielniak
18:56 Re: alter table Owen Jacobson
19:05 Re: alter table Maciej Piekielniak
19:09 Re: alter table Owen Jacobson
19:09 Re: alter table Stephan Szabo
19:29 Re: alter table Maciej Piekielniak
20:58 How to force PostgreSQL using an index Daniel Caune
21:06 Re: How to force PostgreSQL using an index Owen Jacobson
21:06 Re: How to force PostgreSQL using an index Andrew Sullivan
21:27 Re: How to force PostgreSQL using an index Daniel Caune
21:32 Re: How to force PostgreSQL using an index Owen Jacobson
21:33 Re: How to force PostgreSQL using an index Andrew Sullivan
21:47 Re: How to force PostgreSQL using an index Tom Lane
21:48 Re: How to force PostgreSQL using an index Daniel Caune
22:02 Re: How to force PostgreSQL using an index Tom Lane
22:22 Re: How to force PostgreSQL using an index Daniel Caune
23:54 Re: alter table Michael Glaesemann

16 February 2006

08:13 to count no of columns in a table AKHILESH GUPTA
08:34 Re: to count no of columns in a table Juris
08:37 Re: to count no of columns in a table A. Kretschmer
08:39 Re: to count no of columns in a table Ragnar
10:26 VIEWs and TEMP tables problem Antal Attila
10:57 Re: VIEWs and TEMP tables problem Richard Huxton
11:50 Re: VIEWs and TEMP tables problem Markus Schaber
12:57 Re: How to force PostgreSQL using an index Daniel Caune
14:05 Re: VIEWs and TEMP tables problem Tom Lane
14:38 Using calculated columns as arguments in same SELECT Michael Burke
14:42 Re: Using calculated columns as arguments in same SELECT Michael Burke
16:48 Re: group by complications Mark Fenbers
19:07 Using EXPLAIN-ANALYZE Kashmira Patel \(kupatel\)
19:39 Re: Using EXPLAIN-ANALYZE Andrew Sullivan
19:39 Re: Using EXPLAIN-ANALYZE Abhishek
20:08 Re: Using EXPLAIN-ANALYZE Kashmira Patel \(kupatel\)
20:11 Re: Using EXPLAIN-ANALYZE Owen Jacobson
20:14 Re: Using EXPLAIN-ANALYZE Andrew Sullivan
20:15 Re: Using EXPLAIN-ANALYZE Kashmira Patel \(kupatel\)
21:41 Re: group by complications Markus Schaber

17 February 2006

20:07 Given 02-01-2006 to 02-28-2006, output all days. Henry Ortega
20:14 Re: Given 02-01-2006 to 02-28-2006, output all days. Owen Jacobson
20:20 Re: Given 02-01-2006 to 02-28-2006, output all days. Michael Fuhr
22:08 Re: Given 02-01-2006 to 02-28-2006, output all days. Owen Jacobson
22:56 two count columns? Jan Danielsson
23:47 Re: two count columns? Tom Lane
23:51 Re: two count columns? Greg Stark

18 February 2006

03:05 Postgres for Dummies - a new request Nalin Bakshi
03:05 Re: Trigger/Sequence headache rlee0001
03:05 Tough Problem -- Record Checkouts Alfred
03:05 passing array(java) to postgre sql function bond
03:05 SELECT on a to-be-determined table garhone
03:06 view of weekly data Ding Xiangguang
03:06 Btrieve to PostgreSQL Adam Alkins
03:06 ORDER BY with LTREE Axel Straschil
06:36 Re: view of weekly data Greg Stark
06:58 Re: Tough Problem -- Record Checkouts Greg Stark
12:50 Interval subtracting Milorad Poluga
13:24 Re: Interval subtracting Milen A. Radev
13:35 Re: Interval subtracting Milorad Poluga
13:45 Re: Interval subtracting Milen A. Radev
16:42 Need help: Find dirty rows, Update, Delete SQL
17:30 Re: Interval subtracting Tom Lane
18:08 Re: Interval subtracting Stephan Szabo

19 February 2006

09:44 Re: Need help: Find dirty rows, Update, Delete SQL Janning Vygen
17:47 Re: Given 02-01-2006 to 02-28-2006, output all days. Henry Ortega
17:58 Re: Given 02-01-2006 to 02-28-2006, output all days. Stephan Szabo
18:07 Re: Given 02-01-2006 to 02-28-2006, output all days. Michael Fuhr

20 February 2006

06:41 Re: ORDER BY with LTREE Michael Fuhr
07:39 Re: Interval subtracting Milorad Poluga
10:04 Re: SELECT on a to-be-determined table Patrick JACQUOT
10:25 Re: Need help: Find dirty rows, Update, Delete SQL Patrick JACQUOT
16:24 Re: ORDER BY CASE ... Bruno Wolff III
19:30 Re: Given 02-01-2006 to 02-28-2006, output all days. Pedro B.
19:39 Re: Given 02-01-2006 to 02-28-2006, output all days. Mark R. Dingee" Pedro
19:56 Re: ... more than one count with left join Pedro B.

21 February 2006

05:31 Re: ORDER BY with LTREE Michael Fuhr
10:55 Avoid querying a specific field - how? Stefan Schwarzer
14:32 Re: Avoid querying a specific field - how? Ibrahim Tekin
15:02 Re: Avoid querying a specific field - how? Achilleus Mantzios

22 February 2006

08:14 restircting rows padmanabha konkodi
08:17 Re: passing array(java) to postgre sql function Markus Schaber
08:19 Re: restircting rows A. Kretschmer
08:21 Re: restircting rows Richard Huxton
08:23 Re: restircting rows Michael Glaesemann
10:00 Feature, my misconception or bug?? Achilleus Mantzios
11:47 Re: Feature, my misconception or bug?? Peter Eisentraut
11:55 Re: Feature, my misconception or bug?? Markus Schaber
11:56 Re: Feature, my misconception or bug?? Markus Schaber
14:27 Re: Feature, my misconception or bug?? Achilleus Mantzios
17:02 'locking' the SELECTs based on indices... Mario Splivalo
17:07 Update in all tables Judith
17:33 Re: Update in all tables Janning Vygen
17:58 Re: 'locking' the SELECTs based on indices... Tom Lane
18:12 Re: Update in all tables Scott Marlowe
19:57 Update in all tables Judith Altamirano Figueroa
20:13 Re: Update in all tables Andrew Sullivan
20:16 Re: Update in all tables Scott Marlowe
20:25 Re: Update in all tables Owen Jacobson

23 February 2006

06:59 Re: Feature, my misconception or bug?? Achilleus Mantzios
09:15 Re: 'locking' the SELECTs based on indices... Mario Splivalo
10:04 Re: 'locking' the SELECTs based on indices... Mario Splivalo
15:30 Re: 'locking' the SELECTs based on indices... PFC
15:34 Re: 'locking' the SELECTs based on indices... PFC
17:06 Sum If Daniel Hernandez
17:09 Re: Sum If Jim Buttafuoco
18:03 Re: Sum If Daniel Hernandez
19:10 Re: 'locking' the SELECTs based on indices... Mario Splivalo
21:09 Question about index scan vs seq scan when using count() Kashmira Patel \(kupatel\)
21:12 Re: Question about index scan vs seq scan when using count() Andrew Sullivan
21:25 Re: Question about index scan vs seq scan when using count() Kashmira Patel \(kupatel\)
21:35 Re: Question about index scan vs seq scan when using count() Kashmira Patel \(kupatel\)
21:47 Re: Question about index scan vs seq scan when using count() Andrew Sullivan
21:56 Re: Question about index scan vs seq scan when using count() Kashmira Patel \(kupatel\)
22:08 Re: Question about index scan vs seq scan when using count() Owen Jacobson

24 February 2006

09:45 CREATE TABLE AS and tablespaces Markus Schaber
10:48 "Installing" dbLink Richard C
11:43 Re: "Installing" dbLink A. Kretschmer
14:39 After Trigger assignment to NEW Achilleus Mantzios
15:06 Re: After Trigger assignment to NEW Tom Lane
16:16 Re: After Trigger assignment to NEW Alvaro Herrera
16:37 Re: After Trigger assignment to NEW Tom Lane
17:08 Missing fields on Query result. Daniel Hernandez
17:10 Re: Missing fields on Query result. Daniel Hernandez
17:43 Re: After Trigger assignment to NEW Achilleus Mantzios
17:47 Re: After Trigger assignment to NEW Achilleus Mantzios
17:58 Re: After Trigger assignment to NEW Owen Jacobson
21:15 Can't connect to the db Judith
21:21 Re: Can't connect to the db Andrew Sullivan
22:22 Obtaining client IP address Alexis Paul Bertolini
22:34 Re: Obtaining client IP address Michael Fuhr

25 February 2006

03:51 Re: CREATE TABLE AS and tablespaces Bruce Momjian
05:36 Re: After Trigger assignment to NEW Achilleus Mantzios
06:27 Relation 0 does not exist Yasuhiro Furuse
08:27 Re: Obtaining client IP address Alexis Paul Bertolini
09:42 Re: "Installing" dbLink Richard C
13:17 Index to support LIKE '%suffix' queries Florian Weimer
13:42 Re: After Trigger assignment to NEW Stephan Szabo
14:24 Re: Relation 0 does not exist Alvaro Herrera
16:22 Re: Index to support LIKE '%suffix' queries Tom Lane
16:52 Re: Index to support LIKE '%suffix' queries Florian Weimer
17:13 Re: Index to support LIKE '%suffix' queries Alvaro Herrera

26 February 2006

22:26 Re: Relation 0 does not exist Yasuhiro Furuse

27 February 2006

01:40 Disabling triggers/constraints pg<8.1 Bath, David
01:51 Dump/restore comments only? Bath, David
06:19 Problem with query on history table Andreas Joseph Krogh
08:04 Re: Dump/restore comments only? Ragnar

28 February 2006

15:35 grant select,... over schema chester c young
16:10 Re: grant select,... over schema chester c young
22:49 plsql / time statement Daniel Caune
23:06 Re: plsql / time statement Steve Crawford