pgsql-sql since 2008-02-18 00:00

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

Feb. 18, 2008

Thread Author Time
comment on COLUMN, broken or misunderstanding? Bryce Nesbitt 02:18
Re: comment on COLUMN, broken or misunderstanding? Tom Lane 02:35
Re: comment on COLUMN, broken or misunderstanding? Markus Bertheau 02:39
Re: comment on COLUMN, broken or misunderstanding? Milen A. Radev 02:50
Re: comment on COLUMN, broken or misunderstanding? Michael Fuhr 04:38

Feb. 19, 2008

Thread Author Time
SELECT DISTINCT Shavonne Marietta Wijesinghe 10:01
Am I wasting my time with partitions? Stuart Brooks 10:54
UPDATE with ORDER BY Robins Tharakan 12:49
Re: Am I wasting my time with partitions? Richard Huxton 13:48
Re: SELECT DISTINCT Richard Huxton 13:51
Re: Am I wasting my time with partitions? Stuart Brooks 14:05

Feb. 21, 2008

Thread Author Time
Data layer migration from MSSQL Sebastian Rychter 17:47
Re: Data layer migration from MSSQL Medi Montaseri 18:42
Re: Data layer migration from MSSQL Sebastian Rychter 18:55

Feb. 22, 2008

Thread Author Time
Re: Proposed archival read only trigger on rows - prevent history modification Robert Treat 03:31
Re: Proposed archival read only trigger on rows - prevent history modification Phillip Smith 04:09
postgresql function not accepting null values in select statement Jyoti Seth 08:30
Re: postgresql function not accepting null values in select statement Richard Huxton 09:05
Re: postgresql function not accepting null values in select statement Jyoti Seth 09:22
Re: postgresql function not accepting null values in select statement Richard Huxton 09:33
Re: postgresql function not accepting null values in select statement Robins Tharakan 09:34
Re: postgresql function not accepting null values inselect statement Bart Degryse 09:35
Re: postgresql function not accepting null values inselect statement johnf 16:30
Delete with foreign keys felix 18:00
SQL standards in Mysql Ken Johanson 18:57
Re: SQL standards in Mysql Alvaro Herrera 19:57

Feb. 23, 2008

Thread Author Time
Re: SQL standards in Mysql Scott Marlowe 00:13
Re: SQL standards in Mysql Dean Gibson (DB Administrator) 01:39
Re: SQL standards in Mysql Scott Marlowe 05:03
Re: SQL standards in Mysql Scott Marlowe 05:34
Re: SQL standards in Mysql Tom Lane 05:50
Re: Delete with foreign keys dipesh 07:12
Re: Delete with foreign keys felix 07:47
Re: SQL standards in Mysql Aarni Ruuhimäki 21:06

Feb. 25, 2008

Thread Author Time
Re: postgresql function not accepting null values inselect statement Jyoti Seth 05:20
autovacuum not freeing up unused space on 8.3.0 Stuart Brooks 06:27
Re: postgresql function not accepting null values inselect statement Robins Tharakan 06:56
Re: autovacuum not freeing up unused space on 8.3.0 Stuart Brooks 06:57
Re: postgresql function not accepting null values inselect statement Robins Tharakan 07:03
Re: postgresql function not accepting null valuesinselect statement Bart Degryse 08:05
Re: Bouncing replies [was: SQL standards in Mysql] Dean Gibson (DB Administrator) 21:08
Re: Bouncing replies [was: SQL standards in Mysql] Dave Page 21:29
Re: Bouncing replies [was: SQL standards in Mysql] Colin Wetherbee 21:33

Feb. 26, 2008

Thread Author Time
Re: Bouncing replies [was: SQL standards in Mysql] Scott Marlowe 00:42
Bounce test Dean Gibson (DB Administrator) 03:13
Re: Bounce test Adrian Klaver 03:17
Re: Bounce test Adrian Klaver 03:20
Re: Bounce test Tom Lane 03:24
Re: Bouncing replies [was: SQL standards in Mysql] Scott Marlowe 03:26
Re: Bounce test Scott Marlowe 03:28
Re: Bounce test Scott Marlowe 03:29
Re: Bounce test Scott Marlowe 03:32
Re: Bounce test Colin Wetherbee 03:36
Re: Bouncing replies [was: SQL standards in Mysql] D'Arcy J.M. Cain 03:36
Re: Bounce test Adrian Klaver 03:54
Re: Bounce test Scott Marlowe 04:07
Re: Bounce test Adrian Klaver 05:08
duplicate key violates unique constraint Shavonne Marietta Wijesinghe 14:55
Re: Deploying PostgreSQL on virtualized hardware TJ O'Donnell 14:56
Re: duplicate key violates unique constraint Teemu Torma 15:17
Re: duplicate key violates unique constraint Shavonne Marietta Wijesinghe 16:05
Re: duplicate key violates unique constraint Andrew Sullivan 16:22
Re: duplicate key violates unique constraint Teemu Torma 16:28
Function returns error (view) Professor Flávio Brito 16:32
Re: duplicate key violates unique constraint Bart Degryse 16:34
Re: duplicate key violates unique constraint Shavonne Marietta Wijesinghe 16:36
Re: Function returns error (view) Colin Wetherbee 16:36
Re: Function returns error (view) Professor Flávio Brito 16:48
Re: Function returns error (view) Bart Degryse 16:59
Re: duplicate key violates unique constraint Alvaro Herrera 17:03
Re: duplicate key violates unique constraint Rodrigo E. De León Plicet 17:09
Re: [SQL] Deploying PostgreSQL on virtualized hardware Colin Wetherbee 17:33
Re: Function returns error (view) Professor Flávio Brito 18:20
Re: duplicate key violates unique constraint Edward W. Rouse 19:29

Feb. 27, 2008

Thread Author Time
Re: Function returns error (view) Bart Degryse 07:52
Re: Function returns error (view) Markus Bertheau 09:09
Re: Function returns error (view) Bart Degryse 09:16
REFERENCES and INHERITS restrictions? Stefan Scheidegger 09:25
Re: Function returns error (view) Markus Bertheau 09:37
how do I get table DDL from psql (not from pg_dump) Sofer, Yuval 11:22
Re: how do I get table DDL from psql (not from pg_dump) A. Kretschmer 12:19
Re: REFERENCES and INHERITS restrictions? Gregory Stark 14:04
Re: how do I get table DDL from psql (not from pg_dump) Frank Bax 15:23
Re: how do I get table DDL from psql (not from pg_dump) Lew 16:57
Re: SQL standards in Mysql Steve Crawford 18:31
Re: Function returns error (view) Professor Flávio Brito 20:42
operator class miquel_ibanez 22:40

Feb. 28, 2008

Thread Author Time
Subselects returning array and ANY... Dawid Kuroczko 00:01
Re: Subselects returning array and ANY... Josh Berkus 00:11
Re: Subselects returning array and ANY... Dawid Kuroczko 00:34
Re: Subselects returning array and ANY... Josh Berkus 00:45
Re: operator class Tom Lane 05:30
Re: Function returns error (view) Bart Degryse 07:45
Re: Function returns error (view) (RESOLVED) Professor Flávio Brito 16:01
pl/pgsql and error handling Alex Hochberger 19:10

Feb. 29, 2008

Thread Author Time
Re: pl/pgsql and error handling Tom Lane 04:43
Re: pl/pgsql and error handling Alex Hochberger 05:29
Re: pl/pgsql and error handling Bart Degryse 07:44

March 1, 2008

Thread Author Time
Function returns error (view) (RESOLVED) Professor Flávio Brito 11:11

March 2, 2008

Thread Author Time
Re: Bouncing replies [was: SQL standards in Mysql] Bruce Momjian 21:32

March 3, 2008

Thread Author Time
psql word wrapping to terminal width - testers? Bryce Nesbitt 06:20
compiling plpython compilation error Gerardo Herzig 13:15
Re: compiling plpython compilation error Tom Lane 16:12
Re: psql word wrapping to terminal width - testers? 📎 Bryce Nesbitt 19:30

March 4, 2008

Thread Author Time
php to pgsql question li ethan 10:25
Re: php to pgsql question Leif B. Kristensen 10:32
Re: compiling plpython compilation error (solved) Gerardo Herzig 16:16
Documenting a DB schema Shahaf Abileah 20:02
Re: [GENERAL] Documenting a DB schema Oisin Glynn 20:45
Re: Documenting a DB schema Emi Lu 20:47
Re: Documenting a DB schema Tomás Di Doménico 20:54
Re: Documenting a DB schema Michael Monnerie 20:56
Re: Documenting a DB schema Alan Hodgson 21:00
Re: Documenting a DB schema Colin Wetherbee 21:06
Re: [SQL] Documenting a DB schema Steve Crawford 21:27
Re: Documenting a DB schema Mary Anderson 22:13
using copy from in function Yura Gal 22:51

March 5, 2008

Thread Author Time
Re: using copy from in function Osvaldo Kussama 01:02
Re: Documenting a DB schema Professor Flávio Brito 13:10
Re: [DOCS] Documenting a DB schema David Fetter 15:05
finding columns that have three or fewer distinct characters Jeff Frost 17:33
Re: using copy from in function Steve Midgley 17:38
Re: finding columns that have three or fewer distinct characters Colin Wetherbee 17:56
Re: finding columns that have three or fewer distinct characters Osvaldo Rosario Kussama 18:46
Re: finding columns that have three or fewer distinct characters Jeff Frost 20:03
Bit string help, please tyrrill_ed 22:17

March 6, 2008

Thread Author Time
RETURN QUERY generates error Yura Gal 07:45
Re: Bit string help, please Richard Huxton 08:13
Re: RETURN QUERY generates error Richard Huxton 08:24
Re: RETURN QUERY generates error Pavel Stehule 08:40
Re: RETURN QUERY generates error Tom Lane 18:14
Re: Bit string help, please tyrrill_ed 18:24
Re: Bit string help, please Richard Huxton 18:35
Re: Bit string help, please Tena Sakai 18:50
Re: Bit string help, please tyrrill_ed 18:52
Re: Bit string help, please Richard Huxton 19:01
Composite UNIQUE across two tables? Jamie Tufnell 19:04
query results in XML format? Emi Lu 19:24
Re: query results in XML format? Peter Eisentraut 21:14

March 7, 2008

Thread Author Time
Re: Composite UNIQUE across two tables? Jamie Tufnell 01:10
Re: Composite UNIQUE across two tables? Jorge Godoy 02:22
Re: Composite UNIQUE across two tables? Bart Degryse 07:46
Re: Composite UNIQUE across two tables? Sébastien Meudec 08:40
Re: Composite UNIQUE across two tables? Bart Degryse 08:54
UPDATE .. FROM Markus Bertheau 13:13
Re: RETURN QUERY generates error Yura Gal 13:23
Re: UPDATE .. FROM Tom Lane 13:47
Re: Composite UNIQUE across two tables? Jamie Tufnell 15:33
Re: Composite UNIQUE across two tables? Jamie Tufnell 15:46
Re: Composite UNIQUE across two tables? Jamie Tufnell 16:09

March 8, 2008

Thread Author Time
plpythonu + os.spawnv Markus Schatten 01:12
Re: plpythonu + os.spawnv Markus Schatten 14:07

March 9, 2008

Thread Author Time
Re: Composite UNIQUE across two tables? Jamie Tufnell 15:27
Insert problem A. R. Van Hook 21:02

March 10, 2008

Thread Author Time
Re: Insert problem Jamie Tufnell 00:14
Re: Insert problem Steve Midgley 18:09
Re: works but ... Steve Midgley 22:03

March 11, 2008

Thread Author Time
Re: Composite UNIQUE across two tables? Dirk Jagdmann 19:03
Re: Composite UNIQUE across two tables? Rodrigo E. De León Plicet 20:31

March 12, 2008

Thread Author Time
case when... end in update clause? Emi Lu 15:47
Re: case when... end in update clause? Emi Lu 16:01
Re: case when... end in update clause? Scott Marlowe 16:01
Re: case when... end in update clause? Emi Lu 16:11
Re: case when... end in update clause? Scott Marlowe 16:19
Re: case when... end in update clause? Emi Lu 16:25
Timestamp, epoch and a bit confusion Valter Douglas Lisbôa Jr. 22:36
Re: Timestamp, epoch and a bit confusion Aurynn Shaw 22:58

March 13, 2008

Thread Author Time
Re: Timestamp, epoch and a bit confusion Valter Douglas Lisbôa Jr. 00:41
Re: Composite UNIQUE across two tables? Jamie Tufnell 02:42
Re: Composite UNIQUE across two tables? Dirk Jagdmann 06:16
Re: in() VS exists() Bart Degryse 13:46
Re: in() VS exists() Bart Degryse 14:12
Re: in() VS exists() Bart Degryse 14:28
in() VS exists() Julien 14:47
Re: in() VS exists() Bart Degryse 14:50
Re: in() VS exists() Julien 16:10
Re: in() VS exists() Julien 16:27
Re: in() VS exists() Julien 16:50
Counting days ... Aarni Ruuhimäki 18:25
Re: Counting days ... Steve Crawford 18:58
Re: Counting days ... Aarni Ruuhimäki 20:09
Re: Counting days ... Steve Crawford 20:22
cursors and sessions chester c young 22:54
Re: cursors and sessions Aaron Bono 23:04

March 14, 2008

Thread Author Time
Re: Counting days ... Aarni Ruuhimäki 13:04
Re: Counting days ... Frank Bax 13:43
Re: Counting days ... Frank Bax 13:58
Re: Counting days ... Aarni Ruuhimäki 15:13
Re: Counting days ... Steve Crawford 15:59
Re: Counting days ... Frank Bax 16:09
DB Design PostgreSQL Admin 16:45
Re: Counting days ... Aarni Ruuhimäki 17:25

March 15, 2008

Thread Author Time
Re: Counting days ... Frank Bax 16:05
Re: Counting days ... Aarni Ruuhimäki 17:06

March 16, 2008

Thread Author Time
Subselect strange behaviour - bug? Mario Splivalo 17:47
Re: Subselect strange behaviour - bug? Tom Lane 18:28

March 17, 2008

Thread Author Time
Re: Subselect strange behaviour - bug? Mario Splivalo 12:04

March 18, 2008

Thread Author Time
postgres server crashes unexpectedly Chadwick Horn 01:20
Re: postgres server crashes unexpectedly Tom Lane 02:32
Re: postgres server crashes unexpectedly Chadwick Horn 15:17

Browse Archives

Prev | Next