Ron St-Pierre <[EMAIL PROTECTED]> writes:
> Whenever I run certain functions, such as the example below, the output
> is either displayed in the terminal or emailed to be by cron, depending
> on how I run it. Is there any way I can re-write the function, set some
> psql parameters, etc, to ensu
Whenever I run certain functions, such as the example below, the output
is either displayed in the terminal or emailed to be by cron, depending
on how I run it. Is there any way I can re-write the function, set some
psql parameters, etc, to ensure that the results aren't displayed? I've
check
How to build some of those contrib? Can you add one of contrib on the
existing Postgresql without reconfigure, rebuild, and reinstall?
Thanks.
johnl
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
remove a ) at the end, 3 is enough ;-)
Bruno BAGUETTE wrote:
Hello,
I have a PL/PGSQL stored procedure that makes me mad currently... (The
stored procedure is a procedure that simulates a materialized view)
It complains about a parse error when I call that procedure :
WARNING: line 8 at execute
Tom Lane said:
> "John Sidney-Woollett" <[EMAIL PROTECTED]> writes:
>> [ needs to make this fast: ]
>> -- locate the next order
>> select WCCustOrderID into vCustOrderID
>> from CUSTOMER.WCCustOrderStatusLog
>> where WCOrderStatusID = pStatusID
>> and Acknowledged is null
>> and Process
On Fri, 2004-04-16 at 00:17, Tom Lane wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > On Thursday 15 April 2004 04:20 pm, Tom Lane wrote:
>
> If we were to advance the QuerySnaphot between statements of a plpgsql
> function, the problem would go away because the SELECT would see
> tra
Robert Treat <[EMAIL PROTECTED]> writes:
> On Fri, 2004-04-16 at 00:17, Tom Lane wrote:
>> Now in this situation it is good to recognize the effects of other
>> transactions between statements of a plpgsql function, but it's not hard
>> to think up cases in which plpgsql functions would break if th
Scott,
> the sad thing is that while MySQL implemented a -ansi switch that
> supposedly turns on ansi compliance, it only fixes about 1/2 of all the
> non-compliance issues. Yet another half-implemented feature... :)
Plus they completely broke ansi-compliance with the latest version of
mysqld
Shalu Gupta <[EMAIL PROTECTED]> writes:
> I want to access the RelOptInfo data structure from the executor module.
You can't, because it doesn't exist any more. RelOptInfo is a planner
internal data structure, and is probably pfree'd before the executor starts.
Perhaps you could explain your pr
Giorgio Valoti <[EMAIL PROTECTED]> writes:
> Further points:
> - The sort command gives the same (wrong) results.
> - GUI (Cocoa) applications give the expected sort.
Hm, that's interesting.
> Any clues? Should I assume that if sort does not give the expected
> result, postgresql will not be dif
"John Sidney-Woollett" <[EMAIL PROTECTED]> writes:
> [ needs to make this fast: ]
> -- locate the next order
> select WCCustOrderID into vCustOrderID
> from CUSTOMER.WCCustOrderStatusLog
> where WCOrderStatusID = pStatusID
> and Acknowledged is null
> and Processing is null
> for upda
The java code is reasonably agnostic, provided the JDBC driver is smart
enough to
deal with any datatype properly as strings, although that intelligence
can be added.
Something else as a slave would be considerable easier, of course. For
something
else to be the master, you would have to find a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You might want to check out yesterdays thread with the subject
"Table Lock issue". Tom gave a really long and detailed explanation there
(which I'm very grateful for).
The problem you have looks similar, if not identical to the one in that
thread.
On Fri, 16 Apr 2004, Christopher Kings-Lynne wrote:
> > I always ran one of the 2 scripts (can't remember which one) and after that
> > started checking the dump file, because there were things that didn't get
> > changed correctly[1].
> >
> > [1]: I always remember the first conversion I did.
Yeah. It was my shell that was the bottleneck. What did the trick was
adding this line in /etc/profile:
ulimit -n 8000
Thanks!
Bruno Wolff III <[EMAIL PROTECTED]> writes:
It sounds like what is really happening is that
you are hitting an OS limit on the number of open files. You should be
able
Hello,
I am trying to work with the Postgresql-7.3.4 and can you
please help me with it.
I have the following problem:
I want to access the RelOptInfo data structure from the executor module.
Basically I have added a flag to the RelOptInfo data structure and at
the
time of execution I wan
Hi,
I'm trying to enable italian locale support on a Mac OS X host.
I run the initdb command with the following parameters (among others):
--encoding=UNICODE --locale=it_IT.UTF-8
then I created a new test database
test_locale=# \d test_sort
Table "public.test_sort"
Column | Type | Modifiers
> I'm wondering if anyone could have a script or something to help me
> with this situation... :(
Knowing that Unicode is composed of plain ASCII characters,
you may perform a conversion test using PHP "recode" function.
You may test each record as follows:
$test = recode ("latin1..u8", $record)
"Thomas Chille" <[EMAIL PROTECTED]> writes:
> Now I understand that i can not split easily my scripts into logical units but what
> i not understand is the documention not correct
> or is my problem not similiar to the example in point 37.4.3 on
> http://www.postgresql.org/docs/7.4/static/plpgsql
Hi
I'm building a web app where changes to customer orders are logged in the
following table, and I worried about the time that it will take to locate
records that need further processing/actioning. Here's the table:
create table CUSTOMER.WCCustOrderStatusLog (
WCCustOrderID integer,
WCO
On Mon, Apr 05, 2004 at 03:58:36PM +0200, Miguel Guzman Miranda wrote:
> I've been suggested to do a triggered procedure in Oracle so that
> everytime a file is inserted, deleted or updated, a perl script is run
> which modifies in turn the PSQL DB.
If you go to gborg and get the latest erse
Hi,
I'm trying to restore a pg_dump-backed up database from one
server to another. The problem is that the db is "mixed encoded"
in UTF-8 and LATIN1... (weird but, yes it is ! It was ported once
from a hypersonic db... that screwed up something and now I'm
fighting with that...).
So, trying to res
Tom Lane дµÀ:
weiping he <[EMAIL PROTECTED]> writes:
txn1: txn2:
begin; begin;
update table_a set col= col + 1; update table_a set col = col + 1;
end; end;
if two transaction begin at exact the same time,
what's the result of 'col' after both transactions committed
in Read committed le
Hello,
I have a PL/PGSQL stored procedure that makes me mad currently... (The
stored procedure is a procedure that simulates a materialized view)
It complains about a parse error when I call that procedure :
WARNING: line 8 at execute statement
ERROR: parser: parse error at or near "organizatio
Hello Tom,
thank u for your fast reply!
Now I understand that i can not split easily my scripts into logical units but what i
not understand is the documention not correct
or is my problem not similiar to the example in point 37.4.3 on
http://www.postgresql.org/docs/7.4/static/plpgsql-declarati
25 matches
Mail list logo