| psql
unit |
category | Reporting and Logging / What to Log
short_desc | Sets the application name to be reported in statistics and logs.
extra_desc |
context| user
vartype| string
source | client
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgs
2011/6/22 Jaime Casanova :
> On Wed, Jun 22, 2011 at 3:28 AM, Emanuel Calvo wrote:
>> I'm still finding pg_create_restore_point in 9.1a2 documentation:
>> http://www.postgresql.org/docs/9.1/static/functions-admin.html
>>
>> But I've compiled that version
orrect but in other releases it displays all
the functions (as \d displays
all the relations in this one).
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
>> I'm doing like other versions:
>
>> make; make install
>
> That's correct.
>
>> and then:
>> psql < .sql
>
> That's not correct anymore. Use CREATE EXTENSION.
>
Thanks Tom, I thougth that the old way was al
ke install
and then:
psql < xxxx.sql
Does it change for 9.1?
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ity :(.
>
Good point.
> PL/PSM has different philosophy where full check is implemented now.
>
Do you think that make some test in 9.1 worthwhile for this
language? I see that the last contrib was submitted years ago.
Regards,
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
El 27/05/2011 16:18, "Heikki Linnakangas" <
heikki.linnakan...@enterprisedb.com> escribió:
> On 27.05.2011 17:05, Emanuel wrote:
>> postgres=# CREATE OR REPLACE FUNCTION p_() RETURNS TABLE (i int) AS $$
>> DECLARE
>> BEGIN
>> SELECT * FROM p; --<<<-- here must ne RETURN QUERY ..
>> END;
>> $$ LANGU
he problem will comes when the standby is promoted to master, in that
case I didn't test what happens (file not exists, i think it will
couldn't insert data
directly or may force to the dba drop the table from catalog).
--
--
Emanuel Calvo
Helpame.com
--
ation for Solaris are in the site #1, you will find since
installation until complex trace rutines.
Enjoy it!
#1[http://www.sun.com/software/products/postgresql/index.jsp]
Regards,
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
