suggest that every point where commit and rollback are discussed,
there should be information about how to "Turn off auto-commit," even
if only a link.
Besides fixing the documentation for everyone, I'd like some information
now about how to "Turn off auto-commit."
xited with status 512 - abort
[root@dugite log]#
The actual messages are no surprise.
I appreciate that I've not provided a lot of information about what I'm
trying to do. However, I don't think that ANYTHING I do should case PG
to use so much disk for so little data.
--
ble disk space.
The problems I see
1) Documentation
2) Performance - there's no obvious need to use all this space
3) Performance - there's no (or insufficient) removal of old logs.
4) Recovery. I see no means of recovering short of either adding disk
or deleting the entire database.
ent on lists; it
almost inevitable results in a 24-hour delay.
--
Cheers
John Summerfield
Microsoft's most solid OS: http://www.geocities.com/rcwoolley/
Note: mail delivered to me is deemed to be intended for me, for my
disposition.
---(end of broadcast)-
The build instructions in the INSTALL documentation does not lead to the
documentation (HTML or man pages) being built.
Here are all the directories I have having followed the instructions:
[pgtest@possum pgtest]$ ls postgresql
total 24
drwxrwxr-x6 pgtest pgtest 4096 Sep 3 16:50 .
After much fun building ant (which, at the very least proved I have a
working javac AND that I don't need JAVA_HOME set, I get this failure
building PostgreSQL 7.2devel with Java support:
configure:1499: checking for executable suffix
configure:1509: gcc -o conftest -O2 -g conftest.c 1>&5
con
erl and python components to install into the
location I specified, and to leave me to discuss with Perl and Python
the question of how to make sure I get the right versions (or even
better, offer a handy hint).
--
Cheers
John Summerfield
Microsoft's most solid OS: http://www.geocities.co
On Fri, 7 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > I have postmaster configured to use syslog. Despite this, these messages appear on
>the terminal from which I start it:
> > 2001-09-03 23:44:37 [26371] DEBUG: recycled transaction l
This is explicity allowed in db2:
void f3(int i)
{
EXEC SQL BEGIN DECLARE SECTION;
char host_var_3[25];
EXEC SQL END DECLARE SECTION;
EXEC SQL SELECT COL2 INTO :host_var_3 FROM TBL2;
}
void f4(int i)
{
char host_var_3[25];
EXEC SQL INSERT I
ually the reason it gave for not installing the perl bits is that I
didn't have the authority. It would have been completely happy if I'd
been root.
And I wouldn't have.
--
Cheers
John Summerfield
Microsoft's most solid OS: http://www.geocities.com/rcwoolley/
Note: mail del
I'm using 7.2devel from CVS, and as I've already reported, the documentation doesn't
build.
Consequently I'm forced to rely on documentation for 7.1.2/3 which does not mention
-209, at least in the ecpg documentation I'm looking at,
Nore does it appear in the DB2 documentation I'm using as sec
I checked out the latest updates about 14 hours ago.
I've also put together a new box, featuring an Athlon running at 1.3 Mhz. I cloned the
OS (Red Hat Linux 7.1) - I'd copied it from one disk to another fairly recently, and
so the software setup is pretty well precisely what I've been using al
I've tried unsuccessfully to subscribe to some list. Majordom doesn't understand me.
I asked for help. Majordomo doesn't understand that either.
Thought I'd recheck the website to see what I really ought to do. I get this:
While trying to retrieve the URL: http://developer.postgresql.org/index.
Sorry all. There was a certain amount of nonsence in my previous posting on this topic.
The failing sql command is an fact a select into.
It fails when trying to retrieve a null value. The insert worked (I can retrieve the
record
if I don't ask for the null field, so evidently the insert code i
This worked 2-3 days ago: what's changed?
vs -z9 -q update
cvs update: authorization failed: server postgresql.org rejected access to
/home/projects/pgsql/cvsroot for user anoncvs
summer@dugite pgsql$
The entry's still in ~/.cvspass
---(end of broadcast)--
On Thu, 13 Sep 2001, Peter Eisentraut wrote:
> John Summerfield writes:
>
> > I'm using 7.2devel from CVS, and as I've already reported, the documentation
>doesn't build.
>
> http://www.ca.postgresql.org/devel-corner/docs/postgres/index.html
I don't
On Mon, 17 Sep 2001, Thomas Lockhart wrote:
> ...
> > I think that if it actually reused them instead of deleting old files...
>
> That is in fact what it does for at least the upcoming 7.2 release.
>
>
It's not what I see now in 7.2devel. Unless the changes are uncommitted (or commited
in the
werbsite's out of date.
As I noted, it was working.
>
> On Tue, 18 Sep 2001, John Summerfield wrote:
>
> > This worked 2-3 days ago: what's changed?
> >
> > vs -z9 -q update
> > cvs update: authorization failed: server postgresql.org rejected access to
The instructions at
http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html#ANONCVS do not work.
pgtest@dugite pgtest$ cvs -d
:pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot login
(Logging in to [EMAIL PROTECTED])
CVS password:
cvs login: authorization failed: server postgresql
On Wed, 19 Sep 2001, Justin Clift wrote:
> Tom Lane wrote:
> >
>
> > > While trying to retrieve the URL: http://developer.postgresql.org/index.php
> >
> > Where did you get that URL from? AFAIK we have never had such a site
> > name as "developer.postgresql.org".
>
> Hi Tom,
>
> This is the ne
On Fri, 21 Sep 2001, Vince Vielhaber wrote:
> On Fri, 21 Sep 2001, Tom Lane wrote:
>
> > John Summerfield <[EMAIL PROTECTED]> writes:
> > > I get response like this
> > > subscribe
> > > Illegal command!
> > > No valid commands proc
On Sat, 22 Sep 2001, Vince Vielhaber wrote:
> On Sat, 22 Sep 2001, Tom Lane wrote:
>
> > Vince Vielhaber <[EMAIL PROTECTED]> writes:
> > >> It would seem that that page is out of date. Vince, can you fix it?
> >
> > > Actually the instructions are correct.
> >
> > Are they? The last time I sub
On Tue, 18 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > I asked for help. Majordomo doesn't understand that either.
>
> What did you do exactly? The following message brought back a help
> response for me:
I get response like this
On Tue, 18 Sep 2001, Marc G. Fournier wrote:
>
>
> go to anoncvs.postgresql.org, not postgresql.org ..
Fails the same.
I used the password postgresql (by cut&paste).
>
> On Tue, 18 Sep 2001, John Summerfield wrote:
>
> > This worked 2-3 days ago: what's
On Wed, 19 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > Or if it is reusing them, it's renaming them too.
>
> That is what the "recycling..." message is all about...
>
1) Why rename them?
2) Does anyone have a better idea
This has me foxed.
I can build the source on one machine, Numbat.
On another, Dugite it fails. I'm using the same script (copied from Numbat
to Dugite for the occasion).
Both systems are running Red Hat Linux; Dugite was upgraded from RHL 6.2,
Numbat was a fresh install.
I'm building from a t
On 4 Oct 2001, Arcady Genkin wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
>
> > > g9genarc@eddie:~$ psql -h /var/pgsql --help
> > > psql was compiled without support for long options.
> > > Use --help for help on invocation options.
> > >
> > > I guess that it was confused by havi
On Thu, 11 Oct 2001, Bruce Momjian wrote:
>
> I have added documentation for code 209. Looks like there are other
> undocumented ones. Should we document them all?
If you're asking me, I'm all in favour of documenting them;-)
I'm not a fan of "Read the source," though I do it if I'm desperat
It used to be the case that psql could be run thus:
psql -U summer -h numbat template1 <
ZZ
which is very convenient in scripting.
Now, it writes a password prompt (successfully in my case) and tries to
read the password (presumably from the tty) which fails.
Here is the entire script that f
pls, link to the most important info - the release notes detailing
what's changed since a) RC1 abd b) 7.4.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
30 matches
Mail list logo
