jakob / jakob/Postico

EXCLUDE constraint does not show properly

Open
#569 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

## What did you do?

I have created an EXCLUDE constraint:

```sql
ALTER TABLE event ADD CONSTRAINT unique_event_by_movie_id EXCLUDE (movie_id WITH =,venue_id WITH =,starts_at WITH =, (CASE WHEN unlisted_at IS NULL THEN 1 ELSE 0 END) WITH =) DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE event ADD CONSTRAINT unique_event_by_cinema_movie_name_id EXCLUDE (cinema_movie_name_id WITH =,venue_id WITH =,starts_at WITH =, (CASE WHEN unlisted_at IS NULL THEN 1 ELSE 0 END) WITH =) DEFERRABLE INITIALLY IMMEDIATE;

```

## What did you expect to happen?

I expected to be able to edit the constraint in the table Structure view.

## What actually happened?

The exclude constraint is not being displayed properly and I cannot edit the constraint definition.

screen shot 2018-07-01 at 20 35 32
screen shot 2018-07-01 at 20 37 30

## What software versions are you using?

Version 1.4.1 (2841)

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the issue in the table Structure view using the supplied PostgreSQL EXCLUDE constraints, then trace how constraints are displayed and edited there. Done means EXCLUDE constraints appear correctly and their definitions can be edited without losing the expressions or options.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.