[SQL] Aggregate function error in 7.4

Hi all. I'm trying to migrate from 7.3.4 to 7.4.1. I've performed a pg_dumpall using the pg_dumpall from 7.4.1. Once 7.4 is running and I try to import the dump, I get the following error: psql:pgsql.dump:301: ERROR: column "r.day" must appear in the GROUP BY clause or be used in an aggregate

Re: [SQL] Query TIME ZONE

"Raman" <[EMAIL PROTECTED]> writes: > [ okay: ] > "select current_time AT TIME ZONE INTERVAL '+5:30'" > [ not okay: ] > "select current_time AT TIME ZONE INTERVAL time_difference from customer_events" "TIME ZONE INTERVAL" is not a SQL construct. You have misunderstood the interaction of two diffe

[SQL] Query TIME ZONE

Hi All, I have a query regarding Time Zone Interval   QUERY: "select current_time AT TIME ZONE INTERVAL '+5:30'" it is running fine   BUT When I take the value of interval from DB table like:   "select current_time AT TIME ZONE INTERVAL time_difference from customer_events"   here : time_d

Re: [SQL] postgreSQl 7.4.1 and Hibernate

Beya, > just wanted to know whether anyone on this group uses Hibernate in > conjunction with postgreSQL 7.4.1? Not me personally but there are some companies who do. Also Alzabo. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)

Re: [SQL] [BUGS] PgSQL Down

"Cavit Keskin" <[EMAIL PROTECTED]> writes: > Postgresql often stops after a time (unknown, changing). You haven't given any information that would allow anyone to help :-( > Below is the log file just after Postgresql database server is started > manually. Log can't record the cause of this probl

Re: [SQL] PgSQL Down

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 27 Jan 2004, Cavit Keskin wrote: > Using Postgresql's source files I compiled postgresql 7.4.1 on a > dedicated machine with a customized Redhat 7.2 system. > Postgresql often stops after a time (unknown, changing). > Below is the log fi

[SQL] postgreSQl 7.4.1 and Hibernate

hi, just wanted to know whether anyone on this group uses Hibernate in conjunction with postgreSQL 7.4.1? ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] PgSQL Down

Using Postgresql's source files I compiled postgresql 7.4.1 on a dedicated machine with a customized Redhat 7.2 system. Postgresql often stops after a time (unknown, changing). Below is the log file just after Postgresql database server is started manually. Log can't record the cause of this probl

Re: [SQL] time series data

Dnia 2004-01-27 02:42, Użytkownik [EMAIL PROTECTED] napisał: Hi, thanks for the info..btw can u pls explain a little bit detail since i can't get thru yr solution. thanks in advance insert into time_table (time_key,year_id,month_id,month_desc,day_id) select newid, extract('year' from you

Re: [SQL] time series data

Hi,    thanks for the info..btw can u pls explain a little bit detail since i can't get thru yr solution. thanks in advance Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał: > Use this integer sequence and interval datatype to get date result: > your_date='1994-01-01'::date+'1 day'::i