Re: [BUGS] Problem identifying constraints which should not be inherited

2008-03-19 Thread NikhilS
Hi, On Fri, Mar 7, 2008 at 6:37 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Added to TODO: > > > o Require all CHECK constraints to be inherited > > > > http://archives.postgresql.org/pgsql-bugs/2007-04/msg00026.php > > PFA, a small patch attached which should fix this. I have

[BUGS] BUG #4046: Error on connection

2008-03-19 Thread kusum
The following bug has been logged online: Bug reference: 4046 Logged by: kusum Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP professional Description:Error on connection Details: When we try to connect to postgresql it gives a

Re: [BUGS] 8.3 can't convert cyrillic text from 'iso-8859-5' to other cyrillic 8-bit encoding

2008-03-19 Thread Heikki Linnakangas
Sergey Burladyan wrote: src/backend/utils/mb/conversion_procs/cyrillic_and_mic/cyrillic_and_mic.c does not have cyrillic letter 'IO' in ISO-8859-5 to mule internal code translation table (function iso2mic(const unsigned char *l, unsigned char *p, int len)). this is bug, because it is widely use

Re: [BUGS] BUG #4044: Incorrect RegExp substring Output

2008-03-19 Thread Rui Martins
> "Rui Martins" <[EMAIL PROTECTED]> writes: >> Description:Incorrect RegExp substring Output > >>SUBSTRING( BedNo FROM '^[[:digit:]]+[a-zA-Z]*(:[[:digit:]]+)?$' ) > > Interesting. It had never occurred to me that it's possible for the > whole pattern to have a match when some pare

Re: [BUGS] BUG #4044: Incorrect RegExp substring Output

2008-03-19 Thread Tom Lane
"Rui Martins" <[EMAIL PROTECTED]> writes: > Here the context of the word "match" may be misleading us, in this > conversation. > I say this, because in my report, the second substring expression, the one > for RoomSize: > SUBSTRING( BedNo, '^[[:digit:]]+([a-zA-Z]*)(:[[:digit:]]+)?$' ) AS RoomSize,

Re: [BUGS] Problem identifying constraints which should not be inherited

2008-03-19 Thread Tom Lane
NikhilS <[EMAIL PROTECTED]> writes: > On Fri, Mar 7, 2008 at 6:37 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote: >> Added to TODO: >> o Require all CHECK constraints to be inherited > PFA, a small patch attached which should fix this. If it's a small patch, it's wrong by definition. AFAICS there i

Re: [BUGS] BUG #4044: Incorrect RegExp substring Output

2008-03-19 Thread Rui Martins
Hi Tom Just a side note, See comments below. > "Rui Martins" <[EMAIL PROTECTED]> writes: >> Description:Incorrect RegExp substring Output > >>SUBSTRING( BedNo FROM '^[[:digit:]]+[a-zA-Z]*(:[[:digit:]]+)?$' ) > > Interesting. It had never occurred to me that it's possible for the

Re: [BUGS] BUG #4044: Incorrect RegExp substring Output

2008-03-19 Thread Rui Martins
Hi Tom What I meant is: SELECT '' ~ '^(something)?$' This will match, i.e. the empty string will match with the expression, and substring would return and empty string. or in other words: it returns true SELECT SUBSTRING( '', '^(something)?$' ) This will also match, has a global expres

Re: [BUGS] BUG #4044: Incorrect RegExp substring Output

2008-03-19 Thread Tom Lane
"Rui Martins" <[EMAIL PROTECTED]> writes: > Even though this can me though as argumentative, think about this expression: > (something)? > Will "match" with an empty string in the context of a full expression, and > will return an EMPTY String. So by analogy, I would expect it, to return > the sa

Re: [BUGS] 8.3 can't convert cyrillic text from 'iso-8859-5' to other cyrillic 8-bit encoding

2008-03-19 Thread Heikki Linnakangas
Heikki Linnakangas wrote: Sergey Burladyan wrote: src/backend/utils/mb/conversion_procs/cyrillic_and_mic/cyrillic_and_mic.c does not have cyrillic letter 'IO' in ISO-8859-5 to mule internal code translation table (function iso2mic(const unsigned char *l, unsigned char *p, int len)). this is bu

Re: [BUGS] 8.3 can't convert cyrillic text from 'iso-8859-5' to other cyrillic 8-bit encoding

2008-03-19 Thread Sergey Burladyan
Thursday 20 March 2008 01:16:34 Heikki Linnakangas: Thanks for answer, Heikki ! > You'd need to modify the mic->ISO-8859-5 translation table as well, for > converting in the other direction. oops, i have not thought about it %) > Here's a patch that does the conversion in the other direction as

Re: [BUGS] Problem identifying constraints which should not be inherited

2008-03-19 Thread NikhilS
Hi, On Wed, Mar 19, 2008 at 8:23 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > NikhilS <[EMAIL PROTECTED]> writes: > > On Fri, Mar 7, 2008 at 6:37 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > >> Added to TODO: > >> o Require all CHECK constraints to be inherited > > > PFA, a small patch attached wh