FAQ

Search Discussions

47 discussions - 140 posts

  • Hi, I'm sure this question has been ask before but I could not find anything on google. I most likely did not enter the right text into the google search. I have a parent table that requires that an ...
    JohnfJohnf
    Feb 13, 2008 at 7:21 am
    Feb 18, 2008 at 9:40 pm
  • Hello I am new in SQL programing and I have a problem. I would like to monitor the new records which is inserted into an SQL table. I found some solution which mentioned a queue (log) table which can ...
    MessiasMessias
    Feb 28, 2008 at 7:56 pm
    Feb 29, 2008 at 1:00 pm
  • Is it better to use "JOIN" or comma method with equal sign when doing table joins? TIA
    Mag GamMag Gam
    Feb 18, 2008 at 11:37 pm
    Feb 19, 2008 at 7:23 am
  • Hello, I have a table which a column "fee_type " declared as char(1) The column can contain 'I' (uppercase i), 'C' or 'R' When querying with Select * from <table where fee_type in ('I', 'C') the ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Feb 3, 2008 at 8:26 am
    Feb 6, 2008 at 6:03 am
  • Hi, This is my first message, and I need some help. I have just installed Postgresql 8.2. (Windows). At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all columns correctly. But when I ...
    Aílsom F. HeringerAílsom F. Heringer
    Feb 2, 2008 at 5:36 pm
    Feb 2, 2008 at 6:24 pm
  • Hi all! [Running Debian/Lenny powerpc on an iBook.] After upgrading from postgresql-8.1 to pg_8.3 I lost the capacity to connect to my databases. I have re-created them using old dump.out files. ...
    Ennio-SrEnnio-Sr
    Feb 28, 2008 at 4:45 pm
    Mar 2, 2008 at 6:39 pm
  • Hello, I am a (relatively) newbie to PHP - and am wondering how to get the name of the user logged on to 'my' https:// site via PHP. IT set up the site via SSL and using active directory's users ...
    Greg CocksGreg Cocks
    Feb 20, 2008 at 2:30 am
    Feb 20, 2008 at 5:37 pm
  • I'm not entirely sure where to ask this question, or what to include, so I'm hoping folks here can help me out with that. Basically, I have a query that joins a table to a view. The view contains a ...
    Brandon KaneBrandon Kane
    Feb 17, 2008 at 11:05 pm
    Feb 18, 2008 at 1:42 am
  • Hello togehter, I have a problem while writing a string look like this: '0:40:f4:d3:0:0' into a table. My table has this structure: CREATE TABLE RETRY( rid bigserial primary key, source_macaddress ...
    Christian StalpChristian Stalp
    Feb 17, 2008 at 6:30 pm
    Feb 17, 2008 at 7:54 pm
  • Hi, I've got 3 tables: objects (object_id integer primary ...) projects (project_id integer primary ...) in the 3rt table I store an m:n relation obj_2_proj (object_fk, project_fk, access_ts ...
    AndreasAndreas
    Feb 11, 2008 at 3:43 am
    Feb 12, 2008 at 2:52 pm
  • Hi! Is there a way to find out the priviledges that users have on a database object (table | view | sequence)? I am interested in doing it via queries and not the psql's \z mytable command. Thanks! ...
    Szentpali JanosSzentpali Janos
    Feb 28, 2008 at 12:53 pm
    Feb 28, 2008 at 1:28 pm
  • Hi List, I just joined because I found a behaviour of implicit casts I don't understand. I am quite new to Postgre, trying out things and tried this sql-code: select cast('8.000' as text) = 8.00 as ...
    Emil ObermayrEmil Obermayr
    Feb 26, 2008 at 9:06 am
    Feb 28, 2008 at 3:23 am
  • Hi pgsql-novice: I am using 8.3 and trying to build a log analyzer to take stats. I am trying to log the following: Database Connection: Database Name, so I know which database its on Statement: ...
    Mag GamMag Gam
    Feb 24, 2008 at 8:57 pm
    Feb 27, 2008 at 8:15 pm
  • I would like to prevent changes being made to a table (b), except when a trigger fires as a result of changes (insert,update) being made to another table (a). Should any changes be made to table b by ...
    Alex du PlessisAlex du Plessis
    Feb 22, 2008 at 10:25 am
    Feb 26, 2008 at 8:17 pm
  • Hello, Greetings Everyone! This is my first post to your list. I have a novice problem as follows: There are 2 role groups in my cluster: "editors" and "viewers". In each group there are several ...
    Maciej SieczkaMaciej Sieczka
    Feb 22, 2008 at 10:13 pm
    Feb 23, 2008 at 2:51 pm
  • When the primary key of a table defaults to the nextval() of a sequence, if you insert a new record into the table and accept the default, how do you then select the value that was just used as the ...
    Jeff WilldenJeff Willden
    Feb 22, 2008 at 4:28 am
    Feb 23, 2008 at 7:35 am
  • How can I create the tsvector data for large text files WITHOUT loading the text into a column of the DB? I did it using 2 tables (one with the text inserted with a perl program) and copying the ...
    LeoLeo
    Feb 18, 2008 at 2:07 pm
    Feb 19, 2008 at 1:34 pm
  • Hi , When using regular expression will <code select * from TABLE where COLUMN1 = '~^' || 20 </code Be like <code select * from TABLE where COLUMN1 '~^20' </code -- Regards, Vishal Kashyap. Need help ...
    VishalVishal
    Feb 18, 2008 at 3:49 pm
    Feb 19, 2008 at 12:52 am
  • eg Peter's if one passes the name to an sql in code it ends up looking like: insert into whatevertable (name) values('Peter's'); and bombs. Any suggestions appreciated. Richard
    Richard terryRichard terry
    Feb 18, 2008 at 11:59 pm
    Feb 19, 2008 at 12:25 am
  • Hello, I am attempting to install postgres 8.3 onto a centos 5.1 (Redhat 5) server and am having the following difficulty. Basically, the currently installed postgresql-libs package cannot be removed ...
    Nicholas HemleyNicholas Hemley
    Feb 15, 2008 at 12:05 pm
    Feb 15, 2008 at 7:18 pm
  • So I'm having a problem with an "insane" query that's the result of joining several views. This query seems to consume 10's of megabytes of memory a second, until either the query completes or the ...
    Brian HurtBrian Hurt
    Feb 11, 2008 at 7:12 pm
    Feb 11, 2008 at 7:33 pm
  • Hi list I want to store sets of configuration options in an m:n table. Each option is defined by a parameter/value pair, and each set of options has a unique ID (the data describes non-default ...
    Erik CederstrandErik Cederstrand
    Feb 29, 2008 at 3:35 pm
    Feb 29, 2008 at 7:57 pm
  • I have written a PostgreSQL 8.3beta2 server side function named array_times_scalar (source included below). It works, but I haven't found sufficient examples to be certain that I am not leaking ...
    S anwarS anwar
    Feb 28, 2008 at 7:54 pm
    Feb 29, 2008 at 4:55 am
  • Hello, I am trying to create a new tablespace using postgres 8.3 (Centos 5.1) and am getting a permissions problem when trying to do so. Basically, the directory is owned by postgres and full ...
    Nicholas HemleyNicholas Hemley
    Feb 27, 2008 at 12:34 pm
    Feb 27, 2008 at 3:33 pm
  • This query works as I want it to: SELECT sum(cutoffuohands) AS HANDS, sum(cutoffuopfr) AS pfr FROM compiledplayerresultspositionaction JOIN compiledresults ON ...
    Sdger ergerSdger erger
    Feb 20, 2008 at 3:41 pm
    Feb 20, 2008 at 4:36 pm
  • Hello all, I have recently installed postgres 8.3 and I was slightly thrown by the default authentication as set in pg_hba.conf It appears that ident authentication is the default and not trust ...
    Nicholas HemleyNicholas Hemley
    Feb 18, 2008 at 10:54 am
    Feb 18, 2008 at 6:56 pm
  • I'm moving a PostgreSQL cluster from one server to another, and in the process also moving from 7.4 to 8.1. On the home server I have a template database called template_postgis that I used to create ...
    Mark SMark S
    Feb 18, 2008 at 1:11 am
    Feb 18, 2008 at 1:35 am
  • I'm trying to configure psqlodbc-08.03.0100 on OS X 10.5.2 and I'm getting this error: checking for pg_config... no configure: error: pg_config not found (set PG_CONFIG environment variable) How do I ...
    Brent AustinBrent Austin
    Feb 17, 2008 at 1:07 am
    Feb 17, 2008 at 2:15 am
  • What would the command be to have a query result be put into a location/space sensitive file [position 1 through 5 would be one thing where position 6 through 10 would be the next field, 11 through ...
    Ubence QuevedoUbence Quevedo
    Feb 16, 2008 at 3:39 pm
    Feb 16, 2008 at 7:56 pm
  • Hello all, I am new to PostgreSQL, coming from MySQL. I have a question that strikes me as simple but Google has failed to turn up any simple answers. I utilize bit masking in my code. In MySQL I ...
    Mark SMark S
    Feb 12, 2008 at 10:28 pm
    Feb 12, 2008 at 11:07 pm
  • Hello, I'm planning to cluster a few large tables in our database but I'm unable to find any recommendations/documentation on best practices -- Mainly, whether it's better to use an index which has a ...
    SalmanSalman
    Feb 11, 2008 at 8:03 pm
    Feb 12, 2008 at 2:42 am
  • Hi, I have two databases (8.1.11) where the content of some tables should be synced nightly. I tried to dump the contents with a script (similar to a pg_backup script), and then load them again, but ...
    Oeschey, Lars (I/EK-142, extern)Oeschey, Lars (I/EK-142, extern)
    Feb 7, 2008 at 8:12 am
    Feb 9, 2008 at 4:22 am
  • I run a modest postgres database manualy edited (via a web fron end) by 3-4 people. So the number of transactions is comparativly low. I'd like to set up some sort of real time backups The problem is ...
    Michael LushMichael Lush
    Feb 8, 2008 at 12:22 pm
    Feb 8, 2008 at 1:31 pm
  • Hi, While integrating C stub in stored procedure, I came across the following problem whenever the DB triggered the SP: " server closed the connection unexpectedly This probably means the server ...
    Smita VijayakumarSmita Vijayakumar
    Feb 7, 2008 at 10:10 am
    Feb 7, 2008 at 4:17 pm
  • From time to time I found on different forums questions "how to recover deleted rows". If i'm right deleted rows are only mark as deleted but still exist until vacuum (am I right?). So is it possible ...
    RobertskiRobertski
    Feb 27, 2008 at 7:52 pm
    Feb 27, 2008 at 7:52 pm
  • Hi all! I had a working postgresql_8.1 version but having switched to 'Debian/Lenny (testing), decided to install the newer one; so I did: # apt-get install postgresql Then made various attempts to ...
    Ennio-SrEnnio-Sr
    Feb 18, 2008 at 6:28 pm
    Feb 18, 2008 at 6:28 pm
  • Hello, I have installed the new 8.3 Postgres and all works fine for me. It took some time to reload the old tsearch2 tables, but they are OK now. My question is: How can I create the tsvector data ...
    LeoLeo
    Feb 14, 2008 at 1:02 pm
    Feb 14, 2008 at 1:02 pm
  • I have added some code to the Source code for an added functionality now i want to test my code. Please explain how i am going to test it? Thanks in Advance. Regards, Sachin Srivastava
    Sachin SrivastavaSachin Srivastava
    Feb 14, 2008 at 6:38 am
    Feb 14, 2008 at 6:38 am
  • Hello, I am seeking advice on how to build a pseudo-FK (?) relationship. I have a table to carry some time series data derived from a variety of transducers and other instrumentation - with data ...
    Greg CocksGreg Cocks
    Feb 13, 2008 at 4:24 am
    Feb 13, 2008 at 4:24 am
  • Hi, normally web programmers fake a user administration in PHP and connect to the database with one (super) user. I'am a nice guy and pass the user through PHP directly to postgresql. But the problem ...
    Andreas BurkhardtAndreas Burkhardt
    Feb 12, 2008 at 1:36 am
    Feb 12, 2008 at 1:36 am
  • This email is subject to a disclaimer which may be found by connecting to www.medscheme.co.za and clicking on the disclaimer link. Alternatively, the disclaimer can be emailed to you by sending a ...
    Marc AbbottMarc Abbott
    Feb 6, 2008 at 7:32 am
    Feb 6, 2008 at 7:32 am
  • I just installed postgres 8.3 on Windows XP and now find that my IDE (Lazarus) does not find libpq.dll. On investigation I found no libpq.dll file, just a libpq.lib file in the lib subdirectory of ...
    Alex du PlessisAlex du Plessis
    Feb 5, 2008 at 1:43 pm
    Feb 5, 2008 at 1:43 pm
  • Hello list, OK I'm not sure if this is a PHP or Postgres related question. I'm trying to set up php pages to access postgres database. 1/ What I want to do is if User A is logged in and accesses a ...
    Peter JacksonPeter Jackson
    Feb 4, 2008 at 12:30 pm
    Feb 4, 2008 at 12:30 pm
  • I'm having trouble saving the contents of a checkbox value into my postgres database. CREATE TABLE contacts.data_addresses ( pk serial NOT NULL, street text NOT NULL, fk_town integer NOT NULL, ...
    Richard terryRichard terry
    Feb 3, 2008 at 9:37 pm
    Feb 3, 2008 at 9:37 pm
  • Hello all !! Can anyone help me please ?? I would like to get the execution of each the statement in the LOOP ( in the function change_owner() below) each in its own transaction. the construction ...
    Vladimir CalmicVladimir Calmic
    Feb 3, 2008 at 11:09 am
    Feb 3, 2008 at 11:09 am
  • I have just installed Postgres 8.2.6 on a XP box. The server is running fine. However I need to get a hold of libpq.dll and it does not exist in the lib subdirectory (or anywhere I thought of to ...
    Alex du PlessisAlex du Plessis
    Feb 3, 2008 at 10:57 am
    Feb 3, 2008 at 10:57 am
  • Someone (a new subscriber) asked me to pass this question on. Taking awhile to get through Moderation. I believe it's been several hours. "Can anyone help me please ?? I would like to get the ...
    Mike EllsworthMike Ellsworth
    Feb 1, 2008 at 1:00 pm
    Feb 1, 2008 at 1:00 pm
Group Navigation
period‹ prev | Feb 2008 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions47
posts140
users66
websitepostgresql.org
irc#postgresql

66 users for February 2008

Tom Lane: 17 posts Raimon Fernandez: 9 posts Andreas Kretschmer: 6 posts Johnf: 4 posts Mag Gam: 4 posts Phillip Smith: 4 posts Alex du Plessis: 3 posts Didier Gasser-Morlay: 3 posts Greg Cocks: 3 posts Leo: 3 posts Maciej Sieczka: 3 posts Mark S: 3 posts Messias: 3 posts Nicholas Hemley: 3 posts Aílsom F. Heringer: 2 posts Andreas: 2 posts Andrej Ricnik-Bay: 2 posts Brandon Kane: 2 posts Brian Hurt: 2 posts Chander Ganesan: 2 posts
show more
Archives