gmane.org is now gmane.io
hope this works
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.
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 /data/
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 nev
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 reliabl
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 migh
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
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 sessions
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 alway
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 generat
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
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 t
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 framew
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 some
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 me
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
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
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 t
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,
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
>>
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
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 table
On Tue, 31 Jul 2018 12:59:03 -0500, Dimitri Maziuk
wrote:
>On 07/31/2018 12:33 PM, George Neuner wrote:
>
>> Is there some reason that postgresql.conf cannot be a link to your
>> file?
>
>It's six of one, half a dozen of the other. The big problem is when the
>
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 configuratio
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
soft
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:
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 port=543
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
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 may b
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.85)
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 throwi
On Sun, 6 May 2018 15:26:22 -0700, Ken Tanzer
wrote:
>On Fri, May 4, 2018 at 1:03 PM, George Neuner wrote:
>
>> On Thu, 3 May 2018 11:02:00 -0700, Adrian Klaver
>> wrote:
>>
>> >On 05/03/2018 09:47 AM, George Neuner wrote:
>> >>
>> >>
On Thu, 3 May 2018 11:02:00 -0700, Adrian Klaver
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 *try* to
>> copyright the use of + a
On Wed, 2 May 2018 16:01:01 -0700, Adrian Klaver
wrote:
>On 05/02/2018 02:29 PM, Jim Michaels wrote:
>
>>
>> - the microsoft patented CSV would be required for implementation. it
>> handles special data with commas and double-quotes in them
>
>Huh?:
>https://en.wikipedia.org/wiki/Comma-separated
On Mon, 19 Feb 2018 13:02:30 +0100, Durumdara
wrote:
>2018-02-13 21:21 GMT+01:00 George Neuner :
>
>> On Tue, 14 Nov 2017 12:09:31 +0100, Durumdara
>> wrote:
>>
>> >*I disabled my firewall at home - the [keepalive] problem vanished!!!*
>>
>> What
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
>thread. Certainly made sense when networks w
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 the
>Meltdown/Spectre patch
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
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; charset=us-ascii
>Content-Tr
On 2/6/2018 10:52 AM, David G. Johnston wrote:
On Tue, Feb 6, 2018 at 8:46 AM, George Neuner <mailto:gneun...@comcast.net>>wrote:
On Mon, 5 Feb 2018 18:22:02 +0100, Francisco Olarte
mailto:fola...@peoplecall.com>> wrote:
>I repeat for the last time. YOU ARE NOT
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 the numbers and the capi
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 youre
>reading far more
"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 magnitude of event.
It means only
On Tue, 12 Dec 2017 07:18:10 -0600, John McKown
wrote:
>?This is a guess on my part, based on many years on an EBCDIC system. But
>I'll bet that they are doing a conversion off of the EBCDIC system (maybe
>Db2 on z/OS) to an ASCII system (Linux or Windows) running PostgreSQL. They
>want to be abl
44 matches
Mail list logo
