It looks like it started off as a permissions problem. I added the
users to the database before trying again and this time it worked fine.
I have attached the log from the original attempt if you wish to have a
look.
Mike
On Fri, 2004-12-17 at 22:35, Tom Lane wrote:
> "Mike G." <[EMAIL PROTECT
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Travis P) would
write:
> Now, on my AIX 5.1 system, /usr/bin/ cc and cc_r are both just
> symlinks back to /usr/vac/bin/xlc. The different program names just
> invoke the different settings. Brad: can you make such a symlink and
> compi
Dear all,
Found a similar message on the archives, but from 2 years ago, and not too
much about this.
(8.0 rc1 the guilty one)
guido=# \d test1
Table "public.test1"
Column | Type | Modifiers
+-+
I asked this on general, but didn't receive any responses. Is it possible
via SQL to identify the time of the last stat reset (or pg_stat_reset()
call)? This is what I'm lacking to be able to measure query activity
volume over time via SQL, i.e., maybe a function similar to the fictitious
pg
That would require that xlc be installed. Neither cc, cc_r, xlc, nor
xlcc (or maybe it was xlcpp?) are available on the systems Brad and I
are using, so that symlink will not work.
As a result, _none_ of these may be remotely considered to be
"universal answers" on AIX.
In effect, there are two
Greetings,
Why does the append resulting from a inheritance take longer than one
resulting from UNION ALL?
summary:
Append resulting from inheritance:
-> Append (cost=0.00..17.43 rows=2 width=72) (actual
time=3.876..245.320 rows=28 loops=1)
Append resulting from UNION ALL:
-> Append (cost
Hello,
with ./configure --prefix=/tmp --enable-thread-safety --with-tcl
--with-perl --with-python --with-krb5 --with-pam -with-openssl
==
All 96 tests passed.
==
Linux bruckner 2.4.25 #1 Wed Feb 25 10:32:54 CET 2004 ppc GNU/Linux
postgresql-8.0.0rc1 buil
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> My feeling about this is "too bad, we are not supporting threading on
>> platforms whose pthread.h doesn't follow SUS".
> I think we have to at least test for this in configure and give them an
> error message there rather than generat
"Mike G." <[EMAIL PROTECTED]> writes:
> In testing RC1 today I attempted to use pg_dump -h cygwin_box mydb | psql -h
> RC1_box mydb
> It started off ok but at somepoint while transferring data over in a table it
> went astray. I started getting rows and rows of syntax errors most of them
> say
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > [EMAIL PROTECTED] wrote:
> >> UX:acomp: ERREUR: "fe-secure.c", ligne 1316 : prototype mismatch: 2 args
> >> passed, 1 expected: sigwait()
>
> > What is your prototype for sigwait()?
>
> Whatever it is, it doesn't agree with the Sing
--On torsdag, december 16, 2004 09.20.50 +0100 Peter Eisentraut
<[EMAIL PROTECTED]> wrote:
Palle Girgensohn wrote:
Not on FreeBSD, since collation is not implemented in unicode
locales. One way would be to implement it in the OS, of course...
Try taking the locale definition files from another s
What exactly does pgmemcache do?
It's the PostgreSQL interface to memcached(8). See
http://www.danga.com/memcached/ for more details.
I am guessing it has to do with PostgreSQL, Memory, and Caching, but
the
readme listed below only talks about how to install it -- not what it
does.
:) Sorry, p
What exactly does pgmemcache do?
I am guessing it has to do with PostgreSQL, Memory, and Caching, but the
readme listed below only talks about how to install it -- not what it
does.
When I tried to fetch this document, I get "Document not found":
http://people.FreeBSD.org/~seanc/pgmemcache/pgmemc
Howdy. As many may have noticed, I've been working on getting
pgmemcache in shape for the 8.0 release. Well, I'm nearly done, but
thought I'd give the folks here on hackers@ a chance to thump on things
and start using it or testing with it. There's now a real installation
process and documen
Hello,
In testing RC1 today I attempted to use pg_dump -h cygwin_box mydb | psql -h
RC1_box mydb
It started off ok but at somepoint while transferring data over in a table it
went astray. I started getting rows and rows of syntax errors most of them
saying "invalid command \N".
All of the
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> This is all about access to the java class images, i.e. the actual byte
> codes that make out the Java functions that will execute. Class files
> are normally grouped into archives called jar files (zip format
> essentially) and the SQL 2003 standard
Tom Lane wrote:
Just out of curiosity, why use a table at all, if you intend to forbid
all SQL-level access to it? Seems to me that what you want is either
a table (C array) hard-wired in the code, or a configuration file.
Andrew Dunstan wrote:
> I'm not sure if I understand exactly what you want,
I have implemented several requested improvements, which I hope will
prove useful. Since this whole piece of work exists for the benefit of
the pg developers, I'm posting some info here.
The latest version includes these features:
. the log page shows the system type near the top "OS/Compiler/Ar
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> I don't think a view would help much. I want to completely prevent the
> user from viewing or changing any data stored in the table. Using a view
> would just move the problem. Now the user must have select access to the
> view in order to call the f
Thomas Hallgren wrote:
vamsi,
Why dont you create a view on the table and access the view rather
than the table. I guess this would resolve the issue.
What ever select statement you want to have on the table you can make
it a select statement of the view. thus restricting the access to the
main ta
vamsi,
Why dont you create a view on the table and access the view rather
than the table. I guess this would resolve the issue.
What ever select statement you want to have on the table you can make
it a select statement of the view. thus restricting the access to the
main table.
Looking forward to
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> ... Is there any way to bypass the
> permissions when I do an SPI call from within a call handler somehow?
No, but you don't have to use SPI. C code can do pretty much what it
wants to.
regards, tom lane
Hi Thomas,
Why dont you create a view on the table and access the view rather
than the table. I guess this would resolve the issue.
What ever select statement you want to have on the table you can make
it a select statement of the view. thus restricting the access to the
main table.
Looking forw
I'd like some views on the following issue.
The pljava function call handler will resolve a class name using a
loader that in turn uses a specific table in the PostgreSQL database.
Hence, the caller of the function must have select permissions on that
table or the function will fail. I would lik
Jan Wieck <[EMAIL PROTECTED]> writes:
> Doesn't cranking up the bgwriter_percent to 100 effectively make the entire
> shared memory a write-through cache? In other words, with 100% the bgwriter
> will allways write all dirty blocks out and it becomes unlikely to avoid an IO
> for subsequent modif
Bruce Momjian <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] wrote:
>> UX:acomp: ERREUR: "fe-secure.c", ligne 1316 : prototype mismatch: 2 args
>> passed, 1 expected: sigwait()
> What is your prototype for sigwait()?
Whatever it is, it doesn't agree with the Single Unix Spec:
http://www.opengro
[EMAIL PROTECTED] wrote:
> This did'nt get thru so I repost it!
>
> 8.0.0rc1 fails to compile on Unixware 714 with --enable-thread-safety :
> CC=cc
> LDFLAGS="-R/usr/local/lib"
> ANT_HOME=/usr/local/jakarta/ant
> JAVA_HOME=/usr/java2
> PATH=$PATH:/usr/local/jakarta/ant/bin
> #PREFIX="-prefix=/data
This did'nt get thru so I repost it!
8.0.0rc1 fails to compile on Unixware 714 with --enable-thread-safety :
CC=cc
LDFLAGS="-R/usr/local/lib"
ANT_HOME=/usr/local/jakarta/ant
JAVA_HOME=/usr/java2
PATH=$PATH:/usr/local/jakarta/ant/bin
#PREFIX="-prefix=/databases/pgsql-v7.4 --with-port=5532"
#DEBUG="
28 matches
Mail list logo