Search Discussions

37 discussions - 122 posts

  • We are using postgres as the back-end to our webapp which is built with Jakarta Tomcat, Struts, and Hibernate. Most of our database-related activity is very simple and so most of our selects, ...
    Frank KurzawaFrank Kurzawa
    Jun 22, 2004 at 5:21 pm
    Jun 23, 2004 at 10:25 pm
  • Hi there, My database was created with Unicode encoding, as a fair number of the artists and exhibitions have French names, and thus include accented characters. I thought I'd solved all the various ...
    Lynna LandstreetLynna Landstreet
    Jun 9, 2004 at 6:11 pm
    Jun 17, 2004 at 5:32 pm
  • Hi there, Does anyone else here host their sites with pgHoster.com? More to the point, does anyone know what's happened to them? We switched our site to them a couple of months ago and while ...
    Lynna LandstreetLynna Landstreet
    Jun 23, 2004 at 6:49 pm
    Jul 11, 2004 at 3:59 pm
  • I want to execute the sql stored in a directory on my system. How do I submit this file, in batch, to pgsql to be executed?
    Loftis, Charles ELoftis, Charles E
    Jun 3, 2004 at 7:24 pm
    Jun 3, 2004 at 8:58 pm
  • INFO: vacuuming "pg_toast.pg_toast_17242" ERROR: invalid page header in block 2003917 of relation "pg_toast_17242" Is there a way to fix this error, or do I need to rebuild the table? thanks Michael.
    Michael GuerinMichael Guerin
    Jun 9, 2004 at 1:29 pm
    Jun 12, 2004 at 7:38 pm
  • 4


    I have the following table structure: CREATE TABLE "xxx" ( "co" character varying(7), "co1" character varying(9), "n1" character varying(15), "l1" character varying(5), "m1" smallint, "ore" bigint ); ...
    Jun 23, 2004 at 10:27 am
    Jun 25, 2004 at 3:32 pm
  • Hi I try to do the following in a table that has 4 columns, id - month - day- time The column id is the primary key, for example id - month . day - time 1 Jan 22 16:15 2 Jan 22 16:16 3 Jan 22 16:17 4 ...
    Eduardo V. RodríguezEduardo V. Rodríguez
    Jun 15, 2004 at 12:14 am
    Jun 16, 2004 at 7:09 pm
  • Hi there, Does anyone know if it's possible to modify an existing table constraint - for example, to add "ON DELETE CASCADE" to an existing foreign key constraint? Or would I have to recreate the ...
    Lynna LandstreetLynna Landstreet
    Jun 4, 2004 at 11:03 pm
    Jun 6, 2004 at 6:54 am
  • Hi, We recently switch over from Solaris to Linux and we've been experiencing a couple database corruptions problems. We're using the 2.6 kernel and a XFS file system, in case there are any known ...
    Michael GuerinMichael Guerin
    Jun 11, 2004 at 8:16 pm
    Jun 24, 2004 at 8:10 pm
  • I was reading the o'reilly practical PostgreSQL book and came across the chapter that mentioned the Array Column. I fail to see the scenarios where this would be an useful feature. How is this better ...
    Jun 14, 2004 at 6:20 pm
    Jun 21, 2004 at 1:43 pm
  • Is this message the sign of trouble, or is it harmless?
    Michael GuerinMichael Guerin
    Jun 16, 2004 at 2:10 pm
    Jun 18, 2004 at 3:17 pm
  • Hi Tom, Bruce and other members, Following are the statistics for the problem : specified item offset is too large, failed to add item to the page, which I am getting almost each time with my ...
    Rajan BhideRajan Bhide
    Jun 3, 2004 at 6:09 am
    Jun 3, 2004 at 2:43 pm
  • Hello: I am using postgres 7.35 on a Linux 9.0 PC. I am trying to create a technical intranet using the postgresql database for the information. When I type in a solution to a problem all of the text ...
    Larry J. GrossLarry J. Gross
    Jun 28, 2004 at 4:39 pm
    Jul 2, 2004 at 4:16 pm
  • By mistake I took away superuser rights from my postgresql Admin. Any idea how to get it back? There is no other superuser in the database. ---- R.Hnat
    Reinhard HnatReinhard Hnat
    Jun 29, 2004 at 9:03 am
    Jun 29, 2004 at 2:07 pm
  • sir/madam please, help me to get hold of postgres software for my new installation. ......How to install postgress ......How to install the server and so on thanks justus ...
    Justus MugbehJustus Mugbeh
    Jun 23, 2004 at 8:54 am
    Jun 23, 2004 at 5:16 pm
  • I suppose this is actually an OpenGroupware question, but nothing at that site seems to adequately address the issue. I run Debian, and it kind of looks like the debs at ogo.org are set for stable ...
    Jun 16, 2004 at 11:25 pm
    Jun 20, 2004 at 11:08 pm
  • Hello, I created a database and I would like to know how can I make a copy (on a memory stick) of that database and transfer it on another PC. It's possible? I have been looking for the database but ...
    Alain-Serge NagniAlain-Serge Nagni
    Jun 20, 2004 at 8:13 am
    Jun 20, 2004 at 3:56 pm
  • I downloaded the RPMs for RHLinux9 and have run the upgrade, but now I receive an error about the database format needing to be upgraded when I attempt to start the service. Fortunately at this ...
    Michael A WeberMichael A Weber
    Jun 11, 2004 at 12:58 am
    Jun 11, 2004 at 7:12 am
  • Hi does postgresql have a similar command to SHOW in MySQL. I want to select all tables that match a criteria then select all columns. from those tables. in MySQL: "SHOW tables like 'stu%'"; "SHOW ...
    Robert MorganRobert Morgan
    Jun 8, 2004 at 12:37 am
    Jun 8, 2004 at 1:09 pm
  • What's the appropiate command to shut down the Postgres server (postmaster)? Charles Loftis celoftis@unity.ncsu.edu
    Jun 7, 2004 at 12:58 am
    Jun 7, 2004 at 8:07 pm
  • Hi there, I am a newbie, trying to move a pg db from PostgreSQL 7.13 on RedHat 7.3 to PostgreSQL 7.42 on FreeBSD 4.9. The db has one table with 32,000 rows, each containing a blob. The blobs range in ...
    Chris McCormickChris McCormick
    Jun 3, 2004 at 1:14 pm
    Jun 4, 2004 at 3:00 pm
  • Hello: I am using postgres 7.35 on a Linux 9.0 PC. I am trying to create a technical intranet using the postgresql database for the information. When I type in a solution to a problem all of the text ...
    Larry J. GrossLarry J. Gross
    Jun 28, 2004 at 5:31 pm
    Jun 28, 2004 at 7:23 pm
  • From what I've read, Postgres stores plenty of precision to contain milliseconds. My question is, how do I see the milliseconds? Just doing a select on a timestamptz column just gives me hh:mm:ss... ...
    Christopher BeckerChristopher Becker
    Jun 21, 2004 at 8:24 pm
    Jun 22, 2004 at 1:48 am
  • I'm tying to estimate the expense of migrating some application from Oracle to PostgreSQL I'm happy to see, that there are many simmilarities in SQL and PostgreSQl has also all kinds of DML-triggers. ...
    Michael KleiserMichael Kleiser
    Jun 18, 2004 at 10:28 am
    Jun 18, 2004 at 3:00 pm
  • Hello, I am having problems connecting to postgreSQL from my JSP page. I have followed the instructions from other mailing lists and have started the DB with postmaster with the -i option. Also, the ...
    Edgar SaenzEdgar Saenz
    Jun 10, 2004 at 2:35 pm
    Jun 10, 2004 at 5:12 pm
  • hi all, I've constructed a simple query which takes too long to finish. EXPLAIN ANALYZE ( all data shown below ) reports that at one stage there are 40K rows ( on a toy database, most probable cause ...
    Dmitry KarasikDmitry Karasik
    Jun 10, 2004 at 1:01 pm
    Jun 10, 2004 at 3:53 pm
  • In many other db systems you can use built in functions to check to see if an object exists in the db... For example, in Sybase, you can use the object_id function to check to see if an object ...
    Loftis, Charles ELoftis, Charles E
    Jun 8, 2004 at 7:09 pm
    Jun 8, 2004 at 7:37 pm
  • Here is an article at wikipedia (http://en.wikipedia.org/wiki/PostgreSQL) And here is a question: how relation between tables user and address have to be declared? <QUOTE Another very useful feature ...
    Ilya S. SlyzhnyakIlya S. Slyzhnyak
    Jun 1, 2004 at 3:58 am
    Jun 7, 2004 at 8:10 pm
  • Hi, Does anyone know of a way to perform an insert that does not abort the transaction if it fails? I am trying to implement a rule that will allow the insertion data into a view (for backward ...
    Shawn ChisholmShawn Chisholm
    Jun 7, 2004 at 5:54 pm
    Jun 7, 2004 at 8:06 pm
  • For Postgres: 1. Is there an ODBC example to identify/process records locks in Postgres? 2. Is there an example using ODBC to set the statement attribute: SQL_ATTR_QUERY_TIMEOUT to timeout; I have ...
    Robert AntonioRobert Antonio
    Jun 29, 2004 at 5:35 pm
    Jun 29, 2004 at 5:35 pm
  • unsubscribe
    Jun 28, 2004 at 6:35 pm
    Jun 28, 2004 at 6:35 pm
  • Hi I have a problem with initdb ! When i run initdb it stops at line 6 at the following messages $ ipc-daemon2 & $ initdb -D /usr/local/pgsql/data messages : 1- Fixing permissions on existing ...
    Hondjack DehainsalaHondjack Dehainsala
    Jun 27, 2004 at 10:54 am
    Jun 27, 2004 at 10:54 am
  • This isn't really a bug; you should have posted you question to pgsql-novice. (Followups set to there and to you.) The simplest solution is probably to su to root and then su to postgres and then do ...
    Bruno Wolff IIIBruno Wolff III
    Jun 22, 2004 at 1:51 pm
    Jun 22, 2004 at 1:51 pm
  • Hi, I m porting stored procedures from SQL to PGSQL. I dont know much about PGSQL. I have problems in returning affected rows from the function. I could not find much information about this. I would ...
    Pradeepkumar, Pyatalo (IE10)Pradeepkumar, Pyatalo (IE10)
    Jun 18, 2004 at 6:43 am
    Jun 18, 2004 at 6:43 am
  • hi! I'm trying to make a select query which displays the entries in my table by week of month, each week beginning on a monday and ending on a sunday, with the 1st monday of the month marking the ...
    Crystal clearCrystal clear
    Jun 14, 2004 at 3:48 pm
    Jun 14, 2004 at 3:48 pm
  • Hi Simple question How do I know the size (in megabytes, gigabytes)of a table? Thank you in advanced
    Eduardo V. RodríguezEduardo V. Rodríguez
    Jun 10, 2004 at 10:32 pm
    Jun 10, 2004 at 10:32 pm
  • You were absolutely right! I just installed 7.4.2 and assumed that it was the system that we were running. There was an error, and so the database was re-installed. All is great now. Thanks everyone ...
    Jun 2, 2004 at 1:00 am
    Jun 2, 2004 at 1:00 am
Group Navigation
period‹ prev | Jun 2004 | next ›
Group Overview
grouppgsql-novice @

56 users for June 2004

Tom Lane: 19 posts Michael Guerin: 7 posts Bruno Wolff III: 6 posts Lynna Landstreet: 6 posts Josh Berkus: 5 posts Eduardo V. Rodríguez: 4 posts Frank Kurzawa: 4 posts Scott Marlowe: 4 posts Ghaverla: 3 posts Joe Erickson: 3 posts Loftis, Charles E: 3 posts Mike G: 3 posts Derrick: 2 posts Alain-Serge Nagni: 2 posts Bryan Irvine: 2 posts Chris McCormick: 2 posts Frank Bax: 2 posts Larry J. Gross: 2 posts Markus Bertheau: 2 posts M. Bastin: 2 posts
show more