From: | Randy Yates <yates(at)ieee(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Table Rows Not Properly Added |
Date: | 2006-03-17 13:49:50 |
Message-ID: | m3k6at6uyf.fsf@ieee.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)ieee(dot)org> % 'Big Wheels', *Out of the Blue*, ELO
http://home.earthlink.net/~yatescr
From | Date | Subject | |
---|---|---|---|
Next Message | Randy Yates | 2006-03-17 13:55:54 | Re: Table Rows Not Properly Added |
Previous Message | Richard Huxton | 2006-03-17 13:47:26 | Re: Transferring databases to another Server |