Is there a way to grant a user with all privileges on a database? Something
like Informixs GRANT dba?
--
System Administration: It's a dirty job,
but someone told I had to do it.
-
Martín Marqués email: [EMAIL PR
El Vie 26 Ene 2001 17:02, Chean Fonk Joe Thong escribió:
> Hi to all,
>
> Currently I'm trying to upgrade my PostgreSQL from 6.5
> to 7.0.2 with rpm files on my Redhat 6.1 with Glibc
> 2.1.3. The installation won't continue because RPM
> Manager told me that I need libc.so.6 (>= GLIBC 2.2).
I ha
El Mié 24 Ene 2001 15:07, David Wall escribió:
> Is there a place where I can see what the new features for 7.1 are expected
> to be? I'm hopeful for native BLOB support
check the todo list.
--
System Administration: It's a dirty job,
but someone told I had to do it.
El Mié 24 Ene 2001 08:06, Zak McGregor escribió:
>
> Other irritations I've found with MySQL are (briefly):
> - no subselects (makes for ugly hacks in code)
> - no views
> - no foreign keys
Didn't know they didn't have foreign keys. :-(
> - no constraint support
> - completely lacking date integ
El Mar 23 Ene 2001 12:38, Frank Joerdens escribió:
> I am faced with the task of installing, configuring, and tuning my
> database, which is currently running under Linux, under Solaris 7 on a
> brand-new and shiny Sun UltraSPARC (3 CPUs, 768 MB RAM), because the
> sysadmin at the site hasn't used
El Lun 22 Ene 2001 17:56, Florent Guillaume escribió:
> > > select recordid from t1 where oid = $lastoid;
> > > Because the last select could return several lines.
> >
> > Shouldn't! oids are unique over the whole database server (I'm right on
> > this?) So you should have only one or non.
>
> Wel
Sorry if I missed something.
El Vie 19 Ene 2001 11:08, Florent Guillaume escribió:
> > Unless your application logic tries to use OIDs as row identifiers,
> > duplicate OIDs in user tables are not a problem.
>
> Hmmm, that means that the following, which I use, is not strictly correct :
>
> creat
El Mié 17 Ene 2001 15:49, Gareth Cantrell escribió:
> Hi:
>
> I've been trying in vain for over 5 hours now to compile
> PostgreSQL 7.0.3 on Solaris 7 (2.7).
>
> I keep getting the following error:
>
> ld -G -o libpq++.so.3.1 pgconnection.o pgdatabase.o pgtransdb.o
> pgcursordb.o pglobject.o -L..
I have a linux instalation (from rpm) of postgres-7.0.3, which puts the logs
of the server (AFAIK) in /var/log/postgresql.
But the file is empty, and I start making activity on the database and it
stays empty. Does anyone have an idea of what is happening?
Also, on a Solaris 8 machine, compiled
El Mar 19 Dic 2000 10:29, Nick Fankhauser escribió:
> I believe it has to be each table- Oracle has a nice "all tables" option
> which might be worth the developer's consideration on the next round. I
> need to do this regularly, so I'll probably see if I can write a tool to
> create a SQL script.
El Lun 18 Dic 2000 12:43, Wade D. Oberpriller escribió:
> You should be able to do the following:
>
> CREATE TABLE table1 (
> field1 INTEGER CHECK ((field1 >= 0) AND (field1 <= 10))
> );
Thanks!!! Didn't know that!
--
System Administration: It's a dirty job,
but someone told I had to do i
Hi,
how should I write a constraint that can keep an INT field with values
between 0 and 10? Do I have to use two checks on the same field?
TIA
--
System Administration: It's a dirty job,
but someone told I had to do it.
El Mar 12 Dic 2000 11:05, Bruce Momjian escribió:
>
> I thought I fixed that, but it seems to have moved again. Vince, is
> this the page that gets generated automatically?
Sorry, but where (in which manual) can I find specific information on how
TOAST works, how to use WAL, and how to make a g
On Monday 11 December 2000 15:56, Juriy Goloveshkin wrote:
> is it posible to shop query time in psql frontend?
What do you mean with: shop query time?
--
System Administration: It's a dirty job,
but someone told I had to do it.
I know I bothered with this, but I just don't get it.
Lets say I have a test table like this in a certain database:
CREATE TABLE test (
id_test SERIAL,
blob_text oid
);
Now I want to insert a good chunk of text in the blob_text field with PHP.
PHP has some postgres functions like p
On Thursday 30 November 2000 14:48, The Hermit Hacker wrote:
> Note that this is a Linux limitation ... and even then, I'm not quite sure
> how accurate that is anymore ... the *BSDs have supported >2gb file
> systems for ages now, and, since IBM supports Linux, I'd be shocked if
> there was a 2GB
On Tuesday 28 November 2000 10:56, Gordan Bobic wrote:
> Sorry for replying to my own email, but I've just stumbled upon an article
> that seems to imply that v7.1 will support unlimited record lengths. Is
> this the case? When is v7.1 due for release? Is a beta available?
The last thing I heard
I'm on Potsgres 7.0.2 on Solaris, and I get a parse error when I try to
create this table:
CREATE TABLE ubicacion (
id SERIAL,
id_palabra INT,
tablaINT NOT NULL,
id_row INT NOT NULL,
CONSTRAINT "fk_ubic_id_palabra" FORE
On Fri, 17 Nov 2000, Philip Hallstrom wrote:
> What is the value for MinSpareServers in your apache's conf? If that's
> set to 20, then even if you only hit your site 20 times (one for each),
> that many apache processes will continue to live and therefore keep a db
> connection open..??
>
> Wh
On Jue 16 Nov 2000 22:54, Marko Kreen wrote:
> On Thu, Nov 16, 2000 at 01:33:08PM -0400, The Hermit Hacker wrote:
> >
> > I run PHP4 and IMP (http://www.horde.org) and we've gotten then to remove
> > the useof pg_pconnect() since it is broken. Broken how, you might
> > ask? Well, I ran on a stan
On Jue 09 Nov 2000 07:56, Marcos wrote:
> hi,
>
> i am creating a table and i want to add an auto incrementable field
>
> is that correct?
>
> psql ival << EOF
> create table partes (
> codigo int not null auto_increment,
WRONG. That is not ANSI-SQL. That is MySQL.
Define it as SERIAL, ju
> I cant speak for PHP, but in perl or in C you have a documented module
> that will handle this things. (in perl its DBD::Pg). You dont need to
> save the text to a file first, you can write directely into the blob.
>
> The principal things are explained in the postgres-programmers-guide
> you c
I want to find out how confused I am. ;-)
I'm testing something on a Postgres 7.0.2 database. I made a small table with
two columns, one serial and the other TEXT, and tried to make serveral
inserts with PHP.
Some went OK, until I tried to insert a large amount of text. It failed. Of
course, I
My question is if the list configuration for the general and the developers
list is going to stay this way or change?
I have a filter that looks for the Sender header and that line has changes
since 2 days ago from
Sender: [EMAIL PROTECTED]
to
Sender: [EMAIL PROTECTED]
is it goning to stay t
Hi, I have a par of questions.
1) I've read alot abot the 8K row limitation on pgsql. What would happen if I
had a table defined with two columns, one serial and the other TEXT, and in
one insert the texct that goes in the column with type TEXT has 80K or even
more?
2) Is it posible to storag
Has somebody made a script to start and stop the postmaster on Solaris? I'm
having a hard time trying to do the stop part of the script, I just can't
find an elegant way to kill the process and eliminate the socket lock that's
left in /tmp.
bye,
--
"And I'm happy, because you make me feel go
On Wed, 11 Oct 2000, Asidha Luhwidyanto wrote:
> What;s the new in Postgresql 7.1 ?
TOAST and WAL
I think these are big changes that will make me think about postgresql as a
big time competitor against the big commercial database engines.
WAL is a backup system.
TOAST is a system for worki
How far are we from seeing the version 7.1 out?
--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-
Martín Marqués email: [EMAIL PROTECTED]
Santa Fe - Argentinahttp://math.unl.
On Mon, 9 Oct 2000, Bruce Momjian wrote:
> > On Mon, 09 Oct 2000, Peter Eisentraut wrote:
> > > John Menke writes:
> > > > Can you install postgresql on Win98?
> > >
> > > Clients only.
> >
> > And on Windows NT?
>
> Cygwin can run the full server on NT.
Where can I get the binarys?
"And I'm
On Sat, 07 Oct 2000, Tim Kientzle wrote:
>
> I've been using MySQL for initial development; it has pretty
> clean and easy-to-use BLOB support. You just declare a BLOB
> column type, then read and write arbitrarily large chunks of data.
> In Perl, BLOB columns work just like varchar columns; in J
On Thu, 28 Sep 2000, Gilles DAROLD wrote:
> Hi,
>
> After taking a look to many way from fast search into full text (flat
> field with regrep, UDMSearch,
> and other stuff like contrib FTI) i have developped my own indexer and
> fast search.
> It's still specific to my database but can be easily
I'm trying to get IMP to work, and I need to create 2 databases which I have
problems creating.
What I get is this:
GRANT SELECT, INSERT, UPDATE ON active_sessions, auth_user, auth_user_md5 TO nobody;
ERROR: aclparse: non-existent user "nobody"
I don't know how to add the user nobody to grant
32 matches
Mail list logo
