Re: PostgreSQL && data types in ESQL/C

Hi > The above is a bit by try and error. Is there any good manual which > describes the ESQL/C details for PostgreSQL. > I newer used ESQL/C so I cannot to evaluate a quality of this part of this doc. I expect so there will not be any other. https://www.postgresql.org/docs/12/ecpg.html

PostgreSQL && data types in ESQL/C

Hello, On our project roadmap to port our LMS (Library Management System) from Sybase/Oracle to PostgreSQL we are now in the phase of addressing the ESQL/C and C++ code parts (some million lines of code). I wrote a small ESQL/C test code to see how the various data types are handled. In

Re: here does postgres take its timezone information from?

On Wed, Nov 6, 2019 at 2:20 PM Tom Lane wrote: > Thomas Munro writes: > > On Wed, Nov 6, 2019 at 12:02 PM Adrian Klaver > > wrote: > >> On 11/5/19 3:00 PM, Chris Withers wrote: > >>> Hmm. Is there any option to use the system timezone packages? > > >> --with-system-tzdata=DIRECTORY > > > I

Re: here does postgres take its timezone information from?

Thomas Munro writes: > On Wed, Nov 6, 2019 at 12:02 PM Adrian Klaver > wrote: >> On 11/5/19 3:00 PM, Chris Withers wrote: >>> Hmm. Is there any option to use the system timezone packages? >> --with-system-tzdata=DIRECTORY > I hope that most distributions do that*, because otherwise you >

Re: here does postgres take its timezone information from?

On Wed, Nov 6, 2019 at 12:02 PM Adrian Klaver wrote: > On 11/5/19 3:00 PM, Chris Withers wrote: > > Hmm. Is there any option to use the system timezone packages? > > https://www.postgresql.org/docs/11/install-procedure.html > > --with-system-tzdata=DIRECTORY By the way, you can see if your

Re: here does postgres take its timezone information from?

On 11/5/19 3:00 PM, Chris Withers wrote: On 05/11/2019 22:54, Adrian Klaver wrote: On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a

Re: here does postgres take its timezone information from?

On 05/11/2019 22:54, Adrian Klaver wrote: On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a reload or restart to see the updated zone

Re: here does postgres take its timezone information from?

On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a reload or restart to see the updated zone info? If not, how does postgres

Re: here does postgres take its timezone information from?

On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a reload or restart to see the updated zone info? If not, how does postgres

here does postgres take its timezone information from?

Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a reload or restart to see the updated zone info? If not, how does postgres store/obtain its timezone zone information and how

RE: Upgrade procedure

>> For us, we always use pg_upgrade even for minor updates because it >> feels safer to me. That being said, we rarely do minor updates and >> just do majors because upgrading is just hard enough (lots of >> testing!) we tend to wait and then jump further. Upgrading is known to >> take a

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: Upgrade procedure

On 11/05/2019 10:05 PM, Kevin Brannen wrote: From: rihad Hi, all. Why is it normally suggested to stop the server, upgrade it, then start it? Wouldn't it be easier & quicker to simply upgrade the package in-place and restart the service? On OSen that allow modification of currently running

RE: Upgrade procedure

On Tue, 5 Nov 2019, Kevin Brannen wrote: The manual or others here are more knowledgeable than I, but I believe that for a "minor" upgrade, you can just swap out the code and restart PG. For major upgrades, the PG server is going to have to come down as the underlying files might be

RE: Upgrade procedure

>> >From: rihad >> >>> Hi, all. Why is it normally suggested to stop the server, upgrade it, >>> then start it? Wouldn't it be easier & quicker to simply upgrade the >>> package in-place and restart the service? On OSen that allow >>> modification of currently running binaries, which is most Unix

Re: logical replication - negative bitmapset member not allowed

On Tue, 5 Nov 2019 16:02:51 +0100 Peter Eisentraut wrote: > On 2019-10-25 17:38, Jehan-Guillaume de Rorthais wrote: > > On Thu, 10 Oct 2019 15:15:46 +0200 > > Jehan-Guillaume de Rorthais wrote: > > > > [...] > >> Here is a script to reproduce it under version 10, 11 and 12: > > > > I

Re: How to import Apache parquet files?

On Tue, Nov 05, 2019 at 04:21:45PM +0100, Softwarelimits wrote: Hi Imre, thanks for the quick response - yes, I found that, but I was not sure if it is already production ready - also I would like to use the data with the timescale extension, that is why I need a full import. Well, we're not

Re: select view definition from pg_views feature request

Adrian Klaver writes: > On 11/5/19 6:43 AM, Michael Shapiro wrote: >> Can I set search_path='' (ie to a string that does not match any >> existing schema)? Would that be the proper way to guarantee that the >> definition for any view will always be fully-qualified? > [ example ] If you read

Re: How to import Apache parquet files?

Hi Imre, thanks for the quick response - yes, I found that, but I was not sure if it is already production ready - also I would like to use the data with the timescale extension, that is why I need a full import. Have nice day! On Tue, Nov 5, 2019 at 4:09 PM Imre Samu wrote: > >I would like

Re: How to import Apache parquet files?

>I would like to import (lots of) Apache parquet files to a PostgreSQL 11 cluster imho: You have to check and test the Parquet FDW ( Parquet File Wrapper ) - https://github.com/adjust/parquet_fdw Imre Softwarelimits ezt írta (időpont: 2019. nov. 5., K, 15:57): > Hi, I need to come and ask

Re: logical replication - negative bitmapset member not allowed

On 2019-10-25 17:38, Jehan-Guillaume de Rorthais wrote: On Thu, 10 Oct 2019 15:15:46 +0200 Jehan-Guillaume de Rorthais wrote: [...] Here is a script to reproduce it under version 10, 11 and 12: I investigated on this bug while coming back from pgconf.eu. Bellow what I found so far. I have

Re: select view definition from pg_views feature request

On 11/5/19 6:43 AM, Michael Shapiro wrote: Can I set search_path='' (ie to a string that does not match any existing schema)? Would that be the proper way to guarantee that the definition for any view will always be fully-qualified? test=# show search_path;

How to import Apache parquet files?

Hi, I need to come and ask here, I did not find enough information so I hope I am just having a bad day or somebody is censoring my search results for fun... :) I would like to import (lots of) Apache parquet files to a PostgreSQL 11 cluster - yes, I believe it should be done with the Python

Hunspell as filtering dictionary

Hi, I am trying to create a ts_vector from a French text. Here are the operations that seem logical to perform in that order: 1. remove stopwords 2. use hunspell to find words roots 3. unaccent I first tried: CREATE TEXT SEARCH CONFIGURATION fr_conf (copy='simple'); ALTER TEXT SEARCH

Re: Create a logical and physical replication

På tirsdag 05. november 2019 kl. 12:15:20, skrev Deepak Pahuja . < deepakpah...@hotmail.com >: Yes it is possible. No it isn't. I think maybe this will address it for v13: