Rename column to number - Mailing list pgadmin-support

From Lrat
Subject Rename column to number
Date
Msg-id 000501c2193b$6840fe90$0102a8c0@uno
Whole thread Raw
List pgadmin-support

2002-06-21 17:27:17 - Updating Column...
2002-06-21 17:27:17 - Entering pgSchema:pgColumn.Property Get Name()
2002-06-21 17:27:17 - Entering pgSchema:pgServer.Property Get
Databases()
2002-06-21 17:27:17 - Entering pgSchema:Databases.Property Get
Item("ayuntamientos")
2002-06-21 17:27:17 - Entering pgSchema:pgDatabase.Property Get
Namespaces()
2002-06-21 17:27:17 - Entering pgSchema:Namespaces.Property Get
Item("public")
2002-06-21 17:27:17 - Entering pgSchema:pgDatabase.Property Get Tables()
2002-06-21 17:27:17 - Entering pgSchema:Tables.Property Get
Item("datoscandidaturas1999")
2002-06-21 17:27:17 - Entering pgSchema:pgTable.Property Get Columns()
2002-06-21 17:27:17 - Entering pgSchema:Columns.Rename("\1", "1")
2002-06-21 17:27:17 - Entering pgSchema:pgColumn.Property Let Name(1)
2002-06-21 17:27:17 - Entering pgSchema:pgServer.Property Get
dbVersion()
2002-06-21 17:27:17 - Entering pgSchema:pgColumn.Property Get
FormattedID()
2002-06-21 17:27:17 - Entering pgSchema:pgServer.ExecSQL("ALTER TABLE
datoscandidaturas1999 RENAME COLUMN "\1" TO 1", "Connection:
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=ayuntamientos;SERVER=psql.lrats
.com;PORT=5432;UID=postgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;
ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=1
00;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=6553
6;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarch
ar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;Ex
traSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremat
ure=0;TrueIsMinus1=0"", 0, -1, 1)
2002-06-21 17:27:17 - SQL (ayuntamientos): ALTER TABLE
datoscandidaturas1999 RENAME COLUMN "\1" TO 1
2002-06-21 17:27:17 - Done - 0,01 Secs.

2002-06-21 17:27:17 -
*******************************************************************
2002-06-21 17:27:17 - Error
2002-06-21 17:27:17 -
*******************************************************************
2002-06-21 17:27:17 - Error in pgAdmin II:frmColumn.cmdOK_Click:
-2147467259 - ERROR:  parser: parse error at or near "1"
2002-06-21 17:27:17 - Windows Version: Windows XP v5.1 build 2600
2002-06-21 17:27:17 - pgSchema Version: 1.3.150
2002-06-21 17:27:17 - MDAC Version: 2.7
2002-06-21 17:27:17 - DBMS Version: 07.02.0001 PostgreSQL 7.2.1 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-06-21 17:27:17 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=psql.lrats.com
;PORT=5432;UID=postgres;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidInde
x=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fet
ch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=
65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongV
archar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=
0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPr
emature=0;TrueIsMinus1=0"

Thanks

lratlrat@correo.lrats.com
Virus Scanned by AMaViS for LiNuX ......

Attachment

pgadmin-support by date:

Previous
From: Julio Mendoza
Date:
Subject: Re: setup error
Next
From: "Thomas Sandford"
Date:
Subject: "Multiple-step OLE DB operation generated errors" in pgAdmin II:frmSQLOutput.LoadGrid