Search Discussions

202 discussions - 951 posts

  • to_timestamp() returns a TIMESTAMP WITH TIME ZONE Perhaps an alternative that returns a TIMESTAMP WITHOUT TIME ZONE (which, BTW, is the default TIMESTAMP) should be provided. Elsewhere, there is no ...
    Hernan gonzalezHernan gonzalez
    Jun 23, 2011 at 4:02 pm
    Jun 27, 2011 at 3:01 pm
  • Hello. I need to create an auto-increment field on a table WITHOUT using sequences: CREATE TABLE tbl( name TEXT, uniq_id INTEGER ); Each INSERT to this table must generate a new uniq_id which is ...
    Dmitry KoterovDmitry Koterov
    Jun 30, 2011 at 6:21 pm
    Jul 4, 2011 at 9:12 am
  • I have two tables, town and townalias, the latter containing alternative town names. I would like to ensure that a town name is unique per country-region across the two tables. Can I do this with a ...
    Tarlika Elisabeth SchmitzTarlika Elisabeth Schmitz
    Jun 20, 2011 at 3:09 pm
    Jun 26, 2011 at 4:53 am
  • PostgreSQL community members: Do you love the PostgreSQL project? Do you want to contribute to it? Do you want to help produce the next version of PostgreSQL? (9.2) Well, you *can*. You can be a ...
    Josh BerkusJosh Berkus
    Jun 15, 2011 at 8:49 pm
    Jun 16, 2011 at 7:27 pm
  • Here: http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html Any comments?
    Rodrigo E. De León PlicetRodrigo E. De León Plicet
    Jun 24, 2011 at 2:07 am
    Jun 24, 2011 at 10:33 am
  • I didn't see a function for this, but is there a way in a postgresql query to determine the client OS? Thanks Sim
    Sim ZacksSim Zacks
    Jun 13, 2011 at 12:02 pm
    Jun 14, 2011 at 1:05 pm
  • Hi! I asked same thing in the list formerly, http://archives.postgresql.org/pgsql-general/2011-06/msg00888.php And because of lack of answers now I asked here also: ...
    Jun 30, 2011 at 2:11 pm
    Jul 6, 2011 at 1:28 pm
  • The installer for windows for 64bit versions of postgresql doesn't include ossp-uuid.sql. Does anyone know where or how to get this? Thanks -- *Grace Batumbya* Research Assistant | Seneca CDOT Phone: ...
    Grace BatumbyaGrace Batumbya
    Jun 28, 2011 at 9:58 pm
    Jul 3, 2011 at 7:57 pm
  • hello, I'm looking into pg_tables view and only one tablespace is displayed is pg_global. All my tables are created in my custom tablespace and that column is empty for them. select * from ...
    Jun 17, 2011 at 11:06 pm
    Jun 21, 2011 at 12:13 am
  • Hello Everyone, I got a new project, with 100 user in Europe. In this case, I need to handle production and sales processes an its documentations in PostgreSQL with PHP. The load of the sales process ...
    Carl von ClausewitzCarl von Clausewitz
    Jun 1, 2011 at 8:08 am
    Jun 7, 2011 at 4:51 pm
  • Earlier today I was working on a MySQL database (not by choice, I assure you), and I typed a statement like this: Update tablexyz set field1 = '15' where field2 - 20; The '-' was supposed to be an ...
    Michael NolanMichael Nolan
    Jun 26, 2011 at 4:45 am
    Jun 27, 2011 at 12:48 pm
  • What settings would you recommend for using postgres in an enterprise application together with jboss? there are numerous auth options (from the documentation): 19.3.1. Trust ...
    Eyal edriEyal edri
    Jun 8, 2011 at 7:18 am
    Jun 10, 2011 at 9:22 am
  • I know I can setup a FK constraint to make sure Table1.ColA exists in Table2.Key, however what if I want to do the reverse? I want to ensure Table1.ColA does NOT exist in Table2.Key.. Can I do this ...
    Mike ChristensenMike Christensen
    Jun 16, 2011 at 5:11 am
    Jun 17, 2011 at 11:08 pm
  • hello i have a lot of files in microsoft word format. each file consists of text and images (other text formatting like font is not important). i want to store this documents in Postgresql, and ...
    Arash pajoohandeArash pajoohande
    Jun 8, 2011 at 10:13 am
    Jun 10, 2011 at 4:13 pm
  • Hi all, first of all I'm not expressing any critique against the use of quotes for identifier expressed using camel case. However a lot of new postgresql users seems to be unhappy with the use of ...
    Jun 28, 2011 at 9:19 am
    Jun 29, 2011 at 10:08 am
  • No responses to my earlier post, I'm assuming because OS X experience is rather thin in this group ;-) So a couple of more specific questions: 1) Is my impression correct that given a choice between ...
    Scott RibeScott Ribe
    Jun 17, 2011 at 5:02 pm
    Jun 21, 2011 at 2:28 pm
  • I'm having huge problems with a Drupal install using Postgres 8.4.8. I'm getting the following error: PDOException: SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server ...
    Dave CoventryDave Coventry
    Jun 26, 2011 at 7:37 pm
    Jun 27, 2011 at 12:10 am
  • Hi there, I am new to postgreSQL. I would like to use encrypt/decrypt using PGP keys on windows. May i know, 1. What should i know before i proceed? 2. Any manual to follow the steps ? Thank you in ...
    Vikram AVikram A
    Jun 10, 2011 at 9:28 am
    Jun 16, 2011 at 4:52 am
  • Hi. I'm a new Postgres user. If I happen to ask stupid questions please feel free to point me to any documentation I should read or guidelines for asking questions. I'm looking into storing binary ...
    Hanno SchlichtingHanno Schlichting
    Jun 12, 2011 at 4:22 pm
    Jun 14, 2011 at 1:45 pm
  • Hi, I have a plpgsql function where I read data from a table in a loop and update data in a different table. Is it possible to see the updated data from a different access during the run of this ...
    Clemens SchwaighoferClemens Schwaighofer
    Jun 9, 2011 at 6:41 am
    Jun 10, 2011 at 9:22 am
  • Is there any maximum size limit for a query string in Postgresql 9.0.1? If yes, what is it ?.
    AI RummanAI Rumman
    Jun 7, 2011 at 10:39 am
    Jun 7, 2011 at 10:36 pm
  • So, I needed to build a special PG, for use with xTuple (an ERP). I got the 8.4.4 source, dumped it in a directory in my home, and put the executable out on a non-standard directory on one of my SSD. ...
    Jun 30, 2011 at 2:57 pm
    Jul 1, 2011 at 1:00 am
  • Hi, I am running PostgreSQL 9.0.4 and I am getting an error with a SELECT DISTINCT query that contains a point type in the SELECT clause. To be more specific, a query such as: -- explicit declaration ...
    Jonathan S. KatzJonathan S. Katz
    Jun 28, 2011 at 11:18 pm
    Jun 29, 2011 at 4:24 pm
  • I cannot recall issuing a DROP TABLE command from psql that did not work, but seem to have this as a new experience. When I look at the database table list with '\d' I see public | station_type | ...
    Rich ShepardRich Shepard
    Jun 28, 2011 at 10:34 pm
    Jun 28, 2011 at 11:18 pm
  • Seems to me a lot of the needed standard libraries are in '/lib64' and the linker isn't looking for them there? So far I've hit libreadline and libz. Do I just keep making the sim-links into ...
    Rob SargentRob Sargent
    Jun 22, 2011 at 12:29 am
    Jun 23, 2011 at 4:35 am
  • Hi Everybody, We are using PostGRE 8.4 version and experiencing random backend crashes. We have enabled logging and are able to see some logging happening in pg_log directory but not of much use. ...
    BangarRaju VadapalliBangarRaju Vadapalli
    Jun 14, 2011 at 2:36 pm
    Jun 20, 2011 at 4:38 am
  • Hi I observed some strange behaviour when adding a primary key with ALTER TABLE: Given CREATE TABLE mytable1 (id serial, name text); I filled it with data then did a CREATE TABLE mytable2 AS SELECT * ...
    Stefan KellerStefan Keller
    Jun 14, 2011 at 6:39 am
    Jun 16, 2011 at 1:39 pm
  • Dear all - While setting up streaming I ran into issue with libpq. To resolve it I need to recompile the source. I am issuing the following command . I tried this before with 9.0.2 it worked. Now ...
    Akp geekAkp geek
    Jun 13, 2011 at 9:15 pm
    Jun 15, 2011 at 1:49 pm
  • Is it possible to incorporate SET TIMEZONE into a query, so that to_char(...'TZ') etc. is appropriately localised? The development environment I'm working with uses short-lifetime sessions, and it's ...
    Mark Morgan LloydMark Morgan Lloyd
    Jun 14, 2011 at 10:00 am
    Jun 14, 2011 at 5:14 pm
  • Hi, how do you store recurring events in a database? Selecting all events in a week/month should be fast (comming from an index). My solution looks like this: Table event: Columns: id, name, ...
    Thomas GuettlerThomas Guettler
    Jun 6, 2011 at 11:04 am
    Jun 8, 2011 at 10:24 am
  • Hi, i am trying to obtain from the database what we have been doing in a excel sheet from some time. I have some tables where i store the documents associated with our customers, invoices, payments ...
    Jun 30, 2011 at 1:07 pm
    Jul 1, 2011 at 1:32 pm
  • Hello, how I can tell my postgresql to store last zero of real type ? I put value 2.30 and when I select that column i see 2.3 without zero. -- Regards, Condor
    Jun 29, 2011 at 11:24 am
    Jun 29, 2011 at 10:31 pm
  • Hello, I've just read through a paper here: http://www.edbt.org/Proceedings/2011-Uppsala/papers/edbt/a12-schiller.pdfabout multi-tenancy. They used Postgres for their work and while it is academic ...
    Emrul IslamEmrul Islam
    Jun 28, 2011 at 10:32 am
    Jun 29, 2011 at 11:54 am
  • Hi, I came across a strange issue when caching prepared statement.. We are accessing postgres(9.0.3) via the jdbc driver (9.0b801) using a prepared statement cache. This works very good but in 1 case ...
    Rob GansevlesRob Gansevles
    Jun 26, 2011 at 2:52 pm
    Jun 27, 2011 at 2:02 pm
  • Hello, I couldn't find much information in the archives on this -- perhaps this is a bit of a specialized need, but I was hoping for some input from some experienced pgsql admins. I'm moving some DNS ...
    Jun 4, 2011 at 4:49 pm
    Jun 24, 2011 at 2:07 am
  • Hi, In the following statement, does the custom function get executed twice? SELECT MY_FUNCTION(...), CASE WHEN MY_FUNCTION(...) = '...' THEN '...' ELSE '...' END ... ... If so, is there a way I can ...
    Lover boiLover boi
    Jun 19, 2011 at 2:32 am
    Jun 19, 2011 at 6:56 pm
  • Hi Does Postgres run on the Starter Edition of Windows Vista and Windows 7? Thanks H.F.
    Heine FerreiraHeine Ferreira
    Jun 6, 2011 at 8:19 pm
    Jun 8, 2011 at 12:16 am
  • I have an instance of what looks like a weird mixup of data returned by the server. This is observed in a Java application using the 9.0-801.jdbc4 JDBC driver connecting to an 8.3.4 server (yes, it's ...
    Michal PolitowskiMichal Politowski
    Jun 1, 2011 at 1:44 pm
    Jun 3, 2011 at 4:46 pm
  • Hi all, I am a bit confused regarding streaming replication. I have two server: A and B. I set up replication successfully. But when the master A goes down, B are not acting as master. My ...
    AI RummanAI Rumman
    Jun 16, 2011 at 8:32 am
    Jul 26, 2011 at 5:29 am
  • Hallo, does anyone have know of a free CRUD generator for generating plpgsql functions for doing CRUD operations on all the tables of a database or schema or just one table or.. cf ...
    Wim BertelsWim Bertels
    Jun 22, 2011 at 10:40 am
    Jun 28, 2011 at 8:54 am
  • I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home Edition, with the command line of the service being: D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D ...
    Eduard-Cristian StefanEduard-Cristian Stefan
    Jun 23, 2011 at 3:35 pm
    Jun 26, 2011 at 9:27 pm
  • Hi list, I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have remote access to this database so after reading I found out that modifying pg_hba.conf and postgresql.conf will ...
    Aritz DávilaAritz Dávila
    Jun 23, 2011 at 7:30 am
    Jun 24, 2011 at 6:28 am
  • Hello I'm new to PostgreSQL, coming at it from a MySQL background. I'm currently looking at switching one of our applications (which currently uses MySQL) over to PostgreSQL and had some questions. ...
    Vikram VaswaniVikram Vaswani
    Jun 21, 2011 at 5:08 am
    Jun 22, 2011 at 3:22 am
  • Hello, I am trying to re-create few objects from oracle into postgres. I have a problem inserting a timestamp value into the table: insert into request_queue (request_id, received_time ) values ...
    Leon MatchLeon Match
    Jun 20, 2011 at 7:33 pm
    Jun 21, 2011 at 1:31 pm
  • Hello, I need to search a table to find sets of rows that have a column matching itself for the whole set and another column matching row for row with a list I am going to supply. The result I should ...
    Daron RyanDaron Ryan
    Jun 18, 2011 at 9:51 pm
    Jun 20, 2011 at 1:14 am
  • This is a follow-up on my previous message http://archives.postgresql.org/pgsql-general/2011-06/msg00054.php I think I have now some understanding of what's causing the problem, but I don't have a ...
    BRUSSER MichaelBRUSSER Michael
    Jun 15, 2011 at 9:03 pm
    Jun 17, 2011 at 7:59 am
  • Hello again! (i got my traditional email-address back!) we have been running our infrastructure on 8.3 for quite some years now, and i am thinking it is now time to upgrade all major parts of our ...
    Achilleas MantziosAchilleas Mantzios
    Jun 16, 2011 at 2:27 pm
    Jun 17, 2011 at 5:43 am
  • Hi guys, I need to install plpython language in my db. testdb=# create language plpythonu; ERROR: could not access file "$libdir/plpython": No such file or directory -bash-3.2$ pwd /usr/pgsql-9.0/lib ...
    AI RummanAI Rumman
    Jun 14, 2011 at 7:33 am
    Jun 14, 2011 at 1:58 pm
  • Hi all - After making the required changes to the Primary and slave , I have restarted the slave and I keep seeing the following in the logs. Operating system is solaris. on the primary . ...
    Akp geekAkp geek
    Jun 10, 2011 at 7:47 pm
    Jun 13, 2011 at 2:08 pm
  • For some reason I'm unable to change a column's TYPE from VARCHAR(20) to INTERGER or SMALLINT. I'm required to note the manufactures color code (value = 198) in the table data but keep getting this ...
    Carlos MennensCarlos Mennens
    Jun 10, 2011 at 5:47 pm
    Jun 10, 2011 at 6:26 pm
Group Navigation
period‹ prev | Jun 2011 | next ›
Group Overview
grouppgsql-general @

261 users for June 2011

Craig Ringer: 61 posts Tom Lane: 43 posts David Johnston: 35 posts Merlin Moncure: 34 posts John R Pierce: 28 posts Greg Smith: 21 posts Adrian Klaver: 19 posts Rob Sargent: 19 posts Radosław Smogura: 13 posts Scott Marlowe: 13 posts Pavel Stehule: 12 posts Vincent Veyron: 12 posts Alexander Farber: 11 posts Scott Ribe: 11 posts Tomas Vondra: 11 posts Bill Moran: 10 posts Mike Christensen: 10 posts Akp geek: 9 posts Alban Hertroys: 9 posts Hernan gonzalez: 9 posts
show more