Casey Duncan <[EMAIL PROTECTED]> writes:
> On May 11, 2006, at 4:42 AM, Simon Riggs wrote:
>> As your database is defined, this SQL statement will return
>> approximately 4 trillion rows, by my calculation. As you say, it
>> returns no rows at all when the database is empty.
> *slaps forehead* I
On May 11, 2006, at 4:42 AM, Simon Riggs wrote:
On Wed, 2006-05-10 at 09:34 -0700, Casey Duncan wrote:
The script actually fails before the function is even defined anyhow,
on this statement:
INSERT INTO ss
(ss_id, name, ll_id, shared_ss_id, time_added,
shared_creator_id)
SELECT ne
On May 9, 2006, at 9:09 PM, Tom Lane wrote:
"Casey Duncan" <[EMAIL PROTECTED]> writes:
CREATE FUNCTION write_error_trigf() RETURNS trigger AS '
BEGIN
RAISE EXCEPTION ''Writes not allowed to this table on this
node'';
END;
' LANGUAGE plpgsql;
END; --Upgrade script
You did no
"Casey Duncan" <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION write_error_trigf() RETURNS trigger AS '
> BEGIN
> RAISE EXCEPTION ''Writes not allowed to this table on this node'';
> END;
> ' LANGUAGE plpgsql;
> END; --Upgrade script
You did not show how this function is being used,
The following bug has been logged online:
Bug reference: 2428
Logged by: Casey Duncan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Debian Linux (2.6.13.1-20050914 #2 SMP) 2xOpteron 8GB
RAM
Description:ERROR: out of memory, running INSE
