I've installed it and it works. Thanks a lot.
On Saturday 12 April 2008 01:01:06 Tom Lane wrote:
> Marc Cousin <[EMAIL PROTECTED]> writes:
> > I'm having a strange problem : I created a view in a database, and I
> > cannot restore it after a pg_dump. ...
> > ERROR: for SELECT DISTINCT, ORDER BY e
Marc Cousin <[EMAIL PROTECTED]> writes:
> I'm having a strange problem : I created a view in a database, and I cannot
> restore it after a pg_dump.
> ...
> ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
You need this patch:
http://anoncvs.postgresql.org/cvsweb.cgi/p
Marc Cousin <[EMAIL PROTECTED]> writes:
> Sorry to post again, but I feel this issue is a bit strange and I'd like to
> understand it. The problem is that I've got the same query that runs
> sometimes, and fails with a syntax error at other times... It's the first
> time I've seen it, and I've b
I didn't put it in, pg_dump dit it for me... it seems that when a view has a
distinct, the dumped view has automatically the order by. that's what
triggered the whole problem.
But the query is supposed to be the same with the order by, because of the
distinct, so pg_dump is not wrong.
It looks
Hi,
Sorry to post again, but I feel this issue is a bit strange and I'd like to
understand it. The problem is that I've got the same query that runs
sometimes, and fails with a syntax error at other times... It's the first
time I've seen it, and I've been using PostgreSQL for a while now ...
T
I've forgotten to add this information :
Version :
infocentre_dte=# SELECT * from version();
version
--
PostgreSQL 8.3.1 on x86_64-pc-linux-gnu, compiled by GCC cc (GC
Hi,
I'm having a strange problem : I created a view in a database, and I cannot
restore it after a pg_dump.
I'm creating this view :
CREATE VIEW vj_icsi_integration_winaudit_isiparc AS
SELECT DISTINCT objet.c_barre ,
resume.computer ,
