Skip to main content

All Questions

Filter by
Sorted by
Tagged with
7 votes
1 answer
20k views

ERROR: function unnest(integer[]) does not exist in postgresql

SELECT UNNEST(ARRAY[1,2,3,4]) While executing the above query I got the error like this: ERROR: function unnest(integer[]) does not exist in postgresql. I am using PostgreSQL 8.3 and I have installed ...
Rafiu's user avatar
  • 5,000
0 votes
1 answer
1k views

Postgresql db import not working well

I am trying to import a sql dump to postgresql db as - sudo su postgres -c psql dbname < mydb_dump.sql This gives errors as - SET SET SET SET SET SET ERROR: function "array_accum" already ...
rtdp's user avatar
  • 2,107