Home » Category » PostgreSQL

PostgreSQL

• Browse database , schema

• Hi All,I have a question about rights to browse a database and a schema'sstructure. Is this normal that user who isn't have any permission asselectto same db or scheme may explore it and see tables (table's fieldsetc.) ?How prohibit that ? ThanksRegardsQnick...
• Fri, 03 Sep 2010 06:55:00 GMT | 313 bytes | Answers (1)

• recovering from a --clean dump

• hello,I use an automated script that if it detects a problem in a databaseuses a dumb from another db to recover data.'pg_dump -c -h host1 d1 | psql -a -h host2 -d DB2 >> recover_dump 2>&1'now my recover_dump tells me a unix index could`nt be created as thetable contains dupli...
• Fri, 03 Sep 2010 05:55:00 GMT | 906 bytes

• SET TIME ZONE with GMT+X notation

• I'm a bit confused about SET TIME ZONE and its effect on PostgreSQL'sdate processing.In my experience with timestamps in all other *nix-based softwaresystems, a timestamp is always a numeric representation of thetime elapsed since the epoch, in GMT. Thus, a function thatreturns the cur...
• Fri, 03 Sep 2010 04:55:00 GMT | 3,684 bytes | Answers (2)

• Nullable Foreign Key-like Constraint

• Mandatories: Ver 7.3.4, Redhat Linux 8.0, P4, 2GB RAMI want to add a 'nullable' foreign key to a column in a table. I havetables "company" and "project" which may be related bycompany.companyID <-> project.companyID.project.companyID is allowed to be null. However, when someone t...
• Fri, 03 Sep 2010 01:55:00 GMT | 2,618 bytes

• Why different execution times for different instances for the

• On Tue, 2005-10-25 at 13:14 -0700, Kishore B wrote:> Hi ,> I am Kishore doing freelance development of J2EE applications.>> We switched to use PostgreSQL recently because of the advantages it> has over other commercial databases. All went well untill recently,> untill we began...
• Thu, 02 Sep 2010 21:55:00 GMT | 1,850 bytes

• question : the choice of the primary key.

• U have for example something like thiscreate table persons((id..),surename ..,familyname ..,street ..,..,birthdate,..)a table containing the data of persons, each persons should of course bepresent only once;and one should still define a primary key,there are two options now,1.many people make a...
• Thu, 02 Sep 2010 19:55:00 GMT | 1,041 bytes | Answers (1)

• How to recover from : "Cache lookup failed for rela tion "

• Patrick.FICHE@AQSACOM.COM writes:> Do you have any idea on the reason of this situation ?No, I was hoping we might see some clues but there wasn't much. Boththe pg_depend entries and the pg_type row should have been deleted bythe same transaction that deleted the pg_class row. Partially...
• Thu, 02 Sep 2010 18:55:00 GMT | 1,010 bytes

• [ psqlodbc-Bugs-1000600 ] odbc via the local net (lan & Wan)

• Bugs item #1000600, was opened at 2006-03-27 18:44You can respond by visiting:[url]http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000600&group_id=1000125[/url]Category: Interface (example)Group: v1.0 (example)Status: OpenResolution: NonePriority: 3Submitted By: Nobody (None)Assigned to:...
• Thu, 02 Sep 2010 18:55:00 GMT | 1,281 bytes

• Row fields by position in a cursor

• I am passing a SQL statement to a function as a parameter and thenexecuting it via a call likeOPEN curs1 FOR EXECUTE sql_str;Since I won't know in advance the fieldnames being passed by the SQLstring, I'd like to dereference the column fields by position. Cananybody tell me the syntax...
• Thu, 02 Sep 2010 17:55:00 GMT | 530 bytes | Answers (1)

• PQtrace doesn't work

• Hello,I've send this message also on 29-1-2004 and have since no solution forthis problem .. >:o .I have a little test program (see at the end of the message).The program crashes when PQTrace is called (instruction xxxx referencedmemory at "0x00000010", thememory could not be written" (o...
• Thu, 02 Sep 2010 17:55:00 GMT | 2,950 bytes | Answers (6)

• RES: Order by behaviour

• Hi,I was trying to find the docs about the collating sequence standards butcould not find.Would like to know for example which characters are ignored by the "orderby" in some of the collating types.Please, can anyone indicate me where could I find documentation about thesestandards?Thanks in adv...
• Thu, 02 Sep 2010 16:55:00 GMT | 1,056 bytes | Answers (1)

• Best Linux Distribution

• Best Linux Distribution...
• Thu, 02 Sep 2010 16:55:00 GMT | 0 bytes

• postgres copy command very slow.

• Hi,We have PostgreSQL 7.4.1 running on Mac OS.we aredoing a conversion from mysql to postgres. I'mimporting the table dumps using copy command inpostgres. Copy takes 2 min to import 427938 rows inone table and at the same time it takes more than 2hrs for 2415768 rows.. no of columns are sim...
• Thu, 02 Sep 2010 15:55:00 GMT | 1,200 bytes | Answers (1)

• Database storage bloat -- FOLLOWUP

• I thought I'd make a followup to the question of storage bloat. Itried approaching the problem by living a little loosely with databasenormalization and use arrays instead of flattening everything out inthe tables.So my original table,CREATE TABLE original (dbIndex integer,index1 smallint,i...
• Thu, 02 Sep 2010 15:55:00 GMT | 1,581 bytes

• Assigning a row of a record to a text variable

• <br><font size=2 face="sans-serif">Hi</font><br><font size=2 face="sans-serif">I'm running PostgreSQL 7.3.4. </font><br><font size=2 face="sans-serif">I have the following problem: Ina trigger function I want to read out the values from the ps...
• Thu, 02 Sep 2010 13:55:00 GMT | 1,043 bytes

• archives.postgresql.org weirdness

• Guys,Is anyone else annoyed by the fact that the "thread view" for the listsin archives.postgresql.org is incomplete? I mean, there _is_ a link tothe "next page" of the thread view, but it taks you to the "date view"instead...--Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)"No reniegues de lo...
• Thu, 02 Sep 2010 13:55:00 GMT | 632 bytes | Answers (1)

• Remove diacritic

• Good morning,I would like to remove diacritic from string like 'luouk k'(UTF-8) and transform it into 'zlutoucky kun'. I have used functionconvert(); and SQL_ASCII as destination encoding.Converted string still contains diacritic:SELECT convert('luouk k','UTF8&...
• Thu, 02 Sep 2010 12:55:00 GMT | 745 bytes

• Cygwin? or paid version from SRA?

• Hi All For deploying PostgreSQL on Windoz platform, which one is a betteroption (performance, reliability) ? Thru Cygwin or Paid version fromSRA? Any option for hot backup? Thank you ...
• Thu, 02 Sep 2010 12:55:00 GMT | 214 bytes | Answers (6)

• Bug in psqlodbc ?

• Hi,I have problems with the psqlodbc driver under SuSE Linux Professional 9.1.I have tried to modify the suspect code with this lines:logs_on_off(1,1,1);mylog("Size for rowset: %d\n", vParam);logs_onOff(0,0,0);This code is in set_statement_option and located in case SQL_ROWSET_SIZE.But the log f...
• Thu, 02 Sep 2010 11:55:00 GMT | 503 bytes

• Postgre Architecture

• Hello!We working currently with the Oracle and we would like to know if postgresql has some similar components as the concept of instance, buffer database cache, Redo log buffer, datafiles, background process, etc. How postgre works? It works in memory?There is some figure that ilustrates your a...
• Thu, 02 Sep 2010 11:55:00 GMT | 362 bytes