FAQ

PostgreSQL > pgsql-novice > June 2005

Search Discussions

70 discussions - 224 posts

  • PostgreSQL-7.4.5 I don't know whether this is a 'bug' (it seems like designed behaviour) - but if you do: SELECT markUp.* FROM markUp AS mark JOIN clientBranch AS clntB ON mark.foreignRecNo = ...
    Steve TucknottSteve Tucknott
    Jun 30, 2005 at 6:53 am
    Jul 7, 2005 at 4:03 am
  • When I try to remove a database with phppgadmin, I get the following error, "ERROR: cannot drop the currently open database". Any insight would be appreciated. Sean
    Sean MontagueSean Montague
    Jun 1, 2005 at 7:08 pm
    Jun 6, 2005 at 1:19 pm
  • hi all, i've googled and searche dmy pgsql books and i can't quite get a confident grasp on cron jobs. as i understand it... the following should enable me to backup via cron: PGUSER=postgres ...
    Operationsengineer1Operationsengineer1
    Jun 6, 2005 at 5:07 pm
    Jun 9, 2005 at 9:57 am
  • hi all, id like to know where i could find some info on the advantages that postgresql has over mysql. thanks
    CimaCima
    Jun 30, 2005 at 6:06 am
    Jul 1, 2005 at 8:14 pm
  • hi all, I'm wondering if it is at all possible to do a mass insert into a table using only a single query? Something along the lines of: insert into mytable values (val1), (val2), (val3) rather than ...
    Oren MazorOren Mazor
    Jun 17, 2005 at 1:32 pm
    Jun 17, 2005 at 7:55 pm
  • Hello, I've got an Access database and I need to migrate the data from the Access database to a Postgresql database. Up to this moment, I've done the following: - Create a table in postgresql create ...
    Sara simoesSara simoes
    Jun 20, 2005 at 10:00 am
    Jul 21, 2005 at 4:17 pm
  • Hi all Postgresql users, I've been using MySQL for years and now I have decided to switch to Postgresql, because I needed more robust "enterprise" features like views and triggers. I work with VERY ...
    RabtRabt
    Jun 18, 2005 at 5:47 pm
    Jun 20, 2005 at 2:36 pm
  • Hi all, I need your help to determine the configuration of a server machine, and the PG DBMS. There will be not more than 25 concurrent users. They will use a business software that accesses tha ...
    Havasvölgyi OttóHavasvölgyi Ottó
    Jun 10, 2005 at 9:13 pm
    Jun 14, 2005 at 8:41 pm
  • I've searched the manual that came with PostgreSQL 8.0.1 (I have the one page html version and I used the browser find on page) and could not find anything on how to create tables and insert data ...
    Michael AvilaMichael Avila
    Jun 13, 2005 at 11:00 pm
    Jun 14, 2005 at 11:40 am
  • Are there any good resources on stored procedures? I'm not very familiar with them, so if with regards to php is important, then resources with regards to php it is then. Thanks. Sean
    SeanSean
    Jun 28, 2005 at 8:23 pm
    Jun 30, 2005 at 4:26 pm
  • I'm looking for help with a design issue. If I was working in Oracle I know how I'd handle this situation, but I'm not sure in postgres because of some differences in security. Our application only ...
    Walker, Jed SWalker, Jed S
    Jun 30, 2005 at 3:19 pm
    Jun 30, 2005 at 3:48 pm
  • How can I query the database to determine if a user has usage on a particular schema, and how can I query the database to find out all the schemas a user has usage on? Thanks in advance, Jed S. Walker
    Walker, Jed SWalker, Jed S
    Jun 29, 2005 at 2:58 pm
    Jun 29, 2005 at 4:09 pm
  • I have a small business I am helping with their Postgresql server. They may need to move one of two databases onto a seperate disk system. They don't want another physical server. Can I run two ...
    Steve PoeSteve Poe
    Jun 27, 2005 at 4:38 pm
    Jun 28, 2005 at 6:46 am
  • Hi, I'm using DBD::Pg 1.32 and postgresql 8.0.3. At first I posted to the DBD::Pg mailing list because I though the following might be a perl-specific issue. Now I'm not so sure. I have a query that ...
    Joshua N PritikinJoshua N Pritikin
    Jun 24, 2005 at 4:56 am
    Jun 26, 2005 at 11:37 am
  • Hi All, I am working on an application that has a search dialog. The dialog is automatically populated with all of the available fields. It gets the field names from the views that were used on the ...
    Keith WorthingtonKeith Worthington
    Jun 23, 2005 at 2:55 am
    Jun 23, 2005 at 1:45 pm
  • Hi, I have been trying to figure out why this simple query doesn't execute if no record exist ! CREATE OR REPLACE FUNCTION del_rest() RETURNS TRIGGER AS ' DECLARE t record; BEGIN SELECT * INTO t FROM ...
    Prasad devPrasad dev
    Jun 20, 2005 at 12:27 am
    Jun 23, 2005 at 1:38 am
  • Thanks Mr. Fuhr, I used the psql and it worked. The pgAdmin tool must have been having trouble with my schema qualified SQL code. The trigger and trigger function work properly now. Thanks again for ...
    Matt IskraMatt Iskra
    Jun 17, 2005 at 5:33 pm
    Jun 20, 2005 at 6:29 pm
  • Hi all! Reading from man psql I see that the \d used without a pattern argument is equivalent to \dtvs which will display all pga_* tables along with the 'pure' data tables. Is there a way to change ...
    Ennio-SrEnnio-Sr
    Jun 9, 2005 at 7:37 pm
    Jun 9, 2005 at 11:15 pm
  • Is there any way to have transactions work inside plpgsql procedures? So far none of my attempts have worked. It's kind of frustrating to have to wait days for results and especially so when the ...
    Celia McInnisCelia McInnis
    Jun 27, 2005 at 3:02 pm
    Jun 28, 2005 at 4:00 pm
  • Hi, I am really new to database administration, so forgive me if I overlook something obvious ; I want to import data from a csv file into an existing, non-empty table. My problem is the fact that I ...
    Mattes SarcanderMattes Sarcander
    Jun 27, 2005 at 2:30 pm
    Jun 27, 2005 at 4:04 pm
  • hi. is it possible to use flort values with a comma as decimal placeholder? i am trying to use copy to insert a table, the table contains a few columns with numerical values such as price, the vales ...
    Stig eriksonStig erikson
    Jun 12, 2005 at 10:16 am
    Jun 19, 2005 at 12:26 pm
  • Howdy y'all. I have been trying to get a trigger and trigger function working. I have looked at the docs, copied the examples, and I still cannot get this to work. So, now I try you guys/gals. My ...
    Matt IskraMatt Iskra
    Jun 16, 2005 at 10:57 pm
    Jun 17, 2005 at 1:54 pm
  • I am currently working on a project that may be used throughout the United States. I have created the project database in MySQL but have been looking at Postgres due to it being completely free. The ...
    Michael AvilaMichael Avila
    Jun 4, 2005 at 6:34 pm
    Jun 16, 2005 at 6:26 pm
  • Hello all, I am getting hit by errors in timestamp formatting on seemingly valid timestamps: 19990108040506. From the PG manual: <Valid input for the time stamp types consists of a concatenation of a ...
    Razvan Costea-BarlutiuRazvan Costea-Barlutiu
    Jun 8, 2005 at 4:28 pm
    Jun 8, 2005 at 5:04 pm
  • UNSUBSCRIB pgsql-novice
    PrashantPrashant
    Jun 23, 2005 at 6:22 am
    Jul 1, 2005 at 12:19 am
  • Hi all. I've already read the friendly manual but have not found any clue. I would like to do some calculation on the rows of a table every time it gets updated. I've decided to use: create table ...
    Vincenzo RomanoVincenzo Romano
    Jun 29, 2005 at 11:28 am
    Jun 29, 2005 at 8:57 pm
  • dear colleagues, how do you transfer postgres file to another computer having postgresql application. thanks ramon
    Ramon OrticioRamon Orticio
    Jun 29, 2005 at 8:17 am
    Jun 29, 2005 at 8:52 am
  • Hi all, I have a timestamp in a database that is beeing returned in pgAdmin as "2005-06-21 11:21:47", exactly as entered. When i retrieve the field via PQgetvalue i get 8 bytes worth of data that i ...
    Joe JoeJoe Joe
    Jun 21, 2005 at 1:28 pm
    Jun 28, 2005 at 6:14 am
  • I want to warn you all that you might hurt yourself by banging your head against the wall or damage your karma by using foul language if you find your postmaster rejecting to work after a minor ...
    AndreasAndreas
    Jun 27, 2005 at 4:35 pm
    Jun 28, 2005 at 5:40 am
  • What is the syntax for using a grouped 'function' result in a subquery? I am trying to group by the first part of the 'post code' and use that in the subquery - the code is: I tried using the pZone ...
    Steve TucknottSteve Tucknott
    Jun 23, 2005 at 3:47 pm
    Jun 23, 2005 at 5:18 pm
  • Hello List, I have 2 identical tables, table1 and table2 with 2 fields: id int and idname varchar(30). I am successful in retrieving the records in table1 not in table2 with: select id from table1 ...
    George McQuadeGeorge McQuade
    Jun 21, 2005 at 7:37 pm
    Jun 21, 2005 at 10:13 pm
  • I have a table with 7 columns and Im trying to pull a section(rows) of the table by using the date column(field), in a function. I want it to work like so; # Select Slice('03/01/2004', '03/05/2003'); ...
    EdEd
    Jun 20, 2005 at 12:40 am
    Jun 20, 2005 at 1:28 am
  • Hello, I am a decently proficient perl programmer of many years. I am recently taking up PostgreSQL in a project involving perl. In my perl script, I am parsing a multiline "|" delimited "report" and ...
    Mark J. BaileyMark J. Bailey
    Jun 17, 2005 at 2:06 pm
    Jun 19, 2005 at 12:35 pm
  • Thanks for the assistance Michael Fuhr and Dr. DeSoi. The recoded function is much more what I wanted to anyway - one generic function that could be used on multiple tables through their respective ...
    Matt IskraMatt Iskra
    Jun 17, 2005 at 4:38 pm
    Jun 17, 2005 at 5:40 pm
  • Hi, I'm using ADO to connect to my PostgreSQL instance. When I use a SELECT statement that references a non-existent column in an existing table I get a SQLSTATE error S1000 code with native error ...
    Babak AsadiBabak Asadi
    Jun 4, 2005 at 6:17 pm
    Jun 14, 2005 at 3:27 am
  • Hi all, Id like to to function with plperlu which write's db-events to log-file. My trigger looks like this: CREATE TRIGGER trapd BEFORE INSERT OR UPDATE ON events FOR EACH ROW EXECUTE PROCEDURE ...
    Ville LeinonenVille Leinonen
    Jun 13, 2005 at 11:09 am
    Jun 13, 2005 at 2:47 pm
  • I have two separate (postgres) databases each of which contain a set of tables with the same names. Now it turns out that one of the tables between these two databases can be shared. What's my best ...
    Celia McInnisCelia McInnis
    Jun 11, 2005 at 12:57 am
    Jun 11, 2005 at 2:37 am
  • This does not belong on the pgsql-bugs list. The pgsql-novice or pgsql-performance lists seem more appropiate. I have set followups to the pgsql-novice list. On Thu, Jun 02, 2005 at 12:05:00 +0100, ...
    Bruno Wolff IIIBruno Wolff III
    Jun 2, 2005 at 1:04 pm
    Jun 3, 2005 at 2:50 pm
  • When I run pg_ctl start I get back: ReadRecord: invalid resource manager id 159 at 5/2FEB854 along with a couple other "invalid" messages. Version 7.2.4 does not have a 'pg_resetxlog' so what do I do ...
    David NorrisDavid Norris
    Jun 1, 2005 at 2:19 pm
    Jun 1, 2005 at 7:15 pm
  • Hi, I am using the following code to connect to my database. <? $db = pg_connect("dbname=friends"); echo pg_dbname(); ? But there is nothing displayed on the screen when I try it on my browser. I use ...
    Vivek Sonny AbrahamVivek Sonny Abraham
    Jun 28, 2005 at 10:36 am
    Jun 28, 2005 at 11:04 am
  • Dear friends, I am trying to extend the postgis with some spatial functions, Somebody knows where I can locate the source code of the libpostgis.dll dll, which contains the definition of functions ...
    Joel da SilvaJoel da Silva
    Jun 27, 2005 at 8:08 pm
    Jun 27, 2005 at 8:41 pm
  • Hello, Inside my postgres database i want to store images of doors, windows etc together with a specification of how a building face looks like (so on which position is the door, etc). When i am ...
    Johan De KoningJohan De Koning
    Jun 24, 2005 at 11:03 am
    Jun 24, 2005 at 3:52 pm
  • Hi all, I want to localize the Postgresql database that we are using for our application. I am using PgSQL version 7.4.3 on a customised Linux platform. Now I want to know as to what changes should ...
    Pradeepkumar, Pyatalo (IE10)Pradeepkumar, Pyatalo (IE10)
    Jun 23, 2005 at 11:00 am
    Jun 23, 2005 at 9:18 pm
  • In plpgsql, how do I declare an array of "timestamp without time zone"? Thanks for your help. Celia McInnis
    Celia McInnisCelia McInnis
    Jun 22, 2005 at 8:32 pm
    Jun 22, 2005 at 9:28 pm
  • Kirti PankhaniaKirti Pankhania
    Jun 22, 2005 at 5:27 am
    Jun 22, 2005 at 5:42 am
  • Just did a LAPP install, FC4, A2.0.54, PSQL8.0.3, PHP5.0.4 and I'm using pgAdmin III on my WinXP desktop. Ported a database from a system running PostgreSQL 7.4.2 and after a few basic tweaks I'm ...
    Sigurður ReynissonSigurður Reynisson
    Jun 21, 2005 at 8:04 pm
    Jun 22, 2005 at 12:35 am
  • subscribe
    Vishal Kashyap @ [SaiHertz]Vishal Kashyap @ [SaiHertz]
    Jun 18, 2005 at 8:40 am
    Jun 20, 2005 at 3:53 pm
  • PrashantPrashant
    Jun 1, 2005 at 12:48 pm
    Jun 15, 2005 at 9:41 am
  • Say I have a table tbl1 with two columns: tbl1(a integer, b integer, c integer) I want to select the rows in which a and b are members of a list of integer pairs. The SQL in my mind is something ...
    Sophie YangSophie Yang
    Jun 14, 2005 at 7:08 pm
    Jun 14, 2005 at 7:21 pm
  • Hi, What's the difference between server/client binary data conversions [1] of these commands: i. "COPY ... TO ... WITH BINARY ..." ii. "DECLARE ... BINARY ..." iii. PQexecParams(..., 1) AFAIC, the ...
    Volkan YAZICIVolkan YAZICI
    Jun 13, 2005 at 7:37 am
    Jun 13, 2005 at 2:21 pm
Jun 2005
12
Group Navigation
period‹ prev | Jun 2005 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions70
posts224
users83
websitepostgresql.org
irc#postgresql

83 users for June 2005

Tom Lane: 26 posts Michael Fuhr: 17 posts Bruno Wolff III: 11 posts Operationsengineer1: 10 posts John DeSoi: 10 posts Andreas Kretschmer: 9 posts Celia McInnis: 7 posts Keith Worthington: 7 posts Volkan YAZICI: 6 posts Walker, Jed S: 6 posts Matt Iskra: 5 posts Michael Avila: 5 posts Steve Tucknott: 5 posts Daniel T. Staal: 4 posts Michael Glaesemann: 4 posts Sean Davis: 4 posts Alex: 3 posts Ennio-Sr: 3 posts Sean: 3 posts Aarni Ruuhimäki: 2 posts
show more
Archives