Re: [HACKERS] Deployment of an output plugin in Unix-like environment

Anyone? -- View this message in context: http://postgresql.nabble.com/Deployment-of-an-output-plugin-in-Unix-like-environment-tp5940384p5942038.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To

Re: [HACKERS] How to extract bytes from a bit/bit(n) Datum pointer?

Thank you Ashutosh! I've been looking everywhere for this info -- View this message in context: http://postgresql.nabble.com/How-to-extract-bytes-from-a-bit-bit-n-Datum-pointer-tp5939776p5939811.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-ha

[HACKERS] How to extract bytes from a bit/bit(n) Datum pointer?

Hi, This may come from my lack of experience with Postgres, but I'm trying to extract the byte portion of a Datum that is of type VarBit - bit/bit(n). I see that the Datum pointer contains the value content of the bytes (after a few bytes for the header) but I would need to point to the actual val

Re: [HACKERS] Logical decoding - filtering tables

Craig Ringer-3 wrote > Take a look at how pglogical does it in its replication set handling > and relation metadata cache. I checked it out but for what I understand it uses the inline parameter. Would it be possible to store this info in some config table and then run a select from inside the plu

[HACKERS] Logical decoding - filtering tables

Hi, I'm developing a logical decoding plugin to extract changes from the database. This is working pretty well so far, but I have a question on the architectural aspect of the application. I want to filter changes based on the tables that are subscribed for CDC in my application and avoid network t

Re: [HACKERS] Transaction user id through logical decoding

Hi Craig, Thanks for your answer, I'll need to dig deep in the solutions you suggested although I was looking for something less convoluted. Valerio -- View this message in context: http://postgresql.nabble.com/Transaction-user-id-through-logical-decoding-tp5923261p5930219.html Sent from the Po

[HACKERS] Transaction user id through logical decoding

Hi all, I'm developing a custom plugin to stream Postgres CDC changes to my client application. One of the info the application needs is the user id of the user who executed a certain transaction. I can see we have access to other transaction info (xid, lsn, changed data) but apparently the user id

Re: [HACKERS] Error running custom plugin: “output plugins have to declare the _PG_output_plugin_init symbol”

The link was very helpful. It's a standard 'Attach to process' approach with Visual Studio and it works just as expected. Thank you Ashutosh! -- View this message in context: http://postgresql.nabble.com/Error-running-custom-plugin-output-plugins-have-to-declare-the-PG-output-plugin-init-symbol

Re: [HACKERS] Error running custom plugin: “output plugins have to declare the _PG_output_plugin_init symbol”

Hi Ashutosh, Thank you for your answer. At the end I realized that the PGDLLEXPORT keyword was missing from the functions definitions. As a side question, what are the options to debug the plugin while it's being executing? I've seen a debug plugin for Postgres but it seems more for SQL functions

[HACKERS] Error running custom plugin: “output plugins have to declare the _PG_output_plugin_init symbol”

Hi, I'm kind of new to Postgres and I'm trying to create a custom output plugin for logical replication (Postgres is 9.5.4 version and I'm building the project from a Windows 8/64 bit machine - same machine where the db is installed). I started from the code of the sample test_decoding, and I was t