Thread: Table Rows Not Properly Added

Table Rows Not Properly Added

From
Randy Yates
Date:
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."
%%%% <yates@ieee.org>           %  'Big Wheels', *Out of the Blue*, ELO
http://home.earthlink.net/~yatescr

Re: Table Rows Not Properly Added

From
Randy Yates
Date:
PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)
--
%  Randy Yates                  % "My Shangri-la has gone away, fading like
%% Fuquay-Varina, NC            %  the Beatles on 'Hey Jude'"
%%% 919-577-9882                %
%%%% <yates@ieee.org>           % 'Shangri-La', *A New World Record*, ELO
http://home.earthlink.net/~yatescr