Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

Warn if a table does not have integer primary key

Open
#166 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

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

Research direction

No source file or test is named in the issue. Start by tracing the initialization path that determines which tables will be synchronized, then inspect how their primary-key metadata is read. Done means users are warned when a selected table lacks an integer primary key, with behavior aligned to GeoPackage requirements 29 and 119.

Written by the indexing model from the issue text.

Description

enhancement

GeoPackage (as of v1.4.0) require that vector and attribute tables have integer primary keys (see requirement 29 and 119 in https://www.geopackage.org/spec140/). It would be good to check during init whether the tables we are going to sync have integer primary keys - and if not, report that to the user.

The sync will probably work fine even with non-integer primary keys, but such .gpkg files may cause interoperability issues, so this should be avoided.

Dominant language
Python
Stars
53
Forks
24
PR merge metrics
No merged PRs in 30d

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from MerginMaps/db-sync

All issues in MerginMaps/db-sync

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.