On Wed, Dec 20, 2000 at 10:35:01AM +1100, Mark Cowlishaw wrote:
> > According to "Postgres: Introduction and Concepts", varchar is slower
> > than char. So if you (like me) want to use char and get rid of the
> > padding spaces, you may use a regex replacement, as in
> >
> > while (@row=$r
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> According to "Postgres: Introduction and Concepts", varchar is slower
> than char. So if you (like me) want to use char and get rid of the
> padding spaces, you may use a regex replacement, as in
> while (@row=$result->fetchrow)
> {
Just recently added this functionality to phpPgAdmin. You can now update
the ACL of all the objects (tables, sequences, views) of a database at the
same time.
This will be part of the next release (2.2.1) which should happen this week
sometime. Look for the announcement.
-Dan
- Original M
Tom Lane wrote:
>"Johann Woeckinger" <[EMAIL PROTECTED]> writes:
>> But when using a Tcl-based interface (e.g. pgaccess or home made tcl
>> based programs) to insert such characters into a table, they are not corre
>ct
>> displayed on queries by use of psql - they appear as two 'un
> > Soma> All values called from the database are still padded with
> > Soma> extra spaces from the column size in the database. Is this
> > Soma> normal - I don't remember this happening when I was using
> > Soma> MySQL. I thought usually the database stripped the extra
> > S
> Anobody could tell-me how can I make a Trigger thats execute some things
> whith "postgres" superuser privileges (like INSERT INTO a table that the
> user logged in don't have access)
I think triggers should run with table-owner user permissions. That way you
could have a table owned by superus
I need to insert a bunch of records in a transaction. The transaction must
not abort if the a duplicate is found.
I know I have seen the syntax for the before. Can someone jog my memory?
Bryan White, ArcaMax.com, VP of Technology
The avalanche has already begun.
It is too late for the pebbles
Hi, all
Anobody could tell-me how can I make a Trigger thats execute some things
whith "postgres" superuser privileges (like INSERT INTO a table that the
user logged in don't have access)
regards,
Tulio Oliveira
--
==
AKACIA TECNOLOGIA
Des
Hi all,
I'm pretty new in PostgreSQL and I have some problems and
questions. I'll list them here, maybe someone can help me :)
1) I wanted to use a binary type. I've seen in some place a
type called bytea which I can use, but I cannot use it
as a primary key. Is that possible somehow or with ano
On Tue, Dec 19, 2000 at 10:37:42AM -0500, Raymond Chui wrote:
> delete from tablename where datetime < TODAY-10;
delete from tablename where datetime < timestamp 'now' - interval '10 days';
or
delete from tablename where age(datetime) > '10 days';
--
Mike Castle Life is like a cl
Hi Raymond,
You might try something like this:
DELETE FROM tablename WHERE datetime < ('now'::timestamp - '10
days'::interval);
and
DELETE FROM tablename WHERE datetime BETWEEN ('now'::timestamp - '10
hours'::interval) AND 'now'::timestamp;
If you just want the date stamp, you can use 'now'::da
Help me for "DBI->connect failed: Sorry, too
many clients already."my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-typ
On Tue, 19 Dec 2000, Joseph wrote:
> $dbh=DBI->connect("dbi:Pg:dbname=$dbname",$dbusername,$dbpassword) or die "can
I would assume that if you never disconnect and are running under
mod_perl, you will have problems.
I have a table with columns
datetime timestamp,
valuefloat(8)
I want to delete rows 10 days older or 10 hours older by
delete from tablename where datetime < TODAY-10;
or
delete from tablename where datetime between CURRENT-10 and CURRENT;
So are there key words TODAY, CURRENT in Pos
my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-type: text/html\n\n";print
<<"TAG"; The count is
$count. TAGexit
0;#
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.
At 10:04 19/12/00 -0800, Adam Haberlach wrote:
>On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote:
>> Somebody knows how to get a sql "schema" of a Postgresql database??
>
>pg_dump -s -d
>
No.
-d does something to the INSERT strings
--
thorNET - Internet Consultancy, Services
At 12:51 19/12/00 -0500, gerardo tagliani wrote:
>Somebody knows how to get a sql "schema" of a Postgresql database??
>
>Thanks!!
pg_dump -s databasename
--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
http://www.thornet.co.uk
> You can run PostgreSQL on Windows NT using the Cygwin
> toolkit, but getting
> that to work can sometimes be a final project as well.
I disagree. Using the instructions on
http://people.freebsd.org/~kevlo/postgres/portNT.html it is almost a
no-brainer.
Joost Kraaijeveld
Askesis B.V.
Molukkenst
On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote:
> Somebody knows how to get a sql "schema" of a Postgresql database??
pg_dump -s -d
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and profound desire for
htt
Somebody knows how to get a sql "schema" of a Postgresql database??
Thanks!!
Gerardo Tagliani
Linux Registred User #139437
---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com
carolina writes:
> Can Postgres run in Windows 95 or Windows 98?
No. (You can compile the client library on Windows 95/98, but that's it.)
You can run PostgreSQL on Windows NT using the Cygwin toolkit, but getting
that to work can sometimes be a final project as well.
My advice would be to fi
Harry Wood wrote:
>
> Anyone know how to create auto incrementing fields?
>
> --
> Harry
> [EMAIL PROTECTED]
> http://www.doc.ic.ac.uk/~hw97/Nojer2
> Nojer2 on chat.yahoo.com and zapidonia.com
> ICQ number 18519769
CREATE TABLE test (
teste_id SERIAL PRIMARY KEY,
namevarch
On Tue, 19 Dec 2000, Harry Wood wrote:
> Anyone know how to create auto incrementing fields?
create sequence my_seq;
create table my_table (
my_id integer primary key default nextval('my_seq'),
another_field varchar(10),
...
);
OR, you can create an implicit sequence:
Use the column type of SERIAL in your create table statement. This will
automatically create a sequence and default for the given column.
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-createsequence.htm
for more on sequences.
- Original Message -
From: "Harry Wood" <[EMAIL P
ALTER USER postgres WITH PASSWORD '[enter password]'
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-alteruser.htm
- Original Message -
From: "Leon van Dongen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 18, 2000 1:56 AM
Subject: [GENERAL] newbie question
Anyone know how to create auto incrementing fields?
--
Harry
[EMAIL PROTECTED]
http://www.doc.ic.ac.uk/~hw97/Nojer2
Nojer2 on chat.yahoo.com and zapidonia.com
ICQ number 18519769
please
I have an application developed with my-sql , but iI want to migrate it to postgress.
What
can my do
Thanks
--
Lambert SONNA MOMO
29 matches
Mail list logo
