Hi,
You can try following query on test database to remove duplicates.
DELETE FROM isi.rcited_ref a
WHERE a.ctid <> (SELECT min(ctid) FROM isi.rcited_ref b
WHERE a.rart_id = b.rart_id
AND a.r9 = b.r9
AND a.ra = b.ra
AND a.ry = b.ry
AND a.rw =
User 'test' is allow to connect to 'postgres' because by default it gets that
permission.
The default is no public access for
tables, columns, schemas, and tablespaces; CONNECT privilege and TEMP
table creation privilege for databases; EXECUTE privilege for functions; USAGE
privilege for l
