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
hi,
i would like to allow updates to a view, but pgsql crashes,
presummably from an infinite loop.
i add a rule like so:
CREATE RULE update_myview AS ON UPDATE TO myview DO INSTEAD SELECT
updater(OLD, NEW);
where updater is a plperl function. the function updater does a few
comparisons 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
Hi,
Ok i know this is something stupid, somebody mind explaining it to me? Also
sorry if this gets posted twice, i got a error back the first time..
I have a Visual Basic Project that access a PostgreSQL Datbase. One Form
pulls information from a View in postgres. If teh user changes anything on
