ya'da man tom!
applied the patch, rebuilt, and postgres doesn't crash anymore. fixed
my syntax error, and all is working properly.
phew, my first experience with sql
thanks!
matt
On Thu, Dec 14, 2006 at 09:23:40PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > so maybe i'm using
[EMAIL PROTECTED] writes:
> so maybe i'm using the word crash too liberally. this is the error
> message i get:
> server closed the connection unexpectedly
Looks like a crash to me.
> version is 8.2.0, just downloaded a few days ago.
There's a known bug in 8.2.0 having to do with failing out o
hi tom,
so maybe i'm using the word crash too liberally. this is the error
message i get:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting rese
[EMAIL PROTECTED] writes:
> i would like to allow updates to a view, but pgsql crashes,
> presummably from an infinite loop.
If it crashes, that's a bug, regardless of whether the code is doing
what you want. However, if the thing is indeed into an infinite
recursion, you might be running out of
CTED]
> Subject: [ODBC] Re: [GENERAL] Updating a view
>
>
> I'm not sure about Postgres in particular, but updating a view is not
> always possible. Consider
>
> CREATE VIEW TEST AS
> SELECT sum(money) FROM table;
>
> What would it mean to update an aggregat