Homeid integer NOT NULL CHECK(Homeid > 0),Īwayid integer NOT NULL CHECK(Awayid > 0),įOREIGN KEY (Homeid) REFERENCES team(Teamid),įOREIGN KEY (Awayid) REFERENCES team(Teamid),įOREIGN KEY (Stadiumid) REFERENCES stadium(Stadiumid) ON DELETE CASCADE)') Matchid integer NOT NULL CHECK(Matchid > 0),Ĭompetition text NOT NULL CHECK(Competition = 'International' OR Competition ='Domestic'), Query = sql.SQL('CREATE TABLE IF NOT EXISTS public.match( ( Stadiumid integer NOT NULL CHECK(Stadiumid > 0),Ĭapacity integer NOT NULL CHECK(Capacity > 0), Query = sql.SQL('CREATE TABLE IF NOT EXISTS public.stadium (Teamid integer NOT NULL CHECK(Teamid > 0), Query = sql.SQL('CREATE TABLE IF NOT EXISTS public.team What could be the problem? conn = Connector.DBConnector() Use the credentials created for the Login role when setting up your PostgreSQL connection for Chartio.įor information on creating a user with psql, see this article.įor more information on connecting your PostgreSQL database to Chartio, see our documentation.I have written some SQL code in python format using PGAdmin 4 servers to create some basic tables for my database (soccer games, keeping track of scores and such) and for some reason the definition of the table match (the third table) throws and exception that states 'there is no unique constraint matching given keys for referenced table 'stadium'' although Stadiumid is a key is stadium. You have successfully created a new read-only user for your database. On the ‘Role membership’ tab add the newly create group to the ‘Member’ window > click ‘OK’.

On the ‘Definition’ tab enter a secure password. Under your server tree right-click ‘Login Roles’ > select ‘New Login Role’ If your schema is not ‘public’, you will also need to grant USAGE permissions on the schema. In the ‘Privileges’ tab select the newly created group from the ‘Role’ drop-down menu > check the ‘Select’ box > click ‘Add/Change’ > click ‘OK’. On the ‘Selection’ tab click ‘Check All’. In the ‘Privileges’ tab select the newly created group from the ‘Role’ drop-down menu > check the ‘Connect’ box > click ‘Add/Change’ > click ‘OK’.Ĭlick the expand arrow next to your database > expand ‘Schemas’ > right-click ‘public’ > select ‘Grant Wizard’.

You do NOT need to create a password for the Group role we will create a password for the Login role created later in this document.Įxpand ‘Databases’ > right-click on the database you would like to connect to Chartio > select ‘Properties’.

Give the role a descriptive name > click ‘OK’. Connect to your PostgreSQL server instance using pgAdmin > right-click on ‘Group Roles’ and select ‘New Group Role’.

Pgadmin 4 and sql