Hello.
It seems that this works (I made tests on permanent table, postgresql
8.4.0):
CREATE OR REPLACE FUNCTION track_updates()
RETURNS TRIGGER AS $$
DECLARE
BEGIN
IF TG_OP = 'UPDATE' THEN
IF NEW IS NOT DISTINCT FROM OLD THEN
RAISE NOTICE 'OLD and NEW are the same!';
Hello
NEW and OLD is comparable in 8.4. In 8.3 and older you have to use
little bit different syntax
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
Regards
Pavel Stehule
2009/12/15 Josh Kupershmidt :
> Hi all,
>
> Short version of m
Greetings!
The Gluster Team is happy to announce the release of Gluster Storage Platform
3.0. The Gluster Storage Platform is based on the popular open source clustered
file system GlusterFS, integrating the file system, an operating system layer,
a web based management interface, and an easy
I have a few things to report so I'm not sure if one email is good or
several but here goes.
We are using Postgresql 8.3.8
We were having a blocking query problem that should have been fixed by
statement_timeout = 9 however this seems to have had zero effect.
The query we have was like so:
Hi all,
Short version of my question:
What's the best way to compare arbitrary records (OLD and NEW, in my
case) using PL/pgSQL in Postgres 8.3, without knowing anything about
the structure of the records? If the answer is to cast OLD and NEW to
text, and then compare, as suggested in [1], what fa
December 14th, 2009, the PostgreSQL Conference U.S. team is pleased to
announce the East 2010 venue and call for papers. This year the premiere
East Coast PostgreSQL Conference will be returning to history Drexel
University in Philadelphia.
The event this year is being held at Drexel University in
Phoenix Kiula writes:
> Is there any SQL possibility to find these columns and replace them
> with utf-8 equivalents using some postgresql commands? Couldn't find
> anything in the "Strings functions" (chapter 9 of manual).
I've bookmarked this for later:
http://archives.postgresql.org/pgsql-g
On Mon, Dec 14, 2009 at 9:10 AM, Dave Page wrote:
>> It currently shows the binaries for 8.4.1.
> Did you try a reload?
Yes, It shows 8.4.2. Actually the page refreshed two minutes after I
sent the email.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
On Mon, Dec 14, 2009 at 4:28 PM, Richard Broersma
wrote:
> I might be bringing this up too soon, however the link to the 8.4.2
> windows binaries needs to be updated:
>
> http://www.enterprisedb.com/products/pgdownload.do#windows
>
> It currently shows the binaries for 8.4.1.
Did you try a reload
Hi All,
I have solaris 10 update5 sunfire X4240 with 32GB RAM and ZFS system.I am
having problem while configuring below parameters especially how shmmni
works ---
1) shmmax
2) shmmni
3) arc_max
4) shared_buffers
Since, it's a dedicated server i want to utilize all resources.As of now i
have
When upgrading pg 8.4.1 to 8.4.2 the following error message appeared:
-Error-
[quote]"Error copying file from package archive
(...)/postgresql-8.4.2-1-windows.exe to (...)/bin/comerr32.dll[/quote]
After selecting retry, the install process completes successfully.
P.S.
I tried posting this to
I might be bringing this up too soon, however the link to the 8.4.2
windows binaries needs to be updated:
http://www.enterprisedb.com/products/pgdownload.do#windows
It currently shows the binaries for 8.4.1.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
Tom wrote:
>> In order to have a "global map" of the dependencies of the functions,
>> views, tables in a PG database, I'd like to have some sort of
>> "dependency tracking tool"...
>>
>>
>>
>> Is it correct to say that this "hierarchy" does not exist inside
>> Postgresql, and that it is necessar
Philippe Lang wrote:
> Hello,
>
> In order to have a "global map" of the dependencies of the functions,
> views, tables in a PG database, I'd like to have some sort of
> "dependency tracking tool", that would show for each object:
>
> - which other objects depend on this object
> - on which other
"Philippe Lang" writes:
> In order to have a "global map" of the dependencies of the functions,
> views, tables in a PG database, I'd like to have some sort of
> "dependency tracking tool", that would show for each object:
> - which other objects depend on this object
> - on which other objects t
On Monday 14 December 2009 3:04:07 am Fred Janon wrote:
> Hi,
>
> I am using Postgres 8.3. I have a table defined like this:
>
> ===
> -- Table: timeson
>
> -- DROP TABLE timeson;
>
> CREATE TABLE timeson
> (
> id bigint NOT NULL,
> enddatetime timestamp without time zone NO
On 14 Dec 2009, at 13:21, Phoenix Kiula wrote:
> Actually I just realized that the SQL below will also pick up on these
> perfectly valid-looking columns:
>
>
> http://factfinder.census.gov/servlet/ReferenceMapFramesetServlet?_bm=y&-zip=27340&-PANEL_ID=rm_result&-_MapEvent=zoomToAddress&-street=
Alvaro Herrera writes:
> Tom Lane wrote:
>> Hm, I wonder whether the reason the OP ran into trouble was that he
>> followed that guide :-(. Relying on manual invocation of configure
>> is a sure recipe for hitting weird breakage anytime somebody changes
>> the configure input files ... Surely the
Tom Lane wrote:
> Greg Smith writes:
> > wrote:
> >> Hi,guys.I ama studentwho want to studyPostgreSQL.I encountered the
> >> following errors which I don't know how to fix while I using eclipse
> >> to built pgsql:
>
> > I don't know why this specific one isn't working, but we do have
On 14/12/2009 4:35 PM, Allan Kamau wrote:
> and I am calling this function in
from a threaded application which could use the same connection in
more than one thread(is this possible/or even safe).
No!
Admittedly it depends on the client interface/driver, but at least for
direct psql, PgODBC
Actually I just realized that the SQL below will also pick up on these
perfectly valid-looking columns:
http://factfinder.census.gov/servlet/ReferenceMapFramesetServlet?_bm=y&-zip=27340&-PANEL_ID=rm_result&-_MapEvent=zoomToAddress&-street=&-city=&-rm_config=|b=50|l=en|t=420|zf=0.0|ms=ref_legal_00
Actually the title of my email should have been "how to **replace**
utf-8 values".
Thanks.
On Mon, Dec 14, 2009 at 7:03 PM, Phoenix Kiula wrote:
> An easy question for some I hope.
>
> I have a DB from 8.2 days that when I now dump and try to take into
> the 8.3.7, it gives me errors about utf
Hi,
I am using Postgres 8.3. I have a table defined like this:
===
-- Table: timeson
-- DROP TABLE timeson;
CREATE TABLE timeson
(
id bigint NOT NULL,
enddatetime timestamp without time zone NOT NULL,
startdatetime timestamp without time zone NOT NULL,
times_id bigin
An easy question for some I hope.
I have a DB from 8.2 days that when I now dump and try to take into
the 8.3.7, it gives me errors about utf-8 stuff.
I tried searching this list's archives but could not come up with an answer.
Google returns some sites like these:
http://sniptools.com/databases
Hello,
In order to have a "global map" of the dependencies of the functions,
views, tables in a PG database, I'd like to have some sort of
"dependency tracking tool", that would show for each object:
- which other objects depend on this object
- on which other objects this object depends
This wo
Hi all,
I have a simple question: Are the temporary database objects created
within a pgplsql function visible/available outside the function (or
implicit transaction) in any way. I am dropping and creating temporary
database objects within a function and I am calling this function in
from a thread
Hello.
I'd like to collect some statistics in my application (using JDBC). In
Oracle I could collect data, sent to client, using the following query:
SELECT S.value FROM V$MYSTAT S,SYS.V_$STATNAME NAMES
WHERE NAMES.STATISTIC#=S.STATISTIC#
AND NAMES.NAME='bytes sent via SQL*Net to client';
Can
27 matches
Mail list logo
