FAQ

Search Discussions

363 discussions - 1,842 posts

  • Hello all Let me introduce myself first. I am the ex-lead developer of SQLyog (one of the most popular GUI for MySQL which is Windows only and runs on Linux through WINE, more info at ...
    Ritesh NadhaniRitesh Nadhani
    Nov 25, 2006 at 9:53 am
    Nov 30, 2006 at 9:22 pm
  • Hi all, I am wonderring if it is a good practice to use SERIAL index as primary key, as it is only available up to 9999999? Currently i am dealing with storing LDAP users into Postgres and i am ...
    Carter ckCarter ck
    Nov 23, 2006 at 2:24 am
    Nov 28, 2006 at 1:34 pm
  • set datestyle to iso,iso; select 1 where ('2006-10-31'::date, '9999-12-31'::date) OVERLAPS ('2006-10-16'::DATE, '2006-10-31':: DATE) does not return any rows. Why ? How to make overlaps to return ...
    AndrusAndrus
    Nov 9, 2006 at 1:47 pm
    Nov 28, 2006 at 8:35 am
  • Hi list ! I already posted this as "COPY FROM encoding error", but I have been doing some more tests since then. I'm trying to export data from MS SQL Server to PostgreSQL. The tables are quite big ( ...
    Arnaud LesauvageArnaud Lesauvage
    Nov 21, 2006 at 9:50 pm
    Nov 24, 2006 at 8:08 am
  • I need to create nightly backups to separate computer over internet from 8.1 server I tried to run pg_dump to make backup using command "..\pg_dump\pg_dump.exe" -i -Z9 -b -v -f "C:\061127 ...
    AndrusAndrus
    Nov 27, 2006 at 5:14 pm
    Nov 30, 2006 at 4:36 pm
  • Hello all, Is there an existing mechanism is postgresql that can automatically increment/decrement on a daily basis w/out user interaction? The use case I'm considering is where a student is in some ...
    Louis gonzalesLouis gonzales
    Nov 2, 2006 at 6:14 pm
    Nov 9, 2006 at 10:17 am
  • In an interview "An interview with Adam Machanic" at http://www.simple-talk.com/sql/sql-server-2005/sql-server,-postgressql-and-fish-curry/ at the bottom of the page is a post by Andrew Clarke that ...
    NovnovNovnov
    Nov 11, 2006 at 10:00 pm
    Jan 17, 2007 at 6:36 pm
  • I have been using PostgreSQL for years in my web apps, and so far in my career I have not had to deal with database-side permissions issues. i.e. when I have multiple clients, or hands on the data, ...
    John McCawleyJohn McCawley
    Nov 30, 2006 at 6:48 pm
    Dec 1, 2006 at 7:12 pm
  • I have a server which has a socket of /var/run/postgresql/.s.PGSQL.5432. This is set in the .conf file. However, when I try to run a pg_dump it complains about the server not running on ...
    Garry saddingtonGarry saddington
    Nov 21, 2006 at 5:33 pm
    Nov 23, 2006 at 10:45 pm
  • I would like a way to run the autovacuum daemon on demand periodically. Every night at 2 AM, for example. Anybody know if this is possible? If not, it's a feature request :-) -Glen
    Glen ParkerGlen Parker
    Nov 10, 2006 at 1:00 am
    Nov 14, 2006 at 2:55 pm
  • hi list. as soon as i left-join an additional table, the query takes 24sec instead of 0.2sec, although the added fields have no impact on the resultset: -------------------- SELECT * FROM shop.dvds ...
    Thomas H.Thomas H.
    Nov 9, 2006 at 1:32 am
    Nov 10, 2006 at 2:09 am
  • We are getting a backend crash after issueing a load command. It's pretty easy to recreate -- so easy that I'm not sure that there is something being overlooked. This is on pg 8.2 roughly two weeks ...
    Merlin MoncureMerlin Moncure
    Nov 27, 2006 at 9:06 pm
    Nov 29, 2006 at 4:18 pm
  • Seriously though, there is one thing I've been meaning to bring up. I understand why NULLs compare the way they do in queries, and that's fine. But there are times when I need to query what would be ...
    Scott RibeScott Ribe
    Nov 28, 2006 at 12:38 am
    Nov 28, 2006 at 9:58 pm
  • Hi, One of our PostgreSQL 8.1.5 databases constantly crashed on a certain query (backend SEGFAULTs). I've figured the crashes were caused by a very long IN() clause. You can easily reproduce the ...
    Markus SchiltknechtMarkus Schiltknecht
    Nov 2, 2006 at 3:22 pm
    Nov 2, 2006 at 4:44 pm
  • I hope the subject says it all. I'm porting an Oracle-centric application to PostgreSQL and the Oracle sql is full of the 'unique' qualifier. I'm assuming PostgreSQL does not support 'unique' since ...
    Wm.A.StaffordWm.A.Stafford
    Nov 20, 2006 at 8:13 pm
    Nov 21, 2006 at 2:45 pm
  • Hi list ! When trying to import a 20M rows csv file into PostgreSQL, I get : ERROR: out of memory État SQL :53200 Détail :Failed on request of size 1073741823. Contexte : COPY tmp, line 1 The table ...
    Arnaud LesauvageArnaud Lesauvage
    Nov 23, 2006 at 10:04 am
    Nov 24, 2006 at 10:14 am
  • Hi. I have a table: ID | Name 0 | Anna 1 | Other 2 | Link 3 | Fernando I need sorted result but the way like this: 0 | Anna 3 | Fernando 2 | Link 1 | Other Record '1 | Other' must by at the end of ...
    MicroUserMicroUser
    Nov 14, 2006 at 10:03 pm
    Nov 21, 2006 at 3:45 pm
  • Hi All, I've got a problem w/ one of pgsql installations. It can't start: [postgres@db ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data PANIC: failed to re-find parent key in "23724" Aborted This is ...
    Igor ShevchenkoIgor Shevchenko
    Nov 14, 2006 at 12:51 am
    Nov 16, 2006 at 4:39 pm
  • I'm new to pgsql, mostly coming from MSSQL. It sounds like it's simplest to keep field names lowercase with pgsql, so I will have to change some habits I've developed over the years. I would like to ...
    NovnovNovnov
    Nov 8, 2006 at 5:49 pm
    Nov 14, 2006 at 12:47 am
  • Hi all, Yes, it's yet another request for advice on replicating pgsql. I have been doing some research on this lately, and so far I am getting the impression that what I want is Slony + log shipping. ...
    Brendan JurdBrendan Jurd
    Nov 10, 2006 at 7:36 pm
    Nov 13, 2006 at 8:47 pm
  • I'm completely new to pgsql, using 8.1 and pgAdmin III. I'm not finding a lot of bare bones simple example stored procs that I can learn from. It would be very helpful if someone could show me some ...
    NovnovNovnov
    Nov 4, 2006 at 4:45 am
    Nov 5, 2006 at 9:04 pm
  • Hi everyone, I recently installed PostgreSQL (Version 8.1.5.1) using the MSI installer on a Windows Server 2000 system. I ran the installer logged in under an Administrator account, and set the ...
    George WeaverGeorge Weaver
    Nov 27, 2006 at 6:20 pm
    Dec 15, 2006 at 3:33 pm
  • In all of postgres 8.1.4 (windows) databases I create there are a bunch of cube and g_cube functions added to the db. If these are not needed, is there a simple way to make sure that they are not ...
    NovnovNovnov
    Nov 25, 2006 at 10:24 pm
    Nov 28, 2006 at 9:37 pm
  • Hi, i have a table and i have the query select * from table where col_name is null; it returns some rows now, say i have to implement the same query using the in clause how shold it be done? select * ...
    Surabhi.ahujaSurabhi.ahuja
    Nov 24, 2006 at 9:02 am
    Nov 28, 2006 at 2:02 pm
  • I have an 8.1.2 autovac which appears to be hanging/blocking every few days or so, but we're don't understand what's causing it. I wasn't able to catch a backtrace before we killed it. I do not see ...
    Ed L.Ed L.
    Nov 14, 2006 at 6:21 pm
    Nov 16, 2006 at 6:08 pm
  • I notice a lot of places where people use the approach of creating an index and a unique key like: CREATE TABLE foo ( idx SERIAL PRIMARY KEY, name varchar(32) UNIQUE NOT NULL ) instead of CREATE ...
    Tom AllisonTom Allison
    Nov 24, 2006 at 3:14 pm
    Nov 27, 2006 at 9:18 am
  • I seem to be having a problem with pg_dump in 8.1.2, it's not dumping indexes at all. Is this a known problem, should I just do an upgrade? Thanks, Alex Turner Mint Pixels
    Alex TurnerAlex Turner
    Nov 9, 2006 at 6:05 pm
    Nov 10, 2006 at 5:22 pm
  • Hi, I just can't understand why autovacuum is not working. I have a test db/table which I insert values into (by the thousands) and can't work out why my stats don't get updated. Could someone have a ...
    Anton MelserAnton Melser
    Nov 9, 2006 at 11:19 am
    Nov 10, 2006 at 7:54 am
  • Hello, We been having a problem lately with some data changing their value without modifying them. We used to backups to see the difference: this was the first backup INSERT INTO journal ...
    Ardian XharraArdian Xharra
    Nov 16, 2006 at 4:45 pm
    Jan 15, 2007 at 5:02 pm
  • I don't know what the exact version is but I am getting this: FATAL: database is not accepting commands to avoid wraparound data loss in database "postgres" How can I recover from this and why woud ...
    Tony CadutoTony Caduto
    Nov 27, 2006 at 7:27 pm
    Dec 3, 2006 at 3:21 am
  • Here is sample code demonstrating the issue: test=# create table test_coalesce(f1 int not null, f2 date); CREATE TABLE test=# insert into test_coalesce values (1, null); INSERT 0 1 test=# insert into ...
    Kevin GrittnerKevin Grittner
    Nov 29, 2006 at 5:07 pm
    Nov 29, 2006 at 9:35 pm
  • Hello. I have an unconfirmed feeling that autovac does not like system-wide statement_timeout. I.e. when I in some panic move set system-wide statement_timeout to 90 seconds, autovac stopped working ...
    Marcin MańkMarcin Mańk
    Nov 16, 2006 at 6:25 pm
    Nov 21, 2006 at 9:12 pm
  • Dear list, I have been banging my head against a problem for a few days now, and although I am making progress it is painfully slow, and I am hoping that some one out there can steer me in a better ...
    Gregory S. WilliamsonGregory S. Williamson
    Nov 17, 2006 at 1:56 am
    Nov 20, 2006 at 4:41 pm
  • A question about rules: I am trying to create a rule which handles inserts on a view, and that rule should insert rows into multiple tables, each one of which contains some of the columns that the ...
    Jeremy SmithJeremy Smith
    Nov 16, 2006 at 7:41 pm
    Nov 18, 2006 at 1:54 am
  • Hi I have done some research and it seems there are no active mirroring solutions for postgresql 8 and above. I did see Slony but I need Master to Master functionality and not only Master to ...
    GideonGideon
    Nov 10, 2006 at 11:24 am
    Nov 10, 2006 at 4:05 pm
  • I'd like to be able to have several versions of a database available concurrently and one database alias that refers to the most recent of these. For example: dbname_1-1 dbname_1-2 dbname_1-3 dbname ...
    Reece HartReece Hart
    Nov 6, 2006 at 11:13 pm
    Nov 7, 2006 at 6:42 pm
  • Hi All I am unable to find PostGIS Binary RPM for Red Hat Linux ...on the postgis.org website ... Can somebody point me to the url from where i can download ...this ?? Thanks in advance Sandeep
    Sandeep Kumar JakkarajuSandeep Kumar Jakkaraju
    Nov 4, 2006 at 7:51 am
    Nov 7, 2006 at 5:10 am
  • Is there any way to count how many hits I got in a cursor in PL/pgsql? I have a function that will "window" through the result of a (large) query based on two parameters, but I also want to return ...
    Magnus HaganderMagnus Hagander
    Nov 2, 2006 at 9:43 pm
    Nov 3, 2006 at 2:43 pm
  • It is like the weirdest thing ever... I have a proc that dynamically generates SQL, executes it and returns results as setof record. Some of fields are strings with single quotes inside them. Since ...
    PeterPeter
    Nov 2, 2006 at 1:48 pm
    Nov 3, 2006 at 9:52 am
  • hi, i have been testing 8.2 rc1, while i got this problem. base data: linux, 32bit, kernel: 2.6.18.3; debian postgresql version: PostgreSQL 8.2rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Nov 30, 2006 at 10:38 am
    Dec 2, 2006 at 10:15 am
  • Hi, I have a postgresql server setup on a Solaris 10 box. I can connect to the db via psql from the local machine. What I have been trying to do it connect with pgAdmin from my workstation. I have ...
    Ben shortBen short
    Nov 24, 2006 at 8:56 pm
    Nov 28, 2006 at 6:25 am
  • I have found myself somewhat trapped in a project where the software being used is essentially set in stone, and its limitations are strangling progress. It is a client-side app written in VB with an ...
    John McCawleyJohn McCawley
    Nov 22, 2006 at 4:13 pm
    Nov 22, 2006 at 10:51 pm
  • Hello, Does anyone know if it is possible to use SAN Splitting (the function of splitting a mirror of disks so that there are two idential copies of a Postgres Instance)? The reason that I ask is ...
    Paul SilveiraPaul Silveira
    Nov 14, 2006 at 10:44 pm
    Nov 15, 2006 at 10:13 pm
  • PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though). DBMS was running fine for some months but now one of the databases isn't accessible. Any help would be greatly appreciated. ...
    Rob OwenRob Owen
    Nov 14, 2006 at 11:23 am
    Nov 15, 2006 at 10:08 pm
  • X-No-Archive: true Hi, Thanks for all the help: we have our postgreSQL server on a 'backend' machine, and the client on a webserver. The application I want to develop is a school library, and as this ...
    Desmond CoughlanDesmond Coughlan
    Nov 14, 2006 at 3:42 pm
    Nov 15, 2006 at 10:24 am
  • What would be the easiest way to get back only the meaningful digits of a numeric value in a pgsql function? eg? 1.002 -- 1.002 1.020 -- 1.02 1.200 -- 1.2 1.000 -- 1 Thanks SWK
    SunWuKungSunWuKung
    Nov 13, 2006 at 1:45 pm
    Nov 14, 2006 at 2:06 pm
  • My database locale is en_US, and by default my databases are UTF8. My application code allows the user to paste text into a box and submit it to the database. Sometimes the pasted text contains non ...
    Rick SchumeyerRick Schumeyer
    Nov 11, 2006 at 7:52 pm
    Nov 14, 2006 at 11:34 am
  • Hi! I'd like to know if there's any reasoning for not allowing creating an index inside the same schema where the table is. For example, if I have a multi-company database where each company has its ...
    Jorge GodoyJorge Godoy
    Nov 12, 2006 at 12:07 pm
    Nov 13, 2006 at 1:36 am
  • CentOS 4.4 which means postgresql-server-7.4.13-2.RHEL4.1 I'm starting to deal with the notion of allowing other users access (read only) to a db. Experimenting on my own db... host all main_user ...
    Craig WhiteCraig White
    Nov 9, 2006 at 3:54 am
    Nov 11, 2006 at 6:38 pm
  • One of our 8.1.2 postmasters on HPUX 11.23 ia64 just received a SIGKILL signal from unknown origins. After reviewing all command history files for the DBA and root, I do not believe anyone manually ...
    Ed L.Ed L.
    Nov 8, 2006 at 5:18 pm
    Nov 10, 2006 at 7:27 am
Group Navigation
period‹ prev | Nov 2006 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions363
posts1,842
users364
websitepostgresql.org
irc#postgresql

364 users for November 2006

Tom Lane: 120 posts Richard Huxton: 84 posts Martijn van Oosterhout: 68 posts Joshua D. Drake: 52 posts Richard Broersma Jr: 35 posts Jeff Davis: 32 posts Andrus: 29 posts Merlin Moncure: 29 posts Alvaro Herrera: 28 posts Andreas Kretschmer: 27 posts Alban Hertroys: 26 posts Novnov: 25 posts Tony Caduto: 24 posts Ron Johnson: 23 posts Scott Ribe: 22 posts Arnaud Lesauvage: 21 posts Surabhi.ahuja: 19 posts Albe Laurenz: 17 posts Bob Pawley: 17 posts John McCawley: 17 posts
show more
Archives