Hi, I'm not using PostgreSQL yet. I just wanted to know if INTEGER(n), like INTEGER(11) or such are allowed by PostgreSQL. Does the value in...

Karsten Wutzke

09-05-2009 02:09 PM
Karsten Wutzke

Hi ! Well, on an old 7.4 postgres the vacuum failed for some time without us noticing it, and now some data is hidden because the XID wrapped. We...

rixed@happyleptic.org

09-04-2009 04:30 AM
Laurenz Albe

Hi, We are a computer systems research group at the Computer Science department at Rutgers University, and are conducting research on simplifying...

Wei Zheng

09-02-2009 11:01 AM
Wei Zheng

Greetings. Although a newbie at PostgreSQL, I have jumped right in to write the SQL scripts to create the tables in my database, including foreign...

Rasputin Paskudniak

08-29-2009 05:25 AM
Jochen Lutz

Greetings, new friends. I have just started trying to get my feet wet with PostgreSQL on my Ubuntu Linux host. May this be my greatest hurdle. I am...

Rasputin Paskudniak

08-25-2009 06:39 AM
Rasputin Paskudniak

Hello everyone! What are the techniques for searching large tables without index (SELECT id FROM big_table WHERE name LIKE '%search%'). With...

Pet

08-19-2009 03:06 AM
Laurenz Albe

Vesa-Matti Kari wrote: There is no need for table locking, the existing row locking techniques can cope well with this problem. All you have to do...

Matthew Woodcraft

08-18-2009 12:17 PM
Laurenz Albe

Hi, we've been using a batch file containing a call to reindexdb.exe , vacuumdb.exe and pg_dump.exe on a regular basis, and recently found...

Justus Janssen

08-11-2009 03:15 AM
Laurenz Albe

(Sorry, Couldn't find a pure SQL newsgroup) This little request is working OK. The idea is to get a percentage of the selected records based only...

orofgggghtyy

08-10-2009 03:57 AM
Laurenz Albe

Hello, I really just want to know specifically whether SELECT * FROM test WHERE boolean_column; SELECT * FROM test WHERE integer_column; work or...

Karsten Wutzke

07-24-2009 07:34 AM
Coniglio Sgabbiato

Hi, everybody, Our applications must work on various RDBMS'es, so in sql queries we cannot use some built-in functions because they are not...

Jaros³aw Lubczyñski

07-21-2009 05:13 AM
Jaros³aw Lubczyñski

Hi, I have projects that *may* be split into phases and timereports records that refer to a project and possibly to a phase. It's not difficult to...

ortles

07-17-2009 07:31 PM
Ben Finney

Hi, I read onto documentation: http://www.postgresql.org/docs/8.3/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT "epoch For date and...

Coniglio Sgabbiato

07-08-2009 09:36 AM
Anselmo Canfora

Hi! Where are stored the sequence information? How I can query the properties of a sequence like increment, max/min value, cache? I'm looking for a...

Andre Rothe

07-03-2009 09:29 AM
Andre Rothe

Hello all, I would like to know if it is possible to control changes in the structure of a table... I tried to make a trigger to monitor the updates...

EBMB

06-25-2009 02:02 AM
Andreas Kretschmer

Hello c.d.p, I recently installed postgresql under Debian/GNU Linux 5.0 (lenny) using the standard aptitude method. SELECT version();...

Peter B Schmidt

06-24-2009 03:24 PM
Peter B Schmidt

Hello! I have to manipulate vector data in an array of 55 dimensions v(measure1, measure2, .... ,measure55) where measureN is an integer. I have...

Alain Reymond

06-20-2009 05:15 AM
Alain Reymond

Hello, I have a weird question, is there a way to perform a query on a table which the name is been obtaind from another query? A trivial example...

Coniglio Sgabbiato

06-19-2009 08:59 AM
Coniglio Sgabbiato

I have one table A, which should be updated sometimes. I.e. I download copy of A with some new records. I cannot just drop table A, because there may...

Pet

06-18-2009 05:27 AM
Tep

Hello, if i try the following statement: select ts_headline('example text', to_tsquery('example'), 'ShortWord = 3, MinWords = 10, MaxWords = 30,...

Torsten Zühlsdorff

06-15-2009 11:04 AM
Torsten Zühlsdorff

Hi, can you please guide me as to how can I create users that can only log on to certain databases. Thanks for all your help, Undbund

undbund

06-15-2009 01:34 AM
Andreas Kretschmer

Mogwai ERDesigner NG is a Java based entity releationship design tool. It includes the following key features: * is based on Java and can be run on...

Mirko Sertic

06-10-2009 02:41 AM
Mirko Sertic

"patrick imbault" <pat (AT) free (DOT) fr> writes: My guess is there's not much benefit of the OLE DB provider over ODBC for this purpose, unless...

marc spitzer

06-03-2009 04:54 PM
David Bolen

Group, I want to redump a DB which was dumped with a PostGIS version < 1.0.0 (don't know the exact version, so as the postgreSQL version). The...

Henning Bredel

05-16-2009 02:46 PM
Henning Bredel

CSQL Enterprise, a main memory database caching platform which improves application throughput by 30 times for data access, thereby scaling...

Praba

05-11-2009 05:21 AM
Marco Mariani

When I used to use Oracle's SQL*Plus, it was possible to run SQL scripts using the @ symbol, for example:- @myscript.sql and if that script referred...

gargoyle47

05-08-2009 03:31 AM
gargoyle47

I'm sitting deep in the belly of the Ruby on Rails PostgreSQL adapter and the database has just notified me of an error. I've got an error message...

Michael Schuerig

05-06-2009 06:24 PM
Michael Schuerig

Hi all, I have _two_ problems, please consider the following example function: drop function if exists test(varchar, smallint, varchar); create or...

Coniglio Sgabbiato

05-05-2009 05:40 AM
Laurenz Albe

Hello all, I've read several sources including http://www.postgresql.org/docs/8.3/static/datatype-numeric.html There doesn't really seem to be a...

Karsten Wutzke

05-05-2009 04:23 AM
Laurenz Albe

I’ve installed PostgreSQL 8.3.5 on Windows XP Home (SP3). Now I’ve had time to play around with it, I want to delete my test databases and all...

gargoyle47

04-24-2009 07:14 AM
Thomas Kellerer

The 8.3 documentation makes no reference to nchar etc types and yet you can create columns, cast and specify a national character literal. Does...

the6campbells

04-22-2009 04:11 AM
Laurenz Albe

Hello I tried to create a table with some CHARACTER VARYING(10480000) CHARACTER SET UTF8 column in PostgreSQL 8.3 (I have the latest version)...

Timothy Madden

04-20-2009 09:25 AM
Sibylle Koczian

hi, can you tell me how can i search geo points from geopoints database in defined area? how can i define area? i have points on my googlemaps map...

iamx

04-16-2009 01:43 PM
Bernd Nawothnig

I'd like to get a textual SQL representation of expression and partial indexes. I've found that the information is somehow contained in pg_index...

Michael Schuerig

04-15-2009 01:44 PM
Michael Schuerig

it seems that postgres does not currently support the "compoundrule" directives in ispell affix files, but i cant seem to find an english dictionary...

snex

04-08-2009 02:32 PM
snex

I have a database I would like to backup every hour. For a given hour, if the database has not been modified since the last backup, I'd like to skip...

KM

04-06-2009 06:37 AM
Laurenz Albe

Since about a month I can't connect to the local postgres server any more. $ psql psql: could not connect to server: No such file or directory Is...

Kai-Martin Knaak

04-06-2009 03:10 AM
Andreas Kretschmer

Hello, I was wondering what would be more prudent (performance-wise): to use the bytea datatype in postgres 8.3 or to use an xfs filesystem for...

Can Özdemir

04-04-2009 01:27 PM
Can Özdemir

I want to give people with the same name consecutive serial numbers. The way I'm trying to achieve this is to insert everyone with a serial number of...

Michael Schuerig

04-03-2009 02:53 AM
Laurenz Albe

The PostgreSQL adapter of the Ruby on Rails database connector contains the following statement to find all indexes on a table, including the indexed...

Michael Schuerig

04-02-2009 09:09 AM
Michael Schuerig

I'm considering the implications of dropping indexes temporarily during mass operations such as imports and generation of sample data. The idea is to...

Michael Schuerig

04-01-2009 06:22 AM
Andreas Kretschmer

Hi, i got a following problem, the sql query is: INSERT...

N.G.

03-25-2009 05:16 AM
N.G.

Hi, I have opensuse 11.0 with postgresql installed. Now I want to login using phpPgAdmin, but I don't now the initial super user credentials. Can...

Thorsten Kiefer

03-13-2009 10:15 AM
Laurenz Albe

Hi I am looking for sample database in postgres, i.e a sample schema and data for say a library database. I need a schema to be of medium complexity...

Swati F

03-13-2009 02:30 AM
Thomas Kellerer

It is our pleasure to announce the first public release of MayBMS, MayBMS 2.1 beta, which is now available...

Christoph Koch

03-11-2009 09:00 PM
Christoph Koch

Greetings. I posted this question on pgsql.general a few days ago, reopening an months-old thread, but thus far, nobody has taken up my fight. ...

Beau Nanaz

03-05-2009 05:41 PM
Robert

I am using Postgersql 8.2.11-1 on Windows XP. When Postresql is in use it outputs a lot of text to the console window. Every query and and every...

Artist

02-17-2009 05:50 AM
Thomas Kellerer

Hallo, how can i get a description of an object in the worksheet of pgadmin? in psql i can say \d objectname and then i become the description of...

Reinhard Asmus

02-17-2009 05:32 AM
Laurenz Albe

Hi, How to create a rule which when an insert appears, update another row in another table with the value of the insert. for exemple : Table...

bcar

02-11-2009 07:34 AM
bcar

Hi, I am thinking of using the inheritance feature of PQ but have some problems with it. As far as I read the documentation foreign-key support,...

Sascha Bohnenkamp

01-27-2009 10:07 AM
Sascha Bohnenkamp