Re: Where is pg_create_restore_point funciton in 9.1a2 ?

On Wed, Jun 22, 2011 at 3:28 AM, Emanuel Calvo <postgres(dot)arg(at)gmail(dot)com> 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 and I didn't found it:
>
> postgres=# \df *create_restore*
>                       List of functions
>  Schema | Name | Result data type | Argument data types | Type
> --------+------+------------------+---------------------+------
> (0 rows)
>

the function exists... and it should appear, it does for me

postgres=# \df *create_re*
List of functions
Schema | Name | Result data type | Argument
data types | Type
------------+-------------------------+------------------+---------------------+--------
pg_catalog | pg_create_restore_point | text | text
| normal
(1 row)

postgres=# select pg_create_restore_point('jcm');
ERROR: WAL level not sufficient for creating a restore point
HINT: wal_level must be set to "archive" or "hot_standby" at server start.
STATEMENT: select pg_create_restore_point('jcm');

>
> By the way, another issue that I found is when I execute \df. It
> doesn't display anything (I must
> force with * to do that).

i can confirm this

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación