Thread: Edit Data dialog

Edit Data dialog

From
"Adam H. Pendleton"
Date:
When using the edit data dialog, there should be a way to add a new row
to a table with no data.  Right now, I can edit the data of an empty
table, enter my data, but then there doesn't seem to be any way for me
to add the data.  Also, when using the edit data dialog, a column named
"OIDS" exists, which I don't really understand.  Isn't that a
database-specific column?  Should it even be visible?

ahp


Re: Edit Data dialog

From
"Dave Page"
Date:

> -----Original Message-----
> From: Adam H. Pendleton [mailto:fmonkey@fmonkey.net]
> Sent: 01 July 2003 17:16
> To: Dave Page; pgadmin-hackers@postgresql.org
> Subject: Edit Data dialog
>
>
> When using the edit data dialog, there should be a way to add
> a new row
> to a table with no data.  Right now, I can edit the data of an empty
> table, enter my data, but then there doesn't seem to be any
> way for me
> to add the data.

You can - just start typing in the row marked with a *.

> Also, when using the edit data dialog, a
> column named
> "OIDS" exists, which I don't really understand.  Isn't that a
> database-specific column?  Should it even be visible?

PostgreSQL has an 'oid' column which is unique within a given table (in
theory, unless oid wraparound occurs). It used to be common for people
to use this column as part of their schema. Nowadays, you can create
tables WITHOUT OIDS to prevent premature wraparound, however some people
do still use them, so seeing them may be useful. Note that you cannot
edit them.

Incidently, I did notice that when editting data in the grid, you only
seem to be able to append data to a string if it exceeds the width of
the column on screen. To insert data anywhere in the string, you must
resize the column such that it can hold the whole string visible at
once.

:-(

Regards, Dave.

Re: Edit Data dialog

From
Andreas Pflug
Date:
Dave Page wrote:

>- Still cannot enter more data than will visibly fit on screen unless I
>enlarge the column width.
>
Bug not located so far. Buried deep inside wx.

>
>- How do I enter carriage returns in the data? I can adjust the height
>of the row, but the normal suspects like shift-return or control-return
>don't work.
>
You can't at the moment. Not yet...

Regards,
Andreas