Install files for version 7.4

Carlos writes:

Could someone please send me the link and the names of the files to install
the version 7.4 in Windows 2000 server and XP Pro? I cannot discern the
files that one is supposed to download.

There is no version 7.4 yet. When it will be available, the release
announcement will contain instructions.

--
Peter Eisentraut peter_e@gmx.net

Not even for the beta version?

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Peter
Eisentraut
Sent: Thursday, November 06, 2003 1:11 PM
To: Carlos
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] Install files for version 7.4

Carlos writes:

Could someone please send me the link and the names of the files to
install the version 7.4 in Windows 2000 server and XP Pro? I cannot
discern the files that one is supposed to download.

There is no version 7.4 yet. When it will be available, the release
announcement will contain instructions.

--
Peter Eisentraut peter_e@gmx.net

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Carlos Oliva writes:

Not even for the beta version?

In that case you want the file postgresql-7.4RC1.tar.gz. (or .bz2).

--
Peter Eisentraut peter_e@gmx.net

Thank you very much

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Peter
Eisentraut
Sent: Thursday, November 06, 2003 1:51 PM
To: Carlos
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Install files for version 7.4

Carlos Oliva writes:

Not even for the beta version?

In that case you want the file postgresql-7.4RC1.tar.gz. (or .bz2).

--
Peter Eisentraut peter_e@gmx.net

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Ryan Mahoney kirjutas N, 06.11.2003 kell 23:03:

I am running PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96

the following query fails:

SELECT 'UPDATE pa_sales_lead SET details = COALESCE(details, \'\') ||
\'' || replace(data, '\'', '\'\'') || '\' WHERE foreign_sales_lead_id =
\'' || id || '\';' FROM temp_sales_lead ORDER BY id, row LIMIT 10;

with the error:

ERROR: repalloc: invalid request size 1073741824

but, the following query (without replace):
SELECT 'UPDATE pa_sales_lead SET details = COALESCE(details, \'\') ||
\'' || data || '\' WHERE foreign_sales_lead_id = \'' || id || '\';' FROM
temp_sales_lead ORDER BY id, row LIMIT 10;

works just fine, producing output like:

UPDATE pa_sales_lead SET details = COALESCE(details, '') || 'EMPLOY: 50'
WHERE foreign_sales_lead_id = '10000004';

any ideas?

what does just

SELECT replace(data, '\'', '\'\'')
FROM temp_sales_lead
ORDER BY id, row LIMIT 10;

produce ?

----------------
Hannu

Hannu Krosing wrote:

Ryan Mahoney kirjutas N, 06.11.2003 kell 23:03:

I am running PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96

what does just

SELECT replace(data, '\'', '\'\'')
FROM temp_sales_lead
ORDER BY id, row LIMIT 10;

produce ?

There was a bug in replace(), fixed by Tom in 7.3.3 I think (for sure by
7.3.4). If you have any embedded "%" characters in data, it would
trigger the bug. Try upgrading to 7.3.4.

HTH,

Joe