[Sent again as it did not seem to come through]
Paul,
Yes, all of our software works this way - that way it fits in nicely with an
organization's internal systems and permissions: they might have their access
mechanisms tied into other systems (LDAP, Kerberos or whatever). If you don't
use thi
On Mittwoch 29 April 2009 Michael Monnerie wrote:
> ERROR: CLUSTER cannot be executed from a function or multi-command
> string
>
> I got this error from a script which tried:
> psql -U postgres db1 -c 'cluster ; analyze'
>
> In the docs there's no word that it's not possible, and I wonder why
> t
Michael Monnerie wrote:
> ERROR: CLUSTER cannot be executed from a function or multi-command
> string
>
> I got this error from a script which tried:
> psql -U postgres db1 -c 'cluster ; analyze'
>
> In the docs there's no word that it's not possible, and I wonder why
> this is not allowed. An
Michael Monnerie wrote:
> On Mittwoch 29 April 2009 Alvaro Herrera wrote:
> > Multi-table cluster (i.e. the one where you don't specify one table
> > to cluster) cannot be used in a transaction block, function, etc, and
> > the FM does mention it:
> Ah, found this now, in the docs 8.1-8.3. But st
On Mittwoch 29 April 2009 william pink wrote:
> Hi,
>
> Unfortuneatly the partition that has the Postgres DB has filled up
> beause of files in the Postgres directory. this partition is 85GB
>
> I tried using Table space to point it at a new partition so I did
>
> exampledb=# CREATE TABLESPACE fast
