Re: [BUGS] was enhancement of temp tables in plpgsql supposed to apply to temp views as well? appears it did not.

2007-11-28 Thread Tom Lane
"chris wood" <[EMAIL PROTECTED]> writes: > Plpgsql procedure: Would you provide a self-contained test case, rather than a handwavy description? It certainly should work, so I suppose there is some critical point that you left out. Also, you *are* testing 8.3something, right? What exactly?

[BUGS] was enhancement of temp tables in plpgsql supposed to apply to temp views as well? appears it did not.

2007-11-28 Thread chris wood
Plpgsql procedure: BEGIN Drop table if exits temptable cascade ; Create temp table temptable ... Create temp view tempview as select . from temptable... Select .. from tempview ... END The first time I run this after I create the procedure it works perfectly. The second time

[BUGS] BUG #3787: configure: error: readline library not found

2007-11-28 Thread paulo
The following bug has been logged online: Bug reference: 3787 Logged by: paulo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.14 Operating system: MANDRIVA Description:configure: error: readline library not found Details: Help -me no install configure: er

Re: [BUGS] BUG #3784: pg_ctl fails to start server when called with -c parameters

2007-11-28 Thread Tom Lane
"Stephen Bespalko" <[EMAIL PROTECTED]> writes: > The following start statement fails, after about 60 seconds: > bash-3.2$ > "/Users/sjbespa/Desktop/MDP.v8/MacDentPro/MacDentPro/build/Development/MacDe > ntPro 10.5.app/Contents/Resources/postgresql/bin/pg_ctl" -w -D > "/Users/sjbespa/pgsql.abqdenta

Re: [BUGS] win32 executables

2007-11-28 Thread Dave Page
[EMAIL PROTECTED] wrote: > Hello, > > I tried your 8.3beta3 and 8.2.5 zip-packaged (no installer) versions. > The 8.2.5 does not react at all to the starting of any of the > executables (on the command line, the prompt immediately returns, > incidentially the return code is 53, but there are no v

Re: [BUGS] BUG #3782: table_to_xmlschema and xsd:simpleType

2007-11-28 Thread Dragos Ionita
Thanks for the patch Peter. - I applied the patch but wasn't able to compile postgre on windows, but i'll try again a bit later on linux - For checking we can use http://www.w3.org/2001/03/webdata/xsv - One more thing I'd like to point out is what happens in situations like the following: if th

[BUGS] win32 executables

2007-11-28 Thread postgres-001
Hello, I tried your 8.3beta3 and 8.2.5 zip-packaged (no installer) versions. The 8.2.5 does not react at all to the starting of any of the executables (on the command line, the prompt immediately returns, incidentially the return code is 53, but there are no visible signs of unhappiness; strace o

Re: [BUGS] BUG #3784: pg_ctl fails to start server when called with -c parameters

2007-11-28 Thread Bruce Momjian
Please check the database server logs to see if it has any reason for the failure. --- Stephen Bespalko wrote: > > The following bug has been logged online: > > Bug reference: 3784 > Logged by: Stephen Bespal

Re: [BUGS] BUG #3782: table_to_xmlschema and xsd:simpleType

2007-11-28 Thread Peter Eisentraut
Am Dienstag, 27. November 2007 schrieb Dragos Ionita: > I'm having a problem with table_to_xmlschema, for VARCHAR fields the > function returns: > > > > > And parsers don't seem to like this: > > Invalid XML schema: 'Further elements required under element > .' > > The simpleType should have a ch

[BUGS] BUG #3786: report error:"ERROR: invalid byte sequence for encoding "UTF8""

2007-11-28 Thread wengxc
The following bug has been logged online: Bug reference: 3786 Logged by: wengxc Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: RHEL AS4 Description:report error:"ERROR: invalid byte sequence for encoding "UTF8"" Details: my postgresql

[BUGS] BUG #3784: pg_ctl fails to start server when called with -c parameters

2007-11-28 Thread Stephen Bespalko
The following bug has been logged online: Bug reference: 3784 Logged by: Stephen Bespalko Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Mac OS X 10.5 Description:pg_ctl fails to start server when called with -c parameters Details: The