Hi there,
i'm new to this mailing list(s) and just want to say hello to everybody
here. Allow to introduce myself a little.
I'm German (so, please excuse any language problems i have) and work for
an company (you see "Organization:"? ;-) as Unix- and Network Admin
(though i'm still enrolled to
I am confusing that Postgres 7.0.2 plan for a joined
query.
I have tow tables, each contains about 36000 rows. the first
tables' structure likes following:
username varchar(20) primary key,
other columns;
and the 2nd table's structure:
username varchar(20) primary key,
other
Hi,
I am using Postgresql 7.0.2, and have used some
foreign key in my database, but I get some error like "the backend ended the
connection" where I am trying to insert or delete a row to the master
table(Delete cascade and update cascade). Of course, this error is no use to
find
Have you renamed any tables used in the foreign keys
(or dumped and restored with different names or some
missing tables). Under 7.0.2 and earlier there is
a problem with postgres crashing if a constraint trigger
has bad values (due to renames or incomplete restores).
This should be fixed for 7.
> please help in starting the postmaster and keeping it in the same state
> always ..ie started , i'm a beginner, i tried
> pg_ctl,postmaster,postgres...
Read the INSTALL file with the source, it should tell you alot.
> my database is kept in a dir where permission is denied to the user ,
Which u
This happens for me when the tables referenced in the foreign key don't
exisit. Hope that helps!
Gavin
lt wrote:
Hi,
I am using Postgresql 7.0.2, and have used some foreign key in my database,
but I get some error like "the backend ended the connection" where I am
trying to insert or delete
Anton Kalauzky wrote:
[Problem with sort order in RH 6.1 upgraded to 6.2 versus straight 6.2
install]
> So, do you have any idea about solving this problem? Thank you for your
> time.
This is due to the collation sequence set up in RH 6.2 when you do a
fresh install. The upgrade doesn't touch t
Lamar Owen <[EMAIL PROTECTED]> writes:
> Anton Kalauzky wrote:
> [Problem with sort order in RH 6.1 upgraded to 6.2 versus straight 6.2
> install]
>
> > So, do you have any idea about solving this problem? Thank you for your
> > time.
>
> This is due to the collation sequence set up in RH 6.2 w
