[ADMIN] Application crash - pls help !!!

2004-08-04 Thread Pradeepkumar, Pyatalo (IE10)
Hi all, In the project that I am working, we have 4-5 components. Recently we had the integration of the components. Before integrating the postgresql database component, the application was running for 3-4 days without any problem. But after integrating the database component with the applicatio

Re: [ADMIN] Application crash - pls help !!!

2004-08-04 Thread Gregory S. Williamson
Pyatalo, As a start, perhaps you could provide some more information about what release of postgres, what OS platform and perhaps some more about the connection type (JDBC, perl, PHP, PgAdmin, etc) and some information about the application itself ? I am not knowledgable enough about postgres t

[ADMIN] check constraints

2004-08-04 Thread Jodi Kanter
I have little experience with postgres' check constraint features and was hoping to get some guidance. We have a table which houses links to various user files. The PK of this table is fi_pk. There are several tables in which a foreign key (fi_fk) to this field exist. We are implementing a feat

Re: [ADMIN] check constraints

2004-08-04 Thread Oliver Elphick
On Wed, 2004-08-04 at 15:50, Jodi Kanter wrote: > I have little experience with postgres' check constraint features and > was hoping to get some guidance. We have a table which houses links to > various user files. The PK of this table is fi_pk. There are several > tables in which a foreign key (fi

[ADMIN] pg_dump: schema with OID 1 does not exist

2004-08-04 Thread Christian Platzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there. We have a big problem with one of our databases. Postgres Server 7.3 When we try to backup the database, pg_dump exits with the following error: pg_dump: schema with OID 1 does not exist The same issue appears when we copy the entire database