On Wednesday 16 October 2002 06:54, Jyry Kuukkanen wrote:
> On Tue, 15 Oct 2002, Andreas Schmitz wrote:
> > I have a problem dumping with 7.2.3. When I do a pg_dumpall redirecting
> > this to a file I have >4 lines of schema and data. Running psql
> > template1 < the databases get partially c
On Tue, 15 Oct 2002, Andreas Schmitz wrote:
> I have a problem dumping with 7.2.3. When I do a pg_dumpall redirecting this
> to a file I have >4 lines of schema and data. Running psql template1 <
> the databases get partially created, i.e the schema is completely
> there but data even of
> One way might be to create a C (or C++) program that emulates your my_func
> function.
>
> We've tried doing this and did some benchmarks that show that the system
> works quite faster when you take out the stored procedures/functions and
> "translate" them into C programs.
Rightly said. C fun
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Rusty Wright wrote:
>> Are there commands provided with postgresql for checking the databases
>> and also for repairing them?
> We don't have checks because thing rarely break.
Or at least: there are seldom any programmable-in-advance patterns to
our f
"Marc Mitchell" <[EMAIL PROTECTED]> writes:
> We just encountered the same condition sited in the following post snipped
> from Goggle groups:
> FATAL 1: LWLockAcquire: can't wait without a PROC structure
> I could not find any info that said the cause or cure had been identified.
This is fixe
Rusty Wright wrote:
> Are there commands provided with postgresql for checking the databases
> and also for repairing them? I'd like to be able to run something to
> check the databases before our nightly backups.
We don't have checks because thing rarely break. You can do a VACUUM,
which does
Are there commands provided with postgresql for checking the databases
and also for repairing them? I'd like to be able to run something to
check the databases before our nightly backups.
Thanks
---(end of broadcast)---
TIP 5: Have you checked our
Sorry, nevermind; I discovered \? and figured it out.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I'm someone with some mysql experience and need to set up postgres for
a product we're evaluating. In mysql I can use SHOW DATABASES to list
all of the databases on the system, USE DB1 to switch to one of the
databases, SHOW TABLES to list all of the table names in the database
I'm USEing, and DE
We just encountered the same condition sited in the following post snipped
from Goggle groups:
>fredrik chabot <[EMAIL PROTECTED]> writes:
>> so I migrated the database to a non-smp machine running RH 7.2 and the
postgres
>> 7.2.1-5 rpm's
>>
>> Kernel 2.4.7-10
>>
>> and I still get
>>
>> FA
Andrew Sullivan wrote:
> On Mon, Oct 14, 2002 at 12:42:37PM -0700, David De Graff wrote:
>
> > Is this the same group that recently asked for input on their proposal,
> > which specified Postgres as the registry database?
>
> Hi everyone,
>
> Yes, this is us. (Sorry I've been inactive the last
Hello,
I have a problem dumping with 7.2.3. When I do a pg_dumpall redirecting this
to a file I have >4 lines of schema and data. Running psql template1 <
the databases get partially created, i.e the schema is completely
there but data even of the big tables is missing. The dumpfile itse
On Mon, 14 Oct 2002 11:13:46 -0400, Jeff Boes wrote:
> ERROR: cannot open segment 1 of relation table_D (target block
> 2337538109): No such file or directory
>
> and for table B:
>
> NOTICE: Child itemid in update-chain marked as unused - can't continue
> repair_frag
> ERROR: cannot open se
Michael Sheldon <[EMAIL PROTECTED]> writes:
> bash$ pg_dumpall > backup.data
> getAggregates(): SELECT failed. Explanation from backend: 'ERROR:
> Attribute 'aggtransfn1' not found
> '.
This looks like a problem with using an older (7.0?) pg_dump against a
newer database. Check your PATH to se
RTFM.
www.postgresql.org -> your favorite mirror -> interactive
documentation (http://www.postgresql.org/idocs/) -> SQL
Commands (http://www.postgresql.org/idocs/index.php?sql-commands.html)
-> ALTER TABLE (http://www.postgresql.org/idocs/index.php?sql-altertable.html)
It wasn't th
Are there the following SQL commands in psotgreSQL?
ALTER TABLE CATALOGITEM_LNK ADD
CONSTRAINT PK_CATALOGITEM_LNK PRIMARY KEY(catalogid,
itemid);
ALTER TABLE CATALOGITEM_LNK ADD
CONSTRAINT FK_CATALOGITEM_LNK_CATALOG FOREIGN KEY
(catalogid) REFERENCES CATALOG(id);
As you can probably figure out by now I want to back up my databases so
that I can upgrade to the latest version of PGSQL for a number of reasons.
I am having trouble though. See example below.
bash$ pg_dumpall > backup.data
getAggregates(): SELECT failed. Explanation from backend: 'ERROR:
At
On Mon, Oct 14, 2002 at 12:42:37PM -0700, David De Graff wrote:
> Is this the same group that recently asked for input on their proposal,
> which specified Postgres as the registry database?
Hi everyone,
Yes, this is us. (Sorry I've been inactive the last week. I was on
vacation.)
What follo
18 matches
Mail list logo
