;,null), ('correct','wrong','notsure'),
('second','second1','second3')) x
db-# ;
col1 | col2 | col3
--+--+--
null | abc | null
(1 row)
Its work correct. It returns first row value for a column.
--Sudalai
-
sudalai
--
View this messa
econd_element (ANYARRAY)
RETURNS ANYELEMENT AS $$ SELECT $1[2]; $$ LANGUAGE SQL;
-- create first aggregate function that return first_row item value
CREATE AGGREGATE first(anyelement)(
SFUNC=two_value_holder,
STYPE=ANYARRAY,
INITCOND='{NULL}',
FINALFUNC=second_element
);
I hope
slave) to create multiple tablespaces.
-
sudalai
--
View this message in context:
http://postgresql.nabble.com/File-count-restriction-of-directory-limits-number-of-relations-inside-a-database-tp5844711p5845044.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
--
errmsg("could not remove symbolic link
\"%s\": %m",
linkloc)));
}
}
/*
* Create the symlink under PGDATA
*/
if (symlink(newlocation, link
ed to change the recovery.conf
file and restart the standby node.
but,
*I Need to change masterip without restarting the standby node.*
-
sudalai
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Dynamically-change-Master-recovery-info-without-restarting-standby-
Hi,
I need to query master ip from hot_standby.
*pg_stat_replication* view only shows the slave replication status.
Is there any way to get *Master IP* from standby node apart from checking
*recovery.conf* file.
Thanks,
Sudalai
-
sudalai
--
View this message in context:
http