Thread: Query Limitations

Query Limitations

From

Keith Gray

Date:

07 March 2001, 02:40:36

PostgreSQL 6.4 seems to have limitations in Query Length when I 

"CREATE VIEW" ... is this limit defined

further, when I create a query on a query... it seems to compound
the queries and reach the limit sooner!!

Is this limit programmable?

Is it default higher in 7.0?

What is the most stable 7.X release?






Keith

Re: Query Limitations

From

Bruce Momjian

Date:

07 March 2001, 03:03:16

> PostgreSQL 6.4 seems to have limitations in Query Length when I 
> 
> "CREATE VIEW" ... is this limit defined
> 
> further, when I create a query on a query... it seems to compound
> the queries and reach the limit sooner!!
> 
> Is this limit programmable?
> 
> Is it default higher in 7.0?

Yes.

> 
> What is the most stable 7.X release?

7.0.3

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

how to get info of function

From

Jie Liang

Date:

07 March 2001, 15:10:20

Hi,

What system table hold info of user defined function??
Acturally , I want to know how to retrive the defination of a function
from its name.


Thankes.



Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com