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 != OO
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
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
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
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
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
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
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
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
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
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 entire
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.
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
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)
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!
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. oid's,
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.
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 condition
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
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 - specifically
-- 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 maillingslist
-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
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 fingers,
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;
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
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
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?
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 permissions
28 matches
Mail list logo