Re: [HACKERS] [GENERAL] to_timestamp() and quarters

In response to Bruce Momjian : > Well, I can easily make it do what you expect, and I don't see many > error returns in that area of the code, so I just wrote a patch that > does what you would expect rather than throw an error. Well, that's great and better than an error, thx. > test=> sel

Re: [pgsql-www] [HACKERS] tribble.postgresql.org - planned maintenance downtime

In response to Alvaro Herrera : > Jaime Casanova escribió: > > > > had your baby born now? > > Still waiting ... You are pregnant? ;-) Hey, and yes: i wish you and your wife all the best and many fun with the baby. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/71

Re: [HACKERS] creating index names automatically?

In response to Peter Eisentraut : > Could we create an option to create index names automatically, so you'd > only have to write > > CREATE INDEX ON foo (a); > > which would pick a name like foo_a_idx. We already do this in a number > of places such as constraint names and sequences without much

Re: [HACKERS] New PostgreSQL Committers

In response to Dave Page : > On behalf of the core team, I'm pleased to announce that the > PostgreSQL Project has expanded it's team of "committers", those > people who are able to make direct changes to the PostgreSQL source > code respository. As the project is extremely conservative about any >

Re: [HACKERS] happy birthday Tom Lane ...

In response to Hans-Juergen Schoenig -- PostgreSQL : > Tom, > > On behalf of the entire PostgreSQL team here in Austria I want to wish > you a happy birthday. > We hope that you fill be a vital part of PostgreSQL for many years to come. +1 -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150,

Re: [HACKERS] use of pg_stat_database

In response to abdelhak benmohamed : > Hellow, > > > > I like to track the number of committed transaction for my database > > So I use the following command > > Select * from pg_stat_database; > > > > The column xact_commit gives me the number of transaction committed > > > > But if

Re: [HACKERS] View running statements

In response to Vlad Arkhipov : > Is there any way to inspect current running statements (optionally full > stack of these statements)? I've found there is error_context_stack > variable in each backend, but it seems there is no way to get this > variable from another backend. It will be great if

Re: [HACKERS] Validating problem in the isn contrib module

In response to Andreas 'ads' Scherbaum : > > Hello all, > > > test=# select is_valid('978-3-937514-69-7'::isbn13); > is_valid > -- > t > (1 row) Nice advertisement for your book... Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) Gn

Re: [HACKERS] non unique value error... pgsql,,help needed.

In response to Shri : > Dear friends, > > I am trying to import db from oracle to pgsql, > > meanwhile facing a difficulty during importing oracle numeric(38) to pgsql > numeric(38) column, Because in oracle that column is unique, but PGsql not > able > to correctly identify different and unique

Re: [HACKERS] How to insert the values of .sql file (dump file) into postgresql 8.1

In response to sai srujan : > Hi > This is srujan and I am beginner of postgresql 8.1 and I have > just stopped using mysql and i would like to use the dump (.sql file) > created in it. I would like transfer the databases in my sql to postgresql > 8.1. > Please do reply. I am wa

Re: [HACKERS] blatantly a bug in the documentation

am Mon, dem 24.11.2008, um 9:02:37 -0500 mailte Tom Lane folgendes: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > Dave Page wrote: > >> It might also be useful to create such a database at initdb time so > >> newbies have something interesting to look at right away. > > > No, there is no need

Re: [HACKERS] blatantly a bug in the documentation

am Mon, dem 24.11.2008, um 13:47:54 + mailte Dave Page folgendes: > On Mon, Nov 24, 2008 at 1:38 PM, Alvaro Herrera > <[EMAIL PROTECTED]> wrote: > > A. Kretschmer wrote: > > > >> Okay, it is an argument. On the other side, it was a question today in > &g

Re: [HACKERS] blatantly a bug in the documentation

am Mon, dem 24.11.2008, um 7:24:47 -0500 mailte Merlin Moncure folgendes: > On Mon, Nov 24, 2008 at 6:02 AM, A. Kretschmer > <[EMAIL PROTECTED]> wrote: > > I hope this is the right place to report a bug/issue in the official > > documentation... > > > > I

[HACKERS] blatantly a bug in the documentation

I hope this is the right place to report a bug/issue in the official documentation... In http://www.postgresql.org/docs/current/interactive/plpgsql-control-structures.html there is an example for a function, cs_refresh_mviews(), chapter 38.6.4. Within this function there are a "PERFORM cs_log('Ref

Re: [HACKERS] Website request -- developer docs along with release docs

am Mon, dem 27.10.2008, um 19:01:14 +0100 mailte Stefan Kaltenbrunner folgendes: > Webb Sprague wrote: > >Could I request that a link to the developer docs be posted along with > >the release docs on > > > >http://www.postgresql.org/docs/manuals/ > > they are already referenced in the developmen

Re: [HACKERS] trigger functions broken?

am Wed, dem 08.10.2008, um 14:29:23 -0400 mailte Alvaro Herrera folgendes: > Hi, > > Trigger functions are supposed to be able to be called only as triggers, > but apparently the check is not working in CVS HEAD: > > alvherre=# create or replace function foo () returns trigger as $$ begin > per

Re: [HACKERS] Command execution

am Thu, dem 03.07.2008, um 23:15:33 +1000 mailte Aaron Spiteri folgendes: > Hi guys, > > I have been following the mailing list and reading the source code > for a little while, and was wandering if someone could fill in the > gaps for me. Does PostgresQL view updates and inserts performed

Re: [HACKERS] Strange issue with GiST index scan taking far too long

am Mon, dem 09.06.2008, um 14:18:50 +0100 mailte Mark Cave-Ayland folgendes: > Hi there, > > I'm currently looking at a bug report in PostGIS where we are getting > extremely long index scan times querying an index in one case, but the > same scan can take much less time if the input geometry i

Re: [HACKERS] get rid of psql welcome message

am Thu, dem 17.04.2008, um 14:39:43 +0200 mailte Peter Eisentraut folgendes: > Around it > was proposed to truncate the psql welcome screen. What do you think about > that? > > Personally, I'd get rid of it all, because it get

Re: [HACKERS] operator suggest " interval / interval = numeric"

am Wed, dem 09.01.2008, um 17:33:00 +0700 mailte Ilya A. Kovalenko folgendes: > > I suggest one more standard date/time operator, to divide one interval > by another with numeric (or float, for example) result. > I.e. something like that: > > database=# SELECT '5400 seconds'::interval / '1 hour'

Re: [HACKERS] Slow count(*)

am Wed, dem 02.01.2008, um 9:29:24 -0600 mailte Abraham, Danny folgendes: > Hi, > > We are looking for a patch that will help us count using the indexes. > > Our product is about 20 times slower on Postgres compared to MS SQL > Server. > > Any ideas? Please show us your SQL and the execution