I have a no-OIDs database with a table that uses a serial primary key. I am using the "View data" option on the table within pgadminIII to enter new rows into the table. When I type enter into the last field of the last row, the "*" row counter increments to the next row. However, nothing is entered into the primary key field. I can place my cursor into the first (non-key) field and enter data, but then all subsequent fields lock me out so that I can't enter data. If I refresh the "view data" form, then a new primary key is applied and entered and I can edit the data.
Why must I refresh the table before entering further data, and why isn't the primary key autoupdating immediately when I create a new row? -- % Randy Yates % "...the answer lies within your soul %% Fuquay-Varina, NC % 'cause no one knows which side %%% 919-577-9882 % the coin will fall." %%%% <[EMAIL PROTECTED]> % 'Big Wheels', *Out of the Blue*, ELO http://home.earthlink.net/~yatescr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
