Dear Mr or miss :
please give a instruction of PostgreSQL 8.1.0 that be installed on the
gentoo
linux OS,thank you very much!
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
The following bug has been logged online:
Bug reference: 2052
Logged by: Ferindo Middleton
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.4
Operating system: Windows 2000
Description:Federal Agency Tech Hub Refuses to Accept Postgresql on
Network because of
... continued ...
So that is the query.
The destination table looks like this:
Table "public.pws_stats_case"
Column| Type | Modifiers
-+---+---
batch_id| integer |
csid
The following bug has been logged online:
Bug reference: 2049
Logged by: Prakash Suryavanshi
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2
Operating system: Linux
Description:pg_dump BACKUP error
Details:
Respected Sir,
I am working on Linux 9.0
I've been investigating this problem further.
I've tried adding first just 2, then 4 more FULL JOINs to the statement. This works and the statement
gets to INSERT and completes successfully.
If I add 16 further FULL JOINs however, it does not.
Regards,
Matt
P.S. Apologies for the grammar er
Ok :) Then I found the solution in this partical case:
CREATE RULE test1_on_insert AS ON INSERT TO test1 DO INSERT INTO
test_log1 (qid) VALUES ( (SELECT lastval()) );
With this rule all inserts are working as expected :)
Thank you for you advise :)
Sarunas
Michael Fuhr wrote:
On Wed, Nov 16
(Resending)
Hi
I have a nightly process which distills a range of statistics from a
third-party database into a set of temporary tables, and then from those
tables, aggregates and joins these figures into two main tables. Each
temporary table contains a moderate number of rows and few columns.
T
The following bug has been logged online:
Bug reference: 2050
Logged by: Johannes
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc
(GCC) 3.3.5-20050130 (Gentoo 3.3.5.20050130-r1, ssp-3.3.5.20
The following bug has been logged online:
Bug reference: 2047
Logged by: Jeff Challender
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows XP
Description:Can't get to mirrors
Details:
Would like to download 8.1 can't access ANY of th
The following bug has been logged online:
Bug reference: 2048
Logged by: Acure
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: freebsd
Description:initdb hang up
Details:
I want to upgrade pgsql server from 8.0 to 8.1, but i have trouble
On 11/17/05, Johannes <[EMAIL PROTECTED]> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2050
> Logged by: Johannes
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.0.3
> Operating system: i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-g
"Johannes" <[EMAIL PROTECTED]> writes:
> EXPLAIN SELECT title FROM content WHERE title LIKE 'teane%';
> Seq Scan on content (cost=0.00..75647.59 rows=1 width=68)
>Filter: (title ~~ 'teane%'::text)
Apparently you're using a non-C locale. LIKE can only use an index if
you're in the C locale or
"Prakash Suryavanshi" <[EMAIL PROTECTED]> writes:
> system flashes error as follows
> bash-2.05b$ pg_dump chrome2105 > 2nov1505
> pg_dump: ERROR: _mdfd_getrelnfd: cannot open relation ed_accounttype:
> Permission denied
You've apparently started the postmaster as the wrong user, or else
someone'
"Ferindo Middleton" <[EMAIL PROTECTED]> writes:
> This bug report involves more than one proposed bug. I work at a federal
> government agency. The information technology division at this agency
> refuses to allow the database version 8.0.4 on their network because of
> several security vulnerabili
* Ferindo Middleton ([EMAIL PROTECTED]) wrote:
> CVE-2005-0245 Buffer overflow in gram.y for PostgreSQL 8.0.0 and earlier
> may allow attackers to execute arbitrary code via a large number of
> arguments to a refcursor function (gram.y), which leads to a
> heap-based buffer overflow, a different v
> Bug reference: 2052
> Logged by: Ferindo Middleton
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.0.4
> Operating system: Windows 2000
> Description:Federal Agency Tech Hub Refuses to Accept
> Postgresql on
> Network because of Security Vulnerabilities
>
On Thu, Nov 17, 2005 at 06:00:35PM +, Johannes <[EMAIL PROTECTED]> wrote:
> SELECT title FROM content WHERE title LIKE 'teane%';
>
> It uses to long time, I compare this with sybase
> and I was disappointed, but explain shows the reason.
>
>
> EXPLAIN SELECT title FROM content WHERE title L
Jeff Challender wrote:
> Would like to download 8.1 can't access ANY of the mirrors. Tried them all.
> Can't connect.
Works for me, and for a whole lot of people. Ever considered it may be
a problem on your side?
--
Alvaro Herrera
---(end of broadcast)---
Matt <[EMAIL PROTECTED]> writes:
>> If you'd be willing to send me a test case off-list, I'd be willing to
>> take a look. A convenient test case from my point of view would be a
>> SQL script that sets up the database plus another one containing the
>> slow query.
> I've created a standalone tes
19 matches
Mail list logo
