for PostgreSQL questions specific to version 9.2.
I'm trying to run this in PostgreSQL 9.2: RAISE NOTICE 'hello, world!'; And the server says: Error : ERROR: syntax error …
postgresql postgresql-9.2In one of my select statements I've got the following error: ERROR: failed to find conversion function from unknown to …
postgresql postgresql-9.1 postgresql-9.2Is there any way to get rowid of a record in postgres?? In oracle i can use like SELECT MAX(…
postgresql postgresql-9.2We have a table of photos with the following columns: id, merchant_id, url this table contains duplicate values for …
sql database ruby-on-rails-3 duplicates postgresql-9.2I have a table with three columns using the NUMERIC type. However, two of them have nothing (ie. empty). Here …
postgresql-9.2 coalesce tsvectorI tried to use code from Check if sequence exists in Postgres (plpgsql). To create sequence if it does not …
sql postgresql database-design plpgsql postgresql-9.2I am seeking clarification of how to ensure an atomic transaction in a plpgsql function, and where the isolation level …
transactions runtime-error plpgsql postgresql-9.2 read-committedDoes anyone know what is the limit on the size of JSON data type in PostgreSQL 9.2?
json postgresql postgresql-9.2I tried to change precision like this: ALTER Table account_invoice ALTER amount_total SET NUMERIC(5); But I get syntax …
sql postgresql postgresql-9.2 alter-tableI am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running …
service installation database-connection windows-7-x64 postgresql-9.2