Re: Publication/Subscription Questions

2018-07-28 Thread Adrian Klaver
On 07/27/2018 01:34 AM, xOChilpili wrote: Hi everyone, Im just testing/learning how subscriptions and publications work, then this is what i have done until now: Server A : create database test_pubsubs; create table foo(  id_foo serial not null primary key, foo varchar(20) not null ​);​ ins

Re: Publication/Subscription Questions

2018-07-28 Thread Christophe Pettus
> On Jul 27, 2018, at 01:34, xOChilpili wrote: > > Why ? If i remove rows, from Server B and refresh publication, why data is > not re-sync ? ALTER SUBSCRIPTION ... REFRESH PUBLICATION doesn't do another initial copy of the data for existing tables in the publication. Its function is to add

Publication/Subscription Questions

2018-07-28 Thread xOChilpili
Hi everyone, Im just testing/learning how subscriptions and publications work, then this is what i have done until now: Server A : create database test_pubsubs; create table foo( id_foo serial not null primary key, foo varchar(20) not null ​);​ insert into foo values(1,'foo'); insert into foo v

Re: postgres with xcode

2018-07-28 Thread Adrian Klaver
On 07/28/2018 11:24 AM, Sumit Chaturvedi wrote: Ccing list Yes, I can start Postgres server from the terminal. I was thinking, if I comment out these lines and another assert later on which checks whether postmaster is using multiple threads, I'll be fine right? If by fine you mean driving fur

Re: postgres with xcode

2018-07-28 Thread Sumit Chaturvedi
Yes, I can start Postgres server from the terminal. I was thinking, if I comment out these lines and another assert later on which checks whether postmaster is using multiple threads, I'll be fine right? On Sat, Jul 28, 2018 at 11:46 PM, Adrian Klaver wrote: > On 07/28/2018 11:08 AM, Sumit Chat

Re: postgres with xcode

2018-07-28 Thread Adrian Klaver
On 07/28/2018 11:08 AM, Sumit Chaturvedi wrote: Hello. Thanks for those pointers. Will keep them in mind in the future. No, there is no problem outside Postgres. So you can start the Postgres server and use it from a program other then xcode? Could it be that postmaster becomes multithre

Re: postgres with xcode

2018-07-28 Thread Sumit Chaturvedi
Hello. Thanks for those pointers. Will keep them in mind in the future. No, there is no problem outside Postgres. Could it be that postmaster becomes multithreaded for some other reason?? On Sat, Jul 28, 2018 at 9:57 PM, Adrian Klaver wrote: > On 07/28/2018 07:15 AM, Sumit Chaturvedi wrote: >

Re: Read only to schema

2018-07-28 Thread Łukasz Jarych
Thank you Charles once again ! And best wishes, Jacek sob., 28 lip 2018 o 15:58 Charles Clavadetscher napisał(a): > Hello Jakek > > > > *From:* Łukasz Jarych [mailto:jarys...@gmail.com] > *Sent:* Samstag, 28. Juli 2018 14:13 > *To:* Melvin Davidson ; pgsql-gene...@postgresql.org > >> PG-General

Re: postgres with xcode

2018-07-28 Thread Adrian Klaver
On 07/28/2018 07:15 AM, Sumit Chaturvedi wrote: Please reply to list also. Ccing list. Hello. Thanks a lot for your response. Yes that was also there. Note: Bottom posting is the style on this list. Unfortunately the screenshot is not coming through on this reply. For those that see this the

Re: postgres with xcode

2018-07-28 Thread Adrian Klaver
On 07/28/2018 04:04 AM, Sumit Chaturvedi wrote: Hello everyone. I'm a third year student from IIT Bombay, India. Since I'm currently learning about databases, I wanted to debug postgresql with xcode. However, I am having a lot of problems. OS - 10.13.6 (High Sierra) Xcode - 9.4.1 To set up my

RE: Read only to schema

2018-07-28 Thread Charles Clavadetscher
Hello Jakek From: Łukasz Jarych [mailto:jarys...@gmail.com] Sent: Samstag, 28. Juli 2018 14:13 To: Melvin Davidson ; pgsql-gene...@postgresql.org >> PG-General Mailing List Subject: Re: Read only to schema Hi Guys, thank you for such advances replies and help ! You are the best!