by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 03:15
    dkastl commented #1345
  • 02:53
    sanak commented #1345
  • 02:27
    dkastl commented #1345
  • 01:31
    sanak commented #1345
  • Jul 05 20:24
    ImreSamu opened #1375
  • Jul 05 17:50

    cvvergara on develop

    pumping up to version 3.0.1 Merge pull request #1368 from c… Honoring cancellation request (… and 46 more (compare)

  • Jul 05 17:50
    cvvergara closed #1374
  • Jul 05 16:25
    cvvergara synchronize #1374
  • Jul 05 16:21
    cvvergara edited #1374
  • Jul 05 16:21
    cvvergara review_requested #1374
  • Jul 05 16:21
    cvvergara review_requested #1374
  • Jul 05 16:21
    cvvergara review_requested #1374
  • Jul 05 16:21
    cvvergara review_requested #1374
  • Jul 05 16:21
    cvvergara review_requested #1374
  • Jul 05 16:21
    cvvergara review_requested #1374
  • Jul 05 16:21
    cvvergara review_requested #1374
  • Jul 05 16:20
    cvvergara labeled #1374
  • Jul 05 16:20
    cvvergara opened #1374
  • Jul 05 16:20
    cvvergara milestoned #1374
  • Jul 04 15:40

    cvvergara on gh-pages

    Updating users documentation (compare)

Vicky Vergara
@cvvergara
```
SELECT FROM pgr_dijkstra(
'SELECT
FROM edge_table', -- edges sql query
'SELECT sources, targets FROM foo' --- combinations query
)
CREATE TABLE bar AS (
source BIGINT,
target BIGINT
)
source  | target
1  | 3
1 | 4
...
SELECT FROM pgr_dijkstra(
'SELECT FROM edge_table', -- edges sql query
'SELECT source, target FROM bar' --- combinations query
)
Vicky Vergara
@cvvergara
source | target
1 | 3
2 | 4
1 | 5
internally:
1 -> 3, 5
2 -> 4
SELECT 1 AS source, 3 AS target UNION SELECT 2,4 UNION SELECT 1,5 ---combinations query
'SELECT source, target FROM bar WHERE family = 1'
mahmsakr
@mahmsakr
WITH _src(seq1, id1) AS(
SELECT nextval('serial1'), id FROM sample1 limit 100
), _dest(seq2, id2) AS(
SELECT nextval('serial2'), id FROM sample2 limit 100
), srcdest AS(
SELECT id1, id2
FROM _src, _dest
WHERE seq1=seq2
Vicky Vergara
@cvvergara
SELECT * FROM pgr_dijkstra(
$$SELECT * FROM edge_table$$, -- edges sql query
--- the combinations query
$$WITH _src(seq1, id1) AS(
    SELECT nextval('serial1'),  id FROM sample1 limit 100
), _dest(seq2, id2) AS(
    SELECT nextval('serial2'),  id FROM sample2 limit 100
)
    SELECT id1 AS source, id2 AS target
    FROM _src, _dest
    WHERE seq1=seq2
$$);
CREATE TABLE foobar 
WITH _src(seq1, id1) AS(
    SELECT nextval('serial1'),  id FROM sample1 limit 100
), _dest(seq2, id2) AS(
    SELECT nextval('serial2'),  id FROM sample2 limit 100
)
    SELECT id1 AS source, id2 AS target
    FROM _src, _dest
    WHERE seq1=seq2;

SELECT * FROM pgr_dijkstra(
$$SELECT * FROM edge_table$$, -- edges sql query
--- the combinations query
$$SELECT * FROM foobar$$);
Vicky Vergara
@cvvergara
Plan:
  • pgRouting 3.0.0 final release must be done before June starts
  • meanwhile, MobilityDB team works on adding the new pgr_dijkstra overload function
When its ready, and "tested" incorporate to pgRouting and make a 3.1 release with the new function
as experimental
Vicky Vergara
@cvvergara
array[1] ARRAY [3,2] parallel
1 | 2
1 | 3
SELECT source, target FROM foo;
ARRAY[1,2,3,4,5 ..... 1000000] ARRAY[1000000, ...... 5,4,3,2,1]
SELECT source, target FROM foo WHERE target IN (3);
999998, 3
Vicky Vergara
@cvvergara
SELECT ARRAY[1,2,3,4,5 ..... 1000000] AS sources, ARRAY[1000000, ...... 5,4,3,2,1] as targets
Ashish Kumar
@krashish8
When are we having the next meeting? I'm sorry I didn't listen.
Is it Tomorrow Tuesday (19 May), 2pm UTC = 9am in Mexico = 7:30pm in India? @cvvergara
Vicky Vergara
@cvvergara
I didn't set up a date, but just be attentive for the last minute annoucement
Ashish Kumar
@krashish8
Okay. Thanks!
Vicky Vergara
@cvvergara
@krashish8 @rajhim2 @prakashupes please review pgRouting/pgrouting#1349
Vicky Vergara
@cvvergara

Topic: updating your working branch

The master branch has been updated, so you need to update the working branch

  • work on your GSoC-pgRouting clone
  • suppose remotes are:
    • origin your GSoC-pgRouting fork
    • upstream pgRouting repo
    • gsoc the GSoC-pgRouting repo

Steps:

  • If you haven't started coding:

    git fetch gsoc
    git checkout gsoc/<your branch> 
    git checkout -b <branch name>
    git fetch upstream
    git rebase upstream/master
    git push --set-upstream origin <branch name>

    And make a PR from <branch name> to gsoc/<your branch>

  • If you already started coding on branch: <branch name>

    git checkout <branch name>
    git fetch upstream
    git rebase upstream/master
    git push

    And make a PR from <branch name> to gsoc/<your branch>

I will check those PR (in my) tonight

end of topic

Vicky Vergara
@cvvergara
@rajhim2 why are you reverting the merge of the PR on the main repository
Ashish Kumar
@krashish8
@cvvergara I think we should force push in case "If you already started coding on branch: <branch name>"
git push -f
This is because rebasing would reorder the commits history, therefore the remote branch can't be fast-forwarded to local, without a force push.
Vicky Vergara
@cvvergara
yeah I forgot the -f, but that doesnt try to revert the master branch of the main repository
@krashish8 can you make the PR
Ashish Kumar
@krashish8
@cvvergara Done!
Vicky Vergara
@cvvergara
Thanks, The merge will be done before mailing a report next weekend
The opened PR will allow to follow your work
Ashish Kumar
@krashish8
Okay, understood!
Himanshu Raj
@rajhim2

@rajhim2 why are you reverting the merge of the PR on the main repository

It was clicked by mistake mam.

Ashish Kumar
@krashish8
@cvvergara There are some extra commits made by transfix-integration [bot]. So, we should rebase the master branch of pgrouting repository again, right? (repeating the above steps)
Himanshu Raj
@rajhim2
Can anyone please explain me why is this build failing. https://travis-ci.org/github/rajhim2/GSoC-pgRouting/jobs/689126458 This repository is on my profile rajhim2.
Himanshu Raj
@rajhim2
The command "if [ "$DOCUMENTATION" == "OFF" ] && [ "$BUILD_TYPE" == "Debug" ]; then bash ./ci/travis/doc-quieries_test.sh $POSTGRESQL_VERSION postgres; fi" exited with 1.
Daniel Kastl
@dkastl
Thank you @cvvergara !
Next I think it's on my to encourage a few more pgRouting businesses to financially contribute:
https://funding.communitybridge.org/projects/pgrouting
Rajat Shinde
@omshinde
Thank you @cvvergara . Congratulations to the team. :)
Vicky Vergara
@cvvergara
Next meeting: tuesday May 26 at 2pm UTC = 9am in Mexico = 7:30pm in India
Himanshu Raj
@rajhim2
Why the same build passes on appveyor and fails on travis-ci.
Ashish Kumar
@krashish8

Why the same build passes on appveyor and fails on travis-ci.

@rajhim2 I don't have any idea how it passes on appveyor, however, there's an error in your added files.

In the file src/kargersContraction/kargersContraction.c, the function's name shall be in all lowercase, as PostgreSQL converts all unquoted names to lowercase (_pgr_kargerscontraction instead of _pgr_kargersContraction).

You need to change this in all the three lines:

https://github.com/rajhim2/GSoC-pgRouting/blob/him/src/kargersContraction/kargersContraction.c#L43
https://github.com/rajhim2/GSoC-pgRouting/blob/him/src/kargersContraction/kargersContraction.c#L44
https://github.com/rajhim2/GSoC-pgRouting/blob/him/src/kargersContraction/kargersContraction.c#L116

Himanshu Raj
@rajhim2

Why the same build passes on appveyor and fails on travis-ci.

@rajhim2 I don't have any idea how it passes on appveyor, however, there's an error in your added files.

In the file src/kargersContraction/kargersContraction.c, the function's name shall be in all lowercase, as PostgreSQL converts all unquoted names to lowercase (_pgr_kargerscontraction instead of _pgr_kargersContraction).

You need to change this in all the three lines:

https://github.com/rajhim2/GSoC-pgRouting/blob/him/src/kargersContraction/kargersContraction.c#L43
https://github.com/rajhim2/GSoC-pgRouting/blob/him/src/kargersContraction/kargersContraction.c#L44
https://github.com/rajhim2/GSoC-pgRouting/blob/him/src/kargersContraction/kargersContraction.c#L116

Thank you @krashish8 ! It worked like a charm.

Himanshu Raj
@rajhim2
Mahmoud will open 1 issue:
For the functionality request of the pgr_dijkstra with the combinations sql
the issue has an example
step 2) Other issue (maybe there is already one that talks about using ctlr-C and in the comment put the possible solution.