Tickets Tagged With:postgresql

0
votes
5
answers
18 views

Category: Questions

DROP CASCADE

Hi,   My replaction is failing since I created a view on a atble on which increaments are not possible. I need to do a drop & recreate. https://app.skyvia.com/#/packages/80908/edit   ....

Created by Bart Jonk Bart Jonk 24 February 2020.

Latest by Bart Jonk Bart Jonk 25 February 2020.

0
votes
2
answers
53 views

Category: Bug Reports

Sync error - PG to Marketo

I am just starting with skyvia, and set up a simple test to sync a tiny 2-row table from PG to Marketo. The first run, it actually did put my ....

Created by Spencer Carlson Spencer Carlson 01 November 2019.

Latest by Spencer Carlson Spencer Carlson 13 November 2019.

0
votes
3
answers
35 views

Category: Questions

An exception .. during initialization: Updating field with name xyz does not exist in schema

Hi,   I have two failed packages with error message above. What's wrong? Is there any extra logging available?   cheers, Bart. ....

Created by Bart Jonk Bart Jonk 16 October 2019.

Latest by Mariia Zaharova Mariia Zaharova 16 October 2019.

0
votes
10
answers
369 views

Category: Questions

Synchronization Integration won't allow Target to Source "Id" column synchronization

Hello there. I have successfully synced a SFDC object/table to a table in a PostgreSQL database. I added a new primary-key column (named "_id") and am able to sync records back ....

Created by Jacob Widmer Jacob Widmer 11 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 21 March 2019.

0
votes
1
answers
166 views

Category: Questions

Problems importing to Postgresql using auto-generated id

Hi, I would like to import new rows into a Postgresql table where the primary key uses uuid_generate_v4() to generate unique Id's. The problem is that Skyvia requires me to map ....

Created by Elena O'Neil Elena O'Neil 18 February 2019.

Latest by Mariia Zaharova Mariia Zaharova 19 February 2019.

0
votes
4
answers
252 views

Category: Questions

Sync job failure - Value does not exist or does not match filter criteria.

Hey there, I have an error that's cryptic and non-explanatory when I insert a value into my PostgreSQL database and then run a data sync job to (ideally) have it ....

Created by Jacob Widmer Jacob Widmer 11 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 12 October 2018.

0
votes
1
answers
206 views

Category: Questions

Salesforce and Syncing - "... It does not have 'IsDeleted' column."

Hey there,Attempting to sync the RecordType table of a SFDC org to a table I've created in a Postgres database. Unfortunately getting the error: Table cannot be used in synchronization. ....

Created by Jacob Widmer Jacob Widmer 04 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 05 October 2018.

0
votes
8
answers
294 views

Category: Questions

Bi-directional synchronizing Salesforce with PostgreSQL

Hey there,I am attempting to create a "clone" more or less of a few different tables from Salesforce in an external Postgres database. The synchronization tool sounds like it's exactly ....

Created by Jacob Widmer Jacob Widmer 08 August 2018.

Latest by API User Reporting API User Reporting 15 August 2018.

0
votes
5
answers
514 views

Category: Questions

Accessing Postgresql on Heroku

Hi I'm looking at exporting data from a Postgresql database hosted on Heroku, unfortunately, the DB is set to require SSL but Heroku don't make the certificate details available. When I ....

Created by Ben Long Ben Long 09 May 2018.

Latest by Mariia Zaharova Mariia Zaharova 11 May 2018.

0
votes
1
answers
214 views

Category: Questions

Clear or erase a table completely before syncing

I have a table in PostgreSQL which I want to keep sync'd with MailChimp. I currently use the UPSERT operation and it works okay. But when subscribers are removed from MailChimp, ....

Created by Michael Fielding Michael Fielding 18 November 2017.

Latest by Mariia Zaharova Mariia Zaharova 20 November 2017.

Close