pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedTkSql and pg_group...
5+ messages / 3 participants
[nested] [flat]
* TkSql and pg_group...
@ 2002-07-07 00:56 Sandro Dentella <sandro.dentella@tin.it>
2002-07-07 16:34 ` Re: TkSql and pg_group... Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Sandro Dentella @ 2002-07-07 00:56 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: TkSql and pg_group...
2002-07-07 00:56 TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
@ 2002-07-07 16:34 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-07-08 11:04 ` Re: TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2002-07-07 16:34 UTC (permalink / raw)
To: Sandro Dentella <sandro.dentella@tin.it>; +Cc: pgsql-interfaces
Sandro Dentella <sandro.dentella@tin.it> writes:
> 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.
You should not be editing system catalogs with INSERT/UPDATE/DELETE
operations in any case.
This points up that the initdb process is pretty lax about marking
catalog columns NOT NULL, even though essentially all fixed-width
columns in the catalogs are in fact expected to not be null ...
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: TkSql and pg_group...
2002-07-07 00:56 TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
2002-07-07 16:34 ` Re: TkSql and pg_group... Tom Lane <tgl@sss.pgh.pa.us>
@ 2002-07-08 11:04 ` Sandro Dentella <sandro.dentella@tin.it>
2002-07-08 17:55 ` Re: TkSql and pg_group... Ross J. Reedstrom <reedstrm@rice.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Sandro Dentella @ 2002-07-08 11:04 UTC (permalink / raw)
To: pgsql-interfaces
On Sun, Jul 07, 2002 at 12:34:05PM -0400, Tom Lane wrote:
> Sandro Dentella <sandro.dentella@tin.it> writes:
> > 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.
>
> You should not be editing system catalogs with INSERT/UPDATE/DELETE
> operations in any case.
>
This was not true till 7.1 before CREATE GROUP command, correct?
You're suggesting tksql should set read-only any system catalogs, and let
people change them w/ other means?
How are system catalogs recognizable (apart from leading pg_ that a user
could put to other table names...)
TYA
sandro
*:-)
--
Sandro Dentella *:-)
e-mail: sandro.dentella@tin.it
http://www.tksql.org TkSQL Home page - My GPL work
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: TkSql and pg_group...
2002-07-07 00:56 TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
2002-07-07 16:34 ` Re: TkSql and pg_group... Tom Lane <tgl@sss.pgh.pa.us>
2002-07-08 11:04 ` Re: TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
@ 2002-07-08 17:55 ` Ross J. Reedstrom <reedstrm@rice.edu>
2002-07-10 09:22 ` Re: TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
0 siblings, 1 reply; 5+ messages in thread
From: Ross J. Reedstrom @ 2002-07-08 17:55 UTC (permalink / raw)
To: pgsql-interfaces
On Mon, Jul 08, 2002 at 01:04:47PM +0200, Sandro Dentella wrote:
> On Sun, Jul 07, 2002 at 12:34:05PM -0400, Tom Lane wrote:
>
> How are system catalogs recognizable (apart from leading pg_ that a user
> could put to other table names...)
You sure?
test=# create table pg_foo (a int, b text);
ERROR: invalid relation name "pg_foo"; the 'pg_' name prefix is reserved for system catalogs
Ross
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: TkSql and pg_group...
2002-07-07 00:56 TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
2002-07-07 16:34 ` Re: TkSql and pg_group... Tom Lane <tgl@sss.pgh.pa.us>
2002-07-08 11:04 ` Re: TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
2002-07-08 17:55 ` Re: TkSql and pg_group... Ross J. Reedstrom <reedstrm@rice.edu>
@ 2002-07-10 09:22 ` Sandro Dentella <sandro.dentella@tin.it>
0 siblings, 0 replies; 5+ messages in thread
From: Sandro Dentella @ 2002-07-10 09:22 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Ross J. Reedstrom <reedstrm@ece.rice.edu>
On Mon, Jul 08, 2002 at 12:55:04PM -0500, Ross J. Reedstrom wrote:
> On Mon, Jul 08, 2002 at 01:04:47PM +0200, Sandro Dentella wrote:
> > On Sun, Jul 07, 2002 at 12:34:05PM -0400, Tom Lane wrote:
> >
> > How are system catalogs recognizable (apart from leading pg_ that a user
> > could put to other table names...)
>
> You sure?
>
> test=# create table pg_foo (a int, b text);
> ERROR: invalid relation name "pg_foo"; the 'pg_' name prefix is reserved for system catalogs
>
> Ross
Ops!... thanks
*:-)
--
Sandro Dentella *:-)
e-mail: sandro.dentella@tin.it
http://www.tksql.org TkSQL Home page - My GPL work
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-07-10 09:22 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-07 00:56 TkSql and pg_group... Sandro Dentella <sandro.dentella@tin.it>
2002-07-07 16:34 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-07-08 11:04 ` Sandro Dentella <sandro.dentella@tin.it>
2002-07-08 17:55 ` Ross J. Reedstrom <reedstrm@rice.edu>
2002-07-10 09:22 ` Sandro Dentella <sandro.dentella@tin.it>
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