FAQ

Search Discussions

182 discussions - 896 posts

  • I haven't been able to find anywhere, easily, in the documentation using google where a list of allowed data types for primary keys is. So, UUIDs can be primary keys? Any issues wtih them on sorting ...
    Dennis GearonDennis Gearon
    Jan 4, 2011 at 7:07 pm
    Jan 8, 2011 at 10:48 am
  • Invoice numbers have format yymmddn where n is sequence number in day staring at 1 for every day. command SELECT COALESCE(MAX(nullif(substring( substring(tasudok from 7), '^[0-9]*'),'')::int),0)+1 ...
    Andrus MoorAndrus Moor
    Jan 15, 2011 at 6:22 pm
    Jan 17, 2011 at 6:25 pm
  • Hi, I am trying to create a PL/pgSQL function whose return type is a tuple consisting of an integer and a list of table rows. I emulate the tuple by defining a record 'page_t' with the two fields; ...
    Jon SmarkJon Smark
    Jan 13, 2011 at 4:22 pm
    Jan 16, 2011 at 4:51 pm
  • Hi, I need to put some images on Base64 in a PostgreSQL database. Wich type should I use and what is the difference between using bytea or text to store Base64? Best Regards,
    Andre LopesAndre Lopes
    Jan 25, 2011 at 10:27 pm
    Jan 29, 2011 at 1:59 am
  • Hi, I am looking into using PostgreSQL as a database service in a desktop application since it's one of the support local database systems by DataObjects.net and has more features and higher ...
    Jensen SomersJensen Somers
    Jan 13, 2011 at 10:31 pm
    Jan 18, 2011 at 1:22 am
  • PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit is installed in Windows 2008 server and servers 23 users in LAN 10 hours per work day. Approx once per week server stops responding: Users ...
    AndrusAndrus
    Jan 21, 2011 at 1:17 pm
    Jan 23, 2011 at 2:20 pm
  • Trying to get some DDL auditing in a development environment by adding triggers to pg_proc, pg_class,pg_type,pg_trigger and getting the following error: ERROR: permission denied: "pg_proc" is a ...
    El CoEl Co
    Jan 26, 2011 at 9:30 pm
    Jan 28, 2011 at 2:50 pm
  • Hello, We have 700 user install base using Sybase SQL Anywhere 9.02 We are looking at migrating these installations over to PostGres 1. Very Very Short Answer Please - why should we? 2. Does anyone ...
    Robert ParesiRobert Paresi
    Jan 20, 2011 at 4:55 pm
    Jan 26, 2011 at 12:10 am
  • My PITR work well from 01/01/2011 to 06/01/2011. At 06/01/2011 postgresql log have issue 2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_19"."cdvt13newtmp" in database ...
    TuanhoanganhTuanhoanganh
    Jan 18, 2011 at 5:36 pm
    Jan 22, 2011 at 6:59 am
  • I'm in the process of migrating a project from Oracle to Postgres and have run into a feature question. I know that Postgres has a full-text search feature, but it does not allow scanning the index ...
    Matt WarnerMatt Warner
    Jan 28, 2011 at 5:41 pm
    Jan 31, 2011 at 2:53 am
  • We need to change the database encoding on our databases as they were created with the wrong encoding. They were created as SQL_ASCII and we are changing them to UTF8. When testing this Friday, I ...
    Geoffrey MyersGeoffrey Myers
    Jan 24, 2011 at 3:34 pm
    Jan 28, 2011 at 9:36 pm
  • We've been running for about ten years on a framework which fires triggers similar to database triggers in a Java tier close to the database, and we're now trying to convert these to actual ...
    Kevin GrittnerKevin Grittner
    Jan 19, 2011 at 10:00 pm
    Jan 20, 2011 at 1:25 pm
  • Has anyone else out there noticed inconsistencies in how pgsql formats time intervals over 1 day? For example, I have a query that returns a column of intervals and I get output like this: 30:30:00 1 ...
    Allen ChenAllen Chen
    Jan 13, 2011 at 5:34 pm
    Jan 14, 2011 at 12:23 am
  • Hi, I have a problem that has me stumped. We have a table that is the main table in a production Microsoft Access application. Our users are complaining that sometimes they enter data in the form, ...
    Karen SpringerKaren Springer
    Jan 2, 2011 at 8:59 am
    Jan 3, 2011 at 8:20 pm
  • Hi, I have an iPad and a small network of macs and fedora/windoze machines at home. I am running pg 8.4.4 on all of the 'real' computers. I have been hoping that some developer would create an iPad ...
    Jerry LeVanJerry LeVan
    Jan 17, 2011 at 12:34 am
    Jan 17, 2011 at 8:37 pm
  • IMPORTANTE!!!: Para participantes extranjeros en el Tercer PGDay Latinoamericano, a desarrollarse en la Universidad de las Ciencias Informáticas, La Habana, en febrero del 2011 . Estimados, luego de ...
    Ing. Yunior Mesa ReyesIng. Yunior Mesa Reyes
    Jan 10, 2011 at 2:50 pm
    Jan 17, 2011 at 10:54 am
  • Hello. We have two problems (which may actually be related...) 1. We are running at over 90% capacity of the disk at one of the servers - a report/data warehouse system. We have ran out of disk space ...
    Herouth MaozHerouth Maoz
    Jan 28, 2011 at 9:26 pm
    Jan 31, 2011 at 5:18 pm
  • Hello all, I am trying to restore a database on a server from a dump taken from a different server, but I get the following error: ...
    Ahmed OssamaAhmed Ossama
    Jan 19, 2011 at 12:30 pm
    Jan 19, 2011 at 8:38 pm
  • I have a table like this: create table event( destination_id integer not null references destination (destination_id), starts timestamp, ends timestamp ); I want to make sure that no two rows **with ...
    Matthew WilsonMatthew Wilson
    Jan 15, 2011 at 7:18 pm
    Jan 19, 2011 at 5:50 pm
  • I am working with Ruby on Rails and I have stumbled into a situation which turned out to be, surprisingly for me, somewhat involved. Given a table "shipments" having a column called "mode" I want to ...
    James B. ByrneJames B. Byrne
    Jan 18, 2011 at 6:02 pm
    Jan 19, 2011 at 10:00 am
  • Hi, I am looking for active-active clustering solution. I have one SAN box and two separate NODES, where I need to create active-active cluster. My data directory would be one and mounted to the SAN ...
    Jaiswal Dhaval SudhirkumarJaiswal Dhaval Sudhirkumar
    Jan 15, 2011 at 5:47 am
    Jan 17, 2011 at 4:04 pm
  • Hi, I've created a trigger that checks the uniqueness of two columns in a table. Traditionally, one would use a unique constraint, but in my case, the size of the unique index would be too large and ...
    Randall SmithRandall Smith
    Jan 15, 2011 at 11:10 pm
    Jan 17, 2011 at 10:40 am
  • Hi all, I've somehow messed up something. psql super psql (8.4.5) Type "help" for help. super= \du+ List of roles Role name | Attributes | Member of | Description ...
    Steve LittSteve Litt
    Jan 16, 2011 at 8:12 am
    Jan 16, 2011 at 10:32 pm
  • Hi, I need advise about a database structure. I need to capture data from the web about one specific subject on few specific websites and insert that data to a database. I have done this question ...
    Andre LopesAndre Lopes
    Jan 3, 2011 at 11:12 am
    Jan 3, 2011 at 9:35 pm
  • Running 8.4.6 hosted on Linux, if I do this... SELECT to_char('2011-03-01 12:00' AT TIME ZONE 'GMT0BST', 'HH24:MI TZ'); to_char --------- 12:00 (1 row) ..I don't get a timezone- I can live with that. ...
    Mark Morgan LloydMark Morgan Lloyd
    Jan 26, 2011 at 10:00 am
    Jan 27, 2011 at 10:04 am
  • Hi folks, We've discovered (or possibly rediscovered?) a corruption when restoring large objects. If 'standard_conforming_strings = on' is set in our DB (which is required for our app) then the piped ...
    Bosco RamaBosco Rama
    Jan 20, 2011 at 9:25 pm
    Jan 21, 2011 at 7:28 pm
  • Hi all, I'm trying to upgrade our pgsql from 8.1 to 8.4, but our system's login uses the hashname() function in order to get the proper password validation. Now pgsql's 8.4 hashname function is not ...
    Nicolas GarfinkielNicolas Garfinkiel
    Jan 10, 2011 at 3:26 pm
    Jan 14, 2011 at 11:36 pm
  • I got a big problem: Warning: database 'postgres' must be vacuumed within 1000000 transactions HINT: To avoid database shutdown, execute a full database vacuum in 'postgres' Warning: database ...
    Asti1987Asti1987
    Jan 4, 2011 at 12:06 pm
    Jan 4, 2011 at 6:49 pm
  • Hi list, Happy newyear to all of you. We use WAL files for backup purposes. Now we need to restore up to a certain date in december, we have a base backup from october 24th, but the WAL files start ...
    Dick KniepDick Kniep
    Jan 1, 2011 at 8:48 am
    Jan 3, 2011 at 11:57 pm
  • Maybe someone here can make sense of this. I'm trying to upgrade a 8.3 system to a 9.0 system. Usual procedure dump, restore, vac full, reindex. Both - old and new - run on the same hardware and the ...
    Uwe SchroederUwe Schroeder
    Jan 29, 2011 at 9:11 am
    Jan 30, 2011 at 3:17 am
  • Hi, I found a post with some instructions for resizing without locking up the table, but would like to get some re-assurance that this is the best way: ...
    Jon HoffmanJon Hoffman
    Jan 15, 2011 at 9:23 pm
    Jan 29, 2011 at 1:49 am
  • Hi All, I want to fire a query such that if the particular column does not exist then query should return some default value. For that I have tried following experiment. CREATE TABLE tbl ( c1 ...
    Santosh Bhujbal (sabhujba)Santosh Bhujbal (sabhujba)
    Jan 25, 2011 at 12:51 pm
    Jan 27, 2011 at 2:16 pm
  • Dear all, for the sake academic teaching, a colleague asked me in how far PostgreSQL does support object functionality these days. I am afraid my web research was not very fruitful to him; the ...
    Nick RudnickNick Rudnick
    Jan 21, 2011 at 8:17 am
    Jan 22, 2011 at 3:01 am
  • hi, postgresl-8.4.6 (database encoding is utf8) the following sql behaves strangely on one of my servers: create table ttt(id serial not null primary key, name text); insert into ttt (name) values ...
    RafRaf
    Jan 17, 2011 at 2:49 am
    Jan 19, 2011 at 3:15 am
  • I am running Redhat 5.2 Linux with Postgresql 8.4.4; When my disk space is 90% free the database performance is very good. However, when it reaches close to 20% free the database performance is bad. ...
    Mag GamMag Gam
    Jan 16, 2011 at 4:44 pm
    Jan 18, 2011 at 2:59 pm
  • Hi, I'm moving over from MS SQL. I've been googling this for ages now and suprisingly cannot find a clear answer. I want my data in tables to be case insensitive. This is so i can: 1. Put keys on ...
    Phillip SmithPhillip Smith
    Jan 13, 2011 at 3:11 pm
    Jan 13, 2011 at 4:18 pm
  • Hi guys I am using the postgres driver for OOO and just ran into the following error: Error code: 1 pq_driver: [PGRES_FATAL_ERROR]ERROR: array value must start with "{" or dimension information LINE ...
    Bernhard RohrerBernhard Rohrer
    Jan 7, 2011 at 5:46 pm
    Jan 7, 2011 at 6:23 pm
  • Database connection using "libpq": So, generally speaking, I need: - send multiple queries using "PQsendQuery()" (or what else) - bind some data (void*) to each qeury - obtain results using ...
    Вячеслав БлинниковВячеслав Блинников
    Jan 5, 2011 at 6:41 pm
    Jan 6, 2011 at 6:13 am
  • I has set config.pl to $config- {perl}; 1; and run build.bat, everything is ok, there is plpgsql.dll but don't found plperl.dll. I use strawberry perl 5.10 or must I use ActiveState Perl. Please help ...
    TuanhoanganhTuanhoanganh
    Jan 4, 2011 at 5:12 pm
    Jan 5, 2011 at 8:25 pm
  • I have a JDBC-based application which passes date/time parameters using JDBC query parameters, which is performing very badly (ie. doing full table scans). In an effort to try to narrow down the ...
    Kurt WesterfeldKurt Westerfeld
    Jan 3, 2011 at 11:08 pm
    Jan 4, 2011 at 4:02 pm
  • Hello everybody out there familiar with the tablefunc module, Having read the documentation of the tablefunc module, I'm wondering whether it is possible to get the values for the names of the ...
    Julia JacobsonJulia Jacobson
    Jan 21, 2011 at 1:49 pm
    Feb 7, 2011 at 12:54 pm
  • I'm trying to install the Postgres gem on OS/X but getting errors no matter what I try.. In theory, it should be as simple as "gem install postgres", correct? Here's what I get: Building native ...
    Mike ChristensenMike Christensen
    Jan 29, 2011 at 1:37 am
    Jan 29, 2011 at 2:01 am
  • Using these instructions http://wiki= .flexive.org/confluence/display/FX/Postgres+9.x+installation+in+Ubuntu?focu= sedCommentId=3D4915206#comment-4915206 I am trying to install current pgadmin3 1.12 ...
    MargaretgillonMargaretgillon
    Jan 25, 2011 at 11:28 pm
    Jan 26, 2011 at 6:12 pm
  • Hello, I'm looking for a database backend for a dictionary coder project. It would have three major tasks: - take a text corpus, get their words and substitute each word by a 64 bit integer (the ...
    Attila NagyAttila Nagy
    Jan 23, 2011 at 11:37 am
    Jan 25, 2011 at 10:14 pm
  • Dear Members, We are currently using PostgreSQL 7.3 on an Embedded System (Based on http://www.msc-ge.com/de/produkte/com/qseven/q7-us15w.html) running Windows XP Embedded / SP3. The onbard flash ...
    Christian WalterChristian Walter
    Jan 13, 2011 at 1:46 pm
    Jan 17, 2011 at 2:26 am
  • Hello, my name is raghu. I work for Avaya. We uses postgres as database in our application. Our application is a jboss based enterprise application, that does some updates operations based on ...
    Karayappalli, Raghunath (Raghu)Karayappalli, Raghunath (Raghu)
    Jan 11, 2011 at 3:13 am
    Jan 14, 2011 at 5:51 am
  • We are about to build a new database server, our plan is to use Debian. Is there documentation of recommended server configurations for Linux, such as kernel parameters, preferred file system, etc ...
    Sim ZacksSim Zacks
    Jan 6, 2011 at 11:21 am
    Jan 6, 2011 at 9:53 pm
  • Hello, the following function takes forever to execute as is. I see 'Inserting original actions in temporary table' and nothing after that. If i replace orig_user_id in the FOR loop with 1811 (the ...
    Nicos PanayidesNicos Panayides
    Jan 31, 2011 at 6:30 pm
    Feb 1, 2011 at 6:49 pm
  • ~ I need to configure postgreSQL in a way that I could run it from a directory mounted as read only, with separate rw partitions mounted for the data, logs, . . . ~ What would be the steps to follow ...
    Albretch MuellerAlbretch Mueller
    Jan 24, 2011 at 10:09 pm
    Jan 29, 2011 at 12:37 am
  • Hi, What could be the possible damage if a database is migraged without the -o (OID) option? Integrity of data? What are the options to solve this problem if it is migrated this way? Shouldn't ...
    Girts LaudaksGirts Laudaks
    Jan 27, 2011 at 12:52 pm
    Jan 28, 2011 at 9:36 pm
Group Navigation
period‹ prev | Jan 2011 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions182
posts896
users239
websitepostgresql.org
irc#postgresql

239 users for January 2011

Tom Lane: 45 posts Adrian Klaver: 40 posts Alban Hertroys: 25 posts Jasen Betts: 20 posts Bill Moran: 19 posts Craig Ringer: 19 posts Scott Ribe: 19 posts Andy Colson: 18 posts Tuanhoanganh: 15 posts Pavel Stehule: 14 posts Andrew Sullivan: 13 posts Andrus Moor: 11 posts Dmitriy Igrishin: 11 posts Вячеслав Блинников: 11 posts Vivek Khera: 10 posts Chris Browne: 9 posts Jeff Davis: 9 posts John R Pierce: 9 posts Raymond O'Donnell: 9 posts Rsmogura: 9 posts
show more
Archives