Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN

On Sun, 6 May 2018 15:26:22 -0700, Ken Tanzer <ken.tan...@gmail.com> wrote: >On Fri, May 4, 2018 at 1:03 PM, George Neuner <gneun...@comcast.net> wrote: > >> On Thu, 3 May 2018 11:02:00 -0700, Adrian Klaver >> <adrian.kla...@aklaver.com> wrote: >> >&

Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN

On Thu, 3 May 2018 11:02:00 -0700, Adrian Klaver <adrian.kla...@aklaver.com> wrote: >On 05/03/2018 09:47 AM, George Neuner wrote: >> >> ..., I would not discount the possibility that Microsoft really >> has patented some variation of CSV. They absolutely did *t

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Tue, 29 May 2018 13:32:46 -0700, Adrian Klaver wrote: >On 05/29/2018 12:14 PM, nageswara Bandla wrote: > >> As per the link- >> (https://www.postgresql.org/docs/9.6/static/libpq-pgpass.html) I set >> PGPASSFILE environment variable to point to pgpass.conf location. Even >> then, it’s

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Thu, 31 May 2018 11:24:18 -0500, nageswara Bandla wrote: >On Wed, May 30, 2018 at 7:45 PM, George Neuner wrote: > >> LocalSystem has administrator permissions to virtually everything. >> https://msdn.microsoft.com/en-us/library/windows/desktop/ >> ms684190(v=vs.

Re: Code of Conduct plan

On Sun, 03 Jun 2018 17:47:58 -0400, Tom Lane wrote: >Benjamin Scherrey writes: > >> Another more specific factual question - have there been incidents within >> the active Postgresql community where behaviour by individuals who are >> participants in the community have conducted themselves in a

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Thu, 31 May 2018 15:40:21 -0500, nageswara Bandla wrote: >On Thu, May 31, 2018 at 12:57 PM, George Neuner >wrote: > >> It just occurred to me that you said PGPASSFILE was set to >> >> %APPDATA%/postgresql/pgpass.conf >> >> >> The problem

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On 6/4/2018 6:31 PM, nageswara Bandla wrote: I have figured out the issue with pgAgent both in Windows and Linux. PgAgent seems to ignore pgpass.conf/.pgpass whenever it has 127.0.0.1 (127.0.0.1:5432:*:postgres:postgres) throws an error: *DEBUG: Creating DB connection: user=postgres

Re: pg_dump out of memory

On Tue, 3 Jul 2018 21:43:38 -0500, Andy Colson wrote: >Hi All, > >I moved a physical box to a VM, and set its memory to 1Gig. Everything >runs fine except one backup: > > >/pub/backup# pg_dump -Fc -U postgres -f wildfire.backup wildfirep > >g_dump: Dumping the contents of table "ofrrds" failed:

Re: data-checksums

"On Tue, 9 Jan 2018 20:02:37 +0100, "Rakesh Kumar" wrote: >Hello Mr. Pedantic, > >> noticeable != huge. > >and noticeable != small/negligible either, at least from English >point of view. small != negligible. The word "noticable" does not imply any particular

Re: SSD filesystem aligned to DBMS

On Tue, 16 Jan 2018 16:50:28 +, Michael Loftis wrote: >Alignment definitely makes a difference for writes. It can also make a >difference for random reads as well since the underlying read may not line >up to the hardware add in a read ahead (at drive or OS Level) and

Re: Regex Replace with 2 conditions

On Mon, 5 Feb 2018 18:22:02 +0100, Francisco Olarte wrote: >I repeat for the last time. YOU ARE NOT USING ASCII. ASCII IS A SEVEN >BIT CODE, 0-128. "?" IS NOT IN THE ASCII CHARACTER SET. What ASCII table are you reading? The question mark symbol is #63. It lies between

Re: Regex Replace with 2 conditions

On Tue, 6 Feb 2018 17:57:33 +0100, Francisco Olarte wrote: >So, no question mark sent, I suspect your mail chain may be playing >tricks on you, or may be you are translating to 7 bits on purpose >since your mail came with the headers: > >Content-Type: text/plain;

Re: Regex Replace with 2 conditions

On 2/6/2018 10:52 AM, David G. Johnston wrote: On Tue, Feb 6, 2018 at 8:46 AM, George Neuner <gneun...@comcast.net <mailto:gneun...@comcast.net>>wrote: On Mon, 5 Feb 2018 18:22:02 +0100, Francisco Olarte <fola...@peoplecall.com <mailto:fola...@peoplecall.com>>

Re: Connection loosing at some places - caused by firewall

On Tue, 14 Nov 2017 12:09:31 +0100, Durumdara wrote: >*I disabled my firewall at home - the [keepalive] problem vanished!!!* What firewall are you using? Windows own firewall doesn't interfere with keepalive packets. Most commercial SOHO firewalls won't either. George

Re: shared_buffers 8GB maximum

On Sat, 17 Feb 2018 00:36:57 +0200, Vitaliy Garnashevich wrote: >- I'm not a huge Linux expert, but I've heard someone saying that >reading from the filesystem cache requires a context switch. Yes. >I suspect >that such reads are slightly more expensive now after

Re: Database health check/auditing

On Sat, 17 Feb 2018 07:23:32 +1100, Tim Cross wrote: >Thomas Kellerer writes: > >> Plus: trimming the original content, so that not the whole email >> thread is repeated in the quote. > >While I'm happy to comply, I disagree with trimming/editing the

Re: Question on postgresql.conf

On Mon, 30 Jul 2018 18:35:59 +, "Lu, Dan" wrote: >I am going through the PostgreSQL manual and came across a question >hoping you can help me. It appears the "postgresql.conf" file is >needed by default to start Postgres. Since we have standard with >other RDBMS to store the

Re: User documentation vs Official Docs

On Thu, 19 Jul 2018 21:02:16 -0400, Melvin Davidson wrote: >As universities DO NOT ALLOW software to be installed on shared computers, >and this is the case especially in a library, it implies the user has >their own computer. Many (most?) universities do allow students to install and run

Re: Varlena with recursive data structures?

On Wed, 16 Jan 2019 22:08:35 +, Sam Patterson wrote: >Hi all, > >I've recently started developing an extension for Postgres for which I'll >need to create a new variable-length base type. The type will require a >tree-like structure in order to parse sufficiently, which of course >probably

Re: Watching for view changes

On Thu, 20 Dec 2018 12:12:14 -0800, Mitar wrote: >On Thu, Dec 20, 2018 at 8:11 AM Mike Rylander wrote: >> If, as I assume, the FROM clause of the SELECT is essentially static, >> just with varying WHERE conditions, you could just use an AFTER >> INSERT/UPDATE/DELETE trigger on each of the

Re: Watching for view changes

On Fri, 21 Dec 2018 20:49:23 -0800, Mitar wrote: >On Thu, Dec 20, 2018 at 6:28 PM George Neuner wrote: > >> The difficulty is that views are not guaranteed to be updateable. > >What you mean by that? I mean, just to be clear. I care only about >read-only views. The changes

Re: Watching for view changes

On Sun, 23 Dec 2018 23:06:51 -0800, Mitar wrote: >On Fri, Dec 21, 2018 at 11:10 PM George Neuner wrote: >> A materialized view IS exactly such a deliberate cache of results from >> applying a view. It is a real table that can be monitored for changes >> using INSERT,

Re: Watching for view changes

On Sun, 23 Dec 2018 10:10:50 -0800, Mitar wrote: >I can then wire triggers on underlying tables to REFRESH materialized >views automatically. Is there some easy way to debounce those >refreshes? If I just blindly trigger REFRESH in every row trigger, >this could do a lot of work. I would prefer

Re: Watching for view changes

On Mon, 24 Dec 2018 01:16:53 -0800, Mitar wrote: > >I am unable to find cache table's name. :-( > Did you execute the view or simply define it? I think the table is created the 1st time the view is executed. George

Re: Determine in a trigger if UPDATE query really changed anything

On Sun, 23 Dec 2018 20:21:22 -0800, Mitar wrote: >Currently I am doing: > >CREATE TRIGGER some_trigger AFTER UPDATE ON my_table REFERENCING NEW >TABLE AS new_table OLD TABLE AS old_table FOR EACH STATEMENT EXECUTE >FUNCTION my_trigger(); > >In my trigger I do: > >PERFORM * FROM ((TABLE new_table

Re: Watching for view changes

On Fri, 21 Dec 2018 23:41:16 -0800, Mitar wrote: >Hi! > >On Fri, Dec 21, 2018 at 11:10 PM George Neuner wrote: >> A materialized view IS exactly such a deliberate cache of results from >> applying a view. It is a real table that can be monitored for changes &g

Re: Future Non-server Windows support???

On Sun, 03 Mar 2019 08:30:48 +0100, Laurenz Albe wrote: >Bill Haught wrote: >> My main concern is that Microsoft has Enterprise versions of Windows and >> versions for everything else which makes me wonder if at some point >> Windows versions for desktop use may not have features needed by

Re: Web GUI for PG table ?

On Thu, 12 Sep 2019 10:56:21 -0400, David Gauthier wrote: >Many good visualization options but I need one that runs on the web AND >allows insert/update/delete records. Most browser GUI toolkits have some kind of spreadsheet-like "grid" widget that allows editing the displayed data. Some

Re: Cascade Trigger Not Firing

On Sat, 14 Sep 2019 10:00:18 -0500, Ron wrote: >On 9/14/19 9:54 AM, Tom Lane wrote: >[snip >> The only mention of this feature in 38.1 "Overview of Trigger Behavior" >> is >> >> UPDATE triggers*can* moreover be set to fire only if certain columns >> are mentioned in the SET clause of

Re: select view definition from pg_views feature request

On Sun, 03 Nov 2019 16:15:23 -0500, Tom Lane wrote: >Michael Shapiro writes: >> It seems that the definition of a view from pg_catalog.pg_views does not >> qualify the tables used in the view if the tables are in the current search >> path. > >> Is it possible to either have the definition

Re: select view definition from pg_views feature request

On Tue, 5 Nov 2019 14:29:00 +1300, David Rowley wrote: >See https://www.postgresql.org/docs/current/sql-set.html > >"SET only affects the value used by the current session." > >Also: > >"The effects of SET LOCAL last only till the end of the current transaction" > >Neither affects other

Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

On Tue, 10 Dec 2019 18:00:02 -0600, Ron wrote: >On 12/10/19 3:11 PM, Erwin Brandstetter wrote: >> I am looking for stable hash functions producing 8-byte or 4-byte hashes >> from long text values in Postgres 10 or later. >> >> There is md5(), the result of which can be cast to uuid. This

Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

On Sun, 15 Dec 2019 20:23:25 -0600, Ron wrote: >On 12/15/19 3:59 PM, George Neuner wrote: > >> On long text CRC will not be as discriminating as a real cryptohash, > >When specifying a 4 byte hash, something must be sacrificed... Obviously. But the main point is that CRC

Re: Is this a bug ?

On Wed, 23 Oct 2019 11:27:12 -0500, Ron wrote: >On 10/23/19 11:20 AM, Geoff Winkless wrote: >> On Wed, 23 Oct 2019 at 17:09, Ron wrote: >> >>> As much as I hate to say it, MSFT was right to ignore this bug in the >>> standard. >> Standards are standards for a reason. It is almost never correct

Re: Composite type storage overhead

On Wed, 23 Oct 2019 21:24:58 +, Laiszner Tamás wrote: Rob Sargent wrote >> Why not use UUID type? > 1. > Although it does not enforce, but the UUID type kind of suggests a > specific interpretation of the data. Of course the documentation says > you are free to use any algorithm to

Re: status of CURSORs after DISCONNECT

On Thu, 28 Nov 2019 09:58:50 -0500, Tom Lane wrote: >Matthias Apitz writes: >> When an ESQL/C written process issues a >> EXEC SQL DISCONNECT [connection]; >> do the opened CURSOR(s) still survive? > >No. Cursors are purely session-local objects in Postgres. >I'm a bit surprised to hear it

Re: status of CURSORs after DISCONNECT

On Thu, 28 Nov 2019 07:27:15 +0100, Matthias Apitz wrote: >When an ESQL/C written process issues a > >EXEC SQL DISCONNECT [connection]; > >do the opened CURSOR(s) still survive? We run into the problem that the >father process issues DISCONNECT before forking children, the forked child >CONNECTs

testing post through gmane.io

gmane.org is now gmane.io hope this works

Re: WaitForMultipleObjects in C Extension

On Tue, 14 Jan 2020 10:35:09 +0300, ?lyas Derse wrote: > Hi guys I need your experiences. I made an Extension in C. When I stop the >query on PostgreSQL,I want to control my extension's result with use cases >in C.So I think , I should use WaitForMultipleObjects. Not really understanding this.

Re: Changing default ../data/ directory

On Sat, 4 Jan 2020 07:20:44 -0800 (PST), Rich Shepard wrote: >As this is all new to me I want to learn how to: > >1) Define a postgresl.conf and learn where it should be located. > >2) Move all current databased in /var/lib/pgsql/11/data to /data/pgsql/11. > >3) Create all new databases in