On Fri, Jun 19, 2015 at 12:01 PM, Adrian Klaver
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 some point in time.
On Fri, 19 Jun 2015 13:46 Michael Paquier wrote:
On Fri, Jun 19, 2015 at 2:38 PM, James Sewell
wrote:
Hey All,
Is it possible to create WAL archive files on standby servers when using
streaming replication?
Yes and no, standbys do not archive WAL in ~9.4, but you could use
archive_mode = 'al
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 ; --with or without a cast
RETURN ;
END;
$$;
The goal is to return the value of text_to_return wit
"David G. Johnston" 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 ; --with or without a cast
> RETURN ;
> END;
> $$;
>
On Sat, Jun 20, 2015 at 10:56 AM, Tom Lane wrote:
> "David G. Johnston" 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 'te
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 (2,'T
Adrian Klaver writes:
> On 06/19/2015 01:05 PM, Paula Price wrote:
>
>>
>>
>> On Fri, Jun 19, 2015 at 12:01 PM, Adrian Klaver
>> mailto: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
"David G. Johnston" writes:
> On Sat, Jun 20, 2015 at 10:56 AM, Tom Lane wrote:
>
> "David G. Johnston" 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
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 vi
On Sat, 20 Jun 2015 10:44:21 -0700 (MST)
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
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
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 n
13 matches
Mail list logo
