FAQ

Search Discussions

37 discussions - 126 posts

  • Greetings, I've got an interesting problem. I have a table with a column full of timestamps. I need a means of returning only the rows which have a timestamp that falls after the last 16:00 and ...
    Lonni J FriedmanLonni J Friedman
    Oct 5, 2007 at 10:47 pm
    Oct 8, 2007 at 1:37 pm
  • It seems to me this ought to be simple and clearly documented but I've spent hours researching and experimenting to no avail. PROBLEM: Entering accented characters in psql often results in the error: ...
    John GuntherJohn Gunther
    Oct 12, 2007 at 4:13 pm
    Feb 27, 2008 at 8:22 pm
  • Hi Tom, You are right. If I try to ping 127.0.0.1, it gives destination unreachable. Something seriously wrong with network configuration. ********* # ping 127.0.0.1 ICMP Host Unreachable from ...
    Durgaprasad PawarDurgaprasad Pawar
    Oct 30, 2007 at 5:06 pm
    Oct 31, 2007 at 10:41 pm
  • Hello, I am new to Postgres and have an embarassingly simple question. I am running v8.2 on Windows Vista although I don't think that has any bearing on the answer. create table test (col1 int, col2 ...
    Tore LukashaugenTore Lukashaugen
    Oct 3, 2007 at 6:24 pm
    Oct 5, 2007 at 11:19 pm
  • I am attempting to build postgresql from source because there is a clear need on our system to place the directories in the default location, /usr/local/pgsql, while my distro places them in ...
    G. J. WalshG. J. Walsh
    Oct 25, 2007 at 12:24 am
    Oct 26, 2007 at 6:59 pm
  • I am trying to design some tables that have keys that look like: ASDF-#### where #### should be derived from a sequence. However, I would like the primary key to be an integer for speed of indexing, ...
    Sean DavisSean Davis
    Oct 10, 2007 at 12:18 pm
    Oct 10, 2007 at 4:07 pm
  • I am trying to get Daylight Savings Time working for the EAST Brazilian time zone. In Brazil for 2007, the DST change occurs on Oct. 13-14. I tried setting the DB to each of the following time zones ...
    Wright, GeorgeWright, George
    Oct 1, 2007 at 5:26 pm
    Oct 2, 2007 at 2:33 pm
  • Hi, I am experiencing a strange problem with createdb. It gives following error message. *********** bin # ./createdb -U dpgres -p 9999 -h 127.0.0.1 -q mydb createdb: could not connect to database ...
    Durgaprasad PawarDurgaprasad Pawar
    Oct 30, 2007 at 10:08 am
    Oct 30, 2007 at 3:22 pm
  • Good Morning, I know that question is going to be stupid for some of you. Which could be the difference of size between the same table on Postgresql and on Mysql ? Tables are exactly the same : same ...
    Cedric BUSCHINICedric BUSCHINI
    Oct 25, 2007 at 6:29 am
    Oct 25, 2007 at 7:34 am
  • Hi, Would someone be able to assist with the following Postgres Query. select t.id,q.name,t.subject,u.name,t.status,t.created,t.resolved,ov.content,ov.created as Updated from tickets t, queues q, ...
    Tony WadeTony Wade
    Oct 23, 2007 at 10:34 pm
    Oct 24, 2007 at 1:23 pm
  • Hi! OK, I'm new to pgsql but would like to implement a updateable, "temporal" view. By "temporal" I mean that the table has fields for start and end time of the row's validity. The view on the table ...
    Hans-Peter OeriHans-Peter Oeri
    Oct 16, 2007 at 9:23 pm
    Oct 17, 2007 at 2:19 pm
  • Applications that interactively display table information like web clients and gui applications, normally would have to cache the data in the table rows being displayed (e.g. have copies), that could ...
    Syan tanSyan tan
    Oct 13, 2007 at 2:21 am
    Oct 13, 2007 at 4:34 am
  • I'm probably just being a numpty, but I can't seem to get arguments with PG_GETARG_CSTRING. I would much appreciate it if someone could point me in the right direction! The following code is simply ...
    Brett MatonBrett Maton
    Oct 12, 2007 at 11:49 am
    Oct 12, 2007 at 4:24 pm
  • I'm not sure if this is the right forum for this question, so I'll start here and escalate as necessary. One of the things I do a lot is copy large tables from one database to another. I'd started ...
    Brian HurtBrian Hurt
    Oct 22, 2007 at 7:44 pm
    Nov 26, 2007 at 4:09 pm
  • Hello, All. Is there any graphical tool (for ex, similar to Diagrams on Enterprise Manager - Sql Server) for the PostGres Database ? The only one I know is PGAdmin which , AFAIK, cannot be used to ...
    Oliveiros CristinaOliveiros Cristina
    Oct 29, 2007 at 3:52 pm
    Nov 3, 2007 at 10:02 am
  • Creating a database where monetary values will be stored and of course retrieved with calculations. What data types are best to use in this sort of environment? money is limited in quantity numeric - ...
    Niccguard-devNiccguard-dev
    Oct 31, 2007 at 9:15 pm
    Nov 1, 2007 at 4:26 am
  • Hi - I wanted to follow up on the thread opened by Jessica Richards on granting read only permissions. Basically it sounded like there were two options: 1. granting select on each table 2. alter user ...
    Mija LeeMija Lee
    Oct 26, 2007 at 7:55 pm
    Oct 27, 2007 at 12:09 am
  • Hi All, I could not find any information about this simple question. How can I understand who is connected to a given database? How can I kill all connections to a database in order, for example, to ...
    Nikolai CheltsovNikolai Cheltsov
    Oct 18, 2007 at 9:34 am
    Oct 18, 2007 at 10:48 am
  • Hi, I've read through the relevant documentation on distributed transactions for PostgreSQL 8.2.5 but it leaves me with more questions than answers. It is unclear to me how SQL statements can be ...
    Brian Oki (boki)Brian Oki (boki)
    Oct 10, 2007 at 11:23 pm
    Oct 11, 2007 at 12:35 am
  • Hi, I installed binaries on a sun box using packages dlded off sun's site. The version is 8.1.4. How can i know whether i am running in 32 or 64 bit? SELECT version() ; does not show this. postgres=# ...
    Justin VassalloJustin Vassallo
    Oct 9, 2007 at 5:56 pm
    Oct 10, 2007 at 2:49 am
  • Hello - PG v8.2 I have a number of fields in tables with a unique constraint defined on them resulting in the creation of an implicit btree index on the field. Does PG use this implicit index in ...
    David MonarchiDavid Monarchi
    Oct 2, 2007 at 10:34 pm
    Oct 2, 2007 at 11:21 pm
  • There has to be an easy way to do this and I'm just being stupid and missing it. What I want to do is, in plpgsql, insert a record (of the right type) into a table without having to list all the ...
    Brian HurtBrian Hurt
    Oct 26, 2007 at 5:25 pm
    Oct 26, 2007 at 7:16 pm
  • Hello I was looking for a way to have new changes made to template1 affect currently existing databases. We have a new function that I want available to all databases on our cluster, but don't want ...
    Mija LeeMija Lee
    Oct 25, 2007 at 3:30 pm
    Oct 25, 2007 at 4:14 pm
  • Hi, Is there a possibility to delete a DB, when there are still connections to it? Something like force delete. Delete and if there are connections, kill them! Regards, Nikolay Cheltsov
    Nikolai CheltsovNikolai Cheltsov
    Oct 24, 2007 at 3:16 pm
    Oct 24, 2007 at 3:43 pm
  • PG v 8.2 Hello - I believe the date a table is defined is stored in one of the system catalogs. I've looked through Chapter 43 in the documentation, but I am unable to identify which catalog contains ...
    David MonarchiDavid Monarchi
    Oct 24, 2007 at 2:17 am
    Oct 24, 2007 at 2:39 am
  • I'm wondering if there is a query I could run to detect long-running transactions? Basically, I want to know all transactions (either on a given server or just on a given database) that have been ...
    Brian HurtBrian Hurt
    Oct 22, 2007 at 2:47 pm
    Oct 22, 2007 at 4:00 pm
  • I have an sql question. I need to be able to search for text which may have buried single-quotes. I need to be able to effectively ignore the single-quote in the WHERE clause. Here is an example of ...
    Dale SeaburgDale Seaburg
    Oct 21, 2007 at 4:25 am
    Oct 21, 2007 at 12:45 pm
  • Hi, Here is my code: INSERT INTO location_types (lo_location_type_id, lo_location_type) VALUES (3, 'region'); Somehow, variants of this statement generate strange error messages. This one gets ERROR: ...
    Mary AndersonMary Anderson
    Oct 18, 2007 at 11:45 pm
    Oct 19, 2007 at 12:22 am
  • Dear PostgreSQL users, I'm running postgreSQL 8.1 (installed with YaST) on a Suse 10.2 machine. My $PGDATA variable is /home/postgres/data When I initiate the databases with initdb without argument. ...
    Sylvain BroheeSylvain Brohee
    Oct 18, 2007 at 1:14 pm
    Oct 18, 2007 at 2:10 pm
  • Hi, I have a table with 46 million rows, when I execute the following statement on it, I get an error: ALTER TABLE ONLY etefas.tbl_ecu ADD CONSTRAINT pk_tbl_ecu PRIMARY KEY (pk_ecu); HINWEIS: ALTER ...
    Oeschey, Lars (I/EK-142, extern)Oeschey, Lars (I/EK-142, extern)
    Oct 17, 2007 at 2:46 pm
    Oct 17, 2007 at 4:13 pm
  • Hi, I know that in Sql Server, Stored Procedures are compiled only once and then the same execution plan is utilized. This definitely gives a tremendous performance boost when Stored Procedures are ...
    Jasbinder Singh BaliJasbinder Singh Bali
    Oct 16, 2007 at 6:18 am
    Oct 16, 2007 at 5:15 pm
  • Hi Again, I'm trying to return a "row" from the following function, I'm not sure what I'm missing or doing wrong but when I call it I get this error message: ERROR: array value must start with "{" or ...
    Brett MatonBrett Maton
    Oct 15, 2007 at 7:19 am
    Oct 15, 2007 at 9:53 am
  • Tom, Wouldn't you be describing a Linux-specific issue, though? And possibly kernel-specific? It's hard to reconcile this with the real-world performance of PostgreSQL on NFS, which is happening all ...
    Josh BerkusJosh Berkus
    Oct 1, 2007 at 5:19 pm
    Oct 1, 2007 at 5:28 pm
  • Hello, I am evaluating the possibility to port several applications from Sybase ASE. Reading the PostgreSQL manual, (and getting a very good feeling about PostGreSQL, I must say) it seems reasonably ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Oct 26, 2007 at 6:44 pm
    Oct 26, 2007 at 6:44 pm
  • As I am not sure how to execute this function(is there analog of DUAL table in Oracle), I am using something like this; SELECT pg_cancel_backend(15429) FROM pg_stat_activity; The result is; ERROR: ...
    Nikolai CheltsovNikolai Cheltsov
    Oct 18, 2007 at 10:38 am
    Oct 18, 2007 at 10:38 am
  • Hi, we need to run a second instance of PostgreSQL on one machine (RHEL5). What I did: made a /var/lib/pgsql2 directory made a new link /usr/bin/postmaster2 - postgres edited ...
    Oeschey, Lars (I/EK-142, extern)Oeschey, Lars (I/EK-142, extern)
    Oct 12, 2007 at 1:57 pm
    Oct 12, 2007 at 1:57 pm
  • We got a new instrument which stores our sample info in a database (vendor is useless, PostgreSQL 8.0, pgAdmin III 1.2.2, Win XP, only exe's in folder pg_dump and pg_restore). I would like to modeify ...
    Sandy_mcdSandy_mcd
    Oct 2, 2007 at 3:39 am
    Oct 2, 2007 at 3:39 am
Group Navigation
period‹ prev | Oct 2007 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions37
posts126
users44
websitepostgresql.org
irc#postgresql

44 users for October 2007

Tom Lane: 19 posts Michael Glaesemann: 10 posts Wright, George: 8 posts Andreas Kretschmer: 6 posts Nis Jørgensen: 6 posts Brett Maton: 5 posts Lonni J Friedman: 5 posts Brian Hurt: 4 posts Valentin Gjorgjioski: 4 posts Cedric BUSCHINI: 3 posts G. J. Walsh: 3 posts John Gunther: 3 posts Mija Lee: 3 posts Nikolai Cheltsov: 3 posts Richard Broersma Jr: 3 posts Sean Davis: 3 posts Syan Tan: 3 posts David Monarchi: 2 posts Durgaprasad Pawar: 2 posts Greg Sabino Mullane: 2 posts
show more
Archives