PSQLexception: ERROR : type "signed" does not exist
signed是MySQL特有的型別,Oracle和原生PostgreSQL都沒有,當MySQL的程式碼有select cast( '1' as signed);跑在當前沒有相容型別的資料庫上會報錯
lightdb@postgres=# select cast('1' as signed); ERROR: type "signed" does not exist LINE 1: select cast('1' as signed); ^ lightdb@postgres=# create domain public.signed as bigint; CREATE DOMAIN lightdb@postgres=# select cast('1' as signed); signed -------- 1 (1 row)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-2908954/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- error :does not name a typeError
- error: 'cout' does not name a type|Error
- SNMP TABLE ERROR : Requested table is empty or does not existError
- error: '[class name]' does not name a typeError
- error: ‘xxx’ does not name a typeError
- error: ‘變數名‘ does not name a type|Error變數
- Property 'context' does not exist on type 'NodeRequire'.ts(2339)ContextUI
- dcat-admin 表單 Field type [autocomplete] does not exist.
- asmcmd does not exist in directoryASM
- javax.media does not existJava
- ndk編譯錯誤:error: 'override' does not name a type編譯ErrorIDE
- from v * ERROR at line 1: ORA-00942: table or view does not existErrorView
- ORA-30012 undo tablespace 'UNDOTBS3' does not exist or of wrong typeS3
- Error: The directory named as part of the path ./log/supervisord.log does not exist解決方案Error
- ‘map’ does not name a type
- vector does not name a type
- MIRO Error:Table T169V: entry G180 does not existError
- Property [title] does not exist on this collection instance
- Waring: /dev/centos/swap does not existdevCentOS
- PatchObject constructor:Input file does not existObjectStruct
- QT中error: xxx does not name a type xxx錯誤QTError
- MIGO Error:Check table 169P: entry G180 does not existGoError
- Laravel Class env does not exist 問題排查Laravel
- ORA-00942: table or view does not existView
- FAQ:Field DATABASE does not exist; see long textDatabase
- relation with OID 637165 does not exist
- does not name a type 的可能性
- 'int32_t' does not name a type
- ORA-04043: object DBA_DATA_FILES does not existObject
- ORA-04042 procedure, function, package, or package body does not existFunctionPackage
- ORA-24756: transaction does not exist問題解決
- 【Oracle】-【許可權-ORA-04043】- object does not existOracleObject
- PL/SQL: ORA-00942: table or view does not existSQLView
- ORA-12545 TNS: Host or Object Does not ExistObject
- PSQLException: ERROR: failed to find conversion function from unknown to charSQLExceptionErrorAIFunction
- pgsql 執行建庫指令碼時候出現ERROR: relation "xxx_id_seq" does not existSQL指令碼Error
- Setup had an error Error: At least one of these paths should existErrorAST
- The user specified as a definer ('wx_root'@'%') does not exist 解決方案