[GENERAL] [ADMIN] initdb on postgresql 7.1.2 running under cygwin on win 2000

[Steve SAUTETNER]

Hello !

I've got a little problem with launching initdb on postgresql 7.1.2 under
cygwin :

when i launch it, it says :

$ initdb -d -n -D $PG_DATA
Running with debug mode on.
Running with noclean mode on. Mistakes will not be cleaned up.

Initdb variables:
  PGDATA=/data/pgsql
  datadir=/usr/share/postgresql
  PGPATH=/usr/bin
  TEMPFILE=/tmp/initdb.412
  MULTIBYTE=SQL_ASCII
  MULTIBYTEID=0
  POSTGRES_SUPERUSERNAME=ssautetn
  POSTGRES_SUPERUSERID=1003
  TEMPLATE1_BKI=/usr/share/postgresql/template1.bki
  GLOBAL_BKI=/usr/share/postgresql/global.bki
  TEMPLATE1_DESCR=/usr/share/postgresql/template1.description
  GLOBAL_DESCR=/usr/share/postgresql/global.description
  POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample
  PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample
  PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample
This database system will be initialized with username "ssautetn".
This user will own all the data files and must also own the server process.

Creating directory /data/pgsql
Creating directory /data/pgsql/base
Creating directory /data/pgsql/global
Creating directory /data/pgsql/pg_xlog
Creating template1 database in /data/pgsql/base/1
Running: /usr/bin/postgres -boot -x1 -C -F -D/data/pgsql -d template1

and then the postgres process freezes and take 100 % of cpu, never creating
the template1 files, so i must kill it.

As anyone an idea on what's happening ?
thank's.


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] concurent updates

[Steve SAUTETNER]

hi everybody !

I've got a little problem when updating a primary key in two table
where the primary key of the one is a foreign key from the second :

here are the 2 tables :

create table table1 (id int primary key, col1 int);
create table table2 (id int primary key references table1(id), col2 int);

and the 2 updates :

1) update table2 set id = 1001 where id = 1;
2) update table1 set id = 1001 where id = 1;

i can't execute them separately because of an integrity constraint
violation.
i've got the same error in a BEGIN / COMMIT block containing the updates.

Does any one see how two help me ?

thanks.


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])