[go: up one dir, main page]

pgsql-general - May 2018

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

May 1, 2018

Thread Author Time
Re: [GENERAL] huge RAM use in multi-command ALTER of table heirarchy Amit Langote 09:33
Re: Locks analysis after-the-fact Merlin Moncure 13:53
Surprised by index choice for count(*) Rob Sargent 15:46
Re: Surprised by index choice for count(*) David G. Johnston 16:07
Re: Surprised by index choice for count(*) Tom Lane 16:11
Re: Surprised by index choice for count(*) Rob Sargent 16:13
extension dependencies with 'requires' Eric Hanson 17:34
Re: extension dependencies with 'requires' Tom Lane 18:00
Re: extension dependencies with 'requires' Eric Hanson 18:06

May 2, 2018

Thread Author Time
Index/trigger implementation for accessing latest records Alastair McKinley 09:51
Re: Index/trigger implementation for accessing latest records Gavin Flower 10:36
Re: Index/trigger implementation for accessing latest records Alvaro Herrera 20:32
CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN Jim Michaels 21:29
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN David G. Johnston 21:49
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN Ron 21:52
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN John McKown 22:04
Re: Index/trigger implementation for accessing latest records Tim Cross 22:14
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN Adrian Klaver 23:01
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN raf 23:15

May 3, 2018

Thread Author Time
Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb Craig Ringer 08:23
Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb Karsten Hilbert 08:46
Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb Craig Ringer 08:55
Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb Fabio Pardi 09:00
Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb Fabio Pardi 09:12
relkind='p' has no pg_stat_user_tables Justin Pryzby 14:14
Re: relkind='p' has no pg_stat_user_tables Adrian Klaver 14:44
Re: relkind='p' has no pg_stat_user_tables Justin Pryzby 15:45
Re: relkind='p' has no pg_stat_user_tables Adrian Klaver 16:18
Re: relkind='p' has no pg_stat_user_tables Alvaro Herrera 16:20
Re: relkind='p' has no pg_stat_user_tables Adrian Klaver 16:31
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN George Neuner 16:47
what's the error meaning? on mast/slavery replication . 林晓东 17:07
Re: relkind='p' has no pg_stat_user_tables Justin Pryzby 17:38
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN Adrian Klaver 18:02
Re: relkind='p' has no pg_stat_user_tables Adrian Klaver 18:15
Re: relkind='p' has no pg_stat_user_tables Justin Pryzby 18:24
Two things bit baffling in RDS PG Ravi Krishna 20:18
Re: Two things bit baffling in RDS PG David G. Johnston 21:05

May 4, 2018

Thread Author Time
Query planner riddle (array-related?) Markus 08:09
Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc) Adrian Heath 10:41
Re: Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc) Peter Eisentraut 11:07
How to find the hits on the databases and tables in Postgres nikhil raj 11:44
Re: Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc) Adrian Heath 11:45
Re: How to find the hits on the databases and tables in Postgres Adrian Klaver 13:21
Re: Query planner riddle (array-related?) Tom Lane 13:32
Re: relkind='p' has no pg_stat_user_tables Michael Paquier 14:13
Re: How to find the hits on the databases and tables in Postgres nikhil raj 16:45
statement_timeout issue Ian Harding 16:52
Re: statement_timeout issue Andres Freund 17:22
Re: statement_timeout issue Adrian Klaver 18:28
Re: How to find the hits on the databases and tables in Postgres Adrian Klaver 18:36
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN George Neuner 20:03
Re: How to find the hits on the databases and tables in Postgres Thomas Kellerer 20:22
Known Bugs on Postgres 9.5 Anudeep Gudipelli 21:38
Re: Known Bugs on Postgres 9.5 Tom Lane 22:53
[GENERAL] Full text search with plain input Havasvölgyi Ottó 23:54

May 5, 2018

Thread Author Time
Re: [GENERAL] Full text search with plain input David G. Johnston 00:06
Re: [GENERAL] Full text search with plain input Havasvölgyi Ottó 00:46
Re: [GENERAL] Full text search with plain input David G. Johnston 01:12
Re: [GENERAL] Full text search with plain input Havasvölgyi Ottó 01:57
Re: How to find the hits on the databases and tables in Postgres PT 11:03
Re: How to find the hits on the databases and tables in Postgres Pavel Stehule 12:13
comparison between 2 execution plans Neto pr 13:26
User defined functions in Postgresql, troubles with the c code Christof Priller 13:58
pg_dump with compressible and non-compressible tables Ron 14:14
Re: How to find the hits on the databases and tables in Postgres Melvin Davidson 14:47
ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification Alexander Farber 14:49
Re: comparison between 2 execution plans Neto pr 15:18
Re: statement_timeout issue Ian Harding 15:31
Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification Alexander Farber 16:08
Re: comparison between 2 execution plans Adrian Klaver 16:57
Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification Adrian Klaver 17:03
Re: pg_dump with compressible and non-compressible tables Adrian Klaver 17:13
Re: Known Bugs on Postgres 9.5 Vick Khera 17:39
Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification Alexander Farber 17:41
Re: comparison between 2 execution plans Neto pr 17:51
Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification Adrian Klaver 18:29
Re: comparison between 2 execution plans Adrian Klaver 19:05
Re: pg_dump with compressible and non-compressible tables Ron 19:41
Re: pg_dump with compressible and non-compressible tables Adrian Klaver 20:07
Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification Alexander Farber 21:39
Re: Known Bugs on Postgres 9.5 Anudeep Gudipelli 22:10
Re: Known Bugs on Postgres 9.5 Adrian Klaver 22:27
Re: Known Bugs on Postgres 9.5 Adrian Klaver 22:42
Known Bugs on Postgres 9.5 David G. Johnston 23:49

May 6, 2018

Thread Author Time
Re: what's the error meaning? on mast/slavery replication . Laurenz Albe 11:01
Re: Known Bugs on Postgres 9.5 Vick Khera 15:31
Re: User defined functions in Postgresql, troubles with the c code Adrian Klaver 20:54
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN Ken Tanzer 22:26
Re: pg_stat_statements : how to catch non successfully finished statements ? legrand legrand 22:46

May 7, 2018

Thread Author Time
Add schema to the query Igor Korot 02:19
Re: Add schema to the query Melvin Davidson 02:33
Re: Add schema to the query Melvin Davidson 02:37
psycopg2.DataError: invalid input syntax for integer: "" tango ward 03:37
Re: psycopg2.DataError: invalid input syntax for integer: "" David G. Johnston 03:47
Re: Add schema to the query Igor Korot 04:02
Re: Add schema to the query Rob Sargent 04:54
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN George Neuner 05:22
Re: psycopg2.DataError: invalid input syntax for integer: "" tango ward 06:05
Re: psycopg2.DataError: invalid input syntax for integer: "" David G. Johnston 06:39
Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN Ken Tanzer 06:42
Re: psycopg2.DataError: invalid input syntax for integer: "" tango ward 07:28
Is it possible to get username information while writing trigger? a 07:39
Re: Is it possible to get username information while writing trigger? Laurenz Albe 07:57
Re: Is it possible to get username information while writingtrigger? a 08:39
Re: Is it possible to get username information while writingtrigger? Laurenz Albe 08:59
Re: Query planner riddle (array-related?) Markus 09:12
Re: postgres on physical replica crashes SRINIVASARAO OGURI 10:31
Re: Add schema to the query Igor Korot 11:38
Re: psycopg2.DataError: invalid input syntax for integer: "" David G. Johnston 13:12
Re: psycopg2.DataError: invalid input syntax for integer: "" Adrian Klaver 13:35
Re: psycopg2.DataError: invalid input syntax for integer: "" David G. Johnston 13:40
Re: psycopg2.DataError: invalid input syntax for integer: "" Adrian Klaver 13:49
void function and view select Philipp Kraus 13:52
Re: Is it possible to get username information while writingtrigger? Adrian Klaver 13:59
Re: void function and view select David G. Johnston 14:06
Re: void function and view select Philipp Kraus 14:12
Re: Query planner riddle (array-related?) Tom Lane 14:17
Renice on Postgresql process Ayappan P2 14:46
Re: Renice on Postgresql process Ben Chobot 18:04
How to manipulate tuples in C functions? a 20:20
Run external command as part of an sql statement ? David Gauthier 21:35
Re: Run external command as part of an sql statement ? David G. Johnston 21:41
Re: Run external command as part of an sql statement ? Tom Lane 21:52
Re: How to manipulate tuples in C functions? Tom Lane 21:59
Re: Run external command as part of an sql statement ? Adrian Klaver 22:37
Re: psycopg2.DataError: invalid input syntax for integer: "" tango ward 23:44

May 8, 2018

Thread Author Time
KeyError: self._index[x] tango ward 03:07
Re: KeyError: self._index[x] tango ward 03:11
Re: KeyError: self._index[x] David G. Johnston 03:50
Re: KeyError: self._index[x] Adrian Klaver 04:06
Re: KeyError: self._index[x] Adrian Klaver 04:10
Re: KeyError: self._index[x] tango ward 04:40
Re: KeyError: self._index[x] tango ward 04:42
Re: KeyError: self._index[x] David G. Johnston 04:58
Re: KeyError: self._index[x] tango ward 05:00
Re: Renice on Postgresql process 📎 Ayappan P2 06:50
cursor empty Philipp Kraus 12:39
Re: cursor empty Adrian Klaver 13:36
Autovacuum holding exclusive lock on table Kumar, Virendra 13:38
Re: cursor empty David G. Johnston 14:18
Re: cursor empty Philipp Kraus 14:32
Error creating plpython3u extension Bruce Harold 20:28
Re: Error creating plpython3u extension Adrian Klaver 22:38
Re: Error creating plpython3u extension Jeff Peck 22:38

May 9, 2018

Thread Author Time
issues when installing postgres Antonio Silva 00:54
New install of 9.5.12 missing default PostgreSQL DB chandru.aroor@yahoo.com 01:12
Concatenate 2 Column Values For One Column tango ward 02:17
Re: Concatenate 2 Column Values For One Column David G. Johnston 02:44
Re: Concatenate 2 Column Values For One Column David G. Johnston 02:54
.ready files being created on secondaries Christophe Pettus 02:56
Re: Concatenate 2 Column Values For One Column tango ward 03:13
Re: Concatenate 2 Column Values For One Column Adrian Klaver 04:21
Re: Concatenate 2 Column Values For One Column tango ward 04:43
duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" while performing full vacuum on the database Raghavendra Rao J S V 07:31
Enhancement to psql command, feedback. John McKown 07:59
Re: Enhancement to psql command, feedback. Pavel Stehule 08:05
partition table query allocate much memory tao tony 10:53
Re: Enhancement to psql command, feedback. Matt Zagrabelny 12:37
Re: Enhancement to psql command, feedback. Ron 13:17
Re: New install of 9.5.12 missing default PostgreSQL DB Adrian Klaver 13:27
Re: Enhancement to psql command, feedback. John McKown 13:36
Re: issues when installing postgres Adrian Klaver 13:36
Re: Enhancement to psql command, feedback. John McKown 13:44
Re: Enhancement to psql command, feedback. Stephen Frost 13:52
Re: Enhancement to psql command, feedback. David G. Johnston 13:56
Re: Enhancement to psql command, feedback. John McKown 14:17
Re: Enhancement to psql command, feedback. John McKown 14:18
Re: Enhancement to psql command, feedback. David G. Johnston 14:25
Re: Enhancement to psql command, feedback. Tom Lane 14:30
Re: Enhancement to psql command, feedback. Christopher Browne 16:04
RE: Error creating plpython3u extension Bruce Harold 16:46
RE: Error creating plpython3u extension Bruce Harold 17:38
Re: Enhancement to psql command, feedback. David G. Johnston 17:41
Why is my Postgre server went in recovery mode all in sudden nikhil raj 18:31
Re: Enhancement to psql command, feedback. Jan Claeys 18:42
Re: duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" while performing full vacuum on the database Laurenz Albe 19:41
Re: issues when installing postgres Antonio Silva 21:47
Re: pg_stat_statements : how to catch non successfully finished statements ? legrand legrand 22:06
Re: Error creating plpython3u extension Adrian Klaver 23:20
Re: Why is my Postgre server went in recovery mode all in sudden Adrian Klaver 23:40
Re: issues when installing postgres Adrian Klaver 23:45
Re: New install of 9.5.12 missing default PostgreSQL DB Adrian Klaver 23:48

May 10, 2018

Thread Author Time
Re: issues when installing postgres Tim Cross 00:15
ON CONFLICT DO UPDATE tango ward 02:04
Re: New install of 9.5.12 missing default PostgreSQL DB Chandru Aroor 02:12
Re: New install of 9.5.12 missing default PostgreSQL DB Adrian Klaver 02:42
Re: New install of 9.5.12 missing default PostgreSQL DB Chandru Aroor 03:05
Re: New install of 9.5.12 missing default PostgreSQL DB David G. Johnston 03:31
Re: New install of 9.5.12 missing default PostgreSQL DB Chandru Aroor 03:49
Re: ON CONFLICT DO UPDATE Adrian Klaver 04:07
Re: ON CONFLICT DO UPDATE tango ward 04:56
Re: ON CONFLICT DO UPDATE tango ward 05:13
Re: ON CONFLICT DO UPDATE tango ward 05:25
Domain based on TIMEZONE WITH TIME ZONE Ben Hood 08:03
Re: Domain based on TIMEZONE WITH TIME ZONE Ben Hood 08:10
Re: Domain based on TIMEZONE WITH TIME ZONE Francisco Olarte 08:59
Re: ON CONFLICT DO UPDATE Alban Hertroys 09:57
Re: ON CONFLICT DO UPDATE tango ward 10:04
Re: Domain based on TIMEZONE WITH TIME ZONE Ben Hood 10:19

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