web / mailing list archives finds little to nothing regarding
"The index is not optimal. To optimize it, contact a developer, or try to use
the column as the second one in the CREATE INDEX command."
Should we make the effort to track down these indices / constraints and reorder
the columns to put the original table's primary key fields first, then the
range column last?
--
James Robinson
Socialserve.com by Emphasys Software
uot;substring"(pg_get_triggerdef(t.oid), 48), 'EXECUTE
PROCEDURE'::text) + 47)::information_schema.character_data AS action_statement,
...
But at least we can turn a blind eye to its internal horror. Thanks!
---
James Robinson
ja...@jlr-photo.com
--
Sent via pgsql-g
HEN clause portion'
for this use case (an in-house web-based schema browser which just got taught
how to display triggers). Was primarily interested in seeing if there was a
known way of doing this short of filthy string parsing.
I'll post the soln. I end up with just for mail archives
ilt in, or should we just make
call to pg_catalog.pg_get_triggerdef() and parse out the WHEN clause text?
Thanks!
------
James Robinson
Socialserve.com by Emphasys Software
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
On Jan 28, 2012, at 3:45 AM, Tom Lane wrote:
> James Robinson writes:
>> ERROR: duplicate key value violates unique constraint
>> "pg_toast_22608264_index"
>> DETAIL: Key (chunk_id, chunk_seq)=(22354927, 0) already exists.
>
>> The error is
yields nothing). Figuring it
could have been one of the temporary tables used in the transformations (at
least one of which had data rows wide enough to get toasted)?
James Robinson
Socialserve.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
me observed an undetected deadlock-ish issue, and the
juciest aspect was that a db-wide cluster was running.
Thanks!
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
k that got anywhere...
It's a psql only thing BTW, other programs will not see it.
Have a nice day,
--
Martijn van Oosterhout http://svana.org/
kleptog/
From each according to his ability. To each according to his
ability to litigate.
James Robinson
Socialserve.com
else
insert into housing.terse_listing (id,
last_modified) values (NEW.id, now());
end if;
return null;
END;
|
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
at tech which was supposed to make things
easy for you. CMP is a very leaky overcomplicated abstraction.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscr
Have you vacuum'd and/or analyzed D2?
http://www.postgresql.org/docs/8.1/static/maintenance.html
http://www.postgresql.org/docs/8.1/static/sql-analyze.html
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3:
rebuilding any indices on the old type columns, then
dropping the old type. Inconvenient, not insurmountable.
That said -- anyone stepping up to claiming using 'em? Are these things
seen as against the data normalization grain?
James Robinson
Socialserve.com
hat they
just aren't true members of the relational model, but, aside from
constraint inheritance, what is known to be lacking, aside from the
plethora of parenthesis they inflict?
James Robinson
Socialserve.com
---(end of broadcast)---
-- okay -- eat it now
for testrow in execute query loop
return next testrow;
end loop;
return;
END;
$$ language plpgsql;
social=# select * from dynamic_test('{2,3}');
NOTICE: query: "select * from test where id in (2, 3)"
id
ving only two lines of SQL to build
to educate the database about each one would be a real winner.
Not to sound ungrateful -- the scalar type tricks can work, but with
more SQL-level effort.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Apr 12, 2005, at 4:48 PM, Tom Lane wrote:
James Robinson <[EMAIL PROTECTED]> writes:
insert into simple_table values (null, '(43)'); -- GRR works!!! It'll
let any smallint in. What happened to the constraint?
The composite-type input routine doesn't check any constra
ith a separate oid for object / relational mapping.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
rence manual page on the COPY command.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
18 matches
Mail list logo
