FAQ

PostgreSQL > pgsql-novice > October 2005

Search Discussions

86 discussions - 253 posts

  • hi all, during the 8.0.4 installation of pgsql, you are asked for two passwords. 1. the account password 2. the db user password (as you know, postgres is the db user name) i understand the latter ...
    Operationsengineer1Operationsengineer1
    Oct 22, 2005 at 7:34 pm
    Nov 4, 2005 at 3:14 am
  • Q1 Is there another way to create the first DB after a fresh install? I used the createdb executable. I read that this is a wrapper for executing create database sql command. If I don't want to use ...
    Williams, RodgerWilliams, Rodger
    Oct 25, 2005 at 12:52 pm
    Oct 26, 2005 at 3:37 pm
  • Hi all, I'm writing a property rental web application, and one of the metrics I wish to track is the number of page views per month for each property. I originally envisaged a table with a column for ...
    Neil SaundersNeil Saunders
    Oct 21, 2005 at 3:47 pm
    Oct 27, 2005 at 1:01 pm
  • Postgresql 7.4.5 On RedHat 8 Is there a way to see what is happening with a process? We have a 4gl module that maintains our database (ie creates the tables, adds columns etc) - the problem (?) is ...
    Steve TucknottSteve Tucknott
    Oct 6, 2005 at 11:20 am
    Dec 15, 2005 at 11:02 am
  • Hi, I have a small table (100 rows) and I update its values every 8 seconds. This leads to poor performance until I vacuum. pg8.0 on w2000. Any suggestions on how often to vacuum or would I be better ...
    KadilKadil
    Oct 26, 2005 at 11:12 am
    Oct 28, 2005 at 7:50 am
  • This may come across as an odd question, but here goes.. To see the current query in PostgreSQL, the normal procedure is to type: SELECT current_query FROM pg_stat_activity; Now here's my question.. ...
    Rieback MelanieRieback Melanie
    Oct 21, 2005 at 10:28 pm
    Oct 25, 2005 at 1:26 am
  • This may come across as a rather odd question. However, is there a way to force PostgreSQL to return rows in a very specific order? I am currently facing running one three-way-join query which will ...
    Martin FosterMartin Foster
    Oct 12, 2005 at 12:56 am
    Oct 12, 2005 at 2:38 am
  • I am sorry, I know that this is an SQL problem ... . I need reach different rows in 2 almost same tables. I need use it in PL/pgSQL. Thanks for your advidce.
    Jaromír KamlerJaromír Kamler
    Oct 4, 2005 at 9:06 pm
    Oct 10, 2005 at 2:32 am
  • I'll admit straight away I'm a novice, but this one has me perplexed.... I have a table, T1, with a column (userid) that is an int4 generated from a sequence. I have a second table (T2) that I wish ...
    Steve SouthSteve South
    Oct 7, 2005 at 12:59 pm
    Oct 7, 2005 at 3:48 pm
  • unsubscribe
    Andres LedesmaAndres Ledesma
    Oct 25, 2005 at 5:19 am
    Nov 18, 2005 at 10:41 am
  • Hi, I need to have default privileges like "GRANT SELECT ON ALL TABLES" for a particular user. Looking at the docs & mailing list archives there's no easy way to do this. I seem to have to run a ...
    AndrewAndrew
    Oct 3, 2005 at 4:50 pm
    Oct 25, 2005 at 3:24 am
  • hi all, i think i'm stuck with alton and ray's problem - i stopped my install just after creating a database service and approving the auto-generated file. i went to copy down the password and ...
    Operationsengineer1Operationsengineer1
    Oct 24, 2005 at 5:40 pm
    Oct 24, 2005 at 7:26 pm
  • Is there a way to tell in PL/PgSQL if the delete coming down the line is from a cascade delete? I have a trigger, which when called will throw an error because the row its trying to change is now ...
    Martin FosterMartin Foster
    Oct 17, 2005 at 4:27 pm
    Oct 17, 2005 at 7:37 pm
  • Hello, I had employed MySQL for a couple of former projects. But now have decided to switch to PostgreSQL...not that version 8 also works on that, ahem...other OS...which I'm stuck with at work. But ...
    Gan Uesli StarlingGan Uesli Starling
    Oct 16, 2005 at 9:17 pm
    Oct 17, 2005 at 1:04 pm
  • Hello, I am running v 8 on OS/2 (actually eComStation). I have a backup procedure in Rexx which tries to shut down the PGS Server. The statement I am executing is C:\PGSQL\BIN\PG_CTLEXE stop -m smart ...
    Aviar cmmsAviar cmms
    Oct 3, 2005 at 5:07 pm
    Oct 17, 2005 at 11:40 am
  • Hi folks, I've been searching archives and helpfiles, and I am still very confused. My problem: newly created users cannot connect to a database. Older users can connect. The scenario: run pqsl from ...
    Cath LawrenceCath Lawrence
    Oct 12, 2005 at 8:08 am
    Oct 13, 2005 at 1:31 am
  • I am currently receiving an error message each time I try to insert a row. The row contains several GUID values, and when I try to do the insert I get an error like 'Syntax error at or near 'a45'. ...
    Kevin CrenshawKevin Crenshaw
    Oct 27, 2005 at 2:41 pm
    Oct 31, 2005 at 6:11 pm
  • Hello, while my trigger is fired, I can access the variable "TG_RELNAME" to get the name of the table that is updated. How will I get the name of the shema this table is stored? Thank you, Christian
    Christian HofmannChristian Hofmann
    Oct 31, 2005 at 9:47 am
    Oct 31, 2005 at 3:24 pm
  • Is there currently any way to change variables in a running server?
    Ted RolleTed Rolle
    Oct 28, 2005 at 2:10 pm
    Oct 29, 2005 at 2:14 am
  • Hi all, Does anybody have any idea whether there is any Bit-map Index functionality in Postgres. Atleast is there methods to extend postgres with bit-map indexes. Also if anybody has any experience ...
    Mogin MohandasMogin Mohandas
    Oct 19, 2005 at 2:26 am
    Oct 25, 2005 at 3:25 am
  • I’m receiving the following error message when I try to log into pgsql via pgAdmin: FATAL: missing or erroneous pg_hba.conf file HINT: See server log for details I don't have access ot the server ...
    Operationsengineer1Operationsengineer1
    Oct 17, 2005 at 7:37 pm
    Oct 19, 2005 at 8:20 pm
  • Hi I need to create 1:N related tables . eg.: table A and a table B. - table B will have motorcicles - table A will have motorcicles owners If a owner is deleted from the table A i need to delete all ...
    Ângelo Marcos RigoÂngelo Marcos Rigo
    Oct 19, 2005 at 12:34 pm
    Oct 19, 2005 at 1:23 pm
  • select currval('library.items_itemid_seq') as NextItemID; ERROR: currval of sequence "items_itemid_seq" is not yet defined in this session Note that the nextval function works as expected select ...
    BluebottleBluebottle
    Oct 7, 2005 at 7:27 am
    Oct 7, 2005 at 6:06 pm
  • Set Privileges on All Tables (and/or Sequences) at Once Can this be done? or am i stuck doing this on each table and sequence whenever i create a new group? tia... Yahoo! Mail - PC Magazine Editors' ...
    Operationsengineer1Operationsengineer1
    Oct 7, 2005 at 5:20 pm
    Oct 7, 2005 at 5:43 pm
  • Dear all, I am a new user of postgresql and got a question of using index. I have a table with the folloing definition CREATE TABLE t_post ( post_id serial NOT NULL, ownerid int4, t_stamp int4, ...
    Jonathan TseJonathan Tse
    Oct 5, 2005 at 6:53 am
    Oct 7, 2005 at 3:23 am
  • Are there any examples of using postgis that I can use for research? My current problem is the use of the Contains function. Here's my statement: Select astext(wkb_geometry), name, state From usroads ...
    Frances CollierFrances Collier
    Oct 5, 2005 at 8:06 pm
    Oct 6, 2005 at 4:12 pm
  • When I type 'psql' in the cmd window, it brings up a screen that closes too fast to read. What can I do to fix this?
    Ted RolleTed Rolle
    Oct 26, 2005 at 3:19 pm
    Oct 26, 2005 at 7:39 pm
  • Hi all, This is my first post to this list so I hope I'm not overlooking anything obvious. I've been saving my databases using pg_dump, and loading them back in where necessary. Recently I upgraded ...
    Sue FittSue Fitt
    Oct 25, 2005 at 10:46 am
    Oct 25, 2005 at 7:43 pm
  • This is maybe a really newbie question, but, when I have an SQL function like that: $$ Insert into mytable (id, name) values ($1, $2); $$ What return value suppose to return?
    Cristian PrietoCristian Prieto
    Oct 19, 2005 at 6:27 pm
    Oct 20, 2005 at 7:35 am
  • How can I see the definition of a user defined function without dumping the database or the schema to a file? I've been looking for a way to do this for about three weeks now, off and on and it's ...
    Charley L. TiggsCharley L. Tiggs
    Oct 18, 2005 at 2:43 pm
    Oct 18, 2005 at 3:39 pm
  • Configuration: Postgres 8.0.3 Apache 2.0.52 PHP 4.3.9 ADOdb 4.65 I have a web solution that works extremely well. Yet, the following error appears in the logs a lot. At least one entry every 5 ...
    Charley L. TiggsCharley L. Tiggs
    Oct 10, 2005 at 3:37 pm
    Oct 10, 2005 at 5:02 pm
  • Dear All, I am trying to change the column type: alter table knoten_alt alter column knoten type varchar(100); I am gettin Error message: syntax error at or near "type" at character 44 Postgresql ...
    OlegOleg
    Oct 10, 2005 at 3:56 pm
    Oct 10, 2005 at 4:04 pm
  • Hello All, I tried to search for information on Stored Procedures but couldn't find anything specific on stored procedures. My aim is to show the difference between stored procedures and triggers. ...
    Prasad devPrasad dev
    Oct 10, 2005 at 12:10 pm
    Oct 10, 2005 at 1:19 pm
  • Hi, I´m trying to collect IP traffic in a Postgres database and created a table consisting of an index, a column for the source IP-address of the traffic and a column for the counter of the ...
    Emre BastuzEmre Bastuz
    Oct 5, 2005 at 8:36 pm
    Oct 6, 2005 at 2:29 am
  • [ i posted this originally to the pgsql-sql list, sorry for cross posting ] I have a large number of tables with a common naming convention mytable001, mytable002, mytable003 ... mytable00n I would ...
    SolarsailSolarsail
    Oct 4, 2005 at 7:18 pm
    Oct 4, 2005 at 8:29 pm
  • Hello, Id like to compare two arrays, and if any value is found in both, return true. Is this possible without needing a procedure to loop through one? For example, say categories is an array : ...
    A GilmoreA Gilmore
    Oct 3, 2005 at 4:07 am
    Oct 4, 2005 at 5:13 am
  • In searching the archives, I have found postings by people migrating from other databases, who have expressed a need to support the semantic of descending sort direction in a multi-column index, as ...
    Eric FaulhaberEric Faulhaber
    Oct 31, 2005 at 9:20 pm
    Oct 31, 2005 at 9:39 pm
  • Hi, Can someone explain where I've gone wrong? Given the table array_check: Cheers, David
    David OrmeDavid Orme
    Oct 28, 2005 at 1:33 pm
    Oct 28, 2005 at 3:46 pm
  • How may I reproduce the TCP/IP dump on page 7(pdf); 6(doc) of 'Postgresql Internals through Pictures'? I'm using Ethereal on a Windows XP box. TCP/IP Packet 17:05:22.715714 family.home.49165 ...
    Ted RolleTed Rolle
    Oct 27, 2005 at 3:00 pm
    Oct 27, 2005 at 3:22 pm
  • Is there any possibility to see which useres are connected to the database at the moment? thanks in advance ---- R.Hnat
    Reinhard HnatReinhard Hnat
    Oct 27, 2005 at 5:58 am
    Oct 27, 2005 at 6:05 am
  • Is 'PostgreSQL Internals through Pictures' current? Or is it so high-level that it is always 'current'? I don't want to spend a lot of time on something that's out-of-date.
    Ted RolleTed Rolle
    Oct 26, 2005 at 11:09 pm
    Oct 27, 2005 at 2:59 am
  • Which net is #pgsql on? I tried irc.freenode.net <http://irc.freenode.net , but no dice.
    Ted RolleTed Rolle
    Oct 26, 2005 at 3:45 pm
    Oct 26, 2005 at 4:17 pm
  • I am under the impression that I just installed the latest and greatest PostgreSQL 8.1 Beta but when I execute psql -V it reports 7.3.4. Does the front end have a different rev? How do I interrogate ...
    Craig GriffithCraig Griffith
    Oct 25, 2005 at 10:16 pm
    Oct 25, 2005 at 10:31 pm
  • After downloading the windows beta version postgresql-8.1-beta versions and applying WinZip the following two files show up. postgresql-8.1-betaX-int.msi and postgresql-8.1-betaX.msi What is the ...
    T. LackeyT. Lackey
    Oct 25, 2005 at 1:45 pm
    Oct 25, 2005 at 2:00 pm
  • Hi All, I'm trying ot install postgresql 8.0.4 on suse 9.0. I can run ./configure but when I try to run make, the program cannot find a usable c compiler. I tried ./configure ...
    Phil campaignePhil campaigne
    Oct 24, 2005 at 11:51 pm
    Oct 25, 2005 at 3:33 am
  • Hello, I have a main table (t1), with several other tables referencing the ID of t1. When I update a row on t1 Id like to remove any rows that reference it in the other tables. The typical way of ...
    A GilmoreA Gilmore
    Oct 24, 2005 at 5:30 pm
    Oct 24, 2005 at 7:10 pm
  • In a WHERE clause, I want to to compare strings ignoring the spaces inside them. Is there a function to do that? I do not find it in the documentation. SELECT (...) WHERE ...
    Pierre CoudercPierre Couderc
    Oct 24, 2005 at 1:24 pm
    Oct 24, 2005 at 1:47 pm
  • Hi, I am trying to verify the return size that MD5 function returns. I dont see any details mentioned about this in the docs. Basically i am planning on storing passwords as md5(password) and want to ...
    TruthhurtsTruthhurts
    Oct 22, 2005 at 11:40 pm
    Oct 23, 2005 at 1:47 am
  • hi all, i followed this winxp install tutorial and it is the best one i found for pgsql newbies. http://viu.eng.rpi.edu/lab/1/s1_1.html due to the lack of documentation, i would recommend that ...
    Operationsengineer1Operationsengineer1
    Oct 22, 2005 at 7:25 pm
    Oct 22, 2005 at 10:13 pm
  • Howdy, I have two tables, thus (sans non-relevent cols).... -- Associate to a computer in the 'computers' table. CREATE TABLE softwares ( id SERIAL PRIMARY KEY, -- more cols after ); CREATE TABLE ...
    Gan Uesli StarlingGan Uesli Starling
    Oct 20, 2005 at 8:00 pm
    Oct 21, 2005 at 6:48 am
Oct 2005
12
Group Navigation
period‹ prev | Oct 2005 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions86
posts253
users97
websitepostgresql.org
irc#postgresql

97 users for October 2005

Operationsengineer1: 27 posts Tom Lane: 18 posts Michael Fuhr: 17 posts Martin Foster: 8 posts Oliver Elphick: 8 posts Kevin Crenshaw: 7 posts Michael Glaesemann: 6 posts Ted Rolle: 6 posts Andreas Kretschmer: 5 posts Daniel T. Staal: 5 posts A Gilmore: 4 posts Andreas Kretschmer: 4 posts Bruno Wolff III: 4 posts Jaromír Kamler: 4 posts Sean Davis: 4 posts Me: 3 posts Bruce Momjian: 3 posts Cath Lawrence: 3 posts Derrick Betts: 3 posts Gan Uesli Starling: 3 posts
show more
Archives