Search Discussions

45 discussions - 138 posts

  • hi-- is there a way to retrieve several tuples via a pl/pgsql stored function from ecpg code? i've tried using cursors 6 ways from Sunday and I'm having no luck. i've searched the documentation and ...
    Andrew JarchoAndrew Jarcho
    Apr 28, 2007 at 8:20 am
    May 2, 2007 at 1:09 am
  • Ladies and Gentlemen, This will be long, I apologize. I'm mostly looking for someone to tell me there's an obvious solution I'm missing. I have a table 'answer' with medical survey answers. ...
    Michael SwierczekMichael Swierczek
    Apr 25, 2007 at 2:37 pm
    Apr 26, 2007 at 12:15 pm
  • Hi I have a database called eventOrganizer and I am trying to do a backup. When I go pg_dump eventOrganizer; I get this: eventOrganizer=# pg_dump eventOrganizer; ERROR: syntax error at or near ...
    Apr 26, 2007 at 7:54 am
    Apr 26, 2007 at 10:48 pm
  • Hi, I am having problem importing data from a windows xp2 postgresql server to a linux one. On the windows server I did: pg_dumpall -U postgres dumpall.sql On the linux machine I did: tr -d '\r' < ...
    Francois DeliegeFrancois Deliege
    Apr 25, 2007 at 1:56 pm
    Apr 26, 2007 at 1:25 pm
  • Hi to all, I realy need help of you. My problem is $subj. I mean, for example. If user run command like: INSERT INTO public.foo (at1,at10) VALUES ('val1','val10') I would need to catch this (may be ...
    David FleglDavid Flegl
    Apr 24, 2007 at 7:01 am
    Apr 24, 2007 at 5:39 pm
  • Hello all, I have a function definition built with pgadmin3 that looks like this: CREATE FUNCTION "fnGenerateAuthTicket"(p_ticket_serial character varying, p_expire_hours integer, p_user_id integer, ...
    Joshua KramerJoshua Kramer
    Apr 7, 2007 at 4:43 am
    Apr 8, 2007 at 11:16 pm
  • HI, I am designing a reservation system booking system. I want to put as much logic into the database as possible so it is independent from the application. One of the constraints is that a room can ...
    hostel Natehostel Nate
    Apr 30, 2007 at 5:10 am
    Apr 30, 2007 at 8:11 am
  • I am accessing a database remotely and I can use the select instruction but nothing happens when I use insert or update. I can use those instructions directly on the computer running postgresql. I ...
    Apr 26, 2007 at 7:54 am
    Apr 27, 2007 at 12:26 am
  • I would like to know how long it will take until the effects of a transaction is visible from outside after a commit statement. Or in other words: I have the situation that i have to use data which ...
    Reinhard HnatReinhard Hnat
    Apr 26, 2007 at 10:29 am
    Apr 27, 2007 at 12:04 am
  • Hi I have been asked to produce a website for selling a very varied range of items, around 5000 in all. The client wants to be able to categorise items in a hierarchical tree, along the lines of ...
    Mark KellyMark Kelly
    Apr 4, 2007 at 9:51 pm
    Apr 4, 2007 at 10:54 pm
  • I couldn't find anything in the postgresql manual as how to view its content. SELECT does not seem to work. Thanks,
    Fei LiuFei Liu
    Apr 25, 2007 at 9:37 pm
    May 9, 2007 at 11:38 pm
  • Anyone know where I can find a good editor for postgreSQL with runtime environment? Hey, I'm new.
    Mark DeeringMark Deering
    Apr 28, 2007 at 3:34 am
    Apr 28, 2007 at 5:57 am
  • Hello, I have a "proposals" table which includes the columns "draft" (boolean) and "user_id" (integer foreign key into a "users" table). The former says whether the record is a draft proposal. The ...
    Apr 19, 2007 at 9:52 am
    Apr 20, 2007 at 5:19 pm
  • Hello all, I have a table called sessions, with session ids. Each session also has a last_access timestamp and some other data. Is is possible (using PL/pgSQL) to implement something along the line ...
    Jan DanielssonJan Danielsson
    Apr 5, 2007 at 12:49 am
    Apr 5, 2007 at 4:42 am
  • I remember with oracle there was a self numbering record id field which we often used to cross reference tables. Is there something like this with postgresql? Stephen Choularton 0413 545 182 02 9999 ...
    Apr 26, 2007 at 10:48 pm
    Apr 28, 2007 at 12:27 pm
  • Hello group, I need to design and develop a web reporting system to let users query/view syslog files on a unix host. For now, I am concentrating on the authentication file that has user logon ...
    Fei LiuFei Liu
    Apr 27, 2007 at 8:03 pm
    Apr 27, 2007 at 8:51 pm
  • Hi I am trying to find sql to get table and column names. I found these: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' This one works, but the column name one below ...
    Apr 26, 2007 at 7:54 am
    Apr 26, 2007 at 10:50 pm
  • Hello all, I have a table that stores different parts of phone numbers in different columns, namely <areacode for the first three digits, <exchangenumber for the next three digits, <last4digits for ...
    Apr 25, 2007 at 4:23 pm
    Apr 25, 2007 at 5:24 pm
  • hello. i need to clean up some tables: from several equal rows keep only one (like `sort -u`) aaa bbb - do not delete aaa bbb - delete aaa bbb - delete fenx -- Отправлено M2, революционной почтовой ...
    Apr 25, 2007 at 9:06 am
    Apr 25, 2007 at 1:53 pm
  • Hello- Is it possible to read and write directly to data (text) files using PL/pgSQL? Thanks! --greg
    Greg LindstromGreg Lindstrom
    Apr 24, 2007 at 5:41 pm
    Apr 24, 2007 at 6:56 pm
  • I come from a MS SQL Server background, but I am planning on using PostgreSQL to take over the world in my own way. What (if it exists) is the equivalent of a clustered index in SQLServer?
    Stephen CookStephen Cook
    Apr 21, 2007 at 7:21 am
    Apr 21, 2007 at 9:53 am
  • Hi, are there something like variables on the server-side that can be set by the client? e.g. I'd like to store the user-id who created or updated a record. I've allready got a trigger that sets a ...
    Apr 12, 2007 at 3:33 am
    Apr 12, 2007 at 5:56 pm
  • I keep a large number of separate development projects in a single database, each in its own schema. Whenever I wish to work on one of them in psql, after running psql <dbname I then have to type SET ...
    Apr 12, 2007 at 2:16 pm
    Apr 12, 2007 at 5:03 pm
  • Hi * I am using the postgresql-8.2.3, with a jdbc-8.2-504.... (the GeoNet webServer tool...) My question is : Is the <<PostGresDB server able to log the whole <<SELECT query? {made by a prepared ...
    Apr 11, 2007 at 7:40 am
    Apr 12, 2007 at 9:48 am
  • I would appreciate and thank in advance any help to understand the error message I receive when I try to run this function. The function is initially accepted with no errors of syntax. CREATE OR ...
    Oscar ChavarriaOscar Chavarria
    Apr 9, 2007 at 2:16 pm
    Apr 9, 2007 at 3:04 pm
  • Welcome to psql 8.1.8, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to ...
    James LongJames Long
    Apr 3, 2007 at 10:31 pm
    Apr 4, 2007 at 12:18 am
  • Hi Group, I just realized that partitioning is not available in 8.0. As far as I can see it's only 'set constraint_exclusion = on;' missing from 8.0 compared with 8.1. Is there a way to emulate ...
    Fei LiuFei Liu
    Apr 30, 2007 at 9:33 pm
    May 6, 2007 at 5:05 pm
  • Hello all, Okay, this is me back again regarding those two tables I needed to join again, <abc and <def . Once these tables are joined together the resulting table has two fields of interest, <n and ...
    Apr 27, 2007 at 4:10 pm
    May 6, 2007 at 4:09 pm
  • Hi list: I am using sqlquery to build a report in a chameleon (php/mapscript)-enabled online mapping application. Having little experience in PostgreSQL, I uploaded a shapefile (empchgfinal.shp) to ...
    Jessica FendosJessica Fendos
    Apr 29, 2007 at 6:28 am
    Apr 30, 2007 at 1:40 pm
  • G'morning all, My task is to take table <abc and join it with <def with <WHERE clause <WHERE abc.ghi = def.ghi . My immediate reaction is to write SQL statement: SELECT a.*, d.p INTO output_table ...
    Apr 27, 2007 at 3:19 pm
    Apr 27, 2007 at 7:54 pm
  • Does anyone have a suggestion for being able to store "dates" parsed from email headers that would handle a fairly international set of formats? Or do I need to do date-conversion prior to trying to ...
    Gary WarnerGary Warner
    Apr 25, 2007 at 3:50 pm
    Apr 25, 2007 at 4:26 pm
  • Hi!! I am using postgresql 7.3 and I have a table with one timestamp without zone field (date1), I want to select any row when "date1" is between inicial_date and final_date values, I'm using an Sql ...
    Ing. Sergio LimaIng. Sergio Lima
    Apr 25, 2007 at 5:53 am
    Apr 25, 2007 at 1:08 pm
  • does anybody know if there's a way to access pl/pgsql stored functions from ecpg? i haven't been able to find anything about it in the documentation or on the web. --andy
    Andrew JarchoAndrew Jarcho
    Apr 21, 2007 at 9:40 pm
    Apr 21, 2007 at 11:53 pm
  • Hi Community, I have a server with Linux Fedora Core 6 and PostgreSQL 8.2.3. The server has 4 G of RAM I want to configure 1.2 G de RAM only for PostgreSQL. Which could be a good setting? When I try ...
    Apr 21, 2007 at 8:06 pm
    Apr 21, 2007 at 11:13 pm
  • hi -- im using ecpg to issue commands to my postgresql db on my school's Solaris system. The commands that read from the db seem to function properly. Those that should write to the db run but have ...
    Andrew JarchoAndrew Jarcho
    Apr 21, 2007 at 5:17 am
    Apr 21, 2007 at 5:27 am
  • Hello. I'm trying to install PostgreSQL 8.1.4 in a XP SP2 machine and I get the following errors: 1.) "Failed to connect to the database. Procedural language files are installed, but are not ...
    Apr 12, 2007 at 7:26 am
    Apr 13, 2007 at 5:13 am
  • I would appreciate any suggestions that people could contribute to my dilema. I have a Debian/Postgres 7.1.2 server where root partition went bad but the database partition is fine. I've rebuilt an ...
    Aaron WoehlerAaron Woehler
    Apr 12, 2007 at 2:55 pm
    Apr 12, 2007 at 3:29 pm
  • I'm a relative newcomer to PostgreSQL. I read the page on its website that explained how to connect, and I tried to compile the following example program. I located a "libpq-fe.h" at ...
    Apr 12, 2007 at 4:22 am
    Apr 12, 2007 at 4:56 am
  • I installed, accepting the program selected password. I immediately realized that the generated password would be difficult to use so I clicked back and changed it. Upon running the program it became ...
    Bill SiasBill Sias
    Apr 30, 2007 at 10:37 pm
    Apr 30, 2007 at 10:37 pm
  • can i call stored functions created with pl/pgsql from ecpg code? if so, how? i've been struggling with this for a while, i'm getting nowhere, and would much appreciate any help. andy j
    Andrew JarchoAndrew Jarcho
    Apr 20, 2007 at 5:47 pm
    Apr 20, 2007 at 5:47 pm
  • Hi, I have to work on PostgreSQL for my project, which is to add some operators in the current PGSQL implementation. The problem is that I can not access the ftp://ftp.postgresql.org/. Is there any ...
    Tasneem MemonTasneem Memon
    Apr 20, 2007 at 1:20 pm
    Apr 20, 2007 at 1:20 pm
  • Could anyone recommend a template for doing simple queries from a Microsoft Visual C++ program to a PostGres database? Libraries needed? working "select boo from blah" example? Thanks for any help! ...
    Gary WarnerGary Warner
    Apr 19, 2007 at 6:28 pm
    Apr 19, 2007 at 6:28 pm
  • Hello All, I am trying to set up continues archiving of WAL files. I have some doubt about the archive command %p and %f parameter. I am havining all 5/6 WAL files in following directory. ...
    Ashish KaralkarAshish Karalkar
    Apr 17, 2007 at 7:04 am
    Apr 17, 2007 at 7:04 am
  • Are you sure? -- It should be: apt-get build-deps postgresql-8.2 dpkg-buildpackage -us -nc -rfakeroot Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- ...
    Michelle KonzackMichelle Konzack
    Apr 5, 2007 at 6:56 pm
    Apr 5, 2007 at 6:56 pm
  • Hi All, I'm trying to add a batch of records to a table in one go rather than make a call from the application for each record. To do this i'd like to pass in an array as a text eg. the param looks ...
    Peter SchonefeldPeter Schonefeld
    Apr 4, 2007 at 1:36 am
    Apr 4, 2007 at 1:36 am
Group Navigation
period‹ prev | Apr 2007 | next ›
Group Overview
grouppgsql-novice @

61 users for April 2007

Phillip Smith: 11 posts Tom Lane: 11 posts Andreas Kretschmer: 6 posts Richard Broersma Jr: 6 posts Andrew Jarcho: 5 posts Fei Liu: 5 posts Michael Swierczek: 5 posts Stephen`: 5 posts Kvnsmnsn: 4 posts Francois Deliege: 4 posts Michael Fuhr: 4 posts Sean Davis: 4 posts David Flegl: 3 posts hostel Nate: 3 posts Joshua Kramer: 3 posts Mark Kelly: 3 posts Psql-novice: 2 posts Alan Hodgson: 2 posts Andreas: 2 posts Andrej Ricnik-Bay: 2 posts
show more