Thanks, I've never seen that page before. I guess it must be new.
Thanks.
On Wed, Dec 10, 2003 at 07:37:16AM +0100, Peter Eisentraut wrote:
> Martijn van Oosterhout wrote:
> > I was just trying to find a query what would determine, given a
> > username, what tables they can see and what permissio
Martijn van Oosterhout wrote:
> I was just trying to find a query what would determine, given a
> username, what tables they can see and what permissions they have on
> those tables. Obviously this would only work for superusers, but does
> anyone have any ideas?
http://www.postgresql.org/docs/cur
Hi,
I have installed postgres in a non-standard location with this call to
configure:
./configure --prefix=/scratch/postgresql-7.4/
--exec-prefix=/scratch/postgresql-7.4 --libdir=/scratch/postgresql-7.4/lib
make
make install
I then put /scratch/postgresql/bin/ in my PATH and /scratch/postgresq
I was just trying to find a query what would determine, given a username,
what tables they can see and what permissions they have on those tables.
Obviously this would only work for superusers, but does anyone have any
ideas?
A while ago someone tried using the like operator, would that be the bes
Thomas Zehetbauer wrote:
Why do I have to use FOUR queries to accomplish the same result I can
get from MySQL with only ONE query:
alter table users add column $ColumnName text;
alter table users alter column $ColumnName set default '';
update users set t_shirt_size='' where $ColumnName is null;
a
> Bruce Momjian wrote:
> >"I'm tired of MySQL being beaten up by the PostgreSQL guys. I am going
> >to fight back! Where is my sword?"
>
> Carefull Bruce. The MySQL sword is razor sharp only on one side and is
> missing the handle! But if you succeed to pull it out without cutting
> off your f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I think that's been part of pgadmin 2
On Monday 08 December 2003 10:49 pm, Randy Harris wrote:
> I've been scouring the PostgreSQL web site and have found several
> references to a Database Migration Wizard. I was unable, however, to find
> any deta
Martin Hart <[EMAIL PROTECTED]> writes:
> db=# select '(1,2)'::point::text;
> ERROR: cannot cast type point to text
> the only way i have been able to achieve it is to write a plpgsql function:
> while this appears to work fine - I am wondering if I am missing something
> fundamental - specifica
Philippe Lang wrote:
Hello,
This is exactly what I needed. It works just fine for me, except when a function is being created through the pgAdmin III (version 1.02 under Windows). In this case, I think functions are being stored in the database with a CR/LF at the end, what the plpgsh engin
> Unlikely as PostgreSQL doesn't support read uncommitted...
You're right - Postgres only offers two levels "PostgreSQL offers the Read
Committed and Serializable isolation levels."
> I think you need to play with a couple of psql sessions to sort this out.
> I think you might have a race conditi
Stephan Szabo wrote:
On Tue, 9 Dec 2003, Brendan Jurd wrote:
Hi all,
I read on the manual page for Inheritance that:
"A limitation of the inheritance feature is that indexes (including
unique constraints) and foreign key constraints only apply to single
tables, not to their inheritance children.
> The only way to reset oids is to destroy the entire data directory and
> initdb again. In recent versions you can create tables
> without oids, thus
> reducing their usage.
Today we have oid's > 2147483647 , what happens, if we have more than
allowed ? I remember it was about 4 billions max. oi
-- Forwarded message --
Date: Tue, 9 Dec 2003 12:55:55 +0100
From: Ferdinand Smit <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [ADMIN] Full textsearch & gist
Hi,
I'm experimenting with tsearch2. It works very good, but i have a few
questions:
- Is there a tsearch maillingslis
Hello,
This is exactly what I needed. It works just fine for me, except when a function is
being created through the pgAdmin III (version 1.02 under Windows). In this case, I
think functions are being stored in the database with a CR/LF at the end, what the
plpgsh engine does not like at all!
On 09/12/2003 11:47 John Sidney-Woollett wrote:
Hi
I have a function called from a java app (via jdbc) which identifies
images awaiting processing. This is determined by checking the
WPImageStateID field on the WPImageHeader record (1=awaiting, 2=being
processed, 3=complete).
The (jdbc) connection
Hi
I have a function called from a java app (via jdbc) which identifies
images awaiting processing. This is determined by checking the
WPImageStateID field on the WPImageHeader record (1=awaiting, 2=being
processed, 3=complete).
The (jdbc) connection to the database is a standard one so I suspect
On Tue, 2003-12-09 at 00:54, Tom Lane wrote:
> Chris Travers <[EMAIL PROTECTED]> writes:
>
> I guess I'm questioning the assumption that that's not possible.
> Having many users share an account when you want to enforce different
> permissions for each user seems like a fundamentally bad idea. P
Hi Martijn,
> > There must be a global value which sets the last oid, i need to set this
to
> > "1" or to fill up from 1 , so i have no oids >= 2147483647 for the near
> > future.. how can i do this ? Fixing the mentioned above will take more
time.
>
> The only way to reset oids is to destroy the
The only way to reset oids is to destroy the entire data directory and
initdb again. In recent versions you can create tables without oids, thus
reducing their usage.
Hope this helps,
On Tue, Dec 09, 2003 at 11:22:15AM +0100, Gellert, Andre wrote:
> Hello,
> i have a bug in a php application bas
Hi all,
PG 7.4 beta4 (not had a chance to upgrade yet :-(
how do i cast something of type point to text?
db=# select '(1,2)'::point::text;
ERROR: cannot cast type point to text
db=# select text('(1,2)'::point);
ERROR: function text(point) does not exist
HINT: No function matches the given na
Hello,
I want to know whether PostgreSQL support cancel() [cancel
JDBCStatement]. I want to abort a long running query issued/executed by a
java application using JDBC driver to connect to the database. Thanks.
-Prahalad
---(end of broadcast)-
Philippe Lang wrote:
Hello,
How can open a unix shell from a PLPGSQL function / trigger?
I would like to send an email from a postgres database, and also send some unix commands to the server, through the database...
http://archives.postgresql.org/pgsql-novice/2002-01/msg00098.php
HTH
Shridha
Hello
If you require only send mail, try pgsendmail.
http://sourceforge.net/project/showfiles.php?group_id=35804.
You can use plsh too.
http://developer.postgresql.org/~petere/pgplsh/
regards
Pavel Stehule
On Tue, 9 Dec 2003, Philippe Lang wrote:
> Hello,
>
> How can open a unix shell from a
Hello,
i have a bug in a php application based on postgres 7.2.2 , which cannot
handle oid's greater than
2147483647 .
So I have to reset the used oids to start from 1 again, so that we have more
time to correct this bug, I tried to delete dropdb, createdb and read back
the data, but the oids are
Why not create a cron script which connects to the database and queries
your tables (using psql). Have it generate an output (shell) script which
your original script then calls.
Unfortunately I know how to do this with Oracle, but not postgres *yet*,
but I suspect that in principle this idea will
Hello,
How can open a unix shell from a PLPGSQL function / trigger?
I would like to send an email from a postgres database, and also send some unix
commands to the server, through the database...
Thanks
-
Philippe Lang
Attik System
http://www.attiksystem.ch
--
Patrick Hatcher wrote:
Pg: 7.4.
I thought there was supposed to be switch to allow dumping of schema X from
a database in version 7.4? But I don't see one.
Is it still not possible?
pg_dump --schema does not do it?
http://developer.postgresql.org/docs/postgres/app-pgdump.html
Shridhar
On Tue, Dec 09, 2003 at 01:11:03AM +0100, Socketd wrote:
> Hi all
>
> I can see Postgresql calls itself a "object-relational database
> management system", but what's the object part of it?
>
> I have found inheritance, but are there more OO features in postgresql?
object-relational database !=
28 matches
Mail list logo
