pgsql-general - July 2010

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

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 31

July 1, 2010

Thread Author Time
Re: Cannot open table in new database Adrian Klaver 00:04
Re: left outer join fails because "column .. does not exist in left table?" Tom Lane 00:05
Re: Cannot open table in new database Tom Lane 00:12
Re: left outer join fails because "column .. does not exist in left table?" Scott Marlowe 00:16
Re: loading many queries from a file Tim Landscheidt 00:49
Re: LINE 1: IDENTIFY_SYSTEM error infinitum Zoid 02:35
Re: LINE 1: IDENTIFY_SYSTEM error infinitum Fujii Masao 02:58
Re: LINE 1: IDENTIFY_SYSTEM error infinitum Tom Lane 04:02
Re: LINE 1: IDENTIFY_SYSTEM error infinitum Fujii Masao 05:13
Re: Problems building from source Magnus Hagander 05:23
Re: Problems building from source Tom Lane 05:34
Re: Problems building from source Bidski 05:48
Re: DBI::Oracle problems Craig Ringer 06:53
PostgreSQL triggers Sebastian Ritter 10:29
Re: Find users that have ALL categories David Fetter 11:26
Re: Find users that have ALL categories Sam Mason 11:37
Re: Find users that have ALL categories David Fetter 11:43
extracting total amount of time from an interval Andrew Geery 11:53
Re: extracting total amount of time from an interval Thom Brown 12:10
Re: extracting total amount of time from an interval A. Kretschmer 12:17
Re: PostgreSQL triggers Alban Hertroys 13:10
Re: PostgreSQL triggers Sebastian Ritter 13:57
Re: Prevent characters not transposable to LATIN9 Arnaud Lesauvage 14:10
problems with encoding and accent letters aaaawwww 14:43
Re: Prevent characters not transposable to LATIN9 Sam Mason 14:48
Re: Prevent characters not transposable to LATIN9 Arnaud Lesauvage 14:53
Process- or SessionID with ECPG Leif Jensen 15:05
Re: Prevent characters not transposable to LATIN9 Sam Mason 15:12
Re: Problems building from source Mark Cave-Ayland 15:54
Easy way to convert a database from WIN1252 to UTF8? Mike Christensen 16:08
Re: Can't EXTRACT number of months from an INTERVAL Eliot, Christopher 16:10
Re: Easy way to convert a database from WIN1252 to UTF8? Mike Christensen 16:31
Re: Easy way to convert a database from WIN1252 to UTF8? Mike Christensen 16:38
Re: Easy way to convert a database from WIN1252 to UTF8? Sam Mason 16:44
Cannot open table in new database Phil Jackson 16:46
Re: Easy way to convert a database from WIN1252 to UTF8? Mike Christensen 16:47
Re: Easy way to convert a database from WIN1252 to UTF8? Sam Mason 16:54
Re: Easy way to convert a database from WIN1252 to UTF8? Mike Christensen 17:01
Re: Easy way to convert a database from WIN1252 to UTF8? Sam Mason 17:07
Re: Easy way to convert a database from WIN1252 to UTF8? Mike Christensen 17:14
Re: Easy way to convert a database from WIN1252 to UTF8? 📎 Justin Graf 17:22
Uncable to commit: transaction marked for rollback David Kerr 18:06
Re: Uncable to commit: transaction marked for rollback David Kerr 18:08
Re: Uncable to commit: transaction marked for rollback Tom Lane 18:10
Re: Cannot open table in new database Phil Jackson 18:11
Re: Uncable to commit: transaction marked for rollback Thomas Markus 18:26
Re: Cannot open table in new database Phil Jackson 19:11
Re: problems with encoding and accent letters Peter Geoghegan 20:44
Re: problems with encoding and accent letters Peter Geoghegan 20:47
Re: problems with encoding and accent letters aaaawwww 21:27
Re: Is full-row updates slower than single-value updates Björn Lindqvist 22:19
Re: problems with encoding and accent letters John R Pierce 22:39
Re: Is full-row updates slower than single-value updates Tom Lane 23:01
change array dimension Gerhard Heift 23:32
Help with pgAndroid Contest Stephen Denne 23:39
different language indexes Dennis Gearon 23:44

July 2, 2010

Thread Author Time
Re: Prevent characters not transposable to LATIN9 Arnaud Lesauvage 06:10
Re: Uncable to commit: transaction marked for rollback Wappler, Robert 07:10
Query to "balance" rows across multiple tables Mike Christensen 09:24
bulk insert using COPY and PHP code Babu R 10:46
Re: bulk insert using COPY and PHP code Pavel Stehule 10:52
pgpool-II (max_pool and num_init_children) Geoffrey 11:36
Re: Query to "balance" rows across multiple tables Tim Landscheidt 11:56
Re: pgpool-II (max_pool and num_init_children) Tatsuo Ishii 12:03
Autovacuum and pg_largeobject Norberto Delle 12:10
C-Functions using SPI - Missing Magic Block 📎 Saitenheini 13:26
Re: Postgresql partitioning - single hot table or distributed Greg Smith 13:43
C-functions using SPI Missing Magic Block Error Saitenheini 13:45
Re: pgpool-II (max_pool and num_init_children) Geoffrey 13:46
Re: change array dimension Merlin Moncure 13:54
Re: Postgresql partitioning - single hot table or distributed Scott Marlowe 13:59
Re: pgpool-II (max_pool and num_init_children) Guillaume Lelarge 14:08
Re: C-functions using SPI Missing Magic Block Error Tom Lane 14:12
Re: Scheduling backup Chris Browne 15:05
Re: C-functions using SPI Missing Magic Block Error Saitenheini 15:13
Re: C-functions using SPI Missing Magic Block Error Joe Conway 15:19
Re: C-functions using SPI Missing Magic Block Error Saitenheini 15:36
Re: C-functions using SPI Missing Magic Block Error Joe Conway 15:46
Re: C-functions using SPI Missing Magic Block Error Saitenheini 15:52
ERROR: canceling statement due to statement timeout Tim 16:22
Re: Autovacuum and pg_largeobject Alvaro Herrera 16:57
Re: bulk insert using COPY and PHP code Babu R 17:28
Re: bulk insert using COPY and PHP code Pavel Stehule 17:42
Re: Autovacuum and pg_largeobject Norberto Delle 17:43
CFP for Surge Scalability Conference 2010 Jason Dixon 18:39
New DB-design - help and documentation pointers appreciated Rikard Bosnjakovic 18:43
Re: bulk insert using COPY and PHP code Scott Marlowe 19:33
Re: pgpool-II (max_pool and num_init_children) Geoffrey 20:15
Re: Help with pgAndroid Contest Josh Kupershmidt 22:22
Half-applied UPDATE rule on view A.M. 22:27
Re: Help with pgAndroid Contest Stephen Denne 23:09
Need Windows 2008 support and old installer kind Jose Torres 23:25
Re: Autovacuum and pg_largeobject Alvaro Herrera 23:30

July 3, 2010

Thread Author Time
Re: DBI::Oracle problems Howard Rogers 00:44
Re: C-Functions using SPI - Missing Magic Block Craig Ringer 01:35
Re: ERROR: canceling statement due to statement timeout Craig Ringer 01:41
Re: New DB-design - help and documentation pointers appreciated Craig Ringer 01:51
Re: Half-applied UPDATE rule on view Dean Rasheed 07:54
Re: C-Functions using SPI - Missing Magic Block Martijn van Oosterhout 08:43
Re: problems with encoding and accent letters aaaawwww 13:45
Re: Does psql -f quit insertion after an error in a statement has been detected? Bruce Momjian 16:30
Re: Requested addition to the todo list [was]: Re: Altering Domain Constraints on composite types Bruce Momjian 17:27
SQL statement logging: picking up strange queries from "pg_catalog" Graham Leggett 22:13
Re: SQL statement logging: picking up strange queries from "pg_catalog" Tom Lane 22:49
Re: SQL statement logging: picking up strange queries from "pg_catalog" Graham Leggett 23:22
Re: SQL statement logging: picking up strange queries from "pg_catalog" Tom Lane 23:24

July 4, 2010

Thread Author Time
How to know if an INSERT is done inside a function? Andre Lopes 10:01
Re: How to know if an INSERT is done inside a function? Pavel Stehule 10:05
Re: How to know if an INSERT is done inside a function? Andre Lopes 11:15
Re: How to know if an INSERT is done inside a function? Pavel Stehule 11:20
Re: How to know if an INSERT is done inside a function? Andre Lopes 11:25
Re: How to know if an INSERT is done inside a function? Merlin Moncure 13:41
Extending postgres objects with attributes Davor J. 13:43
Open Source Forum Software using PostgreSQL? Andre Lopes 14:10
Re: Open Source Forum Software using PostgreSQL? David Boreham 14:16
Re: Open Source Forum Software using PostgreSQL? CaT 14:22
Re: Open Source Forum Software using PostgreSQL? Roland Vögtli 14:54
Re: Open Source Forum Software using PostgreSQL? Dave Page 14:54
Re: Open Source Forum Software using PostgreSQL? Thom Brown 15:04
Re: How to know if an INSERT is done inside a function? Pavel Stehule 15:11
Re: Open Source Forum Software using PostgreSQL? Guillaume Lelarge 15:50
Re: Open Source Forum Software using PostgreSQL? Garry Saddington 15:50
Re: How to know if an INSERT is done inside a function? Andre Lopes 23:40

July 5, 2010

Thread Author Time
Re: How to know if an INSERT is done inside a function? Ricardo Ramírez 01:29
Re: Extending postgres objects with attributes Craig Ringer 01:29
Unable to run this query Srikanth Kata 07:16
Re: Unable to run this query Pavel Stehule 07:20
Re: C-Functions using SPI - Missing Magic Block Saitenheini 08:20
Out of memory on update of a single column table containg just one row. zeeshan.ghalib 10:11
Out of memory on update of a single column table containg just one row. Zeeshan.Ghalib 10:47
Re: C-Functions using SPI - Missing Magic Block Sam Mason 10:49
Re: Out of memory on update of a single column table containg just one row. Thom Brown 11:40
Re: Out of memory on update of a single column table containg just one row. Zeeshan.Ghalib 13:13
Windows Installation Problem Len Morgan 13:33
Re: Out of memory on update of a single column table containg just one row. Thomas Markus 13:39
Re: Out of memory on update of a single column table containg just one row. Zeeshan.Ghalib 13:52
Re: Out of memory on update of a single column table containg just one row. Sam Mason 14:14
Re: Out of memory on update of a single column table containg just one row. Zeeshan.Ghalib 14:44
how to remove a for-loop from programming language and put it into the query? Pedro Zorzenon Neto 14:48
Re: how to remove a for-loop from programming language and put it into the query? Thom Brown 15:11
Re: how to remove a for-loop from programming language and put it into the query? Sam Mason 15:22
Re: how to remove a for-loop from programming language and put it into the query? Pedro Zorzenon Neto 15:26
Re: how to remove a for-loop from programming language and put it into the query? Tim Landscheidt 15:30
Re: how to remove a for-loop from programming language and put it into the query? Thom Brown 15:32
Re: how to remove a for-loop from programming language and put it into the query? Pedro Zorzenon Neto 15:44
Re: Out of memory on update of a single column table containg just one row. Zeeshan.Ghalib 15:47
Re: how to remove a for-loop from programming language and put it into the query? Sam Mason 15:56
OFFTOPIC -- pgpool list is down????? Edmundo Robles L. 19:26
Re: OFFTOPIC -- pgpool list is down????? Devrim GÜNDÜZ 19:46
Manual for small project pasman pasmański 20:57
moderninzing/upgrading mail list format Dennis Gearon 21:43
Re: moderninzing/upgrading mail list format Sam Mason 23:40

July 6, 2010

Thread Author Time
cgi program doing multiple queries hangs in multiple places Alan Corey 04:59
Re: how to remove a for-loop from programming language and put it into the query? Sim Zacks 05:39
TupleDesc and HeapTuple Luca Ferrari 06:53
Re: moderninzing/upgrading mail list format Thomas Kellerer 06:55
SQL Query Help Please ! GrGsM 07:06
Transform_Null_Equals does not work in Functions Daniel Schuchardt 09:17
psql \dp equivalent or similar query? Davor J. 09:17
Re: psql \dp equivalent or similar query? A. Kretschmer 09:32
PostgreSQL trigger execution order Sebastian Ritter 09:33
Re: Extending postgres objects with attributes Davor J. 09:47
Re: psql \dp equivalent or similar query? Davor J. 09:52
Re: PostgreSQL trigger execution order Alban Hertroys 09:57
'default nextval()' loses schema-qualification in dump ? Arnaud Lesauvage 10:02
Re: PostgreSQL trigger execution order Sebastian Ritter 10:05
Rules in views, how to? Andre Lopes 10:28
Rules in views, how to? Andre Lopes 10:39
Re: Rules in views, how to? Alban Hertroys 10:54
Re: Rules in views, how to? Andre Lopes 11:03
Re: [SOLVED] Rules in views, how to? Andre Lopes 11:28
Re: moderninzing/upgrading mail list format Lew 11:39
Re: [SOLVED] Rules in views, how to? Sam Mason 11:46
Re: [SOLVED] Rules in views, how to? Andre Lopes 11:55
Re: [SOLVED] Rules in views, how to? Sam Mason 13:12
Re: Rules in views, how to? Alban Hertroys 14:09
Re: 'default nextval()' loses schema-qualification in dump ? Tom Lane 14:22
Feedback on live schema changes and updates for PostgreSQL ChronicDB Community Team 14:51
Re: 'default nextval()' loses schema-qualification in dump ? Arnaud Lesauvage 15:02
Re: PostgreSQL trigger execution order Sebastian Ritter 15:13
Re: 'default nextval()' loses schema-qualification in dump ? Tom Lane 15:17
Re: SQL Query Help Please ! Thomas Kellerer 15:32
Re: SQL Query Help Please ! Sam Mason 15:35
Re: ERROR: canceling statement due to statement timeout Vick Khera 15:36
Re: Transform_Null_Equals does not work in Functions Tom Lane 15:39
Re: moderninzing/upgrading mail list format John R Pierce 15:50
Re: moderninzing/upgrading mail list format Thom Brown 15:57
Re: SQL Query Help Please ! Guy Rouillier 16:59
make view with union return one record Andy Colson 19:43
Re: TupleDesc and HeapTuple Alvaro Herrera 19:58
OSCON booth staffing gabrielle 22:57

July 7, 2010

Thread Author Time
Re: Extending postgres objects with attributes Craig Ringer 01:45
Re: moderninzing/upgrading mail list format Merlin Moncure 02:51
Re: Commit every N rows in PL/pgsql Howard Rogers 05:01
Re: 'default nextval()' loses schema-qualification in dump ? Arnaud Lesauvage 06:47
Re: 'default nextval()' loses schema-qualification in dump ? Arnaud Lesauvage 07:39
Re: 'default nextval()' loses schema-qualification in dump ? Richard Huxton 07:41
Re: Re: [GENERAL] 'default nextval()' loses schema-qualification in dump ? Arnaud Lesauvage 07:51
Problems with Vista and Windows 7 el dorado 08:19
How to Get Column Names from the Table venkat 09:08

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 31