pgsql-general - August 2017

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. 1, 2017

Thread Author Time
Re: Question about loading up a table Alex Samad 06:16
Not able to create collation on Windows 📎 Murtuza Zabuawala 07:21
Not able to create collation on Windows 📎 Murtuza Zabuawala 07:39
Shared Constants in PLPGSQL Tim Uckun 09:56
Re: Shared Constants in PLPGSQL [email protected] 11:57
Re: Shared Constants in PLPGSQL Merlin Moncure 13:04
Re: Shared Constants in PLPGSQL Merlin Moncure 13:10
Re: Question about loading up a table Scott Marlowe 13:24
Re: Shared Constants in PLPGSQL Tim Uckun 13:29
Logging in Code vs SQL-WHERE was: Row based permissions: at DB or at Application level? Thomas Güttler 14:11
Re: [GENERAL] Not able to create collation on Windows Tom Lane 14:53
Re: [GENERAL] Not able to create collation on Windows Peter Eisentraut 15:35
Re: [GENERAL] Not able to create collation on Windows Tom Lane 15:39
Re: Perfomance of IN-clause with many elements and possible solutions Jeff Janes 16:13
Problem compiling a C function on Windows - not finding _palloc0@4 Dan Cooperstock at Software4Nonprofits 16:21
Re: Perfomance of IN-clause with many elements and possible solutions Dmitry Lazurkin 16:24
Re: [GENERAL] Not able to create collation on Windows Murtuza Zabuawala 16:33
Re: [GENERAL] Not able to create collation on Windows Tom Lane 16:58
Re: standby database crash Michael Paquier 18:32
Re: Problem compiling a C function on Windows - not finding _palloc0@4 Dan Cooperstock at Software4Nonprofits 18:35
Re: Shared Constants in PLPGSQL Merlin Moncure 18:54
Re: Perfomance of IN-clause with many elements and possible solutions Jeff Janes 20:17
Re: Question about loading up a table Alex Samad 23:27
Re: PGpool question Tatsuo Ishii 23:59

Aug. 2, 2017

Thread Author Time
org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command Emi 13:42
Re: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command Albe Laurenz 14:10
Re: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command Melvin Davidson 14:13
bidirectional mapping? John McKown 15:44
Re: bidirectional mapping? Chris Travers 15:55
Do not INSERT if UPDATE fails Alexander Farber 15:58
Would you add a --dry-run to pg_restore? Edmundo Robles 16:02
Re: Question about loading up a table Scott Marlowe 16:11
Re: Do not INSERT if UPDATE fails Scott Marlowe 16:23
Re: Would you add a --dry-run to pg_restore? David G. Johnston 16:37
Re: Do not INSERT if UPDATE fails David G. Johnston 16:40
Re: Would you add a --dry-run to pg_restore? Tom Lane 16:49
Re: Would you add a --dry-run to pg_restore? Steve Atkins 16:56
Re: Would you add a --dry-run to pg_restore? Edmundo Robles 17:10
Re: Would you add a --dry-run to pg_restore? David G. Johnston 17:29
PostgreSQL 9.3 Uninstall error - Windows 2012 Pankaj Arora 18:12
Re: Would you add a --dry-run to pg_restore? Karsten Hilbert 18:39
Re: bidirectional mapping? John McKown 19:35
Re: bidirectional mapping? Rob Sargent 19:48
Re: Fwd: Planner oversight for GIN indices? Tom Lane 21:47
select md5 result set Peter Koukoulis 22:42
Re: select md5 result set David G. Johnston 23:25
Re: select md5 result set Peter Koukoulis 23:50

Aug. 3, 2017

Thread Author Time
Re: Question about loading up a table Alex Samad 00:12
Re: select md5 result set David G. Johnston 00:21
Re: Interesting streaming replication issue James Sewell 00:38
hot standby questions armand pirvu 03:19
unexpected pageaddr armand pirvu 03:34
standby database crash Murtuza Zabuawala 07:03
Re: Do not INSERT if UPDATE fails Francisco Olarte 08:14
Re: Would you add a --dry-run to pg_restore? Francisco Olarte 08:25
Re: Would you add a --dry-run to pg_restore? Rory Campbell-Lange 09:02
Re: Would you add a --dry-run to pg_restore? Merlin Moncure 12:58
Re: unexpected pageaddr armand pirvu 14:28
Check if prepared statement exist? Igor Korot 15:05
Re: Check if prepared statement exist? Tom Lane 15:54
Re: select md5 result set Jeff Janes 17:22
Re: hot standby questions Jeff Janes 17:58
cast issue in WITH RECURION k b 18:22
Re: cast issue in WITH RECURION k b 19:19

Aug. 4, 2017

Thread Author Time
Re: cast issue in WITH RECURION Alban Hertroys 01:32
Setting Variables within the PostgreSQL Service Process on AWS Linux Mark Street 02:40
Re: hot standby questions Lucas Possamai 04:03
Re: cast issue in WITH RECURION k b 05:54
Re: cast issue in WITH RECURION k b 06:01
Re: Do not INSERT if UPDATE fails Alexander Farber 12:10
Re: hot standby questions armand pirvu 12:21
Lifetime of PQexecPrepared() returned value Igor Korot 19:12
Re: Lifetime of PQexecPrepared() returned value Michael Paquier 19:26
Re: Lifetime of PQexecPrepared() returned value Igor Korot 19:29
Re: Lifetime of PQexecPrepared() returned value Tom Lane 21:01

Aug. 5, 2017

Thread Author Time
Type cast in PHP PDO (does not work like in Java?) Alexander Farber 15:58
Re: Type cast in PHP PDO (does not work like in Java?) Raymond O'Donnell 16:38
Re: Lifetime of PQexecPrepared() returned value Igor Korot 17:46
Re: Invalid byte sequence for encoding UTF-8 0xc3\n Igor Korot 18:01
Re: Lifetime of PQexecPrepared() returned value Tom Lane 18:30
PostgreSQL with PowerBuilder, and Identity keys (serials) Dan Cooperstock at Software4Nonprofits 20:09
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Melvin Davidson 20:45
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Dan Cooperstock at Software4Nonprofits 21:12
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Rob Sargent 21:29
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Dan Cooperstock at Software4Nonprofits 21:39
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Igor Korot 22:26
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Melvin Davidson 23:04

Aug. 6, 2017

Thread Author Time
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Dan Cooperstock at Software4Nonprofits 00:06
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Rick Widmer 00:22
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Karl Czajkowski 00:25
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Dan Cooperstock at Software4Nonprofits 00:52
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Igor Korot 02:17
PostgreSQL with PowerBuilder, and Identity keys (serials) David G. Johnston 07:46
Data checksum with pg upgradecluster Dan 12:15
Re: Data checksum with pg upgradecluster Karsten Hilbert 12:43
Re: PostgreSQL with PowerBuilder, and Identity keys (serials) Dan Cooperstock at Software4Nonprofits 17:40
the "PgJDBC driver is not an executable" message scott ribe 18:24

Aug. 7, 2017

Thread Author Time
Redacting JSONB Paul Jones 19:08
Re: Redacting JSONB Joshua D. Drake 19:14
Audit based on role anand086 23:33
Ora2pg estimation accuracy Venkat Ramkrishna 23:37
Re: Audit based on role John R Pierce 23:41
Re: Audit based on role anand086 23:47

Aug. 8, 2017

Thread Author Time
Re: Audit based on role Joe Conway 00:05
[General] - Ora2PG estimation accuracy Venkat Ramkrishna 00:16
Re: Audit based on role Melvin Davidson 01:59
About using IMCS moldule 송기훈 09:31
About using IMCS module 송기훈 09:57
Re: Audit based on role pinker 10:07
Re: Audit based on role Arthur Zakirov 10:57
ZeosLib database components - uuid inserts using libpq Ertan Küçükoğlu 14:56
Re: 64bit initdb failure on macOS 10.11 and 10.12 Rainer J.H. Brandt 15:04
Re: 64bit initdb failure on macOS 10.11 and 10.12 Tom Lane 15:14
Re: 64bit initdb failure on macOS 10.11 and 10.12 Rainer J.H. Brandt 16:27
Re: 64bit initdb failure on macOS 10.11 and 10.12 Tom Lane 16:36
Compiling libpq only on Linux Igor Korot 18:49
Re: 64bit initdb failure on macOS 10.11 and 10.12 Vick Khera 19:03
Re: Audit based on role Joe Conway 22:40
Re: Compiling libpq only on Linux Peter Eisentraut 23:30

Aug. 9, 2017

Thread Author Time
Any thoughts on making a psql meta-command "hide (or show alt text) if no results"? David G. Johnston 01:16
Re: Any thoughts on making a psql meta-command "hide (or show alt text) if no results"? Melvin Davidson 01:25
Re: Any thoughts on making a psql meta-command "hide (or show alt text) if no results"? David G. Johnston 01:44
Multixact members limit exceeded Peter Hunčár 10:06
pg_upgrade fails right after printing "Running in verbose mode" Юрий Нелепко 10:47
Re: 64bit initdb failure on macOS 10.11 and 10.12 Rainer J.H. Brandt 11:00
invalid byte sequence for encoding basti 12:21
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 ADSJ (Adam Sjøgren) 12:27
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Achilleas Mantzios 13:29
Re: invalid byte sequence for encoding rob stone 13:37
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Harry Ambrose 13:40
Re: 64bit initdb failure on macOS 10.11 and 10.12 Tom Lane 14:04
How to ALTER EXTENSION name OWNER TO new_owner ? Colin 't Hart 14:42
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Melvin Davidson 15:20
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Melvin Davidson 15:40
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Tom Lane 16:10
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Scott Marlowe 16:19
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Tom Lane 17:37
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Melvin Davidson 17:41
Re: Data checksum with pg upgradecluster Dan 17:50
Re: How to ALTER EXTENSION name OWNER TO new_owner ? David G. Johnston 17:56
Re: Multixact members limit exceeded Andres Freund 17:57
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Melvin Davidson 18:30
Re: How to ALTER EXTENSION name OWNER TO new_owner ? David G. Johnston 19:00
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Melvin Davidson 19:26
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Scott Marlowe 19:27
Re: Multixact members limit exceeded Peter Hunčár 19:31
Re: How to ALTER EXTENSION name OWNER TO new_owner ? David G. Johnston 19:32
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Melvin Davidson 19:37
Re: Multixact members limit exceeded Alvaro Herrera 20:30
Re: Multixact members limit exceeded Andres Freund 20:39
ErrorCode=-2147467259 storing a .net string marcelo 20:49
Re: Multixact members limit exceeded Peter Hunčár 21:27
Re: ErrorCode=-2147467259 storing a .net string marcelo 21:28
streaming replication - crash on standby Seong Son (US) 22:03
Re: Interesting streaming replication issue Andres Freund 22:08
Re: streaming replication - crash on standby Andres Freund 22:26
Re: Multixact members limit exceeded Thomas Munro 22:26
Re: streaming replication - crash on standby Seong Son (US) 22:31
Re: streaming replication - crash on standby Andres Freund 22:33
Re: Multixact members limit exceeded Thomas Munro 22:39
Re: Multixact members limit exceeded Alvaro Herrera 22:39

Aug. 10, 2017

Thread Author Time
Isolation of schema renames Ben Leslie 01:44
Re: Isolation of schema renames Tom Lane 02:14
Re: Isolation of schema renames Thomas Munro 02:34
Re: Isolation of schema renames Ben Leslie 03:21
Re: Audit based on role anand086 03:44
pg_stat_statements -- Historical Query anand086 04:23
Re: pg_stat_statements -- Historical Query Michael Paquier 04:41
Re: pg_stat_statements -- Historical Query Julien Rouhaud 07:30
foreign key with char and varchar Thomas Poty 07:37
Re: pg_stat_statements -- Historical Query Melvin Davidson 13:00
Re: About using IMCS moldule John McKown 13:06
Re: pg_stat_statements -- Historical Query Julien Rouhaud 13:12
Re: How to ALTER EXTENSION name OWNER TO new_owner ? Colin 't Hart 13:49
Curious planning decision Steve Rogerson 14:28
Re: foreign key with char and varchar Tom Lane 14:54
Re: Curious planning decision Tom Lane 15:09
pglogical sync armand pirvu 17:29
pglogical repo armand pirvu 17:30
Re: pglogical repo John R Pierce 18:21
Re: pglogical repo armand pirvu 18:29
could not find function "pglogical_table_data_filtered" in file "/usr/pgsql-9.5/lib/pglogical.so" armand pirvu 19:13
Re: could not find function "pglogical_table_data_filtered" in file "/usr/pgsql-9.5/lib/pglogical.so" armand pirvu 20:20
Re: pglogical sync armand pirvu 20:42
sequence used on null value or get the max value for a column whith concurrency marcelo 22:05
Re: sequence used on null value or get the max value for a column whith concurrency David G. Johnston 23:18

Aug. 11, 2017

Thread Author Time
Receive a string in Composite-type Arguments Fabiana Zioti 13:09
Re: sequence used on null value or get the max value for a column whith concurrency rob stone 14:05
Fwd: 2 process postgres -D for one instance Murtuza Zabuawala 14:15
Re: Receive a string in Composite-type Arguments Achilleas Mantzios 14:39
Re: Receive a string in Composite-type Arguments Pavel Stehule 15:12
Re: Fwd: 2 process postgres -D for one instance Peter Eisentraut 19:35
Re: Fwd: 2 process postgres -D for one instance Ron Johnson 19:44
Re: Fwd: 2 process postgres -D for one instance Don Seiler 20:06
How to make server generate more output? Rui Pacheco 20:14
Re: Fwd: 2 process postgres -D for one instance Tom Lane 20:23
Re: How to make server generate more output? Jeff Janes 21:29
Re: streaming replication - crash on standby Seong Son (US) 21:56

Aug. 13, 2017

Thread Author Time
Where is pg_hba.conf Igor Korot 14:00
Re: Where is pg_hba.conf Christoph Berg 14:09

Browse Archives

Prev | Next