postgresql
Null value isn't unique
I have rows like these on postgre开发者_高级运维s: name | address | college john | rome| john | rome|[详细]
2023-04-12 22:45 分类：问答Many to Many SQL Query for selecting all Images Tagged with certain words
I have 2 Tables in Postgres: CREATE TABLE \"images\" ( \"id\" serial NOT NULL PRIMARY KEY, \"title\" varchar(300) NOT NULL,[详细]
2023-04-12 22:31 分类：问答Postgres pull multiple future keys from sequence
In Oracle I can do something like this to fetch a bunch of keys. select seq.nextval from dual connect by level <= 1000;[详细]
2023-04-12 21:46 分类：问答Postgres causing swapping on CentOS
All, I am running CentOS 6.0 with Postgresql 8.4 and can\'t seem to figure out how to prevent so much disc swap from occurring. I have 12 gigs of RAM and 4 processors and I am doing some simple updat[详细]
2023-04-12 20:48 分类：问答Is there a way to store Arabic dates with Postgres?
I am a PHP developer and I am working on a project in which I need to store Arabic dates in my database.[详细]
2023-04-12 20:25 分类：问答PostgreSQL custom exception conditions
Is it possible to create custom conditions when I raise an exception? Consider the following example:[详细]
2023-04-12 20:08 分类：问答Postgresql connection pooling in Erlang
I am looking for a robust connection pooling library for Postgre开发者_StackOverflow社区sql. Something similar to https://github.com/dweldon/riakpool would be great.Poolboy is a pretty good general-p[详细]
2023-04-12 20:08 分类：问答Postgresql - change the size of a varchar column to lower length
I have a question about the ALT开发者_运维问答ER TABLE command on a really large table (almost 30 millions rows).[详细]
2023-04-12 19:37 分类：问答Creating Rails 3.1 app with Postgresql database (OSX Lion)
I cant seem to find an up-to-date guide to creating a new Rails 3.1开发者_StackOverflow社区 app with a Postgresql database. I would greatly appreciate a guide through that process.Since Rails 3, the f[详细]
2023-04-12 18:07 分类：问答Migration from MYSQL to PostgreSQL
I just want to migrate my application from MYSQL to PostgreSQL. I am stuck at one point, CREATE TABLE some_table[详细]
2023-04-12 17:45 分类：问答
加载中,请稍侯......