Re: [Refdb-devel] Help! can't create databases

[Michael S. <sm...@xm...>]

It's a Cygwin problem. Works fine on Linux.

  --Mike

Michael Smith <sm...@xm...> writes:

> 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 <sm...@xm...> writes:
> 
> > Markus Hoenicka <mar...@mh...> 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)