1. Connect to PostgreSQL.
2. Open SQL editor and execute following statement:
"create table travel."test-test" ("i-d" int);".
3. Rightclick newly create tabgle and choose "View Data".
4. Insert some data and then press "Truncate table".
Result: Exception message appears.
Created attachment 71462 [details]
Screenshot of exception message.
Did you commit the data you inserted before trying to truncate the table?
Yes, I commited. But I did it with SQL editor, but not with "Insert Record" dialog.
Can you do the step 4 first and then step 3...
Since we are holding one connection that is used by all sub-components such as sqleditor, dataview etc.
I think somehow the connection is getting corrupted.
Anyway, I think this is a P3
Ahi, what do you mean "Can you do the step 4 first and then step 3"? As I understand we have "Truncate Table" button
only in data view window, so I can't do step 4 before step 3. Or you mean to do step 3 after step 4 again (as step 5)?
And I really don't agree that it is P3. If connection is getting corrupted right after it was established it isn't good.
And in case of PostgreSQL "Truncate Table" functionality doesn't work at all, at least I don't know any workaround.
Actually it can be even P1, since functionality doesn't work for DB, which is supported by Sun (in Solaris).
space between "truncate table" and fully qualified table name was missing hence truncate statement generated was not
understood by PostgreSQL.
Verified with build 081105.
I've transplanted the changeset http://hg.netbeans.org/main/rev/3ee8f45eecec into release65_fixes repository as