pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Grillet <andrew@grillet.co.uk>
To: pgsql-bugs@postgresql.org
Subject: Bug report
Date: Fri, 1 Oct 2004 22:48:52 +0100
Message-ID: <200410012248.53267.andrew@grillet.co.uk> (raw)

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







view thread (28+ messages)  latest in thread

Message-ID: <200410012248.53267.andrew@grillet.co.uk>
Permalink:  ../200410012248.53267.andrew@grillet.co.uk/
Also on:    postgresql.org/message-id/200410012248.53267.andrew@grillet.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: andrew@grillet.co.uk
  Subject: Re: Bug report
  In-Reply-To: <200410012248.53267.andrew@grillet.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox