1
edit
Changes
no edit summary
[[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]] [[category: NexJ Express]]
=General Research=
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
|-
| Does postgreSQL have constants for boolean values?
|
|-
| Does posrgreSQL jdbc driver support returning metadata in UpperCase
|
|
|-
| Does renaming a column cause error if a view depends on it?
|
|-
| Does lo.sql unlink large objects when table is truncated?
|
|}
|
|}
==PostgreSQLSchemaManager==
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
|-
! Task
! Status
|-
|dropTable
* Remove <code>if exists</code>
|
|
|-
|getGUIDExpr
*Implement solution for x64 versions
|
|
|-
|remove trigger and procedure suffix $uid
|
|
|-
|getDefaultLongspace, getDefaultTablespace, getDefaultIndexspace
* move to SQLAdapter
|
|
|-
|getPrimaryKeys
* check if override is needed
|
|
|-
|generateIndexName
* Check if toLowerCase is needed
|
|
|-
|appendColumnType
* check if serial and bigserial have limits when compared to using sequences
|
|
|-
|Refactor creating and deleting full-text search indexes
* createFullTextIndex
** createFullTextSearchProcedure
** createFullTextSearchTrigger
* dropFullTextIndex
** dropFullTextSearchProcedure
** dropFullTextSearchTrigger
|
|
|-
|Refactor checking for BLOB column to isBLOB
|
|
|-
|Refactor checking for full-text search index on a column to getFullTextIndex
|
|
|-
|alterColumn - use this logic
* execute SQL to drop all dependent view/s for the column's table
* alter the column
* create the deleted view/s
|
|
|-
|renameColumn - use this logic for
* check if column has full-text search index
* rename the column
* rename column$
* drop full-text search trigger
* create full-text search trigger
|
|
|-
|dropIndex
* call super
* if index is TEXT index
** drop column$
** drop full-text search trigger
|
|
|-
|appendColumnAlternation
|}
=Scripts=
==postgrecreatepostgresql_create.sql====postgresetuppostgresql_setup.sql====postgredroppostgresql_drop.sql==
