On Mon, Nov 29, 2004 at 03:47:27PM -0500, [EMAIL PROTECTED] wrote:
> So does post not update a SERIAL column sequence when id's are
> manually entered? Would I have to manually do a nextval on the seq
> when manually setting id's? Should't post know that i used an id
> number and use the next avai
Michael Owens <[EMAIL PROTECTED]> writes:
> Yeah, that was it. I started to look into that after you last email
> and discovered that I had libedit installed. I was tinkering around
> with it a few weeks back. I just unmerged libedit and got it off my
> system. As soon as I tried to shutdown PG, pg
Michael Owens <[EMAIL PROTECTED]> writes:
> ... So it seems to be something related to reading the .psql_history file.
psql itself doesn't even know that .psql_history exists; that file is
only touched by the readline library (or possibly libedit, if you are
using that instead of readline; not lik
On Mon, 2004-11-29 at 17:10 -0600, Michael Owens wrote:
> This problem seems to be related to the .psql_history file. If I
> delete the file, the problem does not occur and psql starts up fine.
> However, when I run psql again (after the previous session had
> generated a .psql_history file), the p
This problem seems to be related to the .psql_history file. If I
delete the file, the problem does not occur and psql starts up fine.
However, when I run psql again (after the previous session had
generated a .psql_history file), the problem occurs. strace shows
something like
read(4, "", 131072)
Hello Everyone,
My name is Matt, this is my first post to the list. I've been using post
for a while and love it. I haven't had any issues with it and i have found it
to be a great and very flexible system.
That said... I looked through the archives a bit but could not find what i was
loo
I have two identical Dell Dimension 8400's running the exact same
versions of Gentoo Linux, running the same build for PG 8.0 Beta 5.
One box works fine. The other, no matter what I do, eventually runs
into what appears to be an infinite loop trying to connect to the
postmaster. It virtually brings
"Luciano - UNILOG SA" <[EMAIL PROTECTED]> writes:
> createlang: language installation failed: ERROR: could not load library =
> "C:/Arquivos de programas/PostgreSQL/8.0.0-beta5/lib/pltcl.dll": error
> What the problem ?
Good question. The unhelpful error message can evidently be blamed on
this
Hello,
As the documentation describes the AGE() function -
http://developer.postgresql.org/docs/postgres/functions-datetime.html#FUNCTIONS-DATETIME-TABLE
,
there are two signatures:
- AGE(timestamp);
- AGE(timestamp, timestamp).
I think the documentation is misleading, because AGE(timestamp) is
But the description says: vacuum can run parallel to selects.
This is than not true.
Regards,
Michael
Tom Lane schrieb:
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
Description:after update: vacuum blocks parallel to select
This isn't a bug, it's simply vacuum waiting until it can ac
Hello
I'm trying to create a new language in my database
(pg 8 beta5 - Windows Xp) and the error message show me.
C:\Arquivos de
programas\PostgreSQL\8.0.0-beta5\bin>createlang.exe pltcl -d supremus -h
localhost -U administradorPassword:createlang: language installation
failed: ERROR: c
Neil Conway <[EMAIL PROTECTED]> writes:
> (2) The syntax error message is wrong (we print a character offset and
> query context that is relative to the CREATE FUNCTION statement, not the
> individual SQL statement we're executing). I fooled around a bit with
> defining a custom ereport() callback
"Enke, Michael" <[EMAIL PROTECTED]> writes:
> But the description says: vacuum can run parallel to selects.
> This is than not true.
Sure it can; but that doesn't mean there is no interlocking at all.
The issue you have is not so much that the select is running as that it
is *not* running, ie, it
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> Description:after update: vacuum blocks parallel to select
This isn't a bug, it's simply vacuum waiting until it can acquire a
page-level lock.
regards, tom lane
---(end of broadcast)
The following bug has been logged online:
Bug reference: 1332
Logged by: Robert Grabowski
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: Linux
Description:wrong results from age function
Details:
select age('2004-02-01'::date, '200
The following bug has been logged online:
Bug reference: 1331
Logged by: Michael Enke
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.5
Operating system: Linux SuSE 9.1 Kernel 2.6/RedHat 9 Kernel 2.4
Description:after update: vacuum blocks parallel to sel
Hi,
A further clue that can help to resolve this bug:
I tried to install it on Windows 2000 & it works fine. So I think the issue
might be only for Windows XP Professional systems.
Regards,
Mehul
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mehul
D
17 matches
Mail list logo
