pgsql-general - June 2012

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

June 1, 2012

Thread Author Time
Re: Trouble with plan statistics for behaviour for query. Craig James 00:08
Re: Procedural Languages Joshua Tolley 01:30
Re: Procedural Languages Chris Travers 03:29
Re: Procedural Languages Chris Travers 03:52
Re: PostgreSQL 9.0.4 crashing R, Abhilash (HP Software) 04:30
libpq Windows 7 64 Bret Stern 05:20
Re: Libpq question Mark Morgan Lloyd 08:41
Re: Trouble with plan statistics for behaviour for query. Vitalii Tymchyshyn 09:06
Re: Procedural Languages John Townsend 10:24
Re: Procedural Languages Chris Travers 12:50
Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index Bryan Murphy 13:07
Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index Bryan Murphy 13:45
Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index Tom Lane 13:52
Re: PostgreSQL 9.0.4 crashing Scott Marlowe 14:52
Re: Disable Streaming Replication without restarting either master or slave Samba 15:16
Question: How do you manage version control? Bryan Montgomery 15:28
Re: Trouble with plan statistics for behaviour for query. Maciek Sakrejda 15:38
TYPE TABLE OF NUMBER utsav 15:48
Re: Question: How do you manage version control? Chris Angelico 15:48
Re: Question: How do you manage version control? Thomas Kellerer 15:51
Re: Question: How do you manage version control? Ralf Schuchardt 16:23
Re: autovacuum running for a long time on a new table with 1 row Tom Lane 17:34
Re: autovacuum running for a long time on a new table with 1 row Lonni J Friedman 17:44
Re: autovacuum running for a long time on a new table with 1 row Tom Lane 17:54
Re: autovacuum running for a long time on a new table with 1 row Lonni J Friedman 18:10
Re: autovacuum running for a long time on a new table with 1 row Tom Lane 18:55

June 2, 2012

Thread Author Time
Re: Disable Streaming Replication without restarting either master or slave Jasen Betts 06:48
Re: timestamps, formatting, and internals Jasen Betts 06:57
Re: timestamps, formatting, and internals Jasen Betts 07:06
Re: Updateable Views or Synonyms. Jasen Betts 07:14
Re: select current_setting('transaction_isolation') Samba 08:49
Array fundamentals idc danny 17:05
Re: [PERFORM] Array fundamentals Jeff Davis 17:21
SELECT issue with references to different tables Alexander Reichstadt 18:50
Re: SELECT issue with references to different tables Chris Angelico 19:22
Re: SELECT issue with references to different tables David Johnston 19:27
Re: [GENERAL] pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index 📎 Bruce Momjian 20:41
Re: Re: [GENERAL] pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index Tom Lane 21:10

June 3, 2012

Thread Author Time
Re: timestamps, formatting, and internals Mark Morgan Lloyd 07:43
Re: SELECT issue with references to different tables Misa Simic 10:00
Re: Updateable Views or Synonyms. Tim Uckun 11:57
evaluating subselect for each row Scott Ribe 17:55
Re: evaluating subselect for each row Ben Chobot 20:15
RLS & SEpgsql Matthias 20:42
Re: SELECT issue with references to different tables Alexander Reichstadt 21:23
[postgres no lnger launches Alexander Reichstadt 22:39
Re: [postgres no lnger launches Alexander Reichstadt 23:03
Re: [postgres no lnger launches Tom Lane 23:16
[Solved] Re: [postgres no lnger launches Alexander Reichstadt 23:35
Re: [postgres no lnger launches Alexander Reichstadt 23:50

June 4, 2012

Thread Author Time
Re: TYPE TABLE OF NUMBER Raghavendra 04:41
Re: TYPE TABLE OF NUMBER utsav 05:00
Re: PostgreSQL 9.0.4 crashing R, Abhilash (HP Software) 05:10
Re: Question: How do you manage version control? Robert Gravsjö 06:54
Re: Question: How do you manage version control? Brendaz 09:06
Re: Question: How do you manage version control? Chris Travers 09:19
Re: TYPE TABLE OF NUMBER Thomas Kellerer 13:05
How to avoid base backup in automated failover chinnaobi 13:14
Re: Re: [GENERAL] pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index 📎 Bruce Momjian 14:16
Building PostgreSQL 9.1.4 on Solaris 64-bit with gcc 4.6 Chander Ganesan 17:06
Re: Building PostgreSQL 9.1.4 on Solaris 64-bit with gcc 4.6 Tom Lane 18:13

June 5, 2012

Thread Author Time
Return equal number of rows with same column value Nick 00:27
Re: Return equal number of rows with same column value Nick 01:06
Re: Trouble with plan statistics for behaviour for query. Trevor Campbell 01:25
Re: Trouble with plan statistics for behaviour for query. Trevor Campbell 03:49
Re: Return equal number of rows with same column value David Johnston 05:05
Re: Procedural Languages Thomas Markus 08:13
PostgreSQL 8.4 download for RHEL6 saimounika.jagu 08:44
Companies using a shared storage failover Ludger Overbeck 09:30
Re: PostgreSQL 8.4 download for RHEL6 Birta Levente 09:55
Re: PostgreSQL 8.4 download for RHEL6 Devrim GÜNDÜZ 09:55
Re: PostgreSQL 8.4 download for RHEL6 Magnus Hagander 09:56
Re: TYPE TABLE OF NUMBER utsav 10:14
Manage PostgreSQL Remotely: Backup/Restore Dumps Easily Marina Sprava 13:30
Postgresql support for windows 8 and Windows 2012 server Divyaprakash Y 13:38
Criteria to "degrade" synchronous replication? David Pirotte 16:13
Postgres crash during Stored procedure execution Jayashankar K B 16:16
Re: Postgres crash during Stored procedure execution Pavel Stehule 17:15
Re: Postgresql support for windows 8 and Windows 2012 server John R Pierce 17:57
Re: TYPE TABLE OF NUMBER Igor Neyman 18:52
db alias Gauthier, Dave 18:59
Re: db alias Guillaume Lelarge 19:04
problem after upgrade db missing Aleksander Rozman 21:51
I'd like to learn a bit more about how indexes work Mike Christensen 22:24
Re: I'd like to learn a bit more about how indexes work Dann Corbit 22:36
Populate Table From Two Other Tables Rich Shepard 22:50
Re: Populate Table From Two Other Tables Greg Williamson 23:02
acessibility for tables Kraus Philipp 23:15
Re: Populate Table From Two Other Tables Rich Shepard 23:28
Re: I'd like to learn a bit more about how indexes work Mike Christensen 23:28
Re: Populate Table From Two Other Tables David Johnston 23:40
Re: Populate Table From Two Other Tables Rich Shepard 23:49

June 6, 2012

Thread Author Time
Re: I'd like to learn a bit more about how indexes work Dann Corbit 00:21
Re: Populate Table From Two Other Tables Adrian Klaver 02:15
Re: I'd like to learn a bit more about how indexes work Chris Curvey 02:20
Re: problem after upgrade db missing Adrian Klaver 02:35
Re: Postgresql support for windows 8 and Windows 2012 server Divyaprakash Y 04:59
Partitioning Advice Ben Carbery 05:07
Re: Populate Table From Two Other Tables Darren Duncan 05:19
Re: I'd like to learn a bit more about how indexes work Mike Christensen 05:50
Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup Manoj Govindassamy 06:54
Re: Partitioning Advice Albe Laurenz 07:05
Re: db alias Albe Laurenz 07:14
Re: acessibility for tables Albe Laurenz 07:24
column definition for setof record functions (like dblink and crosstabs) Willy-Bas Loos 11:03
postgres function for the query tree based normalization? Marc Mamin 11:11
Re: acessibility for tables Willy-Bas Loos 11:12
Re: acessibility for tables Kraus Philipp 11:26
Problem while restoring a database from SQL_ASCII to UTF-8 Manoj Agarwal 11:30
Re: acessibility for tables Albe Laurenz 11:34
Re: acessibility for tables Willy-Bas Loos 11:57
Re: column definition for setof record functions (like dblink and crosstabs) Pavel Stehule 12:02
Re: acessibility for tables Philipp Kraus 12:09
Re: Problem while restoring a database from SQL_ASCII to UTF-8 Adrian Klaver 13:12
Re: Problem while restoring a database from SQL_ASCII to UTF-8 Peter Geoghegan 13:37
Re: I'd like to learn a bit more about how indexes work Tom Lane 14:05
pg_database_size differs from df -s Frank Lanitz 14:33
Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup Manoj Govindassamy 14:55
Re: problem after upgrade db missing Alban Hertroys 15:01
Re: pg_database_size differs from df -s Tom Lane 15:49
Re: Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup Gabriele Bartolini 15:51
Re: pg_database_size differs from df -s Frank Lanitz 15:58
Re: Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup Manoj Govindassamy 16:16
Need help in transferring FP to Int64 DateTime Benson Jin 16:20
Re: pg_database_size differs from df -s Tom Lane 16:28
Re: pg_basebackup blocking all queries Lonni J Friedman 16:42
Re: pg_database_size differs from df -s Julien Rouhaud 16:46
Renumber table rows Efraín Déctor 18:27
Re: pg_database_size differs from df -s Alban Hertroys 18:31
Re: pg_database_size differs from df -s Guillaume Lelarge 19:22
Query runtime dependent on ANALYZE run Viktor Rosenfeld 19:40
Re: pg_database_size differs from df -s Frank Lanitz 19:45
Re: Renumber table rows David Johnston 20:17
How to get user privs on a table using select Gauthier, Dave 20:41
Re: Renumber table rows Efraín Déctor 21:25
Re: How to get user privs on a table using select Josh Kupershmidt 21:30
Re: acessibility for tables Philipp Kraus 23:59

June 7, 2012

Thread Author Time
Re: Need help in transferring FP to Int64 DateTime Josh Kupershmidt 00:01
Re: Need help in transferring FP to Int64 DateTime Benson Jin 00:35
Re: Need help in transferring FP to Int64 DateTime Adrian Klaver 02:02
Counting # of consecutive rows with specified value(s)? Ken Tanzer 02:20
Re: Problem while restoring a database from SQL_ASCII to UTF-8 Manoj Agarwal 03:30
Re: Counting # of consecutive rows with specified value(s)? David Johnston 04:26
Re: Procedural Languages Craig Ringer 08:29
Re: acessibility for tables Willy-Bas Loos 08:55
Re: Partitioning Advice Ben Carbery 09:02
Missing row after update Dinsdale 13:57
Postgres 9.2 beta2 one-click installer on windows Marc Watson 14:00
Question about load balance Condor 14:26
Two databases on the same server, looking for idea how to restrict access. Condor 14:39
Re: Need help in transferring FP to Int64 DateTime Benson Jin 15:29
Memory Overcommit Andy Chambers 15:33
Re: Memory Overcommit Tom Lane 16:14
Re: Two databases on the same server, looking for idea how to restrict access. Raymond O'Donnell 17:07
Re: Missing row after update Adrian Klaver 17:44
Re: Missing row after update Steve Crawford 17:47
Re: Missing row after update Dinsdale 18:23
Re: Partitioning Advice Greg Smith 18:40
Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?! hubert depesz lubaczewski 19:16
Re: Counting # of consecutive rows with specified value(s)? François Beausoleil 19:35
Re: Missing row after update Adrian Klaver 19:48
Re: pg_database_size differs from df -s Vincent Veyron 20:02
Re: Problem while restoring a database from SQL_ASCII to UTF-8 Adrian Klaver 20:07
Re: Need help in transferring FP to Int64 DateTime Adrian Klaver 20:14
Re: acessibility for tables Philipp Kraus 20:20
Re: Problem while restoring a database from SQL_ASCII to UTF-8 Adrian Klaver 20:48
Re: Missing row after update Dinsdale 21:45

June 8, 2012

Thread Author Time
Re: Procedural Languages Zenaan Harkness 00:40
Re: Procedural Languages Zenaan Harkness 01:08
Re: Two databases on the same server, looking for idea how to restrict access. Darren Duncan 04:03
Re: Postgres 9.2 beta2 one-click installer on windows Craig Ringer 05:34
Re: Question about load balance Craig Ringer 05:39
Re: Procedural Languages Craig Ringer 06:08
Re: Problem while restoring a database from SQL_ASCII to UTF-8 Manoj Agarwal 09:30
Re: Postgres 9.2 beta2 one-click installer on windows Marc Watson 12:04
Re: Postgres 9.2 beta2 one-click installer on windows Craig Ringer 13:20
Re: Postgres 9.2 beta2 one-click installer on windows Marc Watson 15:55
Re: Question about load balance René Romero Benavides 16:04
Extension table data Keith Fiske 16:11
Re: Two databases on the same server, looking for idea how to restrict access. René Romero Benavides 16:55
describe command for Little, Douglas 19:31
Re: describe command for René Romero Benavides 19:44
Re: describe command for Bartosz Dmytrak 19:50
Re: describe command for René Romero Benavides 19:59
New crosslinks in docs Adrian Klaver 20:06
Extending SQL C-language multidimension arrays Chris Schnaufer 21:17
ctid ranges Thomas Munro 21:27

June 9, 2012

Thread Author Time
Re: Extension table data Tom Lane 03:38
Re: Extension table data Keith Fiske 06:56
Need help to debug a code gautam kumar 06:59
Re: Extension table data Keith Fiske 07:15
Re: Postgres 9.2 beta2 one-click installer on windows Craig Ringer 07:50
Re: Extension table data Yeb Havinga 08:54
Re: Extension table data Tom Lane 12:33
pass NEW / OLD variable in trigger to table Philipp Kraus 12:49
Re: Extension table data Chris Travers 13:56
Re: pass NEW / OLD variable in trigger to table Adrian Klaver 14:30
Re: Extending SQL C-language multidimension arrays Tom Lane 15:18
Run external SQL file via Perl dbh David Williams 22:29
is there a select for update insert if not exist type command? Evan Rempel 22:41

Browse Archives

Prev | Next