pgsql-sql - August 2009

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 11 12 13 14 17 18 19 20 21 22 24 25 26 27 28 29 30 31

Aug. 3, 2009

Thread Author Time
Activity count problem dino 09:02
Problems when copy data from dump file Klas Stockhem 11:00
Re: Tweak sql result set... ? Axe 11:13
Problems when copy data from dump file Klas Stockhem 12:08
Create table command fails with permission denied Venkateswara Rao Bondada 12:08
Re: Create table command fails with permission denied Rob Sargent 22:02

Aug. 4, 2009

Thread Author Time
Re: Problems when copy data from dump file Richard Huxton 08:09
Re: Create table command fails with permission denied Venkateswara Rao Bondada 08:11
Re: Problems when copy data from dump file Richard Huxton 13:26
Re: Create table command fails with permission denied Rob Sargent 16:32

Aug. 5, 2009

Thread Author Time
Re: Create table command fails with permission denied Tom Lane 01:16
Re: Problems when copy data from dump file Klas Stockhem 09:56
question about pgagent Jan Verheyden 13:54
Re: Create table command fails with permission denied Venkateswara Rao Bondada 17:05
Re: LOG: unexpected EOF on client connection Bernd Nawothnig 18:40
two records per row from query John 23:51

Aug. 6, 2009

Thread Author Time
Re: LOG: unexpected EOF on client connection Tom Lane 02:19
Re: two records per row from query A. Kretschmer 05:21
Re: Problems when copy data from dump file Richard Huxton 07:36
Re: Problems when copy data from dump file Klas Stockhem 08:39
Re: Problems when copy data from dump file Richard Huxton 08:42
trigger problem Jan Verheyden 09:09
Problems when copy data from dump file Klas Stockhem 10:00
Re: two records per row from query Leo Mannhart 13:42
Re: two records per row from query John 13:48
FW: trigger problem Jan Verheyden 13:56
Re: two records per row from query A. Kretschmer 14:21
Re: two records per row from query John 15:46

Aug. 7, 2009

Thread Author Time
Re: two records per row from query Leo Mannhart 09:50
Re: two records per row from query John 13:28

Aug. 11, 2009

Thread Author Time
Updating a specific number of rows in pl/pgsql Peter Headland 00:52
Import (.CVS File) to postgreSql 📎 Premila Devi 03:54
Re: Import (.CVS File) to postgreSql Shoaib Mir 04:22
Re: Import (.CVS File) to postgreSql Shoaib Mir 04:58
Re: Import (.CVS File) to postgreSql A. Kretschmer 05:12
Determining logically unique entities across many partially complete rows where at least one column matches Jamie Tufnell 06:19
Re: Updating a specific number of rows in pl/pgsql D'Arcy J.M. Cain 10:25
Re: Updating a specific number of rows in pl/pgsql Pavel Stehule 10:55
Re: Determining logically unique entities across many partially complete rows where at least one column matches Jasen Betts 11:45
mail alert Jan Verheyden 13:01
Month/year between two dates Bor 13:13
Re: Determining logically unique entities across many partially complete rows where at least one column matches Rob Sargent 15:40
Re: Updating a specific number of rows in pl/pgsql Peter Headland 16:55
Re: Updating a specific number of rows in pl/pgsql Peter Headland 17:05
Re: Updating a specific number of rows in pl/pgsql Pavel Stehule 17:22
Re: Updating a specific number of rows in pl/pgsql Peter Headland 17:24
Race hazard deleting using CTID? Peter Headland 18:29
Re: Race hazard deleting using CTID? Tom Lane 19:00
Re: Race hazard deleting using CTID? Peter Headland 20:13
Re: Month/year between two dates Steve Crawford 22:32
Re: mail alert Denis BUCHER 22:35

Aug. 12, 2009

Thread Author Time
Re: mail alert Rob Sargent 01:38
Re: Month/year between two dates ramasubramanian 03:59
Re: mail alert ramasubramanian 04:01
Re: mail alert Shoaib Mir 06:15
Re: mail alert Jan Verheyden 07:29
Re: Updating a specific number of rows in pl/pgsql Xharon 07:34
Re: mail alert Jan Verheyden 13:27
Re: mail alert Rob Sargent 14:01
Re: mail alert Jan Verheyden 14:44
mysql code questions Ray Stell 18:19
Re: mysql code questions Thomas Kellerer 18:52
Re: mysql code questions Greg Stark 19:00

Aug. 13, 2009

Thread Author Time
Re: Month/year between two dates Jorge Godoy 00:58
simple? query Jan Verheyden 11:36
Re: mail alert Jasen Betts 12:08
Re: mail alert Jasen Betts 12:16
Re: simple? query Relyea, Mike 20:46
Re: mail alert Alvaro Herrera 21:54
Re: mail alert Tim Landscheidt 22:24
Re: mail alert Alvaro Herrera 22:36
Re: mail alert Adrian Klaver 23:30

Aug. 14, 2009

Thread Author Time
Re: simple? query Jasen Betts 08:58
Field or record level encryption / decryption Hengky Lie 09:20
Re: simple? query Relyea, Mike 12:58
Re: Field or record level encryption / decryption Joshua Tolley 13:24
Re: simple? query Relyea, Mike 14:21
Re: simple? query Tim Landscheidt 14:53
Re: mail alert Christopher Browne 15:18
Re: Field or record level encryption / decryption Christopher Browne 15:21
Re: Field or record level encryption / decryption Hengky Lie 16:07
Re: Field or record level encryption / decryption Joshua Tolley 22:28

Aug. 17, 2009

Thread Author Time
Multiple simultaneous queries on single connection Yeb Havinga 12:49

Aug. 18, 2009

Thread Author Time
FW: simple? query Jan Verheyden 07:04
operator contains in older Pgsql W. Kinastowski 07:47
Re: operator contains in older Pgsql Jasen Betts 09:44
Re: operator contains in older Pgsql W. Kinastowski 10:16
Re: operator contains in older Pgsql Jasen Betts 11:18
SQL Query Performance - what gives? 📎 Karl Denninger 19:45
Re: SQL Query Performance - what gives? Kevin Grittner 20:23
Re: SQL Query Performance - what gives? 📎 Karl Denninger 20:58
Updating one table with data from another drew 21:02
Re: SQL Query Performance - what gives? Kevin Grittner 21:59
Re: SQL Query Performance - what gives? 📎 Karl Denninger 23:03
Re: FW: simple? query Tim Landscheidt 23:39

Aug. 19, 2009

Thread Author Time
Re: Multiple simultaneous queries on single connection Craig Ringer 01:35
Re: [SQL] SQL Query Performance - what gives? Tom Lane 02:02
Re: [SQL] SQL Query Performance - what gives? 📎 Karl Denninger 02:47
Re: [SQL] SQL Query Performance - what gives? Pierre Frédéric Caillaud 06:27
Ask To Optimize Looping Otniel Michael 09:22
Ask About SQL Otniel Michael 10:17
Re: SQL Query Performance - what gives? Ivan Voras 10:19
Re: Ask About SQL A. Kretschmer 10:46
Re: Ask About SQL Joshua Tolley 14:00
Re: Multiple simultaneous queries on single connection Yeb Havinga 15:15
Re: Ask To Optimize Looping Marc Mamin 15:46
Call Procedure From Trigger Function Doug Pisarek 21:53

Aug. 20, 2009

Thread Author Time
Re: Call Procedure From Trigger Function Scott Marlowe 04:01
Re: Call Procedure From Trigger Function ramasubramanian 04:29
Re: Updating one table with data from another Jasen Betts 10:51
Advice returning data as an array George Woodring 12:07
using case to select 'which version to use' Gerardo Herzig 15:17
Re: using case to select 'which version to use' Rodrigo E. De León Plicet 16:33
Rewrite without correlated subqueries bricklen 20:32
Re: Rewrite without correlated subqueries 📎 Mark Fenbers 20:40
Re: Rewrite without correlated subqueries bricklen 21:16
Re: Rewrite without correlated subqueries Scott Marlowe 21:59
Re: Rewrite without correlated subqueries bricklen 22:03

Aug. 21, 2009

Thread Author Time
Rewrite multiple joins... tripplowe 03:17
Re: Rewrite multiple joins... Rob Sargent 15:15
Re: using case to select 'which version to use' Gerardo Herzig 18:13
multiple substitution in a single replace call? Gerardo Herzig 20:16

Aug. 22, 2009

Thread Author Time
Re: multiple substitution in a single replace call? Jasen Betts 11:45

Aug. 24, 2009

Thread Author Time
Question about encoding Denis BUCHER 16:42
Re: Question about encoding Peter Eisentraut 22:42

Aug. 25, 2009

Thread Author Time
Re: Question about encoding Denis BUCHER 20:16

Aug. 26, 2009

Thread Author Time
Selecting values from comma separated string Nacef LABIDI 13:19
Re: Selecting values from comma separated string A. Kretschmer 13:30
Re: Selecting values from comma separated string Pavel Stehule 13:32
Re: Selecting values from comma separated string Pavel Stehule 13:33
Re: Selecting values from comma separated string Tom Lane 14:05
Re: Selecting values from comma separated string Nacef LABIDI 14:13
Re: Selecting values from comma separated string Pavel Stehule 14:58
Re: Advice returning data as an array Erik Jones 18:20

Aug. 27, 2009

Thread Author Time
Howto automatically define collumn names for a function result. Andreas 11:08
Re: Howto automatically define collumn names for a function result. Jorge Godoy 11:25
WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable rawi 11:59
resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable rawi 14:16
Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable Tom Lane 15:18
Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable Rob Sargent 15:27
Data audit trail techniques in postgresql Nathaniel Smith 16:28
Re: Data audit trail techniques in postgresql Alvaro Herrera 17:36
Re: [SQL] Data audit trail techniques in postgresql Rob Sargent 18:31
Re: [SQL] Data audit trail techniques in postgresql Alvaro Herrera 19:32
Re: [SQL] Data audit trail techniques in postgresql Rob Sargent 20:30

Aug. 28, 2009

Thread Author Time
hopeless, SQL not resolved yet rawi 13:52
Re: Data audit trail techniques in postgresql Nathaniel Smith 14:39
recursively isolate pedigrees, based only on person_id, mother_id and father_id rawi 15:10
Re: recursively isolate pedigrees, based only on person_id, mother_id and father_id Rob Sargent 16:19

Aug. 29, 2009

Thread Author Time
NEED HELP COPY TO DYNAMIC OUTPUT FILE Yogi Rizkiadi 22:02

Aug. 30, 2009

Thread Author Time
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE Pavel Stehule 06:51
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE Tom Lane 15:53
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE Pavel Stehule 15:56
Searching for byte values within a bytea field db1981 19:15

Aug. 31, 2009

Thread Author Time
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE Yogi Dwianandono Rizkiadi 05:47

Browse Archives

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