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
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:
like that? What do others think?
//Magnus
-Original Message-
From: Ottó Havasvölgyi [mailto:[EMAIL PROTECTED]
Subject: Re: [GENERAL] Moving PostgreSQL data directory on Windows
Magnus,
It's a service, and it is 8.0.6. I have fixed the registry to this
value: C:\Program Files
-
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
Subject: Re: [GENERAL] Moving PostgreSQL data directory on Windows
Hello,
Ok. I did not set any security on the machine. Only I have
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
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 error.