FAQ

PostgreSQL > pgsql-sql > April 2006

Search Discussions

55 discussions - 220 posts

  • Hello, What is the easiest way to migrate a complete database from one tablespace to another? ALTER DATABASE only allows to set the default tablespace, but not migrating the existing database. ...
    Markus SchaberMarkus Schaber
    Apr 18, 2006 at 12:05 pm
    Apr 27, 2006 at 3:06 pm
  • I have a table that I created that implements a linked list. I am not an expert SQL developer and was wondering if there are known ways to traverse the linked lists. Any information that can point me ...
    Ray MadiganRay Madigan
    Apr 26, 2006 at 3:53 pm
    May 3, 2006 at 5:14 am
  • Hi, Is there any way to solve the following issue without dropping the table? select count(*) from eventplayerleaveroom; ERROR: could not access status of transaction 3164404766 DETAIL: could not ...
    Daniel CauneDaniel Caune
    Apr 24, 2006 at 6:08 pm
    Apr 24, 2006 at 9:40 pm
  • Hi, I'm trying to find which of the tables in pg_catalog contains the amount of references to a primary key, but I can't seem to find it. Google queries are also less than successful. Is it even ...
    Wiebe CazemierWiebe Cazemier
    Apr 19, 2006 at 12:27 pm
    Apr 23, 2006 at 3:35 pm
  • I've this table : create table test(] satu char(10), dua char(5) ); How could I get the Field length not the Data length ? Thanks, Rina --------------------------------- Love cheap thrills? Enjoy ...
    Louise CatherineLouise Catherine
    Apr 20, 2006 at 3:32 am
    Apr 20, 2006 at 3:44 pm
  • Here is the question: I have a situation where I need to create triggers to cascade an insert operation to many tables to maintain foreign key constraints. So at a high level INSERT INTO myTable ...
    Mark TrueMark True
    Apr 18, 2006 at 6:19 pm
    Apr 18, 2006 at 7:49 pm
  • Hi, i have run into the following problem. Let me describe the context first. When i joined the company(ies) i work for (a group of Shipping Mgmt/ Owenship/Agent companies), the only thing i was told ...
    Achilleus MantziosAchilleus Mantzios
    Apr 18, 2006 at 9:36 am
    Apr 18, 2006 at 10:41 am
  • Dear users, I have this problem I have a table where there are 20 columns named vinc1, vinc2, vinc3, vinc4, etc.... the values contained into each column are simply 1 or 0 (each column is dichotomic) ...
    Ivan marchesiniIvan marchesini
    Apr 13, 2006 at 1:16 pm
    Apr 15, 2006 at 9:56 am
  • Hi every body, somebody can show me hot to execute a query from a shell thanks in advanced!!!
    JudithJudith
    Apr 6, 2006 at 9:34 pm
    Apr 6, 2006 at 10:57 pm
  • I have a problem in a number of my tables. I'd like to add uniqueness constraints across multiple columns, but some of the columns are nullable. This gives me trouble since when I create a constraint ...
    Phillip TornrothPhillip Tornroth
    Apr 27, 2006 at 9:26 pm
    Apr 30, 2006 at 7:37 am
  • Hi, I just stumbled over a slightly confused error message: mydb=# select count(*),coverage_area from myschema.streets except select cd as coverage_area from countryref.disks group by ...
    Markus SchaberMarkus Schaber
    Apr 28, 2006 at 3:59 pm
    Apr 28, 2006 at 7:02 pm
  • Is there a reasonable way to extract a list of all tables which contain a specific column name from the system views on 8.1? For instance, I might want to enumerate all tables with a column named ...
    Jeff FrostJeff Frost
    Apr 21, 2006 at 4:29 pm
    Apr 22, 2006 at 9:42 pm
  • inventory= SELECT cabinets_name, cabinets_description FROM cabinets WHERE cabinets_datacenters = 2; cabinets_name | cabinets_description ---------------+---------------------- 548-4th-Cab2 | ...
    Neil HarkinsNeil Harkins
    Apr 10, 2006 at 9:37 pm
    Apr 10, 2006 at 11:36 pm
  • I have a need to copy/update data from one column to another, based on a join condition. Is this easy to do in pure SQL? I have google'ed without luck for a easy solution (that's not Microsoft ...
    Bryce NesbittBryce Nesbitt
    Apr 7, 2006 at 8:32 pm
    Apr 7, 2006 at 10:24 pm
  • dear all, i want to encrypt and decrypt one of the fields in my table (i.e-passwordfield) i have searched and with the help of pgcrypto package, using function "crypt", i am able to encrypt my data, ...
    AKHILESH GUPTAAKHILESH GUPTA
    Apr 6, 2006 at 8:23 am
    Apr 6, 2006 at 10:24 pm
  • Hello, I have a function get_xy that returns a composite type with columns "x" and "y". I would like to SELECT these as well as some data from a table, like so: SELECT ...
    Michael BurkeMichael Burke
    Apr 5, 2006 at 4:27 pm
    Apr 6, 2006 at 12:45 pm
  • I have a table that I created that implements a linked list. I am not an expert SQL developer and was wondering if there are known ways to traverse the linked lists. The table contains many linked ...
    Ray MadiganRay Madigan
    Apr 26, 2006 at 2:52 am
    May 1, 2006 at 4:49 am
  • Hello! I am a longtime postgres user (started around 10 years ago), however, as for some years I've been using it mostly as administrator. Now that I have started a project and doing some SQL, I've ...
    EmilsEmils
    Apr 28, 2006 at 1:24 pm
    Apr 29, 2006 at 8:33 am
  • Hi Please spare some time to provide a solution for the described problem : I am using set returning functions to return all the records from a table named pss , But what I am getting is the first ...
    Penchalaiah P.Penchalaiah P.
    Apr 28, 2006 at 10:35 am
    Apr 28, 2006 at 3:25 pm
  • I have a type, declared like this: CREATE TYPE type_a AS ( member_a varchar, member_b bool ); There is also a table: CREATE TABLE table_a ( col_a varchar, col_b bool, col_c int4 ); Now, in a ...
    Mario SplivaloMario Splivalo
    Apr 25, 2006 at 12:03 pm
    Apr 25, 2006 at 12:42 pm
  • How do you add null values to a date array? update dattable set insDate = '{04/12/2006,'null'} <-- doesn't work update dattable set insDate= '{04/12/2006,null}' <-- doesn't work update dattable set ...
    A. R. Van HookA. R. Van Hook
    Apr 23, 2006 at 4:18 pm
    Apr 24, 2006 at 8:55 pm
  • Hi If I can not do insert/update action with on select rule, how can I execute some procedure or any sql statement on select event? WBR
    Sergey LevchenkoSergey Levchenko
    Apr 13, 2006 at 3:46 pm
    Apr 14, 2006 at 7:52 am
  • Hi all, I have been working on converting our Informix DB to PostgreSQL. There are some differences with SQL syntax. I have done many outer conversion so far, but all has either one outer or simple ...
    GurkanGurkan
    Apr 12, 2006 at 6:45 pm
    Apr 12, 2006 at 8:01 pm
  • Hello All, I have been having a really hard time trying to come up with a pl/pgsql recursive function to returns the end nodes of a tree. Here is an example table definition: CREATE TABLE ...
    MikeMike
    Apr 10, 2006 at 3:17 pm
    Apr 11, 2006 at 6:00 pm
  • I'm still searching through Google and whatnot, but not finding anything off the bat ... is there some way of creating a 'REVERSE INDEX' on a column in a table? For instance, when I do a 'CLUSTER' to ...
    Marc G. FournierMarc G. Fournier
    Apr 5, 2006 at 6:14 pm
    Apr 5, 2006 at 7:14 pm
  • any one can help me how to get multiple rows in postgresql using arrays in functions Thanks & Regards Penchal reddy | Software Engineer Infinite Computer Solutions | Exciting Times...Infinite ...
    Penchalaiah P.Penchalaiah P.
    Apr 27, 2006 at 12:31 pm
    Apr 27, 2006 at 4:11 pm
  • Hello Willem, if its not too much data you could do an select * from table an store the result in an array of rows. Then you can iterate over it. If this is too bloated then create a cursor with: ...
    Florian ReiserFlorian Reiser
    Apr 20, 2006 at 12:35 pm
    Apr 22, 2006 at 8:47 am
  • Hi! I'm currently porting a rather complex application from PostgreSQL 7.4.x to 8.1.3 and I'm having problems with changed semantics of the trigger functionality. The problem is quite complex and I'm ...
    Andreas HaumerAndreas Haumer
    Apr 21, 2006 at 12:31 pm
    Apr 21, 2006 at 9:32 pm
  • Hi, I have, what I hope to be, a simple question about plpgsql. I have a trigger on a table right now that updates a count everytime that a new record is entered into a database (or removed). What ...
    Todd KennedyTodd Kennedy
    Apr 14, 2006 at 3:38 am
    Apr 14, 2006 at 9:16 am
  • Hello, I wonder if there is an issue with the string 'NL'. In my application NL stands for Netherlands and is thus a country code abreviation. The query SELECT COUNT(*) FROM Table WHERE Field1 = 'NL' ...
    Vellinga, FredVellinga, Fred
    Apr 4, 2006 at 8:40 am
    Apr 13, 2006 at 6:44 am
  • [PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.1] I'm starting to use lots of foreign key constraints to keep my data clean. In one case, however, I need to allow null values ...
    George YoungGeorge Young
    Apr 13, 2006 at 1:11 am
    Apr 13, 2006 at 1:26 am
  • G'day, Looking for an example showing how to return a set from either a sql function or a plpsqq function. Thanks -- Keith Hutchison http://balance-infosystems.com http://realopen.org ...
    Keith HutchisonKeith Hutchison
    Apr 8, 2006 at 9:10 pm
    Apr 10, 2006 at 3:09 pm
  • Greetings, I've encountered a strange problem. We have a PG 8.0.x database cluster (in the sense used in initdb, i.e. bunch of databases) created with UNICODE encoding, namely cs_CZ.UTF-8 locale. ...
    Tomas VondraTomas Vondra
    Apr 5, 2006 at 10:35 pm
    Apr 5, 2006 at 11:03 pm
  • I orginally sent this email to the [novice] list but did not get any response. I am look for help in developing a query that will return the nearest process record that was logged at or after each ...
    Richard Broersma JrRichard Broersma Jr
    Apr 5, 2006 at 12:58 am
    Apr 5, 2006 at 4:37 am
  • Hi, I'm relatively stretched when it comes to SQL but I'm getting there. I have a question though: Thanks to various web sites I've succeeded in creating simple cross tables in PostgreSQL. I'm now ...
    Ross JohnsonRoss Johnson
    Apr 2, 2006 at 6:44 am
    Apr 2, 2006 at 12:15 pm
  • I'm trying to do a simple query and I'm not sure how to get it to work: SELECT SUM(x0 + y0 + z0) / SUM(x2 + y2) AS A1, SUM(x1 + y1 + z1) / SUM(x3 + y3) AS A2 FROM test Problems: 1. All variables are ...
    VinceVince
    Apr 1, 2006 at 6:10 am
    Apr 1, 2006 at 6:34 am
  • Hello, I use postgres 8.1 and trie to run jboss over sequoia-ha (http://sequoia.continuent.org/HomePage). But i have an problem with sequences. Sequoia claims to support for good reasons and ...
    Schnabl, SebastianSchnabl, Sebastian
    Apr 27, 2006 at 8:06 am
    May 8, 2006 at 9:24 pm
  • Comming back after SELECTing into usertypes, is there a nice way to insert data into table from usertype, in a nice way? For instance, I have table like this: CREATE TABLE tblA ( id int4, key ...
    Mario SplivaloMario Splivalo
    Apr 27, 2006 at 4:09 pm
    Apr 27, 2006 at 4:34 pm
  • I've been trawling the net trying to find an answer to this, so sorry if this is a common problem - I have tried looking before posting! My problem is that when trying to SELECT a timestamp using "AT ...
    John GossJohn Goss
    Apr 20, 2006 at 1:31 pm
    Apr 20, 2006 at 4:20 pm
  • Here Question : I have table A with structure : Number Character(20), Description Character(50) I want to get length of field Number (20) What is syntax sql to get length of field ? thx ...
    Mariya YuniartiMariya Yuniarti
    Apr 20, 2006 at 7:37 am
    Apr 20, 2006 at 3:22 pm
  • Hi is there a way wherein I can interface the pg_dump of PostgreSQL Server in Visual basic. I mean for example I want to backup Databases "DB1", "BD12", "DB3" using pg_dump Thank You, Ian I choose ...
    Christian Paul B. CosinasChristian Paul B. Cosinas
    Apr 20, 2006 at 3:33 am
    Apr 20, 2006 at 4:31 am
  • Is it possible to create a temporary table within a rule? I get a syntax error near 'CREATE TEMPORARY TABLE' if I try to do the following: CREATE RULE id_insert_rule AS ON INSERT TO id_insert DO ...
    Ron PetersonRon Peterson
    Apr 18, 2006 at 7:14 pm
    Apr 18, 2006 at 7:53 pm
  • I'm stucked.. Say a car travels from X to Y then from Y to Z (and then from Z back to X but that's not relevant here). In the table below are the timestamps for each point in various dates. The ...
    Timo TuomiTimo Tuomi
    Apr 11, 2006 at 9:34 am
    Apr 17, 2006 at 7:57 pm
  • I have a slow sql: SELECT * FROM mytable WHERE id IN (1,3,5,7,....3k here...); mytable is about 10k rows. if don't use the "IN" clause, it will cost 0,11 second, otherwise it will cost 2.x second I ...
    FavoyangFavoyang
    Apr 10, 2006 at 3:44 am
    Apr 11, 2006 at 8:52 pm
  • I have a function that returns a row from a table, e.g.: create table foo (a integer); create function f_foo (integer) returns foo language 'sql' as $foo$ select * from foo where a = $1 limit 1 $foo$ ...
    Jeff BoesJeff Boes
    Apr 7, 2006 at 9:08 pm
    Apr 11, 2006 at 11:42 am
  • Folks, In v8.0.3 documentation, plperl, plpython and pltcl allow declaration of variables that are global and persistent within a session. begin_quote 37.4. Global Values in PL/Perl You can use the ...
    Dave BathDave Bath
    Apr 11, 2006 at 2:17 am
    Apr 11, 2006 at 5:15 am
  • I would like to model some hierarchical (tree) data in PostgreSQL. Where can I find high quality Nested Set (or Nested Interval) source code and documentation? I know this question gets asked a lot. ...
    Daniel BrowningDaniel Browning
    Apr 7, 2006 at 7:28 am
    Apr 10, 2006 at 1:14 am
  • Hello all, Is the use of IF statement restrict to Functions and Store Procedures? I'm trying to use an IF within Select... Example: create view v1 as select c1, c2, if c3 = 52 then 0 else 1 endif as ...
    Renato CramerRenato Cramer
    Apr 5, 2006 at 4:59 pm
    Apr 5, 2006 at 5:04 pm
  • This is PostgreSQL 7.4 (long story). I have a table, registrars, which has, among other things, note_id integer references notes The notes table has, among other things, note_id integer default ...
    Paul M FosterPaul M Foster
    Apr 3, 2006 at 3:43 am
    Apr 3, 2006 at 3:57 am
  • ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
    Marc G. FournierMarc G. Fournier
    Apr 29, 2006 at 5:33 pm
    Apr 29, 2006 at 5:33 pm
Apr 2006
12
Group Navigation
period‹ prev | Apr 2006 | next ›
Group Overview
grouppgsql-sql @
categoriespostgresql
discussions55
posts220
users86
websitepostgresql.org
irc#postgresql

86 users for April 2006

Tom Lane: 23 posts Markus Schaber: 20 posts Stephan Szabo: 8 posts Bruno Wolff III: 7 posts Alvaro Herrera: 6 posts Eugene E.: 6 posts Ross Johnson: 6 posts Andreas Kretschmer: 5 posts Wiebe Cazemier: 5 posts Andreas Kretschmer: 4 posts Bryce Nesbitt: 4 posts Daniel Caune: 4 posts Gurkan: 3 posts Achilleus Mantzios: 3 posts Ben K.: 3 posts Ivan marchesini: 3 posts Jeff Frost: 3 posts Jim C. Nasby: 3 posts Marc G. Fournier: 3 posts Mario Splivalo: 3 posts
show more
Archives