On 1 Oct 2003 at 22:19, Mailing List wrote:
[...]
now on W2K and W2003
When I try to initialize dbspace using initdb, for example:
[...]
I will get such information:
[...]
IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed:
Function not
implemented
initdb
On 2 Oct 2003 at 10:45, Kerv wrote:
Jarek Lubczyn'ski wrote:
Hi, everybody,
Please help me with an urgent problem.
[...]
When I try to initialize dbspace using initdb, for example:
.
initdb -D /cygdrive/d/database/postgres --username=myuser -W -E
LATIN2
Tom,
Will this be fixed in 7.4?
Thanks for the support.
Rob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
Date: Thursday, October 2, 2003 6:28 pm
Subject: Re: [ADMIN] pg_restore fails - postgres 7.3.4
Rob Long [EMAIL PROTECTED] writes:
Trying to dump and restore a
Rob Long [EMAIL PROTECTED] writes:
Will this be fixed in 7.4?
Yes, and also in 7.3.5 if there is such a release.
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Title: RE: [ADMIN] Delete accident
Thank you everyone!
I got a load of responses, and don't want to keep anyone working at this.
the magic is in pgfsck! http://svana.org/kleptog/pgsql/pgfsck.html
-anya
Trying to dump and restore a production database with no success.
pg_dump database using the following:
pg_dump -v -b -C -Fc -U postgres -f servdb.tar.gz servdb
pg_restore with with following:
pg_restore -v -C -D template1 -Fc -U postgres servdb.tar.gz
restore fails with:
pg_restore:
I've only just now noticed that CREATE INDEX accepts a 'WHERE' clause.
This is used to create something called a partial index. Hmm, ever
being one who sees the world as made of nails when first given a hammer ...
One of our tables, with a couple hundred thousand rows) has a
date-column
Jeff Boes [EMAIL PROTECTED] writes:
If I created the index as something like:
CREATE INDEX ix_foo ON foo(the_date)
WHERE the_date = now() - interval '24 hours';
what might I expect as the impact?
You won't be allowed to, because now() isn't immutable, and only
immutable functions
Hi all,
Is there a script where u can get list of sequences ,the tables associated with it and the column for which these sequences are created.
Thanks in advance
SG Instant message during games with MSN Messenger 6.0. Download it now FREE!
Is there a script that gives a list of sequences and the tables associated with it and the columns associated with it
Thanks in advance
SG Instant message in style with MSN Messenger 6.0. Download it now FREE!
In an attempt to throw the authorities off his trail, Jeff Boes [EMAIL PROTECTED]
transmitted:
I've only just now noticed that CREATE INDEX accepts a 'WHERE'
clause. This is used to create something called a partial index.
Hmm, ever being one who sees the world as made of nails when first
It won't work.
You could instead have a separate boolean attribute called 'expired' for
each row. Set this to true whenever you expire the row, and create the
partial index using that attr.
Matt
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeff Boes
Hi
the problem is to avoid users from viewing functions code (in general db
structures) when connecting to db by means of pgpadmin client.
My db contains several tables and functions and I need to make users viewing
only a restricted
number of tables. It works for tables, as it's possible to
13 matches
Mail list logo