Problems with postgres in test2

[mike]

On Wed, 2004-03-31 at 14:36, Lamar Owen wrote:
> On Wednesday 31 March 2004 07:34 pm, mike wrote:
> > I have installed test2 and now am having problems with a pg DB
> 
> > I did pg_dump_all to a file, checked it, all my data is there
> > Updated then did psql -f template1 as the man page
> 
> What was the previous PostgreSQL version?

7.4 something, whatever came with FC2-test1
> 
> > The "child" table wont allow inserts from a cgi script which worked fine
> > with test1
> 
> This is odd.  Do you have the DML that created those tables handy?
> -- 


This is the output from psql \d
                                     Table "public.tb_invoice_detail"
   Column    |          Type          |                            
Modifiers                                                                                 
-------------+------------------------+-------------------------------------------------------------------
 id          | integer                | not null default
nextval('public.tb_invoice_detail_id_seq'::text)
 invoice_id  | integer                |
 code        | character varying(15)  |
 description | character varying(100) |
 amount      | money                  |
 vat_code    | smallint               |
 line_total  | money                  |
Indexes:
    "tb_id_pk" primary key, btree (id)
Foreign-key constraints:
    "$1" FOREIGN KEY (invoice_id) REFERENCES tb_invoice_header(inv_id)
                                          Table
"public.tb_invoice_header"        Column       |         Type         
|                               Modifiers
--------------------+-----------------------+-----------------------------------------------------------------------
 inv_id             | integer               | not null default
nextval('public.tb_invoice_header_inv_id_seq'::text)
 client_id          | integer               |
 payable_recievable | character varying(15) |
 amount             | money                 |
 amount_paid        | money                 |
 date_paid          | date                  |
 cheque             | character varying(20) |
Indexes:
    "ih_pk" primary key, btree (inv_id)



> Lamar Owen
> Director of Information Technology
> Pisgah Astronomical Research Institute
> 1 PARI Drive
> Rosman, NC  28772
> (828)862-5554
> www.pari.edu
>