pgsql-sql - November 2004

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Nov. 1, 2004

Thread Author Time
Re: paertially restoring a DB Iain 05:51
'show databases' in psql way? Erik Wasser 12:13
Re: 'show databases' in psql way? Frank Bax 12:23
Re: 'show databases' in psql way? Ian Barwick 12:26
Re: 'show databases' in psql way? Erik Wasser 12:33
Join Table T E Schmitz 16:34
Re: Join Table Michael Fuhr 17:03
Re: Join Table Tom Lane 17:07
Re: Join Table Richard Huxton 17:08
Re: Join Table T E Schmitz 18:12
Re: Join Table Mischa Sandberg 19:55

Nov. 2, 2004

Thread Author Time
Re: 'show databases' in psql way? Greg Sabino Mullane 03:40
Re: Join Table Michael Fuhr 04:22
Update instead rules on Views Markus Schaber 12:05
Re: 'show databases' in psql way? lorid 14:24
Re: 'show databases' in psql way? Arash Zaryoun 15:03
Re: Update instead rules on Views Markus Schaber 15:20
Re: 'show databases' in psql way? Achilleus Mantzios 15:21
Re: Update instead rules on Views Markus Schaber 15:42
query using a date field that isn't set John B. Scalia 15:44
Re: JOIN not being calculated correctly Andrew Hammond 18:46
Re: [SQL] Log Andrew Hammond 18:56
third edition of SQL FOR SMARTIES --CELKO-- 19:36

Nov. 3, 2004

Thread Author Time
vacuum analyze slows sql query patrick ~ 02:50
Insert/Update Perl Function involving two tables needing to by 'in sync' Ferindo Middleton Jr 03:26
Re: 'show databases' in psql way? Greg Sabino Mullane 03:46
Re: vacuum analyze slows sql query Andrew Sullivan 12:01
Re: vacuum analyze slows sql query Jim Buttafuoco 13:31
trigger status hook 14:57
Re: trigger status Michael Fuhr 15:33
CREATE TYPE Ameen - Etemady 15:56
Re: CREATE TYPE Jeff 16:23
Re: vacuum analyze slows sql query patrick ~ 18:31
Re: vacuum analyze slows sql query Andrew Sullivan 18:45
Re: vacuum analyze slows sql query Greg Stark 19:20
oracle v$session equivalent in postgresql stuff 20:06

Nov. 4, 2004

Thread Author Time
Re: CREATE TYPE sad 06:30
Group by and aggregates Michael L. Hostbaek 16:54
Delayed result from another connection SZŰCS Gábor 17:19
Re: Group by and aggregates Sam Mason 17:25
Re: Group by and aggregates Michael Fuhr 17:31
Re: Group by and aggregates Edmund Bacon 17:34
Re: Group by and aggregates Franco Bruno Borghesi 17:41
Re: Delayed result from another connection Tom Lane 17:46
Re: Group by and aggregates Oliver Elphick 17:46
CREATE TRIGGER ... FOR EACH STATEMENT Mischa Sandberg 22:16

Nov. 5, 2004

Thread Author Time
Re: CREATE TRIGGER ... FOR EACH STATEMENT Mischa Sandberg 03:27
Re: Delayed result from another connection SZŰCS Gábor 13:29
sql problem Flavio Fonseca 14:34
Help in stored procedure Igor Maciel Macaubas 14:35
Re: Group by and aggregates Michael L. Hostbaek 14:51
Killed backend won't rollback transaction? SZŰCS Gábor 14:52
Oracle to Postgres Mickael Faivre-Macon 15:12
Re: Help in stored procedure Thomas F.O'Connell 15:13
oracle v$session equivalent in postgresql stuff 15:27
Re: Delayed result from another connection Tom Lane 15:53
Re: Killed backend won't rollback transaction? Tom Lane 16:02
Re: sql problem Achilleus Mantzios 16:50
Simple SQL Question Andras Kutrovics 16:54
Scheduling Jobs In PostgreSQL Chethana Kuloor 17:05
Re: Simple SQL Question Bricklen 17:13
Re: Simple SQL Question Franco Bruno Borghesi 18:09
Re: Simple SQL Question Tomasz Myrta 18:09
Re: oracle v$session equivalent in postgresql Ian Barwick 19:53

Nov. 6, 2004

Thread Author Time
Re: Simple SQL Question Greg Stark 08:17

Nov. 7, 2004

Thread Author Time
Hi vasundhar 06:45
tricky GROUP BY / JOIN question T E Schmitz 10:31
Re: tricky GROUP BY / JOIN question Tom Lane 18:31

Nov. 8, 2004

Thread Author Time
Re: query using a date field that isn't set D'Arcy J.M. Cain 01:56
Re: third edition of SQL FOR SMARTIES D'Arcy J.M. Cain 02:03
Re: Scheduling Jobs In PostgreSQL Michael Fuhr 03:25
Re: Scheduling Jobs In PostgreSQL Christopher Browne 04:17
how to use COPY within plperl Marek Lewczuk 08:59
Re: Scheduling Jobs In PostgreSQL Kaare Rasmussen 09:36
Re: Killed backend won't rollback transaction? SZŰCS Gábor 14:21
Re: Hi Steven Klassen 15:57
Re: how to use COPY within plperl Goutam Paruchuri 19:04
Re: how to use COPY within plperl Marek Lewczuk 19:14
Job opportunity Kyle 23:29

Nov. 9, 2004

Thread Author Time
A transaction in transaction? Possible? Andrei Bintintan 08:47
Re: Simple SQL Question Andras Kutrovics 09:16
INSERT INTO VIEW - Replacement marc ratun 10:41
Re: A transaction in transaction? Possible? Michael Fuhr 13:55
Drop all indexes of a table w/o knowing the index names Giulio Orsero 14:40
Re: tricky GROUP BY / JOIN question T E Schmitz 14:46
upper/lower for german characters Andrei Bintintan 14:58
Re: A transaction in transaction? Possible? Theodore Petrosky 15:24
Re: Drop all indexes of a table w/o knowing the index names Achilleus Mantzios 15:30
Loading text data/binary data !! Goutam Paruchuri 15:34
Re: A transaction in transaction? Possible? Bricklen 16:20
Re: Simple SQL Question Franco Bruno Borghesi 16:53
Re: [SQL] upper/lower for german characters Markus Schaber 17:59
Re: Drop all indexes of a table w/o knowing the index names Giulio Orsero 19:55
select using regexp does not use indexscan carex 20:02
Aggregate like AVG() with Money Data Type andre.toscano 20:40
Comparing two (largish) tables on different servers Gregory S. Williamson 22:41

Nov. 10, 2004

Thread Author Time
Re: Comparing two (largish) tables on different servers Pierre-Frédéric Caillaud 00:12
Re: Aggregate like AVG() with Money Data Type Michael Fuhr 01:33
UPDATE/INSERT on multiple co-dependent tables Ferindo Middleton Jr 02:26
UPDATE/INSERT on multiple co-dependent tables Ferindo Middleton, Jr 02:35
Re: UPDATE/INSERT on multiple co-dependent tables Stephan Szabo 03:19
Is NULLIF nullable? Dean Gibson (DB Administrator) 03:29
Re: Is NULLIF nullable? Dean Gibson (DB Administrator) 05:12
Re: A transaction in transaction? Possible? sad 06:23
Re: A transaction in transaction? Possible? Michael Fuhr 06:25
Re: [SQL] upper/lower for german characters Contact AR-SD.NET 07:04
Re: A transaction in transaction? Possible? Riccardo G. Facchini 08:45
Re: Comparing two (largish) tables on different servers Sam Mason 09:18
Re: A transaction in transaction? Possible? Michael Fuhr 09:53
Re: A transaction in transaction? Possible? Andrei Bintintan 10:37
Re: A transaction in transaction? Possible? Achilleus Mantzios 10:58
Re: A transaction in transaction? Possible? Peter Eisentraut 15:23
Re: A transaction in transaction? Possible? Achilleus Mantzios 16:01
Re: A transaction in transaction? Possible? Peter Eisentraut 16:09
Error In connection ?? Goutam Paruchuri 16:32
Re: Error In connection ?? Richard Huxton 17:19
Unicode problem inserting records - Invalid UNICODE character sequence found (0xfc7269) David B 17:19
Re: A transaction in transaction? Possible? Tom Lane 17:28
Re: Error In connection ?? Goutam Paruchuri 18:11
Re: Error In connection ?? Goutam Paruchuri 18:15
Re: Error In connection ?? Richard Huxton 18:30
Re: Unicode problem inserting records - Invalid UNICODE character Richard Huxton 18:34
Re: Error In connection ?? Goutam Paruchuri 18:38
Re: Comparing two (largish) tables on different servers Michael Fuhr 19:32
Re: A transaction in transaction? Possible? Stefan Weiss 21:36

Nov. 11, 2004

Thread Author Time
Re: A transaction in transaction? Possible? Gaetano Mendola 08:10
Re: A transaction in transaction? Possible? Gaetano Mendola 08:23
Re: Unicode problem inserting records - Invalid UNICODE character David B 19:29
Re: A transaction in transaction? Possible? Stefan Weiss 19:31

Nov. 12, 2004

Thread Author Time
Cascade updates wait until the end of the transaction? Thomas Berg 03:15
Re: Unicode problem inserting records - Invalid UNICODE character 📎 Richard Huxton 08:18
Re: Unicode problem inserting records - Invalid UNICODE Markus Schaber 09:57
TEXT::CIDR/INET::CIDR output confusion Alexander M. Pravking 21:31

Nov. 13, 2004

Thread Author Time
anounce Kenneth Gonsalves 06:48
postgreSQL 8beta beyaNet 14:35
Re: select using regexp does not use indexscan Stephan Szabo 21:39
Re: postgreSQL 8beta Karsten Hilbert 22:48

Nov. 14, 2004

Thread Author Time
Re: select using regexp does not use indexscan Tom Lane 00:02
Re: UPDATE/INSERT on multiple co-dependent tables Karsten Hilbert 08:47
View and subselect related questions Jakub Kaniewski 13:13
Re: postgreSQL 8beta Theodore Petrosky 13:50

Nov. 15, 2004

Thread Author Time
Re: select using regexp does not use indexscan carex 17:12

Nov. 16, 2004

Thread Author Time
Re: Cascade updates wait until the end of the transaction? Stephan Szabo 06:52
Move table between schemas Markus Schaber 09:02
Re: Move table between schemas Andrew Sullivan 11:05
tree structure photo gallery date quiery Gary Stainburn 11:29
Re: Move table between schemas Achilleus Mantzios 12:30
Re: tree structure photo gallery date quiery sad 13:08
Re: tree structure photo gallery date quiery Rod Taylor 13:23
Table definition Bruno Prévost 14:04
Re: Table definition Goutam Paruchuri 15:07
Re: Table definition Peter Eisentraut 15:16
Re: Table definition Sam Mason 15:29
Re: Table definition Bruno Prévost 15:40
Re: Table definition Peter Eisentraut 16:13
Re: Table definition Bruno Prévost 16:49
Re: tree structure photo gallery date quiery Pierre-Frédéric Caillaud 18:51
Counting Distinct Records Thomas F.O'Connell 19:45
Re: Counting Distinct Records Stephan Szabo 20:03
Re: Counting Distinct Records Thomas F.O'Connell 20:09
finding gaps in dates Matt Nuzum 20:56
Re: finding gaps in dates Pierre-Frédéric Caillaud 21:43
Re: Move table between schemas Andrew Sullivan 22:09
Re: Counting Distinct Records Stephan Szabo 22:34
Re: Counting Distinct Records Thomas F.O'Connell 23:02

Nov. 17, 2004

Thread Author Time
Re: tree structure photo gallery date quiery Gary Stainburn 00:35
Re: tree structure photo gallery date quiery Mike Rylander 02:15
Re: tree structure photo gallery date quiery Oleg Bartunov 08:04
Re: tree structure photo gallery date quiery Oleg Bartunov 09:45
Re: tree structure photo gallery date quiery Achilleus Mantzios 10:00
session_id Riccardo G. Facchini 13:13
Re: session_id Richard Huxton 13:49
Re: session_id Riccardo G. Facchini 14:25
Re: session_id Riccardo G. Facchini 14:27
Re: session_id Achilleus Mantzios 14:33
Re: session_id Richard Huxton 14:44
Re: Counting Distinct Records Stephan Szabo 14:52
Re: session_id Riccardo G. Facchini 15:04
Re: session_id Michael Fuhr 15:19
Re: session_id Richard Huxton 15:24
Re: Counting Distinct Records Thomas F.O'Connell 19:27

Nov. 18, 2004

Thread Author Time
Usenet Discussion Proposal Harry Smith 03:01
How to make lo_import and lo_export to use file on client local machine? Premsun Choltanwanich 10:45
Re: session_id Riccardo G. Facchini 12:38
missing... at end of sql expression Justine.Cleary 19:28
Comparing Dates Nick Peters 21:01
Re: Comparing Dates Ian Barwick 21:10
Re: Comparing Dates Thomas F.O'Connell 21:15
Re: Comparing Dates Nick Peters 21:34

Nov. 19, 2004

Thread Author Time
Re: Comparing Dates Greg Stark 05:50
SQL Question Igor Kryltsov 05:57
Re: Comparing Dates Thomas F.O'Connell 06:07
get sequence value of insert command Erik Thiele 08:41
Re: get sequence value of insert command Michael Glaesemann 09:20
Re: get sequence value of insert command Richard Huxton 09:26
Re: get sequence value of insert command Achilleus Mantzios 09:37
Re: get sequence value of insert command Iain 09:49
transactions in functions, possible bug or what I'm doing wrong? Riccardo G. Facchini 11:52
Re: transactions in functions, possible bug or what I'm doing Richard Huxton 12:59
CREATE TEMPORARY TABLE .. ON COMMIT DROP question Riccardo G. Facchini 14:05

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30