Postgres Pro
Downloads
Home   >   mailing lists

Message at the console - Mailing list pgsql-general

From Kallol Nandi
Subject Message at the console
Date
Msg-id NBEDKIHMDKLGDCDIJLMMOEIJCAAA.kallol.nandi@indussoft.com
Whole thread Raw
List pgsql-general
Tree view
I have created a table using the following command
CREATE TABLE metricsreporttable(id VARCHAR(150) NOT NULL,sitename VARCHAR(155),title VARCHAR(160),type VARCHAR(165),count INTEGER,categoryid VARCHAR(170));
 
When I start inserting rows into this table I get the following error message in the console.
 
"Attribute metricsreporttable.oid must be GROUPed or used in an aggregate function"
 
What might be the problem?
 
Thanks and Regards,
Kallol.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-advocacy] interesting PHP/MySQL thread
Next
From: Tom Lane
Date:
Subject: Re: Many Pl/PgSQL parameters -> AllocSetAlloc(128)?