FAQ

PostgreSQL > pgsql-novice > January 2009

Search Discussions

31 discussions - 136 posts

  • Hello, I am trying to write simple PG Lib on C (on Linux), it is working, bus I have some problem with data types, maybe someone can explain me a little bit: 1. What is wrong with my assignments ...
    LukasLukas
    Jan 9, 2009 at 9:35 am
    Jan 31, 2009 at 9:53 am
  • Hi ! I heard that it is always better to use a full JOIN rather than a LEFT JOIN, for performance reasons. Is that correct ? But it's barely possible to use full JOINS all the time, since most of the ...
    Nico CallewaertNico Callewaert
    Jan 28, 2009 at 10:43 am
    Jan 28, 2009 at 8:50 pm
  • Greetings, all - Apologies to everyone for contributing an extremely uninteresting and ultra-novice-level question to the community. In fact, if the following question suggests a particular help or ...
    Rebecca JonesRebecca Jones
    Jan 29, 2009 at 3:51 pm
    Jan 31, 2009 at 12:24 am
  • Hello, I am looking in to building a web site with PostgreSQL, PostGIS, MapServer, and OpenLayers so users can access an online catalogue of what GIS data is available within an organisation - ...
    Greg CocksGreg Cocks
    Jan 19, 2009 at 7:40 pm
    Jan 21, 2009 at 9:03 pm
  • Hi, I have written my first function, but I'm unable to execute it. Here is the function body and error message. CREATE OR REPLACE FUNCTION update_afdeling(update_type text, in_afd_id smallint, ...
    Nico CallewaertNico Callewaert
    Jan 24, 2009 at 12:44 am
    Jan 24, 2009 at 3:39 pm
  • If a function in PL/pgSQL is wrapped by a transaction, does that same single transaction encompass other functions defined elsewhere that this function calls? Thanks.
    Wright, GeorgeWright, George
    Jan 14, 2009 at 2:41 pm
    Jan 15, 2009 at 3:06 pm
  • Hello. What's the "correct" (read: simple, efficient) way to pass an arbitrarily sized array of C integers to postgres and have it turned into a temporary table? I'm using PostgreSQL 7.4. I could, of ...
    Postgres-novicePostgres-novice
    Jan 27, 2009 at 6:04 pm
    Jan 27, 2009 at 8:48 pm
  • I have the following table: LoadTable: MachineName - String Date - Date Time - Time IOW - Real SYS - Real USR - Real ... - Real I am trying to get information out for using in a graph. Unfortunately, ...
    Daniel StaalDaniel Staal
    Jan 23, 2009 at 8:48 pm
    Jan 26, 2009 at 7:18 pm
  • Hi list, I'm currently having a problem. I cannot call the dblink_connect function of postgres. pos=# select dblink_connect('dbname=postgres'); ERROR: function dblink_connect("unknown") does not ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    Jan 19, 2009 at 10:41 am
    Jan 20, 2009 at 10:50 am
  • All, I have a new postgresql<8.3.4 build on linux<CentOS5 with PHP talking to this database. If I try and update or insert on data that has special characters I get this error: ERROR: invalid byte ...
    Kulmacet101Kulmacet101
    Jan 8, 2009 at 7:34 pm
    Jan 8, 2009 at 9:32 pm
  • Hello. I'm trying to SELECT from the following table: file_id --------- 1 1 2 3 5 6 9 9 9 10 10 The result I'm trying to achieve is essentially to order the file_id column, in descending order, by ...
    Postgres-novicePostgres-novice
    Jan 29, 2009 at 5:04 pm
    Jan 29, 2009 at 6:57 pm
  • Hi, it seems every time I install a new version of postgres I go through this same fight with trying to get UUID to install, Ugg! Anyway in this case I think I can do without it. Does anyone know ...
    Morris, RoyMorris, Roy
    Jan 28, 2009 at 2:27 pm
    Jan 28, 2009 at 5:11 pm
  • Hi, Is there a difference between the standaard PostgreSQL en PostgresPlus from EnterpriseDB. We're planning to replace Firebird with PostgreSQL. We don't know what version to download: the one from ...
    Nico CallewaertNico Callewaert
    Jan 21, 2009 at 3:41 pm
    Jan 22, 2009 at 6:01 pm
  • Dear All, I have some open locks on some table in my postgre data base. I have closed every application, I have restarted the DB, and I have also restart the server machine itself. but the lock is ...
    InfoInfo
    Jan 8, 2009 at 6:19 pm
    Jan 10, 2009 at 5:43 pm
  • Hi all, I recently noticed that I have a postgres.exe process running at 100% CPU but is not doing any I/O. This is fresh off of starting the service. This is a local db so I am the only one using it ...
    Robert SchnabelRobert Schnabel
    Jan 24, 2009 at 5:01 pm
    Jan 27, 2009 at 12:21 am
  • I need a procedure to remove leading and trailing blanks from column of every row in a table. I would like to pass the table name as a parameter and have the procedure do the rest. Does something ...
    Wm.A.StaffordWm.A.Stafford
    Jan 21, 2009 at 6:48 pm
    Jan 25, 2009 at 12:39 am
  • Hi List, Ok I apologize if this is obvious etc but ..... 2 tables (trying to keep question simple) table 1 tbl_id primary key tbl2_acro foreign key table2.acro other_col table 2 acro primary key OK ...
    MltasmaniacMltasmaniac
    Jan 11, 2009 at 4:46 am
    Jan 11, 2009 at 10:52 pm
  • Suppose a database is created to use UTF8 encoding using the following command: createdb -E UTF8 customers Further suppose that a table is created consisting of two columns, cust_name of type text, ...
    Nagle, Gail A \(US SSA\)Nagle, Gail A \(US SSA\)
    Jan 6, 2009 at 12:32 am
    Jan 6, 2009 at 5:00 am
  • I have a Postgresql 8.3.4 server on a VMWare Linux CentOS 4.6 with 896MB RAM. I was wondering if anyone knows of documentation or a site that could help me optimize this server. This server is a ...
    Kulmacet101Kulmacet101
    Jan 3, 2009 at 6:05 pm
    Jan 4, 2009 at 6:44 am
  • Hi. I'd like to log everything to PGDATA/pg_log/postgresql.log with rotation when it reaches the size of 1kB (yes, that is not much, but I'll increase when I see it work) I have these lines ...
    A BA B
    Jan 29, 2009 at 9:23 pm
    Jan 30, 2009 at 1:16 am
  • I want to extract data for graphing from a table, but the field containing the data (value) is a text field as it has both numbers and text (that's how it is delivered to me but I have created a view ...
    Richard terryRichard terry
    Jan 27, 2009 at 8:52 pm
    Jan 27, 2009 at 11:04 pm
  • Hi to all those patient postgres-novice-question-answering-people. My vacuum tells me: "NOTICE: number of page slots needed (508096) exceeds max_fsm_pages (350000) HINT: Consider increasing the ...
    Suny KimSuny Kim
    Jan 20, 2009 at 9:03 am
    Jan 20, 2009 at 9:59 pm
  • All, I am looking for a site that might provide administration scripts for Postgresql. Specifically I am looking for a script where I can add permissions to a group or user on tables, views, and ...
    Kulmacet101Kulmacet101
    Jan 19, 2009 at 1:02 pm
    Jan 20, 2009 at 5:14 am
  • What is the best way to debug plpgsql functions with versions of PostgreSQL prior to 8.2? Thanks.
    Wright, GeorgeWright, George
    Jan 12, 2009 at 2:18 pm
    Jan 17, 2009 at 11:33 am
  • Hi, I have ordering differences between 2 servers, running both the same linux distribution (debian), the same postgresql server (8.2.9, though one was compiled, and the order installed with debian ...
    Raphael BauduinRaphael Bauduin
    Jan 15, 2009 at 11:29 am
    Jan 15, 2009 at 3:03 pm
  • I have a table that contains four fields that need to be either all null or none null. I can add a check like so: CHECK ( (col1 IS NULL AND col2 IS NULL AND col3 IS NULL and col4 IS NULL) OR NOT ...
    Plu 12Plu 12
    Jan 10, 2009 at 8:17 pm
    Jan 11, 2009 at 1:56 pm
  • If I need a field of type character without size limit, should I use VARCHAR specifying no length or TEXT? What would be the difference? With respect, Jorge Maldonado
    JORGE MALDONADOJORGE MALDONADO
    Jan 5, 2009 at 11:19 pm
    Jan 5, 2009 at 11:36 pm
  • Howdy. Once a database is created , is there any easy way to change its encoding? I have several created with SQL_ASCII encoding, which I now realize is an encoding not very recommendable. Nothing is ...
    Oliveiros CristinaOliveiros Cristina
    Jan 5, 2009 at 4:37 pm
    Jan 5, 2009 at 6:12 pm
  • Last time I had to upgrade, pg_dumpall into pg_restore didn't work and I had to use something else. A different dump command or a special option... Can't remember exactly what. It's upgrade time ...
    Andre MajorelAndre Majorel
    Jan 1, 2009 at 11:46 pm
    Jan 2, 2009 at 1:25 am
  • The statistics collector documentation says: "The parameter stats_start_collector <http://www.postgresql.org/docs/8.1/interactive/runtime-config-statistic s.html#GUC-STATS-START-COLLECTOR must be set ...
    Wright, GeorgeWright, George
    Jan 27, 2009 at 3:25 pm
    Jan 27, 2009 at 3:25 pm
  • hey All, I if a problem that apparently I can insert a record into my table with a constrain while in fact the reference doesn't exist: This is my query to test : SELECT * FROM ...
    ries van Twiskries van Twisk
    Jan 12, 2009 at 2:27 pm
    Jan 12, 2009 at 2:27 pm
Jan 2009
Group Navigation
period‹ prev | Jan 2009 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions31
posts136
users50
websitepostgresql.org
irc#postgresql

50 users for January 2009

Tom Lane: 13 posts Nico Callewaert: 11 posts Andreas Wenk: 9 posts Lukas: 8 posts Andreas Kretschmer: 5 posts Jasen Betts: 5 posts Wright, George: 5 posts Kulmacet101: 4 posts Postgres-novice: 4 posts Greg Cocks: 4 posts ries van Twisk: 4 posts Andreas Kretschmer: 3 posts Christopher Browne: 3 posts Daniel Staal: 3 posts John DeSoi: 3 posts Obe, Regina: 3 posts Oliveiros Cristina: 3 posts Bob McConnell: 2 posts Carol Walter: 2 posts David Gardner: 2 posts
show more
Archives