pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sandro Dentella <sandro.dentella@tin.it>
To: pgsql-interfaces@postgresql.org
Subject: TkSql and pg_group...
Date: Sun, 7 Jul 2002 02:56:57 +0200
Message-ID: <20020707005657.GA23126@bluff.diade.it> (raw)


  I noticed only today that postgreSQL 7.2 changed the structure of certain
  tables like pg_group, that now are no loger editable by my tksql. The reason
  is that if TkSql cannot find any of:
    1. primary key
    2. unique not null
    3. oid
  switches to read-only mode. 

  pg_group has only unique key and no oid so that for example you can enter
  several times a line like:
   insert into pg_group (grolist) values ('{27}');

  This is very strange to me, and I'd like to understand it better, moreover
  I'd like to understand how should an editor cope with this case: I'd like
  to make tksql able to edit these tables too, but I see no way to act on a
  record in a unique way.

  Thanks in advance
  sandro
  *:-)

-- 
Sandro Dentella  *:-)
e-mail: sandro.dentella@tin.it 
http://www.tksql.org                    TkSQL Home page - My GPL work





view thread (5+ messages)  latest in thread

Message-ID: <20020707005657.GA23126@bluff.diade.it>
Permalink:  ../20020707005657.GA23126@bluff.diade.it/
Also on:    postgresql.org/message-id/20020707005657.GA23126@bluff.diade.it

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: sandro.dentella@tin.it
  Subject: Re: TkSql and pg_group...
  In-Reply-To: <20020707005657.GA23126@bluff.diade.it>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox