Home > mailing lists

Mailing lists [pgsql-sql]

1 June 2004

02:07 Re: insert or update violates foreign key constraint.why? Tom Lane
12:28 assistance on self join pls email lists
13:59 Re: sum ( time) problem Bruno Wolff III
14:03 Schemata & User-Defined-Type casting issues Chris Gamache
14:25 Re: Schemata & User-Defined-Type casting issues Tom Lane
19:35 Query becoming slower on adding a primary key mallah@trade-india.com
21:37 Re: Query becoming slower on adding a primary key Tom Lane

2 June 2004

02:36 most efficient way to manage ordering Matthew Nuzum
03:11 Re: most efficient way to manage ordering Rod Taylor
08:49 Re: Query becoming slower on adding a primary key Rajesh Kumar Mallah
11:39 UNIQUE columnt depdening on other column??? Andrei Bintintan
12:22 Re: UNIQUE columnt depdening on other column??? Richard Huxton
12:43 Re: UNIQUE columnt depdening on other column??? Reinoud van Leeuwen
13:48 Re: assistance on self join pls Rajesh Kumar Mallah
15:05 function with a composite type calling another function - Mission Impossible? Riccardo G. Facchini
15:51 Re: function with a composite type calling another function - Mission Impossible? Tom Lane
16:33 Re: function with a composite type calling another function - Mission Impossible? Riccardo G. Facchini

3 June 2004

05:02 Re: Query becoming slower on adding a primary key Rajesh Kumar Mallah
07:19 Re: bytea or blobs? Richard Huxton
09:16 Reference with condition on other table column? Andrei Bintintan
12:13 Re: Date format problems Stef
12:14 Re: Date format problems Richard Huxton
14:24 Re: Reference with condition on other table column? Stephan Szabo
17:25 Re: ORDER BY TIMESTAMP_column ASC, NULL first Bruno Wolff III
17:30 Selecting "sample" data from large tables. Joseph Turner
18:14 Re: Reference with condition on other table column? Bruno Wolff III
18:27 Re: Selecting "sample" data from large tables. Tom Lane

4 June 2004

06:11 Re: Selecting "sample" data from large tables. Greg Stark
08:06 ERROR: duplicate key violates unique constraint Khairul Azmi
08:15 Difference between two times as a numeric value in a stored procedure. Stijn Vanroye
13:06 trigger data hook
14:49 Re: Difference between two times as a numeric value in a stored procedure. [Scanned] Stijn Vanroye
15:20 Re: Difference between two times as a numeric value in a stored procedure. Bruno Wolff III
15:40 dynamic rules? Christopher Dedels
16:08 Re: dynamic rules? Bruno Wolff III
17:05 Re: ERROR: duplicate key violates unique constraint Josh Berkus
17:21 Re: Difference between two times as a numeric value in a stored procedure. Tom Lane
18:12 Re: dynamic rules? Bruno Wolff III
19:39 ANSI SQL-99 SYNTAX and "WITH" Rein Petersen
19:51 Re: ANSI SQL-99 SYNTAX and "WITH" Yasir Malik
19:56 Re: ANSI SQL-99 SYNTAX and "WITH" Bruno Wolff III
20:43 Re: ANSI SQL-99 SYNTAX and "WITH" Tom Lane

6 June 2004

02:16 Re: create function atof? Yasir Malik
11:40 Re: postgresql multiple insert slow Harald Fuchs
22:01 Formatting problems with negative intervals, TO_CHAR Jeff Boes
22:01 SQL DDL: FOREIGN KEY construct and field mapping: unexpected behavior nzanella@cs.mun.ca (Neil Zanella)
22:45 Re: Formatting problems with negative intervals, TO_CHAR Tom Lane
22:45 Re: SQL DDL: FOREIGN KEY construct and field mapping: unexpected behavior Tom Lane

7 June 2004

03:29 Re: ERROR: duplicate key violates unique constraint (SOLVED) Khairul Azmi
07:39 empty string casting to typed value sad
07:52 Re: Formatting problems with negative intervals, TO_CHAR Karel Zak
09:09 Re: Formatting problems with negative intervals, TO_CHAR Stefan Weiss
09:46 Re: Formatting problems with negative intervals, TO_CHAR Karel Zak
13:54 Re: empty string casting to typed value Bruno Wolff III
14:34 Re: empty string casting to typed value Stephan Szabo
18:34 Re: pl/pgsql and transaction locks Marcus Whitney
23:57 Getting FK relationships from information_schema Kyle

8 June 2004

05:40 Cursor returned from procedure ignores setFetchSize() on CallableStatement Brian G. Huber
05:53 Re: Getting FK relationships from information_schema Tom Lane
15:20 Re: Getting FK relationships from information_schema Kyle
18:40 Re: Query becoming slower on adding a primary key Rajesh Kumar Mallah
21:51 simple addition of constraints problem Michelle Murrain
22:05 a query question Jaime Casanova
23:18 Re: simple addition of constraints problem Stephan Szabo

9 June 2004

05:05 Re: Getting FK relationships from information_schema Tom Lane
06:24 Last insert id mixo
06:36 Re: Getting FK relationships from information_schema Peter Eisentraut
06:54 Re: Last insert id
07:23 Re: Last insert id Richard Huxton
08:58 Re: returning a recordset from PLpg/SQL Richard Huxton
09:01 Re: Triggers Richard Huxton
16:42 Schema + User-Defined Data Type Indexing problems... Chris Gamache
17:27 search and replace Jodi Kanter
19:29 Trigger problem kasper
19:33 Re: Trigger problem Mike Rylander
20:30 Re: Trigger problem Stephan Szabo

10 June 2004

01:45 Re: Trigger problem Jan Wieck
04:21 Re: Schema + User-Defined Data Type Indexing problems... Tom Lane
06:33 Re: Getting FK relationships from information_schema Tom Lane
07:57 Find out whether a view's column is indexed? Martin Schäfer
08:42 Re: Find out whether a view's column is indexed? Richard Huxton
13:20 Re: Schema + User-Defined Data Type Indexing problems... Chris Gamache
13:48 Re: Find out whether a view's column is indexed? Martin Schäfer
13:52 Converting integer to binary Stephen Quinney
14:09 Re: Schema + User-Defined Data Type Indexing problems... Tom Lane
14:20 Re: Find out whether a view's column is indexed? Karsten Hilbert
14:34 Re: Schema + User-Defined Data Type Indexing problems... Chris Gamache
15:01 Function returns error Michael Long
15:41 Re: Schema + User-Defined Data Type Indexing problems... Tom Lane
15:41 Re: Function returns error Richard Huxton
15:46 Re: query optimization Franco Bruno Borghesi
18:24 Re: Converting integer to binary Bruno Wolff III
20:24 Re: Converting integer to binary Chris Gamache
22:21 Re: Converting integer to binary Bruno Wolff III

11 June 2004

04:37 (No Subject) William Anthony Lim
05:05 Re: Query becoming slower on adding a primary key [ SOLVED Rajesh Kumar Mallah
07:54 Re: Converting integer to binary Stephen Quinney
08:25 casting int to bit sad
14:02 Re: (No Subject) Franco Bruno Borghesi
14:20 pg_dump inside function (was: Re: (No Subject)) Martin Knipper
14:42 plpgsql - Insert from a record variable? Phil Endecott

13 June 2004

21:51 Re: search and replace Benoît BOURNON

14 June 2004

02:32 Re: sum ( time) problem Willem de Jong
14:15 Datetime problem Eric Lemes
14:27 Re: Datetime problem Achilleus Mantzios
14:31 Re: Datetime problem Stef
14:56 Re: Datetime problem Tom Lane
16:02 max value from join hook
16:21 RES: Datetime problem Eric Lemes
16:49 query with =ALL Jaime Casanova
17:06 a query with = ALL Jaime Casanova
17:11 Re: RES: Datetime problem Alexander M. Pravking
17:39 Re: query with =ALL Stephan Szabo
17:49 Re: query with =ALL Richard Huxton
18:02 Re: query with =ALL Jaime Casanova
18:08 Re: query with =ALL Jaime Casanova
18:28 Re: max value from join Richard Poole
18:28 Re: query with =ALL Stephan Szabo
18:48 Re: RES: Datetime problem Tom Lane
18:52 Re: a query with = ALL Tom Lane
19:02 Re: RES: Datetime problem Tom Lane
19:08 Re: query with =ALL Jaime Casanova
19:12 Re: a query with = ALL Jaime Casanova
19:39 Scalar subqueries Subbiah, Stalin
19:43 Re: query with =ALL Tom Lane
19:53 Re: query with =ALL Jaime Casanova
19:57 Re: query with =ALL Tom Lane
20:04 Re: query with =ALL Jaime Casanova
20:07 Re: query with =ALL Stephan Szabo
20:44 Re: Scalar subqueries Richard Poole
23:33 Prepare Statement Jie Liang

15 June 2004

07:05 Re: Last insert id Andrei Bintintan
10:30 Re: Last insert id Rod Taylor
16:44 Re: Prepare Statement Jie Liang
19:06 Is there a faster way to do this? Patrick Hatcher
20:17 Re: Is there a faster way to do this? Richard Huxton
20:20 Re: Is there a faster way to do this? Edmund Bacon
20:37 Re: Is there a faster way to do this? Jean-Luc Lachance

16 June 2004

07:30 Re: Your question in postgresql.org forum (Diff. between two times as a numeric value in a stored proc) Stijn Vanroye
11:53 How to delete the not DISTINCT ON entries Christoph Haller
13:10 Re: How to delete the not DISTINCT ON entries Achilleus Mantzios
14:13 Re: How to delete the not DISTINCT ON entries Jean-Luc Lachance
15:14 Inheritance, plpgsql inserting, and revisions Phil Endecott

17 June 2004

00:53 Re: [JDBC] Prepare Statement Jie Liang
03:07 Re: Is there a faster way to do this? Greg Sabino Mullane
11:01 use of a composite type in CREATE TABLE? Hannes Korte
12:44 Optimal query suggestion needed Interzone
13:36 Re: Optimal query suggestion needed Richard Huxton
13:39 Re: use of a composite type in CREATE TABLE? Tom Lane
17:48 Re: Optimal query suggestion needed Bruno Wolff III
18:19 Re: [JDBC] Prepare Statement Jie Liang
19:04 Re: Optimal query suggestion needed InterZone
19:19 Re: Optimal query suggestion needed InterZone
19:55 Re: Optimal query suggestion needed Bruno Wolff III
20:55 Re: [JDBC] Prepare Statement Jie Liang
22:50 Re: [JDBC] Prepare Statement Jie Liang

18 June 2004

03:12 Re: [JDBC] Prepare Statement Jie Liang
16:44 Re: [JDBC] Prepare Statement Jie Liang
16:57 Re: [JDBC] Prepare Statement Jie Liang
18:30 In 7.4 ensure you have DEFAULT now () with no spaces David B
21:38 case stement when null Jaime Casanova

19 June 2004

06:03 Re: plpgsql - Insert from a record variable? Riccardo G. Facchini
06:21 Re: case stement when null Riccardo G. Facchini
10:25 Re: case stement when null V i s h a l Kashyap @ [Sai Hertz And Control Systems]
12:25 Re: In 7.4 ensure you have DEFAULT now () with no spaces Peter Eisentraut
18:39 Re: plpgsql - Insert from a record variable? Tom Lane
18:50 Re: In 7.4 ensure you have DEFAULT now () with no spaces Tom Lane

20 June 2004

18:48 Number of rows effected Pankaj Chugh
19:00 Re: [JDBC] Prepare Statement Kris Jurka
19:08 Scalar subqueries Subbiah, Stalin
19:44 pivot-like transformation Torsten Lange
21:22 question about which column(s) are the right foreign key Markus Bertheau
22:15 Re: pivot-like transformation Joe Conway

21 June 2004

03:59 Re: Last insert id Michalis Kabrianis
03:59 help with Postgres function ctrl@altonsys.com (ctrl)
04:53 Re: use of a composite type in CREATE TABLE? Josh Berkus
05:34 Re: [JDBC] Prepare Statement Kris Jurka
05:38 Re: help with Postgres function Stephan Szabo
05:52 Re: [JDBC] Prepare Statement Kris Jurka
06:01 Re: [JDBC] Prepare Statement Kris Jurka
06:04 Re: [JDBC] Prepare Statement Kris Jurka
06:09 Re: question about which column(s) are the right foreign key Josh Berkus
06:11 Re: [JDBC] Prepare Statement Kris Jurka
06:18 Re: [JDBC] Prepare Statement Kris Jurka
06:22 Re: [JDBC] Prepare Statement Kris Jurka
06:23 Function Parameters - need help !!! Pradeepkumar, Pyatalo (IE10)
06:36 Strange behaviour updating primary key column. Luis Neves
08:09 Re: pivot-like transformation Torsten Lange
09:41 feature request sad
09:47 Re: Function Parameters - need help !!! V i s h a l Kashyap @ [Sai Hertz And Control Systems]
10:11 subselect prob in view Gary Stainburn
10:15 Re: Strange behaviour updating primary key column. Richard Huxton
10:44 Re: Function Parameters - need help !!! Pradeepkumar, Pyatalo (IE10)
11:53 Re: Function Parameters - need help !!! Phil Endecott
11:54 Re: Function Parameters - need help !!! Richard Huxton
14:19 Re: subselect prob in view Tom Lane
15:12 Re: subselect prob in view Gary Stainburn
16:35 Re: [JDBC] Prepare Statement Jie Liang
17:23 Re: plpgsql - Insert from a record variable? Phil Endecott
18:51 Re: plpgsql - Insert from a record variable? Phil Endecott

22 June 2004

00:56 Re: plpgsql - Insert from a record variable? basic
01:30 Re: plpgsql - Insert from a record variable? Tom Lane
12:01 Re: subselect prob in view Gary Stainburn
13:31 Re: subselect prob in view Stephan Szabo
13:56 Re: subselect prob in view Tom Lane
14:17 Re: plpgsql - Insert from a record variable? Phil Endecott
16:45 matching rows differing only by fkey,pkey Matthew Nuzum
17:19 Re: matching rows differing only by fkey,pkey Richard Huxton
17:20 Re: matching rows differing only by fkey,pkey Bruno Wolff III
17:40 Re: matching rows differing only by fkey,pkey Matthew Nuzum
18:14 Re: matching rows differing only by fkey,pkey Bruno Wolff III
19:48 Re: matching rows differing only by fkey,pkey Richard Huxton

23 June 2004

10:44 sql cristi
10:48 feature request ? sad
11:38 Re: sql Richard Huxton
15:46 Non-standard function names Clive Page
16:08 ERROR: Unable to format timestamp; internal coding error Stef
16:27 Re: Non-standard function names Tom Lane
16:30 Re: ERROR: Unable to format timestamp; internal coding error Tom Lane
17:15 Re: feature request ? Josh Berkus

24 June 2004

05:33 Re: feature request ? Michael Glaesemann
05:49 Re: feature request ? sad
05:54 Re: feature request ? sad (by way of sad
07:48 Re: feature request ? Gregory S. Williamson
07:57 Re: feature request ? sad
10:25 Re: feature request ? Michael Glaesemann
10:31 Re: feature request ? sad
10:32 Re: feature request ? Alexander M. Pravking
10:33 Re: feature request ? Iain
10:36 Re: feature request ? sad
13:25 Re: feature request ? Stephan Szabo
13:48 Re: feature request ? sad
14:03 Re: feature request ? Stephan Szabo
14:22 Re: feature request ? sad
14:36 Re: feature request ? Stephan Szabo
15:52 Re: feature request ? Michael Glaesemann
17:33 Re: feature request ? Jaime Casanova
17:42 Re: feature request ? Bruno Wolff III
18:29 Re: feature request ? Radu-Adrian Popescu
18:41 Re: feature request ? Stephan Szabo
18:51 Normalising an existing table - how? Graham Leggett
19:27 Re: feature request ? Andrew Sullivan
20:43 Question about a CIDR based query Georgos Siganos
21:01 Re: Normalising an existing table - how? Phil Endecott
21:08 Re: Normalising an existing table - how? Frank Bax
21:44 Re: Normalising an existing table - how? Graham Leggett
21:45 Re: Normalising an existing table - how? Graham Leggett
22:43 Re: feature request ? Geoffrey
23:15 Re: Normalising an existing table - how? Phil Endecott

25 June 2004

05:09 Re: feature request ? sad (by way of sad
05:38 Re: feature request ? Rosser Schwarz
07:13 Re: feature request ? sad
08:33 Re: feature request ? Richard Huxton
08:38 Re: Normalising an existing table - how? Richard Huxton
08:46 Re: feature request ? sad
09:22 Re: feature request ? Richard Huxton
09:25 Re: feature request ? Radu-Adrian Popescu
09:57 Re: Normalising an existing table - how? Graham Leggett
10:19 Re: Normalising an existing table - how? Richard Huxton
13:25 Join columns Przemysław Słupkowski
13:48 Re: Join columns Achilleus Mantzios
14:18 Re: question about which column(s) are the right foreign key Markus Bertheau
15:12 Re: question about which column(s) are the right foreign key Markus Bertheau
16:01 Re: Question about a CIDR based query Josh Berkus
18:29 Re: feature request ? Jaime Casanova

26 June 2004

19:59 Need indexes on inherited tables? Phil Endecott
21:06 Re: Need indexes on inherited tables? Franco Bruno Borghesi
22:52 Re: Need indexes on inherited tables? Phil Endecott
23:13 Re: Question about a CIDR based query siganos@gmail.com (George Siganos)
23:40 Re: Need indexes on inherited tables? Karsten Hilbert

28 June 2004

16:02 Empty array IS NULL? Markus Bertheau
16:26 Re: Empty array IS NULL? Joe Conway
16:31 Re: Need indexes on inherited tables? Franco Bruno Borghesi
17:10 Re: Empty array IS NULL? Markus Bertheau
17:56 Re: Empty array IS NULL? Joe Conway
18:14 Re: Empty array IS NULL? Joe Conway
18:35 unsubscribe beyaNet
19:06 Re: Empty array IS NULL? Greg Stark
22:07 "=" operator vs. "IS" Stefan Weiss
22:22 FW: "=" operator vs. "IS" Dmitri Bichko
22:27 Re: "=" operator vs. "IS" Steve Crawford
22:28 Re: "=" operator vs. "IS" Michael A Nachbaur
23:00 Re: "=" operator vs. "IS"
23:04 Re: FW: "=" operator vs. "IS" Stefan Weiss
23:26 Re: FW: "=" operator vs. "IS" Stephan Szabo

29 June 2004

02:26 finding if a foreign key is in use Kenneth Gonsalves
13:52 Re: finding if a foreign key is in use Phil Endecott
14:23 Re: FW: "=" operator vs. "IS" Rich Hall
14:58 Re: FW: "=" operator vs. "IS" Tom Lane
15:01 Re: FW: "=" operator vs. "IS" Michael Kleiser
15:52 Unrecognized node type Alvaro Sanchez-Mariscal
16:18 UPDATE ... WHERE (subselect on the same table) Alexander M. Pravking
16:19 Re: Unrecognized node type Tom Lane
16:44 test1 beyaNet
16:48 Re: FW: "=" operator vs. "IS" Peter Eisentraut
17:39 Re: UPDATE ... WHERE (subselect on the same table) Alexander M. Pravking
17:48 Re: UPDATE ... WHERE (subselect on the same table) Tom Lane
18:02 Re: FW: "=" operator vs. "IS" Stephan Szabo
18:10 Re: FW: "=" operator vs. "IS" Greg Stark
18:40 Re: FW: "=" operator vs. "IS" Greg Stark
20:16 OUTER JOIN problem Zoltan Boszormenyi
22:14 Re: OUTER JOIN problem Stephan Szabo
23:54 Re: Question about a CIDR based query Josh Berkus

30 June 2004

03:50 Re: Question about a CIDR based query Josh Berkus
13:55 Re: Unrecognized node type Tom Lane
22:54 Queries across multiple database Garth Thompson
23:14 Re: Queries across multiple database Gregory S. Williamson
23:19 Re: Queries across multiple database Rod Taylor