On Fri, Jun 19, 2015 at 12:01 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 06/18/2015 05:45 PM, Paula Price wrote:
I have Postgresql 9.2.10 streaming replication set up with log shipping in
case the replication falls behind. I discovered that the log-shipping had
been disabled at
On Fri, 19 Jun 2015 13:46 Michael Paquier michael.paqu...@gmail.com wrote:
On Fri, Jun 19, 2015 at 2:38 PM, James Sewell james.sew...@lisasoft.com
wrote:
Hey All,
Is it possible to create WAL archive files on standby servers when using
streaming replication?
Yes and no, standbys do not
David G. Johnston david.g.johns...@gmail.com writes:
I know this could be written quite easily in sql but was wondering if it is
possible in pl/pgsql.
CREATE FUNCTION test_func()
RETURNS text
LANGUAGE 'plpgsql'
AS $$
BEGIN
SELECT 'text_to_return' INTO what_goes_here?; --with or without a
On Sat, Jun 20, 2015 at 10:56 AM, Tom Lane t...@sss.pgh.pa.us wrote:
David G. Johnston david.g.johns...@gmail.com writes:
I know this could be written quite easily in sql but was wondering if it
is
possible in pl/pgsql.
CREATE FUNCTION test_func()
RETURNS text
LANGUAGE 'plpgsql'
AS
Adrian Klaver adrian.kla...@aklaver.com writes:
On 06/19/2015 01:05 PM, Paula Price wrote:
On Fri, Jun 19, 2015 at 12:01 PM, Adrian Klaver
adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote:
On 06/18/2015 05:45 PM, Paula Price wrote:
I have Postgresql 9.2.10
David G. Johnston david.g.johns...@gmail.com writes:
On Sat, Jun 20, 2015 at 10:56 AM, Tom Lane t...@sss.pgh.pa.us wrote:
David G. Johnston david.g.johns...@gmail.com writes:
I know this could be written quite easily in sql but was wondering if
it is
possible in pl/pgsql.
I know this could be written quite easily in sql but was wondering if it is
possible in pl/pgsql.
CREATE FUNCTION test_func()
RETURNS text
LANGUAGE 'plpgsql'
AS $$
BEGIN
SELECT 'text_to_return' INTO what_goes_here?; --with or without a cast
RETURN what_goes_here?;
END;
$$;
The goal is to return
Hello
The solution proposed by Tom works as long as you can make sure that
your SELECT statement in the function will return a single row with a
single column of type TEXT:
CREATE TABLE test (id INTEGER, what_goes_here TEXT);
INSERT INTO test values (1,'Text 1');
INSERT INTO test values
In PostgreSQL I have this table... (there is a primary key in the most left
side timestamp02 which is not shown in this image)
in the table above, all columns are entered via querrys, except the
time_index which I would like to be filled automatically via a trigger
each time each row is filled.
On 06/20/2015 10:44 AM, litu16 wrote:
In PostgreSQL I have this table... (there is a primary key in the most left
side timestamp02 which is not shown in this image)
in the table above, all columns are entered via querrys, except the
time_index which I would like to be filled automatically via a
On 06/20/2015 12:41 PM, Charles Clavadetscher wrote:
Hello
I just made a short test with the code provided. As Bill mentioned the
moment when the trigger is fired is essential.
I made a test with both before (worked) and after (did not work because
the row was already inserted and the returned
On Sat, 20 Jun 2015 10:44:21 -0700 (MST)
litu16 litumelen...@gmail.com wrote:
In PostgreSQL I have this table... (there is a primary key in the most left
side timestamp02 which is not shown in this image)
in the table above, all columns are entered via querrys, except the
time_index which I
Hello
I just made a short test with the code provided. As Bill mentioned the
moment when the trigger is fired is essential.
I made a test with both before (worked) and after (did not work because
the row was already inserted and the returned new row is ignored).
The assignment (= or :=) does
13 matches
Mail list logo