Alex Rivera | Logout

Questions tagged postgresql

628 questions · page 5 of 13

Sort by: Newest Votes Active
8
votes
1
answers

Postgresql copy data within the tree table

sql function postgresql tree
asked 2012-04-05T08:29:43.613
89
votes
6
answers

How can I test if a column exists in a table using an SQL statement

postgresql information-schema
asked 2012-04-03T10:01:57.220
80
votes
2
answers

Postgres FK referencing composite PK

postgresql
asked 2012-04-02T21:21:22.537
14
votes
4
answers

Postgres error on Heroku with Resque

ruby-on-rails postgresql resque
asked 2012-04-01T00:59:20.527
9
votes
2
answers

PostgreSQL Trigger and rows updated

postgresql triggers
asked 2012-03-31T10:36:51.070
31
votes
3
answers

execute a trigger when I create a table

postgresql triggers ddl-trigger
asked 2012-03-23T13:06:50.660
11
votes
3
answers

Create array in SELECT

sql postgresql aggregate aggregate-functions postgresql-9.1
asked 2012-03-20T22:39:09.937
359
votes
7
answers

PostgreSQL DISTINCT ON with different ORDER BY

sql postgresql sql-order-by distinct-on
asked 2012-03-20T21:59:36.757
11
votes
1
answers

Cast Const Integer to Bigint in Postgres

sql postgresql casting type-conversion
asked 2012-03-20T19:16:45.327
19
votes
2
answers

How do I reference named parameters in Postgres sql functions?

sql postgresql stored-procedures
asked 2012-03-19T13:58:09.950
10
votes
3
answers

Loading large amount of data into Postgres Hstore

postgresql hstore
asked 2012-03-19T06:14:08.800
93
votes
2
answers

How to configure postgresql postgresql.conf listen_addresses for multiple ip addresses

postgresql
asked 2012-03-19T02:01:35.377
12
votes
2
answers

Java queries against PGPool II cause "unnamed prepared statement does not exist" errors

java postgresql jdbc postgresql-9.1 pgpool
asked 2012-03-15T17:29:21.223
10
votes
2
answers

List all UNLOGGED tables in Postgresql database

postgresql postgresql-9.1
asked 2012-03-14T12:55:34.823
12
votes
4
answers

How to prevent inserts in the parent table?

postgresql database-design inheritance triggers foreign-key-relationship
asked 2012-03-03T11:32:27.803
13
votes
10
answers

ComboBox.ValueMember and DisplayMember

c# postgresql combobox datatable
asked 2012-03-01T18:38:48.193
154
votes
6
answers

Adding 'serial' to existing column in Postgres

postgresql
asked 2012-02-28T21:28:35.540
11
votes
4
answers

Broken brew-installed postgresql on lion

macos postgresql homebrew
asked 2012-02-28T13:28:33.027
8
votes
1
answers

Can I use PostgreSQL (pg) in the client-side (express/node.js)

javascript postgresql node.js express
asked 2012-02-25T14:42:05.907
27
votes
2
answers

Postgresql - how to get entries in a table that do not have a match in another table

postgresql
asked 2012-02-24T10:15:34.250
19
votes
2
answers

PostgreSQL pg_dump

postgresql
asked 2012-02-21T18:13:01.507
16
votes
1
answers

Clojure/JDBC/Postgresql: I am trying to update a timestamp value in postgresql from a string, getting an error

postgresql jdbc clojure timestamp
asked 2012-02-16T04:27:00.277
15
votes
2
answers

what is the equivalent of all_tables and all_tab_columns in postgresql

postgresql
asked 2012-02-15T09:57:16.897
85
votes
18
answers

gem install pg --with-pg-config works, bundle fails

postgresql rubygems bundler pg
asked 2012-02-10T21:20:34.927
8
votes
1
answers

Bitwise operations in Postgres

performance postgresql indexing bit-manipulation
asked 2012-02-10T10:23:21.207
14
votes
7
answers

Postgresql socket error on OSX 10.7.3 when running Django's syncdb

django postgresql psycopg2 syncdb
asked 2012-02-03T18:48:16.403
9
votes
1
answers

using flask-login with postgresql

postgresql flask
asked 2012-02-01T12:36:33.330
21
votes
3
answers

Why are sequences not updated when COPY is performed in PostgreSQL?

sql postgresql sequence
asked 2012-02-01T06:32:08.330
48
votes
1
answers

Using INSERT with a PostgreSQL Database using Python

python postgresql psycopg2
asked 2012-01-31T06:28:17.297
12
votes
3
answers

Can I convert a bunch of boolean columns to a single bitmap in PostgreSQL?

sql postgresql types boolean bit-manipulation
asked 2012-01-29T08:25:54.553
30
votes
2
answers

Postgresql: auto lowercase text while (or before) inserting to a column

postgresql postgresql-9.1
asked 2012-01-28T16:27:12.680
15
votes
8
answers

Slow query on "UNION ALL" view

sql performance postgresql indexing union-all
asked 2012-01-27T09:25:12.200
13
votes
3
answers

postgres: What is the query 'select * from user' actually doing?

sql postgresql
asked 2012-01-25T21:33:37.333
37
votes
1
answers

Postgres user create database

postgresql
asked 2012-01-24T14:27:47.270
11
votes
3
answers

PostgreSQL: How do I export a function definition to SQL

postgresql postgresql-9.1
asked 2012-01-20T16:11:17.673
24
votes
4
answers

Adding a non-nullable column to existing table fails. Is the "value" attribute being ignored?

sql postgresql grails database-design liquibase
asked 2012-01-18T02:12:48.623
17
votes
1
answers

Postgres window function and group by exception

sql postgresql aggregate-functions window-functions
asked 2012-01-13T01:44:50.243
16
votes
4
answers

How to convert a db in postgreSQL to utf8?

database postgresql encoding utf-8
asked 2012-01-10T16:23:00.230
23
votes
3
answers

Rails 3.1. Heroku PGError: operator does not exist: character varying = integer

ruby-on-rails postgresql sqlite heroku
asked 2012-01-09T20:55:21.813
94
votes
13
answers

PostgreSQL Error: Relation already exists

postgresql identifier create-table
asked 2012-01-09T17:55:59.463
10
votes
5
answers

PostgreSQL export large object to client

postgresql postgresql-9.1
asked 2012-01-09T10:36:00.793
22
votes
2
answers

Which postgresql package should I use?

postgresql haskell
asked 2012-01-03T00:31:13.463
64
votes
3
answers

Role does not exist and unable to create database when using PostgreSQL

ruby-on-rails ruby ruby-on-rails-3 postgresql
asked 2011-12-26T22:05:52.940
50
votes
5
answers

Shell script to execute pgsql commands in files

bash postgresql psql
asked 2011-12-21T18:41:26.030
18
votes
2
answers

Why is PostgreSQL calling my STABLE/IMMUTABLE function multiple times?

performance function postgresql immutability
asked 2011-12-16T04:13:55.950
13
votes
2
answers

Export only views in Postgres

postgresql
asked 2011-12-12T11:58:33.893
22
votes
5
answers

ST_DWithin takes parameter as degree , not meters , why?

postgresql gis postgis srid
asked 2011-12-09T11:23:22.417
11
votes
1
answers

Triggers in DB to be executed after a “set” of insert statements

postgresql triggers
asked 2011-12-07T18:05:17.047
11
votes
2
answers

Cannot get log_min_duration_statement to work

postgresql logging configuration postgresql-8.4
asked 2011-12-07T10:55:00.850
10
votes
7
answers

PGError: ERROR: relation "table_name" does not exist

ruby-on-rails ruby ruby-on-rails-3 postgresql heroku
asked 2011-12-05T22:38:14.720
← Prev page 5 of 13 Next →