Report bugs to pgsql-bugs@postgresql.org.
bash-3.00$ /usr/local/pgsql/bin/psql -d wildfire -f ./wildfire_postgresql.sql
DROP TABLE
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “jiveversion_pk” for table “jiveversion”
psql:./wildfire_postgresql.sql:10: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “jiveversion_pk” for table “jiveversion”
CREATE TABLE
INSERT 0 1
ALTER TABLE
ALTER TABLE
bash-3.00$ ls
wildfire_db2.sql wildfire_oracle.sql wildfire_sybase.sql
wildfire_hsqldb.sql wildfire_postgresql.sql
wildfire_mysql.sql wildfire_sqlserver.sql
bash-3.00$ cd …/7
bash-3.00$ ls
wildfire_db2.sql wildfire_oracle.sql wildfire_sybase.sql
wildfire_hsqldb.sql wildfire_postgresql.sql
wildfire_mysql.sql wildfire_sqlserver.sql
bash-3.00$ pwd
/opt/wildfire/resources/database/upgrade/7
bash-3.00$ /usr/local/pgsql/bin/psql -d wildfire -f ./wildfire_postgresql.sql
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubnode_pk” for table “pubsubnode”
psql:./wildfire_postgresql.sql:42: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubnode_pk” for table “pubsubnode”
CREATE TABLE
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubaffil_pk” for table “pubsubaffiliation”
psql:./wildfire_postgresql.sql:50: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubaffil_pk” for table “pubsubaffiliation”
CREATE TABLE
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubitem_pk” for table “pubsubitem”
psql:./wildfire_postgresql.sql:60: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubitem_pk” for table “pubsubitem”
CREATE TABLE
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubsubs_pk” for table “pubsubsubscription”
psql:./wildfire_postgresql.sql:79: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubsubs_pk” for table “pubsubsubscription”
CREATE TABLE
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubdefconf_pk” for table “pubsubdefaultconf”
psql:./wildfire_postgresql.sql:101: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “pubsubdefconf_pk” for table “pubsubdefaultconf”
CREATE TABLE
Does this look correct ?
Jeff
wildfire=# \d jiveversion
Table “public.jiveversion”
Column | Type | Modifiers
*----
*----
name | character varying(50) | not null
version | integer | not null
Indexes:
“jiveversion_pk” PRIMARY KEY, btree (name)
wildfire=#
wildfire=#
wildfire=#
wildfire=# SELECT * FROM jiveversion
wildfire-# ;
name | version
±—
wildfire | 7
(1 row)
Message was edited by: jeff_garner
wildfire=#
wildfire=# \d
List of relations
Schema | Name | Type | Owner
*----
*-----+–
public | jiveextcomponentconf | table |
public | jivegroup | table |
public | jivegroupprop | table |
public | jivegroupuser | table |
public | jiveid | table |
public | jiveoffline | table |
public | jiveprivacylist | table |
public | jiveprivate | table |
public | jiveproperty | table |
public | jiveremoteserverconf | table |
public | jiveroster | table |
public | jiverostergroups | table |
public | jiveuser | table |
public | jiveuserprop | table |
public | jivevcard | table |
public | jiveversion | table |
public | mucaffiliation | table |
public | mucconversationlog | table |
public | mucmember | table |
public | mucroom | table |
public | mucroomprop | table |
public | phonedevice | table |
public | phoneuser | table |
public | pubsubaffiliation | table |
public | pubsubdefaultconf | table |
public | pubsubitem | table |
public | pubsubnode | table |
public | pubsubsubscription | table |
(28 rows)
wildfire=#
Message was edited by: jeff_garner
Message was edited by: jeff_garner