Topics

Ninka, on license names: an example

dmg
 

Some people have been asking for it. We finally have a pre-release. You
can download it from:

http://turingmachine.org/~dmg/temp/ninka-1.0-pre1.tar.bz2 (licensed AGPLv3)

I have discussed with Kate that I am going to start unifying names of
licenses with Fossology.

We decided to start looking at several projects, and see how
similar/different our identification is. Here is the first example:
postgresql. This is from the RPM of Fedora 12 (identical to Fedora 13, I
think). These are the "source code" files where we detected there is a
license.

contrib/pgcrypto/fortuna.c;BSD2
contrib/pgcrypto/fortuna.h;BSD2
contrib/pgcrypto/internal.c;BSD2
contrib/pgcrypto/internal-sha2.c;BSD2
contrib/pgcrypto/mbuf.c;BSD2
contrib/pgcrypto/mbuf.h;BSD2
contrib/pgcrypto/openssl.c;BSD2
contrib/pgcrypto/pgcrypto.c;BSD2
contrib/pgcrypto/pgcrypto.h;BSD2
contrib/pgcrypto/pgp-armor.c;BSD2
contrib/pgcrypto/pgp.c;BSD2
contrib/pgcrypto/pgp-cfb.c;BSD2
contrib/pgcrypto/pgp-compress.c;BSD2
contrib/pgcrypto/pgp-decrypt.c;BSD2
contrib/pgcrypto/pgp-encrypt.c;BSD2
contrib/pgcrypto/pgp.h;BSD2
contrib/pgcrypto/pgp-info.c;BSD2
contrib/pgcrypto/pgp-mpi.c;BSD2
contrib/pgcrypto/pgp-mpi-internal.c;BSD2
contrib/pgcrypto/pgp-mpi-openssl.c;BSD2
contrib/pgcrypto/pgp-pgsql.c;BSD2
contrib/pgcrypto/pgp-pubdec.c;BSD2
contrib/pgcrypto/pgp-pubenc.c;BSD2
contrib/pgcrypto/pgp-pubkey.c;BSD2
contrib/pgcrypto/pgp-s2k.c;BSD2
contrib/pgcrypto/px.c;BSD2
contrib/pgcrypto/px-crypt.c;BSD2
contrib/pgcrypto/px-crypt.h;BSD2
contrib/pgcrypto/px.h;BSD2
contrib/pgcrypto/px-hmac.c;BSD2
contrib/pgcrypto/random.c;BSD2
contrib/pgcrypto/crypt-des.c;BSD3
contrib/pgcrypto/md5.c;BSD3
contrib/pgcrypto/md5.h;BSD3
contrib/pgcrypto/sha1.c;BSD3
contrib/pgcrypto/sha1.h;BSD3
contrib/pgcrypto/sha2.c;BSD3
contrib/pgcrypto/sha2.h;BSD3
src/backend/port/dynloader/freebsd.c;BSD3
src/backend/port/dynloader/netbsd.c;BSD3
src/backend/port/dynloader/openbsd.c;BSD3
src/backend/utils/mb/wstrcmp.c;BSD3
src/backend/utils/mb/wstrncmp.c;BSD3
src/port/crypt.c;BSD3
src/port/getopt_long.c;BSD3
src/port/inet_aton.c;BSD3
src/port/memcmp.c;BSD3
src/port/qsort_arg.c;BSD3
src/port/qsort.c;BSD3
src/port/snprintf.c;BSD3
src/port/strtol.c;BSD3
src/port/strtoul.c;BSD3
src/port/getopt.c;BSD3NoWarranty
contrib/cube/cubeparse.c;GPLv2+,BisonException
contrib/seg/segparse.c;GPLv2+,BisonException
src/backend/bootstrap/bootparse.c;GPLv2+,BisonException
src/backend/parser/gram.c;GPLv2+,BisonException
src/backend/parser/gram.h;GPLv2+,BisonException
src/interfaces/ecpg/preproc/preproc.c;GPLv2+,BisonException
src/interfaces/ecpg/preproc/preproc.h;GPLv2+,BisonException
src/pl/plpgsql/src/pl_gram.c;GPLv2+,BisonException
src/pl/plpgsql/src/pl_gram.h;GPLv2+,BisonException
src/port/strlcat.c;MIToldwithoutSellandNoDocumentationRequi
src/port/strlcpy.c;MIToldwithoutSellandNoDocumentationRequi
contrib/pgcrypto/blf.c;MITX11noNotice
contrib/pgcrypto/blf.h;MITX11noNotice
contrib/pgcrypto/imath.c;MITX11noNotice
contrib/pgcrypto/imath.h;MITX11noNotice
src/backend/utils/adt/inet_net_ntop.c;MITX11NoSellNoDocDocBSDvar
src/backend/utils/adt/inet_net_pton.c;MITX11NoSellNoDocDocBSDvar
contrib/fuzzystrmatch/dmetaphone.c;postgresql
contrib/pageinspect/btreefuncs.c;postgresql
contrib/pgrowlocks/pgrowlocks.c;postgresql
contrib/pgstattuple/pgstatindex.c;postgresql
contrib/pgstattuple/pgstattuple.c;postgresql
src/port/gettimeofday.c;postgresql
src/bin/pg_dump/pg_backup_archiver.c;SeeFile
src/bin/pg_dump/pg_backup_archiver.h;SeeFile
src/bin/pg_dump/pg_backup_custom.c;SeeFile
src/bin/pg_dump/pg_backup_files.c;SeeFile
src/bin/pg_dump/pg_backup.h;SeeFile
src/bin/pg_dump/pg_backup_null.c;SeeFile
src/bin/pg_dump/pg_backup_tar.c;SeeFile
src/include/windowapi.h;SeeFile
src/test/thread/thread_test.c;SeeFile
src/pl/plperl/ppport.h;SeeFile,SameAsPerl
src/timezone/strftime.c;UNKNOWN [AllRights,0,,,,BSDpreLike,70,, the Univers=
ity of California, Berkeley,BSDcondEndorse,71,,,name of the University,BSDa=
sIs,80,,]
src/backend/regex/regc_color.c;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN=
,1,Redistribution and use in source and binary forms -- with or without mod=
ification -- are permitted for any purpose, provided that redistributions i=
n source form retain this entire copyright notice and indicate the origin a=
nd nature of any modifications,<------------>[Redistribution and use in sou=
rce and binary forms -- with or without modification -- are permitted for a=
ny purpose, provided that redistributions in source form retain this entire=
copyright notice and indicate the origin and nature of any modifications][=
],BSDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/backend/regex/regc_cvec.c;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,=
1,Redistribution and use in source and binary forms -- with or without modi=
fication -- are permitted for any purpose, provided that redistributions in=
source form retain this entire copyright notice and indicate the origin an=
d nature of any modifications,<------------>[Redistribution and use in sour=
ce and binary forms -- with or without modification -- are permitted for an=
y purpose, provided that redistributions in source form retain this entire =
copyright notice and indicate the origin and nature of any modifications][]=
,BSDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/backend/regex/regc_lex.c;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,1=
,Redistribution and use in source and binary forms -- with or without modif=
ication -- are permitted for any purpose, provided that redistributions in =
source form retain this entire copyright notice and indicate the origin and=
nature of any modifications,<------------>[Redistribution and use in sourc=
e and binary forms -- with or without modification -- are permitted for any=
purpose, provided that redistributions in source form retain this entire c=
opyright notice and indicate the origin and nature of any modifications][],=
BSDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/backend/regex/regc_nfa.c;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,1=
,Redistribution and use in source and binary forms -- with or without modif=
ication -- are permitted for any purpose, provided that redistributions in =
source form retain this entire copyright notice and indicate the origin and=
nature of any modifications,<------------>[Redistribution and use in sourc=
e and binary forms -- with or without modification -- are permitted for any=
purpose, provided that redistributions in source form retain this entire c=
opyright notice and indicate the origin and nature of any modifications][],=
BSDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/backend/regex/rege_dfa.c;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,1=
,Redistribution and use in source and binary forms -- with or without modif=
ication -- are permitted for any purpose, provided that redistributions in =
source form retain this entire copyright notice and indicate the origin and=
nature of any modifications,<------------>[Redistribution and use in sourc=
e and binary forms -- with or without modification -- are permitted for any=
purpose, provided that redistributions in source form retain this entire c=
opyright notice and indicate the origin and nature of any modifications][],=
BSDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/backend/regex/regerror.c;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,1=
,Redistribution and use in source and binary forms -- with or without modif=
ication -- are permitted for any purpose, provided that redistributions in =
source form retain this entire copyright notice and indicate the origin and=
nature of any modifications,<------------>[Redistribution and use in sourc=
e and binary forms -- with or without modification -- are permitted for any=
purpose, provided that redistributions in source form retain this entire c=
opyright notice and indicate the origin and nature of any modifications][],=
BSDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/backend/regex/regexec.c;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,1,=
Redistribution and use in source and binary forms -- with or without modifi=
cation -- are permitted for any purpose, provided that redistributions in s=
ource form retain this entire copyright notice and indicate the origin and =
nature of any modifications,<------------>[Redistribution and use in source=
and binary forms -- with or without modification -- are permitted for any =
purpose, provided that redistributions in source form retain this entire co=
pyright notice and indicate the origin and nature of any modifications][],B=
SDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/backend/regex/regfree.c;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,1,=
Redistribution and use in source and binary forms -- with or without modifi=
cation -- are permitted for any purpose, provided that redistributions in s=
ource form retain this entire copyright notice and indicate the origin and =
nature of any modifications,<------------>[Redistribution and use in source=
and binary forms -- with or without modification -- are permitted for any =
purpose, provided that redistributions in source form retain this entire co=
pyright notice and indicate the origin and nature of any modifications][],B=
SDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/include/regex/regcustom.h;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,=
1,Redistribution and use in source and binary forms -- with or without modi=
fication -- are permitted for any purpose, provided that redistributions in=
source form retain this entire copyright notice and indicate the origin an=
d nature of any modifications,<------------>[Redistribution and use in sour=
ce and binary forms -- with or without modification -- are permitted for an=
y purpose, provided that redistributions in source form retain this entire =
copyright notice and indicate the origin and nature of any modifications][]=
,BSDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/include/regex/regex.h;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,1,Re=
distribution and use in source and binary forms -- with or without modifica=
tion -- are permitted for any purpose, provided that redistributions in sou=
rce form retain this entire copyright notice and indicate the origin and na=
ture of any modifications,<------------>[Redistribution and use in source a=
nd binary forms -- with or without modification -- are permitted for any pu=
rpose, provided that redistributions in source form retain this entire copy=
right notice and indicate the origin and nature of any modifications][],BSD=
asIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/include/regex/regguts.h;UUNMATCHED [AllRights,0,,,,UNKNOWN,0,UNKNOWN,1,=
Redistribution and use in source and binary forms -- with or without modifi=
cation -- are permitted for any purpose, provided that redistributions in s=
ource form retain this entire copyright notice and indicate the origin and =
nature of any modifications,<------------>[Redistribution and use in source=
and binary forms -- with or without modification -- are permitted for any =
purpose, provided that redistributions in source form retain this entire co=
pyright notice and indicate the origin and nature of any modifications][],B=
SDasIs,70,,,<quotes>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
contrib/dblink/dblink.c;UUNMATCHED [AllRights-TOOLONG,0,pgsql/contrib/dblin=
k/dblink.c,v 1.82.2.2 2010/02/03 23<colon>01<colon>23 joe Exp $ Copyright (=
c) 2001-2009, PostgreSQL Global Development Group ,,,psql,10,,,UNKNOWN,0,UN=
KNOWN,1,IN NO EVENT SHALL THE AUTHOR OR DISTRIBUTORS BE LIABLE TO ANY PARTY=
FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLU=
DING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENT=
ATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISED OF THE POSSIBIL=
ITY OF SUCH DAMAGE,<------------>[IN NO EVENT SHALL THE AUTHOR OR DISTRIBUT=
ORS BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CO=
NSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS=
SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BE=
EN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE][],psqlWarr,10,,,AUTHOR AND DI=
STRIBUTORS,psqlWarr2,10,,,THE AUTHOR AND DISTRIBUTORS]
contrib/dblink/dblink.h;UUNMATCHED [AllRights-TOOLONG,0,pgsql/contrib/dblin=
k/dblink.h,v 1.22 2009/06/09 17<colon>41<colon>02 tgl Exp $ Copyright (c) 2=
001-2009, PostgreSQL Global Development Group ,,,psql,10,,,UNKNOWN,0,UNKNOW=
N,1,IN NO EVENT SHALL THE AUTHOR OR DISTRIBUTORS BE LIABLE TO ANY PARTY FOR=
DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING=
LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATIO=
N, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISED OF THE POSSIBILITY =
OF SUCH DAMAGE,<------------>[IN NO EVENT SHALL THE AUTHOR OR DISTRIBUTORS =
BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQ=
UENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOF=
TWARE AND ITS DOCUMENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN A=
DVISED OF THE POSSIBILITY OF SUCH DAMAGE][],psqlWarr,10,,,AUTHOR AND DISTRI=
BUTORS,psqlWarr2,10,,,THE AUTHOR AND DISTRIBUTORS]
contrib/fuzzystrmatch/fuzzystrmatch.c;UUNMATCHED [AllRights-TOOLONG,0,pgsql=
/contrib/fuzzystrmatch/fuzzystrmatch.c,v 1.30.2.1 2009/12/10 01<colon>54<co=
lon>21 rhaas Exp $ Copyright (c) 2001-2009, PostgreSQL Global Development G=
roup ,,,psql,10,,,UNKNOWN,0,UNKNOWN,1,IN NO EVENT SHALL THE AUTHORS OR DIST=
RIBUTORS BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, =
OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF=
THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HA=
VE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE,<------------>[IN NO EVEN=
T SHALL THE AUTHORS OR DISTRIBUTORS BE LIABLE TO ANY PARTY FOR DIRECT, INDI=
RECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS=
, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF TH=
E AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAG=
E][],UNKNOWN,0,UNKNOWN,1,THE AUTHORS AND DISTRIBUTORS SPECIFICALLY DISCLAIM=
ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF M=
ERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE,<------------>[THE AUTH=
ORS AND DISTRIBUTORS SPECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT N=
OT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A =
PARTICULAR PURPOSE][],psqlWarr2,10,,,THE AUTHOR AND DISTRIBUTORS]
contrib/pgbench/pgbench.c;UUNMATCHED [AllRights-TOOLONG,0,pgsql/contrib/pgb=
ench/pgbench.c,v 1.87.2.1 2009/07/30 09<colon>28<colon>05 mha Exp $ Copyrig=
ht (c) 2000-2009, PostgreSQL Global Development Group ,,,psql,10,,,UNKNOWN,=
0,UNKNOWN,1,IN NO EVENT SHALL THE AUTHOR OR DISTRIBUTORS BE LIABLE TO ANY P=
ARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, I=
NCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCU=
MENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISED OF THE POSS=
IBILITY OF SUCH DAMAGE,<------------>[IN NO EVENT SHALL THE AUTHOR OR DISTR=
IBUTORS BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, O=
R CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF =
THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAV=
E BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE][],psqlWarr,10,,,AUTHOR AN=
D DISTRIBUTORS,psqlWarr2,10,,,THE AUTHOR AND DISTRIBUTORS]
contrib/tablefunc/tablefunc.c;UUNMATCHED [psql,10,,,UNKNOWN,0,UNKNOWN,1,IN =
NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE LIABLE TO ANY PARTY FOR DIREC=
T, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST =
PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVE=
N IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUC=
H DAMAGE,<------------>[IN NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE LI=
ABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTI=
AL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE=
AND ITS DOCUMENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISE=
D OF THE POSSIBILITY OF SUCH DAMAGE][],UNKNOWN,0,UNKNOWN,1,THE AUTHORS AND =
DISTRIBUTORS SPECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT NOT LIMIT=
ED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICUL=
AR PURPOSE,<------------>[THE AUTHORS AND DISTRIBUTORS SPECIFICALLY DISCLAI=
M ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF =
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE][],psqlWarr2,10,,,THE =
AUTHOR AND DISTRIBUTORS]
contrib/tablefunc/tablefunc.h;UUNMATCHED [psql,10,,,UNKNOWN,0,UNKNOWN,1,IN =
NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE LIABLE TO ANY PARTY FOR DIREC=
T, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST =
PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVE=
N IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUC=
H DAMAGE,<------------>[IN NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE LI=
ABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTI=
AL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE=
AND ITS DOCUMENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISE=
D OF THE POSSIBILITY OF SUCH DAMAGE][],UNKNOWN,0,UNKNOWN,1,THE AUTHORS AND =
DISTRIBUTORS SPECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT NOT LIMIT=
ED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICUL=
AR PURPOSE,<------------>[THE AUTHORS AND DISTRIBUTORS SPECIFICALLY DISCLAI=
M ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF =
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE][],psqlWarr2,10,,,THE =
AUTHOR AND DISTRIBUTORS]
src/include/utils/catcache.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,All cache fetc=
hes are done with indexscans (under normal conditions),<------------>[All c=
ache fetches are done with indexscans (under normal conditions)][]]
src/bin/psql/tab-complete.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Also it does no=
t always give you all the syntactically legal completions, only those that =
are the most common or the ones that the programmer felt most like implemen=
ting,<------------>[Also it does not always give you all the syntactically =
legal completions, only those that are the most common or the ones that the=
programmer felt most like implementing][]]
src/test/regress/sql/inherit.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,ALTER TABL=
E inhx add constraint foo CHECK (xx =3D <quotes>text<quotes>)
src/include/catalog/pg_amop.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,amoplefttype =
and amoprighttype are just copies of the operator<quotes>s oprleft/oprright=
, ie its declared input data types,<------------>[amoplefttype and amoprigh=
ttype are just copies of the operator<quotes>s oprleft/oprright, ie its dec=
lared input data types][]]
src/interfaces/libpq/fe-misc.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,As is, block=
and restart will cause repeat printouts,<------------>[As is, block and re=
start will cause repeat printouts][]]
src/backend/storage/ipc/procarray.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Because=
of various subtle race conditions it is critical that a backend hold the c=
orrect locks while setting or clearing its MyProc->xid field,<------------>=
[Because of various subtle race conditions it is critical that a backend ho=
ld the correct locks while setting or clearing its MyProc->xid field][]]
src/include/utils/portal.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Because the quer=
y rewriter does not allow arbitrary ON SELECT rewrite rules, only queries t=
hat were originally update-type could produce multiple plan trees
src/test/regress/sql/text.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,But as a spec=
ial exception for usability<quotes>s sake, we still allow implicit casting =
to text in concatenations, so long as the other input is text or an unknown=
literal,<------------>[But as a special exception for usability<quotes>s s=
ake, we still allow implicit casting to text in concatenations, so long as =
the other input is text or an unknown literal][]]
src/interfaces/ecpg/preproc/ecpg.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,(C) Mich=
ael Meskes <meskes@...> Feb 5th, 1998 Placed under the same lice=
nse as PostgreSQL,<------------>[(C) Michael Meskes <meskes@...>=
Feb 5th, 1998 Placed under the same license as PostgreSQL][]]
src/port/copydir.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,copydir.c copies a direc=
tory,<------------>[copydir.c copies a directory][]]
contrib/pgcrypto/rijndael.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Copyright in th=
is implementation is held by Dr B R Gladman but I hereby give permission fo=
r its free direct or derivative use subject to acknowledgment of its origin=
and compliance with any conditions that the originators of the algorithm p=
lace on its exploitation,<------------>[Copyright in this implementation is=
held by Dr B R Gladman but I hereby give permission for its free direct or=
derivative use subject to acknowledgment of its origin and compliance with=
any conditions that the originators of the algorithm place on its exploita=
tion][]]
contrib/pgcrypto/rijndael.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Copyright in th=
is implementation is held by Dr B R Gladman but I hereby give permission fo=
r its free direct or derivative use subject to acknowledgment of its origin=
and compliance with any conditions that the originators of the algorithm p=
lace on its exploitation,<------------>[Copyright in this implementation is=
held by Dr B R Gladman but I hereby give permission for its free direct or=
derivative use subject to acknowledgment of its origin and compliance with=
any conditions that the originators of the algorithm place on its exploita=
tion][]]
src/test/regress/sql/plancache.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,create f=
unction cachebug() returns void as $$ declare r int
src/test/regress/sql/triggers.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,CREATE FU=
NCTION trigger_func() RETURNS trigger LANGUAGE plpgsql AS <quotes> BEGIN RA=
ISE NOTICE <quotes>trigger_func() called<colon>,<------------>[CREATE FUNCT=
ION trigger_func() RETURNS trigger LANGUAGE plpgsql AS <quotes> BEGIN RAISE=
NOTICE <quotes>trigger_func() called<colon>][],UNKNOWN,0,UNKNOWN,1,create =
function trigtest() returns trigger as $$ begin raise notice <quotes>% % % =
%<quotes>, TG_RELNAME, TG_OP, TG_WHEN, TG_LEVEL
src/backend/catalog/information_schema.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,=
CREATE SCHEMA information_schema
src/pl/plperl/sql/plperl_trigger.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,define=
d $val) { elog(NOTICE, <quotes> $_TD-> {$key } =3D NULL<quotes>)
src/backend/executor/execProcnode.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,ExecIni=
tNode() notices that it is looking at a nest loop and as the code below dem=
onstrates, it calls ExecInitNestLoop(),<------------>[ExecInitNode() notice=
s that it is looking at a nest loop and as the code below demonstrates, it =
calls ExecInitNestLoop()][]]
src/test/regress/sql/dependency.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,GRANT S=
ELECT ON TABLE deptest TO GROUP regression_group
src/backend/catalog/system_views.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,GRANT =
SELECT, UPDATE ON pg_settings TO PUBLIC,<------------>[GRANT SELECT, UPDATE=
ON pg_settings TO PUBLIC][]]
src/test/regress/sql/numerology.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,GROUP B=
Y a result column name is not legal per SQL92, but we accept it anyway (if =
the name is not the name of any column exposed by FROM),<------------>[GROU=
P BY a result column name is not legal per SQL92, but we accept it anyway (=
if the name is not the name of any column exposed by FROM)][]]
src/interfaces/ecpg/include/sqlca.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,if <quo=
tes>W<quotes> a (hopefully) non-fatal notice occurred / 3<colon>,<---------=
--->[if <quotes>W<quotes> a (hopefully) non-fatal notice occurred / 3<colon=
][]]
src/test/regress/sql/polymorphism.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Legen=
d<colon>,<------------>[Legend<colon>][],UNKNOWN,0,UNKNOWN,1,test inlining =
of polymorphic SQL functions create function bleat(int) returns int as $$ b=
egin raise notice <quotes>bleat %<quotes>, $1
src/pl/plperl/sql/plperl_elog.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,my $msg =
=3D shift
src/backend/libpq/pqformat.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Note in partic=
ular the distinction between <quotes>raw data<quotes> and <quotes>text<quot=
es>
src/backend/executor/nodeAgg.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Notice that =
advance_transition_function() is coded to avoid a data copy step when the p=
revious transition value pointer is returned,<------------>[Notice that adv=
ance_transition_function() is coded to avoid a data copy step when the prev=
ious transition value pointer is returned][]]
src/backend/optimizer/geqo/geqo_copy.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Perm=
ission is hereby granted to copy all or any part of this program for free d=
istribution,<------------>[Permission is hereby granted to copy all or any =
part of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The autho=
r<quotes>s name and this copyright notice must be included in any copy,<---=
--------->[The author<quotes>s name and this copyright notice must be inclu=
ded in any copy][]]
src/backend/optimizer/geqo/geqo_cx.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Permis=
sion is hereby granted to copy all or any part of this program for free dis=
tribution,<------------>[Permission is hereby granted to copy all or any pa=
rt of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The author<=
quotes>s name and this copyright notice must be included in any copy,<-----=
------->[The author<quotes>s name and this copyright notice must be include=
d in any copy][]]
src/backend/optimizer/geqo/geqo_erx.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Permi=
ssion is hereby granted to copy all or any part of this program for free di=
stribution,<------------>[Permission is hereby granted to copy all or any p=
art of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The author=
<quotes>s name and this copyright notice must be included in any copy,<----=
-------->[The author<quotes>s name and this copyright notice must be includ=
ed in any copy][]]
src/backend/optimizer/geqo/geqo_mutation.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,=
Permission is hereby granted to copy all or any part of this program for fr=
ee distribution,<------------>[Permission is hereby granted to copy all or =
any part of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The a=
uthor<quotes>s name and this copyright notice must be included in any copy,=
<------------>[The author<quotes>s name and this copyright notice must be i=
ncluded in any copy][]]
src/backend/optimizer/geqo/geqo_ox1.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Permi=
ssion is hereby granted to copy all or any part of this program for free di=
stribution,<------------>[Permission is hereby granted to copy all or any p=
art of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The author=
<quotes>s name and this copyright notice must be included in any copy,<----=
-------->[The author<quotes>s name and this copyright notice must be includ=
ed in any copy][]]
src/backend/optimizer/geqo/geqo_ox2.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Permi=
ssion is hereby granted to copy all or any part of this program for free di=
stribution,<------------>[Permission is hereby granted to copy all or any p=
art of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The author=
<quotes>s name and this copyright notice must be included in any copy,<----=
-------->[The author<quotes>s name and this copyright notice must be includ=
ed in any copy][]]
src/backend/optimizer/geqo/geqo_pmx.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Permi=
ssion is hereby granted to copy all or any part of this program for free di=
stribution,<------------>[Permission is hereby granted to copy all or any p=
art of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The author=
<quotes>s name and this copyright notice must be included in any copy,<----=
-------->[The author<quotes>s name and this copyright notice must be includ=
ed in any copy][]]
src/backend/optimizer/geqo/geqo_px.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Permis=
sion is hereby granted to copy all or any part of this program for free dis=
tribution,<------------>[Permission is hereby granted to copy all or any pa=
rt of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The author<=
quotes>s name and this copyright notice must be included in any copy,<-----=
------->[The author<quotes>s name and this copyright notice must be include=
d in any copy][]]
src/backend/optimizer/geqo/geqo_selection.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1=
,Permission is hereby granted to copy all or any part of this program for f=
ree distribution,<------------>[Permission is hereby granted to copy all or=
any part of this program for free distribution][],UNKNOWN,0,UNKNOWN,1,The =
author<quotes>s name and this copyright notice must be included in any copy=
,<------------>[The author<quotes>s name and this copyright notice must be =
included in any copy][]]
src/bin/pg_dump/pg_dump.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,pg_dump will read=
the system catalogs in a database and dump out a script that reproduces th=
e schema in terms of SQL that is understood by PostgreSQL,<------------>[pg=
_dump will read the system catalogs in a database and dump out a script tha=
t reproduces the schema in terms of SQL that is understood by PostgreSQL][]]
src/bin/pg_dump/pg_restore.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,pg_restore wil=
l read the backup archive and dump out a script that reproduces the schema =
of the database in terms of user-defined types user-defined functions table=
s indexes aggregates operators ACL - grant/revoke,<------------>[pg_restore=
will read the backup archive and dump out a script that reproduces the sch=
ema of the database in terms of user-defined types user-defined functions t=
ables indexes aggregates operators ACL - grant/revoke][],UNKNOWN,0,UNKNOWN,=
1,Copyright (c) 2000, Philip Warner Rights are granted to use this software=
in any way so long as this notice is not removed,<------------>[Copyright =
(c) 2000, Philip Warner Rights are granted to use this software in any way =
so long as this notice is not removed][],UNKNOWN,0,UNKNOWN,1,The author is =
not responsible for loss or damages that may result from its use,<---------=
--->[The author is not responsible for loss or damages that may result from=
its use][]]
src/interfaces/ecpg/preproc/parse.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Placed=
under the same license as PostgreSQL,<------------>[Placed under the same =
license as PostgreSQL][]]
src/pl/plpython/sql/plpython_function.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,p=
lpy.notice(<quotes>import socket failed -- %s<quotes> % str(ex)) return <qu=
otes>failed as expected<quotes> return <quotes>succeeded, that wasn<quotes>=
t supposed to happen<quotes> LANGUAGE plpythonu,<------------>[plpy.notice(=
<quotes>import socket failed -- %s<quotes> % str(ex)) return <quotes>failed=
as expected<quotes> return <quotes>succeeded, that wasn<quotes>t supposed =
to happen<quotes> LANGUAGE plpythonu][],UNKNOWN,0,UNKNOWN,1,plpy.notice(<qu=
otes>import failed -- %s<quotes> % str(ex)) return <quotes>failed, that was=
n<quotes>t supposed to happen<quotes> return <quotes>succeeded, as expected=
<quotes> LANGUAGE plpythonu,<------------>[plpy.notice(<quotes>import faile=
d -- %s<quotes> % str(ex)) return <quotes>failed, that wasn<quotes>t suppos=
ed to happen<quotes> return <quotes>succeeded, as expected<quotes> LANGUAGE=
plpythonu][],UNKNOWN,0,UNKNOWN,1,val =3D TD[key] plpy.notice(<quotes>TD[<q=
uotes> + key + <quotes>] =3D> <quotes> + str(val)),<------------>[val =3D T=
D[key] plpy.notice(<quotes>TD[<quotes> + key + <quotes>] =3D> <quotes> + st=
r(val))][],UNKNOWN,0,UNKNOWN,1,plpy.notice(str(ex)) return None rv =3D plpy=
.execute(SD[<quotes>plan<quotes>], [ a ]) if len(rv)<colon>,<------------>[=
plpy.notice(str(ex)) return None rv =3D plpy.execute(SD[<quotes>plan<quotes=
], [ a ]) if len(rv)<colon>][]]
src/backend/nodes/read.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,read.c routines to=
convert a string (legal ascii representation of node) back to nodes,<-----=
------->[read.c routines to convert a string (legal ascii representation of=
node) back to nodes][]]
src/backend/regex/regcomp.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,re_comp and fri=
ends - compile REs This file includes several others (see the bottom),<----=
-------->[re_comp and friends - compile REs This file includes several othe=
rs (see the bottom)][],AllRights,0,,,,UNKNOWN,0,UNKNOWN,1,Redistribution an=
d use in source and binary forms -- with or without modification -- are per=
mitted for any purpose, provided that redistributions in source form retain=
this entire copyright notice and indicate the origin and nature of any mod=
ifications,<------------>[Redistribution and use in source and binary forms=
-- with or without modification -- are permitted for any purpose, provided=
that redistributions in source form retain this entire copyright notice an=
d indicate the origin and nature of any modifications][],BSDasIs,70,,,<quot=
es>,<quotes>,,BSDWarr,70,,,HENRY SPENCER,]
src/test/regress/sql/join.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,regression te=
st for improper extraction of OR indexqual conditions (as seen in early 8.3=
.x releases),<------------>[regression test for improper extraction of OR i=
ndexqual conditions (as seen in early 8.3.x releases)][]]
src/backend/utils/adt/selfuncs.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Restrictio=
n clause estimation<colon>,<------------>[Restriction clause estimation<col=
on>][],UNKNOWN,0,UNKNOWN,1,Join selectivity estimation is far more difficul=
t and usually less accurate than restriction estimation,<------------>[Join=
selectivity estimation is far more difficult and usually less accurate tha=
n restriction estimation][],UNKNOWN,0,UNKNOWN,1,When dealing with the inner=
scan of a nestloop join, we consider the join<quotes>s joinclauses as rest=
riction clauses for the inner relation, and treat vars of the outer relatio=
n as parameters (a/k/a constants of unknown values),<------------>[When dea=
ling with the inner scan of a nestloop join, we consider the join<quotes>s =
joinclauses as restriction clauses for the inner relation, and treat vars o=
f the outer relation as parameters (a/k/a constants of unknown values)][],U=
NKNOWN,0,UNKNOWN,1,So, restriction estimators need to be able to accept an =
argument telling which relation is to be treated as the variable,<---------=
--->[So, restriction estimators need to be able to accept an argument telli=
ng which relation is to be treated as the variable][],UNKNOWN,0,UNKNOWN,1,T=
he call convention for a restriction estimator (oprrest function) is,<-----=
------->[The call convention for a restriction estimator (oprrest function)=
is][]]
src/test/performance/runtests.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Script sho=
uldn<quotes>t notice either he is running for test or for initialization pu=
rposes,<------------>[Script shouldn<quotes>t notice either he is running f=
or test or for initialization purposes][]]
src/test/regress/sql/select_implicit.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,SE=
LECT_IMPLICIT Test cases for queries with ordering terms missing from the t=
arget list,<------------>[SELECT_IMPLICIT Test cases for queries with order=
ing terms missing from the target list][]]
src/port/strdup.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,strdup.c copies a null-te=
rminated string,<------------>[strdup.c copies a null-terminated string][]]
src/test/regress/sql/foreign_data.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Suppr=
ess NOTICE messages when roles don<quotes>t exist SET client_min_messages T=
O <quotes>error<quotes>,<------------>[Suppress NOTICE messages when roles =
don<quotes>t exist SET client_min_messages TO <quotes>error<quotes>][],UNKN=
OWN,0,UNKNOWN,1,no usage on FDW RESET ROLE
src/test/regress/sql/privileges.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Suppres=
s NOTICE messages when users/groups don<quotes>t exist SET client_min_messa=
ges TO <quotes>error<quotes>,<------------>[Suppress NOTICE messages when u=
sers/groups don<quotes>t exist SET client_min_messages TO <quotes>error<quo=
tes>][],UNKNOWN,0,UNKNOWN,1,GRANT ALL ON atest1 TO regressuser2
src/backend/postmaster/autovacuum.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,The aut=
ovacuum launcher cannot start the worker processes by itself, because doing=
so would cause robustness issues (namely, failure to shut them down on exc=
eptional conditions, and also, since the launcher is connected to shared me=
mory and is thus subject to corruption there, it is not as robust as the po=
stmaster),<------------>[The autovacuum launcher cannot start the worker pr=
ocesses by itself, because doing so would cause robustness issues (namely, =
failure to shut them down on exceptional conditions, and also, since the la=
uncher is connected to shared memory and is thus subject to corruption ther=
e, it is not as robust as the postmaster)][]]
src/backend/utils/cache/plancache.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,The cre=
ator of a cached plan can specify whether it is allowable for the query to =
change output tupdesc on replan (this could happen with <quotes>SELECT <quo=
tes> for example) if so, it<quotes>s up to the caller to notice changes and=
cope with them,<------------>[The creator of a cached plan can specify whe=
ther it is allowable for the query to change output tupdesc on replan (this=
could happen with <quotes>SELECT <quotes> for example) if so, it<quotes>s =
up to the caller to notice changes and cope with them][]]
src/backend/executor/nodeSetOp.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,The delive=
red output tuples are just copies of the first-to-arrive tuple in each inpu=
t group,<------------>[The delivered output tuples are just copies of the f=
irst-to-arrive tuple in each input group][]]
src/backend/regex/regc_locale.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,The followi=
ng terms apply to all files associated with the software unless explicitly =
disclaimed in individual files,<------------>[The following terms apply to =
all files associated with the software unless explicitly disclaimed in indi=
vidual files][],UNKNOWN,0,UNKNOWN,1,The authors hereby grant permission to =
use, copy, modify, distribute, and license this software and its documentat=
ion for any purpose, provided that existing copyright notices are retained =
in all copies and that this notice is included verbatim in any distribution=
s,<------------>[The authors hereby grant permission to use, copy, modify, =
distribute, and license this software and its documentation for any purpose=
, provided that existing copyright notices are retained in all copies and t=
hat this notice is included verbatim in any distributions][],UNKNOWN,0,UNKN=
OWN,1,No written agreement, license, or royalty fee is required for any of =
the authorized uses,<------------>[No written agreement, license, or royalt=
y fee is required for any of the authorized uses][],UNKNOWN,0,UNKNOWN,1,Mod=
ifications to this software may be copyrighted by their authors and need no=
t follow the licensing terms described here, provided that the new terms ar=
e clearly indicated on the first page of each file where they apply,<------=
------>[Modifications to this software may be copyrighted by their authors =
and need not follow the licensing terms described here, provided that the n=
ew terms are clearly indicated on the first page of each file where they ap=
ply][],UNKNOWN,0,UNKNOWN,1,IN NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE=
LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUE=
NTIAL DAMAGES ARISING OUT OF THE USE OF THIS SOFTWARE, ITS DOCUMENTATION, O=
R ANY DERIVATIVES THEREOF, EVEN IF THE AUTHORS HAVE BEEN ADVISED OF THE POS=
SIBILITY OF SUCH DAMAGE,<------------>[IN NO EVENT SHALL THE AUTHORS OR DIS=
TRIBUTORS BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL,=
OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OF THIS SOFTWARE, ITS DOCU=
MENTATION, OR ANY DERIVATIVES THEREOF, EVEN IF THE AUTHORS HAVE BEEN ADVISE=
D OF THE POSSIBILITY OF SUCH DAMAGE][],UNKNOWN,0,UNKNOWN,1,THE AUTHORS AND =
DISTRIBUTORS SPECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT NOT LIMIT=
ED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR =
PURPOSE, AND NON-INFRINGEMENT,<------------>[THE AUTHORS AND DISTRIBUTORS S=
PECIFICALLY DISCLAIM ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMP=
LIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND N=
ON-INFRINGEMENT][],UNKNOWN,0,UNKNOWN,1,THIS SOFTWARE IS PROVIDED ON AN <quo=
tes>AS IS<quotes> BASIS, AND THE AUTHORS AND DISTRIBUTORS HAVE NO OBLIGATIO=
N TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS,=
<------------>[THIS SOFTWARE IS PROVIDED ON AN <quotes>AS IS<quotes> BASIS,=
AND THE AUTHORS AND DISTRIBUTORS HAVE NO OBLIGATION TO PROVIDE MAINTENANCE=
, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS][],UNKNOWN,0,UNKNOWN,1,N=
otwithstanding the foregoing, the authors grant the U.S. Government and oth=
ers acting in its behalf permission to use and distribute the software in a=
ccordance with the terms specified in this license,<------------>[Notwithst=
anding the foregoing, the authors grant the U.S. Government and others acti=
ng in its behalf permission to use and distribute the software in accordanc=
e with the terms specified in this license][]]
src/backend/utils/init/flatfiles.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,The majo=
r restriction imposed by all that is that there<quotes>s no way to read an =
out-of-line-toasted datum, because the tuptoaster.c code is not prepared to=
cope with such an environment,<------------>[The major restriction imposed=
by all that is that there<quotes>s no way to read an out-of-line-toasted d=
atum, because the tuptoaster.c code is not prepared to cope with such an en=
vironment][]]
src/backend/executor/execTuples.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,These are=
used to ensure that the executor frees copies of tuples (made by ExecTarge=
tList) properly,<------------>[These are used to ensure that the executor f=
rees copies of tuples (made by ExecTargetList) properly][],UNKNOWN,0,UNKNOW=
N,1,CONVENIENCE INITIALIZATION ROUTINES ExecInitResultTupleSlot convenience=
routines to initialize ExecInitScanTupleSlot the various tuple slots for n=
odes ExecInitExtraTupleSlot / which store copies of tuples,<------------>[C=
ONVENIENCE INITIALIZATION ROUTINES ExecInitResultTupleSlot convenience rout=
ines to initialize ExecInitScanTupleSlot the various tuple slots for nodes =
ExecInitExtraTupleSlot / which store copies of tuples][]]
src/include/storage/spin.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,These macros are=
implemented in terms of hardware-dependent macros supplied by s_lock.h,<--=
---------->[These macros are implemented in terms of hardware-dependent mac=
ros supplied by s_lock.h][]]
src/test/regress/sql/transactions.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,They =
should not be able to see the partial results of the calling query,<-------=
----->[They should not be able to see the partial results of the calling qu=
ery][],UNKNOWN,0,UNKNOWN,1,But a volatile function can see the partial resu=
lts of the calling query create or replace function max_xacttest() returns =
smallint language sql as <quotes>select max(a) from xacttest<quotes> volati=
le,<------------>[But a volatile function can see the partial results of th=
e calling query create or replace function max_xacttest() returns smallint =
language sql as <quotes>select max(a) from xacttest<quotes> volatile][]]
src/bin/initdb/initdb.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This code is releas=
ed under the terms of the PostgreSQL License,<------------>[This code is re=
leased under the terms of the PostgreSQL License][]]
src/bin/pg_config/pg_config.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This code is =
released under the terms of the PostgreSQL License,<------------>[This code=
is released under the terms of the PostgreSQL License][]]
src/interfaces/ecpg/test/pg_regress_ecpg.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,=
This code is released under the terms of the PostgreSQL License,<----------=
-->[This code is released under the terms of the PostgreSQL License][]]
src/test/regress/pg_regress.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This code is =
released under the terms of the PostgreSQL License,<------------>[This code=
is released under the terms of the PostgreSQL License][]]
src/test/regress/pg_regress_main.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This cod=
e is released under the terms of the PostgreSQL License,<------------>[This=
code is released under the terms of the PostgreSQL License][]]
src/timezone/localtime.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This file is in th=
e public domain, so clarified as of 1996-06-05 by Arthur David Olson,<-----=
------->[This file is in the public domain, so clarified as of 1996-06-05 b=
y Arthur David Olson][]]
src/timezone/private.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This file is in the =
public domain, so clarified as of 1996-06-05 by Arthur David Olson,<-------=
----->[This file is in the public domain, so clarified as of 1996-06-05 by =
Arthur David Olson][]]
src/timezone/tzfile.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This file is in the p=
ublic domain, so clarified as of 1996-06-05 by Arthur David Olson,<--------=
---->[This file is in the public domain, so clarified as of 1996-06-05 by A=
rthur David Olson][]]
src/timezone/ialloc.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This file is in the p=
ublic domain, so clarified as of 2006-07-17 by Arthur David Olson,<--------=
---->[This file is in the public domain, so clarified as of 2006-07-17 by A=
rthur David Olson][]]
src/timezone/scheck.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This file is in the p=
ublic domain, so clarified as of 2006-07-17 by Arthur David Olson,<--------=
---->[This file is in the public domain, so clarified as of 2006-07-17 by A=
rthur David Olson][]]
src/timezone/zic.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This file is in the publ=
ic domain, so clarified as of 2006-07-17 by Arthur David Olson,<-----------=
->[This file is in the public domain, so clarified as of 2006-07-17 by Arth=
ur David Olson][]]
src/test/locale/test-ctype.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This is copyri=
ghted but free software,<------------>[This is copyrighted but free softwar=
e][],UNKNOWN,0,UNKNOWN,1,You can use it, modify and distribute in original =
or modified form providing that the author<quotes>s names and the above cop=
yright notice will remain,<------------>[You can use it, modify and distrib=
ute in original or modified form providing that the author<quotes>s names a=
nd the above copyright notice will remain][],UNKNOWN,0,UNKNOWN,1,Disclaimer=
, legal notice and absence of warranty,<------------>[Disclaimer, legal not=
ice and absence of warranty][],UNKNOWN,0,UNKNOWN,1,This software provided <=
quotes>as is<quotes> without any kind of warranty,<------------>[This softw=
are provided <quotes>as is<quotes> without any kind of warranty][]]
src/test/regress/sql/opr_sanity.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This is=
legal, but usually not intended,<------------>[This is legal, but usually =
not intended][],UNKNOWN,0,UNKNOWN,1,If oprrest is set, the operator must re=
turn boolean, and it must link to a proc with the right signature to be a r=
estriction selectivity estimator,<------------>[If oprrest is set, the oper=
ator must return boolean, and it must link to a proc with the right signatu=
re to be a restriction selectivity estimator][]]
src/backend/commands/async.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,This method is=
necessary because to avoid race conditions, we must hold lock on pg_listen=
er from when we insert a new listener tuple until we commit,<------------>[=
This method is necessary because to avoid race conditions, we must hold loc=
k on pg_listener from when we insert a new listener tuple until we commit][=
]]
contrib/dblink/sql/dblink.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,this time, <q=
uotes>cursor <quotes>rmt_foo_cursor<quotes> not found<quotes> as a notice S=
ELECT FROM dblink_fetch(<quotes>rmt_foo_cursor<quotes>,4,false) AS t(a int,=
b text, c text[]),<------------>[this time, <quotes>cursor <quotes>rmt_foo=
_cursor<quotes> not found<quotes> as a notice SELECT FROM dblink_fetch(<quo=
tes>rmt_foo_cursor<quotes>,4,false) AS t(a int, b text, c text[])][],UNKNOW=
N,0,UNKNOWN,1,CREATE FOREIGN DATA WRAPPER postgresql
src/backend/utils/adt/pg_lzcompress.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Thus,=
the decompressor simply copies rawsize bytes from the location after the h=
eader to the destination,<------------>[Thus, the decompressor simply copie=
s rawsize bytes from the location after the header to the destination][],UN=
KNOWN,0,UNKNOWN,1,Thus there are 3 stop conditions for the lookup of matche=
s<colon>,<------------>[Thus there are 3 stop conditions for the lookup of =
matches<colon>][]]
src/backend/optimizer/path/tidpath.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,tidpat=
h.c Routines to determine which TID conditions are usable for scanning a gi=
ven relation, and create TidPaths accordingly,<------------>[tidpath.c Rout=
ines to determine which TID conditions are usable for scanning a given rela=
tion, and create TidPaths accordingly][],UNKNOWN,0,UNKNOWN,1,What we are lo=
oking for here is WHERE conditions of the form <quotes>CTID =3D pseudoconst=
ant<quotes>, which can be implemented by just fetching the tuple directly v=
ia heap_fetch(),<------------>[What we are looking for here is WHERE condit=
ions of the form <quotes>CTID =3D pseudoconstant<quotes>, which can be impl=
emented by just fetching the tuple directly via heap_fetch()][],UNKNOWN,0,U=
NKNOWN,1,We can also handle OR<quotes>d conditions such as (CTID =3D const1=
) OR (CTID =3D const2), as well as ScalarArrayOpExpr conditions of the form=
CTID =3D ANY(pseudoconstant_array),<------------>[We can also handle OR<qu=
otes>d conditions such as (CTID =3D const1) OR (CTID =3D const2), as well a=
s ScalarArrayOpExpr conditions of the form CTID =3D ANY(pseudoconstant_arra=
y)][],UNKNOWN,0,UNKNOWN,1,We also support <quotes>WHERE CURRENT OF cursor<q=
uotes> conditions (CurrentOfExpr), which amount to <quotes>CTID =3D run-tim=
e-determined-TID<quotes>,<------------>[We also support <quotes>WHERE CURRE=
NT OF cursor<quotes> conditions (CurrentOfExpr), which amount to <quotes>CT=
ID =3D run-time-determined-TID<quotes>][]]
src/include/storage/pg_shmem.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,To simplify =
life for the SysV implementation, the ID is assumed to consist of two unsig=
ned long values (these are key and ID in SysV terms),<------------>[To simp=
lify life for the SysV implementation, the ID is assumed to consist of two =
unsigned long values (these are key and ID in SysV terms)][]]
src/test/regress/sql/rangefuncs.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,trigger=
s will fire, too create function noticetrigger() returns trigger as $$ begi=
n raise notice <quotes>noticetrigger % %<quotes>, new.f1, new.data
src/backend/utils/mb/Unicode/UCS_to_BIG5.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN,1=
,Unfortunately it is prohibited by the organization to distribute the map f=
iles,<------------>[Unfortunately it is prohibited by the organization to d=
istribute the map files][]]
src/backend/utils/mb/Unicode/UCS_to_EUC_CN.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN=
,1,Unfortunately it is prohibited by the organization to distribute the map=
files,<------------>[Unfortunately it is prohibited by the organization to=
distribute the map files][]]
src/backend/utils/mb/Unicode/UCS_to_EUC_JP.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN=
,1,Unfortunately it is prohibited by the organization to distribute the map=
files,<------------>[Unfortunately it is prohibited by the organization to=
distribute the map files][]]
src/backend/utils/mb/Unicode/UCS_to_EUC_KR.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN=
,1,Unfortunately it is prohibited by the organization to distribute the map=
files,<------------>[Unfortunately it is prohibited by the organization to=
distribute the map files][]]
src/backend/utils/mb/Unicode/UCS_to_EUC_TW.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN=
,1,Unfortunately it is prohibited by the organization to distribute the map=
files,<------------>[Unfortunately it is prohibited by the organization to=
distribute the map files][]]
src/backend/utils/mb/Unicode/UCS_to_GB18030.pl;UUNMATCHED [UNKNOWN,0,UNKNOW=
N,1,Unfortunately it is prohibited by the organization to distribute the ma=
p files,<------------>[Unfortunately it is prohibited by the organization t=
o distribute the map files][]]
src/backend/utils/mb/Unicode/UCS_to_most.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN,1=
,Unfortunately it is prohibited by the organization to distribute the map f=
iles,<------------>[Unfortunately it is prohibited by the organization to d=
istribute the map files][]]
src/backend/utils/mb/Unicode/UCS_to_SJIS.pl;UUNMATCHED [UNKNOWN,0,UNKNOWN,1=
,Unfortunately it is prohibited by the organization to distribute the map f=
iles,<------------>[Unfortunately it is prohibited by the organization to d=
istribute the map files][]]
src/include/storage/s_lock.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Usually, S_LOC=
K() is implemented in terms of an even lower-level macro TAS()<colon>,<----=
-------->[Usually, S_LOCK() is implemented in terms of an even lower-level =
macro TAS()<colon>][]]
src/pl/tcl/sql/pltcl_setup.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,$val<quotes>=
} set str <quotes>$str}<quotes> elog NOTICE <quotes>$key<colon>,<---------=
--->[$val<quotes> } set str <quotes>$str}<quotes> elog NOTICE <quotes>$key<=
colon>][],UNKNOWN,0,UNKNOWN,1,$str<quotes> } else { set val [eval list <quo=
tes> $$key<quotes> ] elog NOTICE <quotes>$key<colon>,<------------>[$str<qu=
otes> } else { set val [eval list <quotes> $$key<quotes> ] elog NOTICE <quo=
tes>$key<colon>][],UNKNOWN,0,UNKNOWN,1,This must be done AFTER the changes =
in T_pkey2 are done so the trigger for primkey check on T_dta2 fired on our=
updates will see the new key values in T_pkey2,<------------>[This must be=
done AFTER the changes in T_pkey2 are done so the trigger for primkey chec=
k on T_dta2 fired on our updates will see the new key values in T_pkey2][],=
UNKNOWN,0,UNKNOWN,1,Let old references follow and fire NOTICE message if th=
ere where some,<------------>[Let old references follow and fire NOTICE mes=
sage if there where some][],UNKNOWN,0,UNKNOWN,1,set n [spi_execp $GD(plan_d=
ta2_upd) [list $OLD(key1) $OLD(key2) $NEW(key1) $NEW(key2)]] if {$n > 0} { =
elog NOTICE <quotes>updated $n entries in T_dta2 for new key in T_pkey2<quo=
tes> } },<------------>[set n [spi_execp $GD(plan_dta2_upd) [list $OLD(key1=
) $OLD(key2) $NEW(key1) $NEW(key2)]] if {$n > 0} { elog NOTICE <quotes>upda=
ted $n entries in T_dta2 for new key in T_pkey2<quotes> } }][],UNKNOWN,0,UN=
KNOWN,1,delete references and fire NOTICE message if there where some,<----=
-------->[delete references and fire NOTICE message if there where some][],=
UNKNOWN,0,UNKNOWN,1,set n [spi_execp $GD(plan_dta2_del) [list $OLD(key1) $O=
LD(key2)]] if {$n > 0} { elog NOTICE <quotes>deleted $n entries from T_dta2=
<quotes> } },<------------>[set n [spi_execp $GD(plan_dta2_del) [list $OLD(=
key1) $OLD(key2)]] if {$n > 0} { elog NOTICE <quotes>deleted $n entries fro=
m T_dta2<quotes> } }][]]
src/test/regress/sql/select.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,VALUES is a=
lso legal as a standalone query or a set-operation member VALUES (1,2), (3,=
4+4), (7,77.7),<------------>[VALUES is also legal as a standalone query or=
a set-operation member VALUES (1,2), (3,4+4), (7,77.7)][]]
src/test/regress/sql/cluster.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Verify tha=
t clustering all tables does in fact cluster the right ones CREATE USER cls=
tr_user
src/test/regress/sql/portals.sql;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,We should =
not see the portal that is created internally to implement EXECUTE in pg_cu=
rsors PREPARE cprep AS SELECT name, statement, is_holdable, is_binary, is_s=
crollable FROM pg_cursors
src/backend/utils/hash/pg_crc.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,We use a no=
rmal (not <quotes>reflected<quotes>, in Williams<quotes> terms) CRC, using =
initial all-ones register contents and a final bit inversion,<------------>=
[We use a normal (not <quotes>reflected<quotes>, in Williams<quotes> terms)=
CRC, using initial all-ones register contents and a final bit inversion][]]
src/include/utils/pg_crc.h;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,We use a normal =
(not <quotes>reflected<quotes>, in Williams<quotes> terms) CRC, using initi=
al all-ones register contents and a final bit inversion,<------------>[We u=
se a normal (not <quotes>reflected<quotes>, in Williams<quotes> terms) CRC,=
using initial all-ones register contents and a final bit inversion][]]
src/backend/parser/scan.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,When we actually =
see the EOF, we change the status to <quotes>new<quotes> (via base_yyrestar=
t()), so that the user can continue scanning by just pointing base_yyin at =
a new input file,<------------>[When we actually see the EOF, we change the=
status to <quotes>new<quotes> (via base_yyrestart()), so that the user can=
continue scanning by just pointing base_yyin at a new input file][]]
src/backend/bootstrap/bootscanner.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,When we=
actually see the EOF, we change the status to <quotes>new<quotes> (via boo=
t_yyrestart()), so that the user can continue scanning by just pointing boo=
t_yyin at a new input file,<------------>[When we actually see the EOF, we =
change the status to <quotes>new<quotes> (via boot_yyrestart()), so that th=
e user can continue scanning by just pointing boot_yyin at a new input file=
][]]
contrib/cube/cubescan.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,When we actually se=
e the EOF, we change the status to <quotes>new<quotes> (via cube_yyrestart(=
)), so that the user can continue scanning by just pointing cube_yyin at a =
new input file,<------------>[When we actually see the EOF, we change the s=
tatus to <quotes>new<quotes> (via cube_yyrestart()), so that the user can c=
ontinue scanning by just pointing cube_yyin at a new input file][]]
src/backend/utils/misc/guc-file.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,When we a=
ctually see the EOF, we change the status to <quotes>new<quotes> (via GUC_y=
yrestart()), so that the user can continue scanning by just pointing GUC_yy=
in at a new input file,<------------>[When we actually see the EOF, we chan=
ge the status to <quotes>new<quotes> (via GUC_yyrestart()), so that the use=
r can continue scanning by just pointing GUC_yyin at a new input file][]]
src/pl/plpgsql/src/pl_scan.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,When we actual=
ly see the EOF, we change the status to <quotes>new<quotes> (via plpgsql_ba=
se_yyrestart()), so that the user can continue scanning by just pointing pl=
pgsql_base_yyin at a new input file,<------------>[When we actually see the=
EOF, we change the status to <quotes>new<quotes> (via plpgsql_base_yyresta=
rt()), so that the user can continue scanning by just pointing plpgsql_base=
_yyin at a new input file][]]
contrib/seg/segscan.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,When we actually see =
the EOF, we change the status to <quotes>new<quotes> (via seg_yyrestart()),=
so that the user can continue scanning by just pointing seg_yyin at a new =
input file,<------------>[When we actually see the EOF, we change the statu=
s to <quotes>new<quotes> (via seg_yyrestart()), so that the user can contin=
ue scanning by just pointing seg_yyin at a new input file][]]
src/bin/psql/psqlscan.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,When we actually se=
e the EOF, we change the status to <quotes>new<quotes> (via yyrestart()), s=
o that the user can continue scanning by just pointing yyin at a new input =
file,<------------>[When we actually see the EOF, we change the status to <=
quotes>new<quotes> (via yyrestart()), so that the user can continue scannin=
g by just pointing yyin at a new input file][]]
src/interfaces/ecpg/preproc/pgc.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,When we a=
ctually see the EOF, we change the status to <quotes>new<quotes> (via yyres=
tart()), so that the user can continue scanning by just pointing yyin at a =
new input file,<------------>[When we actually see the EOF, we change the s=
tatus to <quotes>new<quotes> (via yyrestart()), so that the user can contin=
ue scanning by just pointing yyin at a new input file][]]
src/backend/executor/nodeBitmapHeapscan.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,W=
ith SnapshotNow we might return a tuple that doesn<quotes>t meet the requir=
ed index qual conditions,<------------>[With SnapshotNow we might return a =
tuple that doesn<quotes>t meet the required index qual conditions][]]
contrib/pgcrypto/crypt-gensalt.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Written by=
Solar Designer and placed in the public domain,<------------>[Written by S=
olar Designer and placed in the public domain][]]
contrib/pgcrypto/crypt-blowfish.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Written b=
y Solar Designer <solar@...> in 1998-2001, and placed in the publi=
c domain,<------------>[Written by Solar Designer <solar@...> in 1=
998-2001, and placed in the public domain][],UNKNOWN,0,UNKNOWN,1,There<quot=
es>s absolutely no warranty,<------------>[There<quotes>s absolutely no war=
ranty][],UNKNOWN,0,UNKNOWN,1,I would appreciate it if you give credit where=
it is due and keep your modifications in the public domain as well, but I =
don<quotes>t require that in order to let you place this code and any modif=
ications you make under a license of your choice,<------------>[I would app=
reciate it if you give credit where it is due and keep your modifications i=
n the public domain as well, but I don<quotes>t require that in order to le=
t you place this code and any modifications you make under a license of you=
r choice][]]
contrib/sslinfo/sslinfo.c;UUNMATCHED [UNKNOWN,0,UNKNOWN,1,Written by Victor=
B. Wagner <vitus@...>, Cryptocom LTD This file is distributed und=
er BSD-style license,<------------>[Written by Victor B. Wagner <vitus@cryp=
tocom.ru>, Cryptocom LTD This file is distributed under BSD-style license][=
]]



--
--
Daniel M. German
http://turingmachine.org/
http://silvernegative.com/
dmg (at) uvic (dot) ca
replace (at) with @ and (dot) with .