The following bug has been logged online:
Bug reference: 1090
Logged by: Simon
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: windows and cygwin
Description:initdb does not work
Details:
hi,
I installed the last version of cygwin(the
-原始邮件-
发件人: 帅猛 [mailto:[EMAIL PROTECTED]
发送时间: 2004年3月3日 10:41
收件人: '[EMAIL PROTECTED]'
主题: docs on tsearch2
hi all
Are there any other docs about tsearch2 except for the 3 docs in \contrib\tsearch2\docs
i want some tech docs on tsearch2 thank all
-
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> Description:pg_restore fails when restoring lo.sql functions from
> contrib
Hmm. It looks like the code for dumping CREATE CAST fails if the cast
function is from a schema other than pg_catalog. I'm amazed we did not
notice this when
PostgreSQL Bugs List wrote:
This works fine on Linux using 7.3.4. It also worked on 7.2.x on Cygwin.
FWIW, I can reproduce this problem with CVS HEAD.
-Neil
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://ww
Jeff Bohmer <[EMAIL PROTECTED]> writes:
Great! I'd like to try out the patch when it's ready.
Here ya go.
Works for me on OS X and Linux.
Thank you very much!
- Jeff
--
Jeff Bohmer
VisionLink, Inc.
_
303.402.0170
www.visionlink.org
_
The following bug has been logged online:
Bug reference: 1089
Logged by: Joseph Tate
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Win32/Cygwin
Description:pg_restore fails when restoring lo.sql functions from
contrib
Details:
I'v
Jeff Bohmer <[EMAIL PROTECTED]> writes:
> Great! I'd like to try out the patch when it's ready.
Here ya go.
regards, tom lane
Index: src/backend/executor/execAmi.c
===
RCS file: /cvsroot/pgsql-server/src/bac
I think the problem is similar to the FAQ item about using temp tables
in plpgsql functions. On your first plpgsql call, the function body is
compiled and cached for future calls. If the index is dropped, the
cached function doesn't know that and errors out. We really need some
dependency code
I should have a patch later today.
Great! I'd like to try out the patch when it's ready.
Thanks,
- Jeff
--
Jeff Bohmer
VisionLink, Inc.
_
303.402.0170
www.visionlink.org
_
People. Tools. Change. Community.
---
Jeff Bohmer <[EMAIL PROTECTED]> writes:
> Running any of these statements on my database causes the backend to
> crash (example from PG log below):
Crash confirmed here. Seems to be a side-effect of the 7.4 optimization
that tries to avoid "unnecessary" projection steps. In the "SELECT *
FROM f
Reproduced in PG 7.4.1 on ...
OS X Server 10.2.8
OS X 10.2.8
RHL 9 (2.4.20-30.9)
Running any of these statements on my database causes the backend to
crash (example from PG log below):
create temp table foo as select * from server_prefs limit 1;
create table foo as select * from server_prefs lim
On Tuesday 02 March 2004 14:09, PostgreSQL Bugs List wrote:
> The following bug has been logged online:
>
> Bug reference: 1088
> Logged by: Antonino Albanese
> Email address: [EMAIL PROTECTED]
> Description:Name resolution connecting to a database
> trying to connect t
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> trying to connect to the server with domain name
> takes long time, here an example:
> ...
> but every thing works fine if I use the IP address:
There's something wrong with your DNS setup. You'll probably find that
the same delay occurs with a
=?gb2312?B?y6fDzQ==?= <[EMAIL PROTECTED]> writes:
> when i debug ,i can break at function such as gistgettuple,gistfirst,gistnext
> BUT when i create table and index this way( just create the index after i have
> inserted data ) ,i can't debug gist,why?
CREATE INDEX doesn't go through any of tho
The following bug has been logged online:
Bug reference: 1088
Logged by: Antonino Albanese
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Linux server.sitvallee.it 2.4.20-28.7smp #1 SMP Thu Dec
18 11:18:31 EST 2003 i686 unknown
Description:
hi all
i create table and index following the doc of tsearch2-guide.html
this way:
=#CREATE TABLE docs ( id SERIAL, doc TEXT, vector tsvector )
=# CREATE INDEX docs_index ON docs USING gist(vector);
CREATE FUNCTION insdoc(text) RETURNS void LANGUAGE sql AS
'INSERT INTO docs (doc, vector
I droped all source and imported cvs repository. initdb was successful
after it.
regards
Pavel Stehule
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not mat
17 matches
Mail list logo
