Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

To Adrian:Your question: "The original encoding was Win-10 (Japanese) correct?"Let me answer this way:Yes, I created the file using used Win 10 (J)'s Excel (2016).When I saved the file as tab delimited text, it seems it was saved as ANSI because when I opened it using notepad, I could see it was

Re: Errors with schema migration and logical replication — expected?

On 12/11/18 2:21 PM, Mike Lissner wrote: Reupping this since it was over the weekend and looks like a bug in logical replication. My problems are solved, but some very weird things happened when doing a schema migration. On Sun, Dec 9, 2018 at 5:48 PM Mike Lissner mailto:mliss...@michaeljayli

Re: Errors with schema migration and logical replication — expected?

Reupping this since it was over the weekend and looks like a bug in logical replication. My problems are solved, but some very weird things happened when doing a schema migration. On Sun, Dec 9, 2018 at 5:48 PM Mike Lissner wrote: > On Sun, Dec 9, 2018 at 12:42 PM Adrian Klaver > wrote: > >> >>

Re: Search path & functions in temporary schemas

jose luis pillado writes: > This solution worked with a real schema, but it did not with a temporary > one. ... > Is there any way to make this work? The temp schema is intentionally excluded from the search path for functions and operators, because otherwise it's just too easy to trojan-horse th

Re: Newly Created Source DB Table Not Reflecting into Destination Foreign Tables

Ok, I will check. Thanks a lot. On Tue, 11 Dec 2018 at 21:16, Adrian Klaver wrote: > On 12/11/18 7:28 AM, ramsiddu007 wrote: > > Please reply to list also. > Ccing list. > > > Thanks for giving reply. > > 1. Postgres Version: 11 > > > > 2. Below Databases are in Single Server: > > Source Datab

Fwd: Code for getting particular day of week number from month

On Tue, Dec 11, 2018 at 2:10 PM Mike Martin wrote: > For a particular sequence I needed to do (schedule 2nd monday in month for > coming year) I created the following query nice, but a little brute force. Is this what you are trying to do: $ select d::date as month_starts, to_char(date_tr

Search path & functions in temporary schemas

Hi all, I was trying to mock a function. So I followed the instructions in this thread. I created a function with the same name as the existing one in different schema, and I updated the search path ad

Re: Newly Created Source DB Table Not Reflecting into Destination Foreign Tables

On 12/11/18 7:28 AM, ramsiddu007 wrote: Please reply to list also. Ccing list. Thanks for giving reply. 1. Postgres Version: 11 2. Below Databases are in Single Server:  Source Database (TestDB1): --- create table dept(deptno smallint, dname character varyi

Re: finding out what's generating WALs

On 11/12/18 4:00 μ.μ., Chris Withers wrote: Hi All, With a 9.4 cluster, what's the best way to find out what's generating the most WAL? I'm looking after a multi-tenant PG 9.4 cluster, and we've started getting alerts for the number of WALs on the server. It'd be great to understand what's ge

Re: Newly Created Source DB Table Not Reflecting into Destination Foreign Tables

On 12/11/18 1:44 AM, ramsiddu007 wrote: Dear Professionals,                            I hope you are doing well. I am looking *Foreign Data Wrappers*. In this way I have created a data wrapper in destination database. But at the time of creating wrapper, server and user mappings, source data

finding out what's generating WALs

Hi All, With a 9.4 cluster, what's the best way to find out what's generating the most WAL? I'm looking after a multi-tenant PG 9.4 cluster, and we've started getting alerts for the number of WALs on the server. It'd be great to understand what's generating all that WAL and what's likely to

Code for getting particular day of week number from month

Hi For a particular sequence I needed to do (schedule 2nd monday in month for coming year) I created the following query select to_char(min(date::date) + interval '1 week','DD/MM/') date --gets first date for day of month (monday in this case) then adds week and finally formats it to desi

Re: pg_restore fails due to foreign key violation

Tom Lane wrote: > Hm. In theory, that truncation failure in itself shouldn't have caused a > problem --- autovacuum is just trying to remove some empty pages, and if > they don't get removed, they'd still be empty. However, there's a problem > if the pages are empty because we just deleted some

Newly Created Source DB Table Not Reflecting into Destination Foreign Tables

Dear Professionals, I hope you are doing well. I am looking *Foreign Data Wrappers*. In this way I have created a data wrapper in destination database. But at the time of creating wrapper, server and user mappings, source database having only 1 table. After creating wrapp