Search Results

Search found 1505 results on 61 pages for 'postgresql 9 1'.

Page 14/61 | < Previous Page | 10 11 12 13 14 15 16 17 18 19 20 21  | Next Page >

• Schemas and tables versus user-ids in a single table using PostgreSQL

  - by gvkv

  I'm developing a web app and I've come to a fork in the road with respect to database structure and I don't know which direction to take. I have a database with user information that I can structure one of two ways. The first is to create a schema and a set of tables for each user (duplicating the structure for each user) and the second is to…

  Read the article

• Force max length for string in PostgreSQL

  - by Jimmy

  Hey guys, I am using heroku for a RoR application and am trying to manually set the length of a string column and am having trouble. I tried making a migration along the lines of change_column :posts, :content, :string, :length => 10000 I assumed this would work but no such luck, anyone have some pointers? Thanks!

  Read the article

• add schema to path in postgresql

  - by veilig

  I'm the process of moving applications over from all in the public schema to each having their own schema. for each application, I have a small script that will create the schema and then create the tables,functions,etc... to that schema. Is there anyway to automatically add a newly created schema to the search_path? Currently, the only way…

  Read the article

• Encoding error PostgreSQL 8.4

  - by KandadaBoggu

  I am importing data from a CSV file. One of the fields has an accent(Telefónica O2 UK Limited). The application throws en error while inserting the data to the table. PGError: ERROR: invalid byte sequence for encoding "UTF8": 0xf36e6963 HINT: This error can also happen if the byte sequence does not match the encoding expected by the…

  Read the article

• Python + PostgreSQL + strange ascii = UTF8 encoding error

  - by Claudiu

  I have ascii strings which contain the character "\x80" to represent the euro symbol: >>> print "\x80" € When inserting string data containing this character into my database, I get: psycopg2.DataError: invalid byte sequence for encoding "UTF8": 0x80 HINT: This error can also happen if the byte sequence does not match the…

  Read the article

• PostgreSql XML Text search

  - by cro

  I have a text column in a table. We store XML in this column. Now I want to search for tags and values Example data: Citi Bank ..... ..... / I would like to run the following query: select * from xxxx where to_tsvector('english',xml_column) @@ to_tsquery('Citi Bank') This works fine but it also works for tags like name1…

  Read the article

• Using outer query result in a subquery in postgresql

  - by brad

  I have two tables points and contacts and I'm trying to get the average points.score per contact grouped on a monthly basis. Note that points and contacts aren't related, I just want the sum of points created in a month divided by the number of contacts that existed in that month. So, I need to sum points grouped by the created_at…

  Read the article

• PostgreSQL 8.3 data types: xml vs varchar

  - by Sejanus

  There's xml data type in Postgres, I never used it before so I'd like to hear opinions. Downsides and upsides vs using regular varchar (or Text) column to store xml. The text I'm going to store is xml, well-formed, UTF-8. No need to search by it (I've read searching by xml is slow). This XML actually is data prepared for PDF…

  Read the article

• General many-to-many relationship problem ( Postgresql )

  - by David

  Hi, i have two tables: CREATE TABLE "public"."auctions" ( "id" VARCHAR(255) NOT NULL, "auction_value_key" VARCHAR(255) NOT NULL, "ctime" TIMESTAMP WITHOUT TIME ZONE NOT NULL, "mtime" TIMESTAMP WITHOUT TIME ZONE NOT NULL, CONSTRAINT "pk_XXXX2" PRIMARY KEY("id"), ); and CREATE TABLE "public"."auction_values" ( "id"…

  Read the article

• PostgreSQL: SELECT all fields, filter some

  - by Adam Matan

  Hi, In one of our databases, there is a table with dozens of columns, one of which is a geometry column. I want to SELECT rows from the table, with the geometry transformed to another SRID. I want to use something like: `SELECT *` in order to avoid: SELECT col_a, col_b, col_c, col_d, col_e, col_f, col_g,…

  Read the article

• Connection error with heroku db:push with postgresql

  - by Toby Hede

  I have suddenly started seeing this strange error when trying to push my database to heroku. > heroku db:push Auto-detected local database: postgres://infinity:infinity@localhost/infinity_development?encoding=utf8 Failed to connect to database: Sequel::DatabaseConnectionError -> TypeError wrong argument type…

  Read the article

• PostgreSQL - fetch the row which has the Max value for a column

  - by Joshua Berry

  I'm dealing with a Postgres table (called "lives") that contains records with columns for time_stamp, usr_id, transaction_id, and lives_remaining. I need a query that will give me the most recent lives_remaining total for each usr_id There are multiple users (distinct usr_id's) time_stamp is not a unique…

  Read the article

• How do I continue a session from one page to another with PostgreSQL and PHP

  - by MrEnder

  Ok I set up a session... but now how do I make it work on my other pages? I tried doing @session_start(); if(isset($_SESSION['$userName'])) { echo "Your session is running " . $_SESSION['$userName']; }

  Read the article

• PostgreSQL - disabling constraints

  - by azp74

  I have a table with approx 5 million rows which has a fk constraint referencing the primary key of another table (also approx 5 million rows). I need to delete about 75000 rows from both tables. I know that if I try doing this with the fk constraint enabled it's going to take an unacceptable amount of…

  Read the article

• How do I create a postgresql user with fabric

  - by user320080

  I want to create a database user for my setup fabric script but createuser has interactive password entering and seams not to like fabric.

  Read the article

• Future proof Primary Key design in postgresql

  - by John P

  I've always used either auto_generated or Sequences in the past for my primary keys. With the current system I'm working on there is the possibility of having to eventually partition the data which has never been a requirement in the past. Knowing that I may need to partition the data in the future,…

  Read the article

• In postgresql return result of a function in a rule when performing INSERT INTO RETURNING

  - by Dmitry

  I have a View that has several fields. When i INSERT INTO a view I run a function based on INSERT parametrs. The function returns a value. How can I retrieve The value from rule? INSERT RETURNING Gives me: ERROR: cannot perform INSERT RETURNING on relation "full_subntes" ?????????: You need an…

  Read the article

• How to give weight to full matches over partial matches (PostgreSQL)

  - by kagaku

  I've got a query that takes an input searches for the closet match in zipcode/region/city/metrocode in a location table containing a few tens of thousands of entries (should be nearly every city in the US). The query I'm using is: select metrocode, region, postalcode, region_full, city…

  Read the article

• PostGreSQL load increasing over time, why?

  - by TravisO

  It's a CentOS server (I don't know the specs) and just before anybody states the obvious, keep in mind these mitigating factors: the server does a nightly VACUUM job all the tables are indexed it's pretty much read only (meaning the DBs are not increasing in size) the number of queries being…

  Read the article

• PostgreSQL - best way to return an array of key-value pairs

  - by Matt W

  I'm trying to select a number of fields, one of which needs to be an array with each element of the array containing two values. Each array item needs to contain a name (character varying) and an ID (numeric). I know how to return an array of single values (using the ARRAY keyword) but I'm…

  Read the article

• Binding multiple arrays for WHERE IN in PostgreSQL

  - by Alec

  So I want to prepare a query something like: SELECT id FROM users WHERE (branch, cid) IN $1; But I then need to bind a variable length list of arrays like (('a','b'),('c','d')) to it. How do I go about doing this? I've tried using ANY but can't seem to get the syntax right. Cheers, …

  Read the article

• Speeding up PostgreSQL query where data is between two dates

  - by Roger

  I have a large table ( 50m rows) which has some data with an ID and timestamp. I need to query the table to select all rows with a certain ID where the timestamp is between two dates, but it currently takes over 2 minutes on a high end machine. I'd really like to speed it up. I have…

  Read the article

• IN statement performance in PostgreSQL (and in general)

  - by Vasil

  I know this has probably been asked before, but I can't find it with SO's search. Lets say i've TABLE1 and TABLE2, who should I expect the performance of a query such as this: SELECT * FROM TABLE1 WHERE id IN SUBQUERY_ON_TABLE2; as the number of rows in TABLE1 and TABLE2 grow and…

  Read the article

• How does PostgreSQL's JDBC drivers compare to MySQL?

  - by Bytecode Ninja

  Especially regarding completeness and compliance with the JDBC 3 and JDBC 4 specs?

  Read the article

• How large is a "buffer" in PostgreSQL

  - by Konrad Garus

  I am using pg_buffercache module for finding hogs eating up my RAM cache. For example when I run this query: SELECT c.relname, count(*) AS buffers FROM pg_buffercache b INNER JOIN pg_class c ON b.relfilenode = c.relfilenode AND b.reldatabase IN (0, (SELECT oid FROM…

  Read the article

< Previous Page | 10 11 12 13 14 15 16 17 18 19 20 21  | Next Page >