FAQ

Search Discussions

36 discussions - 121 posts

  • Hi, I'm new to the list and hope I don't make too much mistakes ;) I have a postgreSQL 8.1 here, where I have a little problem. Database is owned by user A, I have a group g_a and a user B. Both A ...
    Oeschey, Lars (I/EK-142, extern)Oeschey, Lars (I/EK-142, extern)
    Sep 18, 2007 at 7:44 am
    Sep 18, 2007 at 1:24 pm
  • Forgive my complete lack of knowledge here, but I have a bit of a problem! I'm in the middle of moving a website from one server to another, and it happens to be that POSTGRESQL is not available on ...
    Jonathon StiermanJonathon Stierman
    Sep 14, 2007 at 5:50 pm
    Sep 15, 2007 at 7:04 am
  • Greetings, I've googled a bit on this, and didn't find any clear answers. I've got a table with several columns, one of which I'd like to hold the contents of text files. What I tried doing was using ...
    Lonni J FriedmanLonni J Friedman
    Sep 24, 2007 at 11:57 pm
    Sep 25, 2007 at 4:21 am
  • Hello All, I am having a table with 5 columns. I want to add another column by altering the table at 2nd position constraint is that I can not drop and recreate the table as column ordering is of ...
    Ashish KaralkarAshish Karalkar
    Sep 10, 2007 at 5:42 pm
    Sep 10, 2007 at 11:50 pm
  • Hello I want to fill in a table from a file, but when I use the COPY command I get the following error: mydb= COPY weather FROM '/home/fideito/weather.txt'; ERROR: must be superuser to COPY to or ...
    Jorge AlbertoJorge Alberto
    Sep 28, 2007 at 7:40 pm
    Sep 28, 2007 at 8:27 pm
  • Hello - I'm running PG 8.2 on an 8-processor 16G Unix machine. The machine is dedicated to the db, and only 5 threads/processors are busy. The following query takes 70 seconds to execute. select ...
    David MonarchiDavid Monarchi
    Sep 25, 2007 at 8:02 pm
    Sep 27, 2007 at 11:54 am
  • I am new to this list, and pretty new to postgres. I have used Oracle, DB2, MS Sql Server, etc., for several years, but I still run into things unique to postgres that stump me. I am running Postgres ...
    Brent FriedmanBrent Friedman
    Sep 28, 2007 at 7:20 pm
    Oct 1, 2007 at 10:20 am
  • I was wondering if anyone has built a trigger or etc. that verifies the validity of an entry that is being posted to the database. I would like to do the following: 1. Iterate through the column ...
    Derrick BettsDerrick Betts
    Sep 21, 2007 at 4:10 pm
    Sep 22, 2007 at 2:28 pm
  • Hello, I've created a new schema in my database but i can't select anything from the tables into this schema, selecting from the public schema gives no trouble. I've already tried using the postgres ...
    Michael CochezMichael Cochez
    Sep 20, 2007 at 6:25 pm
    Sep 20, 2007 at 7:04 pm
  • hello list, i am facing problem while dumping a database. Here the error i am getting # /usr/local/pgsql/bin/pg_dump -U postgres ihm ihm.sql pg_dump: schema with OID 0 does not exist # i also tried ...
    Sandeep AgarwalSandeep Agarwal
    Sep 19, 2007 at 5:48 am
    Sep 20, 2007 at 2:00 pm
  • Hi - I have two questions that have arisen as a result of using the copy command to create csv files. 1. Apparently, the table from which I am trying to create the csv file has linefeeds/carriage ...
    Mija LeeMija Lee
    Sep 18, 2007 at 11:49 pm
    Sep 19, 2007 at 9:12 pm
  • Hi all, Not sure what I've done (an automatic yum update I suspect!) but my Drupal site recently died. Traced the problem back to this error in PostgreSQL: ESTLOG: connection received: host=::1 ...
    Phillip SmithPhillip Smith
    Sep 25, 2007 at 11:40 am
    Sep 25, 2007 at 10:59 pm
  • Hi All, I'm getting a lot of this sort of thing in my console when postgresql is being contacted message type 0x54 arrived from server while idle message type 0x44 arrived from server while idle ...
    Rajaram JRajaram J
    Sep 25, 2007 at 7:13 am
    Sep 25, 2007 at 1:09 pm
  • Hello, All, I need to allow access to the postgres server(windows) from a remote machine (10.61.90.231). I changed the postgresql.conf to include the line : listen_addresses = ...
    Oliveiros CristinaOliveiros Cristina
    Sep 24, 2007 at 2:56 pm
    Sep 24, 2007 at 5:57 pm
  • You can do this, you need a untrusted language like plperlU or plsh. Then you can write a TRIGGER and call external programs. Hope that helps, Andreas -- Andreas Kretschmer Kontakt: Heynitz: ...
    Andreas KretschmerAndreas Kretschmer
    Sep 18, 2007 at 4:33 pm
    Sep 18, 2007 at 5:19 pm
  • I have a language table (translations) with column names which are the language for the items in that column: english spanish german etc. I am joining that table to another table on an integer id. I ...
    Wright, GeorgeWright, George
    Sep 12, 2007 at 12:51 pm
    Sep 12, 2007 at 2:13 pm
  • Hi folks: I am doing a fresh install of 8.2.4 and have been having problems with language support. This is what I know: - pg has been configured --with perl - the libdir is /usr/lib - there are ...
    Mija LeeMija Lee
    Sep 11, 2007 at 3:55 pm
    Sep 11, 2007 at 7:19 pm
  • Hi, SUSE 10.2 pgadmin3 1.6.3 When I use a copy command from the pgadmin query screen as in: COPY agschgrid (tablename, header1, header2, header3, header4, header5, coldata1, coldata3, coldata2, ...
    JohnfJohnf
    Sep 10, 2007 at 9:55 pm
    Sep 11, 2007 at 1:51 pm
  • Hi, I am trying to update multiple tables using the 'PQputline/PQendcopy' function. The code works fine if the tables are updated one after the other. However, if there are multiple threads trying to ...
    Durgaprasad PawarDurgaprasad Pawar
    Sep 11, 2007 at 5:39 am
    Sep 11, 2007 at 10:40 am
  • Hi, I normally use pgadmin3 for backups and restorations. But sometimes, I only have terminal access to certain servers. When I try to restore a backup made with pgadmin3, pg_restore -dmydb ...
    Jason Tan Boon TeckJason Tan Boon Teck
    Sep 8, 2007 at 10:59 am
    Sep 11, 2007 at 4:01 am
  • I'm trying to connect to postgres through an odbc connection from my PC. Does the connection need to be enabled on the server side when postgres and downloaded and compiled or is it enabled by ...
    Sugrue, SeanSugrue, Sean
    Sep 24, 2007 at 8:18 pm
    Sep 24, 2007 at 9:51 pm
  • Hello Gurus I'm very surprised at the fact that primary keys are not inherited. When trying to make foreign keys from a third table to a parent table, the child table's data is not counted [I assume] ...
    T WT W
    Sep 21, 2007 at 5:11 am
    Sep 21, 2007 at 8:45 am
  • Hello, I want to create a view where the mac address of a table is seen as a string i was thinking about something like this : SELECT some_function_to_convert(mac_address) FROM table; is this ...
    Michael CochezMichael Cochez
    Sep 20, 2007 at 3:35 pm
    Sep 20, 2007 at 4:45 pm
  • I've tried different settings of --locale= and --lc_collate= But i just can't seem to get norwegian letters to be sorted correctly. I've tried googling and manual reading but have had little luck in ...
    Sten Daniel SoersdalSten Daniel Soersdal
    Sep 17, 2007 at 1:44 pm
    Sep 19, 2007 at 8:20 am
  • Hi. im new to postgresql. Im tring to install it on debian. 1. where do I extract the postgresql-8.2.4.tar.gz file and build it? 2. do I need [or recommend I have] lreadline library? - I tried to ...
    Michael AroustianMichael Aroustian
    Sep 17, 2007 at 8:30 am
    Sep 17, 2007 at 9:21 am
  • Hi I am trying to migrate an application from MS SQL Server to Postgres. In MS SQL triggers I have been used to declaring variables inserted into a table using the syntax 'SELECT . . . FROM ...
    Peter StowPeter Stow
    Sep 14, 2007 at 5:51 am
    Sep 14, 2007 at 6:18 am
  • Hi All, I wrote the following type and function to calculate and return two values based on a number of inputs. When I execute the function like this SELECT * FROM ...
    Keith WorthingtonKeith Worthington
    Sep 11, 2007 at 4:01 am
    Sep 11, 2007 at 4:28 am
  • Hi - I've read the section about transaction ID wrapping, but I'm not quite sure how to interpret this message in the log: 2007-09-06 01:45:09 PDT LOG: transaction ID wrap limit is 1083315433, ...
    Mija LeeMija Lee
    Sep 6, 2007 at 4:59 pm
    Sep 6, 2007 at 7:02 pm
  • Hi all, I am relatively new to this mailing list and to the concept of Geodatabases. We are looking to implement a single geodatabase as the main storage for all of our GI data. We would like to ...
    Brooks, StephenBrooks, Stephen
    Sep 6, 2007 at 10:57 am
    Sep 6, 2007 at 4:23 pm
  • Hi there, I'm in the process of moving a rather large OpenBase database to PG 8.2.3. In Openbase it was allowed to use column references in default expression, which seems to be forbidden in PG. You ...
    Maximilian TyrtaniaMaximilian Tyrtania
    Sep 5, 2007 at 2:43 pm
    Sep 6, 2007 at 9:06 am
  • I have a client (psycopg2) that only allows copies of the entire table (not specific rows). I would like to use a SERIAL column on tables, but I cannot seem to figure out how to apply the default. ...
    Sean DavisSean Davis
    Sep 5, 2007 at 1:28 am
    Sep 5, 2007 at 2:48 am
  • I spent a bit of time tonight poking at the issue reported here: http://archives.postgresql.org/pgsql-novice/2007-08/msg00123.php It turns out to be quite easy to reproduce, at least for me: start ...
    Tom LaneTom Lane
    Sep 29, 2007 at 3:58 am
    Sep 29, 2007 at 3:58 am
  • Hmm ... I had hoped that the fixes we put in for Windows would solve this for NFS too, but apparently not. Well, any fix will probably not appear in production for some months, so you might as well ...
    Tom LaneTom Lane
    Sep 26, 2007 at 7:07 pm
    Sep 26, 2007 at 7:07 pm
  • Hi folks, We're still evaluating our transcision from 4D Server to PostgreSQL. As 4D maintains selections in the server, and only sends the rows than can be viewed, it's fast from a user perspective. ...
    Raimon FernandezRaimon Fernandez
    Sep 24, 2007 at 8:11 am
    Sep 24, 2007 at 8:11 am
  • I like the pgsql cursor. However, the instance that I need it in, which utilizes Zend Framework, does not allow persistent connections and therefore cannot use it. Some writings have suggested making ...
    Charles SullivanCharles Sullivan
    Sep 17, 2007 at 8:25 pm
    Sep 17, 2007 at 8:25 pm
  • Hi, I wanted to use user accounts in my PostgreSql database for system authentication. I have installed the following: Fedora Core 6 Postgresql 8.2.4 pam-pgsql-0.6.3(found at ...
    Yanot panaraYanot panara
    Sep 8, 2007 at 1:06 am
    Sep 8, 2007 at 1:06 am
Group Navigation
period‹ prev | Sep 2007 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions36
posts121
users50
websitepostgresql.org
irc#postgresql

50 users for September 2007

Richard Broersma Jr: 12 posts Sean Davis: 12 posts Tom Lane: 10 posts Oeschey, Lars (I/EK-142, extern): 6 posts Mija Lee: 5 posts Oliver Elphick: 5 posts Andreas Kretschmer: 4 posts Jonathon Stierman: 4 posts Michael Cochez: 4 posts Robert Wimmer: 4 posts Derrick Betts: 3 posts Lonni J Friedman: 3 posts Phillip Smith: 3 posts A Gilmore: 2 posts Devrim GÃNDÃZ: 2 posts Jason Tan Boon Teck: 2 posts Johnf: 2 posts Jorge Alberto: 2 posts Maximilian Tyrtania: 2 posts Oliveiros Cristina: 2 posts
show more
Archives