Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000

Sreedhar, From looking at the documentation at postgresql.org, it seems like this syntax is not supported. The compatibility description in the create trigger docs indicates that BEFORE UPDATE OF col_name is not supported either which probably means that Postgres has no knowledge of the

[ADMIN] dbsize

Hello *, I don't know if dbsize a part of the admin business here. I couln't find any contact infos in the README or the source. I have a 7.3 on solaris 8. When I try to execute SELECT database_size('newsdb'); I get the following error message: ERROR: MemoryContextAlloc: invalid request

[ADMIN] now() and ::date

Howdy, I'm having a little trouble understanding the query optimizer related to a timestamp with time zone column. I have a table called event with a not null column called event_date_time of type timestamp with time zone that has been recently analyzed. There are about 500,000 rows in the