FAQ

Search Discussions

114 discussions - 388 posts

  • i'm setting up a data entry entry form. once the data is entered in a pgsql, i want to have it redisplay the blank form with the text just entered displayed. I have it so it enters data. i'm having a ...
    Operationsengineer1Operationsengineer1
    Jan 31, 2005 at 7:15 pm
    Feb 9, 2005 at 5:38 pm
  • Hey, everyone: My first post here, so nice to meet y'all. I've recently started working with PostgreSQL (in fact, recently started working with SQL...) and although I'm getting off to a good start, ...
    Rodolfo J. PaizRodolfo J. Paiz
    Jan 25, 2005 at 1:39 am
    Jan 28, 2005 at 12:03 am
  • How do I give all database object to another user so that user can do everything he wants? ALTER DATABASE blabla OWNER TO another_user; does not give what I want because that another user still does ...
    AkbarAkbar
    Jan 20, 2005 at 3:11 am
    Feb 2, 2005 at 10:05 pm
  • Hi! I can't find (at least, not in my first 10 minutes of looking) a mailing list preferences page for this list. I don't like the fact that I must hit "reply-all" to get the mailing list, but I can ...
    Rodolfo J. PaizRodolfo J. Paiz
    Jan 26, 2005 at 5:19 pm
    Jan 27, 2005 at 4:15 pm
  • Hi! I have a query which needs to provide a monthly report. Thanks to the date_trunc() function someone mentioned in a thread earlier today, I got the query working properly. However, each month is ...
    Rodolfo J. PaizRodolfo J. Paiz
    Jan 25, 2005 at 1:42 am
    Jan 27, 2005 at 2:03 am
  • Hi, how can I copy a table (including sequences etc.) to a different schema? Kind regards, Andreas
    Andreas NeumannAndreas Neumann
    Jan 19, 2005 at 2:35 pm
    Feb 3, 2005 at 1:12 am
  • how do you compare postgresql to mysql or oracle 10i which has become an open source material? thank you for your expert opinion.
    Ramon OrticioRamon Orticio
    Jan 5, 2005 at 5:43 am
    Jan 25, 2005 at 7:19 pm
  • Hi All, We are chasing a few problems around and I thought it would be a good idea to move to the offical release prior to chaing our tails. The download, build and check all went well. However, when ...
    Keith WorthingtonKeith Worthington
    Jan 21, 2005 at 10:50 pm
    Jan 24, 2005 at 3:59 pm
  • Hi All, Is it possible to "generate" dynamic queries using pl/pgsql? I am trying to archive a set of tables: affiliate_event, affiliate_batch, affiliate_batch_details, affiliate_daily_batch, ...
    Sarlav kumarSarlav kumar
    Jan 18, 2005 at 6:34 pm
    Jan 21, 2005 at 11:13 pm
  • dear friends, may i know what is your recommended prgramming language that would create GUI and connects to postgresql. thanks for your advice. mon
    Ramon OrticioRamon Orticio
    Jan 25, 2005 at 2:03 am
    Jan 27, 2005 at 9:31 am
  • dear friends, i am intending to do is to have a database system where there is a server for storage of data and a multiuser application distributed over a network of computer. i would like to have a ...
    Ramon OrticioRamon Orticio
    Jan 25, 2005 at 5:10 am
    Jan 25, 2005 at 6:55 pm
  • Hi All, I have the following statements in my shell script: echo $PGPASSWORD | psql -U $USER -h $HOST -d $DBNAME -c "select * from affiliate_batch where tx_dt < ' "$DATE" ' order by id; " ...
    Sarlav kumarSarlav kumar
    Jan 14, 2005 at 6:36 pm
    Jan 14, 2005 at 8:32 pm
  • Hi All, I have finished a testing phase and I would like to create a production database. My thought is to use pg_dump to create a backup of the data dictionary, create a new database using ...
    Keith WorthingtonKeith Worthington
    Jan 4, 2005 at 2:12 am
    Jan 5, 2005 at 1:20 am
  • Hi, I have a WXP Professional machine. This one is my first contact with PostgreSQL, so before starting I would like to know which file should I download and install in my machine. Where could I find ...
    Jorge PérezJorge Pérez
    Jan 3, 2005 at 3:50 pm
    Jan 4, 2005 at 3:14 pm
  • Hi All, Our database just reset and now I'm getting Errors in the log and I would like to know if this is recoverable. Here's the segment of the log right before and after it reset. LOG: unexpected ...
    Michael GuerinMichael Guerin
    Jan 26, 2005 at 7:07 pm
    Jan 26, 2005 at 9:35 pm
  • Hi All, Is there an easy way to find out the list of tables that have a FK relation on a particular table? Say, if I have a 'customer' table, I would like to get the tables that depend on customer ...
    Sarlav kumarSarlav kumar
    Jan 12, 2005 at 6:56 pm
    Jan 12, 2005 at 9:23 pm
  • Hi! Looking for "best practices" here. I've just seen that psql can output a query to an HTML file. If I am creating a query within a web page, is it generally recommended to get HTML output from ...
    Rodolfo J. PaizRodolfo J. Paiz
    Jan 25, 2005 at 1:47 am
    Jan 25, 2005 at 2:44 am
  • A record type contians the 1st row form dynamic query result. From that row I want to select the 1st column. How do I do that? CREATE OR REPLACE FUNCTION dswz.save_query (TEXT) RETURNS BOOL AS ' ...
    Tjibbe RijpmaTjibbe Rijpma
    Jan 17, 2005 at 11:42 pm
    Jan 19, 2005 at 4:05 pm
  • Seems like I missed a peece of Doc somewhere. But in my tries to save and restore my databases schema using pg_dump I got major problems. Please give me a tip, what's the trick. Working all with ...
    Robert KöpferlRobert Köpferl
    Jan 11, 2005 at 11:15 am
    Jan 11, 2005 at 5:57 pm
  • Hi folks, The enclosed function returns a proper result only when the LOOP and its enclosed functionality is removed from the function. Notice near the return I have xml=xml||'</transaction '; That ...
    K AndersonK Anderson
    Jan 2, 2005 at 3:38 am
    Jan 2, 2005 at 11:47 pm
  • I am converting from another database, where the line below was defined as a 'datetime' datatype. Am trying to convert that data, and it is telling me that my default date is out of range, and that I ...
    Van Ingen, LaneVan Ingen, Lane
    Jan 31, 2005 at 6:38 pm
    Jan 31, 2005 at 7:14 pm
  • Hello, I am using postgres 7.3.4. I am trying to retrieve data from already existing database. I am using postgres, which is super user of my database in php.ini. But when I am trying to retrieve ...
    Inpreet SinghInpreet Singh
    Jan 25, 2005 at 6:23 am
    Jan 29, 2005 at 10:16 pm
  • Hello, I have been working on two errors that I continue to recieve. I am attempting to get DocMgr to work with Postgres and PHP4. I am able to access the test.php page and my apache page like ...
    Daniel BlavosDaniel Blavos
    Jan 20, 2005 at 12:41 am
    Jan 26, 2005 at 4:07 pm
  • Hi! I'm trying to fill a table which has a polygon-type column from another table with discrete numeric data. It contains circle descriptions by x,y,r components in seperate columns. There is a nice ...
    KlausKlaus
    Jan 21, 2005 at 7:33 pm
    Jan 25, 2005 at 5:53 pm
  • Hi All, I have timestamp information in a table. I want to extract the date portion for insertion into another table. I tried this DECLARE v_inventory_date DATE; BEGIN SELECT CAST(extract(year from ...
    Keith WorthingtonKeith Worthington
    Jan 24, 2005 at 11:43 pm
    Jan 25, 2005 at 4:05 am
  • Help! Your good name is at risk, I was hoping to evaluate this DB for future projects. I have downloaded and unzipped the version 8 file I get 2 .msi files from the zip one about 58K the other around ...
    Shaun McGuileShaun McGuile
    Jan 18, 2005 at 3:21 pm
    Jan 22, 2005 at 6:08 am
  • Hi All: I am thinking about using PostgreSql as the back end of Windows application. I plan to install postgreSql in silent mode as part of my application's setup program. I have couple of questions ...
    Karim MardhaniKarim Mardhani
    Jan 19, 2005 at 7:10 pm
    Jan 21, 2005 at 4:48 pm
  • Just a quick question--does it suffice to copy the pg_hba.conf from 7.4.3 to the data directory of 8.0.0 (assuming the users are created, in addition)? Thanks, Sean
    Sean DavisSean Davis
    Jan 20, 2005 at 1:36 pm
    Jan 21, 2005 at 12:59 pm
  • I visited the web site and downloaded version 8.0 rc5 for Windows. Didn't see anything telling me what to download, so I selected what I think I needed from the ftp site: /binary/win32: took ...
    Van Ingen, LaneVan Ingen, Lane
    Jan 20, 2005 at 8:28 pm
    Jan 20, 2005 at 9:07 pm
  • Ok. Just make sure: a) pg_dump all databases using pg_dump from version 7.4.x I have to use pg_dump and not pg_dumpall since I have to dump tables with OID order and large objects into binary ...
    Marcin GilMarcin Gil
    Jan 20, 2005 at 7:35 am
    Jan 20, 2005 at 3:31 pm
  • Hi I'm trying to insert values into a table with a perl script. I know the script works with another database but it doesn't work with eandreibase, can anyone tell me why? I don't get any error ...
    Ann hedleyAnn hedley
    Jan 20, 2005 at 10:21 am
    Jan 20, 2005 at 11:50 am
  • i changed the postgresql.conf file adding listen_address = '*' but it doesn't kick. also changd the pg_hba.conf file adding "host template1 postgres 192.168.0.0/24 md5" but to no avail. inasmuch as ...
    Ramon OrticioRamon Orticio
    Jan 18, 2005 at 2:16 am
    Jan 18, 2005 at 1:05 pm
  • Hi there, First of all i'm using the postgresql 8.0rc2 on windows I have a problem updating views and seem to be stuck. My front-end to postgresql is ms-access and i have the following code in my VBA ...
    AdminAdmin
    Jan 6, 2005 at 6:02 pm
    Jan 17, 2005 at 10:08 pm
  • Could somebody help me? I'm trying to change the name of my psql database. Does it exist any command to do this. Thanks a lot for your help, Sylvain Brohée Free University of Brussels
    Sylvain BrohéeSylvain Brohée
    Jan 17, 2005 at 10:59 am
    Jan 17, 2005 at 3:43 pm
  • i installed pgadmin3 in windows xp. do i still need to install postgresql8? thanks for any info. mon
    Ramon OrticioRamon Orticio
    Jan 14, 2005 at 5:13 am
    Jan 14, 2005 at 8:55 am
  • Hi, I have a simple, flat, empty database I'd like to use as a template for others. How can I copy this template to start developing a new database? Can it be done through phpPgAdmin? Thanks, ...
    Lawrence MoranLawrence Moran
    Jan 13, 2005 at 1:35 pm
    Jan 13, 2005 at 4:59 pm
  • I'm using postgres to return business names via a function. In the function I "xml-ify" the output by taking the name and wrap it with start/end tags, as in "<name name</name " (there's a lot more to ...
    Schuhmacher, BretSchuhmacher, Bret
    Jan 13, 2005 at 12:24 am
    Jan 13, 2005 at 2:36 pm
  • Hi All, I have written a function that moves data from a load table (data_transfer.tbl_sales_order_line_item) to two data tables (sales_order.tbl_line_item & sales_order.tbl_item_description) the ...
    Keith WorthingtonKeith Worthington
    Jan 11, 2005 at 5:19 pm
    Jan 12, 2005 at 4:58 pm
  • Hi, I am a newbie pgsql user. How can I get the sha1 sum of large objects? or md5. but sha1 is better. thanks... -- Can Burak Cilingir http://canb.net/ http://tdk.org.tr/dogruyazalim.html icq#10720999
    Can Burak CilingirCan Burak Cilingir
    Jan 3, 2005 at 11:05 pm
    Jan 4, 2005 at 3:48 pm
  • Howdy, I'm having a little bit of trouble making arrays of a data type I'm defining into another data type I'm defining. What I'm trying to do is this: create type MYSCHEMA.T_QUESTION_RESULT as ( ...
    James DeMondJames DeMond
    Jan 31, 2005 at 2:58 pm
    Feb 1, 2005 at 3:06 pm
  • i'm trying to grant a user permissions in pgadminiii. however, the only option it gives me is for the group "public". in addition, i can grant privileges at the db level, the schema level, the public ...
    Operationsengineer1Operationsengineer1
    Jan 31, 2005 at 3:36 pm
    Feb 1, 2005 at 2:09 am
  • Hello I've installed Postgres last week and I plan to learn this database. I've been using Access and other databases such as dBase (a long time ago), for more than 10 years, but I don't know how to ...
    Tomas Eroles i FornerTomas Eroles i Forner
    Jan 31, 2005 at 6:52 pm
    Jan 31, 2005 at 7:48 pm
  • Should the expressions select distinct x from t and select x from t group by x have the same effect? It seems the optimizer sometimes chooses different plans for those expressions. Could the select ...
    Ron MayerRon Mayer
    Jan 28, 2005 at 10:35 am
    Jan 29, 2005 at 10:14 pm
  • I am converting several databases from difference database vendors in PostgreSQL, but I am finding that PostgreSQL appears to not support this datatype, unlike the other vendors we use. The DATETIME ...
    Van Ingen, LaneVan Ingen, Lane
    Jan 28, 2005 at 8:57 pm
    Jan 28, 2005 at 9:15 pm
  • Hello All! How PostGre keeps datastorage files? Is that one file for entire database or one for each table or some other way? -- Best regards, Dmitry mailto:webbird@mail.ru
    Dmitry KonnovDmitry Konnov
    Jan 27, 2005 at 1:26 pm
    Jan 27, 2005 at 2:13 pm
  • Hello ¿Does anybody has installed Postgres 8.0 on Windows using the MSI Installer file that provides Postgresql Web Page using a FAT32 Partition? I tried but I get the following error "The PostgreSQL ...
    Eduardo Vázquez RodríguezEduardo Vázquez Rodríguez
    Jan 26, 2005 at 7:57 pm
    Jan 26, 2005 at 10:09 pm
  • Hi, i'm using delphi 7 with Zeos components to access PostgreSQL 8.0 for Windows. I need to import a delimited text file into a PostgreSQL table. Like BatchMove. May you help me and send me a sample ...
    Márcio ViníciusMárcio Vinícius
    Jan 21, 2005 at 5:41 pm
    Jan 25, 2005 at 7:01 pm
  • I have Postgres 7.3 installed from the Red Hat Enterprise distribution... I can't find contrib/dblink... Where do I find contrib/dblink?
    Mike DisbrowMike Disbrow
    Jan 21, 2005 at 6:06 pm
    Jan 25, 2005 at 6:12 pm
  • Hi! Me again. <grin I have learned how to ALTER USER to both set a password and change a password. However, I can't seem to *remove* a password. Setting it to '' does not work as intended; on the ...
    Rodolfo J. PaizRodolfo J. Paiz
    Jan 25, 2005 at 1:44 am
    Jan 25, 2005 at 4:40 pm
  • Hi all, I'm writing a function that basically returns all of the URLs that are like (in the SQL sense of LIKE) a string that I supply. I can't seem to get the correct arrangement of percent symbols ...
    Paul MurphyPaul Murphy
    Jan 20, 2005 at 4:20 pm
    Jan 21, 2005 at 11:07 am
Group Navigation
period‹ prev | Jan 2005 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions114
posts388
users105
websitepostgresql.org
irc#postgresql

105 users for January 2005

Michael Fuhr: 29 posts Sean Davis: 29 posts Tom Lane: 22 posts Keith Worthington: 19 posts Ramon Orticio: 17 posts John DeSoi: 16 posts Rodolfo J. Paiz: 16 posts Mike G.: 14 posts Sarlav kumar: 13 posts Alexander Borkowski: 12 posts Operationsengineer1: 9 posts Bruno Wolff III: 9 posts Jeff Eckermann: 8 posts Van Ingen, Lane: 8 posts Afton & Ray Still: 7 posts Andreas Kretschmer: 6 posts Jason Dixon: 6 posts Tjibbe Rijpma: 6 posts Akbar: 4 posts Devrim Gündüz: 4 posts
show more
Archives