Hi,
How can I query the following information from the catalog:
- max number of index columns;
- max number of function arguments;
As far as I know these are compile-time constants, default is 32.
Thanks,
Otto
---(end of broadcast)---
TIP 5: don
Hi,
What is the cause that "now()" works but "now" does not and
"current_user" works but "current_user()" does not. They are both
functions, and are present in pg_proc. How can I decide if a function
needs parentheses or not if it has no parameters?
Thanks in advance,
Otto
--
Hello,
I would like to move the data directory to another location. I have done this:
1. Stop PostgreSQL
2. Move data directory
3. Create a PGDATA env. variable to the new location
4. Start PostgreSQL
And it cannot start, because it cannot find postgresql.conf. (in Event log)
What should I do now
Magnus,
It's a service, and it is 8.0.6. I have fixed the registry to this
value: "C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe" runservice -N
"pgsql-8.0" -D "E:\PostgreSQL\data\"
The service does not start.
This new directory definetely exists. But now there is no Event log
entry about the err
g_ctl register to register a new one with the new data
> directory. Doing this you won't hvae to reboot.
>
>
> Perhaps this is something we should add to pg_ctl for 8.2? "pg_ctl
> reconfigure" or something like that? What do others think?
>
> //Magnus
>
> &
> --
> I know not english well, but I know 9 computer languages.
> Pinoy Ako!
>
> -----Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ottó Havasvölgyi
> Sent: Saturday, January 14, 2006 7:38 AM
> To: Magnus Hagander
> Cc: Pg - General
