Cannot remove then add a column in table's properties window - Columns tab.
SQL tab shows only ALTER TABLE table_name ADD COLUMN column_name; that with
DROP COLUMN vanished. So I'm forced to do it in 2 steps. Would be great to
do it in one step or pressing an Apply button after remove operation.
I'm connected to a postgresql server as non-privileged user. If I want to
rename a column which has length field modifiable then SQL looks like:
ALTER TABLE tablename RENAME columnname TO newcolumnname;
UPDATE pg_attribute
SET atttypmod=132
WHERE attrelid=21373::oid AND attnum=6;
even if lengt
LE info
(
version varchar(50) NOT NULL,
creationtstamptz timestamptz NOT NULL DEFAULT now()
) WITHOUT OIDS;
There is another problem, I cannot insert rows via Edit Data grid in info
table.
Virgil Frum
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Trying to run a SQL query (ex: SELECT 1;) with SELECT or 1 selected leads to
a syntax error. Seems that only selected area is executed.
Virgil
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
I cannot save changed server address (via server's properties) even on
disconnected server entry. Same behavior for Initial DB property.
Virgil
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.pos
If column type is int4 and try to change type to int2, SQL look like this:
UPDATE pg_attribute
SET atttypid=, atttypmod=-1
WHERE attrelid=21459::oid AND attnum=3;
and syntax error occurs. I know that int2 is not in Data type drop down list
but error should be avoided in some way.
Regards,
Vi
pgAdmin3 ver. 1.2.0 Post-Beta (oct 16 2004)
Steps to follow in edit grid:
1. Change value of an arbitrary column on last row then click on the same
row but different column so row is not updated ('Save[d] changed row.'
button is enabled).
2. Select previous row (n-1) and last row.
3. Press Delete
In Edit Data window, when mouse cursor is moved over toolbar's buttons,
status bar is cleared. If I press Refresh button (instead using F5) and move
cursor, number of rows from status bar will disappear. Idem for Delete
button.
Regards,
Virgil
---(end of broadcast)---
> OK, I found out what's happening. I've been testing with the correct
> versions from
> http://pgadmin.postgresql.org/snapshots/postgresql/libs-win32-20040927.zip
> but my distribution batch copied older versions.
>
> Please download that zip, replace the dlls and try again. This will
> hopefull
> Hm, I don't see too much either.
> Is that my win32 snapshot? Do you have a stack trace (Dr.Watson)?
Binary size (less than previous version): 5.500.928 bytes (CRC32: 1DA3940B;
MD5: F86F0A85151495DD4C74EFA7DFBD9F89), timestamp: 09.10.2004 23:39:08. Dr.
Watson's stack trace attached.
Virgil
Stat
Debug logging doesn't seem to be useful in this case:
2004-10-11 15:20:26 STATUS : Retrieving server properties...
2004-10-11 15:20:26 INFO : Displaying properties for Server
172.16.2.47:5432
2004-10-11 15:20:26 INFO : Displaying properties for server
172.16.2.47:5432
2004-10-11 15:20:26 STATU
pgAdmin3 ver. 1.2.0 Post Beta2 (Oct 09 2004) crashes when I'm trying to
connect to a postgresql 7.4.2 database. Same behavior if I want to add a new
server. Was tested only on postgresql 8.0.0?
Postgres log:
Oct 11 13:10:59 linux postgres[2248]: [1-1] LOG: connection received:
host=172.16.2.49 po
The problem is just partially resolved. I've made some new tests (on oct 05
release) and looked over changes you've made in src/ui/frmEditGrid.cpp.
Conclusion: deletion is working correctly only if rows are selected in
ascending or descending order with or without gaps. Selecting rows in an
arbitra
Your crystal
ball is brilliant. I've tested using PostgreSQL 7.4.2 (SUSE9.1), and that's
the message:ERROR: adding NOT NULL columns is not implementedHINT:
Add the column, then use ALTER TABLE SET NOT NULL.Would be great if
error messages could be selected and copy/pasted inmessage (like Add
Platform: Windows 2000(build 2195: Service Pack 4)
Language: english
Distribution: binary
Version: 1.2.0 Post Beta1 (Sept 17 2004)
When multiple rows are selected (in Edit Data window) from bottom to top and
Delete button is pressed then either the program crashes or wrong rows are
deleted.
Examp
15 matches
Mail list logo
