FAQ

PostgreSQL > pgsql-novice > June 2010

Search Discussions

63 discussions - 226 posts

  • Hi there, could someone drop me a hint on the whys at below? The table: test=# select * from texts; title | a_text --------------+------------------------- A macskacicó | A blah blah macskacicónak. ...
    Laslo ForroLaslo Forro
    Jun 8, 2010 at 8:49 am
    Jun 22, 2010 at 8:41 pm
  • This statement: UPDATE question_choices SET total_rows = count(*) from care_lesson; returns the following error (which is well-documented): ERROR: cannot use aggregate function in UPDATE LINE 1: ...
    John GageJohn Gage
    Jun 1, 2010 at 8:28 pm
    Mar 2, 2012 at 3:19 pm
  • Hello, I'm running a Debian Lenny box with PostgreSQL 8.4.4 from the backports. I have a question regarding timestamps with time zone. I can't get time zones inserted into my timestamp with time zone ...
    Xavier RobinXavier Robin
    Jun 30, 2010 at 1:12 pm
    Jul 1, 2010 at 7:26 am
  • How do I run an operating system command from a stored procedure? In INFORMIX I would use the SYSTEM command, can't see to find the equivalent for POSTGRES. I'm running AIX6.1. Thanks Atif
    Atif JungAtif Jung
    Jun 17, 2010 at 2:30 pm
    Jun 18, 2010 at 8:12 pm
  • Hi, I'm new to the list and have the following situation happening "PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit" running windows XP sp3 I have an SQL problem that I thought was easy ...
    Michael DienerMichael Diener
    Jun 2, 2010 at 3:24 pm
    Jun 4, 2010 at 12:07 pm
  • I have the following query: SELECT * FROM "sales_projects" WHERE (((sales_projects.prospect ILIKE E'%rancho murieta%') OR (sales_projects.prospect_type ILIKE E'%rancho murieta%') OR ...
    Kent ThomasKent Thomas
    Jun 30, 2010 at 12:29 pm
    Jul 2, 2010 at 9:50 am
  • 7

    RI

    Hi list, does a Referential Integrity toward a table also acts like an index, or am I obliged to create this index? JY -- But sex and drugs and rock & roll, why, they'd bring our blackest day.
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 24, 2010 at 3:19 am
    Jun 24, 2010 at 8:57 pm
  • Hello, I'm new to Postgres so I apologize in advance for the simple question.... Why is it when I'm building an empty schema does Postgres consume all the CPU resources? My experience is with ...
    Deborah FuentesDeborah Fuentes
    Jun 22, 2010 at 8:40 pm
    Jun 24, 2010 at 3:13 pm
  • Hi list, Is it safe to leave an internet access to SSL Pg (4096 bits key) or not? -- Honi soit la vache qui rit.
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 14, 2010 at 8:14 pm
    Jun 18, 2010 at 4:18 pm
  • Hello everyone When the trigger executes the function which I copy below: IF (TG_OP = 'UPDATE') THEN EXECUTE 'CREATE TABLE '||NEW.nome_tabella||' (ordinativo serial PRIMARY KEY CHECK (nome_tabella = ...
    CovioloCoviolo
    Jun 9, 2010 at 10:37 am
    Jun 10, 2010 at 7:31 am
  • Battleground was a machine running CentOS 5.5 and the two towers were 2 databases. First, PostgreSQL 8.4.4: scott=# select count(*) from emp e1,emp e2, emp e3, emp e4,emp e5, emp e6; count --------- ...
    Mladen GogalaMladen Gogala
    Jun 8, 2010 at 2:42 am
    Jun 8, 2010 at 3:35 pm
  • Hi all, I have a question (or more of a guidence request) in regards to PostgreSQL v8.4 Protocol v3 and accessing the database via TCP. Background: part of the summer project that Im involved in I ...
    GregGreg
    Jun 28, 2010 at 4:38 pm
    Jun 29, 2010 at 2:35 pm
  • Hi list people. Okay I've read the documentation. Now it's time to talk to people that actually do this for a living. Mixed case searches, what is the best practice? I'm searching for an account ...
    Chris CampbellChris Campbell
    Jun 15, 2010 at 3:29 pm
    Jun 16, 2010 at 6:21 pm
  • Hello all, Im not sure if this is the right list to post this on, so if its wrong please point me in the right direction. I first used the "one-click" installer package for Windows to install ...
    BidskiBidski
    Jun 30, 2010 at 8:47 am
    Jun 30, 2010 at 10:17 pm
  • debian sid pg 8.4.4-1 =============== Hi list, I read the docs about escaping, but I can't find any other manner to escape than a backslash or to double the single quote: SELECT ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 26, 2010 at 9:22 pm
    Jun 27, 2010 at 2:38 pm
  • Hi there, I am trying to set the --locale for a database but receive 'invalid locale name' Here is the posgresql.conf part: lc_messages = 'en_US.UTF-8' # locale for system error message # strings ...
    Laslo ForroLaslo Forro
    Jun 21, 2010 at 8:28 pm
    Jun 22, 2010 at 8:42 am
  • Hi, Index was working correctly in 8.4,I have upgraded to version 9 as I require some of the new features and now the index doesn't work. Probably something stupid I have forgotten to do when ...
    Darryl PyeDarryl Pye
    Jun 15, 2010 at 6:53 am
    Jun 21, 2010 at 8:03 pm
  • Hi. The table is table foo( id integer, x integer); and let the data be id x ===== 1 10 1 20 2 20 3 30 3 10 Now I would like to get the data in a format like this 1 , 10 20 2 , 20 3 , 10 30 where id ...
    A BA B
    Jun 17, 2010 at 3:14 pm
    Jun 17, 2010 at 3:44 pm
  • Hi all, Sorry if this question is a bit basic. I want to be able to have different PGSql db's talking to each other. So, one DB must act like a client, and be able to connect to another one. Do you ...
    PGSql UserPGSql User
    Jun 15, 2010 at 12:18 pm
    Jun 15, 2010 at 1:47 pm
  • Hello group, The following is a Hibernate generated statement, select count(*) as y0_ from view_localized_task this_ inner join TASKS nonlocaliz1_ on this_.non_localized_task_id=nonlocaliz1_.TASK_ID ...
    Sheng HuiSheng Hui
    Jun 7, 2010 at 2:48 pm
    Jun 8, 2010 at 12:51 am
  • Hello - I am new to PostgreSQL and trying to create a program to update a table, but I am getting syntax errors. Here is my program: ------------------------------------------------------------- -- ...
    Alan SimonAlan Simon
    Jun 4, 2010 at 7:08 pm
    Jun 5, 2010 at 12:42 pm
  • Okay, maybe not that simple, but is there a way to transfer a table easily between two databases? The easiest way I can think of is to back-up the table in an sql file and then run the sql file in ...
    John GageJohn Gage
    Jun 3, 2010 at 3:29 pm
    Jun 4, 2010 at 10:20 am
  • The postgres manual states: "In the default mode, statements are committed only when EXEC SQL COMMIT is issued. The embedded SQL interface also supports autocommit of transactions (similar to libpq ...
    Atif JungAtif Jung
    Jun 28, 2010 at 2:57 pm
    Jul 1, 2010 at 4:30 pm
  • Hi, We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and facing the below error while running the select queries in the application side:: ERROR: prepared statement ...
    Raghu ramRaghu ram
    Jun 28, 2010 at 9:32 pm
    Jun 29, 2010 at 7:48 am
  • I'm getting an error msg which reads: DECLARE CURSOR can only be used in transaction blocks. does that mean to DECLARE a cursor I must surrond it with a BEGIN & COMMIT work? Atif
    Atif JungAtif Jung
    Jun 28, 2010 at 11:27 am
    Jun 28, 2010 at 3:46 pm
  • On 9.0 beta 2, I have tried to prevent autostart of the database engine via the by the process shown in http://forums.enterprisedb.com/posts/list/2240.page Leaving the file in place and setting the ...
    MattKMattK
    Jun 24, 2010 at 12:45 am
    Jun 26, 2010 at 11:38 pm
  • I have some data like this 2010/06/26 Task A:started at 5:30AM:ended 6:00AM Task B:started at 5:30AM:ended 7:00AM Task C:started at 5:45AM:ended 6:00AM Task D:started at 7:30AM:ended 11:00AM ...
    Mag GamMag Gam
    Jun 26, 2010 at 9:55 pm
    Jun 26, 2010 at 10:22 pm
  • We have a Postgres database that is so huge(images are stored inside the database) that any Pg_dump configuration I tried wouldn't finish. After taking with the software vendor it was decided that ...
    Teri HolmesTeri Holmes
    Jun 24, 2010 at 12:19 am
    Jun 25, 2010 at 4:40 pm
  • I'm trying to drop an index from called t_sub_ind_1 from table t_submissions using the role update_all. The role has been granted full access privileges on the table from which the index is to be ...
    Atif JungAtif Jung
    Jun 24, 2010 at 9:44 am
    Jun 24, 2010 at 2:26 pm
  • Is it possible to grant a user 'ALL' privileges to all tables in a database in one command? Atif
    Atif JungAtif Jung
    Jun 23, 2010 at 9:10 am
    Jun 23, 2010 at 10:28 pm
  • Hi everyone, How are sequences' state dumped and transferred via pg_dump? I am dumping and restoring a database via pg_dump. In the dump file I have CREATE SEQUENCE and ALTER SEQUENCE commands. The ...
    Александър ШоповАлександър Шопов
    Jun 23, 2010 at 7:54 pm
    Jun 23, 2010 at 9:54 pm
  • The following lines inserts a row into table pending_file +1757 /* Add a row to pending_file */ +1758 EXEC SQL INSERT INTO pending_file +1759 (submission_no, orc, terminal_id, initials, user_id, ...
    Atif JungAtif Jung
    Jun 23, 2010 at 10:24 am
    Jun 23, 2010 at 12:40 pm
  • Hi, Can anyone help me get up and running on Ubuntu 64-bit Server (lucid) OS with PostgreSQL 64-bit and Python 2.6? (Please note that this is all running in a VirtualBox VM however I am not convinced ...
    Tom WilcoxTom Wilcox
    Jun 22, 2010 at 4:53 pm
    Jun 23, 2010 at 2:14 am
  • Hello there. Perhaps I'm supposed to know this, but how can I run a function on each query result in psql? I run the query select a,b from foo where x=y; and I would like to run the function bar(u,v) ...
    A BA B
    Jun 15, 2010 at 11:44 am
    Jun 15, 2010 at 12:13 pm
  • I created a global temporary table, using the following syntax: [[email protected] tmp]$ psql scott Timing is on. psql (8.4.4) Type "help" for help. scott=# create global temporary table t_emp scott-# on ...
    Mladen GogalaMladen Gogala
    Jun 13, 2010 at 8:54 am
    Jun 14, 2010 at 2:31 pm
  • Hi, there's a way to set persistently the PROMPT1 and/or PROMPT2 variables? I didn't find anything about this in man pages, i can change them once in psql, but the changes are lost once i quit. ...
    Salvatore De PaolisSalvatore De Paolis
    Jun 14, 2010 at 1:19 am
    Jun 14, 2010 at 2:11 am
  • I've been searching for a way to do transaction blocks and savepoints within a user defined c function. Apparently the docs state that if an SPI function throws an error, control goes out of the ...
    Michael HadjivassiliouMichael Hadjivassiliou
    Jun 9, 2010 at 12:55 am
    Jun 9, 2010 at 8:24 pm
  • LinkedIn ------------Jeanne Louize Emygdio requested to add you as a connection on LinkedIn: ------------------------------------------ Ammar, I'd like to add you to my professional network on ...
    Jeanne Louize EmygdioJeanne Louize Emygdio
    Jun 1, 2010 at 12:17 pm
    Jun 2, 2010 at 12:12 am
  • I have the following SPL written in plperlu which I need help with please. CREATE or replace FUNCTION validatesubmission(submission_num text) RETURNS INTEGER AS $$ $ISIS2_USER = "unknown"; $cmd = ...
    Atif JungAtif Jung
    Jun 30, 2010 at 9:00 am
    Jun 30, 2010 at 11:58 am
  • Hi list, If I give column rights to a user, I can't use a general view for him, which is normal. I read a lot about DBs and some specialists say that I must not give direct data (table) access to ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 27, 2010 at 2:36 pm
    Jun 27, 2010 at 2:51 pm
  • 1

    md5

    Hi list, As md5 isn't very safe, is it planned to introduce sha-256/sha-512)? JY -- I program, therefore I am.
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 24, 2010 at 6:26 pm
    Jun 24, 2010 at 6:34 pm
  • I was wondering if someone could comment on any good MSSQL - Postgresql migration tools? I really only need to migrate the schema. I am going from SQL 2000 to current stable postgresql. Thanks! Roy
    Morris, RoyMorris, Roy
    Jun 21, 2010 at 8:29 pm
    Jun 21, 2010 at 8:43 pm
  • In this fairly gruesome statement: "insert into public.abstract_choices (correct_ans, apache_user, descr_num, pmid, keyword, amer_term, abstr_lacking, abstr_having) select 'false', '$apache_user', ...
    John GageJohn Gage
    Jun 16, 2010 at 7:03 pm
    Jun 16, 2010 at 10:14 pm
  • I've currently built all my code in an AIX environment but now wish to debug my code in MS Visual Studio under Win XP. What ecpg software do I require to do this successfully? Thanks Atif
    Atif JungAtif Jung
    Jun 15, 2010 at 1:39 pm
    Jun 15, 2010 at 7:49 pm
  • I installed PostgreSQL on my Windows 7 64-bit machine. I set my path, classpath as follow: Path: %JAVA_HOME%\bin;%JAVA_HOME%\bin\server Classpath: C:\Program Files ...
    Kelvin LaiKelvin Lai
    Jun 14, 2010 at 7:55 pm
    Jun 14, 2010 at 7:57 pm
  • Hi list, I must build a kind of ERP and I wonder what's the best DB layout, especially about quotations/orders/delivery orders/invoices/RMAs/credit notes. It must be very scalable (say from 10 ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 12, 2010 at 8:56 pm
    Jun 14, 2010 at 2:27 pm
  • HI all I am looking for some more suggestions here on ways to use variables in sql scripts to be run on postgresql We have some Sybase reports that needs to be run against a postgresql database using ...
    Machiel RichardsMachiel Richards
    Jun 9, 2010 at 11:38 am
    Jun 9, 2010 at 11:48 am
  • Is it possible to run pl/pgsql in a script, without putting it into a function? I need to run a one-time update to my db. I could easily create a function run it and then drop it, but I’m wondering ...
    Tyler HainsTyler Hains
    Jun 8, 2010 at 10:11 pm
    Jun 8, 2010 at 10:39 pm
  • Hello all, We recently migrated one of our products from Oracle to EnterpriseDB's Advanced Server. The Oracle database has tables with BLOB data type. One example is a column where we store html ...
    Jayadevan MJayadevan M
    Jun 4, 2010 at 6:13 am
    Jun 4, 2010 at 10:16 am
  • Hi, I want to create a function in plpgsql that must execute a INSERT query on the database. The problem comes in I want to create the query inside the function. Look at the following: CREATE OR ...
    Carel CombrinkCarel Combrink
    Jun 3, 2010 at 1:48 pm
    Jun 3, 2010 at 2:05 pm
Jun 2010
12
Group Navigation
period‹ prev | Jun 2010 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions63
posts226
users72
websitepostgresql.org
irc#postgresql

72 users for June 2010

Tom Lane: 27 posts Atif Jung: 14 posts Jean-Yves F. Barbier: 14 posts Thom Brown: 13 posts Laslo Forro: 11 posts Mladen Gogala: 10 posts John Gage: 8 posts Jasen Betts: 6 posts Tim Landscheidt: 6 posts Mladen Gogala: 5 posts A B: 4 posts Andreas Kretschmer: 4 posts Andreas Kretschmer: 4 posts Coviolo: 4 posts Leif Biberg Kristensen: 4 posts Machiel Richards: 4 posts Michael Wood: 4 posts Carel Combrink: 3 posts Chris Campbell: 3 posts Deborah Fuentes: 3 posts
show more
Archives