Search Discussions

90 discussions - 321 posts

  • I am developing a web application and I would like to manage my user accounts in my postgresql database. Is the 'best' way to do this to set up all of my user accounts in Postgres and then set up a ...
    Kevin CrenshawKevin Crenshaw
    Jan 4, 2006 at 12:59 pm
    Jan 5, 2006 at 2:29 pm
  • I there I'm having a problem. I'm doing this SQL query select count(*) from public_identif INNER JOIN ifc ON ifc.spid=public_identif.spid where (ifc.profilepartindicator='' OR ...
    Luis SilvaLuis Silva
    Jan 30, 2006 at 3:41 pm
    Feb 22, 2006 at 6:43 pm
  • I have the following query which I would need to be able to use in PostgreSQL. This basically limits the number of allowed rows in a table to 8. CREATE TRIGGER <TRIGGERNAME ON [<TABLENAME ] FOR ...
    Jan 10, 2006 at 2:29 pm
    Jan 10, 2006 at 9:04 pm
  • hi list here's what i would like to do: table1: field0: id field1: boolean field2: numeric field3: varchar when selecting records from this table, i would like to have different sort orders depending ...
    Jan 14, 2006 at 4:47 pm
    Jan 15, 2006 at 6:33 pm
  • To all, I have two databases which need to be the same structurally. However members on my team have gone ahead and made structural changes to one and not the other. I am trying to sync up the ...
    Sugrue, SeanSugrue, Sean
    Jan 11, 2006 at 8:30 pm
    Jan 23, 2006 at 6:13 am
  • OK, this may be just my brain being foggy because it's late at night and I've been working on this project too long, but I have a SELECT statement that's not doing what I want, and I can't figure out ...
    Lynna LandstreetLynna Landstreet
    Jan 19, 2006 at 11:13 am
    Jan 20, 2006 at 7:38 am
  • Hi all - I have two tables - customers and documents. Each customer can be related to several different documents. There has been a bug in some software that's been duplicating the addition of a ...
    Scott FordScott Ford
    Jan 11, 2006 at 7:07 pm
    Jan 12, 2006 at 5:06 pm
  • and another sql question... greatly simplified info: t_sn sn_id sn t_inspect inspect_id sn_id (fkey) inspect_pass (boolean) i want to display all sns where there is not a single instance of ...
    Jan 7, 2006 at 12:02 am
    Jan 10, 2006 at 3:32 pm
  • with mysql you can do: CREATE TABLE [table] ... stamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, ... but with pgsql it seems you need to do a trigger: CREATE RULE ...
    F gF g
    Jan 23, 2006 at 1:56 pm
    Jan 24, 2006 at 9:50 pm
  • Hello, I need a little help with a query. We have some auditing tables. Now we want to see the values that were in a database at a special date. Here is our table: project_his_conno operation user_no ...
    Christian HofmannChristian Hofmann
    Jan 15, 2006 at 6:19 pm
    Jan 16, 2006 at 4:46 pm
  • they query i'm using is as follows: SELECT t_product.product_id, t_product.product_number, t_serial_number.serial_number_id, t_serial_number.serial_number, FROM t_serial_number LEFT JOIN ...
    Jan 12, 2006 at 5:09 pm
    Jan 12, 2006 at 8:57 pm
  • PostgreSql 8.0.3 I have a complex query that I want to read the data in a hierarchical manner - ie from master table filtered rows to sub set1, from subset1 to subset2 etc. The query is in the ...
    Steve TucknottSteve Tucknott
    Jan 2, 2006 at 9:07 am
    Jan 12, 2006 at 4:43 am
  • Why don't you use PGAdmin ? -----Original Message----- From: pgsql-novice-owner@postgresql.org On Behalf Of Joao Miguel Ferreira Sent: Monday, January 09, 2006 11:57 PM To: ...
    Jan 9, 2006 at 2:10 pm
    Jan 9, 2006 at 8:18 pm
  • Hello again, thx very much for all the previous feedback.... here's another one: what do database people mean by 'schema' ? jmf
    Joao Miguel FerreiraJoao Miguel Ferreira
    Jan 9, 2006 at 3:43 pm
    Jan 9, 2006 at 5:47 pm
  • Hello all at PG, Let's say I forgot the "definition" of a table (.. the original CREATE TABLE query)... how do I ask PG to tell me these definition's (int not null, text, foreign key, etc) ?? ...
    Joao Miguel FerreiraJoao Miguel Ferreira
    Jan 9, 2006 at 1:57 pm
    Jan 9, 2006 at 4:15 pm
  • Hallo, I need GRANT some privilegies to one row. I know, that it si possible to do that for columns, but I do not know how do it for rows. Any ideas? Thanks for your advices. Jaromik Kamler
    Jaromír KamlerJaromír Kamler
    Jan 4, 2006 at 10:57 pm
    Jan 5, 2006 at 8:57 am
  • hello, i've been a filemaker pro user for quite awhile, and have decided to take the plunge with postgresql. i just installed the latest release version, v8.1.1, and am slowly making my way through ...
    Jan 3, 2006 at 8:01 pm
    Jan 3, 2006 at 9:14 pm
  • Hi I have a list of cities stored in flat file that I would like to left join with another table. The file looks like this: city1,city2,city3 I want to put them into a table like this: city -------- ...
    Jan 26, 2006 at 2:30 am
    Feb 4, 2006 at 9:51 pm
  • I'm about to embark on some major development of data bases both at home and at work. In both cases, my servers, which are functioning perfectly, are installed with FC3 (postgresql-7.4.6-1.FC3.1) ...
    Lan BarnesLan Barnes
    Jan 30, 2006 at 6:49 pm
    Jan 31, 2006 at 2:30 pm
  • Hello, I have a little table with 400,000,000 rows of text (about 40 chars each). I want to delete values that are exisiting more than two times. So I created a new table (table2), the same than the ...
    Christian HofmannChristian Hofmann
    Jan 30, 2006 at 3:31 pm
    Jan 30, 2006 at 5:45 pm
  • Hi all, Our postgresql database has been churning along just fine, albeit a little slower than I'd like. However, more surprising to me is that it has (over the past few years) become HUGE. It's ...
    Anthony PresleyAnthony Presley
    Jan 18, 2006 at 8:35 pm
    Jan 18, 2006 at 9:57 pm
  • Hi I have created a column item varchar(11) with default value = 0 But when i do insert any record the value is set to null. How can i always get the defualt value if any other value is not defined ...
    Ângelo Marcos RigoÂngelo Marcos Rigo
    Jan 13, 2006 at 1:16 pm
    Jan 13, 2006 at 6:30 pm
  • Does anyone know if PostgreSQL 8.1.x will work on the new Intel Macs? I'm putting in my order for a new MacBook Pro. Thanks, Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com ...
    Brendan DuddridgeBrendan Duddridge
    Jan 11, 2006 at 6:19 am
    Jan 11, 2006 at 11:39 pm
  • Hello all, this is my first question... I'm really new to PG. How do I get a list of all tables in a database ? Is there an SQL command for this ? thx jmf
    Joao Miguel FerreiraJoao Miguel Ferreira
    Jan 9, 2006 at 12:42 pm
    Jan 9, 2006 at 3:35 pm
  • hi list why can't i define a primary key on a varchar field as being lower(field)? i'm getting the following error: ERROR: syntax error at or near "(" at character 94: PRIMARY KEY ((lower(e_name) )); ...
    Jan 7, 2006 at 12:28 am
    Jan 8, 2006 at 1:18 pm
  • i'm trying to apply the following UPDATE statement: UPDATE t_sn SET t_sn.sn_completed = false WHERE sn = 1 AND t_sn.link_id = t_link.link_id AND t_link.job_id = t_job.job_id AND t_job.product_id = ...
    Jan 4, 2006 at 10:29 pm
    Jan 5, 2006 at 12:31 am
  • Hello- I have a table with values in two columns that I want to swap; that is, I want the value in column A to now be in column B and the value in column B to be in column A. I tried... UPDATE ...
    Greg LindstromGreg Lindstrom
    Jan 18, 2006 at 8:52 pm
    Feb 2, 2006 at 1:13 am
  • Another noobish question. I'm looking for the "moral equivalent" of the mythical GRANT SELECT ON TABLE * TO PUBLIC I.e. I'm looking for a way to grant SELECT privileges to PUBLIC on all the tables, ...
    Jan 31, 2006 at 9:10 pm
    Feb 1, 2006 at 6:35 am
  • Dear All, I am trying to copy the PostGIS Database from Linux computer to Windows. Under Linux Debian we have PostgreSQL 7.4.6, under Windows XP we have PostgreSQL 8.1.0-2 . I am creating dump under ...
    Jan 30, 2006 at 11:50 am
    Jan 30, 2006 at 3:36 pm
  • i set up an update statement to update a unit's status from incomplete to completed. however, pgsql doesn't kick out an error message when i try to update something that doesn't exist. eg, serial ...
    Jan 26, 2006 at 10:22 pm
    Jan 27, 2006 at 2:59 am
  • Hi all, I have a short function below that is return me an error, and I can't figure out what I should do to fix it. Can anyone help? Archives have not helped. The error I get is: select * from ...
    Lane Van IngenLane Van Ingen
    Jan 10, 2006 at 3:42 pm
    Jan 10, 2006 at 4:40 pm
  • First LastFirst Last
    Jan 5, 2006 at 8:36 am
    Jan 5, 2006 at 12:24 pm
  • hi list during table creation i mistakenly had a SERIAL instead of INTEGER type for a value. i removed the default value (nextval....) for this field. still i can't drop the old sequence: ERROR: ...
    Jan 3, 2006 at 2:46 am
    Jan 3, 2006 at 5:33 pm
  • Hello, I am a new user to PostgreSQL. I need to use the "Northwind" database in SQL. I tried to take a backup of that database. And tried to restore the backup in PostgreSQL. But i could not do that. ...
    Jan 27, 2006 at 10:19 am
    Feb 20, 2006 at 2:02 pm
  • hi all, i'm new to the list, so if this is an off-topic question, or has already been posed, i apologize... i'm trying to figure out how to get the following test situation to work: creating a ...
    Murat TasanMurat Tasan
    Jan 30, 2006 at 11:26 pm
    Feb 4, 2006 at 10:33 pm
  • My problem is this: I have a table 'history' with columns for ''date_time', 'event', 'sensor'. The 'event' column may contain 'Calibrated', 'Damaged', 'Repaired'. Since it is a history, the same ...
    Gan Uesli StarlingGan Uesli Starling
    Jan 31, 2006 at 3:10 pm
    Feb 2, 2006 at 12:38 am
  • Please help. Please correct : copy tmp_table from supplier_merch.dat with delimiter '|'; ERROR: parser: parse error at or near "table" at character 6. COPY table [ ( column [, ...] ) ] FROM { ...
    Clifton ZamaClifton Zama
    Jan 31, 2006 at 11:59 am
    Feb 1, 2006 at 6:41 am
  • Hi! I managed myself to a near-hopeless situation. My pg_dumps lost, the machine with the database died. I have the disk of the machina, with the data directory, with (hipotetically) intact files. So ...
    Tomka GergelyTomka Gergely
    Jan 31, 2006 at 12:51 pm
    Jan 31, 2006 at 3:07 pm
  • I know that one can store multiple psql commands and SQL statements in a separate "script" file, and then "source" the script file, e.g. with the \i command. My question is, can I define variables in ...
    Jan 31, 2006 at 12:17 pm
    Jan 31, 2006 at 1:35 pm
  • i allow my users to insert notes. when they leave the note blank, "" gets inserted into the db. is this expected behavior? tia...
    Jan 31, 2006 at 1:04 am
    Jan 31, 2006 at 8:59 am
  • Hi! I´m start to work with postgresql, and I have some problema when I try to run pg_dump. If I execute: pg_dump mibd -U postgres midb.out Don´t receive any error message, but midb.out is empty.... ...
    Luzmar Caicedo UsecheLuzmar Caicedo Useche
    Jan 27, 2006 at 8:13 pm
    Jan 30, 2006 at 2:15 pm
  • When I try to drop a database, whether I have opened it or some other database, I get told it doesn't exist. The message changes the case of the database name, but that may be a feature of SQL. They ...
    Lan BarnesLan Barnes
    Jan 27, 2006 at 8:07 pm
    Jan 28, 2006 at 1:40 am
  • I there, is it possible to send a undefine number of queries (SELECTS) with transactions, and if one of then doesn't return anything do rollback and do not commit? if not, is there another tool that ...
    Luis SilvaLuis Silva
    Jan 5, 2006 at 4:36 pm
    Jan 27, 2006 at 5:49 pm
  • how can i make use of the column number instead of the column name when making the select statement? for instance: "SELECT mytable.col[1], mytable.col[2], mytable.col[3], mytable.userid from mytable" ...
    First LastFirst Last
    Jan 20, 2006 at 8:24 am
    Jan 23, 2006 at 7:34 pm
  • Good Day: I understand that it is undesireable to run a database over NFS. However, due to the shortage of local space on my machine, I had to utilize NFS space on another machine as an additional ...
    S anwarS anwar
    Jan 17, 2006 at 10:38 pm
    Jan 18, 2006 at 1:23 am
  • Hello every one, Here is my first post. I have the following message : ======================================= "ERROR: unrecognized configuration parameter "ksqo" ...
    Cédric BuschiniCédric Buschini
    Jan 17, 2006 at 9:05 am
    Jan 17, 2006 at 11:23 am
  • hi list how can something like this be achieved: UPDATE mytable SET m_list = (SELECT DISTINCT s_id FROM sometable WHERE s_id 6000) WHERE m_id = 10; the field m_list would then hold something like ...
    Jan 12, 2006 at 11:11 pm
    Jan 13, 2006 at 12:39 pm
  • Tom, I've done more tests. After re-creating a table with just one field (char(8000)), I inserted 26 records. Look at this: teste=# select relname, oid, relpages, reltuples from pg_class where oid = ...
    Jan 12, 2006 at 12:27 pm
    Jan 12, 2006 at 5:21 pm
  • I there!! How can I receive in my query result '1' or '0' instead of 't' and 'f'. tks in advance Express yourself instantly with MSN Messenger! Download today it's FREE! ...
    Luis SilvaLuis Silva
    Jan 11, 2006 at 6:41 pm
    Jan 11, 2006 at 7:00 pm
  • Hello all, I created 2 users (user01 and user02) with passwords. I created 2 databases (user01db and user02db) owned by each of the users. Nevertheless, user02 can connect to the database of user01 ...
    Joao Miguel FerreiraJoao Miguel Ferreira
    Jan 10, 2006 at 12:24 pm
    Jan 10, 2006 at 3:57 pm
Group Navigation
period‹ prev | Jan 2006 | next ›
Group Overview
grouppgsql-novice @

87 users for January 2006

Tom Lane: 30 posts Michael Fuhr: 26 posts Operationsengineer1: 19 posts Andreas Kretschmer: 19 posts Sean Davis: 15 posts Me: 13 posts Jaime Casanova: 13 posts Luis Silva: 11 posts Kevin Crenshaw: 10 posts Christian Hofmann: 8 posts Frank Bax: 7 posts Michael Glaesemann: 7 posts First Last: 6 posts Andrew Chambers: 5 posts Brendan Duddridge: 5 posts Bruno Wolff III: 5 posts Steve Tucknott: 5 posts Guido Barosio: 4 posts Joao Miguel Ferreira: 4 posts Lynna Landstreet: 4 posts
show more