Re: Help! can't create databases

OK, here's where it seems to be failing:

  INSERT INTO t_meta
    (meta_app,meta_type,meta_version,meta_create_date,meta_modify_date)
    VALUES ('refdb', 'risx', '0.9.4-pre2', ' ', ' ')
  ERROR:  invalid input syntax for type timestamp: " "
  insert into t_meta failed

Seems like it's RefDB is not generating a timestamp correctly. Maybe
it's a Cygwin-specific issue -- I'll try it on Linux and see if I get
the same error or not.

  --Mike

Michael Smith <[email protected]> writes:

> Markus Hoenicka <[email protected]> writes:
> 
> > Hi,
> > 
> > I just wanted to point out that the new listdb behaviour to only list
> > RefDB reference databases relies on a new table containing
> > meta-data. Therefore listdb will only show databases that were created
> > with a fairly recent CVS version.
> 
> I just rebuilt from latest CVS source and now can't seem to get any
> refdb databases created correctly. I filed bug #865817 -
> 
>   http://sourceforge.net/tracker/index.php?func=detail&aid=865817&group_id=26091&atid=385991
> 
> Please let me know what I'm doing wrong. I removed the old "refdb"
> database, then created a new one using the latest refdb.dump.pgsql file,
> then tried to run "refdba -C createdb foo", and the database seems to
> get created, but I get an "insert into t_meta failed" error, and the new
> db doesn't show up when I run "refdba -C listdb".
> 
>   --Mike



-- 
Michael Smith
Openwave Systems Japan     +81 90 9148 0269 (mobile)
Nishishinjuku 6-22-1       +81  3 5909 6347 (office)
Tokyo, Japan 163-1117      +81  3 5909 6241 (fax)

-----BEGIN PGP SIGNATURE-----

iD8DBQE/659XsGCNMsnBsxkRAu1WAJ9ijlesSCrfE4pSIdQDJe9zNMWd7gCeOtjo
gqSubcKPvJ+xXImIjmpg11Y=
=SHp2
-----END PGP SIGNATURE-----