pgsql-general since 2012-08-23 00:00

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)

Browse Archives

Prev | Next

Aug. 23, 2012

Thread Author Time
What text format is this and can I import it into Postgres? Mike Christensen 00:23
Re: Performance implications of numeric? Craig Ringer 00:28
Re: What text format is this and can I import it into Postgres? Edson Richter 00:33
Re: What text format is this and can I import it into Postgres? Rob Sargent 00:33
Re: What text format is this and can I import it into Postgres? Bosco Rama 00:34
Re: What text format is this and can I import it into Postgres? Rob Sargent 00:35
Re: What text format is this and can I import it into Postgres? Mike Christensen 00:38
Re: What text format is this and can I import it into Postgres? David Johnston 00:40
Re: What text format is this and can I import it into Postgres? Mike Christensen 00:41
Re: Alternatives to very large tables with many performance-killing indicies? Jeff Janes 00:56
Re: What text format is this and can I import it into Postgres? John R Pierce 00:57
Re: What text format is this and can I import it into Postgres? John R Pierce 00:58
Re: What text format is this and can I import it into Postgres? Bosco Rama 00:58
Re: NULL value comparison Craig Ringer 01:13
Re: NULL value comparison Craig Ringer 01:17
no null checking/check constraint checking in nested tables: Bug, missing feature, or desired behavior? Chris Travers 01:42
Re: Can column name aliases be supported? Craig Ringer 02:04
Re: What text format is this and can I import it into Postgres? Mike Christensen 02:17
Re: NULL value comparison Michael Sacket 02:32
Re: NULL value comparison Craig Ringer 02:38
Re: What text format is this and can I import it into Postgres? Adrian Klaver 02:44
Re: What text format is this and can I import it into Postgres? John R Pierce 03:01
Re: Alternatives to very large tables with many performance-killing indicies? Scott Marlowe 03:16
Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) Chris Travers 03:22
Re: Can column name aliases be supported? Chris Angelico 03:56
Re: What text format is this and can I import it into Postgres? Mike Christensen 04:13
Re: Can column name aliases be supported? Craig Ringer 04:19
Re: Can column name aliases be supported? Chris Angelico 05:23
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) David Johnston 05:36
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) Thomas Kellerer 06:15
Re: What text format is this and can I import it into Postgres? Thomas Kellerer 06:22
Re: At what point does a big table start becoming too big? Gavin Flower 07:04
Re: Alternatives to very large tables with many performance-killing indicies? Martijn van Oosterhout 07:09
Re: At what point does a big table start becoming too big? 📎 Martin French 07:22
Result from Having count Condor 07:52
Re: Result from Having count Frank Lanitz 08:11
Re: Result from Having count Condor 08:45
Re: Result from Having count Frank Lanitz 08:54
Re: At what point does a big table start becoming too big? Chris Travers 09:13
Rules, Windows and ORDER BY Jason Dusek 11:37
Re: Amazon High I/O instances Vincent Veyron 11:39
Re: At what point does a big table start becoming too big? Jasen Betts 11:55
Re: Amazon High I/O instances Anthony 12:00
Re: Can column name aliases be supported? Gauthier, Dave 13:32
Re: At what point does a big table start becoming too big? Bill Moran 13:37
Re: Amazon High I/O instances Sébastien Lorion 13:45
Re: At what point does a big table start becoming too big? Merlin Moncure 13:46
Re: Amazon High I/O instances Craig Ringer 13:49
Re: Check PostgreSQL status using MS-DOS bat file? Loughrey, Hugh 13:50
Re: Rules, Windows and ORDER BY Tom Lane 13:51
Re: At what point does a big table start becoming too big? 📎 Martin French 13:51
Re: Can column name aliases be supported? Craig Ringer 13:52
Re: At what point does a big table start becoming too big? Chris Travers 14:09
Re: At what point does a big table start becoming too big? Tom Lane 14:18
Re: Can column name aliases be supported? Gauthier, Dave 14:19
Cannot Run EnterpriseDB Postgresql Installation javad M 14:31
Re: NULL value comparison Michael Sacket 14:49
Re: Performance implications of numeric? Merlin Moncure 15:17
Re: Amazon High I/O instances Merlin Moncure 15:37
Re: Cannot Run EnterpriseDB Postgresql Installation Sachin Srivastava 15:40
Re: Amazon High I/O instances John R Pierce 15:51
Should I drop / create extensions after upgraging? François Beausoleil 16:19
Re: Should I drop / create extensions after upgraging? Tomas Vondra 17:03
Re: Should I drop / create extensions after upgraging? Tom Lane 17:36
Re: Cannot Run EnterpriseDB Postgresql Installation javad M 18:10
Confirming \timing output Gauthier, Dave 18:13
Re: Amazon High I/O instances Sébastien Lorion 18:24
Re: Confirming \timing output Steven Schlansker 18:27
Re: Confirming \timing output John R Pierce 18:30
Re: Amazon High I/O instances John R Pierce 18:41
Windows SIngle Sign On - LINUX Server Jeremy Palmer 19:12
Re: How hard would a "path" operator be to implement in PostgreSQL Merlin Moncure 19:20
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) Merlin Moncure 19:36
Re: Problems with timestamp with time zone and old dates? Michael Clark 19:41
Re: Problems with timestamp with time zone and old dates? Michael Clark 19:42
need substring based on delimiter Gauthier, Dave 21:30
Re: Statistical aggregates with intervals Christopher Swingley 21:39
Re: need substring based on delimiter Joe Conway 21:58
Re: Statistical aggregates with intervals Ondrej Ivanič 22:43

Aug. 24, 2012

Thread Author Time
Re: At what point does a big table start becoming too big? Jeff Janes 00:16
Re: At what point does a big table start becoming too big? Jeff Janes 00:56
FETCH in subqueries or CTEs Craig Ringer 01:35
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) Chris Travers 01:44
Re: FETCH in subqueries or CTEs Jeff Davis 02:00
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) Chris Travers 02:04
Re: Can column name aliases be supported? Craig Ringer 02:12
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) Ondrej Ivanič 02:17
Postgresql 9.1 on VMWare ESXi 5.0 Edson Richter 02:18
Re: At what point does a big table start becoming too big? Bill Moran 02:22
Re: Confirming \timing output Craig Ringer 02:31
Re: Confirming \timing output John R Pierce 02:48
Re: At what point does a big table start becoming too big? Ondrej Ivanič 02:48
Re: Postgresql 9.1 on VMWare ESXi 5.0 Craig Ringer 03:14
Re: Amazon High I/O instances Sébastien Lorion 04:22
Re: FETCH in subqueries or CTEs Pavel Stehule 04:34
Re: Rules, Windows and ORDER BY Jason Dusek 09:32
Re: Windows SIngle Sign On - LINUX Server SUNDAY A. OLUTAYO 10:10
Re: Rules, Windows and ORDER BY Martijn van Oosterhout 10:50
Re: FETCH in subqueries or CTEs Craig Ringer 10:54
I: Installation faillure version 8.4.12 Segato Luca 11:17
Re: I: Installation faillure version 8.4.12 Ashesh Vashi 11:20
Re: Interval "1 month" is equals to interval "30 days" - WHY? Dmitry Koterov 11:45
Re: Windows SIngle Sign On - LINUX Server Craig Ringer 11:48
Re: Windows SIngle Sign On - LINUX Server SUNDAY A. OLUTAYO 12:00
create table like . . . constraint names Sahagian, David 13:27
Re: FETCH in subqueries or CTEs Pavel Stehule 13:46
Re: FETCH in subqueries or CTEs Tom Lane 14:31
Re: Rules, Windows and ORDER BY Tom Lane 14:52
run function on server restart John D. West 16:45
Overlapping time ranges constraints in 8.4 EXT-Rothermel, Peter M 17:59
Re: Overlapping time ranges constraints in 8.4 Kevin Grittner 20:23
Re: Windows SIngle Sign On - LINUX Server Jeremy Palmer 20:29
Re: run function on server restart Kevin Grittner 20:29
Does continue in a loop not commit any changes Rhys A.D. Stewart 20:44
Re: Cannot Run EnterpriseDB Postgresql Installation javad M 21:24
Re: run function on server restart John D. West 21:46
fast-archiver tool, useful for pgsql DB backups Mathieu Fenniak 21:48
Re: run function on server restart Rob Sargent 21:52
Re: run function on server restart Kevin Grittner 21:56
Re: run function on server restart John D. West 22:25

Aug. 25, 2012

Thread Author Time
Re: run function on server restart Chris Angelico 06:40
Re: FETCH in subqueries or CTEs Craig Ringer 08:41
Permission denied for relation pg_database , one role has problem Jukka Inkeri 09:06
Re: Windows SIngle Sign On - LINUX Server Craig Ringer 09:15
Permission denied for relation pg_database , one role has problem Jukka Inkeri 09:19
Re: Windows SIngle Sign On - LINUX Server Chris Travers 09:34
Re: Postgresql 9.1 on VMWare ESXi 5.0 Edson Richter 12:56
Re: Permission denied for relation pg_database , one role has problem Tom Lane 16:01

Aug. 26, 2012

Thread Author Time
Re: create table like . . . constraint names Vincent Veyron 04:11
Re: postmaster.pid file auto-clean up? Michael Clark 04:56
Re: postmaster.pid file auto-clean up? John R Pierce 05:09
9.2 and index only scans Thomas Kellerer 09:04
Question about granting permissions Matvey Teplov 11:10
Re: Question about granting permissions Dmitriy Igrishin 11:34
Re: Question about granting permissions Guillaume Lelarge 11:37
Re: postmaster.pid file auto-clean up? Tom Lane 14:25
Re: 9.2 and index only scans Tom Lane 14:31
Re: Question about granting permissions Matvey Teplov 14:37
Re: 9.2 and index only scans Thomas Kellerer 15:02
Re: run function on server restart John D. West 15:19
Re: postmaster.pid file auto-clean up? Michael Clark 15:21
Re: postmaster.pid file auto-clean up? Alban Hertroys 17:25
Re: postmaster.pid file auto-clean up? Michael Clark 17:51
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) Wolfgang Keller 17:57
Renaming tables and their indexes simultaneously Moshe Jacobson 18:26
Re: 9.2 and index only scans Jeff Janes 18:45
Re: 9.2 and index only scans Tom Lane 19:34
Re: 9.2 and index only scans Pavel Stehule 19:42
Re: Renaming tables and their indexes simultaneously Tom Lane 19:48
Re: 9.2 and index only scans Tom Lane 19:52
Re: 9.2 and index only scans Thomas Kellerer 19:58
Re: 9.2 and index only scans Jeff Janes 20:26
Re: 9.2 and index only scans 📎 Thomas Kellerer 21:01
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) Chris Travers 22:33

Aug. 27, 2012

Thread Author Time
Looking for ODBC drivers for NT4. Mouse Dresden 01:44
PGBouncer Connection Using Perl DBI Prashant Bharucha 01:51
Re: PGBouncer Connection Using Perl DBI Craig Ringer 02:26
Re: 9.2 and index only scans Pavel Stehule 04:04
Odd query result Maximilian Tyrtania 08:55
Re: PGBouncer Connection Using Perl DBI Greg Williamson 09:27
Re: Odd query result Frank Lanitz 09:35
Re: Odd query result Sergey Konoplev 09:39
Re: Odd query result Maximilian Tyrtania 09:53
Re: Odd query result Maximilian Tyrtania 09:56
Re: Odd query result Sergey Konoplev 10:14
Re: Odd query result Georges Racinet 10:37
Re: Odd query result Sergey Konoplev 10:47
Re: Odd query result Georges Racinet 10:52
unexpected pageaddr in the log of a standby server Viacheslav N Tararin 12:17
Re: Odd query result Tom Lane 14:18
Re: unexpected pageaddr in the log of a standby server Adrian Klaver 14:20
Re: [GENERAL] Why extract( ... from timestamp ) is not immutable? Bruce Momjian 15:07
Re: Odd query result Maximilian Tyrtania 15:09
Re: Overlapping time ranges constraints in 8.4 EXT-Rothermel, Peter M 16:46
GRANT SELECT Stephen Crawford 17:09
Re: GRANT SELECT ElEucas 17:20
Re: GRANT SELECT Stephen Crawford 17:32
Re: GRANT SELECT Pavel Stehule 17:35
Re: [GENERAL] Why extract( ... from timestamp ) is not immutable? Tom Lane 20:23
Documentation of Implicit Function Call /w Composite Types David Johnston 20:46
Re: Documentation of Implicit Function Call /w Composite Types Merlin Moncure 21:59
Re: Documentation of Implicit Function Call /w Composite Types Tom Lane 23:28

Aug. 28, 2012

Thread Author Time
Re: 9.2 and index only scans Martijn van Oosterhout 08:02
Re: Looking for ODBC drivers for NT4. Mark Morgan Lloyd 09:07
Re: 9.2 and index only scans Thomas Kellerer 09:51
Postgres DBA in Berlin, Germany jobs 10:34
Is it nonsense (read: stupid) to keep count of child entries via triggers and a custom table? Seref Arikan 12:56
Re: Postgres DBA in Berlin, Germany Merlin Moncure 12:58
Re: 9.2 and index only scans Craig Ringer 13:04
Re: Is it nonsense (read: stupid) to keep count of child entries via triggers and a custom table? Craig Ringer 13:14
Re: Is it nonsense (read: stupid) to keep count of child entries via triggers and a custom table? Seref Arikan 13:18
FGS - Postgresql server install José Pedro Santos 13:31
Re: 9.2 and index only scans Thomas Kellerer 13:43
Re: FGS - Postgresql server install Craig Ringer 13:44
Re: Overlapping time ranges constraints in 8.4 Merlin Moncure 13:44
order of checking the unique constraints Sahagian, David 13:45
Re: 9.2 and index only scans Chris Travers 13:55
Re: order of checking the unique constraints Marc Mamin 14:00
Re: FGS - Postgresql server install José Pedro Santos 14:19
"Need some information about postgresql products and community" mithun 14:29

Browse Archives

Prev | Next