dbTalk Databases Forums  

Sponsored Links


mailing.database.pgsql-sql mailing.database.pgsql-sql


Discuss in the mailing.database.pgsql-sql forum.



Post New Thread
Threads in Forum : mailing.database.pgsql-sql Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
what is the best performance / best practices for frequently-used simple dml, for example, an insert 1. fast-interface 2. prepared statement calling...
chester c young
06-27-2011 08:40 AM
Pavel Stehule Go to last post
7 24
Hi, I have a SELECT statement that is using the regexp_split_to_table function as follows: .... and fk_topic in (select...
John Fabiani
06-23-2011 11:45 AM
John Fabiani Go to last post
1 27
the database collation is: en_US.UTF-8 drop table t1; create table t1 (recid int ,f1 varchar(20)); insert into t1 values (1,'a'); insert into t1...
Eyal Wilde
06-23-2011 02:18 AM
Pavel Stehule Go to last post
15 37
Hi, I've got a table with a couple of objects. Primary key object_id. There is a function that fetches some values from another table that relate...
Andreas
06-20-2011 10:56 PM
Pavel Stehule Go to last post
1 21
Hi, I am totally new to PostgreSQL and this is my first script. Can anyone please help me with my following requirement I have script that returns ...
Tripura
06-20-2011 12:05 PM
Ross J. Reedstrom Go to last post
4 26
hi, please see this code select aiah_number.aiah_number_id, aiah_number.aiah_number, lock.lock_status, rank.rank_value, approve.approve_status,...
hatem gamal elzanaty
06-20-2011 08:29 AM
Emi Lu Go to last post
2 18
Hi, I am new to postgre sql.I need to convert sqlite datbase to postgres database.i have nearly 15 table in my sqlite database in which 3 table...
sara vanan
06-16-2011 05:08 PM
Viktor Bojović Go to last post
1 32
I have a fact table that looks like this: dim1_fk bigint, time_fk bigint, tstamp timestamp without timezone value numeric(16,2) The tstamp column...
Samuel Gendler
06-15-2011 03:52 PM
Samuel Gendler Go to last post
1 21
Hi! Although I try for some time, I am not able to write an SQL-Query that can do the following: I have a very big table (let's call it "mytable")...
Jira, Marcel
06-15-2011 11:49 AM
Oliveiros d'Azevedo Cristina Go to last post
3 20
This is a follow-up to an old message by Tom Lane: http://archives.postgresql.org/pgsql-sql/2006-10/msg00080.php In ORMs like NHibernate, there are...
Patrick Earl
06-14-2011 08:01 PM
greg.fenton Go to last post
1 37
Can anybody tell me why this doesn't work? pgslekt=> CREATE SEQUENCE sources_source_id_seq START WITH (SELECT MAX(source_id) FROM sources); ERROR: ...
Leif Biberg Kristensen
06-14-2011 09:00 AM
Florian Weimer Go to last post
9 20
I have a table that, at a minimum, has ID and timestamp columns. Records are inserted into with random IDs and timestamps. Duplicate IDs are...
lists-pgsql@useunix.net
06-12-2011 04:50 PM
Gavin Flower Go to last post
15 33
Hey folks, I am still slogging away on my pet project, and I'm giving up - I need help from the experts to try to get this function working like I...
C. Bensend
06-11-2011 05:18 PM
C. Bensend Go to last post
2 22
Good morning, String array compare command, I forgot how to do it. E.g., create table z_drop(id varchar); insert into z_drop values('{"a1", "a2",...
Emi Lu
06-11-2011 04:59 AM
Jasen Betts Go to last post
1 25
hi, I have a log-table that stores events of users and projects like this ( user_id integer, project_id integer, ts timestamp, event_type integer...
Andreas
06-09-2011 04:22 PM
Edgardo Portal Go to last post
6 22
Hello , do you know how to find a process that is locking a table ? I try to run a vacuum analyze , an it take a state of waiting , I canceled it...
manuel antonio ochoa
06-06-2011 06:21 PM
Scott Marlowe Go to last post
1 25
Is there a way in post-9.0 postgres for one session to determine if a LISTEN channel currently has a backend registered to receive notifications?...
James Robinson
06-01-2011 05:22 PM
Greg Sabino Mullane Go to last post
1 24
postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new install) I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and...
Dean le Roux
06-01-2011 10:00 AM
Dean le Roux Go to last post
4 28
Can procedural languages be used in rules? I didn't see any examples in the documentation that suggested something like this could be done using...
Kevin Crain
05-31-2011 09:46 AM
Kevin Crain Go to last post
1 22
Hi all, I need to write a function that totally empty a schema. So I have written a TRUNCATE statement for each table and set to 0...
Surfing
05-30-2011 09:45 AM
Rob Sargent Go to last post
4 23
On Fri, May 27, 2011 at 9:15 AM, Emi Lu <emilu (AT) encs (DOT) concordia.ca> wrote: You asked about the "most efficient" but you didn't tell us...
Samuel Gendler
05-28-2011 02:58 AM
Piotr Czekalski Go to last post
1 19
A column contains location information, which may contain any of the following: 1) null 2) country name (e.g. "France") 3) city name, region name...
Tarlika Elisabeth Schmitz
05-26-2011 03:40 PM
Tarlika Elisabeth Schmitz Go to last post
15 38
Hello, To save pdf files into postgresql8.3, what is the best column type? bytea, blob, etc? Thank you, Emi --
Emi Lu
05-26-2011 01:07 PM
Ross J. Reedstrom Go to last post
13 31
Hi, Are there any guidelines for deciding whether to 1) create an enum data type or 2) create a table with the set of values and then have...
Seb
05-25-2011 06:08 PM
Seb Go to last post
2 25
Would you mind try: Select VehicleTrimAbbreviated, VehicleTrimAbbreviatedId from VehicleTrimAbbreviated Where vehicleTrimAbbreviated like...
Emi Lu
05-25-2011 05:18 PM
Ozer, Pam Go to last post
15 46
Hi, is there a reason why Not IN-performance is so poor in 9.0.4 compared to 8.4? Ty Jasmin
Jasmin Dizdarevic
05-25-2011 02:49 PM
Robert Haas Go to last post
9 23
I trying to get the next one : pg_dump -h 192.170.1.3 -U User --format custom --inserts --verbose --file \"/root/Desktop/$name .backup\" --table...
manuel antonio ochoa
05-24-2011 09:07 PM
Craig Ringer Go to last post
2 24
The tools "pg_dump" & "pg_restore" are used to extract and re-create databases. Can be used for chores such as deploying from development to...
Basil Bourque
05-24-2011 08:56 PM
Craig Ringer Go to last post
5 23
I have a couple of questions regarding unnest. 1) If I issue a select statement "select unnest(vector1) as v from some_table", I cannot seem to use...
Karl Koster
05-21-2011 10:23 PM
Craig Ringer Go to last post
2 57
Hello, Postgresql8.3, tried: create table test(id, image oid); insert into test values(1, lo_import('apple.jpg')); ERROR: must be superuser to...
Emi Lu
05-18-2011 09:02 PM
Craig Ringer Go to last post
1 31
I have the following tables (individual seat allocation removed to make it simpler) create table coaches ( -- carriages c_id serial...
Gary Stainburn
05-18-2011 07:09 PM
David W Noon Go to last post
1 26
Hi, This probably reflects my confusion with how self joins work. Suppose we have this table: =# SELECT * FROM tmp; a | b ---+--- 1 | 2
Seb
05-17-2011 04:07 AM
Jasen Betts Go to last post
6 35
Hi, I am looking for a way to sort data returned from two tables with the first sort based on a field from table A and the secord sort based on the...
R. Smith
05-14-2011 07:58 AM
Oliver d'Azevedo Christina Go to last post
1 30
Hi all, I have this table id | date | score_count ----+--------------+------------- 13 | 1999-09-16 | 4 13 | 2002-06-27 | ...
Nguyen,Diep T
05-12-2011 05:18 PM
Samuel Gendler Go to last post
2 36
We are converting from Oracle to Postgres. An Oracle script contains this line: select replace(firstname,'"'), memberid, emailaddress from...
Tony Capobianco
05-11-2011 03:53 PM
Lew Go to last post
6 30
Hi, Maybe this is a dumb question but if I have a date field that contains a NULL will it show up when I ask for a where date range for the same date...
John Fabiani
05-10-2011 12:55 PM
Lew Go to last post
9 31
Hi there I am trying to get an example of SET BASED trigger logic with FOR EACH STATEMENT, but I cannot find any example involving the pseudo table...
F. BROUARD / SQLpro
05-09-2011 05:18 AM
Pavel Stehule Go to last post
2 25
Hi, When working with psql via sql.el, multiple prompts accumulate in a single line when sending multi-line input to the SQLi buffer. For example,...
Seb
05-07-2011 05:33 PM
Seb Go to last post
4 32
Hi, I'm playing around with 9.1beta1 and would like to create a table where one column has a non-default collation. But whatever I try, I can't...
Thomas Kellerer
05-07-2011 03:12 PM
Thomas Kellerer Go to last post
4 19
On Thu, May 5, 2011 at 11:06 PM, Tarlika Elisabeth Schmitz <postgresql3 (AT) numerixtechnology (DOT) de> wrote: You need another level of...
Scott Marlowe
05-07-2011 07:52 AM
Lew Go to last post
1 27
I have got a database that needs to be populated, first with historical data, then on a daily basis. Number of entities is small, data volume huge....
Tarlika Elisabeth Schmitz
05-07-2011 04:39 AM
Tarlika Elisabeth Schmitz Go to last post
3 39
Excuse me, The original table is: order*** ID*** value*** ---------------------- 1*** 1000*** 3 2*** 1000*** 5 3*** 1000*** 6 1*** 1001*** 1 2***...
Claudio Adriano Guarracino
05-06-2011 12:41 AM
Claudio Adriano Guarracino Go to last post
2 25
Hello! I have a doubt about a query that I tried to do, but I cant...... This is the scenario: I have a table, with this rows: order*** ID***...
Claudio Adriano Guarracino
05-05-2011 03:24 PM
Oliveiros Go to last post
1 27
Hello, ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple way to get row_number select row_number(), col1, col2... FROM ...
Emi Lu
05-04-2011 12:28 AM
Andreas Kretschmer Go to last post
4 26
I know that BIT and BIT VARYING types were deleted from SQL:2003 and there are "old new" BINARY, BINARY VARYING in SQL:2008. I have two question: 1)...
Grzegorz Szpetkowski
05-03-2011 07:41 AM
Grzegorz Szpetkowski Go to last post
2 39
Hello everybody ! I want to know if I could share PLpgSQL variables between different functions and within different calls just using memory (not...
Charles N. Charotti
05-03-2011 06:01 AM
Viktor Bojović Go to last post
3 21
On 2011-04-15, LaraK <indarija (AT) gmx (DOT) net> wrote: if I undestand your goal correctly you want to subtract the daylight savings offset from...
Jasen Betts
05-03-2011 02:15 AM
LaraK Go to last post
3 26
Good morning !! How can I solve this problem : FATAL: invalid cache id: 19 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system...
manuel antonio ochoa
05-02-2011 11:25 AM
Tom Lane Go to last post
1 26
Hi. I just tried to make a query that traverses a tree upwards to locate the root and then downwards to locate all branches on PGSQL 9.0. The two...
Svenne Krap
05-01-2011 10:18 PM
Svenne Krap Go to last post
2 29
Hi guys, I need your help. I have a table called medidas, in this table i have some ocurrences that has id_medida(primary key) id_ponto (sec_key) and...
Saulo Venncio
04-21-2011 06:15 PM
Jasen Betts Go to last post
2 32
Post New Thread

Display Options
Showing threads 451 to 500 of 3171
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.