Re: Fwd: Proposed Chinese Translation of Community Code of Conduct

I see the attachments in your first email. On 5/21/21 12:22 PM, Stacey Haysler wrote: And, once again, the attachments did not make it through. Re-sending from my Gmail in hope that the attachments make it through this time. Regards, Stacey Begin forwarded message: *From: *Stacey Haysler

Re: The contents of the pg_timezone_names view bring some surprises

On 5/19/21 5:50 PM, Bryn Llewellyn wrote: Thanks, as ever, David and Tom, for your quick responses. Thanks also to Adrian Klaver, who replied in a branched thread with this—in response to my comment about my reading of the information content of the pg_timezone_abbrevs view: « This claims (as

Re: Question about integer out of range in function

On 2021-05-16 11:09:38 -0700, David G. Johnston wrote: > On Sunday, May 16, 2021, Condor wrote: > > >      new_time = fromtime * 1000; -- here is line 19 >       > > > An integer times an integer results in an integer.  Period.  Neither fromtime > nor new_time have been assigned to

Re: Plan for exclusive backup method

Hi Magnus, Thank you. On Wed, May 19, 2021 at 3:30 PM Magnus Hagander wrote: > On Wed, May 19, 2021 at 11:58 AM MEERA wrote: > > > > Hi team, > > > > https://www.postgresql.org/docs/12/continuous-archiving.html > > > > It is mentioned here that exclusive backup method is deprecated and >

Re: I have no idea why pg_dump isn't dumping all of my data

2021年5月21日(金) 20:42 Vijaykumar Jain : > > PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an > Extension > > so it works as expected. > someone would have to point to the reference wrt modification of data in > objects created via extension. If you want to be able to dump

Re: I have no idea why pg_dump isn't dumping all of my data

PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an Extension so it works as expected. someone would have to point to the reference wrt modification of data in objects created via extension. The main advantage of

Re: I have no idea why pg_dump isn't dumping all of my data

so this is the summary. I modified the extension to have a simple sql that created table and inserted a value. *** postgres@go:~$ cat /opt/postgresql-13/local/share/extension/nanoscopic--1.0.sql create table foo(id int); insert into foo values (1);

Re: I have no idea why pg_dump isn't dumping all of my data

ok, I think this is what it is. I copied the files to the extensions folder. ls /opt/postgresql-13/local/share/extension/nanoscopic* /opt/postgresql-13/local/share/extension/nanoscopic--1.0.sql /opt/postgresql-13/local/share/extension/nanoscopic.control and loaded the extensions. the relations

Re: I have no idea why pg_dump isn't dumping all of my data

This is the source code of the extension in question: https://github.com/xmrsoftware/nanoscopic/tree/master/sql/nanoscopic ‐‐‐ Original Message ‐‐‐ On Friday, May 21st, 2021 at 11:29, Vijaykumar Jain wrote: > i just did a dump of a db which was owned by postgres but some tables owned

Re: I have no idea why pg_dump isn't dumping all of my data

i just did a dump of a db which was owned by postgres but some tables owned by other users and it ran fine. I am not sure of that nanoscopic extension though. *** createdb -e foobar; postgres=# \c foobar You are now connected to database "foobar" as user "postgres".

Re: I have no idea why pg_dump isn't dumping all of my data

‐‐‐ Original Message ‐‐‐ On Friday, May 21st, 2021 at 10:55, Vijaykumar Jain wrote: > Can you try dumping using verbose flag. > -v > > Just want to confirm if the user has relevant permissions. > > On Fri, May 21, 2021, 3:04 PM Simon Connah > wrote: > > > Hi, > > > > I'm

Re: I have no idea why pg_dump isn't dumping all of my data

Can you try dumping using verbose flag. -v Just want to confirm if the user has relevant permissions. On Fri, May 21, 2021, 3:04 PM Simon Connah wrote: > Hi, > > I'm running the following command to dump my database: > > /usr/bin/pg_dump >

I have no idea why pg_dump isn't dumping all of my data

Hi, I'm running the following command to dump my database: /usr/bin/pg_dump --file=/home/simon/nanoscopic_db_127_0_0_1-2021_05_21_10_25_28-dump.sql --dbname=nanoscopic_db --clean --create --if-exists --username=nanoscopic_db_user --host=127.0.0.1 --port=5432 and yet when I run that all I get

Re: Any insights on Qlik Sense using CURSOR ?

For the record, Qlik uses the odbc driver with useDeclareFetch=1, hence the use of cursors. By default, postgresql planner tries to optimize the execution plan for retrieving 10℅ of the records when using a cursor. This can be controlled with cursor_tuple_fraction parameter. In my case,