FAQ

PostgreSQL > pgsql-novice > April 2002

Search Discussions

101 discussions - 277 posts

  • hi, is pgaccess still a good software ? because my readline don't work with psql, so i'm looking for an alternate solution. thank you for your suggestion patrick
    Patrick CoulombePatrick Coulombe
    Apr 16, 2002 at 4:39 pm
    Apr 17, 2002 at 9:51 pm
  • Currently I have a table on Microsoft Sequel Server that I wish to port over to Postgresql. This table has four primary keys and it's the combination of the four fields that make the record unique. I ...
    Samsom, debraSamsom, debra
    Apr 18, 2002 at 3:00 pm
    Jul 31, 2002 at 7:03 pm
  • Hello, Two questions - 1. M$ SQL Server has an identity column which generates a sequential number for you, we use this often for unique primary keys. Does postgres support anything like this ? 2. ...
    ChrisChris
    Apr 4, 2002 at 9:23 pm
    Apr 5, 2002 at 7:25 pm
  • I have installed pg 7.2.1_1, initialized & setup databases, installed plpgsql, set up users & superusers - everything seems to be ok.... but I cannot restore the backup of a database that was created ...
    P. JourdanP. Jourdan
    Apr 16, 2002 at 8:19 pm
    Apr 17, 2002 at 11:24 pm
  • My first question is about oid's. What are they exactly and when should/shouldn't I use them. I had trouble finding any information on them in either the online documentation or the online books. I'm ...
    Juliet MayJuliet May
    Apr 9, 2002 at 8:36 pm
    Apr 10, 2002 at 4:02 pm
  • I have o big problem! I have a table which has a field by date type. The date format is mm/dd/yyyy. When I'm doing this select: select da from a where da='03-31-2002'; the result is : 03-30-2002 ...
    CristiCristi
    Apr 3, 2002 at 6:11 am
    Apr 4, 2002 at 5:29 am
  • Does Postgresql have something akin to the MSSQL "SQL Profiler" to perform database traces? Any info is appreciated. Thanks, Michael McConnell Systems Engineer Education Networks of America (615) ...
    Michael McConnellMichael McConnell
    Apr 18, 2002 at 4:22 pm
    Apr 19, 2002 at 6:35 pm
  • Hi ! bash-2.04$ pg_dump my_db my_db_2904 Database version: PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96 pg_dump version: 7.0 Aborting because of version mismatch. Use --ignore-version if ...
    Aarni Ruuhimäki / Megative Tmi / KYMI.comAarni Ruuhimäki / Megative Tmi / KYMI.com
    Apr 30, 2002 at 10:22 am
    Apr 30, 2002 at 10:57 am
  • Hi, I have a rather complicated problem, that I hope someone can help with. My application keeps track of updates to an order database running on another machine. For reasons that are too complicated ...
    John TaylorJohn Taylor
    Apr 23, 2002 at 1:36 pm
    Apr 24, 2002 at 10:49 pm
  • From the big picture of PostgreSQL architecture, I understand that query processing includes parser, rewriter, optimizer and executor. I am wondering at which step, PostgreSQL performs algebraic ...
    Sophie yangSophie yang
    Apr 19, 2002 at 6:42 am
    Apr 20, 2002 at 3:05 am
  • Have only just installed RH7.2 and pgsql I'm trying to import an access csv file have already setup db with necessary columns. COPY wests from '/home/peter/wests.csv' using delimiters ';'; ERROR: ...
    Peter LowmanPeter Lowman
    Apr 13, 2002 at 10:50 pm
    Apr 15, 2002 at 1:59 pm
  • Hello, I'm trying to use a Perl script to export a query result to a text file. The result should have no header or footer information. However, when I run the script, I get a message: DBD::Pg::st ...
    Patrick HatcherPatrick Hatcher
    Apr 10, 2002 at 4:45 pm
    Apr 11, 2002 at 1:43 pm
  • I have been trying to get started with PostgreSQL, and it hasn't been going well. I installed, ran initdb, but when I try to create a database with createdb I get an error that "username" does not ...
    Kent RigbyKent Rigby
    Apr 1, 2002 at 3:33 pm
    Apr 2, 2002 at 12:24 am
  • Hi all I've got a products table in my database that has the cost price of a product and another field called vatInclusive that is simply a boolean that tells me whether the cost price is vat ...
    RobRob
    Apr 30, 2002 at 7:48 am
    May 4, 2002 at 1:56 pm
  • Sir I m using POSTGRESQL as backend.I need to take the INCREMENTAL backup of the database.But I am unable to find any way to fulfill my requirement.So its a request to you to help me in this case. I ...
    NeerajNeeraj
    Apr 30, 2002 at 5:41 am
    Apr 30, 2002 at 5:00 pm
  • Hi folks ! Where to start looking for cure ? I have a database, simple one, about teams and team members, nothing fancy about it, straight forward, add, mod and del teams and their members. Four ...
    Aarni Ruuhimäki / Megative Tmi / KYMI.comAarni Ruuhimäki / Megative Tmi / KYMI.com
    Apr 25, 2002 at 5:39 pm
    Apr 26, 2002 at 2:55 pm
  • Dear list, Just starting out with postgresql, I've got a 18 table db listing info on organisations and on the main organisation table I've got an update column (timestamp), to keep a record of the ...
    Paul butlerPaul butler
    Apr 22, 2002 at 7:17 am
    Apr 22, 2002 at 1:02 pm
  • Hello, :-) Can someone help me spec out the hardware needed for a simple web-based database app? Basically, that application needs to lookup a single row by its primary key. This would be fairly ...
    PdgPdg
    Apr 21, 2002 at 11:20 pm
    Apr 22, 2002 at 7:58 am
  • can someone please give the correct syntax for a query that has a column timestamp that allows nulls and needs to be converted to a certain format and also needs to be concatenated with commas ...
    Pam WamplerPam Wampler
    Apr 17, 2002 at 2:14 pm
    Apr 18, 2002 at 9:00 am
  • I don't know if the subject line is a correct description I have three tables for entering time data for projects. The three tables are timeentries, projects, and projectstatus. timeentries ...
    Brian JohnsonBrian Johnson
    Apr 16, 2002 at 3:25 pm
    Apr 17, 2002 at 10:23 am
  • Hi, I try to set up PG7.1.3 The date format now is yyyy-mm-dd How can I start it in date format mm-dd-yyyy? in posgresql file I have: .......-p /usr/bin/postmaster start -o -i dev/null 2 ........... ...
    CristiCristi
    Apr 11, 2002 at 6:40 am
    Apr 15, 2002 at 3:51 pm
  • Wow, thank you! I'll study your examples to learn as well! I am using your fine program as a matter of fact, and when executing the CREATE FUNCTION code below, I get the message: ERROR: Unrecognized ...
    April LApril L
    Apr 14, 2002 at 7:02 pm
    Apr 14, 2002 at 7:56 pm
  • Hi everyone, I'm trying to create a database and I'm getting some errors when I try to create some of the tables. I'm going to post the SQL and the errors and I'd appreciate it if there's a guru on ...
    Tim WilsonTim Wilson
    Apr 9, 2002 at 3:50 am
    Apr 9, 2002 at 4:54 am
  • Hi, I installed postgresql using cygwin. I got everything up and going fine. I read a suggestion on a help page that said I should run the postmaster in a separate cygwin window. That works fine too, ...
    Juliet MayJuliet May
    Apr 8, 2002 at 9:44 pm
    Apr 8, 2002 at 11:05 pm
  • HI, I am running Postgresql-7.2 with PHP 4.1.1 and I am beginning to use transactions inside of a php script: $Link = pg_connect("host=$Host dbname=$DBName user=$User") or die ("Couldn't connect to ...
    RootRoot
    Apr 3, 2002 at 1:09 pm
    Apr 4, 2002 at 10:15 pm
  • Tried to search the novice archives and the engine just never returns an answer. This is probably a pretty common question so I hope I'll get a quick answer. I have two tables cgidat and tierdat. I ...
    Lloyd VancilLloyd Vancil
    Apr 3, 2002 at 8:36 pm
    Apr 4, 2002 at 12:07 am
  • Hi, I've got a system where I want to store a full history in multiple rows as well as a current view which has the current values in one record. I know that all of the data that I want is in the ...
    Eric soroosEric soroos
    Apr 29, 2002 at 11:03 pm
    Apr 30, 2002 at 3:02 am
  • Hi, I'm inserting data into the database (via a JSP) and I'm getting the incorrect year sometimes. The date is entered by the user (it is their birthdate) then inserted into the database as dd-mm-yy ...
    Sharon CowlingSharon Cowling
    Apr 29, 2002 at 9:04 pm
    Apr 29, 2002 at 11:10 pm
  • Hi, Does postgreSQL support atomic multi-table updates? Something like: update items,month set items.price=month.price where items.id=month.id; We are considering postgreSQL for a project where we ...
    Steve AulenbachSteve Aulenbach
    Apr 24, 2002 at 5:55 pm
    Apr 25, 2002 at 8:51 am
  • Try doubleing the apostraphe again, ie: set div_name = ''RICH''''S'' Cheers, - Stuart
    Henshall, Stuart - WCPHenshall, Stuart - WCP
    Apr 24, 2002 at 10:10 am
    Apr 24, 2002 at 3:11 pm
  • What field data type do I use to store .jpg's? thanks /j-p. ----------------------- JUSTATEST Art Online www.justatest.com
    John-paul delaneyJohn-paul delaney
    Apr 23, 2002 at 8:21 pm
    Apr 24, 2002 at 10:08 am
  • Hi all. I'm trying to create a function which should return a cursor (to be used from a jdbc connection) and I'm experiencing problems in quoting (I believe) correctly inside the function: <code ...
    Alberto bolchiniAlberto bolchini
    Apr 20, 2002 at 10:49 am
    Apr 20, 2002 at 2:10 pm
  • Hi, I have a table that I want users to access to only through a view. For the inserts, I have defined a rule. I granted insert rights on the base table and view as well as select rights on the view ...
    ThiemoThiemo
    Apr 19, 2002 at 11:00 pm
    Apr 19, 2002 at 11:31 pm
  • I´m trying to create a function to obtain the possition of a substring, but i don't kown if is correct can anyone can help me to do this? test=# CREATE FUNCTION pos1 (int4) RETURNS int4 AS ' test'# ...
    Eduardo_cadenaEduardo_cadena
    Apr 17, 2002 at 3:15 pm
    Apr 18, 2002 at 6:50 am
  • Hi, I would like to make a function that writes some log data into a text file. Can anybody help me? best regards, Levi.
    Bartus LeventeBartus Levente
    Apr 14, 2002 at 4:58 pm
    Apr 18, 2002 at 3:20 am
  • Hi I have installed a 7.1.3 postgresql version on my linux server. (RedHat 7.2) When I type "createuser xxxxxxxx" it asks me : Shall the new user allowed to create databases (y/n)? Shall the new user ...
    Pierre-Alexis PaquinPierre-Alexis Paquin
    Apr 9, 2002 at 7:22 am
    Apr 15, 2002 at 2:41 pm
  • Thanks for helping. I made some notes below. I'm new to mailing lists and am not sure of the correct protocols so I appreciate any suggestions on how to respond. At 04:27 PM 4/11/2002 -0700, you ...
    P. JourdanP. Jourdan
    Apr 13, 2002 at 2:08 pm
    Apr 14, 2002 at 6:49 pm
  • Hi all, I have a table with products in and each products has 13 a digit barcode as its primary key. There are two basic types of barcodes - those that start with 25 and those that start with 60. For ...
    RobRob
    Apr 12, 2002 at 9:40 am
    Apr 12, 2002 at 11:38 am
  • Hi, I have an application where a user can choose a large number of distinct products to process. The SQL that I currently use looks something like this: select * from products where date='01012000' ...
    John TaylorJohn Taylor
    Apr 12, 2002 at 9:55 am
    Apr 12, 2002 at 10:47 am
  • Hi, I try to set up a jdbc connection but I fail. I think I have set it up correctly however with dbvisualizer I get the following error when I try to connect. ...
    ThiemoThiemo
    Apr 11, 2002 at 9:19 pm
    Apr 12, 2002 at 5:39 am
  • Hi, I try to set up PG7.2.1 (compiled it myself) with openssl support. I configured it but trying to start I get the message "/opt/pgsql/bin/postmaster: failed to load server certificate ...
    ThiemoThiemo
    Apr 10, 2002 at 8:52 pm
    Apr 10, 2002 at 9:07 pm
  • Hi everyone, Thanks to the folks who offered suggestions on my previous post. I've got all that squared away, but now I've hit another snag as I'm trying to insert some test data into my database. If ...
    Tim WilsonTim Wilson
    Apr 9, 2002 at 4:12 pm
    Apr 10, 2002 at 1:37 pm
  • I am using Postgresql 7.2 -- I would like to know how to turn off the referential integrity of tables so that I can do a bulk load & then turn the referential integrity back on. Thanks very much Pam ...
    Pam WamplerPam Wampler
    Apr 8, 2002 at 5:17 pm
    Apr 8, 2002 at 7:20 pm
  • I have a strange problem on 7.2.1 I am trying to drop a constraint that was set up by this SQL ALTER TABLE customer_main ADD CONSTRAINT cust_main_agent FOREIGN KEY ( agent ) REFERENCES customer_main ...
    Lewis BergmanLewis Bergman
    Apr 30, 2002 at 1:29 pm
    May 2, 2002 at 11:14 pm
  • Hello, I'm trying to install postgres on a HP server. Running ./configure, produces following output: checking types of arguments for accept()... configure: error: could not determine argument types ...
    WimWim
    Apr 29, 2002 at 2:23 pm
    Apr 29, 2002 at 4:40 pm
  • Excuse me if this is a silly question. Say I have a table with a text field, where I perform search operations always in the following form: SELECT * from table where LOWER(textfield) like 'X%'; ...
    Leandro FanzoneLeandro Fanzone
    Apr 25, 2002 at 7:15 pm
    Apr 25, 2002 at 10:46 pm
  • It is possible to fire off a system level shell script based upon a table trigger? I have a table that will be access very infrequently. But when that happens, I want to be able to run a script that ...
    Jerry ThompsonJerry Thompson
    Apr 25, 2002 at 3:20 pm
    Apr 25, 2002 at 5:14 pm
  • Dear all, I am having problems loading files with \copy. It seems that there are problems with the newline character. I am working on Mac OS X 10.1.2. and I am trying to load a file into postgresql ...
    Klaudia WalterKlaudia Walter
    Apr 25, 2002 at 1:39 pm
    Apr 25, 2002 at 5:02 pm
  • I'm using the libpq++ library to access PostgreSQL 7, and I need to use it from several threads at the same time. Is that supported, id est, does it have serialization mechanisms or do I have to ...
    Leandro FanzoneLeandro Fanzone
    Apr 24, 2002 at 3:24 pm
    Apr 24, 2002 at 11:55 pm
  • Howdy How do I do an escape character in a function to for a word that has an apostrophe like: RICH'S. I tried ''RICH\'S'', but when I run my function, I get back mismatch parentheses. TIA REATE ...
    Patrick HatcherPatrick Hatcher
    Apr 23, 2002 at 9:26 pm
    Apr 24, 2002 at 3:13 pm
Apr 2002
123
Group Navigation
period‹ prev | Apr 2002 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions101
posts277
users93
websitepostgresql.org
irc#postgresql

93 users for April 2002

Tom Lane: 27 posts Josh Berkus: 25 posts Joshua b. Jore: 22 posts Andrew McMillan: 9 posts P. Jourdan: 9 posts Thiemo: 8 posts Henshall, Stuart - WCP: 6 posts Patrick Hatcher: 6 posts PGMailList: 6 posts Aarni Ruuhimäki / Megative Tmi / KYMI.com: 5 posts April L: 5 posts Chris: 5 posts John Taylor: 5 posts Juliet May: 5 posts Rob: 5 posts Cristi voinicaru: 4 posts Lloyd Vancil: 4 posts Pierre-Alexis Paquin: 4 posts Ugly Hippo: 4 posts Alberto Bolchini: 3 posts
show more
Archives