Hi Jason,
I use pgAdminIII frequently to make changes to our dspace database
in postgreSQL and it works fine, so I'm not sure what you may be doing
wrong. Sometimes I use the wizard and sometimes I find a table that's
similar to the one I'm going to create, click once on it in the object
browser so that its corresponding DDL appears in the "SQL pane", then
copy the DDL into a SQL query window, make my desired changes and run
the DDL from the SQL query window. Maybe you're creating your objects
in the wrong Database and/or Schema...??? Just make sure you're
connected to the correct Database and Schema before creating your
object(s) and make sure the user you are connected as, has the proper
authorization for creating the object(s)..
Hope this helps!
Good luck,
Sue Walker-Thornton
Sue Walker-Thornton
ConITS Contract
NASA Langley Research Center
</></>Integrated Library Systems Application & Database Administrator
130 Research Drive
Hampton, VA 23666
Office: (757) 224-4074
Fax: (757) 224-4001
Pager: (757) 988-2547
Email: [email protected] <mailto:[email protected]>
________________________________
From: Jason Gum [mailto:[email protected]]
Sent: Wednesday, January 07, 2009 3:49 PM
To: [email protected]
Subject: [Dspace-tech] Adding/modifying tables in the dspace database
Hi all,
I am trying to add a table to the dspace database.
When I try to query my newly added table from dspace, I get an error
that the table does not exist.
When I add a column to an already existing table and call hasColumn() on
the newly added column, I get an error that the column does not exist.
I am trying to add the tables/ columns via pgAdmin III to the PostgreSQL
database using the right-click menus.
What is the proper way to add tables to the dspace database in order to
use them from dspace?
Sincerely,
Jason Gum
------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
