Thank You sir. for your kind to answering my email.
if try it but the default is in the c:\. how can i move it to d:\DataPG
??
Dedy Styawan
Olivier Martineau writes:
You just have to run again the initdb command with -D option :
initdb - D D:\DataPG
Then, you'll have to start the databas
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> On Sun, Mar 27, 2005 at 13:24:34 +0800,
> Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
>>> I'm looking for an existing function which allows me to search the nearest
>>> neighbours of the requested value.
>>
>> Well you could try something like
On Sun, Mar 27, 2005 at 13:24:34 +0800,
Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
> >I'm looking for an existing function which allows me to search the nearest
> >neighbours of the requested value.
>
> Well you could try something like:
>
> SELECT * FROM table ORDER BY ABS(val - 2) LIM
Jos van Roosmalen <[EMAIL PROTECTED]> writes:
> Can someone explain me how to repair a table?
> If I execute a 'select * from ' in PSQL I get the next
> error. A pg_dump export only partially export the broken table and
> ends with the same error:
> "Invalid memory alloc request size: 429496
On Tue, Mar 22, 2005 at 09:31:45PM -0600, root wrote:
> I have a postgres 7.2.2 database, without the DB_VERSION file, so I'm assuming
> this is an "alternate location" - as you can tell, I'm not a DBA. Anyway,
> the machine it was on got hacked, and I backed off the things I thought were
> impor
On Wed, Mar 23, 2005 at 17:26:18 +0100,
"Dr. Roger Wießner" <[EMAIL PROTECTED]> wrote:
> Why occurs this message each time I post something:
Because you aren't subscribed to the list under the address you are
advertising. Posts from nonsubscribers are held for moderation in order
to cut down on
On Wed, Mar 23, 2005 at 16:20:03 +0100,
"Dr. Roger Wießner" <[EMAIL PROTECTED]> wrote:
> Hallo!
>
> Is there a way to ´GRANT ALL TO PUBLIC´?
> (All tables, sequences and indexes at once?)
You can write a script to do it. I believe examples have posted previously
and are in the archives.
> Or:
On Tue, Mar 22, 2005 at 11:22:07 +0530,
Rajarshi Mukherjee <[EMAIL PROTECTED]> wrote:
> Dear Sir/Madam,
>
> I have a problem regarding grants in PG. It is as follows:
>
> I wanted to grant execute on a function that updates a table.
> But i got an ERROR: permission denied for relation
>
> Now
Hello,
Can someone explain me how to repair a table?
If I execute a 'select * from ' in PSQL I get the next
error. A pg_dump export only partially export the broken table and
ends with the same error:
"Invalid memory alloc request size: 4294967290"
Note that this number is really close to 2^3
