my database is empty. i am getting permissio denied message.

[ashok dhar]

sir,

in windows xp after successfully logging as postgres to the newgenlib db.
i m giving this command from postgresql command prompt

\i c:\backupinplain.sql

i am getting permission denied message.


kindly help.

ashok dhar

[ashok dhar]

actually the command should be like this

\i c:/backupinplain.sql

i got it. the command runs but the newgenlib database now has 330 table. but all the tables are empty.

this is the output of the cmd screen on  running the   \i c:/backupinplain.sql given below.
when i point the browser to http://localhost:8080/newgenlibctxt/ i can see the welcome screen but the dynamic values are empty. kindly help.

ashok dhar

output starts here
--------------
psql:c:/backupinplain.sql:19525: ERROR:  constraint "fk_patron_library1" for rel
ation "patron1" already exists
psql:c:/backupinplain.sql:19535: ERROR:  constraint "fk_patron_other_library" fo
r relation "patron" already exists
psql:c:/backupinplain.sql:19545: ERROR:  constraint "fk_patron_sdi" for relation
 "patron_sdi" already exists
psql:c:/backupinplain.sql:19555: ERROR:  constraint "fk_personal_name_af_patron"
 for relation "personal_name_af" already exists
psql:c:/backupinplain.sql:19565: ERROR:  constraint "fk_personal_sae_001" for re
lation "searchable_personalsae_ass" already exists
psql:c:/backupinplain.sql:19575: ERROR:  constraint "fk_personal_sae_002" for re
lation "searchable_personalsae_ass" already exists
psql:c:/backupinplain.sql:19585: ERROR:  constraint "fk_personal_see" for relati
on "personal_name_af_see" already exists
psql:c:/backupinplain.sql:19595: ERROR:  constraint "fk_personal_see_also_001" f
or relation "personal_name_af_seealso" already exists
psql:c:/backupinplain.sql:19605: ERROR:  constraint "fk_personal_see_also_002" f
or relation "personal_name_af_seealso" already exists
psql:c:/backupinplain.sql:19615: ERROR:  constraint "fk_privilege_patron_categor
y" for relation "privilege" already exists
psql:c:/backupinplain.sql:19625: ERROR:  constraint "fk_searchable_cataloguereco
rd" for relation "searchable_alternate_graphic_representation" already exists
psql:c:/backupinplain.sql:19635: ERROR:  constraint "fk_searchable_cataloguereco
rd_personal_name_af" for relation "searchable_cataloguerecord" already exists
psql:c:/backupinplain.sql:19645: ERROR:  constraint "fk_searchable_url_ass_searc
hable_cataloguerecord" for relation "searchable_url_ass" already exists
psql:c:/backupinplain.sql:19655: ERROR:  constraint "fk_ser_corpsh_cn" for relat
ion "searchable_corporatesh_ass" already exists
psql:c:/backupinplain.sql:19665: ERROR:  constraint "fk_ser_mnsh_mn" for relatio
n "searchable_meetingsh_ass" already exists
psql:c:/backupinplain.sql:19675: ERROR:  constraint "fk_ser_persh_pn" for relati
on "searchable_personalsh_ass" already exists
psql:c:/backupinplain.sql:19685: ERROR:  constraint "fk_ser_utsh_ut" for relatio
n "searchable_uniformsh_ass" already exists
psql:c:/backupinplain.sql:19695: ERROR:  constraint "fk_series_name_af_patron" f
or relation "series_name_af" already exists
psql:c:/backupinplain.sql:19705: ERROR:  constraint "fk_series_name_part_name_se
ries_name_af" for relation "series_name_part_name" already exists
psql:c:/backupinplain.sql:19715: ERROR:  constraint "fk_series_name_part_number_
series_name_af" for relation "series_name_part_number" already exists
psql:c:/backupinplain.sql:19725: ERROR:  constraint "fk_sm_bind_list_details_doc
ument" for relation "sm_bind_list_details" already exists
psql:c:/backupinplain.sql:19735: ERROR:  constraint "fk_sm_bind_list_document" f
or relation "sm_bind_list" already exists
psql:c:/backupinplain.sql:19745: ERROR:  constraint "fk_sm_bind_list_sm_co_bind_
spec" for relation "sm_bind_list" already exists
psql:c:/backupinplain.sql:19755: ERROR:  constraint "fk_sm_bind_list_sm_registra
tion" for relation "sm_bind_list" already exists
psql:c:/backupinplain.sql:19765: ERROR:  constraint "fk_sm_bind_order_volumes_sm
_bind_group" for relation "sm_bind_order_volumes" already exists
psql:c:/backupinplain.sql:19775: ERROR:  constraint "fk_sm_bind_order_volumes_sm
_binder_order" for relation "sm_bind_order_volumes" already exists
psql:c:/backupinplain.sql:19785: ERROR:  constraint "fk_sm_binder_order_budget_a
cc_budget_transaction" for relation "sm_binder_order_budget" already exists
psql:c:/backupinplain.sql:19795: ERROR:  constraint "fk_sm_binder_order_budget_s
m_binder_order" for relation "sm_binder_order_budget" already exists
psql:c:/backupinplain.sql:19805: ERROR:  constraint "fk_sm_binder_order_cir_co_b
inder" for relation "sm_binder_order" already exists
psql:c:/backupinplain.sql:19815: ERROR:  constraint "fk_sm_binder_order_library"
 for relation "sm_binder_order" already exists
psql:c:/backupinplain.sql:19825: ERROR:  constraint "fk_sm_binder_order_patron"
for relation "sm_binder_order" already exists
psql:c:/backupinplain.sql:19835: ERROR:  constraint "fk_sm_claim_index_title_pat
ron" for relation "sm_claim_index_title" already exists
psql:c:/backupinplain.sql:19845: ERROR:  constraint "fk_sm_claim_index_title_sm_
index_title" for relation "sm_claim_index_title" already exists
psql:c:/backupinplain.sql:19855: ERROR:  constraint "fk_sm_claim_issue_patron" f
or relation "sm_claim_issue" already exists
psql:c:/backupinplain.sql:19865: ERROR:  constraint "fk_sm_co_bind_price_patron"
 for relation "sm_co_bind_price" already exists
psql:c:/backupinplain.sql:19875: ERROR:  constraint "fk_sm_co_bind_price_sm_co_b
ind_specification" for relation "sm_co_bind_price" already exists
psql:c:/backupinplain.sql:19885: ERROR:  constraint "fk_sm_ind_tit_copy_indtit"
for relation "sm_ind_tit_copy" already exists
psql:c:/backupinplain.sql:19895: ERROR:  constraint "fk_sm_index_title_copy_id"
for relation "sm_index_title_copy" already exists
psql:c:/backupinplain.sql:19905: ERROR:  constraint "fk_sm_index_title_patron" f
or relation "sm_index_title" already exists
psql:c:/backupinplain.sql:19915: ERROR:  constraint "fk_sm_index_title_sm_subscr
iption1" for relation "sm_index_title" already exists
psql:c:/backupinplain.sql:19925: ERROR:  constraint "fk_sm_prediction_patron" fo
r relation "sm_prediction" already exists
psql:c:/backupinplain.sql:19935: ERROR:  constraint "fk_sm_prediction_patron" fo
r relation "sm_prediction_new" already exists
psql:c:/backupinplain.sql:19945: ERROR:  constraint "fk_sm_prediction_sm_subscri
ption" for relation "sm_prediction" already exists
psql:c:/backupinplain.sql:19955: ERROR:  constraint "fk_sm_prediction_sm_subscri
ption" for relation "sm_prediction_new" already exists
psql:c:/backupinplain.sql:19965: ERROR:  constraint "fk_sm_reg_copy_reg" for rel
ation "sm_registration_copy" already exists
psql:c:/backupinplain.sql:19975: ERROR:  constraint "fk_sm_registration_caption_
pattern" for relation "sm_registration" already exists
psql:c:/backupinplain.sql:19985: ERROR:  constraint "fk_sm_registration_sm_regis
tration" for relation "sm_registration" already exists
psql:c:/backupinplain.sql:19995: ERROR:  constraint "fk_sm_registrations_in_clai
m_sm_claim_issue" for relation "sm_registrations_in_claim" already exists
psql:c:/backupinplain.sql:20005: ERROR:  constraint "fk_sm_registrations_in_clai
m_sm_registration" for relation "sm_registrations_in_claim" already exists
psql:c:/backupinplain.sql:20015: ERROR:  constraint "fk_sm_routing_list_patron"
for relation "sm_routing_list" already exists
psql:c:/backupinplain.sql:20025: ERROR:  constraint "fk_sm_routing_list_sm_subsc
ription_family" for relation "sm_routing_list" already exists
psql:c:/backupinplain.sql:20035: ERROR:  constraint "fk_sm_satellite_index_title
_library" for relation "sm_satellite_index_title" already exists
psql:c:/backupinplain.sql:20045: ERROR:  constraint "fk_sm_satellite_index_title
_patron" for relation "sm_satellite_index_title" already exists
psql:c:/backupinplain.sql:20055: ERROR:  constraint "fk_sm_satellite_index_title
_sm_index_title" for relation "sm_satellite_index_title" already exists
psql:c:/backupinplain.sql:20065: ERROR:  constraint "fk_sm_satellite_registratio
n_library" for relation "sm_satellite_registration" already exists
psql:c:/backupinplain.sql:20075: ERROR:  constraint "fk_sm_satellite_registratio
n_patron" for relation "sm_satellite_registration" already exists
psql:c:/backupinplain.sql:20085: ERROR:  constraint "fk_sm_satellite_registratio
n_sm_serial_registration" for relation "sm_satellite_registration" already exist
s
psql:c:/backupinplain.sql:20095: ERROR:  constraint "fk_sm_serial_registration_p
atron" for relation "sm_registration" already exists
psql:c:/backupinplain.sql:20105: ERROR:  constraint "fk_sm_serial_registration_s
m_subscription" for relation "sm_registration" already exists
psql:c:/backupinplain.sql:20115: ERROR:  constraint "fk_sm_subscription_budget_a
cc_credit_note" for relation "sm_subscription_budget" already exists
psql:c:/backupinplain.sql:20125: ERROR:  constraint "fk_sm_subscription_budget_a
cc_depositary_account" for relation "sm_subscription_budget" already exists
psql:c:/backupinplain.sql:20135: ERROR:  constraint "fk_sm_subscription_budget_a
cc_library_budget" for relation "sm_subscription_budget" already exists
psql:c:/backupinplain.sql:20145: ERROR:  constraint "fk_sm_subscription_budget_p
atron" for relation "sm_subscription_budget" already exists
psql:c:/backupinplain.sql:20155: ERROR:  constraint "fk_sm_subscription_budget_t
ransaction_acc_budget_transaction" for relation "sm_subscription_budget_tr" alre
ady exists
psql:c:/backupinplain.sql:20165: ERROR:  constraint "fk_sm_subscription_budget_t
ransaction_acc_credit_note_transacti" for relation "sm_subscription_budget_tr" a
lready exists
psql:c:/backupinplain.sql:20175: ERROR:  constraint "fk_sm_subscription_budget_t
ransaction_acc_depositary_account_tr" for relation "sm_subscription_budget_tr" a
lready exists
psql:c:/backupinplain.sql:20185: ERROR:  constraint "fk_sm_subscription_budget_t
ransaction_sm_subscription_budget" for relation "sm_subscription_budget_tr" alre
ady exists
psql:c:/backupinplain.sql:20195: ERROR:  constraint "fk_sm_subscription_catalogu
erecord" for relation "sm_subscription" already exists
psql:c:/backupinplain.sql:20205: ERROR:  constraint "fk_sm_subscription_family_p
atron" for relation "sm_subscription_family" already exists
psql:c:/backupinplain.sql:20215: ERROR:  constraint "fk_sm_subscription_family_s
m_subscription" for relation "sm_subscription_family" already exists
psql:c:/backupinplain.sql:20225: ERROR:  constraint "fk_sm_subscription_invoice_
patron" for relation "sm_subscription_invoice" already exists
psql:c:/backupinplain.sql:20235: ERROR:  constraint "fk_sm_subscription_invoice_
sm_subscription" for relation "sm_subscription_invoice" already exists
psql:c:/backupinplain.sql:20245: ERROR:  constraint "fk_sm_subscription_library"
 for relation "sm_subscription" already exists
psql:c:/backupinplain.sql:20255: ERROR:  constraint "fk_sm_subscription_patron"
for relation "sm_subscription" already exists
psql:c:/backupinplain.sql:20265: ERROR:  constraint "fk_sm_subscription_sm_co_bi
nd_specification" for relation "sm_subscription" already exists
psql:c:/backupinplain.sql:20275: ERROR:  constraint "fk_sm_vendor_order_adm_co_v
endor" for relation "sm_vendor_order" already exists
psql:c:/backupinplain.sql:20285: ERROR:  constraint "fk_sm_vendor_order_library"
 for relation "sm_vendor_order" already exists
psql:c:/backupinplain.sql:20295: ERROR:  constraint "fk_sm_vendor_order_patron"
for relation "sm_vendor_order" already exists
psql:c:/backupinplain.sql:20305: ERROR:  constraint "fk_sm_vendor_order_patron1"
 for relation "sm_vendor_order" already exists
psql:c:/backupinplain.sql:20315: ERROR:  constraint "fk_smsubscription_vendor" f
or relation "sm_subscription" already exists
psql:c:/backupinplain.sql:20325: ERROR:  constraint "fk_subcorporatename_af_corp
orate_name_af" for relation "subcorporatename_af" already exists
psql:c:/backupinplain.sql:20335: ERROR:  constraint "fk_subcorporatename_af_patr
on" for relation "subcorporatename_af" already exists
psql:c:/backupinplain.sql:20345: ERROR:  constraint "fk_subcorporatename_chronol
ogical_subcorporatename_af1" for relation "subcorporatename_chronological" alrea
dy exists
psql:c:/backupinplain.sql:20355: ERROR:  constraint "fk_subcorporatename_formsd_
subcorporatename_af1" for relation "subcorporatename_formsd" already exists
psql:c:/backupinplain.sql:20365: ERROR:  constraint "fk_subcorporatename_general
sd_subcorporatename_af1" for relation "subcorporatename_generalsd" already exist
s
psql:c:/backupinplain.sql:20375: ERROR:  constraint "fk_subcorporatename_geograp
hicsd_subcorporatename_af1" for relation "subcorporatename_geographicsd" already
 exists
psql:c:/backupinplain.sql:20385: ERROR:  constraint "fk_subgeoname_af_patron" fo
r relation "subgeoname_af" already exists
psql:c:/backupinplain.sql:20395: ERROR:  constraint "fk_submeetingname_af_meetin
g_name_af" for relation "submeetingname_af" already exists
psql:c:/backupinplain.sql:20405: ERROR:  constraint "fk_submeetingname_af_patron
" for relation "submeetingname_af" already exists
psql:c:/backupinplain.sql:20415: ERROR:  constraint "fk_submeetingname_chronolog
icalsd_submeetingname_af1" for relation "submeetingname_chronologicalsd" already
 exists
psql:c:/backupinplain.sql:20425: ERROR:  constraint "fk_submeetingname_formsd_su
bmeetingname_af1" for relation "submeetingname_formsd" already exists
psql:c:/backupinplain.sql:20435: ERROR:  constraint "fk_submeetingname_generalsd
_submeetingname_af1" for relation "submeetingname_generalsd" already exists
psql:c:/backupinplain.sql:20445: ERROR:  constraint "fk_submeetingname_geographi
csd_submeetingname_af1" for relation "submeetingname_geographicsd" already exist
s
psql:c:/backupinplain.sql:20455: ERROR:  constraint "fk_subpername_chronological
sd_subpersonalname_af1" for relation "subpername_chronologicalsd" already exists

psql:c:/backupinplain.sql:20465: ERROR:  constraint "fk_subpername_formsd_subper
sonalname_af1" for relation "subpername_formsd" already exists
psql:c:/backupinplain.sql:20475: ERROR:  constraint "fk_subpername_generalsd_sub
personalname_af" for relation "subpername_generalsd" already exists
psql:c:/backupinplain.sql:20485: ERROR:  constraint "fk_subpername_geographicsd_
subpersonalname_af1" for relation "subpername_geographicsd" already exists
psql:c:/backupinplain.sql:20495: ERROR:  constraint "fk_subpersonalname_af_patro
n" for relation "subpersonalname_af" already exists
psql:c:/backupinplain.sql:20505: ERROR:  constraint "fk_subpersonalname_af_perso
nal_name_af" for relation "subpersonalname_af" already exists
psql:c:/backupinplain.sql:20515: ERROR:  constraint "fk_subtopic_af_patron" for
relation "subtopic_af" already exists
psql:c:/backupinplain.sql:20525: ERROR:  constraint "fk_subuniformtitle_af_patro
n" for relation "subuniformtitle_af" already exists
psql:c:/backupinplain.sql:20535: ERROR:  constraint "fk_subuniformtitle_af_unifo
rm_title_af" for relation "subuniformtitle_af" already exists
psql:c:/backupinplain.sql:20545: ERROR:  constraint "fk_subuniformtitle_chronolo
gicals_subuniformtitle_af1" for relation "subuniformtitle_chronologicals" alread
y exists
psql:c:/backupinplain.sql:20555: ERROR:  constraint "fk_subuniformtitle_formsd_s
ubuniformtitle_af1" for relation "subuniformtitle_formsd" already exists
psql:c:/backupinplain.sql:20565: ERROR:  constraint "fk_subuniformtitle_generals
d_subuniformtitle_af" for relation "subuniformtitle_generalsd" already exists
psql:c:/backupinplain.sql:20575: ERROR:  constraint "fk_subuniformtitle_geograph
icsd_subuniformtitle_af1" for relation "subuniformtitle_geographicsd" already ex
ists
psql:c:/backupinplain.sql:20585: ERROR:  constraint "fk_th_001" for relation "pe
rsonal_name_af_see" already exists
psql:c:/backupinplain.sql:20595: ERROR:  constraint "fk_th_002" for relation "pe
rsonal_name_af_seealso" already exists
psql:c:/backupinplain.sql:20605: ERROR:  constraint "fk_th_003" for relation "pe
rsonal_name_af_seealso" already exists
psql:c:/backupinplain.sql:20615: ERROR:  constraint "fk_th_004" for relation "co
rporate_name_af_see" already exists
psql:c:/backupinplain.sql:20625: ERROR:  constraint "fk_th_005" for relation "co
rporate_name_af_seealso" already exists
psql:c:/backupinplain.sql:20635: ERROR:  constraint "fk_th_006" for relation "co
rporate_name_af_seealso" already exists
psql:c:/backupinplain.sql:20645: ERROR:  constraint "fk_th_fg_seealso_001" for r
elation "formgenre_af_seealso" already exists
psql:c:/backupinplain.sql:20655: ERROR:  constraint "fk_th_fg_seealso_002" for r
elation "formgenre_af_seealso" already exists
psql:c:/backupinplain.sql:20665: ERROR:  constraint "fk_th_formgenre_see" for re
lation "formgenre_af_see" already exists
psql:c:/backupinplain.sql:20675: ERROR:  constraint "fk_th_gn_seealso_001" for r
elation "subgeoname_af_seealso" already exists
psql:c:/backupinplain.sql:20685: ERROR:  constraint "fk_th_gn_seealso_002" for r
elation "subgeoname_af_seealso" already exists
psql:c:/backupinplain.sql:20695: ERROR:  constraint "fk_th_mn" for relation "mee
ting_name_af_see" already exists
psql:c:/backupinplain.sql:20705: ERROR:  constraint "fk_th_mn_seealso_001" for r
elation "meeting_name_af_seealso" already exists
psql:c:/backupinplain.sql:20715: ERROR:  constraint "fk_th_seealso_002" for rela
tion "meeting_name_af_seealso" already exists
psql:c:/backupinplain.sql:20725: ERROR:  constraint "fk_th_subgeo_see" for relat
ion "subgeoname_af_see" already exists
psql:c:/backupinplain.sql:20735: ERROR:  constraint "fk_th_subtopic_see" for rel
ation "subtopic_af_see" already exists
psql:c:/backupinplain.sql:20745: ERROR:  constraint "fk_th_tt_seealso_001" for r
elation "subtopic_af_seealso" already exists
psql:c:/backupinplain.sql:20755: ERROR:  constraint "fk_th_tt_seealso_002" for r
elation "subtopic_af_seealso" already exists
psql:c:/backupinplain.sql:20765: ERROR:  constraint "fk_th_ut" for relation "uni
form_title_af_see" already exists
psql:c:/backupinplain.sql:20775: ERROR:  constraint "fk_th_ut_seealso_001" for r
elation "uniform_title_af_seealso" already exists
psql:c:/backupinplain.sql:20785: ERROR:  constraint "fk_th_ut_seealso_002" for r
elation "uniform_title_af_seealso" already exists
psql:c:/backupinplain.sql:20795: ERROR:  constraint "fk_uniform_title_af_patron"
 for relation "uniform_title_af" already exists
psql:c:/backupinplain.sql:20805: ERROR:  constraint "fkey_to_entry_details" for
relation "auto_number_generation" already exists
psql:c:/backupinplain.sql:20815: ERROR:  constraint "fkey_to_library" for relati
on "auto_number_generation" already exists
psql:c:/backupinplain.sql:20825: ERROR:  constraint "sm_claim_issue_library_id_f
key" for relation "sm_claim_issue" already exists
psql:c:/backupinplain.sql:20835: ERROR:  constraint "sm_claim_issue_library_id_f
key1" for relation "sm_claim_issue" already exists
psql:c:/backupinplain.sql:20845: ERROR:  constraint "sm_claim_issue_library_id_f
key2" for relation "sm_claim_issue" already exists
psql:c:/backupinplain.sql:20855: ERROR:  constraint "sm_claim_issue_library_id_f
key3" for relation "sm_claim_issue" already exists
psql:c:/backupinplain.sql:20865: ERROR:  constraint "textual_holdings_cataloguer
ecordid_fkey" for relation "textual_holdings" already exists
psql:c:/backupinplain.sql:20875: ERROR:  constraint "textual_holdings_cataloguer
ecordid_fkey1" for relation "textual_holdings" already exists
psql:c:/backupinplain.sql:20885: ERROR:  constraint "textual_holdings_cataloguer
ecordid_fkey2" for relation "textual_holdings" already exists
psql:c:/backupinplain.sql:20895: ERROR:  constraint "textual_holdings_cataloguer
ecordid_fkey3" for relation "textual_holdings" already exists
psql:c:/backupinplain.sql:20905: ERROR:  constraint "textual_holdings_cataloguer
ecordid_fkey4" for relation "textual_holdings" already exists
psql:c:/backupinplain.sql:20915: ERROR:  constraint "textual_holdings_cataloguer
ecordid_fkey5" for relation "textual_holdings" already exists
psql:c:/backupinplain.sql:20925: ERROR:  constraint "textual_holdings_cataloguer
ecordid_fkey6" for relation "textual_holdings" already exists
REVOKE
REVOKE
GRANT
GRANT
newgenlib=#

-------------------
out put ends here