Re: foreign key from array element

On Tue, 2012-09-18 at 15:38 -0500, Kevin Grittner wrote:
> Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> wrote:
> > where do I get current-v9.3 from?
>
> At this point 9.3 just means the HEAD of the master branch of the
> git repository, which is where development for the next major
> release of software is always done. For details of the public git
> repository see:
>
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=summary
>

Oh. this is unexpected:

1. Got it by "git clone", the patch went-in cleanly,

2. "./configure" run just fine:
----------------
.
.
#define MEMSET_LOOP_LIMIT 1024
#define PG_VERSION_STR "PostgreSQL 9.3devel on i686-pc-linux-gnu,
compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit"
#define PG_VERSION_NUM 90300

configure: exit 0
----------------

3. But then make fails:
-----------------------
postmaster/postmaster.o: In function `PostmasterMain':^M
postmaster.c:(.text+0x4bc8): undefined reference to `optreset'^M
tcop/postgres.o: In function `process_postgres_switches':^M
postgres.c:(.text+0x1422): undefined reference to `optreset'^M
utils/misc/ps_status.o: In function `set_ps_display':^M
ps_status.c:(.text+0xd4): undefined reference to `setproctitle'^M
collect2: ld returned 1 exit status^M
make[2]: *** [postgres] Error 1^M
make[2]: Leaving directory `/home/rafal/work/postgresql/src/backend'^M
make[1]: *** [all-backend-recurse] Error 2^M
make[1]: Leaving directory `/home/rafal/work/postgresql/src'^M
make: *** [all-src-recurse] Error 2^M
-----------------------

which is interesting, because:

-----------------------
configure:22311: checking for optreset
configure:22337: gcc -o conftest -O2 -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
-fwrapv -D_GNU_SOURCE conftest.c -lz -ledit -lcrypt -ldl -lm >&5
configure:22344: $? = 0
configure:22364: result: yes
----------------------

while "setproctitle" was used despite being detected as missing:

----------------------
configure:7627: checking for library containing setproctitle
configure:7668: gcc -o conftest -O2 -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
-fwrapv -D_GNU_SOURCE conftest.c -lm >&5
/tmp/ccQn02qg.o: In function `main':
conftest.c:(.text+0x7): undefined reference to `setproctitle'
collect2: ld returned 1 exit status
configure:7675: $? = 1
-------------------------

-R