Re: Problems with postgres in test2
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