pgsql-general since 2012-03-24 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)

Advanced Search

Browse Archives

Prev | Next

March 24, 2012

Thread	Author	Time
Re: Change the default [tgenabled] for new "internal" triggers ?	Tom Lane	00:34
broken xlog - recovery plan check	Colin Taylor	00:45
pgcon 2012	Arvind Singh	04:46
Re: PostgreSQL 64 Bit XIDs - Transaction IDs	Bret Stern	05:18
Re: PostgreSQL 64 Bit XIDs - Transaction IDs	Scott Marlowe	07:27
Re: PostgreSQL 64 Bit XIDs - Transaction IDs	Scott Marlowe	07:33
group by does not show error	AI Rumman	08:06
Re: group by does not show error	Thomas Kellerer	08:44
Re: broken xlog - recovery plan check	Thom Brown	09:14
Re: plpgsql function to insert or update problem	Alban Hertroys	10:23
Re: pgcon 2012	Bruce Momjian	11:44
Re: plpgsql function to insert or update problem	Andy Colson	14:28
Howto Replication for dummies?	Andreas	22:52

March 25, 2012

Thread	Author	Time
Re: Table growing faster than autovacuum can vacuum	Jasen Betts	03:40
Re: Table growing faster than autovacuum can vacuum	Scott Marlowe	04:06
Re: Upgrade questions	Jasen Betts	04:39
can these queries be combined into one?	hamann.w	07:16
table alias for update	hamann.w	07:16
Re: table alias for update	Bosco Rama	07:32
Re: Help in Parsing PG log usings CSV format	Jasen Betts	07:33
Re: can these queries be combined into one?	Jasen Betts	08:04
Re: can these queries be combined into one?	Guillaume Lelarge	08:14
Re: can these queries be combined into one?	Guillaume Lelarge	08:50
Re: Is record handle available to a check constraint stored procedure call?	Jasen Betts	09:05
Re: Streaming replication and empty databases	François Beausoleil	13:13
Re: can these queries be combined into one?	David Johnston	14:53
Re: xlog corruption	Jameison Martin	18:13
Re: Howto Replication for dummies?	Sergey Konoplev	19:19
Re: pgcon 2012	Greg Smith	23:14

March 26, 2012

Thread	Author	Time
compilation info without pg_config	Maximilian Tyrtania	09:22
Values inside rolvaliduntil of pg_authid	Frank Lanitz	09:32
loading a function from a file	and	09:32
Re: compilation info without pg_config	John R Pierce	09:34
Re: compilation info without pg_config	Maximilian Tyrtania	10:01
PostgreSQL crashed server	Martín Marqués	11:41
Re: can these queries be combined into one?	Tom Molesworth	12:38
Re: compilation info without pg_config	Greg Sabino Mullane	13:05
Re: compilation info without pg_config	Adrian Klaver	13:09
Re: compilation info without pg_config	Devrim GÜNDÜZ	13:11
Re: compilation info without pg_config	Maximilian Tyrtania	14:13
Re: loading a function from a file	Merlin Moncure	14:22
Re: loading a function from a file	Andy Colson	14:23
Re: loading a function from a file	Adrian Klaver	14:27
"OLD used in query that is not in a rule"	Gauthier, Dave	14:42
Re: "OLD used in query that is not in a rule"	Tom Lane	14:51
Re: "OLD used in query that is not in a rule"	Gauthier, Dave	14:54
Re: Change the default [tgenabled] for new "internal" triggers ?	david.sahagian	14:55
Re: Change the default [tgenabled] for new "internal" triggers ?	Tom Lane	15:03
Re: can these queries be combined into one?	Rainer Pruy	15:16
Re: Quite a fast lockless vacuum full implemenation	Witt83	15:20
language name case sensitivity, also known as plpgsql <> 'PLpgSQL'	Gregg Jaskiewicz	15:30
Re: loading a function from a file	Alban Hertroys	15:31
Re: language name case sensitivity, also known as plpgsql <> 'PLpgSQL'	Thom Brown	15:41
Re: language name case sensitivity, also known as plpgsql <> 'PLpgSQL'	Gregg Jaskiewicz	15:47
Re: language name case sensitivity, also known as plpgsql <> 'PLpgSQL'	Tom Lane	17:27
pgstat wait timeout	Norberto Dellê	18:54
Desperately need a magical PG monitoring tool	Andreas	18:58
DBT-3 workload running error: tmp_query.sql is missing	Yangyang	20:32
Re: Desperately need a magical PG monitoring tool	Richard Huxton	20:52
Backing up through a database connection (not pg_dump)	Tim Uckun	23:05
Re: Backing up through a database connection (not pg_dump)	John R Pierce	23:16

March 27, 2012

Thread	Author	Time
Re: Backing up through a database connection (not pg_dump)	David Boreham	00:00
Re: Backing up through a database connection (not pg_dump)	Tim Uckun	00:12
Re: Backing up through a database connection (not pg_dump)	Stephen Frost	00:17
Re: Backing up through a database connection (not pg_dump)	Bret Stern	00:37
Re: Backing up through a database connection (not pg_dump)	Tim Uckun	00:45
postgresql commit.	leaf_yxj	01:22
Error trying to set up streaming replication	Nick	01:40
Re: postgresql commit.	Chris Travers	02:33
Re: postgresql commit.	Andrew Sullivan	04:34
Re: Backing up through a database connection (not pg_dump)	Eduardo Morras	08:15
Re: Backing up through a database connection (not pg_dump)	hubert depesz lubaczewski	08:39
Problem with installation	nissyre	08:46
Re: Problem with installation	Ashesh Vashi	08:54
Re: Problem with installation	John R Pierce	08:56
Re: Problem with installation	Thomas Kellerer	09:03
Facing error while restoring the database 📎	Akshay Joshi	09:33
PANIC: corrupted item pointer	Janning Vygen	09:47
Re: Facing error while restoring the database	Alban Hertroys	12:45
Re: Facing error while restoring the database	Akshay Joshi	13:12
How can I modify a row in a function such that the caller sees it?	Kenneth Tilton	13:26
Re: Facing error while restoring the database	Alban Hertroys	13:47
Re: Facing error while restoring the database	Albe Laurenz	13:48
Re: Facing error while restoring the database	Tom Lane	14:10
windows 7 não funciona Adeus Postgresql	vossistemas	14:33
Re: Facing error while restoring the database	Akshay Joshi	14:50
Re: Facing error while restoring the database	Alan Hodgson	15:06
configuring RAID10 for data in Amazon EC2 cloud?	Welty, Richard	15:25
Re: configuring RAID10 for data in Amazon EC2 cloud?	Ben Chobot	15:37
Re: configuring RAID10 for data in Amazon EC2 cloud?	Frank Lanitz	16:18
Multiple Slave Failover with PITR	Ken Brush	17:47
Valid query times out when run from bash script	W. David Jarvis	18:37
Re: Valid query times out when run from bash script	hb@101-factory.eu	19:55
Re: Valid query times out when run from bash script	Steve Crawford	20:20
Re: Valid query times out when run from bash script	W. David Jarvis	20:26
Re: Valid query times out when run from bash script	Raymond O'Donnell	20:59
Re: Valid query times out when run from bash script	W. David Jarvis	21:05

March 28, 2012

Thread	Author	Time
Re: postgresql commit.	leaf_yxj	00:48
create one function to let other user execute vacuum command. got such an error.	leaf_yxj	01:51
Re: create one function to let other user execute vacuum command. got such an error.	Guillaume Lelarge	06:44
Re: create one function to let other user execute vacuum command. got such an error.	Greg Jaskiewicz	06:50
How to tell if server is in backup mode?	Toby Corkindale	07:14
Re: Multiple Slave Failover with PITR	Albe Laurenz	07:35
user get notification when postgresql database updated	Albert	11:40
Re: user get notification when postgresql database updated	Tom Molesworth	12:14
Query regarding submission on To Do item for psql client "psql : Allow processing of multiple -f (file) options " 📎	Vikash3 S	12:57
oracle linux	Gregg Jaskiewicz	14:38
Re: oracle linux	Tomas Vondra	15:07
what's difference between vacuum analyze and analyze?	leaf_yxj	15:24
Re: what's difference between vacuum analyze and analyze?	Chris Angelico	15:29
Re: oracle linux	Tom Lane	15:30
Re: what's difference between vacuum analyze and analyze?	Adrian Klaver	15:37
Re: oracle linux	Thom Brown	15:44
Re: oracle linux	Tomas Vondra	16:01
how to pass the function caller's parameter to inside the function. syntax error at or near "$1"	leaf_yxj	16:18
how postgresql passes the parameter to the function. syntax error near or at "$1".	leaf_yxj	16:20
Re: how postgresql passes the parameter to the function. syntax error near or at "$1".	Pavel Stehule	16:25
Re: how to pass the function caller's parameter to inside the function. syntax error at or near "$1"	Merlin Moncure	16:36
Re: how postgresql passes the parameter to the function. syntax error near or at "$1".	leaf_yxj	16:38
Limit the normal user to see system catalog or not??? And create privilege???	leaf_yxj	16:54
How return a row from a function so it is recognized as such by caller?	Kenneth Tilton	16:54
system catalog privilege and create privilege ??? how to control them?? thanks	leaf_yxj	16:55
Re: How return a row from a function so it is recognized as such by caller?	Kenneth Tilton	17:52
Re: How return a row from a function so it is recognized as such by caller?	Kenneth Tilton	18:11
Re: Limit the normal user to see system catalog or not??? And create privilege???	Scott Marlowe	18:20
Re: How return a row from a function so it is recognized as such by caller?	Merlin Moncure	18:36
Re: How return a row from a function so it is recognized as such by caller?	Kenneth Tilton	19:08
Re: How return a row from a function so it is recognized as such by caller?	Merlin Moncure	19:40
Re: How return a row from a function so it is recognized as such by caller?	Kenneth Tilton	19:49
Re: How return a row from a function so it is recognized as such by caller?	Merlin Moncure	20:02
Re: How return a row from a function so it is recognized as such by caller?	Kenneth Tilton	20:25
Re: Limit the normal user to see system catalog or not??? And create privilege???	Adrian Klaver	20:54
could not read block... how could I identify/fix	Naoko Reeves	22:31
scripted 'pg_ctl start' hangs and never finishes, goes <defunct>	Brian Fehrle	22:31
Re: scripted 'pg_ctl start' hangs and never finishes, goes <defunct>	Brian Fehrle	23:33

March 29, 2012

Thread	Author	Time
PG Log	Arvind Singh	05:30
why is pg_dump so much smaller than my database?	Carson Gross	05:32
Re: why is pg_dump so much smaller than my database?	John R Pierce	07:11
Re: why is pg_dump so much smaller than my database?	Alban Hertroys	08:13
Re: system catalog privilege and create privilege ??? how to control them?? thanks	Albe Laurenz	08:16
Re: Query regarding submission on To Do item for psql client "psql : Allow processing of multiple -f (file) options "	Albe Laurenz	08:24
Re: How to tell if server is in backup mode?	Gabriele Bartolini	08:46
Re: PG Log	Albe Laurenz	08:49
Re: How to tell if server is in backup mode?	Gabriele Bartolini	08:50
Re: user get notification when postgresql database updated	Albert	09:43
Why checkpoint_timeout had maximum value of 1h?	Maxim Boguk	10:57
Re: could not read block... how could I identify/fix	Vick Khera	14:08
More PG Log	Arvind Singh	14:09
Re: could not read block... how could I identify/fix	Vick Khera	14:10
Re: More PG Log	Albe Laurenz	14:32
Re: why is pg_dump so much smaller than my database?	Carson Gross	16:41
Managing two sets of data in one database	Jonathan Bartlett	16:43
Re: Managing two sets of data in one database	John R Pierce	17:54
Re: Managing two sets of data in one database	Jonathan Bartlett	18:01
Re: Managing two sets of data in one database	Tom Molesworth	18:26
Move Tables From One Database to Another	Rich Shepard	19:10
Re: Move Tables From One Database to Another	Gabriele Bartolini	19:39
Re: PANIC: corrupted item pointer	Jeff Davis	19:39
Re: Move Tables From One Database to Another	Andy Colson	19:49
Re: Move Tables From One Database to Another	Rich Shepard	20:27
Re: Move Tables From One Database to Another	Rich Shepard	20:28
Re: Managing two sets of data in one database	Jonathan Bartlett	20:39
Re: Managing two sets of data in one database	Scott Marlowe	21:09
Re: Managing two sets of data in one database	Thomas Kellerer	21:16
Re: Managing two sets of data in one database	John R Pierce	21:22
default value returned from sql stmt	David Salisbury	22:16
Problem to change COLLATE	BrunoSteven	22:21
Re: default value returned from sql stmt	Chris Angelico	22:26
Re: default value returned from sql stmt	Pavel Stehule	22:28
Re: default value returned from sql stmt	David Salisbury	22:56
Re: How to tell if server is in backup mode?	Toby Corkindale	23:32

March 30, 2012

Thread	Author	Time
octet_length operator: what encoding?	Chris Angelico	00:37
Re: default value returned from sql stmt	Ken Tanzer	00:57
Re: Move Tables From One Database to Another	Bret Stern	01:22
Re: could not read block... how could I identify/fix	Naoko Reeves	01:47
Re: system catalog privilege and create privilege ??? how to control them?? thanks	leaf_yxj	01:53
Re: could not read block... how could I identify/fix	Scott Marlowe	02:45
double check the role has what's kind of the privilege? And the same for the objects. Thanks.	leaf_yxj	02:49
Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.	Chris Travers	02:53
Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.	leaf_yxj	03:19
Re: default value returned from sql stmt	Richard Huxton	07:42
Re: default value returned from sql stmt	Pavel Stehule	07:46
Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.	Albe Laurenz	08:05
Re: octet_length operator: what encoding?	Albe Laurenz	08:10
Re: default value returned from sql stmt	Richard Huxton	08:22
Re: user get notification when postgresql database updated	Albert	08:24
Re: default value returned from sql stmt	Pavel Stehule	08:34
Re: default value returned from sql stmt	Alban Hertroys	08:45
Re: user get notification when postgresql database updated	Alban Hertroys	08:51
Adding new and changed data	Hendrik Visage	12:13
Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.	leaf_yxj	13:41
Re: PANIC: corrupted item pointer	Janning Vygen	14:02
Surge 2012 CFP is Open!	Katherine Jeschke	14:04
Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.	Tom Lane	14:16
Re: PostgreSQL crashed server	Craig Ringer	14:19
Re: how to pass the function caller's parameter to inside the function. syntax error at or near "$1"	leaf_yxj	14:23
Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.	Albe Laurenz	14:26
Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.	leaf_yxj	14:28
pg_dump incredibly slow dumping a single schema from a large db	Mike Roest	15:51
Re: pg_dump incredibly slow dumping a single schema from a large db	Tom Lane	16:18

Browse Archives

Prev | Next