Home > mailing lists

Mailing lists [pgsql-sql]

1 October 2000

00:40 how can I mirror a postgres database Dronamraju Rajesh
02:04 Re: how can I mirror a postgres database Philip Warner
16:58 currval Craig May

2 October 2000

03:21 Re: question on diagnostics Bruce Momjian
04:38 Q: spinlock on Alpha? (PG7.0.2) Emils Klotins
05:40 Re: Q: spinlock on Alpha? (PG7.0.2) Tom Lane
14:44 Concerns about the OID Josh Berkus
14:44 foreign key introduces unnecessary locking ? Rini Dutta

3 October 2000

02:20 trigger question Carolyn Lu Wong
02:33 Re: Something I'd like to try... Bruce Momjian
02:51 Re: Something I'd like to try... Cristóvão Dalla Costa
03:20 trigger examples Carolyn Lu Wong
03:24 Re: trigger examples drfrog@smartt.com
03:27 DB backup and connection questions Carolyn Lu Wong
03:29 Re: Something I'd like to try... Tom Lane
05:05 Re: trigger examples Carolyn Lu Wong
08:40 grant select on ALL(?) to dbuser; Marcin Mazurek
09:14 Re: Q: spinlock on Alpha? (PG7.0.2) - solved Emils Klotins
11:02 Re: grant select on ALL(?) to dbuser; Antti Linno
11:04 Re: grant select on ALL(?) to dbuser; Marcin Mazurek
11:17 Re: trigger examples Keith Wong
12:13 Object features of pg Michael Ansley
12:34 Re: Object features of pg Peter Mount
12:43 RE: Object features of pg Michael Ansley
13:20 RE: Object features of pg Michael Ansley
13:24 RE: Object features of pg Michael Ansley
13:51 table as field type?? David Diller
13:52 RE: Object features of pg Michael Ansley
14:47 RE: Object features of pg Tod McQuillin
14:51 Re: table as field type?? Tod McQuillin
15:10 OID Perfomance - Object-Relational databases Josh Berkus
15:13 Re: table as field type??
15:16 RE: OID Perfomance - Object-Relational databases Michael Ansley
15:17 Re: Something I'd like to try... Josh Berkus
15:19 Re: OID Perfomance - another question Mitch Vincent
15:25 Re: OID Perfomance - another question Tod McQuillin
15:31 Re: OID Perfomance - Object-Relational databases Mitch Vincent
15:34 RE: OID Perfomance - Object-Relational databases Michael Ansley
15:53 RE: OID Perfomance - Object-Relational databases Michael Ansley
16:29 Re: Something I'd like to try... Barry Lind
18:04 Re: Something I'd like to try... Tom Lane
18:10 Re: OID Perfomance - Object-Relational databases Tom Lane
19:30 Possibly to get off the list? Mads Jensen
19:47 pesky select query Ingram, Bryan
22:37 Re: pesky select query Tom Lane
22:58 RE: Object features of pg Peter Mount
23:33 Re: OID Perfomance - Object-Relational databases Josh Berkus

4 October 2000

00:26 Re: OID Perfomance - Object-Relational databases Michael Fork
02:37 Re: OID Perfomance - Object-Relational databases Tom Lane
02:43 Re: OID Perfomance - Object-Relational databases Tom Lane
03:10 Re: OID Perfomance - Object-Relational databases Josh Berkus
08:26 RE: OID Perfomance - Object-Relational databases Michael Ansley
09:04 Q: performance on some selects (7.0.2)? Emils Klotins
09:23 Re: Q: performance on some selects (7.0.2)? Grant Finnemore
10:44 Re: OID Perfomance - Object-Relational databases Jeff MacDonald
11:57 RE: Re: OID Perfomance - Object-Relational databases Michael Ansley
14:22 Re: Q: performance on some selects (7.0.2)? Tom Lane
14:48 Typecast a user-defined type? Mark Volpe
14:59 Re: Typecast a user-defined type? Tom Lane
18:09 createuser Craig May
18:53 Q: Difference Datatype Polygon - Path Carsten.Hatger@iagb.uni-stuttgart.de
19:04 Re: createuser Peter Eisentraut

5 October 2000

08:45 JDBC: oid after insert Markus Wagner
12:18 Object syntax Michael Ansley
12:48 JDBC and BLOB in Postgres Didier Boudigue
13:33 Re: Object syntax Tom Lane
14:56 Re: JDBC and BLOB in Postgres Josh Berkus
14:58 Re: Object syntax Josh Berkus
15:02 The TEXT data type Josh Berkus
17:17 Loading JDBC Driver José" "Hernández" Zavala
18:44 Re: Object syntax Tom Lane
20:10 Granting of permissions on tables Saltsgaver, Scott
20:23 Re: Granting of permissions on tables Peter Eisentraut
20:37 Re: Granting of permissions on tables Tom Lane

6 October 2000

04:04 Re: [HACKERS] Counting bool flags in a complex query Tom Lane
12:22 RE: Granting of permissions on tables Saltsgaver, Scott
14:07 Re: Granting of permissions on tables Tom Lane
15:31 Re: Re: [HACKERS] Counting bool flags in a complex query Josh Berkus
15:53 Windows 9X Craig May
20:23 Re: Re: [HACKERS] Counting bool flags in a complex query Tom Lane

7 October 2000

11:23 Re: Date problem Edipo E. F. Melo

9 October 2000

00:56 Re: OID Perfomance - Object-Relational databases Bruce Momjian
10:30 Re: Loading JDBC Driver Peter Mount
14:22 Table Attribute Help Brian C. Doyle
14:34 Re: Table Attribute Help Jeff Hoffmann
14:39 Re: AW: Table Attribute Help Brian C. Doyle
14:47 Re: Table Attribute Help omid omoomi
16:34 Re: OID Perfomance - Object-Relational databases Josh Berkus
18:04 Re: OID Perfomance - Object-Relational databases Josh Berkus
18:19 Re: OID Perfomance - Object-Relational databases Bruce Momjian
19:15 Re: OID Perfomance - Object-Relational databases Tom Lane
21:14 Re: Q: spinlock on Alpha? (PG7.0.2) Fabrice Scemama
22:01 Re: OID Perfomance - Object-Relational databases Josh Berkus
22:31 RE: [HACKERS] foreign key introduces unnecessary locking ? Mikheev, Vadim
22:33 Re: [HACKERS] foreign key introduces unnecessary locking ? Stephan Szabo
22:37 Re: OID Perfomance - Object-Relational databases Bruce Momjian
22:46 -query sql Nema, Vivek
23:01 "Delete before" in ms sql? Lars Vadsholt
23:08 trigger question Carolyn Lu Wong
23:33 Re: "Delete before" in ms sql? Josh Berkus
23:34 Re: -query sql John McKown

10 October 2000

16:22 Re: AW: Table Attribute Help Michael Fork

11 October 2000

03:23 Re: Q: spinlock on Alpha? (PG7.0.2) Ryan Kirkpatrick
03:41 Re: Q: spinlock on Alpha? (PG7.0.2) - solved Ryan Kirkpatrick
12:40 Can I use subselect as a function parameter? Oliver Elphick
12:53 Re: Can I use subselect as a function parameter? Philip Warner
13:26 Re: Can I use subselect as a function parameter? Tom Lane
13:49 AFTER triggers, short question Mark Volpe
14:56 SQL to retrieve foreign keys Colleen Williams
15:29 Re: SQL to retrieve foreign keys Stephan Szabo
18:18 Referential integrity: broken rule? Franz J Fortuny
21:19 Re: Referential integrity: broken rule? Stephan Szabo

12 October 2000

06:19 dynamic object creation Indraneel Majumdar
07:52 set digest
13:15 if else query help Brian C. Doyle
13:26 Re: dynamic object creation Mark Volpe
13:53 Re: if else query help Jean-Christophe Boggio
14:35 Re: if else query help Josh Berkus
16:41 Re: if else query help Jie Liang
16:44 Standard syntax? Franz J Fortuny
16:54 Re: Standard syntax? Josh Berkus
16:55 Re: Standard syntax? Tomas Berndtsson
17:25 Re: Standard syntax? Jie Liang
17:35 Re: if else query help John McKown
17:42 Re: Standard syntax? Peter Eisentraut
18:32 Re: Standard syntax? Tom Lane
20:48 Problem whith Stored queries Nelson Brito
20:51 xml perl & pgsql Philip Cook

13 October 2000

07:33 Re: dynamic object creation Indraneel Majumdar
07:34 Re: dynamic object creation Indraneel Majumdar
10:20 Operator Column Itai Zukerman

15 October 2000

13:00 Variable-length Types Itai Zukerman
17:32 Re: Variable-length Types Josh Berkus
17:52 Re: Regular expression query Bruce Momjian
19:27 Re: Variable-length Types Tom Lane
19:49 Re: Variable-length Types Josh Berkus
20:00 Re: Variable-length Types Itai Zukerman
20:23 Re: Variable-length Types KuroiNeko
23:40 Re: Variable-length Types Josh Berkus

16 October 2000

01:10 Re: Variable-length Types Josh Berkus
01:25 Re: Variable-length Types Bruce Momjian
04:40 many-many mapping between unique tables Indraneel Majumdar
06:06 Antw: many-many mapping between unique tables Gerhard Dieringer
06:37 Re: Antw: many-many mapping between unique tables Indraneel Majumdar
07:15 Re: Antw: many-many mapping between unique tables Gerhard Dieringer
07:55 JDBC Performance Craig May
08:02 Re: Antw: many-many mapping between unique tables Indraneel Majumdar
08:17 Re: Antw: many-many mapping between unique tables Indraneel Majumdar
14:17 Re: Antw: many-many mapping between unique tables Josh Berkus
14:31 Re: Antw: many-many mapping between unique tables KuroiNeko
15:42 Re: Antw: many-many mapping between unique tables Indraneel Majumdar
21:06 Formatting US phone numbers, was Variable-length Types KuroiNeko
21:59 Re: many-to-many mapping K Parker
23:14 Re: JDBC Performance Josh Berkus

17 October 2000

09:14 Last serial number inserted Eduardo
14:47 Re: Last serial number inserted Josh Berkus
15:56 Re: Variable-length Types DalTech - CTE
17:14 nested transactions Bernie Huang
18:02 Big Sub-select statement Bernie Huang
18:05 problem with select where like ']' hubert depesz lubaczewski
18:37 Re: problem with select where like ']' Tom Lane
19:14 Re: problem with select where like ']' KuroiNeko
21:11 Re: nested transactions Bruce Momjian
21:26 Re: nested transactions John Hasler
21:43 Re: problem with select where like ']' Joseph Shraibman
22:29 Re: problem with select where like ']' Tom Lane
22:43 Re: problem with select where like ']' Bruce Momjian
22:53 Re: problem with select where like ']' Joseph Shraibman
23:08 Re: problem with select where like ']' Bruce Momjian
23:49 Re: problem with select where like ']' Vince Vielhaber
23:50 RE: nested transactions Mikheev, Vadim

18 October 2000

00:25 Re: JDBC Performance Peter Mount
12:27 Function that returns a tuple. Claudio Jose Zanardi Grillo
14:20 Re: problem with select where like ']' Peter Eisentraut
14:36 Re: Function that returns a tuple. Josh Berkus
15:32 Re: Function that returns a tuple. Tom Lane

19 October 2000

12:25 substr Jeff MacDonald
13:50 Re: substr Tom Lane
15:06 Re: substr Jeff MacDonald
17:00 COUNT Craig May
17:03 Re: COUNT Frank Bax
17:07 Re: COUNT Brian C. Doyle
17:20 Re: COUNT Jie Liang
17:30 Re: COUNT Daniel Wickstrom
17:35 Re: COUNT
22:04 Conditional query plans. Michael Richards
22:43 what is the best way to set-up keywords in tables and Queries ? lesstif
22:49 Re: [HACKERS] Conditional query plans. Tom Lane
23:57 "too big" transactions Edmar Wiggers

20 October 2000

11:18 Re: Conditional query plans. Continuing Technical Education

23 October 2000

15:11 jan.bajerski@viterra.pl
15:44 Re: [HACKERS] foreign key introduces unnecessary locking ? Jan Wieck
15:54 Re: Stephan Szabo
16:01 Re: Tomas Berndtsson
17:09 Re:
18:05 Re: SQL Josh Berkus
19:29 help on creating table pgsql-sql
19:32 Re: what is the best way to set-up keywords in tables and Queries ? Keith Kratochvil
22:09 Large Objects Craig May
22:12 Need info: pl/pgsql performance najm Hashmi
22:13 Help: Using a regular expression match as a value Richard DeVenezia
22:39 Postgresql Site Search Craig May
22:55 Re: Postgresql Site Search The Hermit Hacker

24 October 2000

01:23 Like Query on BLOB's Craig May
02:30 Re: Large Objects pgsql-sql
09:46 Re: Help: Using a regular expression match as a value tjk@tksoft.com
13:03 Permission and users Ferruccio Zamuner
13:04 knowing which columns have beend UPDATEd inside a TRIGGER? Louis-David Mitterrand
17:52 Alternate Database Locations Brian C. Doyle
18:27 Error in Extrack Database Tubagus Nizomi
18:41 Re: NULL Sandis Jerics
19:27 Re: Error in Extrack Database Poul L. Christiansen
19:55 Re: Re: NULL Mark Volpe
20:04 Help on Union Query Craig May
22:13 Re: help on createing table Josh Berkus
22:19 Re: Alternate Database Locations Brian C. Doyle
23:49 Re: Help on Union Query Josh Berkus

25 October 2000

00:05 Re: knowing which columns have beend UPDATEd inside a TRIGGER? Tom Lane
03:18 quote in function Carolyn Lu Wong
05:28 Re: knowing which columns have beend UPDATEd inside a TRIGGER? Louis-David Mitterrand
07:20 Re: knowing which columns have beend UPDATEd inside a TRIGGER? Tomas Berndtsson
15:41 Re: help on creating table Albert REINER
17:34 How to call a shell command in rule Jie Liang
19:30 Re: Alternate Database Locations Brian C. Doyle
19:31 Re: Alternate Database Locations Roderick A. Anderson
22:02 Get a time from a char column Blaise Carrupt

26 October 2000

02:03 Surprising sequence scan when function call used Will Fitzgerald
02:17 Surprising sequence scan when function call used Will Fitzgerald
02:24 Re: Alternate Database Locations Tom Lane
02:29 Re: How to call a shell command in rule Clayton Cottingham
02:34 plperl Jie Liang
02:36 Add Constraint Sivagami .
02:42 Get a time from a char column Blaise Carrupt
02:42 How to Return number of rows updated in stored procedure Shane McEneaney
03:06 Re: Surprising sequence scan when function call used Tom Lane
03:25 Re: Alternate Database Locations indraneel@www.cdfd.org.in
03:29 How to Return number of rows updated in stored procedure Shane McEneaney
03:30 Re: Problem whith Stored queries Jie Liang
03:31 Query Problem Josh Berkus
10:29 Re: Surprising sequence scan when function call used Hosokawa Tetsuichi
12:21 Re: plperl Tom Lane
12:27 pg_atoi: error in "template1": can't parse "template1" Dronamraju Rajesh
12:32 Re: Alternate Database Locations Brian C. Doyle
12:41 Re: How to call a shell command in rule Jie Liang
12:47 Re: Add Constraint Stephan Szabo
13:06 Re: Query Problem Tomas Berndtsson
14:21 Re: Alternate Database Locations Tom Lane
14:37 Re: Query Problem Stephan Szabo
14:43 Re: Query Problem Tom Lane
14:48 Re: Alternate Database Locations Tom Lane
14:56 Re: pg_atoi: error in "template1": can't parse "template1" Tom Lane
15:06 Re: plperl Peter Eisentraut
16:00 Re: Alternate Database Locations Brian C. Doyle
17:17 Re: Query Problem Josh Berkus
18:15 Re: Alternate Database Locations Peter Eisentraut
18:15 Re: Alternate Database Locations indraneel@www.cdfd.org.in
20:07 HELP! ... pg_locale ??? Sandis Jerics
20:08 "average" time Ulf Mehlig
20:38 Nested Aggregate fonction & gouping attributes Pitot

27 October 2000

05:25 renaming columns... danger? Michael Teter
06:46 except on nulls? Daniel Kalchev
08:48 Re: HELP! ... pg_locale ??? Tom Lane
08:48 Re: renaming columns... danger? Emils Klotins
08:51 Re: renaming columns... danger? Grant Finnemore
14:22 Re: except on nulls? Tom Lane
21:38 benchmarks Clayton C.

28 October 2000

01:33 . Sivagami .
04:49 Re: benchmarks KuroiNeko
06:41 Re: benchmarks Josh Berkus
06:42 Re: HELP! ... pg_locale ??? Tom Lane
06:44 Re: renaming columns... danger? Emils Klotins
07:08 Re: except on nulls? Tom Lane
20:02 Re: benchmarks KuroiNeko

29 October 2000

04:58 RE: benchmarks Edmar Wiggers
11:51 Re: benchmarks tjk@tksoft.com
22:38 pgsql-sql list should now work again ... The Hermit Hacker

30 October 2000

07:05 select with function per row Marcin Mazurek
10:36 Lengyel Ferenc
10:55 Re: Yury Don
11:04 Large Object dump ? Alessandro Rossi
11:10 RE: Schlobohm, Jack
12:16 Re: Large Object dump ? tjk@tksoft.com
12:20 ... Petr Jezek
12:32 Re: Philip Warner
12:33 Re: Large Object dump ? Alessandro Rossi
12:41 unsubscribe Vadim Govorov
13:36 Need help! parse erro Najm Hashmi
14:12 Synonyms Carl Shelbourne
14:27 unsubscribe Schlobohm, Jack
14:48 Re: Synonyms Peter Eisentraut
16:37 fetching rows Nikolay Mijaylov
18:15 Re: fetching rows K Parker
19:53 Re: fetching rows Jeff Hoffmann
21:14 Re: fetching rows Martin Christensen

31 October 2000

05:17 Re: Synonyms hubert depesz lubaczewski
09:32 PLPGSQL examples Kovacs Zoltan Sandor
10:42 Re: fetching rows Decio Fonini
14:13 INSERT [IGNORE] INTO TABLE Petr Jezek
14:23 Re: Need info: pl/pgsql performance Kovacs Zoltan Sandor
14:29 RE: INSERT [IGNORE] INTO TABLE Edmar Wiggers
15:03 RE: INSERT [IGNORE] INTO TABLE Petr Jezek
15:16 RE: INSERT [IGNORE] INTO TABLE Edmar Wiggers
15:54 Re: INSERT [IGNORE] INTO TABLE Najm Hashmi
17:50 RE: INSERT [IGNORE] INTO TABLE K Parker
19:53 Problem with coalesce.. George Henry C. Daswani