Обсуждение: pgAdmin III edit grid on empty Table

Поиск
Список
Период
Сортировка

pgAdmin III edit grid on empty Table

От
"Nathan Daniels"
Дата:
I am running the Win32 build installed of the msi installer on a Win2K box.

After installing the database, I created a new database named 'FPMain' and a
new table named 'Trusted' with one column also named 'Trusted' of
varchar[100] NOT NULL.  When I went to edit the table, the column showed up,
but there was no empty row displayed for me to begin entering data.  I
executed an arbitrary SQL statement to add one row of data to it.  The row
correctly showed up in the editor, but there was still no additional empty
row to begin entering new data.

Nathan Daniels
V.P. Data Integration
FATPOT Technologies

Re: pgAdmin III edit grid on empty Table

От
Andreas Pflug
Дата:
Nathan Daniels wrote:
> I am running the Win32 build installed of the msi installer on a Win2K box.
>
> After installing the database, I created a new database named 'FPMain' and a
> new table named 'Trusted' with one column also named 'Trusted' of
> varchar[100] NOT NULL.  When I went to edit the table, the column showed up,
> but there was no empty row displayed for me to begin entering data.  I
> executed an arbitrary SQL statement to add one row of data to it.  The row
> correctly showed up in the editor, but there was still no additional empty
> row to begin entering new data.
>

Nathan,
please post pgadmin related stuff at pgadmin-support.

You probably didn't assign a primary key to that table, pgadmin3 will
refuse to edit tables on which it can't identify rows uniquely.

Regards,
Andreas