I have been trying to find a way to generate unique Id\'s in mongodb. I know that mongodb has _id which is unique based on time which server its beeing added to among other things. The issue I am havi
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
I am very new to postgres. I got this error when try to run the following script: CREATE OR REPLACE FUNCTION xyz(text) RET开发者_开发问答URNS INTEGER AS
Given the following filled x, y coordinates: 0, 0 0, 1 0, 2 1, 0 1, 1 1, 2 2, 0 2, 1 2, 2 4, 0 4, 1 5, 0 5, 1 How do I write an SQL query to determine all the filled rectangles? A rectangle is def
The PostgreSQL manual page on the Serializable Isolation Level states: [Like] the Repeatable Read level, applications using this level must be prepared to retry transactions due to serialization fai
I am reading dat开发者_JAVA技巧a from a .mat file using the Pytables module. After reading the data, I want to insert this data into the database using psycopg.
I have an asp/IIS application deployed on our server that runs fine every time we reboot it or restart due to new application modifications. However, after 10-20 minutes it starts to chug and timeout
I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user \"postgres\" for both console client and Pgadmin. I have typed user as \"postgres\" and password \"postgr
I have 2 databases and want to implement triggers on table update of database1 to do do some updates on database2\'s tables.开发者_如何学Go
Problem: one column of a table contains serialized php arrays. i\'d like to extract values of that serialized data structure with开发者_JAVA技巧out using php. i\'d need a postgres sql statement to ge