FAQ

Search Discussions

140 discussions - 1,024 posts

  • Just a personal observation here, based on the work we've been doing lately ... there are *alot* of very large companies out there, one of which we just did onsite training for that I swear has an ...
    Marc G. FournierMarc G. Fournier
    Jun 25, 2002 at 7:19 pm
    Jun 27, 2002 at 4:16 am
  • That would be good, as would an updated "postgres vs mysql" article to point people towards. Or a "postgres myths debunked" page. Since you asked, here are some ideas and thoughts I've been batting ...
    Greg Sabino MullaneGreg Sabino Mullane
    Jun 25, 2002 at 7:32 pm
    Jun 28, 2002 at 12:17 pm
  • Hi , I am extremely new to PostGreSql. If any one can please answer this question of mine. I want to insert/update records into the postgres database through C or perl code. The only condition is ...
    Vikas p vermaVikas p verma
    Jun 10, 2002 at 8:43 pm
    Jun 18, 2002 at 4:58 pm
  • Hello, I am new to PostgreSQL, but I am interested in the Win32 port. I have studied the architecture of other databases like Oracle. They have had to turn their multi-process model used on Unix into ...
    Serge AddaSerge Adda
    Jun 18, 2002 at 5:31 pm
    Jun 21, 2002 at 2:47 am
  • Developers, Here's part to of my proposal to enhance, improve, and fix Timestamp and Interval in PostgreSQL. Part I is included after Part II in case everyone has forgotten it. Please give me ...
    Josh BerkusJosh Berkus
    Jun 7, 2002 at 11:33 pm
    Jun 12, 2002 at 9:41 am
  • I've got patches for the CREATE CAST/DROP CAST feature (just a rearrangement of our existing function declaration syntax). The SQL99 form assumes that an existing function will be used for the cast ...
    Thomas LockhartThomas Lockhart
    Jun 20, 2002 at 4:19 pm
    Jun 28, 2002 at 4:13 am
  • I think libpqxx, the alternative to libpq++, is just about ready for prime time. That means integrating it with the main source tree, I suppose, but I have no idea where to start--particularly ...
    Jeroen T. VermeulenJeroen T. Vermeulen
    Jun 12, 2002 at 7:29 pm
    Jul 3, 2002 at 4:12 pm
  • How about we add the preproc.c file generated by bison 1.49 to cvs? Could that create problems elsewhere? The version that is part of the source tree now is generated on the server, isn't it? Michael ...
    Michael MeskesMichael Meskes
    Jun 18, 2002 at 6:55 pm
    Jun 28, 2002 at 10:58 am
  • Currently serial is dumped as a sequence and appropriate default statement. With my upcoming dependency patch serials depend on the appropriate column. Drop the column (or table) and the sequence ...
    Rod TaylorRod Taylor
    Jun 13, 2002 at 12:10 pm
    Jun 14, 2002 at 11:26 pm
  • [ Discussion moved to hackers.] I have thought that some type of feedback from the executor back into the optimizer would be a good feature. Not sure how to do it, but your idea makes sense. It ...
    Bruce MomjianBruce Momjian
    Jun 21, 2002 at 3:08 am
    Apr 21, 2005 at 2:03 am
  • The clean way to do this would be to allow extra FROM-list relations in DELETE. We already have a similar facility for UPDATE, so it's not clear to me why there's not one for DELETE. Then you could ...
    Tom LaneTom Lane
    Jun 10, 2002 at 3:21 pm
    Aug 26, 2002 at 9:35 pm
  • I know you guys love subject lines like this, but I have a humble request. Would it be possible to have either a GUC setting or a grammar change to allow TEMPORARY tables to be dropped at transaction ...
    Mike MascariMike Mascari
    Jun 13, 2002 at 9:10 pm
    Jul 8, 2002 at 1:50 am
  • Totally false: http://www.microsoft.com/sql/evaluation/compare/benchmarks.asp False again. There is a problem if the clusted objects are added always to the end of the file, or are constantly hitting ...
    Dann CorbitDann Corbit
    Jun 26, 2002 at 8:20 pm
    Jun 27, 2002 at 7:19 pm
  • I've just committed changes which implement three SQL99 functions and operators. OVERLAY() allows substituting a string into another string, SIMILAR TO is an operator for pattern matching, and a new ...
    Thomas LockhartThomas Lockhart
    Jun 11, 2002 at 3:49 pm
    Jun 13, 2002 at 2:33 pm
  • I have a query which contains both a group by and a count, e.g: SELECT to_char(pa_shopping_cart.delivery_date, 'FMMM/FMDD/YY') AS delivery_date, pa_products.product_name AS product_name, ...
    RyanRyan
    Jun 19, 2002 at 8:14 pm
    Jun 20, 2002 at 2:10 am
  • I finally hit bison's limit and cannot find any easy to remove rules in the ecpg part of the parser anymore. There may be some in the backend part, but I'd like to keep those in sync. For the time ...
    Michael MeskesMichael Meskes
    Jun 18, 2002 at 1:36 pm
    Jun 19, 2002 at 4:49 pm
  • Deletion of data from a PostgreSQL table is very slow. It would be nice to have a very fast delete like "truncate table." Now, truncate is a very dangerous command because it is not logged (but the ...
    Dann CorbitDann Corbit
    Jun 12, 2002 at 7:32 pm
    Jun 13, 2002 at 9:58 am
  • I've been busy working on my presentation on concurrency for the upcoming O'Reilly conference. While doing so, I've been thinking more about the question of when to do SetQuerySnapshot calls inside ...
    Tom LaneTom Lane
    Jun 16, 2002 at 11:53 pm
    Jun 20, 2002 at 1:36 am
  • Hi all! First of all, thanks for your fine job and the answers to a problem (which I thought it was a PG bug) I posted some days ago. I've solved it! Now I've got another strange issue to post... ...
    NunoACHenriquesNunoACHenriques
    Jun 2, 2002 at 4:20 pm
    Jun 11, 2002 at 1:40 pm
  • OK, we need to vote on this patch. It reduces the tuple header by 4 bytes (11% decrease). If we apply it, we will not be able to easily use pg_upgrade for 7.3 because the on-disk table format will ...
    Bruce MomjianBruce Momjian
    Jun 28, 2002 at 11:32 pm
    Jul 3, 2002 at 5:22 pm
  • I am working on the TODO item: o Change syntax to WITH DELIMITER, (keep old syntax around?) and I have added syntax so COPY can now accept all parameters at the end using WITH: COPY table FROM { ...
    Bruce MomjianBruce Momjian
    Jun 19, 2002 at 6:13 am
    Jun 24, 2002 at 12:39 pm
  • What does this mean, and what could be causing it? FATAL 2: InitRelink(logfile 0 seg 173) failed: No such file or directory That's the second time in as many months that I have received this error ...
    James ThorntonJames Thornton
    Jun 15, 2002 at 5:09 pm
    Jun 18, 2002 at 3:32 pm
  • From the ToDo list: Vacuum: * Provide automatic running of vacuum in the background (Tom) As of 7.2 we have lazy vacuum. The next logical step is setting up vacuum to run automatically in the ...
    Matthew T. O'ConnorMatthew T. O'Connor
    Jun 29, 2002 at 8:46 pm
    Jun 30, 2002 at 2:51 pm
  • I'm looking at implementing IS DISTINCT FROM, among other things. It has the unusual behavior that it compares elements for a tuple by considering two NULLs to be equal (hence non-distinct) rather ...
    Thomas LockhartThomas Lockhart
    Jun 23, 2002 at 1:59 am
    Jun 25, 2002 at 4:36 pm
  • Hi, I've a question about returning ADT values through embedded SQL. It's fine to retrieve values of PostgreSQL's build-in types in to C variables of roughly the same type, with only (possibly) a ...
    Tony Griffiths(RA)Tony Griffiths(RA)
    Jun 20, 2002 at 12:49 pm
    Jun 24, 2002 at 12:36 pm
  • As you probably know, SQL99 has dropped the rather useless categorizations of "basic", "intermediate", and "advanced" SQL compliance and instead lists a large number of labeled features. I've put ...
    Thomas LockhartThomas Lockhart
    Jun 14, 2002 at 3:13 pm
    Jun 19, 2002 at 3:11 pm
  • I am seeing massive regression failures on a freshly compiled, initdb'ed version of CVS: 16 of 81 tests failed, 1 of these failures ignored. The first failure I see is: COPY COPY_TBL FROM ...
    Bruce MomjianBruce Momjian
    Jun 17, 2002 at 7:04 am
    Jun 18, 2002 at 2:29 am
  • I am a student doing my graduation in India. I want to know what are the other OODBMS features ( other than inheritance ) available in PostGreSQL. It would be great if you can help me out with some ...
    NishkalaNishkala
    Jun 27, 2002 at 4:51 am
    Jun 29, 2002 at 1:15 am
  • I have been reviewing Rod Taylor's pg_depend patch, which among other things adds SQL-compliant DROP RESTRICT/CASCADE syntax and prevents you from dropping things that other things depend on, as in ...
    Tom LaneTom Lane
    Jun 26, 2002 at 3:54 pm
    Jun 27, 2002 at 3:46 am
  • Hi all! Recently I tried to use the new 7.02.0001 Win32 ODBC driver in the new (beta) Unicode mode in conjunction with MS Access 2000 and a "UNICODE" encoded database stored in a PostgreSQL 7.2.1 ...
    Julian Mehnle, Linksystem MuenchenJulian Mehnle, Linksystem Muenchen
    Jun 21, 2002 at 3:05 pm
    Jun 26, 2002 at 10:12 am
  • OK, I have finally decided that our archive searching stinks. I have emails in my mailbox that don't appear in the archives. Our main site, http://archives.postgresql.org/ doesn't archive the ...
    Bruce MomjianBruce Momjian
    Jun 21, 2002 at 1:18 am
    Jun 24, 2002 at 7:09 pm
  • Hi, I've mailed this previously to the novice list, but got no response, so hopefully this is more the appropriate place. I'm trying to invoke the DirectFunctionCall1function as follows: BOX* __tmp; ...
    Tony Griffiths(RA)Tony Griffiths(RA)
    Jun 19, 2002 at 9:44 am
    Jun 19, 2002 at 2:58 pm
  • Hello PostgreSQL developers and Admins of news.postgresql.org, recently I located messages of this PostgreSQL groups on groups.google.com. However, after asking the local newsserver admin of my ...
    Guido OstkampGuido Ostkamp
    Jun 27, 2002 at 7:20 pm
    Jul 1, 2002 at 3:44 am
  • The cvs docs say that we support the 'WITH CHECK OPTION' on views, but the TODO says we don't... Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 27, 2002 at 9:43 am
    Jun 29, 2002 at 4:18 am
  • I find myself repeatedly arguing for partial solutions, and having to struggle with other developers who feel these solutions are hacks. Let me explain why I like these hacks. When we have a feature ...
    Bruce MomjianBruce Momjian
    Jun 26, 2002 at 7:12 pm
    Jun 27, 2002 at 2:37 pm
  • Bruce, the attached source reproduces this on 7.2, I don't have a later version at hand to test if it's been fixed: createdb floattest echo "CREATE TABLE tab1(col1 FLOAT);" | psql floattest ecpg ...
    Lee KindnessLee Kindness
    Jun 11, 2002 at 10:52 am
    Jun 12, 2002 at 4:40 pm
  • Hi, I'm trying to start to program with the PostgreSQL's geometric primitive types, and have started to write some code using them (PostgreSQL version 7.1.3, installed from source). However when I ...
    Tony GriffithsTony Griffiths
    Jun 7, 2002 at 10:07 am
    Jun 10, 2002 at 3:17 pm
  • Catching up on an old mailbox, Bruce? :-) Exactly. What IBM was saying was was that we were "catching" SIGKILL and I could not convince the (supposedly technical) IBMers that they were talking out ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Jun 6, 2002 at 10:35 am
    Jun 8, 2002 at 2:57 am
  • Sorry to nag about this so late, but I fear that the new command SET LOCAL will cause some confusion later on. SQL uses LOCAL to mean the local node in a distributed system (SET LOCAL TRANSACTION ...
    Peter EisentrautPeter Eisentraut
    Jun 24, 2002 at 12:27 pm
    Aug 27, 2002 at 4:10 am
  • Marc, did you do anything to the format of the individual archive message pages? The top index pages look great, but when I go to, say, http://archives.postgresql.org/pgsql-hackers/2002-05/index.php ...
    Tom LaneTom Lane
    Jun 27, 2002 at 2:38 pm
    Jun 28, 2002 at 5:34 pm
  • Folks, Given the amount of qoute nesting we do in Postgres, I thought that we need a function that handles automatic doubling of quotes within strings. I've written one in PL/pgSQL (below). I'd ...
    Josh BerkusJosh Berkus
    Jun 17, 2002 at 8:36 pm
    Jun 25, 2002 at 4:07 am
  • I know nothing of Oracle's use of PERFORM either. Indeed I have looked in 4 Oracle books 'Oracle 8i The Complete Reference', 'Oracle8i DBA Bible', 'Oracle PL/SQL Language Pocket Reference' and one on ...
    Nigel J. AndrewsNigel J. Andrews
    Jun 15, 2002 at 3:32 pm
    Jun 25, 2002 at 12:11 am
  • With the pg_depend / pg_constraint implementation foreign keys are applied to dumps via alter table / add foreign key (retains inter table dependencies). Some have expressed that this could be quite ...
    Rod TaylorRod Taylor
    Jun 22, 2002 at 4:11 pm
    Jun 24, 2002 at 4:09 pm
  • Hi, We are moving to Postgres from Oracle. We have a few tables that have around 8 to 10 millions of rows and their size increases very rapidly(deletions are very less on these tables). How will ...
    Yuva ChandoluYuva Chandolu
    Jun 10, 2002 at 10:15 pm
    Jun 11, 2002 at 4:24 pm
  • Hi, there's (at least) one point I do not understand in bufpage.h. Could one of the "older" hackers explain it to me, please. Is od_pagesize in any way more or less opaque than pd_lower, pd_upper, ...
    Manfred KoizarManfred Koizar
    Jun 20, 2002 at 3:48 pm
    Jul 2, 2002 at 6:19 am
  • Fernando Nasser of Red Hat reminded me that it really makes no sense for ALTER TABLE ADD COLUMN and ALTER TABLE RENAME COLUMN to behave non-recursively --- that is, they should *always* affect ...
    Tom LaneTom Lane
    Jun 24, 2002 at 10:11 pm
    Jun 25, 2002 at 6:57 am
  • ignore this one ...
    Marc G. FournierMarc G. Fournier
    Jun 22, 2002 at 3:03 am
    Jun 22, 2002 at 4:25 am
  • Hi I need to do some testing of pgAdmin on a database with very large oids ( 4,000,000,000). Is there anyway I can wind the oid counter forward without having to do a few billion inserts? I'm on a ...
    Dave PageDave Page
    Jun 17, 2002 at 11:57 am
    Jun 17, 2002 at 7:05 pm
  • I noticed that gram.y doesn't handle with optional WITH in CREATE USER, ALTER USER, CREATE GROUP very well. It duplicates the actions, rather than creating an optional WITH clause. I have fixed this, ...
    Bruce MomjianBruce Momjian
    Jun 17, 2002 at 5:41 am
    Jun 17, 2002 at 6:05 pm
  • Question: How feasible would it be to create this functionality in PostgreSQL: One creates a test version of a database that initially consists of read-links to the production version of the same ...
    Matthew TedderMatthew Tedder
    Jun 14, 2002 at 6:25 pm
    Jun 16, 2002 at 10:22 pm
Group Navigation
period‹ prev | Jun 2002 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions140
posts1,024
users136
websitepostgresql.org...
irc#postgresql

136 users for June 2002

Bruce Momjian: 192 posts Tom Lane: 142 posts Marc G. Fournier: 46 posts Thomas Lockhart: 43 posts Christopher Kings-Lynne: 33 posts Josh Berkus: 33 posts Dann Corbit: 30 posts Peter Eisentraut: 27 posts Rod Taylor: 26 posts Curt Sampson: 24 posts Dave Page: 24 posts Hannu Krosing: 24 posts Michael Meskes: 24 posts Jan Wieck: 15 posts Karel Zak: 12 posts Larry Rosenman: 12 posts Neil Conway: 11 posts David Ford: 10 posts J. R. Nield: 10 posts Hiroshi Inoue: 9 posts
show more
Archives