Search Discussions

42 discussions - 116 posts

  • Hi I am trying to migrate informix Esql/C application to PostgeSQL using ecpg. I have a structure in the code, where one of the element data type is non-primitive. When i try to complile the code it ...
    Feb 1, 2011 at 7:20 am
    Feb 9, 2011 at 10:57 am
  • I may be over-thinking this but I have some questions about table design. The purpose of the database will be to catalog a comic book collection. I have been reading the online manual along with a ...
    Matty jonesMatty jones
    Feb 8, 2011 at 8:04 pm
    Jun 13, 2011 at 2:49 am
  • Hi. If I have two queries: SELECT pub_id as id, email FROM publication WHERE email_accepted = TRUE; and SELECT contact_id as id, email FROM person WHERE email_accepted = TRUE; is there any way I ...
    Mark KellyMark Kelly
    Feb 19, 2011 at 1:32 pm
    Feb 21, 2011 at 12:51 am
  • Hello, I need a way to quickly import many large tables from various ODBC data sources into PostgreSQL for reporting. Ideally I am looking for a simple way to create all the tables to import to, but ...
    Craig BarnesCraig Barnes
    Feb 22, 2011 at 8:23 pm
    Mar 8, 2011 at 8:58 pm
  • *-------------begin message--------------* * * *1. Warning: Console code page (850) differs from Windows code page (1252) 8-bit characters may not work correctly. See psql reference * *page "Notes ...
    Chris chrisChris chris
    Feb 18, 2011 at 4:52 pm
    Mar 2, 2011 at 7:52 pm
  • Is PostgreSQL 9.0.x certified to run on RHEL 5.6? My platform is x86_64. I am installing from source, not the one-click installer at this time. I appologize if this is a silly question in the world ...
    Mark JohnsonMark Johnson
    Feb 23, 2011 at 8:52 pm
    Feb 24, 2011 at 10:35 am
  • Hello I have the following table CREATE TABLE aaa.domains ( pk_domain_id INTEGER NOT NULL, domain_name CHARACTER VARYING(254) NOT NULL, is_unlocked BOOLEAN DEFAULT TRUE NOT NULL, -- LOCKED = 0, ...
    Feb 22, 2011 at 5:34 pm
    Feb 22, 2011 at 6:11 pm
  • Hello, new to Postgresql and have a problem. I have been using Oracle and MySQL up to now and I was thinking to give PostgreSQL a try. I have opened a SQL console from the pgAdmin tool and tried to ...
    Feb 22, 2011 at 5:24 pm
    Feb 22, 2011 at 6:07 pm
  • Hi I'm using the syslog as my log destination. Here are the configuration settings I have: log_destination='syslog' logging_collector='off' syslog_facility='LOCAL1' syslog_ident='postgres2' The ...
    Feb 9, 2011 at 4:07 pm
    Feb 9, 2011 at 6:10 pm
  • What would be an efficient way to backup several PostgreSQL databases? The number of DB's is not a constant because it depends on the number of clients our company has. Because our company is new, we ...
    Feb 5, 2011 at 8:43 pm
    Feb 9, 2011 at 12:13 pm
  • I while ago, I reported that grant statements were always returning an error stating that the database could no be found. Today I noticed that it seemed to be caused only when the database was ...
    Mike ThomsenMike Thomsen
    Feb 3, 2011 at 6:04 pm
    Feb 3, 2011 at 10:29 pm
  • I have more info in this post, and unfortunately my last post was posted (or not posted) without remembering to subscribe to this list first XD. So if you responded to my last one I didn't see it, so ...
    Feb 28, 2011 at 9:30 pm
    Feb 28, 2011 at 10:49 pm
  • Hi, I'm trying to create a simple trigger and use a bit of refactoring to modularize a common section of functionality into another function. In process, I have created two functions, caller (invoked ...
    Manlin VeeManlin Vee
    Feb 25, 2011 at 3:38 am
    Feb 25, 2011 at 3:58 pm
  • hi, when COMMIT failed, does it leave the transaction opened (thus ROLLBACK is necessary) ? YAMAMOTO Takashi
    YAMAMOTO TakashiYAMAMOTO Takashi
    Feb 10, 2011 at 8:52 am
    Feb 18, 2011 at 1:53 am
  • Hi I am new to postgresql I want to create a user account So I tried to use “create user” command. but then it is not asking for password..User is created. But when I want to enter the db with that ...
    Siva kiran balijepalliSiva kiran balijepalli
    Feb 17, 2011 at 12:10 pm
    Feb 17, 2011 at 12:25 pm
  • hi, the following behaviour of multiple generate_series in a select seems a little counter-intuitive to me. i expected that the former returns 4 rows. where should i look to learn the exact ...
    YAMAMOTO TakashiYAMAMOTO Takashi
    Feb 15, 2011 at 2:06 am
    Feb 15, 2011 at 3:47 pm
  • I am designing a table that will hold a list of unique names and be referenced by several other tables. There will only be one column in the table (name), should I still create a separate primary key ...
    Matty jonesMatty jones
    Feb 1, 2011 at 12:54 am
    Feb 1, 2011 at 7:26 pm
  • Hi, My database schema is susceptible to change between various release of the product. There may be new fields added or old fields removed from a table. Introduction of new fields seems to simple, ...
    Abhinav mehrotraAbhinav mehrotra
    Feb 1, 2011 at 3:56 pm
    Feb 1, 2011 at 7:04 pm
  • Hello list. I have the following problem: Example table Origin *id | length | source | target* 1 25 33 45 2 100 45 60 3 12 22 11 4 78 60 55 5 20 24 60 Example Results: new table *id | length | source ...
    Killspam killspamKillspam killspam
    Feb 1, 2011 at 10:22 am
    Feb 1, 2011 at 3:35 pm
  • I am starting to develop an application and I am considering to use stored procedures. Is there a performance penalty for implementing many DB operations with stored procedures? For example, if my ...
    Feb 28, 2011 at 8:00 pm
    Mar 3, 2011 at 9:28 pm
  • Hi all! I am working on a company that needs DB on its embedded system. We are looking for such DB manager, and we find postgresql as a potential suitable project for us. Does pgsql fits to embedded ...
    Liran RitkopLiran Ritkop
    Feb 28, 2011 at 8:12 am
    Mar 3, 2011 at 5:26 am
  • So I can login while I am on the system as postgres, but when I try to login remotely (directly to the database) I get this: x@x-U52F-BBL9:~$ psql -h servername -U postgres -d repository Password for ...
    Feb 27, 2011 at 9:44 pm
    Feb 28, 2011 at 12:37 pm
  • Hi every one, Pre Basic Question Just starting with Postgres My System – MS Vista Installed Postgresql 8.4.2 Able to get into psql command tool and create a simple database, using direction from ...
    Siva kiran balijepalliSiva kiran balijepalli
    Feb 21, 2011 at 11:29 am
    Feb 25, 2011 at 8:03 pm
  • When we set ssl=on in postgres.conf the server doesn't restart at all. No error message, no log. When we turn it off again it connects fine. Postgres was installed with RedHat as a package so is ...
    David PatricolaDavid Patricola
    Feb 24, 2011 at 7:15 pm
    Feb 25, 2011 at 5:10 am
  • Hi list, My architecture will be composed by a central server and several satellites (POS); the central will have all satellites stock into one DB and its own items too. As we sometimes can have ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Feb 20, 2011 at 2:52 am
    Feb 22, 2011 at 7:36 pm
  • Let's suppose I have a table like this one but without data in the Position field: ---------------------------------------------------------------- Date Score Position ...
    Feb 19, 2011 at 1:06 am
    Feb 19, 2011 at 4:13 pm
  • Hey, Re casting char columns to int, I've worked all the proposed solutions from previous post-gres mailing list posts<http://archives.postgresql.org/pgsql-general/2010-02/msg01078.php , but to no ...
    Lille PenguiniLille Penguini
    Feb 17, 2011 at 6:48 pm
    Feb 17, 2011 at 7:32 pm
  • Hi I am new to postgresql I want to create a user account So I tried to use "create user" command. but then it is not asking for password..User is created. But when I want to enter the db with that ...
    Sivakiran BalijepalliSivakiran Balijepalli
    Feb 17, 2011 at 12:07 pm
    Feb 17, 2011 at 4:16 pm
  • Hi, I'm new to postgres but not to SQL, and have not been able to this stored function to compile: The code I've been using is: CREATE OR REPLACE FUNCTION best_spelling(IN abbreviation varchar(40), ...
    Pilling, MichaelPilling, Michael
    Feb 11, 2011 at 6:58 am
    Feb 11, 2011 at 4:03 pm
  • Is there way to make pgAdmin (Postgres 9) default the "Not NULL" checkbox to ON when adding columns? I tried searching the list archives, but this topic's wording is difficult to query. --Basil ...
    Basil BourqueBasil Bourque
    Feb 2, 2011 at 11:09 pm
    Feb 11, 2011 at 2:54 pm
  • Please excuse my lack of knowledge on the scope of Open Source principles but . . . If you develop a unique data model within Postgresql (i.e. designs for a set of tables, primary and foreign keys ...
    Caradoc JonesCaradoc Jones
    Feb 9, 2011 at 4:58 pm
    Feb 9, 2011 at 9:21 pm
  • Most of my raise statements use short format strings, but every now and then I get a long one that wraps around in my code and looks ugly. Example: raise exception 'Delivery specification for ...
    Leon StarrLeon Starr
    Feb 6, 2011 at 6:09 am
    Feb 9, 2011 at 12:20 pm
  • Ok, I just realized that I installed PostgreSQL before OpenSSL, so the --with-openssl flag is not populated/enabled. Since I installed this via Windows Binary, how can I go in and modify this flag ...
    David PatricolaDavid Patricola
    Feb 1, 2011 at 2:34 pm
    Feb 1, 2011 at 6:38 pm
  • I have added a new table idc_log to my cdrdb database. I have used the same user to create the table and can execute queries successfully from the postgreSQL client tool. But when I execute a select ...
    Karen CastilloKaren Castillo
    Feb 1, 2011 at 9:47 am
    Feb 1, 2011 at 10:56 am
  • The blob page size is already chosen not to allow for out-of-line storage, not to mention that pg_largeobject doesn't have a TOAST table. So I think avoiding detoasting is largely a waste of time. ...
    Tom LaneTom Lane
    Feb 1, 2011 at 12:02 am
    Feb 1, 2011 at 8:35 am
  • Good news for you! My friends! Here:<bestdudu.com Best electrical products such as phone,computer... Best service! Best quality! Lowest price! You can love them! Come here!My friends!
    Suresh ramasamySuresh ramasamy
    Feb 28, 2011 at 9:05 pm
    Feb 28, 2011 at 9:05 pm
  • Hi, I am writing some spatio-temporal function in postgis. Like, ST_Enters( obj_geom, boundary_geom, time t1,time t2) i.e. Does vehicle enters in ABC area between time t1 to t2? For example, select ...
    Nick RajNick Raj
    Feb 27, 2011 at 4:06 am
    Feb 27, 2011 at 4:06 am
  • Hi, I have several csv files each from whose many columns I only require a small subset. How can I avoid the trouble of specifying tables with columns I won't need just to import all this data? Any ...
    Lille PenguiniLille Penguini
    Feb 14, 2011 at 10:58 pm
    Feb 14, 2011 at 10:58 pm
  • Particularly as a return type for plpgsql? In particular, are they synonyms? I'm wondering if anyone can clarify this for me, I did read the standard documentation. Regards, Michael IMPORTANT: This ...
    Pilling, MichaelPilling, Michael
    Feb 11, 2011 at 5:15 am
    Feb 11, 2011 at 5:15 am
  • We are using Postgres as the back end for our Java database program and when we reinstalled it, it created the database with an unknown user and no other users. the previous install it created the ...
    Phillip B ChildsPhillip B Childs
    Feb 9, 2011 at 9:09 pm
    Feb 9, 2011 at 9:09 pm
  • Hi all! I am a total newb in database programming, but unfortunately, I am working on a project that requires database programming using R. I hope that some one could help me about this. Thank you ...
    Zhengyu HuZhengyu Hu
    Feb 9, 2011 at 4:21 pm
    Feb 9, 2011 at 4:21 pm
  • hi, is there a way for an application to know if an asynchronously committed transaction is actually committed or not? i want to issue some asynchronous transactions and, at some point later, ensure ...
    YAMAMOTO TakashiYAMAMOTO Takashi
    Feb 5, 2011 at 5:20 am
    Feb 5, 2011 at 5:20 am
Group Navigation
period‹ prev | Feb 2011 | next ›
Group Overview
grouppgsql-novice @

56 users for February 2011

Tom Lane: 10 posts Java4dev: 5 posts YAMAMOTO Takashi: 5 posts Joel: 4 posts Lew: 4 posts Michael Wood: 4 posts Thomas Kellerer: 4 posts Vibhor Kumar: 4 posts Craig Barnes: 3 posts Jasen Betts: 3 posts JORGE MALDONADO: 3 posts Mark Kelly: 3 posts Matty jones: 3 posts L1: 2 posts Amish: 2 posts Andrej: 2 posts Bruce Momjian: 2 posts Chetan Suttraway: 2 posts Chris Browne: 2 posts David Patricola: 2 posts
show more