for PostgreSQL questions specific to version 9.2.
I'm trying to get EF 5.0 code first working with PostgreSQL (Npgsql provider). I have Npgsql 2.0.12.1 installed via NuGet (referenced assembly …
c# .net database entity-framework-5 postgresql-9.2I have been trying really hard to capture the exact SQL of a really complicated JPA query in my project …
hibernate jpa-2.0 jboss7.x postgresql-9.2 p6spyI'm trying to work with current_setting(). I came up with this: CREATE OR REPLACE FUNCTION process_audit() RETURNS TRIGGER …
postgresql postgresql-9.2I have PostgreSQL 9.2.0. On clicking create database it shows following error: SQL error: ERROR: column "spclocation" does not exist LINE 1: ...…
database postgresql-9.2 phppgadminSo I have a table with a large dataset and this table has a three columns that I would like …
postgresql database-design ddl database-performance postgresql-9.2I am trying to install the debugger for postgresql on Linux so I can use pgAdmin to debug my functions. …
postgresql postgresql-9.2 pgadminI followed the installation notes C:\Program Files\PostgreSQL\9.2\doc\installation-notes.html Edited the postgresql.conf file shared_preload_libraries = …
debugging plugins failed-installation postgresql-9.2 enterprisedbI want to create a function to get the right week number of year. I already posted here to find …
postgresql postgresql-9.2 week-numberI switched my postgres version from 9.2.24 to 9.6 because I need jsonb compatibility along with other recent features. I am running …
postgresql centos7 postgresql-9.2 postgres-9.6I'm trying to compose a WHERE statement that will match rows where a column value is a substring of another …
sql postgresql postgresql-9.2