Re: [BUGS] Make error in ...utils/mb/conversion_procs/*

2003-01-02 Thread Tom Lane
Chris Albertson <[EMAIL PROTECTED]> writes: > make[3]: Entering directory > `/home/postgres/postgresql-7.3/src/backend/utils/mb/conversion_procs/euc_cn_and_mic' > gcc -Wall -Wmissing-prototypes -Wmissing-declarations -fPIC > -I../../../../../../src/include -I /opt/sfw/include -c -o > euc_cn_a

Re: [BUGS]

2003-01-02 Thread Tom Lane
owner <[EMAIL PROTECTED]> writes: > i've CREATE FUNCTION iv_get(int) RETURNS SETOF same_table AS ' select * > from same_table; ' LANGUAGE SQL; > and then > medyk=# SELECT * FROM iv_get(0); > ERROR: parser: parse error at or near "(" Works for me. I suspect you are trying to use 7.3 features with

Re: [BUGS] Libpq is not a shared library on Mac OS X

2003-01-02 Thread Darcy Buskermolen
It's best to send the context diffs to it to [EMAIL PROTECTED] On Thursday 02 January 2003 11:08, Benjamin Reed wrote: > On Thu, 2003-01-02 at 13:38, Peter Eisentraut wrote: > > Kenji Sugita writes: > > > A libpq library on Mac OS X is made as a loadable library (bundle). > > > Since a shared li

Re: [BUGS]

2003-01-02 Thread Stephan Szabo
On Sat, 28 Dec 2002, owner wrote: > > i've CREATE FUNCTION iv_get(int) RETURNS SETOF same_table AS ' select * > from same_table; ' LANGUAGE SQL; > > and then > > medyk=# SELECT * FROM iv_get(0); > ERROR: parser: parse error at or near "(" > > why ?? is there somethink bad > ?? same_table of cour

Re: [BUGS] Libpq is not a shared library on Mac OS X

2003-01-02 Thread Benjamin Reed
On Thu, 2003-01-02 at 13:38, Peter Eisentraut wrote: > Kenji Sugita writes: > > > A libpq library on Mac OS X is made as a loadable library (bundle). Since a > > shared library version (dylib) of libpq does not exist, all programs which > > use libpq are always linked with a static version of libp

Re: [BUGS] Bug #859: 7.3.1 on linux-alpha: 3 "make check" tests fail

2003-01-02 Thread Thien-Thi Nguyen
From: Tom Lane <[EMAIL PROTECTED]> Date: Fri, 27 Dec 2002 00:40:28 -0500 Could you either dig into it [...] ok, will let you know what i find. thi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister comma

[BUGS] Instllation Error 1316

2003-01-02 Thread Tomas Vera
Hello, I downloaded the odbc driver file psqlodbc-07_02_0005.zip I unzipped the MSI to a temporary directory. Then I double-click the MSI file to begin the installation. It starts fine, I accept thelicense agreement, then click Next, then the installer hangs. The main dialog is displaying: "Ge

Re: [BUGS] Bug #856: coredump

2003-01-02 Thread Mike Pechkin
On Thu, Dec 26, 2002 at 12:01:02PM -0500, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > postgresql=# CREATE USER mpech777; > > CREATE USER > > postgresql=# alter USER mpech777 password ''; > > server closed the connection unexpectedly > > Hm, it works fine here. You'll need to give more de

[BUGS]

2003-01-02 Thread owner
i've CREATE FUNCTION iv_get(int) RETURNS SETOF same_table AS ' select * from same_table; ' LANGUAGE SQL; and then medyk=# SELECT * FROM iv_get(0); ERROR: parser: parse error at or near "(" why ?? is there somethink bad ?? same_table of course exists, but why i've this error ? its a bug ?? or

[BUGS] Make error in ...utils/mb/conversion_procs/*

2003-01-02 Thread Chris Albertson
I get many failures in the makefile in postgresql-7.3/src/backend/utils/mb/conversion_procs/* Each is the same. When I re-type the gcc command by hand with the option switches re-orderd it works and the *.so library gets built Here is what I'm running >uname -a SunOS wi792 5.8 Generic_10

Re: [BUGS] Can't start postmaster on Cygwin with local 'ja_JP.EUC

2003-01-02 Thread Tamotsu Ebina
Dear Peter, I'm very sorry I didn't response for your email quickly. I commented out locales in postmaster.conf and executed createdb -E EUC_JP mydb; After this I can handle Japanese. PostgreSQL7.2 and 7.3 work well both on Linux8.0 and WidowsXPsp1+Cygwin1.3.17 using Japanese Kanji characters.

Re: [BUGS] Libpq is not a shared library on Mac OS X

2003-01-02 Thread Peter Eisentraut
Kenji Sugita writes: > A libpq library on Mac OS X is made as a loadable library (bundle). Since a > shared library version (dylib) of libpq does not exist, all programs which > use libpq are always linked with a static version of libpq. Since only Mac OS X has this stupid dichotomy, no one has b

Re: [BUGS] Bug #862: strange select results

2003-01-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > I have created an view. When I select fields separately all looks ok but when I try >to select 3 fields for concatention (f1 || f2 || f3) the resul is empty when f3 is >empty. I think it is not expected bahaviour. That's the way NULLs are defined to work by the SQL sp

[BUGS] Bug #862: strange select results

2003-01-02 Thread pgsql-bugs
Krzysztof Wo¼nica ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description strange select results Long Description I have created an view. When I select fields separately all looks ok but when I try to select 3 fields for concatention (