FAQ

Search Discussions

111 discussions - 278 posts

  • Hi, I am getting a PQExec error when I run this query. delete from a where age('now
    AnandAnand
    Oct 6, 1998 at 12:45 am
    Oct 29, 1998 at 1:56 pm
  • Dear All, Is there a way to make postgreSQL 'show' nulls rather than have them appear as blank fields? e.g. create table test ( code int2 primary key, name text ); insert into test (code,name) values ...
    Stuart RisonStuart Rison
    Oct 9, 1998 at 9:56 am
    Oct 13, 1998 at 3:30 pm
  • Copied to PostgreSQL lists, in the hope of comments from the experts... Martin Schulze wrote: It depends what you are doing: every update or insert is a separate transaction, unless you declare ...
    Oliver ElphickOliver Elphick
    Oct 2, 1998 at 7:21 am
    Oct 4, 1998 at 6:46 pm
  • Hello all, I am currently starting up a pilot project to demonstrate the power of the linux/postgres/php trio in an enterprise setting. I would like to be able to output graphs from data stored in a ...
    Lincoln SpiteriLincoln Spiteri
    Oct 28, 1998 at 11:31 am
    Oct 30, 1998 at 9:49 pm
  • Is there any chance of the 8k tuple limit going away in future releases of PostgreSQL? I was working on setting up a listserv archive with fields such as sentfrom, date, subject, and body, but the ...
    Dan DelaneyDan Delaney
    Oct 27, 1998 at 7:06 pm
    Oct 28, 1998 at 5:24 pm
  • Hi all. I'd like to set up a DB using postgreSQL to archive a mailing list. How would I go about getting all of the mail sent to the list to be automatically entered into the database when it is ...
    Dan DelaneyDan Delaney
    Oct 26, 1998 at 3:53 pm
    Oct 28, 1998 at 12:30 pm
  • Dear All, I'm currently doing some database design work and find myself entering loads of test records into my database tables. Occasionally I want to 'flush' out the database (i.e. keep all tables, ...
    Stuart RisonStuart Rison
    Oct 8, 1998 at 3:02 pm
    Oct 13, 1998 at 2:31 pm
  • Hi -- I've been dabbling in PostgreSQL on and off for a few months now. At this point I can get it to do a number of neat things, but I've run into one that is a stumper. I'm looking for a way that ...
    Valerie MatesValerie Mates
    Oct 14, 1998 at 3:57 pm
    Oct 15, 1998 at 3:30 am
  • Well, I investigated the problem and found out, that in fact, the table is 'created', because the file representing the table called /usr/local/pgsql/data/base/szoli1/perftest EXISTS, but can't reach ...
    MemphistoMemphisto
    Oct 8, 1998 at 2:11 pm
    Oct 12, 1998 at 4:48 pm
  • Hi all, I was just wondering if the IPv6 datatype has allready been implemented on the current version of postgres. Thanks, Lorenzo Huerta
    Lorenzo HuertaLorenzo Huerta
    Oct 5, 1998 at 9:07 pm
    Oct 7, 1998 at 6:48 am
  • I have two tables, structured as: users: id varchar(70) not null unique events: userid varchar(70) not null, code char(10) not null, when datetime not null The query I need to perform answers the ...
    Christophe PettusChristophe Pettus
    Oct 30, 1998 at 7:51 pm
    Nov 1, 1998 at 10:12 am
  • By the way, I was thinking, and my WHERE clause may not catch datetimes which are on Aug 31, 1998, in the middle of the day. Better use: WHERE the_date = '1998-08-01' AND the_date < '1998-09-01'; ...
    Herouth MaozHerouth Maoz
    Oct 21, 1998 at 2:05 pm
    Oct 21, 1998 at 5:00 pm
  • I'm having a problem with an index on a Postgres database. I created an index as follows: create index table1_column1 on table1 using hash (column1); (column1 is a varchar(70)) I discovered that I ...
    Christophe PettusChristophe Pettus
    Oct 15, 1998 at 9:00 pm
    Oct 16, 1998 at 12:52 pm
  • -----Original Message----- From: Andrea Antibo <antibo@mclink.it To: <pgsql-general@postgreSQL.org ; <pgsql-novice@postgreSQL.org Date: Monday, October 05, 1998 14:25 Subject: [GENERAL] make[2]: *** ...
    James OdenJames Oden
    Oct 6, 1998 at 11:34 am
    Oct 15, 1998 at 7:39 am
  • Hi, I want to display serial numbers of rows selected by a query. I can do this in Oracle by selecting a special attribute called 'rownum' (or 'rowno'). Can I do this in Postgres too? If not then is ...
    Anand SureliaAnand Surelia
    Oct 7, 1998 at 5:57 pm
    Oct 8, 1998 at 9:58 pm
  • I've three tables: groups(name text); -- This one contains name of usergroups users (username text, groupid oid); -- This one contains name users, -- groupid is a foreign key to "groups" table's oid. ...
    MemphistoMemphisto
    Oct 30, 1998 at 3:30 pm
    Nov 3, 1998 at 10:12 am
  • Hi all got another question this morning, In postgres when you create a view can you give that view a specific range of your table to be displayed and thats it, i assume giving a specified number of ...
    Lorenzo HuertaLorenzo Huerta
    Oct 29, 1998 at 3:37 pm
    Oct 30, 1998 at 8:34 am
  • I posted the questions below a few days ago to the SQL list, but apparently there is nobody there who can help -- maybe I'm luckier in this list? :-) ...
    Ulf MehligUlf Mehlig
    Oct 21, 1998 at 6:23 am
    Oct 22, 1998 at 5:32 pm
  • Hello, I have following program: ----------------------- CUT ------------------------ import java.net.URL; import java.sql.*; .... String url = "jdbc:postgresql://localhost/store3"; //String url = ...
    Przemyslaw BakPrzemyslaw Bak
    Oct 20, 1998 at 3:25 pm
    Oct 22, 1998 at 5:35 am
  • I'm running 6.3.2 on RedHat 5.0. I have the following table: Table = employees +---------------------+----------------------------------+-------+ ...
    Charles CurleyCharles Curley
    Oct 6, 1998 at 7:09 pm
    Oct 7, 1998 at 11:25 am
  • Is the version of postgres that handles INET addresses allready in the downloadable dir or is it in the CVS tree still. lorenzo
    Lorenzo HuertaLorenzo Huerta
    Oct 29, 1998 at 3:39 pm
    Oct 30, 1998 at 2:30 am
  • I am planning a new release to PgAccess (mainly bug fixes) and I'm wondering if "constraint" and "check" are working ! I am using PostgreSQL 6.3.2 and this example from man create_table is not ...
    Constantin TeodorescuConstantin Teodorescu
    Oct 28, 1998 at 6:49 pm
    Oct 29, 1998 at 10:36 am
  • I'm on a SunOS 5.6 trying to compile postgres 6.3.2 with no root access and the command line of: ./configure --prefix=/my_path/pgsql --with-template=sparc_solaris-gcc Any idea why I'm getting the ...
    Andy LewisAndy Lewis
    Oct 28, 1998 at 10:54 pm
    Oct 29, 1998 at 5:32 am
  • Hi, I have this 3 table: esame= \d prestito Table = prestito +----------------------------------+----------------------------------+-------+ ...
    ZioBuddaZioBudda
    Oct 23, 1998 at 12:25 pm
    Oct 26, 1998 at 9:10 am
  • Hi, how can control in a "select" if a date is not null? I have this table: Table = prestito +----------------------------------+----------------------------------+-------+ Length| ...
    ZioBuddaZioBudda
    Oct 23, 1998 at 12:50 pm
    Oct 26, 1998 at 8:59 am
  • I have a datbase that look like this: vnr|cnr|enr| ip|dato ---+---+---+---------------+---------------------- 1| 1| 17|195.192.136.223|1998-10-14 02:30:18+02 2| 1| 1|195.192.136.164|1998-10-14 ...
    Henrik PedersenHenrik Pedersen
    Oct 21, 1998 at 7:18 pm
    Oct 22, 1998 at 9:28 am
  • The following may not be your problem at all, but it is a mystery I have encountered on my own: If one of the fields in your table is one of the datetime type fields, there is a certain value you can ...
    Carilda A. ThomasCarilda A. Thomas
    Oct 21, 1998 at 6:42 am
    Oct 21, 1998 at 1:14 pm
  • Hi All, I am using a sequence to automatically generate a transaction number in my database. I've set up the transaction number to have a default value from the sequence, so that I don't have to ...
    Anand SureliaAnand Surelia
    Oct 20, 1998 at 11:14 pm
    Oct 21, 1998 at 10:28 am
  • Hi! Let's start with a simple one: I created tables and fields in a pgsql database with mixed-case names. like: Teams, Pilots, Drivers, FullName etc. Then I linked a MS-Access database to the pgsql ...
    Juan Carlos Castro y CastroJuan Carlos Castro y Castro
    Oct 19, 1998 at 1:40 pm
    Oct 19, 1998 at 3:33 pm
  • Hi, I'm new to PostgreSQL and I've got the following questions: 1.What is wrong with the following PostgreSQL statement? CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values (new.i); ...
    Sze Yuen WongSze Yuen Wong
    Oct 15, 1998 at 5:12 pm
    Oct 16, 1998 at 12:23 pm
  • Hi there. As two people said I created now a sequence .... I have the following now: Database = jobforum +------------------+----------------------------------+----------+ ...
    Marc EggenbergerMarc Eggenberger
    Oct 6, 1998 at 9:29 am
    Oct 6, 1998 at 2:48 pm
  • Hi I'm using php3 as a web interface to a pgsql database. So far when i do the pg_Connect i always do it this way : pg_[p]Connect("localhost","5432","","","dbname"); This creates a tcp/ip connection. ...
    Mario FilipeMario Filipe
    Oct 1, 1998 at 9:14 am
    Oct 1, 1998 at 4:42 pm
  • I can't find a definitive answer as to whether Postgres has been ported to SCO OpenServer 3.2. The FAQ mentions that it has been "compiled and tested" on a number of platforms, and SCO is among them, ...
    Troy HansonTroy Hanson
    Oct 31, 1998 at 7:10 pm
    Oct 31, 1998 at 7:28 pm
  • You are right. Thanks. Perhaps originally I used a query that only used the annex_log table, but this app I'm writing is generating the queries and there's also a query that does the same job but FOR ...
    MemphistoMemphisto
    Oct 30, 1998 at 5:00 pm
    Oct 31, 1998 at 3:19 am
  • Hello, I would like to know if there is a way to access a postgress database through a CORBA environment. Any suggestions for a further reading on this topic would be appreciated. Thanks. ---
    Alvaro CastilloAlvaro Castillo
    Oct 22, 1998 at 4:03 am
    Oct 22, 1998 at 5:59 am
  • 2 questions. 1)Hi, I have this 2 tables: esame= select * from libro_autore\g id_libro|id_autore --------+--------- s1 | 5 n3 | 1 n2 | 2 n1 | 1 n1 | 4 and esame= select * from autore\g cognome|nome ...
    ZioBuddaZioBudda
    Oct 20, 1998 at 9:01 pm
    Oct 21, 1998 at 4:55 pm
  • Hi All, When you insert a row within a SPI procedure is the inserted tuple or its oid returned somewhere? There is a variable SPI_Tuptable which is set with the tuples returned from a select query. ...
    Anand SureliaAnand Surelia
    Oct 21, 1998 at 12:44 am
    Oct 21, 1998 at 2:21 am
  • Hello, I've wrote a programm which operates with big table. The speed is ok after executing vacuum, but in some hours it goes down. What should I do to improve speed? Should I VACUUM more frequently ...
    Sergei ChernevSergei Chernev
    Oct 17, 1998 at 7:22 am
    Oct 19, 1998 at 7:57 pm
  • Does anyone know when update locks at a granularity below the table level will be supported in postgresql? I'mm under the impression that an update requires an exclusive table lock. Thx, Jeff
    Jeff GerhartJeff Gerhart
    Oct 16, 1998 at 5:24 pm
    Oct 19, 1998 at 6:53 am
  • To upgrade from 6.3.1 to 6.3.2 can I simply do a dumpall and then reload the information back into psql to re-create? Or is it more complicated than that? I do not want any information to be lost. I ...
    BrianBrian
    Oct 5, 1998 at 11:59 pm
    Oct 16, 1998 at 12:20 pm
  • I am getting ready to write some PHP code that will involve the following: [1] make a connection to a Postgres DB via PHP/Apache [2] query a table for records. only get new records that we didn't get ...
    Andy LewisAndy Lewis
    Oct 15, 1998 at 7:22 pm
    Oct 15, 1998 at 8:45 pm
  • Hopefully I'm not being dense again ... I've got a CGI frontend that I'd like to give users the ability to type in regular expressions into forms and do queries based up this data. During testing ...
    Charles CurleyCharles Curley
    Oct 15, 1998 at 7:53 pm
    Oct 15, 1998 at 8:27 pm
  • subscribe pgsql-general
    MichelMichel
    Oct 3, 1998 at 12:29 pm
    Oct 13, 1998 at 5:15 pm
  • subscribe pgsql-general subscribe pgsql-general-digest
    ArtFile Pte LtdArtFile Pte Ltd
    Oct 9, 1998 at 2:51 am
    Oct 13, 1998 at 12:42 pm
  • Hi. I have a postgreSQL 6.3.2 and I want to delete an entry in a table. I tried a "ALTER TABLE DROP COLUMN" but it replies: "NOT YET IMPLEMENTED" hmmmm ... but it must be possible ... but how? -- mit ...
    Marc EggenbergerMarc Eggenberger
    Oct 9, 1998 at 8:24 am
    Oct 9, 1998 at 4:43 pm
  • Is there a reason why this occurs? table= explain select * from data where oid = 18522; NOTICE: QUERY PLAN: Seq Scan on data (cost=0.00 size=0 width=120) EXPLAIN I would have expected an index scan ...
    TaralTaral
    Oct 8, 1998 at 7:48 pm
    Oct 8, 1998 at 9:45 pm
  • Hello! I have a tabe : addates : (adid int 4,rundate date,posted boolean,dateid int4 unique create no. from sequence datesequence) table is like this adid rundate posted dateid 1031 05-17-1998 t 1856 ...
    AnilAnil
    Oct 7, 1998 at 2:29 am
    Oct 7, 1998 at 4:33 pm
  • Hi, I currently us miniSql and have had problems with performance on a large database. as an example I have a 30mg+ simple database each entry is date stamped. When I request 1 years worth of data it ...
    GG
    Oct 6, 1998 at 1:15 pm
    Oct 7, 1998 at 4:12 pm
  • Hi there. I'm making my first steps on postgreSQL on a Sun Solaris. With the current database I need a field that is automaticly incremented when data is added. I looked in the docs, and the ...
    Marc EggenbergerMarc Eggenberger
    Oct 6, 1998 at 8:17 am
    Oct 6, 1998 at 8:37 am
  • I have a database running fine, however, it is purely stock configuration. I would like to fine tune it for better performance and to control memory usage. I have seen people refer to restricting the ...
    Greg YoungbloodGreg Youngblood
    Oct 3, 1998 at 9:11 pm
    Oct 5, 1998 at 12:15 pm
Group Navigation
period‹ prev | Oct 1998 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions111
posts278
users120
websitepostgresql.org
irc#postgresql

120 users for October 1998

Jackson, DeJuan: 18 posts Bruce Momjian: 16 posts Herouth Maoz: 12 posts Taral: 11 posts Anand Surelia: 9 posts The Hermit Hacker: 9 posts Memphisto: 8 posts Ulf Mehlig: 8 posts Andrea Antibo: 5 posts Andy Lewis: 5 posts Doug Smith: 5 posts Dustin Sallings: 5 posts Mike Meyer: 5 posts Sferacarta Software: 5 posts ZioBudda: 5 posts Christophe Pettus: 4 posts James Olin Oden: 4 posts Michael A. Koerber SR: 4 posts Oliver Elphick: 4 posts Constantin Teodorescu: 3 posts
show more
Archives