pgsql-sql since 2006-07-24 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

July 24, 2006

Thread Author Time
Re: Referential integrity (foreign keys) across multiple tables Richard Jones 08:59
Re: Rows with exclusive lock Martin Marques 11:28
Primary key constraint violation without error? Mario Splivalo 12:12
Re: Primary key constraint violation without error? Richard Huxton 13:04
Re: Primary key constraint violation without error? Michael Fuhr 13:05
Re: System catalog table privileges Aaron Bono 15:56
Re: Referential integrity (foreign keys) across multiple tables Aaron Bono 17:26
Re: Referential integrity (foreign keys) across multiple tables Bruno Wolff III 17:51
Re: Referential integrity (foreign keys) across multiple tables Richard Jones 17:53
Re: Referential integrity (foreign keys) across multiple tables Richard Jones 17:57
Re: Referential integrity (foreign keys) across multiple tables Richard Huxton 19:32
Re: CREATE TABLE AS inside of a function Kevin Nikiforuk 20:49
Re: Referential integrity (foreign keys) across multiple tables Bruno Wolff III 21:22
Re: CREATE TABLE AS inside of a function Stephan Szabo 22:04

July 25, 2006

Thread Author Time
About Div Otniel Michael 07:57
Re: About Div Aaron Bono 15:00
Storage of Binary Data Aaron Bono 17:05
Re: SQL generator Andrew Hammond 19:31
Re: SQL generator Chris Browne 20:39
Re: reusing AS Andrew Hammond 20:40

July 26, 2006

Thread Author Time
Re: About Div Otniel Michael 01:43
Re: About Div Ross Johnson 02:34
Storing an ordered list Michael Artz 02:58
Re: SQL generator Jonah H. Harris 04:00
Re: About Div Aaron Bono 14:49
Re: Storing an ordered list Aaron Bono 15:07
Re: SQL generator Aaron Bono 15:21
Re: SQL generator Andrew Sullivan 15:38
Re: Rows with exclusive lock Andrew Hammond 19:25
Re: Help with privilages please Andrew Hammond 19:29
Re: Storing an ordered list Bruno Wolff III 20:39
DBD::Pg ... how would I format this prepare? Marc G. Fournier 21:29
Re: DBD::Pg ... how would I format this prepare? Tom Lane 21:57
Re: DBD::Pg ... how would I format this prepare? Jim Buttafuoco 22:09

July 27, 2006

Thread Author Time
Re: DBD::Pg ... how would I format this prepare? Marc G. Fournier 00:05
Re: Storing an ordered list Michael Artz 00:09
Re: Storing an ordered list Michael Artz 00:13
Re: Storing an ordered list Bruno Wolff III 13:18
PostgreSQL server terminated by signal 11 Daniel Caune 16:00
Re: [SQL] PostgreSQL server terminated by signal 11 Jeff Frost 16:07
Disk is full, what's cool to get rid of? Erik Jones 16:20
Re: Disk is full, what's cool to get rid of? Jeff Frost 16:32
Re: Disk is full, what's cool to get rid of? Andrew Sullivan 16:37
Re: Storage of Binary Data Andrew Sullivan 18:03
Re: Disk is full, what's cool to get rid of? Scott Marlowe 18:41
Re: Disk is full, what's cool to get rid of? Erik Jones 19:27
Re: Disk is full, what's cool to get rid of? Jeff Frost 19:40
Re: Disk is full, what's cool to get rid of? Erik Jones 20:00
Re: PostgreSQL server terminated by signal 11 Tom Lane 20:05
Re: Disk is full, what's cool to get rid of? Wilkinson Charlie E 20:17
Re: Disk is full, what's cool to get rid of? Tom Lane 20:36
return setof records Chris Lukenbill 20:41
Re: PostgreSQL server terminated by signal 11 Daniel Caune 21:12
Re: [SQL] PostgreSQL server terminated by signal 11 Daniel Caune 23:00
Re: [SQL] PostgreSQL server terminated by signal 11 Tom Lane 23:26
Re: [SQL] PostgreSQL server terminated by signal 11 D'Arcy J.M. Cain 23:49

July 28, 2006

Thread Author Time
Re: [SQL] PostgreSQL server terminated by signal 11 Daniel CAUNE 03:53
Re: [SQL] PostgreSQL server terminated by signal 11 Daniel CAUNE 04:05
Re: [SQL] PostgreSQL server terminated by signal 11 Tom Lane 04:10
primary keys as TEXT Manlio Perillo 08:37
Re: primary keys as TEXT Michael Glaesemann 10:21
Re: [SQL] PostgreSQL server terminated by signal 11 Daniel Caune 12:49
Re: [SQL] PostgreSQL server terminated by signal 11 Tom Lane 13:37
Re: return setof records Michael Fuhr 14:13
Re: [SQL] PostgreSQL server terminated by signal 11 Daniel Caune 16:09
Re: [SQL] PostgreSQL server terminated by signal 11 Tom Lane 16:31
Re: Disk is full, what's cool to get rid of? Erik Jones 16:43
Re: return setof records Chris Lukenbill 18:01
Re: Storing an ordered list Aaron Bono 19:06
Re: primary keys as TEXT Aaron Bono 19:28
Re: primary keys as TEXT Scott Marlowe 19:34
Re: primary keys as TEXT Manlio Perillo 20:06
UPDATE with WHERE clause on joined table Fabian Peters 21:24
Re: UPDATE with WHERE clause on joined table Erik Jones 23:30

July 29, 2006

Thread Author Time
Re: [SOLVED] UPDATE with WHERE clause on joined table Fabian Peters 08:38

July 30, 2006

Thread Author Time
Re: primary keys as TEXT Aaron Bono 20:28

July 31, 2006

Thread Author Time
Triggers using PL/pgSQL Thusitha Kodikara 04:16
Re: Triggers using PL/pgSQL Aaron Bono 04:52
Re: Triggers using PL/pgSQL Thusitha Kodikara 05:30
Re: Triggers using PL/pgSQL Aaron Bono 05:34
Joining a result set from four (4) tables John Tregea 07:31
Re: Joining a result set from four (4) tables Aaron Bono 08:12
Re: primary keys as TEXT Manlio Perillo 08:57
Re: DBD::Pg ... how would I format this prepare? Mathieu Arnold 11:56
Re: Triggers using PL/pgSQL John DeSoi 12:17
Re: Triggers using PL/pgSQL Aaron Bono 14:59
Re: DBD::Pg ... how would I format this prepare? Harald Fuchs 15:30
Re: Triggers using PL/pgSQL Ken Hill 15:47
Re: Triggers using PL/pgSQL John DeSoi 15:53
Re: Triggers using PL/pgSQL Milen A. Radev 16:12
Re: Triggers using PL/pgSQL George Weaver 16:16
Re: primary keys as TEXT Aaron Bono 19:34

Aug. 1, 2006

Thread Author Time
Re: Joining a result set from four (4) tables John Tregea 00:12
finding unused indexes? George Pavlov 16:05
Re: finding unused indexes? Jim Buttafuoco 16:10
Re: finding unused indexes? Brad Nicholson 16:11
Re: Joining a result set from four (4) tables Aaron Bono 19:32
viewing the description of tables from python DB-API Daniel Joo 22:30
Re: viewing the description of tables from python DB-API Alvaro Herrera 23:00
Re: viewing the description of tables from python DB-API Rodrigo De Leon 23:14

Aug. 2, 2006

Thread Author Time
Re: Joining a result set from four (4) tables John Tregea 03:55
alter column type from boolean to char with default doesn't work Markus Bertheau 12:46
Problem while using lo_import and lo_export Penchalaiah P. 12:54
How to cal function in one another Penchalaiah P. 12:55
How to use table from one database to another Penchalaiah P. 12:57
i need informarion regarding functions and arrays... Penchalaiah P. 13:02
Re: How to use table from one database to another Richard Broersma Jr 13:12
Re: alter column type from boolean to char with default doesn't work Tom Lane 13:19
Re: alter column type from boolean to char with default Rod Taylor 13:56
Re: viewing the description of tables from python DB-API Scott Marlowe 16:22
Re: alter column type from boolean to char with default Tom Lane 16:36
Re: Joining a result set from four (4) tables Aaron Bono 18:01

Aug. 3, 2006

Thread Author Time
Re: Problem while using lo_import and lo_export Aaron Bono 00:09
Re: How to cal function in one another Aaron Bono 00:11
Re: i need informarion regarding functions and arrays... Aaron Bono 00:13
Re: Joining a result set from four (4) tables John Tregea 00:51
Re: Problem while using lo_import and lo_export Rodrigo De León 01:33
Re: Problem while using lo_import and lo_export Aaron Bono 04:05
Re: SELECT all fields except two Andrew Hammond 16:16
Function not return zero record Sylvain Racine 16:58
Error: out of memory in create table as 📎 jason nordwick 17:04
Re: Function not return zero record Richard Huxton 17:29
Re: alter column type from boolean to char with default Andrew Hammond 18:49
Re: Error: out of memory in create table as Tom Lane 19:37
Re: alter column type from boolean to char with default Tom Lane 19:40

Aug. 4, 2006

Thread Author Time
[No subject] Jonathan Sinclair 06:55
autoupdating mtime column David Garamond 12:16
Re: autoupdating mtime column Richard Huxton 12:49
Re: autoupdating mtime column David Garamond 15:11
Re: autoupdating mtime column Rodrigo De León 15:39
Re: autoupdating mtime column David Garamond 15:51
Re: autoupdating mtime column Richard Huxton 16:05
Re: autoupdating mtime column Tom Lane 16:10
Re: autoupdating mtime column David Garamond 17:36
Re: autoupdating mtime column Richard Huxton 18:18
select query optimization sergey 18:55
to_dec() Melvin Davidson 21:23

Aug. 5, 2006

Thread Author Time
Re: autoupdating mtime column David Garamond 01:27

Aug. 7, 2006

Thread Author Time
Querying constraints? Lexington Luthor 15:38
Change of data type Judith 17:38
Re: viewing the description of tables from python DB-API George Young 19:20
Re: Change of data type jason nordwick 20:43
Re: Change of data type Kumar Dev 20:45

Aug. 8, 2006

Thread Author Time
Re: Change of data type Roman Neuhauser 11:51
Query response time Jonathan Sinclair 12:25
Re: Query response time Chris Mair 12:48
Re: Query response time Richard Broersma Jr 12:53
Function Temp Table Woes Chad Voelker 17:24
date arithmetic chrisj 21:27

Aug. 9, 2006

Thread Author Time
Re: Function Temp Table Woes Michael Fuhr 02:12
Re: Query response time Roman Neuhauser 17:24

Aug. 10, 2006

Thread Author Time
PL/pgSQL and PHP 5 PostgreSQL Admin 02:36
Re: PL/pgSQL and PHP 5 John DeSoi 03:24
Re: [SQL] PL/pgSQL and PHP 5 Tom Lane 03:40
Re: PL/pgSQL and PHP 5 PostgreSQL Admin 03:42
Re: [SQL] PL/pgSQL and PHP 5 PostgreSQL Admin 03:52
Re: [SQL] PL/pgSQL and PHP 5 - thanks PostgreSQL Admin 04:01
Re: PL/pgSQL and PHP 5 John DeSoi 06:12
Re: Function Temp Table Woes Chad Voelker 11:52
Re: timestamp (MS SQLServer's rowversion) functionality Andrew Hammond 13:28
Re: date arithmetic Osvaldo Rosario Kussama 19:21
Re: Querying constraints? Chris Mair 19:25
Re: Querying constraints? Chris Mair 19:27
Re: Change of data type Shoaib Mir 19:49
how do I check for lower case 📎 Juliann Meyer 20:32
Re: how do I check for lower case Rodrigo De León 21:39
Re: how do I check for lower case Daryl Richter 21:46
Re: how do I check for lower case Scott Marlowe 21:57
Re: how do I check for lower case Oisin Glynn 22:49
Breaking up a query Saad Anis 22:53
Re: Niklas Johansson 23:30

Aug. 11, 2006

Thread Author Time
sql error creating function TJ O'Donnell 00:33
Re: sql error creating function Christopher Browne 12:48
Re: Query response time Jonathan Sinclair 13:58
Can't find which return type is incorrect. Chris Lukenbill 14:45
The Right Way to manage schemas in SCM systems Andrew Hammond 15:05
Re: Can't find which return type is incorrect. codeWarrior 15:28
Re: Can't find which return type is incorrect. Chris Lukenbill 15:49
Undo an update Judith 17:26
Re: Undo an update Rodrigo De León 17:41
Re: timestamp (MS SQLServer's rowversion) functionality Aaron Bono 18:04
Re: timestamp (MS SQLServer's rowversion) functionality Andrew Hammond 18:40

Aug. 12, 2006

Thread Author Time
Re: Undo an update Markus Schaber 09:08
Re: to_dec() Aaron Bono 15:57
Re: Breaking up a query Aaron Bono 16:22

Aug. 13, 2006

Thread Author Time
Re: Breaking up a query Andrew Sullivan 14:43
Using bitmap index scans-more efficient Kyle Bateman 17:46

Aug. 14, 2006

Thread Author Time
Re: Using bitmap index scans-more efficient Florian Weimer 06:40
SQLMAP IBATIS insert values from web forms to a money type column Emi Lu 13:49
Re: SQLMAP IBATIS insert values from web forms to a money type column Andrew Sullivan 14:34
Multiple DB join Sumeet Ambre 21:26
Re: Multiple DB join Shoaib Mir 22:04

Aug. 15, 2006

Thread Author Time
Re: Using bitmap index scans-more efficient Kyle Bateman 01:06
Re: Using bitmap index scans-more efficient Tom Lane 01:53
Re: Multiple DB join Andrew Sullivan 10:36
Re: Multiple DB join Michael Fuhr 11:38
Re: Multiple DB join Jorge Godoy 12:01
Re: Undo an update Kis János Tamás 12:20
Re: Multiple DB join Andrew Sullivan 13:18
Re: Multiple DB join Jorge Godoy 13:25

Browse Archives

Prev | Next