Re: [ADMIN] now() and ::date

2002-12-27 Thread Tom Lane
Ray Ontko <[EMAIL PROTECTED]> writes: > 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 analyze

[ADMIN] now() and ::date

2002-12-27 Thread Ray Ontko
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

Re: [ADMIN] dbsize

2002-12-27 Thread Tom Lane
Andreas Schmitz <[EMAIL PROTECTED]> writes: > 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: > ERR

Re: [ADMIN] dbsize

2002-12-27 Thread Campano, Troy
Would you want to talk to this person: [EMAIL PROTECTED] from this page: http://webmail.postgresql.org/~petere/index.html I'd be interested in finding out why you get this error though. thank you. ~ Troy Campano ~ -Original Message- From: Andreas Schmitz [mailto:[EMAIL PROTECTED]] Se

[ADMIN] dbsize

2002-12-27 Thread Andreas Schmitz
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 si

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

2002-12-27 Thread Klaus Sonnenleiter
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 statem