[BUGS] psql: ERROR: MultiByte strings (MB) must be enabled to use this function
Martin Kuria ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description psql: ERROR: MultiByte strings (MB) must be enabled to use this function Long Description When I am trying to connect to my remote database kenyellow pages i.e. psql -h colo.kenyaweb.com -p 5432 kenyellowpages, am getting this error psql: ERROR: MultiByte strings (MB) must be enabled to use this function What could be wrong, Please assist me Thanks Again Sample Code psql -h colo.kenyaweb.com -p 5432 kenyellowpages No file was uploaded with this report
Re: [BUGS] Truble with compilation
I know the cause of this. SCO has a buggy compiler in several (many?) releases, and one of our macros is too large for the compiler. There is a DISABLE_COMPLEX_MACRO define that turns off an inline macro for sco. In 7.0.X, it seems the include file using the macro is also called by ecpg, and because ecpg does not include the C file that defines the non-inline version of the macro, it fails. At least that is my guess. I am testing the current tree now, but one solution is to remove the DISABLE_COMPLEX_MACRO defined from ./include/port/sco.h. Unfortunately, I can't reproduce the problem in the current source tree. > Hi! Help me please. > > I try compile PostgreSQL 7.0.2 on > OS: > SCO UnixWare 2.1.3 > SCO UnixWare SDK > ptf4001i, ptf4003b, ptf4004a, ptf4024b > machine: > DELL PowerEdge 2100 > (Intel Pentium Pro 200MHz, 96Mb RAM, 4Gb and 9Gb Wide-SCSI HDD) > > I have follow truble: > > cc -o ecpg preproc.o pgc.o ../lib/typename.o ... -lgen -lcrypt -lld > -lnsl\ > -lsocket -ldl -lm -lutil -ltermcap -lcurses -lc89 -Wl,-Bexport > > Undefinedfirst referenced > symbolin file > nocachegetattrpgc.o > UX:ld: ERROR: ecpg: fatal error: Symbol referencing errors. No output > written to ecpg. > > What can I do? Help me please. > > Best regards, > Igor N. Avtaev > > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [BUGS] Truble with compilation
Bruce Momjian writes: > Unfortunately, I can't reproduce the problem in the current source tree. I fixed it. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Re: [BUGS] INSERT/SELECT with ORDER BY
> > Unless I'm horribly misreading the spec, this is correct. > ORDER BY is used in reference to cursor definitions and > direct select statements, but is not part of query expressions > which is what the INSERT INTO references. > > ::= > INSERT INTO > > > ::= > [] > > | DEFAULT VALUES > > ::= > > But, this may be a useful extension to allow, at least with the > existance of LIMIT. Yes, added to TODO. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026