[ADMIN] ERROR: invalid page header in block

Hello,   I have the following error and I'm a bit worried:   SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "public"."lock") AS sub -> ERROR: invalid page header in block 0 of relation "lock"delete from lock where bildschirmnr=16-> ERROR:  invalid page header in block 0 of relation "lock"

[ADMIN] PostgreSQL 8.1.4 - INITDB - database postgres ?

Hello,   we are trying to install PostgreSQL 8.1.4.   We noticed that when you run initdb, there will be a databes postgres.   We found this in the documentation: Creating a database cluster consists of creating the directories in which the database data will live, generating the shared catalo

[ADMIN] sql-statement blocks maschine

Hello,   we are using PostgreSQL 8.0.3 under SuSE Linux 9.2 and SCO OpenServer 6.0 and have some perfomance problems. We are working with telnet-clients, which controlls our application on the server. The application does the sql-statements   If we have sql-statements e.g. SELECT or UPDATE wh

[ADMIN] Starten Server / SCO OpenServer6 / PostgreSQL 8.0.3

Hello,   I get the following messages when starting the PostgreSQL-Server. What does the LOG message mean?   Regards Michaela   $ /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/datapostmaster starting$ LOG:  could not bind IPv6 socket: Network is unreachableHINT:  Is another postmaster

[ADMIN] Question to localization

Hello,   I have a question to the usage of locale.   In the PostgreSQL 8.0.3 Documentation is written: "The drawback of using locales other than C or POSIX in PostgreSQL is its performance impact. It slows character handling and prevents ordinary indexes from being used by LIKE. For this reas

Re: [ADMIN] ALTER TABLE for field modify...

David Stanaway <[EMAIL PROTECTED]> wrote: > In this case the row is ID (Case sensitive) so whenever > you refer to it you must refer to it as "ID" > ... > > > proba=# alter table tabla1 drop constraint ID not null; > > Here you refer to it as ID which is case folded to id and > does not refer

Re: [ADMIN] ALTER TABLE for field modify...

On 03-May-2002 Nick Fankhauser wrote: > alter table drop constraint ID unique; > alter table drop constraint ID not null; > > alter table add constraint ID references table2 ; > Hi! It not works. :( I try it: proba=# create table "tabla1" ("ID" int8 NOT NULL UNIQUE, "nev" varchar(20) ); NO

Re: [ADMIN] ALTER TABLE for field modify...

On 03-May-2002 Nick Fankhauser wrote: > alter table drop constraint ID unique; > alter table drop constraint ID not null; > > alter table add constraint ID references table2 ; > Hi! It not works... :( How can I change the properties of a field? Bye! - Linux RedHat 7.1

[ADMIN] ALTER TABLE for field modify...

Hi! How can I modify a field of table with ALTER TABLE? I want to modify the constraint. The TABLE is now: "ID"int8NOT NULL, UNIQUE But I want this: "ID" int8 REFERENCE "table2" THanx! Bye! - Linux RedHat 7.1 - ---(end of

Re: [ADMIN] PgSQL postmaster.opts

On 29-Mar-2002 Bruce Momjian wrote: > > That file is not for user changes. It gets written on every postmaster > restart. Either change these in postgresql.conf or on the command line. > The "postgresql.conf" file doesn't exist in RedHat. :( But "/var/lib/pgsql/data/pg_options" file exists. I

[ADMIN] PgSQL postmaster.opts

Hi! I subsrcibed to this list again. :) I use the version7.0.3-8 of pgsql from RedHat rpm. I have a problem. The "/var/lib/pgsql/data/postmaster.opts" file contains this: /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data -B 64 -b /usr/bin/postgres -i -N 32 If I modify it (for examlpes, -N 16

[ADMIN] table permissions

Hi! I subscribe to this list now. :) I have a question. How can I query (in SQL) the user permissions of a table? Which system table stores the tables permissions for the user? Bye! Linux Redhat 7.1 ---(end of broadcast)