FAQ

PostgreSQL > pgsql-novice > February 2005

Search Discussions

88 discussions - 293 posts

  • Hi All, I have just discovered that I can speed up one of my functions by a factor of 600 by changing an unqualified DELETE to a TRUNCATE. Unfortunately, the function is run by multiple users and I ...
    Keith WorthingtonKeith Worthington
    Feb 22, 2005 at 6:22 pm
    Feb 24, 2005 at 10:47 pm
  • Hi, Is it possible to import data from a csv file into multiple tables in postgresql database. suppose if I have 2 tables students and departments. And my csv file contains data for both the tables. ...
    DeepbluesDeepblues
    Feb 27, 2005 at 7:15 pm
    Mar 4, 2005 at 2:56 pm
  • Hi I have made a user defined type which has a string of variable length and and an integer value. Since the string is of variable length i have used a pointer for the string. When i use this type as ...
    Kjetil HaalandKjetil Haaland
    Feb 23, 2005 at 1:00 pm
    Feb 24, 2005 at 7:44 pm
  • Does anybody have any solid information that says that one language is better as a front end to a PostgreSQL database over another, and why ? We are coming out of a PHP / MySQL environment, have ...
    Van Ingen, LaneVan Ingen, Lane
    Feb 16, 2005 at 8:21 pm
    Feb 17, 2005 at 2:51 pm
  • Hi, Is there any way to find whether a particular column exists in the table or not based on the column name using sql query? I have a requirement where I need to find whether a column exists in the ...
    Rajan BhideRajan Bhide
    Feb 9, 2005 at 9:56 am
    Feb 9, 2005 at 6:43 pm
  • Hi All, Is there a way to find out the namespace id (relnamespace) for your connection? I grabbed this function from one of the list, however it doesn't work for temp tables when multiple connections ...
    Michael GuerinMichael Guerin
    Feb 4, 2005 at 1:16 am
    Feb 4, 2005 at 7:28 pm
  • I will guess in advance that I'm missing something obvious, but I *think* I need a subselect here and I've never done those. So if anyone has a comment that will point me in the right direction, I'd ...
    Rodolfo J. PaizRodolfo J. Paiz
    Feb 3, 2005 at 7:04 pm
    Feb 5, 2005 at 3:46 pm
  • Hello List... Newbie question - is it possible to combine the following two queries into one query statement returning, subject, created, topic_id, count? thanks, /j-p. (Query1) SELECT subject, ...
    John-paul delaneyJohn-paul delaney
    Feb 22, 2005 at 10:47 am
    Feb 22, 2005 at 10:00 pm
  • Hi all When defining records with varchar entries (and at some other places) something like constants would be useful. They could look something like this: DEFINE short = 20; DEFINE long = 2000; ...
    Arthur van DorpArthur van Dorp
    Feb 4, 2005 at 1:30 pm
    Feb 4, 2005 at 3:35 pm
  • I'm using postgres as the backend of a custom PHP Web application. Text is base64_encode-d in php, then stored in varchar fields in postgres. I'm trying to do this: SELECT * from table where ...
    Ross GohlkeRoss Gohlke
    Feb 25, 2005 at 12:49 am
    Mar 1, 2005 at 8:39 pm
  • i've had to change the data types of several columns in pgadmin3. most of the time, the data type is unavailable (shaded out) and, therefore, i have to delete the whole column and recreate it with ...
    Operationsengineer1Operationsengineer1
    Feb 25, 2005 at 8:24 pm
    Feb 25, 2005 at 10:26 pm
  • In a followup to an earlier question from today from another person, is it possible to create and use a function that takes as input a generic "record"? Specifically, how would I use a function like: ...
    Sean DavisSean Davis
    Feb 22, 2005 at 12:26 pm
    Feb 22, 2005 at 4:10 pm
  • Hi, I'm new to PostgreSql and i'm wondering how to write functions in PL/Perl to INSERT, RETRIEVE, DELETE elements from the tables. I have 3 tables and I have to write functions in perl to populate ...
    DeepbluesDeepblues
    Feb 14, 2005 at 7:11 pm
    Feb 16, 2005 at 1:54 pm
  • Hello, I'm trying to calculate the difference between two timestamps and have the return value in minutes. So, for instance: Time 1 = 1/1/2005 12:00 Time 2 = 1/2/2005 12:00 If you subtract Time 1 ...
    Sal DkjSal Dkj
    Feb 11, 2005 at 1:49 am
    Feb 14, 2005 at 8:54 pm
  • Assume I have one table: id name comment 1 stupid blabla 2 idiot blabla These row has been referenced by other table..... Then I add one row to that table, so the table become: id name comment 1 ...
    AkbarAkbar
    Feb 10, 2005 at 5:01 am
    Feb 11, 2005 at 7:08 pm
  • Hi! On a Red Hat Linux 7.3 system with PostgreSQL 7.3.3, I am having a problem connecting to the database, using PEAR/PHP code in a web page. The code I have worked out so far is: $dsn = ...
    Rodolfo J. PaizRodolfo J. Paiz
    Feb 3, 2005 at 5:33 am
    Feb 3, 2005 at 3:38 pm
  • I instaled the postgreSQL 8.0 version on windows 2000 advance server. I can do anythin of database in pgadminIII but not from web, when I try to conect with pg_connect it give me an error ---"Call to ...
    William DominguezWilliam Dominguez
    Feb 2, 2005 at 2:00 pm
    Feb 3, 2005 at 5:27 am
  • HI all...This is very urgent ......How cab I transpose a table in postgresql...does it have any buit in SQl feature or functions ...Plz help in this regard.... Regards Ravi Shankar
    Ravi shankarRavi shankar
    Feb 24, 2005 at 5:54 am
    Feb 26, 2005 at 8:08 pm
  • Hi All, I have two tables. The first table (tbl_item) contains an item id and it's type. tbl_item item_id | item_type --------+---------- A | DIR B | DIR C | ASY D | DIR E | DIR F | DIR G | ASY The ...
    Keith WorthingtonKeith Worthington
    Feb 17, 2005 at 3:21 am
    Feb 22, 2005 at 5:00 pm
  • Hello, If I have a table like : ID COLOR 1 blue 2 red 3 green Could I write a SQL query that would return a single concatenated row for all matching rows, with a specified seperator. For example like ...
    A GilmoreA Gilmore
    Feb 21, 2005 at 1:38 am
    Feb 21, 2005 at 7:25 pm
  • Hi All, I have been working on a SQL statement that contains a WHERE clause of the form WHERE column1 column2. The query runs pretty quickly (285ms) without the WHERE clause but slows to a relative ...
    Keith WorthingtonKeith Worthington
    Feb 19, 2005 at 3:28 am
    Feb 19, 2005 at 3:12 pm
  • Hi All, I am having difficulty understanding the use of defaults. I have a table with defaults defined in three columns. When I run a function that inserts/or updates records the default value is not ...
    Keith WorthingtonKeith Worthington
    Feb 14, 2005 at 7:50 pm
    Feb 15, 2005 at 2:54 pm
  • Hello I currently own a copy of "PostgreSQL Developer's Handbook" by Geshwinde and Schonig, 2002. Would this still be good enough to start making databases in the current version of PostgreSQL? I ...
    Peter MountPeter Mount
    Feb 11, 2005 at 10:01 am
    Feb 11, 2005 at 2:12 pm
  • Hi..... Imagine I have view named view_stok_table_total.... SELECT * FROM view_stok_table_total; index name sum buying_price sale_price 1 mentos 5 100 120 2 mentos 8 110 140 3 durex 9 200 210 4 queen ...
    AkbarAkbar
    Feb 7, 2005 at 5:23 am
    Feb 7, 2005 at 4:26 pm
  • Hi All, I'm trying to resolve an issue with the database crashing when under a heavy load. The error is hard to reproduce and happens once or twice a month. It's also been happening since Postgresql ...
    Michael GuerinMichael Guerin
    Feb 1, 2005 at 2:54 am
    Feb 7, 2005 at 1:33 am
  • Ok, I want to call a sql expression( and or file) from a bat file and pipe the result to a text file. Sounds super simple.. I am trying to use psql but I cannot find a way of passing the password to ...
    Oisin GlynnOisin Glynn
    Feb 2, 2005 at 9:32 pm
    Feb 4, 2005 at 2:12 pm
  • Hi: One of my tables will store latitude and longitude information. I've checked and I cannot see a datatype for that (which is no surprise, and no loss). However, I can think of three ways to store ...
    Rodolfo J. PaizRodolfo J. Paiz
    Feb 4, 2005 at 12:31 am
    Feb 4, 2005 at 1:45 pm
  • Hello, I was wondering whether it is worth for me to learn PL/Pgsql, given the support of Python in Postgresql. The latter (Python) is the only programming language I've learned voluntarily in my ...
    Wolfgang KellerWolfgang Keller
    Feb 27, 2005 at 3:59 pm
    Mar 4, 2005 at 12:49 pm
  • Hello I have an old Clipper 5.1 based application. I would like to change dbase to postgresql without change program's businsess logic only database connect. Is it possible? Joe ALL-NEW Yahoo! ...
    Mester JózsefMester József
    Feb 23, 2005 at 10:27 am
    Feb 23, 2005 at 10:31 pm
  • Hello List... Given Sean's answer above, I then managed the simple part to get the author name from another table, but was stumped when I thought it would be better to return the created date of the ...
    John-paul delaneyJohn-paul delaney
    Feb 22, 2005 at 2:21 pm
    Feb 22, 2005 at 2:52 pm
  • Hi I have created my own user defined type, and an operator class for this type. Then i can use the order by clause with this type, but it is sorting with the lowest value on top. Is it possible to ...
    Kjetil HaalandKjetil Haaland
    Feb 21, 2005 at 2:15 pm
    Feb 21, 2005 at 4:43 pm
  • Hello all, I am rather new to Postgres (been using for about 5 months) and am having a slight issue with postgresql and it starting up. I am running Debian GNU/Linux Woody 3.0, on a self-built server ...
    Daniel BlavosDaniel Blavos
    Feb 16, 2005 at 12:44 am
    Feb 16, 2005 at 5:18 am
  • How do I tell / where do I look to find out whether our installations of PostgreSQL that I have was installed with JDBC or ODBC? I need the answer for: - version 8.0 Windows - version 8.0 Linux
    Van Ingen, LaneVan Ingen, Lane
    Feb 15, 2005 at 4:26 pm
    Feb 15, 2005 at 5:23 pm
  • Hi, I've got two questions about plpgsql. Couldn't find the answer in the manual nor anywhere on the net. Let's say I've got a table A with columns (id integer, txt varchar) and a function ...
    DimDim
    Feb 12, 2005 at 8:50 am
    Feb 12, 2005 at 10:01 am
  • I am trying to find the pg_hba.conf file in my server; it is Linux Red Hat 9, I have pgadminIII from windows client but I can´t find the file, Can you help me please ? Thanks in advance Sincerely, ...
    Luis CuencaLuis Cuenca
    Feb 4, 2005 at 9:37 pm
    Feb 9, 2005 at 6:24 pm
  • Is there a way to see how many rows of a table have been processed by an update? I've got an update on a 13,000,000 row table that's been running for five days now. Five days is a good long time, ...
    Colin McGuiganColin McGuigan
    Feb 7, 2005 at 2:57 pm
    Feb 7, 2005 at 6:41 pm
  • I've got a table with the following schema: Phone_num latlon location_when Each row holds a user's phone number, their location, and the time they were at that location. There can be up to 120 rows ...
    Schuhmacher, BretSchuhmacher, Bret
    Feb 7, 2005 at 11:34 am
    Feb 7, 2005 at 2:37 pm
  • I have a column in my table block_sizes(varchar) that looks like: 12,23, 234,23, 78,64,28, i.e., comma-separated integer values (and the included trailing comma). I would like to convert these each ...
    Sean DavisSean Davis
    Feb 5, 2005 at 4:12 pm
    Feb 5, 2005 at 5:10 pm
  • Hello all - I know I reported everything was fine the other day on this, but something strange happened... My Linux box (Fedora Core 3) crashed and wouldn't reboot; the bios said it couldn't find a ...
    Schuhmacher, BretSchuhmacher, Bret
    Feb 3, 2005 at 3:28 pm
    Feb 3, 2005 at 4:45 pm
  • Dear all, This is my first post. 2 questions: 1. How can I script the above so passwords aren't asked for? 2. Is bash or perl better, i.e. should I need DBI? Thanks. -- Kind Regards, Gavin Henry. ...
    Gavin HenryGavin Henry
    Feb 3, 2005 at 9:53 am
    Feb 3, 2005 at 2:39 pm
  • does anybody use this technique? it is supported by pgsql, however, setting it up isn't intuitive to this newbie. ------------------------- http://phplens.com/lens/adodb/tips_portable_sql.htm When ...
    Operationsengineer1Operationsengineer1
    Feb 2, 2005 at 8:22 pm
    Feb 2, 2005 at 8:42 pm
  • I try to drop some constraint.... it said ERROR: cannot drop constraint blablabla on table blablabla because other object depend on it... HINT: blablabla How do I know which object depend on this ...
    AkbarAkbar
    Feb 2, 2005 at 9:41 am
    Feb 2, 2005 at 3:49 pm
  • hi all, i have a question about booleans. i heard that a boolean takes more processing power than setting an integer as 1 or 0 and coding around those values. is this really an issue anyone will ...
    Operationsengineer1Operationsengineer1
    Feb 25, 2005 at 8:02 pm
    Feb 25, 2005 at 8:12 pm
  • Does anyone know if Postgres supports some form of: insert into mytable(column1,column2) values ('a','b') returning mytable_pk into :new_mytable_pk Where 'mytable_pk' is defaulted to type of SERIAL? ...
    John NapiorkowskiJohn Napiorkowski
    Feb 23, 2005 at 6:11 am
    Feb 23, 2005 at 9:00 am
  • I'm trying to copy into a table from a file, and postgres is complaining about a float value.... The table is as follows: smallint, smallint, int, smallint, smallint, integer, float8 And the data ...
    Dan QuaroniDan Quaroni
    Feb 18, 2005 at 3:05 pm
    Feb 23, 2005 at 8:18 am
  • Hi Not sure if this belongs in novice or somewhere a bit 'higher' but I'll stick it here anyway. I'm running a series of PHP scripts through postgre 7.3.4 at college to create an online portfolio ...
    A KA K
    Feb 17, 2005 at 5:06 pm
    Feb 23, 2005 at 7:14 am
  • I have a function with 3 parameters (select clause, where clause and order by clause (last two are optionally clauses). This clauses apply to a given table. For example, the table table1 and the ...
    Stefan ArdeleanuStefan Ardeleanu
    Feb 22, 2005 at 2:13 pm
    Feb 22, 2005 at 10:28 pm
  • I created the following statement: CREATE TYPE get_item_info_type AS (full_name varchar(300),dob varchar(300)); CREATE OR REPLACE FUNCTION sp_items(int8) RETURNS get_item_info_type AS ' DECLARE in_id ...
    Chari ClarkChari Clark
    Feb 17, 2005 at 8:35 pm
    Feb 21, 2005 at 6:39 am
  • how do you enter files of images such as jpeg and bitmaps in postgresql. thanks
    Ramon OrticioRamon Orticio
    Feb 17, 2005 at 7:04 am
    Feb 17, 2005 at 1:02 pm
  • I just installed (for the 4th time) Postgresql 8.01 on WinXP SP1. Each time, the same thing happens. When I use pgAdminIII to connect to the default database server, I get the following error: "An ...
    ApocalypznowApocalypznow
    Feb 11, 2005 at 11:12 pm
    Feb 16, 2005 at 11:43 pm
Feb 2005
12
Group Navigation
period‹ prev | Feb 2005 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions88
posts293
users101
websitepostgresql.org
irc#postgresql

101 users for February 2005

Tom Lane: 27 posts Michael Fuhr: 24 posts Operationsengineer1: 16 posts Rodolfo J. Paiz: 13 posts Sean Davis: 12 posts Keith Worthington: 10 posts Bruno Wolff III: 7 posts John DeSoi: 7 posts Schuhmacher, Bret: 7 posts John-paul delaney: 6 posts Kjetil Haaland: 6 posts Michael Guerin: 6 posts Oisin Glynn: 6 posts Van Ingen, Lane: 6 posts Mike G.: 5 posts Brew: 4 posts Arthur van Dorp: 4 posts Bruce Momjian: 4 posts John Hansen: 4 posts Mitch Pirtle: 4 posts
show more
Archives