FAQ

Search Discussions

351 discussions - 1,927 posts

  • Hi, one of the biggest disease of PostGreSQL is, that i can't change the definition of a column. In order to do that, i'd have to drop any keys, drop the column and create a new one with all indexes ...
    Sven KoehlerSven Koehler
    Jun 12, 2003 at 2:20 pm
    Jun 26, 2003 at 3:00 pm
  • Hi. I will explain my experience to prevent other to fall in the same problem. We upgraded from 7.2 to 7.3 few days ago. We reload the data via pg_dump an psql -i <file_dumped . The pg_dump was made ...
    Conxita MarínConxita Marín
    Jun 18, 2003 at 4:28 pm
    Jun 24, 2003 at 10:13 pm
  • [ CC to general.] [ MySQL changes client library to GPL.] This is _very_ interesting, and not surprising. MySQL got users to adopt MySQL, then they change the client license to get users to purchase ...
    Bruce MomjianBruce Momjian
    Jun 22, 2003 at 9:59 pm
    Jun 27, 2003 at 3:54 pm
  • Some backs-story. I'm in the process of converting our internal file based data storage to an RDBMS. After looking a bit at PostgreSQL and MySQL, I chose Postgresql. My boss has heard of MySQL and ...
    Jay O'ConnorJay O'Connor
    Jun 11, 2003 at 3:21 pm
    Jun 17, 2003 at 10:47 am
  • I've worked with the Pl/Python code in the past and will see about removing rexec and making it an untrusted language. Last time I looked, it didn't look particularly difficult. I've set aside some ...
    Kevin JacobsKevin Jacobs
    Jun 19, 2003 at 1:28 am
    Jul 9, 2003 at 4:02 pm
  • Jan wrote [to hackers, but I moved it to general (sorry in advance if that was bad)]: I wonder if the SAP deal is related to the $19.5 million round of venture capital MySQL AB just raised: ...
    Ron MayerRon Mayer
    Jun 6, 2003 at 2:50 pm
    Jun 16, 2003 at 2:33 pm
  • Hi, I have this very strange problem that I cannot figure out. I am in the process of converting a Coldfusion MX application from SQL Server to PostgreSQL 7.3.2 running on SuSE Linux 8.2. Since ...
    Avi SchwartzAvi Schwartz
    Jun 4, 2003 at 3:26 pm
    Jun 10, 2003 at 4:50 am
  • Hi all: I have here a table belonging to a message board (Phorum 3.3), and there's an index in it that is not being used for reasons that I don't understand. The table is: Table "todocinetv" Column | ...
    Paulo JanPaulo Jan
    Jun 10, 2003 at 5:25 pm
    Jun 16, 2003 at 6:12 am
  • Hi, Just a quick question, not unrelated to my previous question, which I don't think will get answered. I have a table with 13 fields. Is that too many fields for one table. Thanks, Mark
    MTMT
    Jun 26, 2003 at 12:55 am
    Jun 29, 2003 at 4:12 pm
  • Don't know if anyone's posted this yet... This, combined with the admittedly weird SAP DB deal, is bad news for PostgreSQL. Today, it's clearly the superior product. It will be tomorrow too. But ...
    Ned LillyNed Lilly
    Jun 4, 2003 at 12:47 pm
    Aug 25, 2003 at 12:51 pm
  • Hello, is it possible, to use a postgreSQL database on a NAS or a SAN? I somewhere read, that you should not install a database to a RAID5 but the most NAS and SAN I know, are using RAID5. Does ...
    Daniel SeichterDaniel Seichter
    Jun 15, 2003 at 7:02 pm
    Jun 18, 2003 at 8:35 pm
  • Hi, I am developing application with PHP as the front end, PGSQL as the backend. I am trying to figure out what's the best way to do this. I want to check if an entry already exists in the table. If ...
    Reuben D. BudiardjaReuben D. Budiardja
    Jun 25, 2003 at 5:56 pm
    Jun 28, 2003 at 5:04 am
  • Okay, I'm obviously doing something wrong but what? I have a trigger defined as: create or replace function cms_user_id_insert_tgr_1 ( ) returns trigger as ' begin execute '' select 1 from ...
    Nigel J. AndrewsNigel J. Andrews
    Jun 17, 2003 at 9:39 am
    Jun 19, 2003 at 11:27 pm
  • No CPUs or RAM. The problem isn't the kernel, realy, it's x86 hardware. The kernel guys aren't going to bother to try to support it until there's hardware support. However for PCI cards, USB, ...
    Jonathan BartlettJonathan Bartlett
    Jun 18, 2003 at 1:03 pm
    Jun 19, 2003 at 3:35 am
  • I have two queries that return identical results. One is a SELECT DISTINCT and the other is the same query without the DISTINCT. The explain for the second one makes it seem as if it would be faster: ...
    Joseph ShraibmanJoseph Shraibman
    Jun 17, 2003 at 12:31 am
    Jun 18, 2003 at 6:36 pm
  • Wasn't sure if this should go to hackers or not, so here it is... It appears that after a pgsql backend uses memory for sort, it doesn't get released again, at least on solaris. IE: 17660 jnasby 1 0 ...
    Jim C. NasbyJim C. Nasby
    Jun 16, 2003 at 6:31 am
    Jun 20, 2003 at 8:28 pm
  • Hello all, I have a table consisting of about 450.000 rows with a unique primary key char(9) kundennummer CHAR(9) unique primary key ... some fields... miano CHAR(6) Today someone issued an UPDATE ...
    Henrik SteffenHenrik Steffen
    Jun 6, 2003 at 8:56 am
    Jun 10, 2003 at 5:36 am
  • Hi Forum, What should I correct in order to eliminate the following error message on start: Executing /etc/rc.d/init.d/postgresql start .. Starting postgresql service: -sh: [: ==: unary operator ...
    CarlosCarlos
    Jun 23, 2003 at 7:15 pm
    Jun 25, 2003 at 5:11 pm
  • Maybe someone can shed a light on this: I have a (test) table, populated with 2M rows: rid int4, -- primary key dcid varchar, dsid varchar, drid int4, owid int4, nxid int4, usg int4, --- something ...
    Ernest E VogelsingerErnest E Vogelsinger
    Jun 12, 2003 at 9:38 pm
    Jun 13, 2003 at 8:38 pm
  • Hi Folks, Shudnt' messages like ERROR: value too long for type character varying(5) Indicate which column and table the server is talking about . Without that we need to open the application source ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Jun 27, 2003 at 6:26 am
    Jun 30, 2003 at 4:05 pm
  • Hi, I have a database with a few tables in it (this is just a "learning" database). Originally I set these tables up with sequences on them which increment the primary key of the table when a new ...
    Erik PriceErik Price
    Jun 19, 2003 at 9:52 pm
    Jun 28, 2003 at 3:06 am
  • This is the query I posted a performance question on, but I have a SQL standard question about it too: update missing_ids set mtransts = a.mtransts, mtranmemtp = a.mtranmemtp from memtran as a where ...
    NolanNolan
    Jun 15, 2003 at 10:09 pm
    Jun 24, 2003 at 4:33 pm
  • Hello list I am working with PostgreSQL for the Bavarian Cadastral Administration. We want to update our WWW online services so that they can use more data. For that reason we want to set up an ...
    Hubert FröhlichHubert Fröhlich
    Jun 18, 2003 at 10:58 am
    Jun 19, 2003 at 9:07 am
  • Dear all, Is there any script/tool I can use to convert Oracle database to Postgresql? Thanks Ursula
    Ursula LeeUrsula Lee
    Jun 18, 2003 at 2:07 am
    Jun 18, 2003 at 3:46 pm
  • Hi I try to add new dict,but I've get an error $mars- {sector119}:~ % ls -la /usr/local/pgsql/share/ukrainian* -rw-r--r-- 1 root root 59504 2 2000 /usr/local/pgsql/share/ukrainian.aff -rw-r--r-- 1 ...
    Sector119Sector119
    Jun 13, 2003 at 2:33 pm
    Jun 17, 2003 at 9:13 pm
  • Hmmm, it's been a couple of days, and this still hasn't appeared on the mailing list as far as I can tell. This is a resend. ---------- Forwarded message ---------- Date: Mon, 9 Jun 2003 00:23:38 ...
    Edmund DenglerEdmund Dengler
    Jun 11, 2003 at 3:18 am
    Jun 12, 2003 at 3:19 pm
  • I have a table with a SEQUENCE on it that increments the primary key (a BIGINT column) of the table whenever a new insert is performed. Is there a way to determine the last incremented value, so that ...
    Erik PriceErik Price
    Jun 12, 2003 at 5:15 pm
    Jun 21, 2003 at 2:10 pm
  • I have read the manual about sequences and I thought I understood both their purpose and how to use them. When I perform inserts, the sequence is updated appropriately. However, I can't seem to ...
    Erik PriceErik Price
    Jun 13, 2003 at 8:28 pm
    Jun 17, 2003 at 7:02 pm
  • Isn't Redhat doing that? I heard they were working on a complete NIST validation. That's a stupendous effort.
    Dann CorbitDann Corbit
    Jun 10, 2003 at 5:57 pm
    Jun 12, 2003 at 12:02 pm
  • Does anybody know what Redhat's enhancements to PostgreSQL are? From their web pages, it appears to be an installer and graphical interface (phppgadmin?). Scott thinks they might optimize ...
    CSNCSN
    Jun 26, 2003 at 8:28 pm
    Jun 28, 2003 at 11:08 pm
  • Hi, I have two backup questions, not much related to each other; here they are. First: With PostgreSQL, I can't do incremental backups. pg_dump will dump the entire database. Thus, if I want to keep ...
    Antonios ChristofidesAntonios Christofides
    Jun 19, 2003 at 8:42 am
    Jun 20, 2003 at 5:21 pm
  • Right now there is no way to get development snapshots later than June 2nd. Is there any estimate on when anonymous CVS access or up to date snapshots will be available again?
    Bruno Wolff IIIBruno Wolff III
    Jun 6, 2003 at 5:32 pm
    Jun 10, 2003 at 6:37 am
  • Hi, What chars must be escaped in string and how exactly? LF - \\n CR - \\r
    IvarIvar
    Jun 24, 2003 at 12:44 pm
    Jul 18, 2003 at 3:45 am
  • Hello Here we have a couple of tables with very high rotation: on one of them, rows get inserted all the time from 2 up to 15 per second, depending on application level of activity. Each row has a ...
    Claudio LapidusClaudio Lapidus
    Jun 25, 2003 at 10:39 pm
    Jun 27, 2003 at 2:25 pm
  • There also ssh clients which support X11 forwarding on a windows machine and since there are X11 servers for windows... You don't necessarily need a unix workstation. Apart from that, a (tight)vnc ...
    Arjen van der MeijdenArjen van der Meijden
    Jun 24, 2003 at 1:53 pm
    Jun 24, 2003 at 5:02 pm
  • Howdy: Running PostgreSQL 7.2.1 on RedHat Linux 7.2. I have a table with about 10 million records and even though it's indexed on three key columns, it's still pretty slow, I believe, because of the ...
    Johnson, ShaunnJohnson, Shaunn
    Jun 20, 2003 at 2:02 pm
    Jun 20, 2003 at 6:57 pm
  • I've created a database called Inflight as user fc I've created a user named luser I want to: grant all on database Inflight to luser; and PostgreSQL responds: ERROR: database "inflight" not found ...
    Travis HumeTravis Hume
    Jun 18, 2003 at 5:51 pm
    Jun 18, 2003 at 10:25 pm
  • I will soon need to begin a project that requires full text searching and I think I want to use tsearch. I have installed the current version and all is well but after doing some more research it ...
    Culley harrelsonCulley harrelson
    Jun 10, 2003 at 9:05 am
    Jun 16, 2003 at 6:26 pm
  • I need a shell scriptable method to determine if a postgresql database is running and accepting connections. I've written a script to start out postgresql database and I was using: "pg_ctl status" to ...
    Travis HumeTravis Hume
    Jun 11, 2003 at 11:36 pm
    Jun 12, 2003 at 8:11 pm
  • I am upgrading my workstation to 7.3.3. I have some database backups that were created with this command. /usr/local/pgsql/bin/pg_dump $db | gzip /usr/local/pgsql/backups/$filename Which generates ...
    Brian AvisBrian Avis
    Jun 7, 2003 at 12:08 am
    Jun 10, 2003 at 3:27 pm
  • Hi, I am trying to create an index on the year of a date field, to speed up some queries. Table structure is as follows ------------------------------------------------------------------------ ---- ...
    Nick BarrNick Barr
    Jun 5, 2003 at 4:38 pm
    Jun 6, 2003 at 10:32 pm
  • I'm creating a new OpenACS package that uses PostgreSQL, and in doing so have encountered what seems to be a problem in PostgreSQL. Specifically, I defined a Pl/PgSQL function with 24 parameters. ...
    Reuven M. LernerReuven M. Lerner
    Jun 24, 2003 at 5:19 am
    Jun 25, 2003 at 9:14 pm
  • Hi there, I've managed to get postgresql working with UTF8 and KOI8. Here is some mini-howto: http://www.sai.msu.su/~megera/postgres/utf8.html Regards, Oleg Oleg Bartunov, sci.researcher, hostmaster ...
    Oleg BartunovOleg Bartunov
    Jun 13, 2003 at 6:02 pm
    Jun 16, 2003 at 5:58 am
  • Hello, I am porting an application from MS SQL 7.0 that dynamically creates statements. I have a table with a date field. Now I would like postgresql to insert NULL when I insert '': insert into foo ...
    Daniel GehrkeDaniel Gehrke
    Jun 13, 2003 at 11:33 am
    Jun 14, 2003 at 2:58 pm
  • re-Hello, First, a little rectification, it's PostgreSQL 6.5.2 and not 6.5.3 as I wrote in the last message... Second : I've tried doing a vacuumdb of the database but it don't changes anything... ...
    Bruno BAGUETTEBruno BAGUETTE
    Jun 11, 2003 at 8:58 am
    Jun 13, 2003 at 3:24 pm
  • Hi, I'm trying to write a check on a column restricting the data to numerals from 0-9, commas, dashes '-' and single spaces. To allow the entry of something like "134-140, 310-312". I seem to have ...
    Joel RodriguesJoel Rodrigues
    Jun 4, 2003 at 6:41 pm
    Jun 5, 2003 at 1:55 pm
  • How can I know tables is inherited or no? # create table parent ( id int primary key, value text ); # create table child ( cval text, primary key (id) ) INHERITS (parent); # \d child Table ...
    Teodor SigaevTeodor Sigaev
    Jun 25, 2003 at 3:26 pm
    Jul 25, 2003 at 9:43 pm
  • Hello all, REINDEXING a table I get the following message: ERROR: Cannot create unique index. Table contains non-unique values. How can that be in REINDEXING ? This means, that the index has been ...
    Henrik SteffenHenrik Steffen
    Jun 30, 2003 at 12:00 pm
    Jul 1, 2003 at 7:13 pm
  • Hello , I have table directory with 3 columns (id,url,title) I want to list all entries with duplicate urls. I tried this: select id,url,title from directory where url IN (select url from directory ...
    Uroš GruberUroš Gruber
    Jun 24, 2003 at 10:16 am
    Jun 24, 2003 at 4:35 pm
  • I am running a Java application on Linux which connects to the Postgresql on Linux using jdbcodbc bridge. But this is the error I am getting : sun.jdbc.odbc.JdbcOdbcDriver ...
    Kallol NandiKallol Nandi
    Jun 20, 2003 at 10:34 am
    Jun 21, 2003 at 8:00 am
Group Navigation
period‹ prev | Jun 2003 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions351
posts1,927
users334
websitepostgresql.org
irc#postgresql

334 users for June 2003

Tom Lane: 194 posts Scott.marlowe: 82 posts Bruno Wolff III: 60 posts Bruce Momjian: 49 posts Dennis Gearon: 38 posts Jim C. Nasby: 37 posts Nigel J. Andrews: 35 posts Stephan Szabo: 35 posts Ron Johnson: 34 posts Richard Huxton: 31 posts Jan Wieck: 28 posts Ernest E Vogelsinger: 27 posts Jonathan Bartlett: 27 posts Sven Köhler: 27 posts Nolan: 25 posts Erik Price: 22 posts Dmitry Tkach: 21 posts Shridhar Daithankar: 21 posts The Hermit Hacker: 21 posts Joe Conway: 19 posts
show more
Archives