Re: pg_tablespace_databases

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_tablespace_databases
Date: 2004-07-02 07:41:05
Message-ID: 40E51191.1070104@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Joe Conway wrote:

>
> Attached is the patch I plan to apply. There are a couple of changes
> from what was posted.
>
> 1) You must have meant tablespace instead of namespace here:
> ------------------------------------------------------------
> + <row>
> +
> <entry><literal><function>pg_tablespace_databases</function>(<parameter>namespace_oid</parameter>)</literal></entry>
>
> + <entry><type>setof oid</type></entry>

Of course. I just call everything namespace :-)

> 2) This allocation size was a bit ambigous and I think based on a once
> longer tablespace directory name:
> ------------------------------------------------------------
> + fctx->location = (char*)palloc(strlen(DataDir)+16+10+1);

This size calculation originated (copy/paste) from
commands/tablespace.c, should be clarified there too (and "pg_tblspc" is
hardcoded in strings, could be extracted to a macro definition).

Regards,
Andreas

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Daniel Baldoni 2004-07-02 12:15:55 First attempt: support for "\dg" in psql
Previous Message Simon Riggs 2004-07-02 07:27:40 Re: PITR Archive Recovery