Hi, in PG 8.3 I have the following issue: db_atm=# select substring('1.3.6.1.4.1.9.1.182', E'(1\.3\.6\.1\.4\.1\.9\.1\.\d*)',...

Anselmo Canfora

01-24-2010 07:24 AM
Anselmo Canfora

Hi, I created a crosstab function (query_sql, query_category) and it works, but my query is dynamic and extracts a number of columns varies according...

Peca's

01-24-2010 04:32 AM
Jasen Betts

Hi all, i am a master's student. I have to do a keyword search for spatial database. I have the data set of a particular district in India. I have a...

Kavita

01-07-2010 05:23 AM
Laurenz Albe

After an insert statement, I need a the members of a user group to get the recently inserted statement's primary key that was created from a...

Ivan K.

01-04-2010 04:38 AM
Laurenz Albe

Hello, today I ran into the "encoding problem". Migrating from Postgres 8 to Postgres 8.3 on a new Debian on another server, psql refused to...

Hadanite Marasek

12-31-2009 04:03 PM
M. Strobel

This is not a Postgres specific question. Given two simple tables tracking the marriages between people: The simple query:

Ivan K.

12-28-2009 03:40 PM
Ivan K.

Hi, Is there an option in PG to do it?

Coniglio Sgabbiato

12-22-2009 01:32 PM
Mladen Gogala

Can I write a stored procedure which does an automonous commit? I saw something on a website that claimed "you can't get there from here" in...

Lee

12-21-2009 04:31 AM
Laurenz Albe

PostgreSQL has hash indexes, very similar to Oracle bitmap indexes. Oracle warns the application designers against using them in the...

Mladen Gogala

12-15-2009 02:31 AM
Thomas Kellerer

I would like to write a single query listing all of the function argument types. I know that I can write a procedure but I would prefer a...

Mladen Gogala

12-11-2009 05:22 PM
Mladen Gogala

Does anybody have an example with spi_prepare, spi_exec_prepared or spi_query_prepared? I managed to get the basic concepts: create function...

Mladen Gogala

12-10-2009 05:36 PM
Mladen Gogala

When I use capital letter(s) in table or view name Hibernate complains it can't find the relation. :( Is this known issue or am I doing something...

Jaroslav Záruba

12-10-2009 03:12 AM
Jaroslav Záruba

Hello, I have several databases. The objects are stored in the public schema of each database. I would like to move them to different schemas in...

Tanguy

12-09-2009 09:14 AM
Tanguy

PostgreSQL has some rather strange indexes, like partial indexes: scott=> create index ename_ind on emp(ename) scott-> where deptno=10; CREATE...

Mladen Gogala

12-03-2009 03:45 PM
Mladen Gogala

I tried the named callable query approach... <sql-something name="..." callable="true"> { ? = call schema.procedure(?,?) } </sql-something> ....but...

Jaroslav Záruba

12-01-2009 12:40 AM
Jaroslav Záruba

so I read great stuff by rob piek about having data not algorithms be cental to programming so if have the data then everything else...

quiet_lad

11-30-2009 04:00 PM
quiet_lad

I have a table defined like this: scott=> \d t Table "public.t" Column | Type |...

Mladen Gogala

11-26-2009 10:00 PM
Mladen Gogala

On Wed, 25 Nov 2009 19:59:10 +0000, Mladen Gogala wrote: It's NOT syntactically supported. Lapsus keyboardi. -- http://mgogala.byethost5.com

Mladen Gogala

11-25-2009 03:11 PM
Mladen Gogala

I am unable to find the necessary package and the source code doesn't compile. Does anybody know more? -- http://mgogala.byethost5.com

Mladen Gogala

11-25-2009 03:44 AM
Laurenz Albe

The following query executes without a problem on 8.4 but fails with syntax error on 8.3. Is there a "new features" document which would tell me the...

Mladen Gogala

11-24-2009 01:15 AM
Mladen Gogala

Don't want to start a long-winded discussion, just seeking some general views. . . I was trained in SQL years ago and was encouraged to use...

gargoyle60

11-23-2009 04:04 AM
Marco Mariani

I asked a simple question and yet my post is not showing, it is pending approval by the list moderators. Is that list intentionally designed to be as...

Mladen Gogala

11-22-2009 04:26 AM
Jasen Betts

Hi, I have create a table with this structur CREATE TABLE import ( id1 integer NOT NULL, id2 integer NOT NULL, dataset oid NOT NULL, CONSTRAINT...

Philipp Kraus

11-19-2009 05:26 AM
Laurenz Albe

Hello, i try to use the setArray method of postgres (8.3) JDBC driver to send data to a function. I hope I'm not off topic here with this...

Philipp Kraus

11-18-2009 08:56 AM
Philipp Kraus

Hi Everyone, Given a table "Items" with a PK "item1" and "Qty" - a numeric column I'd like to define a way in Postgres to insert when item11...

SebiF

11-16-2009 03:53 PM
Andreas Kretschmer

The documentation of this command is extremely unclear and vague? What does the integer argument taken by this command represent? My guess is that it...

Mladen Gogala

11-16-2009 02:45 PM
Mladen Gogala

I have an unusual execution plan below. I am executing a query using the primary key and am getting sequential scan. How can I force the use of the...

Mladen Gogala

11-16-2009 10:48 AM
Mladen Gogala

Hello, i had written a stored procedure that works as trigger for upate and delete statements. The trigger raises an error if there is a not allowd...

Philipp Kraus

11-16-2009 05:50 AM
Philipp Kraus

I am about to start playing with Slony. For one, I have a stupid question: where does one usually install Slony? On the master or on the...

Mladen Gogala

11-13-2009 03:51 PM
Mladen Gogala

I've been looking for something like Oracle's utl_http.request (analagous to the unix curl ) in postresql; but there doesnt seem to be any such...

Lee

11-13-2009 11:06 AM
Lee

Laurenz Albe <invite (AT) spam (DOT) to.invalid> wrote: This ist exactly the use of DBD::PgSPI - and doing so in the usual way you access databases...

Jochen Lutz

11-12-2009 06:35 PM
Jochen Lutz

I have to say that this seems wrong to me. One of the basic rules in programming/coding is that name of class/ variable/function/etc. should describe...

Jaroslav Záruba

11-12-2009 08:34 AM
Laurenz Albe

Hello I have this trigger which ON INSERT inserts more rows into the very same table it "sits" on. To avoid an INSERT-recursion I would like...

Jaroslav Záruba

11-11-2009 10:21 AM
Jaroslav Záruba

Hello all, I need, after one specific table is created, with syncdb, to insert in that new table some values from other table. Exactly I need to...

NMarcu

11-10-2009 08:03 AM
NMarcu

Hello, I'm new to postgresql and have installed it on CentOS 5.3 via yum. I am attempting to install an application that uses postgresql as...

Greg Russell

11-06-2009 03:38 PM
Thomas Kellerer

After the recent events with Oracle licenses, my boss decided to do a pilot project with moving an application to Postgres. So far, my experiences...

Mladen Gogala

11-04-2009 03:11 PM
u235sentinel

I just created my first trigger in Postgres and went to check the catalog schema: scott=>...

Mladen Gogala

11-03-2009 07:31 AM
Laurenz Albe

Is there an active Postgres group in NYC? Are there commercial companies using PgSQL in and around the NYC area? -- http://mgogala.freehostia.com

Mladen Gogala

10-28-2009 01:18 PM
Mladen Gogala

Hi, since version 8.3 we can do following query: create table newtable ( like oldtable INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES...

Pet

10-28-2009 11:31 AM
Pet

On Sat, 24 Oct 2009 22:58:20 +0000, Saaran Erap wrote: It takes some playing. You will have to suffer things like below: SQL> select * from...

Laurenz Albe

10-24-2009 08:36 PM
Mladen Gogala

Hi, I use "LibPQ.dll" to connect a Posgres Database With Delphi 2009. Did anyone knows how to get a variant representation of query fields ? All...

davidcfres

10-16-2009 11:09 AM
Laurenz Albe

I have just installed postgres on Ubuntu 9.04 using the apt-get installer. It all happened automatically. I wasn’t prompted for any password for the...

gargoyle47

10-14-2009 04:40 AM
gargoyle47

Hello everyone, I'm breaking my head to write a function that returns a table PG8.4 well-formatted to avoid using PHP code. We illustrate the...

Peca's

10-13-2009 05:16 PM
Peca's

Hi, I am considering to use table partitioning for a new application, reading the documentation I found this: "Constraint exclusion only works when...

Coniglio Sgabbiato

10-13-2009 05:54 AM
Coniglio Sgabbiato

Wodka40 <martekprato (AT) gmail (DOT) com> wrote: Use a Dyn-DNS - Service, register your server there. Later you can use the registered dyn-dns -...

Andreas Kretschmer

10-05-2009 03:49 AM
Andreas Kretschmer

Hi all, is it the behaviour shown below normal? I mean, why 1::int << 32 and 1::bigint << 64 gives 1 instead to return an error? db_atm=# select...

Coniglio Sgabbiato

09-22-2009 06:09 AM
Coniglio Sgabbiato

First things first, I'm asking because of idle curiosity not because of any more pressing needs. I know that PostgreSQL is very flexible when it...

Michael Schuerig

09-21-2009 11:47 AM
Michael Schuerig

Hello. Let me know if you can know if a table is locked by a lock Type: Begin Work Lock Table MySchema.MyTable IN ACCESS EXCLUSIVE MODE ..... Unlock...

Enzo Campanella

09-16-2009 10:13 AM
Enzo Campanella

Hi: Just learning postgresql, and SQL. Is this an appropriate place to ask simple questions? If not pls direct me. -- I have been asked to take a...

Anon432 Vqfz

09-15-2009 09:39 PM
Name withheld by request

Hello, I see PostgreSQL doesn't have a real one-byte integral type, like TINYINT. What do you use instead? Karsten

Karsten Wutzke

09-08-2009 10:15 AM
Laurenz Albe