Shahaf wrote
>
> I'm running into the same issue. I can "create language plperl;"
> successfully, but as soon as I try to create a function (as shown above),
> Postgres dies.
>
> Guimaraes - did you find a solution using standard installers?
>
No, I didn’t. In fact, þanks God I did not have
hello sir,
I have written a function. The language used
is sql. I am not getting error if I assign an alias to a variable or if I try to
declare any of the variable.
I could figure out that I require support if
plpgsql, but I am not able to get the suppor of this language. I have
tried
Noticed this when I had a typo on the configure command line. The configure
script does not catch the following bogus option:
--enable-bogosity
That might seem like no biggie, but it also doesn't seem to notice this
error:
--enable-thread-safeyt (notice the mispelling)
Makes
Clean build of pgsql 7.4.5 on HPUX B.11.23 on ia64 with
--enable-thread-safety fails ... :(
$uname -a
HP-UX ... B.11.23 U ia64 0144848471 unlimited-user license
$cd postgresql-7.4.5
$./configure --enable-thread-safety --without-readline --without-zlib
...
checking pthread.h usability... yes
ch
$uname
HP-UX ... B.11.23 U ia64 1562128462 unlimited-user license
$more ./regression.diffs
*** ./expected/float8.out Thu Sep 25 01:58:06 2003
--- ./results/float8.outTue Oct 26 20:28:09 2004
***
*** 249,255
SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
ERRO
This is for PostgreSQL 7.4.6...
On Tuesday October 26 2004 7:31, Ed L. wrote:
> $uname
> HP-UX ... B.11.23 U ia64 1562128462 unlimited-user license
>
> $more ./regression.diffs
> *** ./expected/float8.out Thu Sep 25 01:58:06 2003
> --- ./results/float8.outTue Oc
The following queries result in a dropped sequence, but IMO should not:
create table foo(id serial);
create table bar(id integer not null nextval('foo_id_seq'::text));
alter table foo alter column id drop default;
drop table foo;
Once dependence between foo and foo_id_seq has been removed, a dro
On Sunday December 5 2004 12:54, Ed L. wrote:
> There appears to be a race condition in which dropping a view and
> replacing it with an identically-named table inside one transaction while
> other transactions are concurrently updating the view/table causes the
> following error:
On Sun, 05 Dec 2004 14:54:38, Tom Lane wrote:
> On Sunday December 5 2004 12:34, Ed L. wrote:
> > The following queries result in a dropped sequence, but IMO should not:
> >
> > create table foo(id serial);
> > create table bar(id integer not null nextval('foo_id_s
On Monday December 6 2004 9:45, Ed L. wrote:
> On Sun, 05 Dec 2004 14:54:38, Tom Lane wrote:
> > On Sunday December 5 2004 12:34, Ed L. wrote:
> > > The following queries result in a dropped sequence, but IMO should
> > > not:
> > >
> > > create ta
On Monday December 6 2004 11:50, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > I can see the point of *not* dropping the sequence unless the
> > owning column is dropped. I just don't see the point of disabling the
> > useful ability to dec
Note the queries below generate the same result regardless of the timezone
input:
% env | grep TZ
PGTZ=CST6CDT
TZ=CST6CDT
% psql -t -c "select version()"
PostgreSQL 8.0.0beta3 on i686-pc-linux-gnu, compiled by GCC 2.96
% psql -t -c "select '1970-01-01 00:00:00+09'::timestamp + '1089352800
sec
This is not a regression test failure, but looks like one...
Version: PostgreSQL 7.4.6 on ia64-hp-hpux11.23, compiled by GCC gcc (GCC) 3.4.2
$ file postgres
postgres: ELF-64 executable object file - IA64
$ cat regression.diffs
*** ./expected/float8.out Thu Sep 25 02:58:06 2003
--- .
PostgreSQL 7.4.8 on ia64-hp-hpux11.23, compiled by
GCC gcc (GCC) 3.4.2
$cat ./regression.diffs***
./expected/float8.out Thu Sep 25 02:58:06
2003--- ./results/float8.out Tue
Jun 14 18:55:08 2005** 249,255 SELECT ''
AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
Fyi, I got this regression diff on my IBM T41 laptop running new
install of Fedora Core 4... no idea why...
PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.0.0 20050519 (Red Hat 4.0.0-8)
/pgsql/builds/postgresql-7.4.8/src/test/regress
% cat ./regression.diffs
*** ./expected/
On Tuesday June 21 2005 11:22 am, Ed L. wrote:
> Fyi, I got this regression diff on my IBM T41 laptop running
> new install of Fedora Core 4... no idea why...
>
> PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC gcc
> (GCC) 4.0.0 20050519 (Red Hat 4.0.0-8)
>
>
>
checking build system type... ia64-hp-hpux11.23
checking host system type... ia64-hp-hpux11.23
...
checking sys/ipc.h presence... yes
configure: WARNING: sys/ipc.h: present but cannot be compiled
configure: WARNING: sys/ipc.h: check for missing prerequisite headers?
configure: WARNING: sys/ipc.
On Thursday September 8 2005 12:20 pm, Ed L. wrote:
> checking build system type... ia64-hp-hpux11.23
> checking host system type... ia64-hp-hpux11.23
> ...
> checking sys/ipc.h presence... yes
> configure: WARNING: sys/ipc.h: present but cannot be compiled
> configure:
On Thursday September 8 2005 2:18 pm, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > In file included from pg_sema.c:22:
> > /usr/include/sys/ipc.h:51: error: parse error before "cid_t"
> > /usr/include/sys/ipc.h:56: error: parse error bef
On Thursday September 8 2005 3:48 pm, Ed L. wrote:
> On Thursday September 8 2005 2:18 pm, Tom Lane wrote:
> > "Ed L." <[EMAIL PROTECTED]> writes:
> > > In file included from pg_sema.c:22:
> > > /usr/include/sys/ipc.h:51: error: parse error before
>
On Thursday September 8 2005 4:08 pm, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > I see sys/ipc.h already #includes sys/types.h, though.
>
> Possibly there's some magic #define needed to expose the cid_t
> definition?
>
> We ha
Not sure if this is a bug or by design in 8.1.2. Using the
following:
log_connections = on
log_disconnections = on
log_duration = on
log_statement = 'all'
log_line_prefix = '%m [%p] %u %r %d %x '
...the transaction is not printed with the duration (it prints 0
instead).
Ed
--
Not sure this is a bug, but I'm seeing the following message:
pg_ctl: another postmaster may be running; trying to start
postmaster anyway
FATAL: pre-existing shared memory block (key 9812001, ID 655374)
is still in use
HINT: If you're sure there are no old server processes still
running, rem
The following bug has been logged online:
Bug reference: 4617
Logged by: Raymond L. Naseef
Email address: nas...@egr.msu.edu
PostgreSQL version: 8.3 & 7.4
Operating system: FreeBSD
Description:JDBC Drivers 8.2/8.3 return no ResultSet
Details:
Below is query u
Thank you in advance.
I realize only the superuser and table owner can change the ownership of a
table, but is there a way to modify the database owner privileges to do
the same?
Example:
userA is database owner and creates/owns 20 tables
superuser creates userB
superuser changes database owne
Magnus Hagander wrote:
> Using MD5 for passwords doesn't, afaik, actually require
> collision-resistance. It requires resistance against preimage-attacks,
> which there are none for MD5. At least not yet.
Marc Stevens et al have a chosen prefix attack on MD5 (similar to a
second preimage attack, bu
Your name : Christopher L. Cousins
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : AMD K7 (Athlon) ("AuthenticAMD"
686-class) 705 MHz
Operating System (example: Linux
On Wed, Jul 05, 2000 at 12:03:46PM -0400, Tom Lane wrote:
> "Christopher L. Cousins" <[EMAIL PROTECTED]> writes:
> > Using PHP4 or PHP3, the following query will ~sometimes~ cause the
> > backend to terminate. It depends the value of $searchstr and appears
>
On Thu, Jul 06, 2000 at 12:48:53AM -0400, Tom Lane wrote:
> "Christopher L. Cousins" <[EMAIL PROTECTED]> writes:
> > I have been able to make the backend crash using psql. I also took a dump
> > of the database while I had some known values that would trigger the
On Thu, Jul 06, 2000 at 03:10:28AM -0400, Tom Lane wrote:
> "Christopher L. Cousins" <[EMAIL PROTECTED]> writes:
> >> I don't think I believe that backtrace. Could you send me the dump
> >> file?
>
> > The core file is never written to dis
On Thu, Jul 06, 2000 at 03:18:59AM -0400, Tom Lane wrote:
> "Christopher L. Cousins" <[EMAIL PROTECTED]> writes:
> > What I can do is create a fake dataset, find some values that cause the problem,
>then give
> > that to you. Would that be acceptable?
>
>
On Thu, Jul 06, 2000 at 03:18:59AM -0400, Tom Lane wrote:
> "Christopher L. Cousins" <[EMAIL PROTECTED]> writes:
> > What I can do is create a fake dataset, find some values that cause the problem,
>then give
> > that to you. Would that be acceptable?
>
>
On Thu, Jul 06, 2000 at 05:03:21PM -0400, Tom Lane wrote:
> "Christopher L. Cousins" <[EMAIL PROTECTED]> writes:
> > #2 0xdaa41 in fixedlen_like (
> > s=0x1eeff4 "MQZSVRSJDSFR"... , p=0x1bdbe0,
> > charlen=12) at like.c:53
> > #3 0
date_part('day', DATE '2001-07-29')) OR
(
date_part('month', DATE '2001-08-05') =
date_part('month', event.t_begin) AND
date_part('day', event.t_begin) <
running on an Athlon
1.0Ghz system. Please let me know what information could be helpful in
tracking down this "bug." Is it a bug?
-=Fozz
--
-----
Doran L. Barton <[EMAIL PROTECTED]> - Chief Super Hero - Iodyna
I believe I have found a bug in the vacuum procedures. I am helping out
a friend who is running a "alumni" sites of sorts using postgresql 7.2.3
as the backend. The first page someone loads does most of the queries
that any page will need and stores it in a session file (php style) and
hands a co
I believe I have found a bug in the vacuum procedures. I am helping out
a friend who is running a "alumni" sites of sorts using postgresql 7.2.3
as the backend. The first page someone loads does most of the queries
that any page will need and stores it in a session file (php style) and
hands a co
dbsize.c was not updated to use the new tablespace-aware function.
I am not well versed enough with the new function to know if "GLOBAL..."
was the correct default for what dbsize is trying to do. I just thought
you guys might want to know.
Thanks for the WORLD'S GREATEST OpenSource DB!
-- /v
I though of that, but it's linked into the binary. Maybe this is a
problem with the Sun build and not the code? How do I get in touch
with the build maintainer?
--Dave
to...@i2:~$ /usr/ccs/bin/nm -o /usr/postgres/current/bin/64/psql |
grep readline
[542] |20547260|000
Hi Jason. Here Josep M. from Spain.
I need to install the postgreSQL in a win2k, but...where can I find the
best documentation about it ? (for example, I've been looking for the
famous doc/FAQ_MSWIN but I can't find it...).
thanks...
j.m.
---(end of broadcast)--
The following bug has been logged online:
Bug reference: 3853
Logged by: Christopher Brian L. Jurado
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: Windows XP/2003
Description:Autovacuum not working
Details:
I can see in the server
The following bug has been logged online:
Bug reference: 1672
Logged by: Gregory L Miller-Kramer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.2
Operating system: CentOS 4.0
Description:Postgres 8.0 doesn't return errors.
Details:
To Whom it may co
I do appreciate your assistance and I will endeavor to make sure to try what you suggest before replying.
Thank you,
Greg Miller-Kramer
On Tue, 2005-05-17 at 17:05 -0600, Michael Fuhr wrote:
On Tue, May 17, 2005 at 05:05:03PM -0400, Gregory L Miller-Kramer wrote:
> On system One I enter the
43 matches
Mail list logo
