Обсуждение: Backend crashed with status 139 ( may be long SQL query)

Поиск
Список
Период
Сортировка

Backend crashed with status 139 ( may be long SQL query)

От
"Natalya S. Makushina"
Дата:
Hello all.

When i had tried to insert into text field text (length about 4000 chars), the backend have crashed with status 139.
Thiserror is happened when the query length ( SQL query) is more than 4095 chars. 
I am using PostgreSQL 6.4.2 on Linux.

My questions are:
1. Is there problem with text field or with length of SQL query?
2. Would postgresql have any limits for SQL query length?

Thanks for help
                    Natalya Makushina
                    mak@rtsoft.msk.ru


Naming columns for SQL output ...

От
Jim Richards
Дата:
Hello all ...

How do I name a column in an SQL query. In Oracle I would use

    select now() 'the time now';

how is this done in PostgreSQL?

Thanks ...


----
CyberCyberCyberCyber Pty Ltd
 http://www.cyber4.org/cyber4/index.html
  New Media For The New Millennium

Re: [GENERAL] Naming columns for SQL output ...

От
"Aaron J. Seigo"
Дата:
hi..

> How do I name a column in an SQL query. In Oracle I would use
>
>     select now() 'the time now';
>
> how is this done in PostgreSQL?
>
if i understand your question:

select now() as 'the time now';

--
Aaron J. Seigo
Sys Admin

Re: [GENERAL] Naming columns for SQL output ...

От
"Ross J. Reedstrom"
Дата:
On Thu, Sep 23, 1999 at 08:12:34PM -0600, Aaron J. Seigo wrote:
> hi..
>
[ Jim Richards <grumpy@cyber4.org> wrote:  ]
> > How do I name a column in an SQL query. In Oracle I would use
> >
> >     select now() 'the time now';
> >
> > how is this done in PostgreSQL?
> >
> if i understand your question:
>
> select now() as 'the time now';

Always test your code ;-)

idas_demo=> select now() as 'the time now';
ERROR:  parser: parse error at or near "'"
idas_demo=> select now() as "the time now";
the time now
----------------------
1999-09-23 23:26:29-05
(1 row)

idas_demo=>

Hmm, seems since the string is a fieldname, it needs doublequotes.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005