Bug report

From: Andrew Grillet <andrew(at)grillet(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug report
Date: 2004-10-01 21:48:52
Message-ID: 200410012248.53267.andrew@grillet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi

Bug category serious:

The bug report link as www.postgresql.org/bugs/bugs.php is not working.

Original bug I was trying to report is that 7.4.5 builds OK on Freebsd
4.10 and runs fine, but if you try "createlang" (eg to install plpgsql)
it fails because of undefined symbol "downcase_truncate_identifier".

I have tried this on two different systems. In one, the pgsql was a
portupgrade -R, in the other it was built and installed from ports.

Also, unrelated issue:

It would be really nice if the manual .had an example of inserting a
nested query:

is it:
a) INSERT INTO table2 SELECT * from table1;

b) INSERT INTO table2 (SELECT * from table1);

c) INSERT INTO table2 VALUES (SELECT * from table1);

And what if you have a list of columns.

some of us are too stupid to remember, and have to look it up every
time! And there is nothing listed under INSERT or SUBQUERY, and it
takes about 15 mins to look it up!. (Even after using SQL for nearly 20
years :-()

regards

Andrew

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2004-10-01 22:02:44 Wierd results of math -- old bug I hope
Previous Message Tom Lane 2004-10-01 17:36:34 Re: PQdb() fails with coredump when PQconnectDB() passed invalid parameter.