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
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.
[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
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
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(
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
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=#
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
[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
