R: [GENERAL] Error code associated to "could not open relation with OID ..."

2007-03-09 Thread Galantucci Giovanni
retry >a second insert into the table. Giovanni Galantucci -Messaggio originale- Da: Richard Huxton [mailto:[EMAIL PROTECTED] Inviato: venerdì 9 marzo 2007 14.51 A: Galantucci Giovanni Cc: pgsql-general@postgresql.org Oggetto: Re: [GENERAL] Error code associated to "c

Re: [GENERAL] Error code associated to "could not open relation with OID ..."

2007-03-09 Thread Richard Huxton
Galantucci Giovanni wrote: Hi all, I'm using jdbc to connect to a remote database and this morning I've found an SQLException on my log file with this error description: "could not open relation with OID ...". Does anyone know which error code is associated to such exception? It's usually do

[GENERAL] Error code associated to "could not open relation with OID ..."

2007-03-09 Thread Galantucci Giovanni
Hi all, I'm using jdbc to connect to a remote database and this morning I've found an SQLException on my log file with this error description: "could not open relation with OID ...". Does anyone know which error code is associated to such exception? Thanks in advance Giovanni Galantucci I

[GENERAL] error code when database does not exist

2006-07-25 Thread surabhi.ahuja
Title: [JDBC] Invalid column display size. Cannot be less than zero   i want to know what error code will be returned if the database does not exist.   i have the following list, howvere do not know which one shall be returned when database itself does not exits   http://www.postgresql.org/

Re: [GENERAL] Error code 1063

2006-07-12 Thread Magnus Hagander
> We have PostgreSQL 8.1 running on Windows 2000 for a few > weeks now, when we try to start the service, it could not > start claiming no error returned. So, I go to the command > prompt and run the following: > > "C:\Program Files\PostgreSQL\8.1\bin\pg_ctl.exe" runservice > -N "pgsql-8.1" -D

[GENERAL] Error code 1063

2006-07-11 Thread Robert Fitzpatrick
We have PostgreSQL 8.1 running on Windows 2000 for a few weeks now. Don't know what happened, the users reported a connection issue to the database and I found the service will not start. When we try to start the service, it could not start claiming no error returned. So, I go to the command prom

[GENERAL] Error code 1063

2006-07-11 Thread Robert Fitzpatrick
We have PostgreSQL 8.1 running on Windows 2000 for a few weeks now, when we try to start the service, it could not start claiming no error returned. So, I go to the command prompt and run the following: "C:\Program Files\PostgreSQL\8.1\bin\pg_ctl.exe" runservice -N "pgsql-8.1" -D "C:\Program Files

[GENERAL] Error code when trying to insert non-unique value

2001-03-23 Thread Jonas Bengtsson
Hello, How can I check if the error that has occurred during an insert is because the inserted value is not unique when there are a unique error. I'm using PHP. Thanks in advance, Jonas Bengtsson ---(end of broadcast)--- TIP 5: Have you checked ou

[GENERAL] ERROR CODE

2000-04-29 Thread Ray Alba
I am creating a new table called patienttype with categories - infant,pediatric, adult in the doctors table for some reason it allows me to create a sequence but, when I create a table that requires that sequence, I get the following. create table patienttype ( id INT DEFAULT nextval ('category_