Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id D175E47594F
	for <pgsql-interfaces@postgresql.org>;
	Sat,  6 Jul 2002 20:56:56 -0400 (EDT)
Mailbox-Line: From sandro.dentella@tin.it  Sat Jul  6 20:56:56 2002
Received: from bluff.diade.it (adsl-51-134.38-151.net24.it [151.38.134.51])
	by postgresql.org (Postfix) with ESMTP id 7E33347593C
	for <pgsql-interfaces@postgresql.org>;
	Sat,  6 Jul 2002 20:56:55 -0400 (EDT)
Received: by bluff.diade.it (Postfix, from userid 500)
	id C077783B8; Sun,  7 Jul 2002 02:56:57 +0200 (CEST)
Date: Sun, 7 Jul 2002 02:56:57 +0200
From: Sandro Dentella <sandro.dentella@tin.it>
To: pgsql-interfaces@postgresql.org
Subject: TkSql and pg_group...
Message-ID: <20020707005657.GA23126@bluff.diade.it>
Mail-Followup-To: pgsql-interfaces@postgresql.org
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.28i
X-Spam-Status: No, hits=-1.9 required=5.0
	tests=X_NOT_PRESENT
	version=2.30
X-Spam-Level: 
X-Archive-Number: 200207/15
X-Sequence-Number: 2824


  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