[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: [PATCH] Add generate_bibtex.py: Make use of a separate script for generation of debian.{bib,tex} files



Hi Akshita,

On Fri, May 15, 2015 at 12:00:11PM +0530, Akshita Jha wrote:
> > $ ./update-and-run.sh generate-bibref
> > Traceback (most recent call last):
> >   File "/srv/udd.debian.org/udd//udd.py", line 54, in <module>
> >     src_config = config[src]
> > KeyError: 'generate-bibref'
> >
> >
> >
> It should be  $ ./update-and-run.sh generate-bibtex .

... I shouldn't do this kind of stuff at this time of the day.  Sorry for
the noise.

However, there seems to be some other issue:

(master) $ LC_ALL=C psql udd < sql/upgrade_bibtex.sql 
FEHLER:  Syntaxfehler bei „IF“
LINE 7:   IF sources IS NULL THEN
          ^
FEHLER:  Relation „bibtable“ existiert nicht
LINE 63: ... FROM (SELECT DISTINCT source, package, rank FROM bibtable) ...
                                                              ^

Hmmm, postgresql seems to have its own idea about locales and does not
respect shell environment.  It is something like "syntax error at  IF".
Moreover, I think you wanted do write source to verify the function
parameter, right?

BTW, I have no real clue why the IF statement is a syntax error.  While
I think the language should be plpgsql and not sql changing this did not
help as well.  In principle I consider you approach sensible but we seem
to miss some syntax detail.

Sorry, no time to track this down completely.

Kind regards

       Andreas.

-- 
http://fam-tille.de


Reply to: