[BUGS] Select where (upper(xy)~'.CH'); ..matches also SPACE CH

2000-10-26 Thread pgsql-bugs
Marcel ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Select where (upper(xy)~'.CH'); ..matches also SPACE CH Long Description There exists a problem with the ~ statement. The codesample and the text is from an adult contact

Re: [BUGS] pg_log

2000-10-26 Thread The Hermit Hacker
the only way of initializing it (to the best of my knowledge) is to backup your databases (pg_dump) and a re-initdb of the database ... one person recently rm'd the pg_log and found out just how disasterous that is :( btw, would heavily recomment upgrading to 7.0.2 while you are at it, which has

Re: [BUGS] pg_log

2000-10-26 Thread Tom Lane
Sylvain Simard <[EMAIL PROTECTED]> writes: > At begin, with a new database the pg_log are 40k > After many days my pg_log is come 3884k pg_log grows at the rate of 2 bits per transaction. > It's possible to initialize it? If yes how... dump ... initdb ... reload. > It's possible to do anything

Re: [BUGS] Updating multiple bool values crashes backend

2000-10-26 Thread Sean Kelly
On Wed, 25 Oct 2000 14:14:22 -0400, Tom Lane said: > >No core there ... any other suggestions? > > You probably started the postmaster with a ulimit setting that prevents > coredumps (ulimit -c 0 or something like that, see your ulimit man page). > On some Unixen, this ulimit setting is

Re: [BUGS] Updating multiple bool values crashes backend

2000-10-26 Thread Tom Lane
Sean Kelly <[EMAIL PROTECTED]> writes: > Ok, I sorted that ... I now have a 2Mb core file. Can you > explain how to 'backtrace' it with gdb ... gdb /path/to/postgres-executable /path/to/core-file bt quit and send the results. Hopefully there will be at least funct

Re: [BUGS] Select where (upper(xy)~'.CH'); ..matches also SPACE CH

2000-10-26 Thread D. Jay Newman
>Marcel ([EMAIL PROTECTED]) reports a bug with a severity of 3 >The lower the number the more severe it is. > >Short Description >Select where (upper(xy)~'.CH'); ..matches also SPACE CH > >Long Description >There exists a problem with the ~ statement. The codesample and the text is >from an adult

Re: [BUGS] Select where (upper(xy)~'.CH'); ..matches also SPACE CH

2000-10-26 Thread Stephan Szabo
I think that's what it should be doing. ~ is a regexp search, and . is the any character match special character. If you're looking for an actual . you'll need to double backslash escape it. Stephan Szabo [EMAIL PROTECTED] On Thu, 26 Oct 2000 [EMAIL PROTECTED] wrote: > Marcel ([EMAIL PROTEC

[BUGS] \df causes an ERROR: Function oid8types(oidvector) does not exists

2000-10-26 Thread pgsql-bugs
Glauter Fonseca Jannuzzi ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description \df causes an ERROR: Function oid8types(oidvector) does not exists Long Description When I try to use the \df function, this ERROR occurr. I use the os:

[BUGS] \df causes an ERROR: Function oid8types(oidvector) does not exists

2000-10-26 Thread pgsql-bugs
Glauter Fonseca Jannuzzi ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description \df causes an ERROR: Function oid8types(oidvector) does not exists Long Description When I try to use the \df function, this ERROR occurr. I use the os:

[BUGS] Response to Bug Report #37

2000-10-26 Thread pgsql-bugs
Bradley S. Huffman ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Response to Bug Report #37 Long Description It's not Makefile.PL that produces the SUN compiler options "-KPIC -xO3 -depend", but SUN's pre-install version of p

Re: [BUGS] \df causes an ERROR: Function oid8types(oidvector) does not exists

2000-10-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > \df causes an ERROR: Function oid8types(oidvector) does not exists > Thank everybody that can help me. Use the version of psql that matches your version of the server. This looks like a 6.5 or older psql with a 7.0 server... regards, tom lane

[BUGS] \df causes an ERROR: Function oid8types(oidvector) does not exists

2000-10-26 Thread pgsql-bugs
Glauter Fonseca Jannuzzi ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description \df causes an ERROR: Function oid8types(oidvector) does not exists Long Description When I try to use the \df function, this ERROR occurr. I use the os:

Re: [BUGS] Updating multiple bool values crashes backend

2000-10-26 Thread Bruce Momjian
Do we need a TODO here? > Sean Kelly <[EMAIL PROTECTED]> writes: > > (gdb) bt > > #0 0x8115eb2 in ri_BuildQueryKeyFull () > > #1 0x8115dc2 in RI_FKey_keyequal_upd () > > #2 0x8096d7c in DeferredTriggerSaveEvent () > > Hmm. There wasn't any mention of foreign keys for this table in your > bug

Re: [BUGS] Updating multiple bool values crashes backend

2000-10-26 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Do we need a TODO here? None that we haven't got already, AFAIK. regards, tom lane

Re: [BUGS] Updating multiple bool values crashes backend

2000-10-26 Thread Sean Kelly
On Thu, 26 Oct 2000 10:14:16 -0400, Tom Lane said: > gdb /path/to/postgres-executable /path/to/core-file > bt > quit [postgres@nis-master] ~ 132: gdb bin/postgres data/base/users/core This GDB was configured as "i386-slackware-linux"... Core was generated by `/usr/local/po

Re: [BUGS] Updating multiple bool values crashes backend

2000-10-26 Thread Tom Lane
Sean Kelly <[EMAIL PROTECTED]> writes: > (gdb) bt > #0 0x8115eb2 in ri_BuildQueryKeyFull () > #1 0x8115dc2 in RI_FKey_keyequal_upd () > #2 0x8096d7c in DeferredTriggerSaveEvent () Hmm. There wasn't any mention of foreign keys for this table in your bug report, now was there? At a guess, you'

Re: [BUGS] Updating multiple bool values crashes backend

2000-10-26 Thread Sean Kelly
On Thu, 26 Oct 2000 11:27:22 -0400, Tom Lane said: > Sean Kelly <[EMAIL PROTECTED]> writes: > > (gdb) bt > > #0 0x8115eb2 in ri_BuildQueryKeyFull () > > #1 0x8115dc2 in RI_FKey_keyequal_upd () > > #2 0x8096d7c in DeferredTriggerSaveEvent () > > Hmm. There wasn't any mention of foreign

[BUGS] \df causes an ERROR: Function oid8types(oidvector) does not exists

2000-10-26 Thread pgsql-bugs
Glauter Fonseca Jannuzzi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description \df causes an ERROR: Function oid8types(oidvector) does not exists Long Description When I try to use the \df function, this ERROR occurr. I use the os:

[BUGS] PGexec() causes crashes...

2000-10-26 Thread Rob Stoddard
Whenever I run pgexec(), my program always crashes the next time I run it or make any memory allocation.  Something tells me that either that function or pqclear() is deleting an already deleted pointer...   Rob Stoddard [EMAIL PROTECTED]