Re: [pgadmin-support] Entering data

[graeme]

Thanks, When I think about it editing data will not be desirable, however it should be possible to add a new row, which was what I wanted to do, although I didn't explicitly state that. Anyway I can live with the situation, especially since the vast majority of my tables will have a pk. cheers, graeme. KÖPFERL Robert wrote: Hi, I'm using pgadmin 1.2.0 the version bundled with postgreSQL 8.0 on a windows XP machine. I am unable to enter data on any table if that table doesn't have a primary key. If the table has a primary key then I can enter data through the View edit data screen. You're wondering you? You mustn't. This is normal behavour. The reason is in the understanding of SQL or tuple arithmetics. A Relation or Table is nothing else than a set of records. There is no order, no identification. Thus it's not possible to edit individual records. There may however be some constraints. UNIQUE constraints over single columns (Or OIDs). This makes it possible to identify elements (records) of such a set. Thus they can be edited via an editor. OIDs do also help to make it editable. Is there any reason for this behaviour? graeme. -- Experience is a good teacher, but she sends in terrific bills. Minna Antrim ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match