New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Navigation between foreign keys #22

Closed
ulope opened this Issue Jun 29, 2015 · 8 comments

Comments

Projects
None yet
3 participants
@ulope

ulope commented Jun 29, 2015

It would be very useful to have the option of navigating to a foreign key's target from within the row view (also from the sidebar, but less so I'd imagine).

Additionally if this were to be added the option to open the target in a new window would be great (e.g. by holding cmd while clicking the "link" - similar to how you'd open a link in a new browser tab)

@eliduke

This comment has been minimized.

Show comment
Hide comment
@eliduke

eliduke Jul 28, 2015

I want to give this one a 👍

It would be very useful to have the option of navigating to a foreign key's target from within the row view (also from the sidebar, but less so I'd imagine).

eliduke commented Jul 28, 2015

I want to give this one a 👍

It would be very useful to have the option of navigating to a foreign key's target from within the row view (also from the sidebar, but less so I'd imagine).

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Aug 7, 2015

Owner

I've now added a way to navigate to the related row today. I was a bit unsure how to implement it, so I'd love to hear your thoughts if its practical in this way. You can download todays build here: Postico 2015-08-07

(I forgot about the Cmd-Key opens new window idea, I'll add that at a later point)

Owner

jakob commented Aug 7, 2015

I've now added a way to navigate to the related row today. I was a bit unsure how to implement it, so I'd love to hear your thoughts if its practical in this way. You can download todays build here: Postico 2015-08-07

(I forgot about the Cmd-Key opens new window idea, I'll add that at a later point)

@ulope

This comment has been minimized.

Show comment
Hide comment
@ulope

ulope Aug 9, 2015

I like the popup, however I would have expected the referenced row in the target table to be highlighted, or the filter to default to the foreign key value...

ulope commented Aug 9, 2015

I like the popup, however I would have expected the referenced row in the target table to be highlighted, or the filter to default to the foreign key value...

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Aug 9, 2015

Owner

The referenced row should be highlighted in the target table... Hmm.

Could it be that you changed the row in the popover before clicking "Open Table"? In that case Postico jumps to the previous selected row (which I should probably fix?).

What version of PostgreSQL are you running?

Owner

jakob commented Aug 9, 2015

The referenced row should be highlighted in the target table... Hmm.

Could it be that you changed the row in the popover before clicking "Open Table"? In that case Postico jumps to the previous selected row (which I should probably fix?).

What version of PostgreSQL are you running?

@ulope

This comment has been minimized.

Show comment
Hide comment
@ulope

ulope Aug 9, 2015

Select row:
Select row

Click on navigate button:
Click on navigate button

Open target table:
Open target table

As you can see nothing gets highlighted and the target table also is not scrolled to correct row.

ulope commented Aug 9, 2015

Select row:
Select row

Click on navigate button:
Click on navigate button

Open target table:
Open target table

As you can see nothing gets highlighted and the target table also is not scrolled to correct row.

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Aug 9, 2015

Owner

OK, thanks @ulope
Is anything printed to Console.app?

Owner

jakob commented Aug 9, 2015

OK, thanks @ulope
Is anything printed to Console.app?

@ulope

This comment has been minimized.

Show comment
Hide comment
@ulope

ulope Aug 10, 2015

Interesting. I just noticed that highlighting works correctly in other databases.
The database I used above has WITH OIDS on almost all tables. Maybe that causes the Problem?

Also there is nothing logged to Console.app.

ulope commented Aug 10, 2015

Interesting. I just noticed that highlighting works correctly in other databases.
The database I used above has WITH OIDS on almost all tables. Maybe that causes the Problem?

Also there is nothing logged to Console.app.

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Aug 14, 2015

Owner

Okay, the problem was that Postico igrnored OIDs when looking for the related row. Thanks for pointing me to this issue @ulope

Fixed in v0.26

Owner

jakob commented Aug 14, 2015

Okay, the problem was that Postico igrnored OIDs when looking for the related row. Thanks for pointing me to this issue @ulope

Fixed in v0.26

@jakob jakob closed this Aug 14, 2015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment