Britton Wesley ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Cant get source from website for 7.2
Long Description
The link
ftp://ftp.postgresql.org/pub/postgresql-7.2.tar.gz
is broken
Sample Code
No file was uploaded with
On Mon, 24 Sep 2001, Ana Claudia wrote:
> Hello,
>
> Usually, I use Oracle for develop database application. However, I
> change my computer to Linux system (Mandrake 8) and I decide change database
> to Postgresql.
> In Oracle when I create a table where a colum is a char(n) or varchar(n), if
>
This will be fixed in the 7.2 release.
> Hello,
>
> Usually, I use Oracle for develop database application. However, I
> change my computer to Linux system (Mandrake 8) and I decide change database
> to Postgresql.
> In Oracle when I create a table where a colum is a char(n) or varchar(n), if
>
being worked on ... thanks for the reminder ...
On Sat, 22 Sep 2001, Greg A. Woods wrote:
> It's LONG past time you asked IANA to officially register the default
> PGPORT you've been using unofficially for a very long time now!
>
> You are no longer in the middle of an officially unassigned blo
POSTGRESQL BUG REPORT TEMPLATE
Your name : Ricardo Caesar Lenzi
Your email address : [EMAIL PROTE
=?iso-8859-2?Q?=A3ukasz_Odziewa?= <[EMAIL PROTECTED]> writes:
> I have problem with new PGSQL 7.1.3
> I've a table like that TT ( V VARCHAR(10), D DATE, I INTEGER);
> and query "SELECT V || '' || D || '' || I FROM TT;"
> In version 7.1.2 result is '$V$D$I' when $? means text
> representation of ?
[EMAIL PROTECTED] writes:
> INTERSECT fails
I believe this is fixed in current sources (7.2-to-be). The problem
is with INTERSECT (or EXCEPT) as the input to another INTERSECT/EXCEPT.
You could work around it in 7.1 by doing one INTERSECT into a temp
table and then intersecting with that.
I am using PostgreSQL 7.1.2 and I am running into trouble when Vacuuming
a very big DB while others are working on the DB:
21640 pts/0SN 0:00 /usr/local/pgsql/bin/psql -c VACUUM VERBOSE
ANALYZE -d intranet
21641 ?D 3:05 postgres: postgres intranet [local] VACUUM
Status "D"
Stingray ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
[make install] problem with jdbc driver in 7.1.3
Long Description
While I untared all the tarballs and configure it with [--with-java] option, [make],
and [make install]
I have problem with new PGSQL 7.1.3
I've a table like that TT ( V VARCHAR(10), D DATE, I INTEGER);
and query "SELECT V || '' || D || '' || I FROM TT;"
In version 7.1.2 result is '$V$D$I' when $? means text
representation of ?. It's always true even if any $? is NULL.
In version 7.1.3 result is
"Zhang Xiaoming" <[EMAIL PROTECTED]> writes:
> please run below recursion function in 7.1.3
This is fixed in current sources (7.2-to-be).
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
i need a solution how to pass an array into a function and retrieve an
array from a function,itried but encountered many problems itried using
setof while returning but i couldnt solve it can any one help out with
this problem.
if possible send me the example code explaining the way we should
fol
Tamas Vincze ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
INTERSECT fails
Long Description
I've used INTERSECT to get the common rows in 3 simple SELECTs.
If I write the query without grouping parentheses, PG reports 0 rows
can i get a substitution for cursors in postgresql if possible please
mail me back soon.
cheers
chowdary.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Strange ...
The process continued after stopping for a while (and using no CPU time).
Sorry, no bug :)
Hans
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hello,
Usually, I use Oracle for develop database application. However, I
change my computer to Linux system (Mandrake 8) and I decide change database
to Postgresql.
In Oracle when I create a table where a colum is a char(n) or varchar(n), if
I try to insert in this table value bigger than n , I
On Tue, 18 Sep 2001, Marc G. Fournier wrote:
>
>
> go to anoncvs.postgresql.org, not postgresql.org ..
Fails the same.
I used the password postgresql (by cut&paste).
>
> On Tue, 18 Sep 2001, John Summerfield wrote:
>
> > This worked 2-3 days ago: what's changed?
> >
> > vs -z9 -q update
> >
Vince Vielhaber <[EMAIL PROTECTED]> writes:
>> It would seem that that page is out of date. Vince, can you fix it?
> Actually the instructions are correct.
Are they? The last time I subscribed to a new list, the right
incantation was to mail
subscribe list-name my-address
to [EMAIL PR
i have tried using SETOF but icouldnt solve it ,icould get muliple
values but those r not the exact which i expected ,iam getting some junk
values.
the result iam getting is
?column?
> ---
> 136361584
> 136361584
> 136361584
some what like this,please give me a example code so that
On Tue, 18 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > I asked for help. Majordomo doesn't understand that either.
>
> What did you do exactly? The following message brought back a help
> response for me:
I get response like this
subscribe
Illegal c
On Sat, 22 Sep 2001, Vince Vielhaber wrote:
> On Sat, 22 Sep 2001, Tom Lane wrote:
>
> > Vince Vielhaber <[EMAIL PROTECTED]> writes:
> > >> It would seem that that page is out of date. Vince, can you fix it?
> >
> > > Actually the instructions are correct.
> >
> > Are they? The last time I sub
On Sat, 22 Sep 2001, Tom Lane wrote:
> Vince Vielhaber <[EMAIL PROTECTED]> writes:
> >> It would seem that that page is out of date. Vince, can you fix it?
>
> > Actually the instructions are correct.
>
> Are they? The last time I subscribed to a new list, the right
> incantation was to mail
>
On Fri, 21 Sep 2001, Vince Vielhaber wrote:
> On Fri, 21 Sep 2001, Tom Lane wrote:
>
> > John Summerfield <[EMAIL PROTECTED]> writes:
> > > I get response like this
> > > subscribe
> > > Illegal command!
> > > No valid commands processed.
> >
> > > when I send commands according to the inst
On Wed, 19 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > Or if it is reusing them, it's renaming them too.
>
> That is what the "recycling..." message is all about...
>
1) Why rename them?
2) Does anyone have a better idea how it floods my cache?
I'll try again w
John Summerfield <[EMAIL PROTECTED]> writes:
> I get response like this
> subscribe
> Illegal command!
> No valid commands processed.
> when I send commands according to the instructions at
> http://developer.postgresql.org/subunsub.php
It would seem that that page is out of date. Vince, c
On Fri, 21 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > I get response like this
> > subscribe
> > Illegal command!
> > No valid commands processed.
>
> > when I send commands according to the instructions at
> > http://developer.postgresql.org/subunsub.php
>
Hi all!
I have problems wich I can't manage.
psql: ERROR: Function OID 1039 does not exist - one database
and
psql: FATAL 1: Index 'pg_trigger_tgrelid_index' does not exist - second
database
What's going on?
Of course I can't connect to these databases and do anaything like pg_dump.
Miky
[EMAI
It's LONG past time you asked IANA to officially register the default
PGPORT you've been using unofficially for a very long time now!
You are no longer in the middle of an officially unassigned block --
there's an assignment at 5431 now!
Please visit this link and fill out the application A.S.A.
On Wed, 19 Sep 2001, Justin Clift wrote:
> Tom Lane wrote:
> >
>
> > > While trying to retrieve the URL: http://developer.postgresql.org/index.php
> >
> > Where did you get that URL from? AFAIK we have never had such a site
> > name as "developer.postgresql.org".
>
> Hi Tom,
>
> This is the ne
Hi,
please run below recursion function in
7.1.3
---
drop function listTest(int4);create function
listTest(int4)returns textas 'declare mtype alias for
$1; begin if mtype=0 then return
''0''; else return
mtype||listTest(mtype-1);
The instructions at
http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html#ANONCVS do not work.
pgtest@dugite pgtest$ cvs -d
:pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot login
(Logging in to [EMAIL PROTECTED])
CVS password:
cvs login: authorization failed: server postgresql
On Tue, 18 Sep 2001, Marc G. Fournier wrote:
>
>
> go to anoncvs.postgresql.org, not postgresql.org ..
See the instructions at
http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html
If your advice is correct (I've not tried it yet) then the rules are changed and the
werbsite's out
Hi,
thank you for your fast answer. I will try to upgrade, with over 20
production databases not a one-hour job :-)
I will report results to you...
Am I the only one, where this occured??
Greetings
Florian
Tom Lane wrote:
>
> [EMAIL PROTECTED] writes:
> > Stacktrace is:
>
> > #0 0x812ac0c
Ralph ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
The 7.1.3 tar ball from main site produced an error while extracting
Long Description
Hi
I download the latest code release of PostGresql from
http://www.postgresql.org/ft
34 matches
Mail list logo
