Re: [BUGS] Bug #921: Default value not available in RULE

2003-03-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > Default value not available in RULE > I as using postgresql 7.2.3. Update to 7.3.*. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.o

[BUGS] Bug #921: Default value not available in RULE

2003-03-26 Thread pgsql-bugs
A.Bhuvaneswaran ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Default value not available in RULE Long Description I as using postgresql 7.2.3. The default value of a column is not available in the INSERT RULE. The same value

[BUGS] PostgreSql Server Problem

2003-03-26 Thread [EMAIL PROTECTED]
Hi, I am facing this problem when I start the PostgreSql database server and query any of the database. What might the problem? Is there any configuration settings that I might have missed out? Please help. - bwicdb=#

[BUGS] PostgreSQL book recommendation?

2003-03-26 Thread Gary Hendricks
Hi I'm thinking of buying "Practical PostgreSQL" from O'Reilly. Has anyone got any comments on this book? Can anyone suggest alternatives? My level is best described as "intermediate". Thanks in advance! ---(end of broadcast)--- TIP 4: Don't 'kil

[BUGS] Relation n does not exist when trying to ad a foregin key

2003-03-26 Thread Fabio Furia Silva
Dear all: I am having this error when I try to add a foreign key: ERROR: Relation n does not exist Here is the command: test=# alter table cep_bairro add FOREIGN KEY (cod_localidade) REFERENCES cidade (cod_localidade); NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(

Re: [BUGS] Postgresql 7.3.2 Crash

2003-03-26 Thread Stephan Szabo
On Wed, 26 Mar 2003, Adrian Pop wrote: > > > Okay, I think I've localized the cause (but not a fix). > > > > > name_id bigint not null default 0, > > > > I think the problem occurs with of the hack (mentioned in the last mail) > > because the default expression is of a differen

Re: [BUGS] Bug #920: The PostgreSql Server goes down

2003-03-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > FATAL 2: open of /usr/share/postgresql/data/pg_clog/0C81 failed: No such file or > directory This indicates corrupted data --- specifically, a trashed transaction ID in a row header. In all the cases I've been able to examine, this was just the first symptom of more

Re: [BUGS] Postgresql 7.3.2 Crash

2003-03-26 Thread Adrian Pop
On Tue, 25 Mar 2003, Stephan Szabo wrote: > Okay, I think I've localized the cause (but not a fix). > > > name_id bigint not null default 0, > > I think the problem occurs with of the hack (mentioned in the last mail) > because the default expression is of a different type.

[BUGS] Disastrous : Server shuts down abnormally

2003-03-26 Thread Kallol Nandi
Hi, I am using PostgreSql for Windows.It is running on Cygwin which creates a Unix environment. I am facing this problem when I start the PostgreSql database server and query any of the database. The message (copied below) is flashed on the console.All the processes are terminated and the dat