Re: [Firefly-dev] DB update

[firefly-dev]

Ok, I got the database running but now I am getting errors with your
code. Here is the last part of the error.
John Hornbeck

ERROR:  Relation 'loans_loan_id_seq' already exists
NOTICE:  CREATE TABLE will create implicit sequence
'loan_types_loan_type_id_seq' for SERIAL column
'loan_types.loan_type_id'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'loan_types_pkey' for table 'loan_types'
ERROR:  Relation 'loan_types_loan_type_id_seq' already exists
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR:  Relation 'loan_books_relations' already exists
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'reservations_pkey' for table 'reservations'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR:  Relation 'reservations' already exists
ERROR:  relation named "userid_idx" already exists
INSERT 17140 1
INSERT 17141 1
INSERT 17142 1
INSERT 17143 1
ERROR:  Relation "authors_books_relationships" does not exist
ERROR:  Relation "authors_books_relationships" does not exist


On Fri, 2003-04-11 at 19:16, address@hidden wrote:
> db is working, it is not complete but at least it's stable and doesn't
> give more errors. 
> There are some minor problems to fix but they are not very important
> now.
> 
> I'm writing a file to help you to setup the db and one with some sample
> queries, however i have to make some views in the db so the code is not
> definitive yet...
> These files are not completed so I'll commit them tomorrow, it's too
> late here and I'm really tired :)
> 
> However, if you have already configured postgres you can add the db in
> two steps, from a shell type:
> 
> $ createdb --encoding=UNICODE firefly  # create a db called firefly
> $ psql firefly < firefly.sql   # import all the data into the firefly db
> 
> There are various tool to "browse" the db, I use phpPGAdmin, a web
> interface for postgresql databases written in php, still incomplete but
> easy to use, however I haven't tried the others alterntive so I don't
> know if they are better.
> 
> 
> 
> Marco
> 
> 
> P.S. I wanted to make a dir in the cvs called "db" to put all the stuff
> related to the db in there but cvs gave me some weird errors :(
> Can someone make it for me please ? otherwise the more we add files to
> the repository the more it will get disordered.
> thanks
> 
> 
> 
> _______________________________________________
> Firefly-dev mailing list
> address@hidden
> http://mail.nongnu.org/mailman/listinfo/firefly-dev
>