hi
i just spent over 30 minutes trying to discover what was wrong.
i was trying to create view:
> create view views.session_user as
brama-> select 1;
ERROR: parser: syntax error at or near "session_user" at character 19
now - i know that session_user is reserver word, but the error message
is tot
Ben Kinsey ([EMAIL PROTECTED]; [EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Cannot manually log in to database.
Long Description
We are receiving the following error when trying to manually log in to the the
database:
okapvi
Hi,
My name is Catarina Mónica, and I trying to install PostgreSQL 7.3 in a
PPC860 processor and I not being sucessfull in the instalations.
I followed all the instructions given by you but the problem is when I do
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
I always get a message like th
On Mon, 20 Jan 2003, Tom Lane wrote:
TL> [EMAIL PROTECTED] writes:
TL> > The following line:
TL> > SELECT 1875/1000.0
TL> > produces different results. In 7.2.3 it is:
TL> > ?column?
TL> > -
TL> >1.875
TL>
TL> > while in 7.3.1 it is:
TL> > ?column?
TL> > ---
Sir,
In createdb execution the following error has occured.
psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
createdb: database creation failed
We created a unix socket, then c
IpcMemoryCreate: shmget(key=5432001, size=1417216, 03600) failed: Invalid
argume
nt
This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter. You can either
reduce the request size or reconfigure the kernel with larger SHMMAX.
To reduc
Hi!
Our admin upgraded PostgreSQL 7.2.3 to 7.3.1 a while ago (dump and
restore).
Previously I had a table with a long name (>32 chars), which at creation
was truncated to proper length. The table was used from a perl-script
(using the full name) doing mostly DELETE's and INSERT's. The user
ac
I am encountering problems with IN selections.
I am trying this query :
delete from status where status_id not in (select distinct status_id
from company);
"status_id" is a foreign key in "company".
It does not delete any records from status table whereas it should
because the sub query returns
Sir,
In createdb execution the following error has occured.
psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQ
[EMAIL PROTECTED] writes:
> okapview# /opt/pgsql-7.1.3/bin/psql -U postgres -d AppliedView
> psql: connectDBStart() -- connect() failed: No such file or directory
> Is the postmaster running locally
> and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> Stopping and sta
Christopher Hodson ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
explain analyze causes postgres to die
Long Description
running explain analyze on the code below causes postgres to crash. See below for
error messages.
Catarina Monica <[EMAIL PROTECTED]> writes:
> My name is Catarina Mónica, and I trying to install PostgreSQL 7.3 in a
> PPC860 processor and I not being sucessfull in the instalations.
What OS (and what version) are you running on that?
> I always get a message like this
> The program
> '/usr
=?ISO-8859-1?Q?J=E9r=F4me?= Calais <[EMAIL PROTECTED]> writes:
> I am encountering problems with IN selections.
> I am trying this query :
> delete from status where status_id not in (select distinct status_id
> from company);
I'll bet the sub-select yields some NULL rows? If so, this is not a
bu
[EMAIL PROTECTED] writes:
> explain analyze causes postgres to die
Can't do much with this, since you have not provided a complete test
case.
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comman
Andreas Lange <[EMAIL PROTECTED]> writes:
> After the upgrade the calls to the table didn't truncate the name any
> longer (as expected), and thus didn't find the table. So I renamed the
> table to it's full length name, and now the scripts did find the table
> again. But - deletes were no longe
[EMAIL PROTECTED] writes:
> psql: could not connect to server: Connection refused
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Are you sure the postmaster is running? I don't see how you could get
a "connection refused" on
Jérôme Calais writes:
> delete from status where status_id not in (select distinct status_id
> from company);
>
> "status_id" is a foreign key in "company".
>
> It does not delete any records from status table whereas it should
> because the sub query returns some records.
There are probably null
17 matches
Mail list logo
