While having trouble extending the CREATE VIEW grammar i discovered this:
bommel@[local]:yomama #= CREATE VIEW vtest as SELECT * from abteilung WITH;
CREATE VIEW
I can reproduce this on 8.0.0beta1 && beta3 and in a 7.4.2 production

This may be mostly a documention issue:
I have a function with two parameters that returns an array: text[].
I want to access just the first element of that array within
my SQL statement.

is it possible to output the branches before the detection of infinite
recursion when using connectby()? My work is about software evolution
analysis. One of the questions i am interested in is class usage. For
example, class A uses B, B uses C, C uses D, and finally D uses A. I ...

I've been thinking more about Gaetano Mendola's report of a
FlushRelationBuffers failure during VACUUM FULL.  I still don't see how
that could happen in 7.4, but I do see a real related risk in 8.0.
The problem is that in many situations we assume that a lock on an

Hello dear all,
[Please CC your replies to me as I am on the digest mode]
Here's finally a very high-level design proposal of the pg_upgrade feature
I was handwaiving a couple of weeks ago. Since, I am almost done with the

Consider:
template1=# create table baz (test numeric);
CREATE TABLE
template1=# insert into baz values (5);

First error know to be caught by the buildfarm - this is one of DarcyB's
test client machines. All the details below were pulled from the
buildfarm test server's database.
This report is from HEAD, but it might also apply to earlier branches.

I'm just moved my Postgres client project from Mac 10.2.8 to 10.3.5.
It's an Objective-C program that links to libpq.a (the header file is
libpq-fe.h). However, when I try to compile now I get the following
linking error:

I keep getting this error.
DETAIL:  Failed system call was shmget(key=5432001, size=34037760, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared
memory segment exceeded your kernel's SHMMAX parameter.  You can

Is there a way to do COPY FROM STDIN from sql? So, remotely I could
run the copy command and somehow push the info over instead of having
it on the server.
-Josh

Maybe that a basic question ,sorry.
I have to 2 tables :
    Column     |            Type             | Modifiers
----------------+-----------------------------+-----------

I have been trying to troubleshoot a PL/R related issue on-and-off for a
few weeks now, but this morning ran into what appears to be a more
general issue related to 7.4.5 on x86_64. A full backtrace is below, and
in it you can see that PL/R is never reached (but PL/pgSQL is). ...

I'm running postgres 7.4.5 on a linux box, this morning I got this error on my logs:
WARNING:  FlushRelationBuffers("exp_provider", 1836): block 1460 is referenced (private 0, global 1)
ERROR:  FlushRelationBuffers returned -2
DEBUG:  AbortCurrentTransaction

still doing my switch from MySQL to PgSQL, and can't figure out what
the comparable function would be for this:
In MySQL, to store a big secret (like a credit card number) in the
database that I didn't want anyone to be able to see without knowing

I'm an application developer trying to understand a pg data partition
issue. We are storing large objects (gifs) at a rate of about 1GIG /day.
After about a week, most of the objects are recycled -- that is, an
insert triggers a delete of a similar object. The postgres data