pgsql-sql - July 2019

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

July 4, 2019

Thread Author Time
Error: rows returned by function are not all of the same row type andrey.sychev 09:35

July 12, 2019

Thread Author Time
Would like to know what is the problem in my sql statement Karen Goh 02:04
Re: Would like to know what is the problem in my sql statement Juan C. Olivares 02:11
Would like to know what is the problem in my sql statement David G. Johnston 02:34
Re: Would like to know what is the problem in my sql statement Karen Goh 12:22
Re: Error: rows returned by function are not all of the same row type Ed Behn 15:34

July 14, 2019

Thread Author Time
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 03:39
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 08:10
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? David G. Johnston 16:40

July 16, 2019

Thread Author Time
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 06:14
Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 06:17
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Martin Stöcker 06:25
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 08:21
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 08:41
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 08:44
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 08:54
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Thomas Kellerer 08:57
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 09:25
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 09:36
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 09:48
Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 11:19
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 12:45
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Steve Midgley 13:32
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 14:10
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 14:19
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 14:28
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 15:02
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Andrew Gierth 15:21
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? Karen Goh 15:44
Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? David G. Johnston 16:00
IN vs arrays (was: Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?) Andrew Gierth 16:01

July 18, 2019

Thread Author Time
Ordered Hierarchies. Tim Uckun 02:46
Re: IN vs arrays (was: Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?) Tumasgiu Rossini 08:43
Re: IN vs arrays (was: Re: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?) Karen Goh 08:54
Fwd: Ordered Hierarchies. Todd Reed 13:45
Re: Ordered Hierarchies. Tony Shelver 16:25
Re: Ordered Hierarchies. Dmitry Ruban 20:58

July 19, 2019

Thread Author Time
Re: Ordered Hierarchies. Tim Uckun 02:19
Re: Ordered Hierarchies. Steve Midgley 08:15
RE: Ordered Hierarchies. Voillequin, Jean-Marc 08:47
Re: Ordered Hierarchies. Tim Uckun 12:38
pg_advisory_lock lock FAILURE / What does those numbers mean (process 240828 waits for ExclusiveLock on advisory lock [1167570,16820923,3422556162,1];)? Alexandru Lazarev 18:15
Re: pg_advisory_lock lock FAILURE / What does those numbers mean (process 240828 waits for ExclusiveLock on advisory lock [1167570,16820923,3422556162,1];)? Laurenz Albe 19:27
Re: pg_advisory_lock lock FAILURE / What does those numbers mean (process 240828 waits for ExclusiveLock on advisory lock [1167570,16820923,3422556162,1];)? Alexandru Lazarev 19:52

July 21, 2019

Thread Author Time
How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 00:58
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 01:25
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 01:31
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 01:48
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 02:00
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 02:07
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 02:20
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 02:48
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Holger Jakobs 07:28
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 13:53
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 14:12
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 14:24
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 14:54
Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 14:56
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:00
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 15:06
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:10
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 15:13
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:23
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 15:37
Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:44
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Avin Kavish 16:10
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 16:26
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 16:30
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Scott Ribe 17:30

July 22, 2019

Thread Author Time
How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 03:14
Interesting security context issue Erik Brandsberg 20:58

July 23, 2019

Thread Author Time
Implicit typecast behavior Rick Vincent 11:22
AW: Implicit typecast behavior Sonnenberg-Carstens, Stefan 11:29
Re: Implicit typecast behavior Thomas Kellerer 11:46
Re: Implicit typecast behavior Tom Lane 14:31
RE: Implicit typecast behavior Rick Vincent 15:01

July 30, 2019

Thread Author Time
install sample database error Cao, Xiaowei 23:27

July 31, 2019

Thread Author Time
Re: install sample database error Thomas Kellerer 06:16
RE: install sample database error Cao, Xiaowei 16:28
Re: install sample database error Rob Sargent 16:30

Browse Archives

Prev | Next