Mark Bixby writes:
> Creating global relations in /blah/blah/blah
> ERROR: pg_atoi: error in "BIXBY": can't parse "BIXBY"
> ERROR: pg_atoi: error in "BIXBY": can't parse "BIXBY"
> syntax error 25 : -> .
I'm curious about that last line. Is that the shell complaining?
The offending command seems to be
insert OID = 0 ( POSTGRES PGUID t t t t _null_ _null_ )
in the file global1.bki.source. (This is the file the creates the global
relations.) The POSTGRES and PGUID quantities are substituted when initdb
runs:
cat "$GLOBAL" \
| sed -e "s/POSTGRES/$POSTGRES_SUPERUSERNAME/g" \
-e "s/PGUID/$POSTGRES_SUPERUSERID/g" \
| "$PGPATH"/postgres $BACKENDARGS template1
For some reason the line probably ends up being
insert OID = 0 ( MGR BIXBY 484 t t t t _null_ _null_ )
^
which causes the observed failure to parse BIXBY as user id. This brings
us back to why the dot disappears, which seems to be related to the error
message
syntax error 25 : -> .
^^^
Can you try using a different a sed command (e.g, GNU sed)?
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
