Search Discussions

51 discussions - 218 posts

  • Hi All I started using PostgreSQL\Postgis in January. Lately I have been reading on the internet many rumblings about PostgreSQL being slower than MySQL/SQLLite etc etc. Comparisons made were routine ...
    Mar 23, 2006 at 5:00 pm
    Apr 18, 2006 at 7:24 am
  • ESTERROR: relation with OID 75872 does not exist What does ESTERROR stand for? I'm seeing my log files fill up with these errors. Version: PostgreSQL 8.1.2 on sparc-sun-solaris2.8, compiled by ...
    Michael GuerinMichael Guerin
    Mar 14, 2006 at 9:04 pm
    Mar 16, 2006 at 9:59 pm
  • Hi, Suse 10.0 using the Free Pascal Compiler connection version 2.1.1. I have opened a connection to a database (FPC uses the postgres c interface). When I attempt to make two queries using the same ...
    Mar 27, 2006 at 7:29 pm
    Mar 30, 2006 at 3:09 pm
  • I get an "Invalid page header in block 23 of storetransaction_tbl" error on my table when running any kind of select. I do not get the error on other tables. I get the error from CGI apps as well as ...
    Christopher A. GoodfellowChristopher A. Goodfellow
    Mar 8, 2006 at 3:39 pm
    Mar 9, 2006 at 7:38 pm
  • Hi, I am trying to create a makefile for installing some C functions. When I include the following in the makefile: PGXS := $(shell pg_config --pgxs) include $(PGXS) I get the following error: $ make ...
    George WeaverGeorge Weaver
    Mar 2, 2006 at 3:12 pm
    Mar 3, 2006 at 11:29 pm
  • Hi to all in the mailing-list! I am new and I have problems with command line tools of PostgreSQL. I have 2 computers, one at home and one at office. Both computers are equipped with Windows 2000 ...
    Mar 23, 2006 at 11:34 am
    Apr 9, 2006 at 3:29 am
  • I have three problems that I need to solve that are closely related There are tasks: Task 1) Salesman access an application to submit information on a sales they made. This information includes data ...
    Nagita KarunaratneNagita Karunaratne
    Mar 5, 2006 at 9:24 pm
    Mar 6, 2006 at 11:17 pm
  • hallo, I use PostGIS ... . I have table: CREATE TABLE basic_metadata(name text,size text, ......); Inside I want insert some records (name of new table, size of new table and etc.), so I created ...
    Jaromír KamlerJaromír Kamler
    Mar 1, 2006 at 4:57 pm
    Mar 3, 2006 at 6:29 am
  • I would like to use a bytea column to store arbitrary files. I am trying to do this in perl and am wondering how to go about it. The docs for postgresql suggest some pretty elaborate quoting, etc. If ...
    Sean DavisSean Davis
    Mar 23, 2006 at 2:04 am
    Mar 29, 2006 at 2:38 am
  • Does anyone know of a good alternative in postgres to the MS access last function? TIA, Scott
    Scott FordScott Ford
    Mar 1, 2006 at 6:12 pm
    Mar 1, 2006 at 7:25 pm
  • I have both MySQL (5.0) and PostgreSQL (8.1) database servers on my PC. On MySQL I have a table (very simple, only 7 char fields) filled with about 35000 records. On PostgreSQL I have created the ...
    Mar 28, 2006 at 9:38 am
    Apr 10, 2006 at 10:34 pm
  • hi all, i noticed today that phpinfo() displays: PostgreSQL(libpq) Version 8.0.1 the strange thing is that i upgraded to 8.1. shouldn't it display 8.1 instead of 8.0.1? tia...
    Mar 29, 2006 at 3:18 am
    Mar 29, 2006 at 6:33 pm
  • Hello all, is it possible to have Pg automatically insert a Date or Time value on a record if the INSERT comand does not include one ? Something similar to AUTO INCREMENT for INTs ?!?! This way the ...
    Joao Miguel FerreiraJoao Miguel Ferreira
    Mar 13, 2006 at 11:27 am
    Mar 13, 2006 at 9:00 pm
  • I have a table that stores usernames and passwords and I want to encrypt the passwords before they are stored in the database. Will postgresql do this for me, or do I have to do the encryption on the ...
    Kevin CrenshawKevin Crenshaw
    Mar 9, 2006 at 1:22 pm
    Mar 9, 2006 at 7:13 pm
  • Hi, I'm trying to import a db from one server to my local machine. I have a mismatch betweek server pg_dump (8.0.3) and my machine pg_restore vesion (7.4.7). Reading the docs I found that -i option ...
    Marco RossiMarco Rossi
    Mar 2, 2006 at 11:52 pm
    Mar 3, 2006 at 8:50 pm
  • Hi, I am running PostrgreSQL 8.1 on Win X/P. I have written a function in C (my first) that performs a select followed by an update. The function compiles properly, installs properly and works as ...
    George WeaverGeorge Weaver
    Mar 30, 2006 at 3:22 pm
    Mar 30, 2006 at 6:04 pm
  • Ladies and Gentlemen, I'm using PostgreSQL 8.1 for a web application. 1. Is there a good comprehensive resource on plpgsql anywhere? I have "PostgreSQL, Second Edition" by Douglas and Douglas, but ...
    Michael SwierczekMichael Swierczek
    Mar 28, 2006 at 4:02 pm
    Mar 29, 2006 at 12:22 am
  • I have a "daughter" table that inherits from a "mother" table. The mother table has an index on column A. Would there be any point on creating an index on column A of the daughter? If so, in what ...
    Pierre ThibaudeauPierre Thibaudeau
    Mar 24, 2006 at 5:42 am
    Mar 24, 2006 at 7:26 pm
  • Hi Is there a way to update multiple tables with the same information? A kind of MS "find and replace all" utility. I want to change the drive letter of a filepath that is listed in one or more ...
    Chelsea bootChelsea boot
    Mar 16, 2006 at 8:46 pm
    Mar 17, 2006 at 1:31 pm
  • Is there a way to pass a relation (or view) as one of the arguments to a stored procedure? Consider the following pseudo-code: function foo ( table T, int X ) { int Y = ...
    Mar 9, 2006 at 6:37 pm
    Mar 10, 2006 at 6:07 pm
  • Hello, Am having some problems with accentuated content as é à ç è ... (frensh caracters) When inserting from psql command line or phppgadmin some accentuated caracters it works :( I have some php ...
    Zouari FouratZouari Fourat
    Mar 4, 2006 at 10:26 pm
    Mar 5, 2006 at 3:08 pm
  • I have a table (call it T1) made up of a join from two other tables and a few calculated columns. Currently, T1 gets refreshed by manually calling a function that does the select on the join and then ...
    Matt HelmMatt Helm
    Mar 2, 2006 at 5:57 pm
    Mar 2, 2006 at 10:43 pm
  • Hi All, When I originally built a database I did not understand the ramifications of choosing the encoding. Not knowing any better I chose SQL-ASCII. Since upgrading pgadmin3 to the latest release I ...
    Keith WorthingtonKeith Worthington
    Mar 28, 2006 at 3:04 pm
    Mar 29, 2006 at 8:43 pm
  • Hi I want to delete rows out of table1 that match a selection based on table2, tables joined on uniqueID. i.e. table1 Column | Type | Modifiers ----------+-----------------------+----------- est_id | ...
    Ann hedleyAnn hedley
    Mar 28, 2006 at 11:08 am
    Mar 29, 2006 at 4:30 pm
  • Thank very much for answers to my preceding question. I have obtained a plain CSV file from MySQL and I have loaded my PostgreSQL table with this file using the COPY command. I have another question. ...
    Mar 28, 2006 at 12:11 pm
    Mar 29, 2006 at 5:53 am
  • hi list currently in our database, a "person" contains a relation to one or more "events". i now need a view where each person is listed exactly once, and to each person only one (of possible more) ...
    Mar 24, 2006 at 6:36 pm
    Mar 26, 2006 at 3:13 am
  • Hi I have a car parking reservation table that stores 2 timestamps - entry_date and exit_date. There is a maximum number of car parking places, and I want to check that on each day between the 2 ...
    Jonathan DaviesJonathan Davies
    Mar 13, 2006 at 4:51 pm
    Mar 19, 2006 at 11:49 am
  • I need make multiple insertions in a new database under Postgresql 8.0 . I will be satisfy if I can make this operation in a once operation. I will be satisfied if I can make this operation in a once ...
    Mar 11, 2006 at 12:15 pm
    Mar 19, 2006 at 4:23 am
  • Hi, Can I get rid of the number extension at the end of my log file name? What I'd like to do is keep one log file that truncates after a certain amount of time or size, however postgres keeps ...
    Michael GuerinMichael Guerin
    Mar 18, 2006 at 2:43 pm
    Mar 18, 2006 at 3:49 pm
  • Hello! I am trying to use a cursor in Java to fetch multiple rows at once. The code seems to connect to the database okay, and seems to be fetching records, but then it fails with the error: ...
    Richard KutRichard Kut
    Mar 13, 2006 at 6:39 pm
    Mar 16, 2006 at 5:38 pm
  • Hi, Im about to make a small webapplication using Postgresql. My system is Debian 3.1 Sarge with Postgresql 8.1 from backports.org. What I want to do is have my superuser, which also have a system ...
    Mar 11, 2006 at 7:19 pm
    Mar 11, 2006 at 10:49 pm
  • Is there a function that will convert a numeric string to a number, returning zero if the string is empty? Here is the problem I'm trying to solve; I have a column of type VARCHAR(4) that usually, ...
    David GaudineDavid Gaudine
    Mar 9, 2006 at 9:13 pm
    Mar 10, 2006 at 6:50 am
  • Hi, I'm trying to write a function that would the results of select 'foo' . How do I escape strings within a create function block? Thanks, Shuying
    Shuying WangShuying Wang
    Mar 2, 2006 at 3:24 am
    Mar 2, 2006 at 4:25 am
  • Hi, Is it possible to drop and recreate an index on a column that's actually a primary key for a table in PostgreSQL 7.3 ? I couldn't figure that out from the documentation. --Shuying
    Shuying WangShuying Wang
    Mar 1, 2006 at 5:11 am
    Mar 1, 2006 at 6:33 am
  • Hi all, I have a quick question... In function definitions one can dereference the type of some relation's column using the %TYPE syntax. This is a very useful feature that helps prevent type ...
    Murat TasanMurat Tasan
    Mar 23, 2006 at 9:13 pm
    Mar 23, 2006 at 9:24 pm
  • Hey, What is the best way to stop the database. I use "killall -9 postmaster". Mogin
    Moginraj MohandasMoginraj Mohandas
    Mar 23, 2006 at 5:17 pm
    Mar 23, 2006 at 5:20 pm
  • I am using version 8.0.3 on Windows 2003. I would like to get a report out of PostgreSQL like the one below, EXCEPT that I would like to associate a table name with the indexes this query pulls from ...
    Lane Van IngenLane Van Ingen
    Mar 21, 2006 at 9:53 pm
    Mar 21, 2006 at 9:59 pm
  • Can anyone help please. Intermittently a postgres/postmaster process appears to crash on our server and the postmaster service needs restarting. The following is entered in the log: 2006-03-15 ...
    Chelsea bootChelsea boot
    Mar 16, 2006 at 8:33 pm
    Mar 17, 2006 at 8:49 pm
  • I am trying to add additional columns to an existing view. The ALTER statement doesn't appear to operate on views. Is there a way to alter the definition of a view without dropping and recreating it? ...
    Richard Broersma JrRichard Broersma Jr
    Mar 17, 2006 at 1:45 am
    Mar 17, 2006 at 5:40 am
  • Suppose I have a table "people" like this; Name Age David 25 Simon 19 and a table "occupations" like this: Name Occupation David Teacher Simon Student "Name", "Age", and "Occupation" are just the ...
    David GaudineDavid Gaudine
    Mar 15, 2006 at 10:13 pm
    Mar 16, 2006 at 1:52 am
  • I have read that the only solution for insertions multiple in Postgres is using copy , please could somebody explains to me if exist another posibility . Thanks Correo Yahoo! Espacio para todos tus ...
    Mar 11, 2006 at 1:06 pm
    Mar 11, 2006 at 1:16 pm
  • Hello all, I've had some experience in accessing a PostgreSQL database, running on Linux, from remote clients with Perl (DBI, DBD), also on Linux. Only Perl/Linux. But know I need to know if it is ...
    Joao Miguel FerreiraJoao Miguel Ferreira
    Mar 7, 2006 at 4:19 pm
    Mar 10, 2006 at 4:47 pm
  • Hello, I have different database installations. One is a postgresql 8.0 and one is a 8.1 installation. I want to move the database from postgres 8.1 to the postgres 8.0 installation. When i restore ...
    Sten govaertsSten govaerts
    Mar 10, 2006 at 9:25 am
    Mar 10, 2006 at 3:28 pm
  • Michal, I have no idea what is in the base directory. Perhaps some of the more experienced users on the list can enlighten us. What I meant about being specific was showing what it was that was slow ...
    Sean DavisSean Davis
    Mar 8, 2006 at 9:08 pm
    Mar 8, 2006 at 9:43 pm
  • We just got a minor burn from not having a full backup. (Relying on individual users to do backups of their data apparently does not work.) What is the preferred method for doing a full database ...
    Sean DavisSean Davis
    Mar 6, 2006 at 4:32 pm
    Mar 6, 2006 at 5:30 pm
  • hi, i'd like to write sth like: create rule MYRULE as on select to MYTABLE do instead dblink('dbname=ANOTHERDB',querystring); where querystring would be a special keyword, as new and old, but ...
    F GF G
    Mar 4, 2006 at 5:26 pm
    Mar 4, 2006 at 5:37 pm
  • Hello, I have three tables (very simplified): - people (~6 million records) - addresses (~7 million records) - contacts (~10 million records) I need to select all records from the people table and ...
    Bendik Rognlien JohansenBendik Rognlien Johansen
    Mar 1, 2006 at 4:16 pm
    Mar 1, 2006 at 4:32 pm
  • I am using PostgreSQL 8.0.3 on Windows 2003 currently, and we anticipate moving to 8.1.2 soon on both Windows 2003 and Red Hat Linux platforms. Two questions: (1) Does anyone know if there is any ...
    Lane Van IngenLane Van Ingen
    Mar 23, 2006 at 1:41 pm
    Mar 23, 2006 at 1:41 pm
  • The following represents a simplified version of my database setup: =============== BEGIN ================ create table A( id int not null, scale smallint, val smallint[] ); create view V as select ...
    S anwarS anwar
    Mar 16, 2006 at 7:41 pm
    Mar 16, 2006 at 7:41 pm
  • I'm now participating in a PG project.I need to modify some parts of the log buffer flushing function and the data buffer flushing function.I don't know where they are. Could you tell me where the ...
    Mar 12, 2006 at 7:32 am
    Mar 12, 2006 at 7:32 am
Group Navigation
period‹ prev | Mar 2006 | next ›
Group Overview
grouppgsql-novice @

74 users for March 2006

Michael Fuhr: 18 posts Tom Lane: 17 posts Sean Davis: 15 posts Operationsengineer1: 11 posts George Weaver: 9 posts Michael Guerin: 9 posts Guido Barosio: 7 posts Andrea: 6 posts Bruno Wolff III: 5 posts John DeSoi: 5 posts Crdandridge1: 4 posts Andreas Kretschmer: 4 posts Christoph Della Valle: 4 posts George young: 4 posts Nagita Karunaratne: 4 posts Chelsea boot: 3 posts Christopher A. Goodfellow: 3 posts Greg Sabino Mullane: 3 posts Jaromír Kamler: 3 posts Lane Van Ingen: 3 posts
show more