Re: [BUGS] Schemas not available for pl/pgsql %TYPE....

2002-09-04 Thread Bruce Momjian
Tom Lane wrote: > Sean Chittenden <[EMAIL PROTECTED]> writes: > > ::sigh:: Is it me or does it look like all > > of pl/pgsql is schema un-aware (ie, all of the declarations). -sc > > Yeah. The group of routines parse_word, parse_dblword, etc that are > called by the lexer certainly all need wor

Re: [BUGS] Schemas not available for pl/pgsql %TYPE....

2002-09-04 Thread Tom Lane
Sean Chittenden <[EMAIL PROTECTED]> writes: > ::sigh:: Is it me or does it look like all > of pl/pgsql is schema un-aware (ie, all of the declarations). -sc Yeah. The group of routines parse_word, parse_dblword, etc that are called by the lexer certainly all need work. There are some definitio

Re: [BUGS] Schemas not available for pl/pgsql %TYPE....

2002-09-04 Thread Sean Chittenden
> Sean Chittenden <[EMAIL PROTECTED]> writes: > > Call me crazy, but shouldn't the following work? :~| > > Sure should. Want to fix plpgsql's parser? Why not: I've never been one to avoid strapping on 4tons in rocks and jumping into the deep end. ::sigh:: Is it me or does it look like all of

Re: [BUGS] Schemas not available for pl/pgsql %TYPE....

2002-09-04 Thread Tom Lane
Sean Chittenden <[EMAIL PROTECTED]> writes: > Call me crazy, but shouldn't the following work? :~| Sure should. Want to fix plpgsql's parser? regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Us

[BUGS] Schemas not available for pl/pgsql %TYPE....

2002-09-04 Thread Sean Chittenden
Call me crazy, but shouldn't the following work? :~| CREATE FUNCTION t() RETURNS TEXT AS ' DECLARE col_name pg_catalog.pg_attribute.attname%TYPE; BEGIN col_name := ''uga''; RETURN col_name; END; ' LANGUAGE 'plpgsql'; CREATE FUNCTION SELECT t(); WARNING: plpgsql: ERROR

Re: [BUGS] Bug #757: ODBC Doesn works

2002-09-04 Thread Stephan Szabo
On Wed, 4 Sep 2002 [EMAIL PROTECTED] wrote: > Long Description > I have Postgresql 7.2.2 in a red hat 7.3 machine. I'm programming in a > PowerBuilder 8.0 in a windows 2000 machine, I have a > PSQLODBC-07-02-0002. When I try to access to the Postgres with ODBC, > PowerBuilder crash with an exept

[BUGS] Bug #757: ODBC Doesn works

2002-09-04 Thread pgsql-bugs
Lazaro ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description ODBC Doesn works Long Description I have Postgresql 7.2.2 in a red hat 7.3 machine. I'm programming in a PowerBuilder 8.0 in a windows 2000 machine, I have a PSQLODBC-07-0

Re: [BUGS] Bug #756: suggestion: file with password instead of $PGPASSWORD

2002-09-04 Thread Bruce Momjian
This functionality will be in 7.3, due out in a few months. --- [EMAIL PROTECTED] wrote: > Wojciech Scigala ([EMAIL PROTECTED]) reports a bug with a severity of 4 > The lower the number the more severe it is. > > Short Des

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-04 Thread Rod Taylor
This item: Add file to hold passwords using PGPASSWORDFILE environment variable Has been completed, and will be a part of the 7.3 release. Thanks, Rod On Wed, 2002-09-04 at 11:54, [EMAIL PROTECTED] wrote: > Wojciech Scigala ([EMAIL PROTECTED]) reports a bug with a severity of 4 > The lo

[BUGS] Bug #756: suggestion: file with password instead of $PGPASSWORD

2002-09-04 Thread pgsql-bugs
Wojciech Scigala ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description suggestion: file with password instead of $PGPASSWORD Long Description This is not a bug-report in fact, but a suggestion of a feature. (I couldn't find an separa