Re: [GENERAL] Where is the libpg on OSX?

On 05/04/2017 08:54 PM, Igor Korot wrote: Hi, ALL, [code] Igors-MacBook-Air:/ igorkorot$ find . -name *libpg* Pretty sure what you are looking for is libpq: https://www.postgresql.org/docs/9.6/static/libpq.html And then doing this: [code] Igors-MacBook-Air:/ igorkorot$ pg_config --libs

[GENERAL] Where is the libpg on OSX?

Hi, ALL, [code] Igors-MacBook-Air:/ igorkorot$ find . -name *libpg* find: ./.DocumentRevisions-V100: Permission denied find: ./.fseventsd: Permission denied find: ./.Spotlight-V100: Permission denied find: ./.Trashes: Permission denied

Re: [GENERAL] PQerrorMessage documentation

Hi, On Thu, May 4, 2017 at 9:57 PM, Peter Eisentraut wrote: > On 5/3/17 21:23, Igor Korot wrote: >> Hi, ALL, >> [quote] >> Nearly all libpq functions will set a message for PQerrorMessage if >> they fail. Note that by libpq convention, a nonempty PQerrorMessage

Re: [GENERAL] PQerrorMessage documentation

On 5/3/17 21:23, Igor Korot wrote: > Hi, ALL, > [quote] > Nearly all libpq functions will set a message for PQerrorMessage if > they fail. Note that by libpq convention, a nonempty PQerrorMessage > result can consist of multiple lines, and will include a trailing > newline. The caller should not

[GENERAL] Link errors

Hi, [code] 1> Creating library vc_mswuddll\postgres_dll.lib and object vc_mswuddll\postgres_dll.exp 1>libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol __imp__WSAIoctl@36 referenced in function _setKeepalivesWin32 1>libpqd.lib(ip.obj) : error LNK2001: unresolved external

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

On Thursday 04 May 2017 14:47:54 John R Pierce wrote: > On 5/4/2017 2:28 PM, Alan Hodgson wrote: > > On Thursday 04 May 2017 14:21:00 John R Pierce wrote: > >> or EBS, and I've heard from more than a few people that EBS can be > >> something of a sand trap. > > > > Sorry for following up

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

On 5/4/2017 2:50 PM, John R Pierce wrote: But there's an extension - pg_cron: https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/ there's also pg_agent which is a cron-like extension, usually bundled with pg_admin but also available standalone

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

On 5/4/2017 2:08 PM, Sven R. Kunze wrote: After searching the web, it seems to me that PostgreSQL doesn't offer a cron-like background job for cleanup tasks. http://stackoverflow.com/questions/18187490/postgresql-delete-old-rows-on-a-rolling-basis But there's an extension - pg_cron:

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

On 5/4/2017 2:28 PM, Alan Hodgson wrote: On Thursday 04 May 2017 14:21:00 John R Pierce wrote: or EBS, and I've heard from more than a few people that EBS can be something of a sand trap. Sorry for following up off-topic, but EBS has actually improved considerably in the last few years. You

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

On Thursday 04 May 2017 14:21:00 John R Pierce wrote: > or EBS, and I've heard from more than a few people that EBS can be > something of a sand trap. > Sorry for following up off-topic, but EBS has actually improved considerably in the last few years. You can get guaranteed (and very high)

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

On Thu, May 4, 2017 at 2:08 PM, Sven R. Kunze wrote: > On 03.05.2017 12:57, Thomas Güttler wrote: > >> Am 02.05.2017 um 05:43 schrieb Jeff Janes: >> >>> ​​ >>> >>> >> No. You can certainly use PostgreSQL to store blobs. But then, you need >>> to store the PostgreSQL data

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

On 5/4/2017 2:08 PM, Sven R. Kunze wrote: No. You can certainly use PostgreSQL to store blobs. But then, you need to store the PostgreSQL data **someplace**. If you don't store it in S3, you have to store it somewhere else. I don't understand what you mean here. AFAIK storing blobs in PG is

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

On 03.05.2017 12:57, Thomas Güttler wrote: Am 02.05.2017 um 05:43 schrieb Jeff Janes: On Sun, Apr 30, 2017 at 4:37 AM, Thomas Güttler > wrote: Is is possible that PostgreSQL will replace these building blocks in the

Re: [GENERAL] initdb with ignore hidden option

On 05/04/2017 09:59 AM, Feld, Michael (IMS) wrote: Hi Postgres team, Our organization would like to make a feature request to ignore hidden files/directories when running an initdb. We use hidden directories for misc backup strategies, and it’s cumbersome when needing to

[GENERAL] initdb with ignore hidden option

Hi Postgres team, Our organization would like to make a feature request to ignore hidden files/directories when running an initdb. We use hidden directories for misc backup strategies, and it's cumbersome when needing to coordinate with our storage administrator when we are

Re: [GENERAL] Logical replication

On 05/01/2017 09:34 AM, Adrian Klaver wrote: > On 05/01/2017 09:25 AM, Peter Eisentraut wrote: >> On 5/1/17 10:32, Adrian Klaver wrote: >>> On 04/30/2017 09:07 AM, Adrian Klaver wrote: I have started looking at the logical replication feature in Postgres 10. One thing I have no been able

Re: [GENERAL] Compatibility of libpg

On Thu, May 4, 2017 at 7:32 PM, John R Pierce wrote: > On 5/4/2017 2:19 AM, Magnus Hagander wrote: > > On Wed, May 3, 2017 at 11:31 PM, John R Pierce > wrote: > >> On 5/3/2017 2:20 PM, Magnus Hagander wrote: >> >>> >>> Please note that this method of

Re: [GENERAL] Compatibility of libpg

On 5/4/2017 2:19 AM, Magnus Hagander wrote: On Wed, May 3, 2017 at 11:31 PM, John R Pierce > wrote: On 5/3/2017 2:20 PM, Magnus Hagander wrote: Please note that this method of building libpq has been removed from Postgres

Re: [GENERAL] Column information

Igor Korot writes: > So if I write for example: > CREATE TABLE foo(id INTEGER PRIMARY KEY, label VARCHAR(50), price > DOUBLE(10, 2)); > how can I get 50, 10 and 2 from those 5 fields? (I assume you meant NUMERIC where you wrote DOUBLE, because that's not valid syntax as

Re: [GENERAL] Column information

David et al, On Thu, May 4, 2017 at 11:27 AM, David G. Johnston wrote: > On Thu, May 4, 2017 at 8:08 AM, Igor Korot wrote: >> >> Hi, guys, >> >> On Thu, May 4, 2017 at 10:54 AM, Adrian Klaver >> wrote: >> > On

Re: [GENERAL] Column information

Adrian Klaver writes: > Think I answered my own question. Numeric refers to all the types under: > https://www.postgresql.org/docs/9.6/static/datatype-numeric.html > not just the specific type numeric. Right. This overloading of the term "numeric" is a bit

Re: [GENERAL] Column information

On Thu, May 4, 2017 at 8:08 AM, Igor Korot wrote: > Hi, guys, > > On Thu, May 4, 2017 at 10:54 AM, Adrian Klaver > wrote: > > On 05/04/2017 07:44 AM, Tom Lane wrote: > >> > >> Adrian Klaver writes: > >>> > >>> Alright I

Re: [GENERAL] Column information

Hi, guys, On Thu, May 4, 2017 at 10:54 AM, Adrian Klaver wrote: > On 05/04/2017 07:44 AM, Tom Lane wrote: >> >> Adrian Klaver writes: >>> >>> Alright I see that, but why does my example show a >>> numeric_precision_radix of 10? >> >> >>> Is

Re: [GENERAL] Column information

On 05/04/2017 07:44 AM, Tom Lane wrote: Adrian Klaver writes: Alright I see that, but why does my example show a numeric_precision_radix of 10? Is there some transition point where it goes from base 10 to base 2? In PG, "numeric" always has radix 10, because the

Re: [GENERAL] Column information

On 05/04/2017 07:29 AM, Tom Lane wrote: Adrian Klaver writes: On 05/04/2017 07:00 AM, Tom Lane wrote: No, certainly not. The radix column says what the units of measurement are, not that the values in the precision column aren't decimal. So radix 2 indicates that

Re: [GENERAL] Column information

Adrian Klaver writes: > Alright I see that, but why does my example show a > numeric_precision_radix of 10? > Is there some transition point where it goes from base 10 to base 2? In PG, "numeric" always has radix 10, because the underlying implementation is decimal,

Re: [GENERAL] Column information

On 05/04/2017 07:29 AM, Tom Lane wrote: Adrian Klaver writes: On 05/04/2017 07:00 AM, Tom Lane wrote: No, certainly not. The radix column says what the units of measurement are, not that the values in the precision column aren't decimal. So radix 2 indicates that

Re: [GENERAL] Column information

Adrian Klaver writes: > On 05/04/2017 07:00 AM, Tom Lane wrote: >> No, certainly not. The radix column says what the units of measurement >> are, not that the values in the precision column aren't decimal. So radix >> 2 indicates that precision 32 means "32 bits", not

Re: [GENERAL] Generalized pg_stat_statements?

Thanks James! I have some ideas on how implement this using client-provided aggregate specifiers (think StatsD). I'll check PGXN for anything similar, and if I don't find anything, will consider engaging pgsql-hackers@ per https://wiki.postgresql.org/wiki/So,_you_want_to_be_a_developer%3F

Re: [GENERAL] Column information

On 05/04/2017 07:00 AM, Tom Lane wrote: Igor Korot writes: Yes, so for the Radix 2 only 0 and 1 should be used, right? And so the value should be 10 and not 32. No, certainly not. The radix column says what the units of measurement are, not that the values in the

Re: [GENERAL] Column information

On 05/03/2017 08:18 PM, Igor Korot wrote: Hi, ALL, One more question if I may. [code] draft=# SELECT * FROM information_schema.columns WHERE table_name = 'leagues' AND ordinal_position = 8; table_catalog | table_schema | table_name | column_name | ordinal_position | column_default |

Re: [GENERAL] Column information

Igor Korot writes: > Yes, so for the Radix 2 only 0 and 1 should be used, right? > And so the value should be 10 and not 32. No, certainly not. The radix column says what the units of measurement are, not that the values in the precision column aren't decimal. So radix

[GENERAL] Vaccum Query

Hi All, Any Idea what happens when we run standard vacuum (without full) on a table which has exclusive lock (or alter statement is being processed on that table). What happens in this case ? Will vacuum wait for the alter to commit ? If so, how long ? If not, then what ? And what actions can

[GENERAL] pg_stat_activity extra Fields are NULL

Dear Members! Windows Clients, PG 9.4 on Linux. I used [PID + Client IP + Port + BackEnd Start] for unique identification of a connection. Every connection store it's unique connection info in a table (per DataBase). F.e: "8574|195.12.4.3|50120|2017-01-01 08:12:15" Yesterday I realized that

Re: [GENERAL] Column information

Hi, Alan, On Thu, May 4, 2017 at 3:18 AM, Alban Hertroys wrote: > >> According to the documentation 'numeric_precision_radix' field should >> indicate what radix the value of 'numeric_precision' is stored. >> >> However, even though the radix is 2, the actual value is 32,

Re: [GENERAL] Compatibility of libpg

On Thu, May 4, 2017 at 12:06 AM, Igor Korot wrote: > > On Wed, May 3, 2017 at 5:20 PM, Magnus Hagander > wrote: > > On Tue, May 2, 2017 at 4:49 AM, Igor Korot wrote: > >> > >> John, > >> > >> On Mon, May 1, 2017 at 9:38 PM, John R

Re: [GENERAL] Compatibility of libpg

On Wed, May 3, 2017 at 11:31 PM, John R Pierce wrote: > On 5/3/2017 2:20 PM, Magnus Hagander wrote: > >> >> Please note that this method of building libpq has been removed from >> Postgres 10, so it's considered to be deprecated for quite some time. >> >> > this page

Re: [GENERAL] Column information

> According to the documentation 'numeric_precision_radix' field should > indicate what radix the value of 'numeric_precision' is stored. > > However, even though the radix is 2, the actual value is 32, which is > not a radix 2. https://en.wikipedia.org/wiki/Radix Alban Hertroys -- If you