OK, one of my tables was getting duplicate entries, and I thought I'd
create a unique index on a particular field. So, I created the index:
domains=# create unique index idx_domain_name on domain (domain_name);
CREATE
Then, tried a vaccum:
domains=# vacuum analyze;
NOTICE: Index idx_domai
On Wed, Jan 31, 2001 at 12:15:49PM -0500, Doug McNaught wrote:
> [EMAIL PROTECTED] writes:
>
> > I was reading
> > http://www.linuxworld.com.au/article.php3?aid=123&tid=8
> > and specifically
> > "Later in 2001 this flexibility may extend even within the MySQL
> > database server, with PHP scri
On Wed, 31 Jan 2001, Dan Wilson wrote:
> I wouldn't call PHP a subset of Perl at all! I'd call them sibling
> languages with different strengths. I think Perl does certain things better
> than PHP but PHP has strengths that Perl probably can't compete with. But
> for the most part, AFAIK, anyt
Thanks,
It is still strange though that I get different behavior
from the exact same source when built on two different
computers. I installed 7.0.2 on my laptop and I get an
interactive prompt ">". On my linux box I installed 7.0.2
and I get a "#" as the last character in the psql prompt.
The
On Wed, Jan 31, 2001 at 02:58:23PM -0500, some SMTP stream spewed forth:
> postgres support for pl/VB? :)
Well, the most important, of course, would be pl/COBOL!!!
gh
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> http://www.rutgersinsurance.com
> - Original
: As for whether it will be done, well, what does PHP give you over
: Perl? I know Perl well and PHP AFAICS is a tiny subset of Perl
: designed to be embedded in web pages. Given PL/Perl, do we really
: need PL/PHP?
I wouldn't call PHP a subset of Perl at all! I'd call them sibling
languages w
Hi,
Here's a perl script that I use to grant read access to all users and
everything to a few people, it handles tables and associated sequences.
Cheers,
Geoff Russell
P.S. If you use perl/dbi, you don't really have to worry about this stuff
because your programs connect with setuid like privi
I'm trying to back up a database, including the user records. If
I use pg_dump, I can get the table, but I cannot seem to be the user
information.
If I use pg_dumpall, it seems to have trouble connecting to various
databases (in fact, it attempts to connect even if I merely want
Steve Wolfe wrote:
>
> OK, one of my tables was getting duplicate entries, and I thought I'd
> create a unique index on a particular field. So, I created the index:
>
> domains=# create unique index idx_domain_name on domain (domain_name);
> CREATE
>
> Then, tried a vaccum:
>
> domains=# vac
Adam Haberlach wrote:
>I'm trying to back up a database, including the user records. If
>I use pg_dump, I can get the table, but I cannot seem to be the user
>information.
pg_dump -d database >dump
should copy the database schema and all data records into dump.
>If I
10 matches
Mail list logo