Re: Removing INNER JOINs

2017-12-10 Thread David Rowley
On 11 December 2017 at 17:33, Jim Finnerty wrote: > FK constraint enforcement may be deferred, but only to the end of the DML > transaction. Can someone provide an example where a SELECT statement that > is not in that DML transaction and that can view only committed data can see > a FK-side row

Is it possible to sort strings in EBCDIC order in PostgreSQL server?

2017-12-10 Thread Tsunakawa, Takayuki
Hello, It is embarrassing to ask such a thing, but is there any way to sort character column values in EBCDIC order inside the PostgreSQL server? i.e. is it possible to use EBCDIC collation in PostgreSQL, say, by using ICU or something? We need to run on a certain mainframe. I see almost no

Re: Display table entries using partial column entry

2017-12-10 Thread Gmail
> On Dec 10, 2017, at 4:10 PM, Melvin Davidson wrote: > > > >> On Sun, Dec 10, 2017 at 4:50 PM, Sherman Willden >> wrote: >> The database table has five columns; 'id aria artist a_artist album_title'. >> I assume I will use a SELECT * FROM aria_precis WHERE type command. >> >> I want to a

Re: Display table entries using partial column entry

2017-12-10 Thread Melvin Davidson
On Sun, Dec 10, 2017 at 4:50 PM, Sherman Willden wrote: > The database table has five columns; 'id aria artist a_artist > album_title'. I assume I will use a SELECT * FROM aria_precis WHERE type > command. > > I want to access all arias that have mio ben within the aria title. In the > example be

Re: transaction wrap around

2017-12-10 Thread Jeff Janes
On Tue, Dec 5, 2017 at 5:50 PM, Thomas Munro wrote: > On Tue, Dec 5, 2017 at 5:43 PM, Jeff Janes wrote: > > On Mon, Dec 4, 2017 at 5:52 PM, John R Pierce > wrote: > >> On 12/4/2017 2:21 PM, chris kim wrote: > >>> How would I investigate if my database is nearing a transaction wrap > >>> around.

Display table entries using partial column entry

2017-12-10 Thread Sherman Willden
The database table has five columns; 'id aria artist a_artist album_title'. I assume I will use a SELECT * FROM aria_precis WHERE type command. I want to access all arias that have mio ben within the aria title. In the example below I want to display cbiylm06 and cbiylm10. cbiylm06#Caro mio ben#C

Re: Missing RHEL rpm(pg_catcheck-10) in postgres 10 repo.

2017-12-10 Thread Devrim Gündüz
Hi, On Thu, 2017-12-07 at 11:29 +, Kaliappa, Karthic wrote: > > We are looking to upgrade our application from postgres 9.5 to 10x, but we > are unable to find the RPM named 'pg_catcheck-10x' for Redhat: https://downl > oad.postgresql.org/pub/repos/yum/10/redhat/rhel-6.7-x86_64/ > We reques

Re: Feature idea: Dynamic Data Making

2017-12-10 Thread Joe Conway
On 12/05/2017 01:03 PM, Alvaro Herrera wrote: > Riccardo Bassani wrote: >> As SQL Server 2016 ( >> https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking >> ) , or Oracle does: it could be a neat feature having Dynamic Data >> Masking, even if it has some limitation

Re: PG Schema to be used as log and monitoring store

2017-12-10 Thread Stefan Keller
Hi, 2017-12-10 2:53 GMT+01:00 John R Pierce : > I believe I would use boolean, not bit. Agreed. 2017-12-10 10:01 GMT+01:00 Thomas Kellerer : > Did you try to use a (single) hstore or jsonb column instead where the > attribute name is the key? Thought about that and I'm using hstore extensively

Re: PG Schema to be used as log and monitoring store

2017-12-10 Thread Thomas Kellerer
I actually made some tests on my own (using generate_series) and did not find any disk space or performance issues yet. I've also found this paper from 2012 about "Sensor Data Storage Performance: SQL or NoSQL, Physical or Virtual" [2] which confirms my observations. Now, you have to know that t