[BUGS] BUG #2297: plpgsql function causes disconnect sometimes

2006-03-04 Thread bernd

The following bug has been logged online:

Bug reference:  2297
Logged by:  bernd
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system:   Linux Fedora Core 3
Description:plpgsql function causes disconnect sometimes
Details: 

I'm trying to make some admin functions that I can use to revoke privileges
from users. The functions are all stored in a schema called admin. Here are
the functions:

---
create or replace function admin.fn_show_functions(text)
returns setof text as $$
declare
v_schema alias for $1;
v_schema_oid oid;
v_function pg_catalog.pg_proc%rowtype;
v_function_arg text;
v_function_name_and_args text;
begin
select into v_schema_oid oid
from pg_catalog.pg_namespace
where nspname = v_schema;

if found then
for v_function in select * from pg_catalog.pg_proc
where pronamespace = v_schema_oid
loop
v_function_name_and_args := v_function.proname || '(';

for i in 0..(v_function.pronargs - 1)
loop
select into v_function_arg typname
from pg_catalog.pg_type
where oid = v_function.proargtypes[i];

if v_function_arg is not null then
v_function_name_and_args := v_function_name_and_args ||
v_function_arg || ', ';
end if;
end loop;

v_function_name_and_args := trim(trailing ', ' from
v_function_name_and_args);
v_function_name_and_args := v_function_name_and_args || ')';

return next v_function_name_and_args;
end loop;
end if;

return;
end;
$$
language plpgsql;
---
create or replace function admin.fn_revoke_all_functions_from(text, text)
returns void as $$
declare
v_user alias for $1;
v_schema alias for $2;
v_obj record;
begin
for v_obj in select * from admin.fn_show_functions(v_schema) as
name
loop
raise notice 'revoking function %', v_obj.name;
execute 'revoke all on function ' ||
quote_ident(v_schema) || '."' ||
replace(v_obj.name, '(', '"(') || ' from ' ||
quote_ident(v_user);
end loop;
end;
$$
language plpgsql;
---
create or replace function admin.fn_revoke_all(text)
returns void as $$
declare
v_user alias for $1;
v_schema record;
v_obj record;
v_current_db text;
begin
for v_schema in select * from admin.fn_show_user_schemas() as name
loop
raise notice 'revoking all functions from % in %', v_user,
v_schema.name;
perform admin.fn_revoke_all_functions_from(v_user, v_schema.name);
end loop;
end;
$$
language plpgsql;
---
create or replace function admin.fn_show_user_schemas()
returns setof text as $$
declare
v_schema pg_catalog.pg_namespace%rowtype;
begin
for v_schema in select * from pg_catalog.pg_namespace
where not (nspname like 'pg_%' or nspname like 'information_schema')
loop
return next v_schema.nspname;
end loop;
end;
$$
language plpgsql;
---

When I execute:

SELECT * FROM admin.fn_revoke_all('someuser');

I sometimes get disconnected with this message:

server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>

and in the log I have:

LOG:  server process (PID 16202) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2006-03-02 10:50:01 CST
LOG:  checkpoint record is at 0/D004564
LOG:  redo record is at 0/D004564; undo record is at 0/0; shutdown FALSE
LOG:  next transaction ID: 26852; next OID: 101599
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  connection received: host=[local]
FATAL:  the database system is starting up
LOG:  redo starts at 0/D0045A8
LOG:  record with zero length at 0/D037BCC
LOG:  redo done at 0/D037BA4
LOG:  database system is ready

Since I have some RAISE NOTICE statements, I can see that the function
fn_revoke_all disconnects me right after it finishes revoking on all the
functions.

I have reproduced this behaviour on another machine with PostgreSQL 8.1.1
running CentOS 3. It doesn't matter which database I use, the result is the
same.

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [BUGS] BUG #2850: Cannot select from information_schema.schemat

2006-12-21 Thread Bernd Helmle
--On Donnerstag, Dezember 21, 2006 15:47:40 + Tony Marston 
<[EMAIL PROTECTED]> wrote:



The fact that the SQL standard says that the schemata view is supposed to
"Identify the schemata in a catalog that are owned by a given user" does
not automatically mean that the information can *ONLY* be accessed by the
owner. Any user should be able to see the schema to which they have
access, owner or not.


The standard doesn't specify any given user, it specifies CURRENT_USER. Only
if CURRENT_USER is the owner of a schema (or CURRENT_USER inherits
ownership by membership) you are able (and allowed) to see the schema. While
I admit that this makes it hard to identify catalog schemata by an DBA via
the information_schema, the standard is quite clear here. I don't see any
ambiguity here

If you need to go beyond what the standard allows, you have to use the 
system

catalog.

--
 Thanks

   Bernd

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate


[BUGS] BUG #3255: Proper escaping missing

2007-04-27 Thread Bernd Fuhrmann

The following bug has been logged online:

Bug reference:  3255
Logged by:  Bernd Fuhrmann
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system:   Windows XP SP2
Description:Proper escaping missing
Details: 

I just tried to use pgAdmin to create a database with a stupid name:
test"test
This doesn't work since sends this:
CREATE DATABASE "test"test"
  WITH ENCODING='UTF8';

Obivously, if I just enter 'test"test' into the field it rather should have
sent this:

CREATE DATABASE "test""test"
  WITH ENCODING='UTF8';

So I guess pg3Admin is missing proper escaping.

Btw. using the name test""test created the database I wanted, but that will
lead to a lot of other troubles when administrating that database with
pgAdmin.

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [BUGS] BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-04 Thread Bernd Helmle



--On 4. Juni 2010 15:19:42 -0400 Bruce Momjian  wrote:


That would make the bug go away,
rather than require users to use a special flag (and find out only after
they were doing the reload).


Out of curiosity, why is this a "bug" now? We recommend migration 
procedures always to use the pg_dump of the newer version because of many 
reasons as clearly stated here:


   <http://www.postgresql.org/docs/8.4/interactive/migration.html>

And wouldn't introducing backpatching such behavorial changes to pg_dump 
violate our policy in *not* to change such things in minor releases? (think 
of diff's against schema-only dumps and so on).


   Bernd


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored

2010-07-15 Thread Bernd Helmle



--On 12. Juli 2010 14:39:19 -0400 Tom Lane  wrote:


Yeah.  Past discussions of this have leaned to the viewpoint that we
should disallow the above, ie it should not be possible to have NOT NULL
on the parent unless all the children have it too.  Nobody's got round
to implementing it though.  There's a TODO item for it: see
"Move NOT NULL constraint information to pg_constraint"



FYI, i'm currently working on it, see

<https://commitfest.postgresql.org/action/patch_view?id=312>


   Bernd


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] Psql malloc error on Git master

2011-01-21 Thread Bernd Helmle



--On 20. Januar 2011 21:56:44 + Thom Brown  wrote:


Known bug in OSX's libedit.  Use readline instead.

http://archives.postgresql.org/pgsql-bugs/2010-04/msg00127.php

                       regards, tom lane


How do I force readline?  I'm not using --with-libedit-preferred or
--without-readline


What I've done is to switch to MacPorts[1] and use their packaging. I'm 
building PostgreSQL then with:


--with-libraries=/opt/local/lib --with-includes=/opt/local/include

which for example links psql/libreadline with:

% otool -L $PGSQL_HOME/bin/psql
/Users/bernd/pgsql-dev/install/HEAD/bin/psql:
	/Users/bernd/pgsql-dev/install/HEAD/lib/libpq.5.dylib (compatibility 
version 5.0.0, current version 5.4.0)
	/opt/local/lib/libintl.8.dylib (compatibility version 10.0.0, current 
version 10.1.0)
	/opt/local/lib/libssl.1.0.0.dylib (compatibility version 1.0.0, current 
version 1.0.0)
	/opt/local/lib/libreadline.6.1.dylib (compatibility version 6.0.0, current 
version 6.1.0)


Works quite well for me. There's also a libedit in MacPorts, but i've never 
used it.


   Bernd

[1] <http://www.macports.org/>


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] Warm Standby startup process unconditionally hangs

2011-03-21 Thread Bernd Helmle
PostgreSQL is 8.4.7, WAL-Logshipping is actually using SkyTools 2.1.12 
(both installed from PGDG rpms), running with CentOS 5.5 XEN-VM with Kernel 
2.6.18-194.26.1.el5xen.


recovery.conf on the standby installed by walmgr is

restore_command = '/usr/bin/walmgr.py 
/media/pgarchive/wal-config/wal-slave.ini xrestore %f "%p" %r'

#recovery_target_time=
#recovery_target_xid=
#recovery_target_inclusive=true
#recovery_target_timeline=

The archive is located on a NFS share. We have seen the following happening 
on a PostgreSQL Warm Standby:


Once for a while the Startup Process just stops recovering from archive. No 
more xlogs replayed, no more activity in the logs from the startup process. 
We've seen this two or three times in the past, this time we had the chance 
to do some further investigation what's happening.


strace shows the startup process hanging with

strace -p 31898
Process 31898 attached - interrupt to quit
semop(425990, 0x7fff19919060, 1

Here is a backtrace from the startup process:

(gdb) bt
#0  0x003e214d5337 in semop () from /lib64/libc.so.6
#1  0x005a7ff3 in PGSemaphoreLock (sema=0x2b35a0140ce8, 
interruptOK=1 '\001') at pg_sema.c:420
#2  0x005c68a5 in LockBufferForCleanup (buffer=78428) at 
bufmgr.c:2467
#3  0x00485446 in RestoreBkpBlocks (lsn=, 
record=0xcf2b830, cleanup=1 '\001') at xlog.c:3292
#4  0x00460ce0 in heap2_redo (lsn=..., record=0x7fff19919060) at 
heapam.c:4805

#5  0x00482eff in StartupXLOG () at xlog.c:5665
#6  0x00484cfb in StartupProcessMain () at xlog.c:8102
#7  0x0049b5a8 in AuxiliaryProcessMain (argc=2, argv=optimized out>) at bootstrap.c:419
#8  0x005b0ef9 in StartChildProcess (type=StartupProcess) at 
postmaster.c:4319
#9  0x005b30c7 in PostmasterMain (argc=5, argv=0xcf079e0) at 
postmaster.c:1036
#10 0x0056079e in main (argc=5, argv=) at 
main.c:188


Looking at the code, it seems it is stuck in waiting for UnpinBuffer(), 
ProcWaitForSignal(). Getting the backtrace for the bgwriter process, it 
seems it is working as expected:


(gdb)
#0  0x003e214cd1c3 in __select_nocancel () from /lib64/libc.so.6
#1  0x006b086a in pg_usleep (microsec=) at 
pgsleep.c:43

#2  0x005ac00e in BackgroundWriterMain () at bgwriter.c:538
#3  0x0049b5b7 in AuxiliaryProcessMain (argc=2, argv=optimized out>) at bootstrap.c:424
#4  0x005b0ef9 in StartChildProcess (type=BgWriterProcess) at 
postmaster.c:4319
#5  0x005b4df6 in sigusr1_handler (postgres_signal_arg=optimized out>) at postmaster.c:4095

#6  
#7  0x003e214cd1c3 in __select_nocancel () from /lib64/libc.so.6
#8  0x005b1b5e in ServerLoop () at postmaster.c:1347
#9  0x005b30dc in PostmasterMain (argc=5, argv=0xcf079e0) at 
postmaster.c:1040
#10 0x0056079e in main (argc=5, argv=) at 
main.c:188


The logfile shows the following sequence before this issue:

<@ 2011-03-21 13:56:46 CET 4d7a3ae1.7c9a-1457> LOG:  restored log file 
"000100200070" from archive
<@ 2011-03-21 13:56:46 CET 4d7a3ae2.7c9e-48794> DEBUG:  updated min 
recovery point to 20/704A6EC8
<@ 2011-03-21 13:56:46 CET 4d7a3ae2.7c9e-48795> CONTEXT:  writing block 157 
of relation base/70631854/70632521
<@ 2011-03-21 13:56:46 CET 4d7a3ae2.7c9e-48796> DEBUG:  updated min 
recovery point to 20/7054BD78
<@ 2011-03-21 13:56:46 CET 4d7a3ae2.7c9e-48797> CONTEXT:  writing block 156 
of relation base/70631854/70632521
<@ 2011-03-21 13:57:03 CET 4d7a3ae2.7c9e-48798> LOG:  restartpoint 
complete: wrote 4518 buffers (1.7%); write=225.415 s, sync=0.203 s, 
total=225.621 s
<@ 2011-03-21 13:57:03 CET 4d7a3ae2.7c9e-48799> LOG:  recovery restart 
point at 20/68244EC8
<@ 2011-03-21 13:58:18 CET 4d7a3ae2.7c9e-48800> LOG:  restartpoint 
starting: time
<@ 2011-03-21 14:02:18 CET 4d7a3ae2.7c9e-48801> LOG:  restartpoint 
complete: wrote 3733 buffers (1.4%); write=239.997 s, sync=0.022 s, 
total=240.022 s
<@ 2011-03-21 14:02:18 CET 4d7a3ae2.7c9e-48802> LOG:  recovery restart 
point at 20/6BEB2EB0
<@ 2011-03-21 14:03:18 CET 4d7a3ae2.7c9e-48803> DEBUG:  skipping 
restartpoint, already performed at 20/6BEB2EB0
<@ 2011-03-21 14:03:33 CET 4d7a3ae2.7c9e-48804> DEBUG:  skipping 
restartpoint, already performed at 20/6BEB2EB0
<@ 2011-03-21 14:03:48 CET 4d7a3ae2.7c9e-48805> DEBUG:  skipping 
restartpoint, already performed at 20/6BEB2EB0


After this, the startup process just "hangs", with the symptoms shown 
above. I need to restart the standby now, because the customer wants to 
have it back as soon as possible, but if you need more infos, please let me 
know.


--
Thanks

Bernd

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] Warm Standby startup process unconditionally hangs

2011-04-07 Thread Bernd Helmle



--On 23. März 2011 20:37:11 + Simon Riggs  wrote:


The patches are slightly different because the infrastructure isn't
all there in 8.4.

Please can you test these before I commit to 8.4.


FYI, we have deployed patched RPMs to one of the standby servers, the one where 
most of the hangs occured in the past. We'll see wether we get further hangs 
there.


   Bernd



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #6024: pg_dump won't dump ALTERed inherited fields

2011-05-12 Thread Bernd Helmle



--On 12. Mai 2011 11:24:13 -0400 Tom Lane  wrote:


This is on the
to-fix list --- in fact there was a patch submitted for it last year,
although it got returned for rework and we've not seen it again yet.


Yes, I didn't manage to provide a completed patch for 9.1...will try to 
re-submit for 9.2, it's on my radar again.


--
Thanks

Bernd

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #6066: Bad string in German translation causes segfault (user-triggerable)

2011-06-17 Thread Bernd Helmle



--On 17. Juni 2011 08:18:03 + Christoph Berg  wrote:


In German locale, the follow statement causes vsnprintf() to segfault when
printing the hint:

SELECT TO_DATE('30.12.2011', 'MMDD') AS datum;

Fix tested for 8.4:


Additionally, this seems to be the case for 9.0, 9.1 and current -HEAD, too.

--
Thanks

Bernd

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #6113: SET DATESTYLE='European' does not set datestyle output correctly

2011-07-12 Thread Bernd Helmle



--On 12. Juli 2011 04:32:11 + David Carlos Manuelda  
wrote:




The following bug has been logged online:

Bug reference:  6113
Logged by:  David Carlos Manuelda
Email address:  stormb...@gmail.com
PostgreSQL version: 9.0.4
Operating system:   Gentoo Linux
Description:SET DATESTYLE='European' does not set datestyle output
correctly
Details:

According to Doc (http://www.postgresql.org/docs/7.2/static/sql-set.html),
there are different datestyles available to format date outputs.


This is a very outdated documentation link, you should refer to the 9.0 
documentation instead:


<http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT>


But either is a bug in doc or is a bug in postgre itself, but 'European'
does not currently do what it is intended (it does nothing actually).



[...]


As you can see, SET DATESTYLE='European' just did nothing and did not change
it from last set which was 'German', and of course, it does not even outputs
what was expected and stated in documentation.


'European' or 'Euro' is just another way to write 'DMY' as an input format for 
the date part. At least, for me it works as expected:


SET datestyle TO 'ISO, mdy';

SELECT '27.12.2011'::date;
ERROR:  22008: date/time field value out of range: "27.12.2011" at character 8
HINT:  Perhaps you need a different "datestyle" setting.
LOCATION:  DateTimeParseError, datetime.c:3541
STATEMENT:  SELECT '27.12.2011'::date;
ERROR:  date/time field value out of range: "27.12.2011"
LINE 1: SELECT '27.12.2011'::date;
  ^
HINT:  Perhaps you need a different "datestyle" setting.

SET datestyle TO 'European';

SHOW datestyle;
DateStyle
---
ISO, DMY
(1 row)


SELECT '27.12.2011'::date;
   date

2011-12-27
(1 row)


--
Thanks

Bernd

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] Warm Standby startup process unconditionally hangs

2011-08-01 Thread Bernd Helmle



--On 23. März 2011 20:37:11 + Simon Riggs  wrote:


The patches are slightly different because the infrastructure isn't
all there in 8.4.

Please can you test these before I commit to 8.4.


Hi Simon,

I've searched the committers mailinglist wether this is already committed, but 
either i've missed one or this is still open? If not, sorry for bothering you...


Our customers reports that with the patches applied they didn't had any further
hangs on the standby instances anymore for the last couple of months now.


--
Thanks

Bernd

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes

2012-09-21 Thread Bernd Helmle



--On 20. September 2012 18:18:12 -0400 Tom Lane  wrote:


If it were an actual TRUNCATE, yeah.  But it could be a case of VACUUM
truncating a now-empty table to zero blocks.

But nothing like this would explain the OP's report that corruption is
completely reproducible for him.  So I like your theory about hash index
use better.  We really oughta get some WAL support in there.


We had a similar issue at a customer site. The server was shut down for 
updating it from 9.1.4 to 9.1.5, after starting it again the log was 
immediately cluttered with


ERROR:  could not read block 251 in file "base/6447890/7843708": read only 
0 of 8192 bytes


The index was a primary key on table with mostly INSERTS (only a few 
hundred DELETEs, autovacuum didn't even bother to vacuum it yet and no 
manual VACUUM). According to the customer, no DDL action takes place on 
this specific table. The kernel didn't show any errors.


--
Thanks

Bernd


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes

2012-09-21 Thread Bernd Helmle



--On 21. September 2012 10:25:50 +0200 Andres Freund 
 wrote:



We had a similar issue at a customer site. The server was shut down for
updating it from 9.1.4 to 9.1.5, after starting it again the log was
immediately cluttered with

How was it shutdown? -m fast or -m immediate?



-m fast


ERROR:  could not read block 251 in file "base/6447890/7843708": read
only 0 of 8192 bytes

So, not block 0. How many blocks does the new index contain?


255 blocks according to its current size.

--
Thanks

    Bernd


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #8291: postgres_fdw does not re-read USER MAPING after change.

2013-07-10 Thread Bernd Helmle



--On 9. Juli 2013 22:05:20 + lal...@fhcrc.org wrote:


I have found that if you change the password in the USER MAPPING, that
postgres_fdw will not use it unless the current password fails or you
close and re-open your postgres connection. I found this while testing to
see if the USER MAPPING's supports MD5 passwords and they appeared to
until the next day when I found that they no longer worked because I had
closed and re-opened my connection.



Hmm i don't think that's a bug. It's because the postgres_fdw caches the 
connection within your local session, reusing it for any subsequent foreign 
table access.




The second error that I found is in the documentation of ALTER USER
MAPPING. It incorrectly says how to update a users password.




It could be misread, i agree. Attached is a small doc patch to address this 
against HEAD.


--
Thanks

Bernd

user_mapping_doc.patch
Description: Binary data

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] Postgre connection management

2003-08-22 Thread Bernd vd Brincken
Hello,

Annu Panesar wrote:
hi
i need help urgently to understand how postgres manages its connection 
pool , how it manages deadlock . we are using postgres for our supply 
chain mgmt system and we are facding connectin related problems..
 
plz cud u direct me to some relevant res ources/urls
 
Please call this site:  http://www.google.com
and type "postgres connection pooling" in the text field, next press the 
"Google search" button - and choose one or another of the 2000 URLs that you 
receive.

regards
// Bernd vdB
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match


[BUGS] 'query was cancelled' - depending on search pattern

2003-04-03 Thread Bernd von den Brincken
Hello Bugs,
a query that uses pattern matching like this:
  SELECT .. WHERE  ( (content || authorname) ~* ( '.*gesellschaft.* | 
.*wirtschaft.*' ) )

produces an error 'Query was cancelled' - sometimes, depending on the 
search words.
Seems quite strange to me, I increased some postgresql.conf parameters, 
without effect, and failed in finding anything on 'query was cancelled' in 
the docs or in google.

Any hints are welcome (and an update to the docs about error messages would 
make sense anyway).
// Bernd vdB

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly


Re: [BUGS] 'query was cancelled' - depending on search pattern

2003-04-03 Thread Bernd von den Brincken
Hello Tom,

At 04.04.2003 00:22, you wrote:
Bernd von den Brincken <[EMAIL PROTECTED]> writes:
> a query ... produces an error 'Query was cancelled' -
> sometimes, depending on the search words.
That's really, really hard to believe.  I suspect you've mis-analyzed
the situation.  You sure your client-side code doesn't send cancel
requests on occasion?  Can you create a test case that would let someone
else reproduce this behavior?
I stripped the query down a bit - this one produces the cancel:
SELECT id FROM cftext WHERE ( content  ~* ( '.*wirt.* | .*weil.*' 
) ) ;
Whereas this one provides a correct result set:
SELECT id FROM cftext WHERE ( content  ~* ( '.*wirt.* | .*und.*' ) ) ;

My client is psql via telnet on a Toshiba T550 laptop, my version():
  PostgreSQL 7.3.2 on i386-portbld-freebsd4.7, compiled by GCC 2.95.4
Now I tested it on a different machine (P-3 Server) with (almost) the same
DB contents - it works fine there ! - The version() says:
  PostgreSQL 7.3 on i386-unknown-freebsd4.5, compiled by GCC 2.95.3
So may the problem be in the pattern matching code that may differ
 between freebsd versions?
Regards
// Bernd vdB 

---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org


Re: [BUGS] commands

2003-06-17 Thread Bernd von den Brincken
Hello,

subbiah K wrote:

i want how to start the postsql in redhat linux 8 & how to access the data base postgresql in linux
i have ms access 2000 db its possible to access in linux go throw in postgresql
 

would you please fill in some more letters in your request so we know 
what you really aim for.
For the moment the only advice can be to read the docs.

// Bernd vdB

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [BUGS] Make install error

2003-07-02 Thread Bernd von den Brincken
Hello,

Segree, Gareth wrote:

Whenever I do a make install I get the following error:
/usr/lib/postgresql/ascii_msc.so does not exist.
Obvious, you have to install the ascii library before you can use 
postgres on your Nokia mobile phone.

Regards
// Bernd vdB
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly