Re: Help! can't create databases

It appears that the cause for this is that Cygwin 'strftime' doesn't
support %F and %T. So I think refdbda.c needs to use %Y-%m-%d and
%H:%M:%S instead. I noticed the %F and %T format specifiers are also
%used in refdbdref.c, so I think it'll need to be changed there too.

Diffs attached (tar'ed to keep my mailer from munging the backslashes).

  --Mike

Michael Smith <[email protected]> writes:

> It's a Cygwin problem. Works fine on Linux.
> 
>   --Mike
> 
> Michael Smith <[email protected]> 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 <[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".

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

iD8DBQE/6918sGCNMsnBsxkRAh28AJ9K03a77RRqkloa8Qn4bs/+XhafKgCfeK5g
oYqoC0D5adPrfkyTrMyZk7A=
=+M0D
-----END PGP SIGNATURE-----