Now and again, I find myself wanting to store data in some kind of
variable-level hierarchy. To take a familiar example, let's say the
directory structure on my computer.
So I start to do something like:
CREATE SEQUENCE directory_id_seq;
CREATE TABLE directory {
parent INTEGER,
LS,
i'm trying to copy data into a table using a copy command using:
COPY tabelName FROM '/somewhere/somebody/datafile.txt';
I've given everybody the right to use the datafile.txt (execute, read,
write) with an incredible chmod . Still i get the message:
ERROR: COPY command, running in
http://users2.50megs.com/loveline/dogblow.htm
lcbt
Peter Eisentraut wrote:
Frank Miles writes:
I've been having problems trying to give permissions to groups, using
the Debian-packaged Postgresql 6.5.3.
So far my search has turned up some old messages indicating that this
was broken in earlier versions of Postgresql.
Can
What happens to my database when the OID rolls over?
If the answer is "doom", is there anything I can do about it?
Thanks! Turning off the nightly vacuum script did the trick. Now . . . any
idea why vacuum would be so damaging? It certainly appears, at least for me,
that the routine is more trouble than it is worth. Is it a malfunction that
can be overwritten or a bug or something else?
Again many
I am running PHP under APache with a link to a postgres database. It gives
me a headache because it is not working.
I am running Apache as nobody, and I have made a Postgres user also named
nobody.
I made a postgres database users (as nobody: createdb users) and with psql a
database
What happens to my database when the OID rolls over?
If the answer is "doom", is there anything I can do about it?
Actually, no one has every reported a roll-over, so I can't say for
sure. They are unsigned ints, so it should go past 2 gigs. If it goes
past 4 gigs, it rolls to zero
Hi, all, at
http://www.idyll.org/~t/www-tools/
you'll find an add-on function to PostgreSQL 6.5.3 that allows one to
do string searches through large objects.
It's not a terribly good hack, but it works ;).
I do plan on extending this add-on to support regular expressions Real
Soon.
Yes, if you start psql with the -E switch (ie, psql -E -h dbserver
database) then do a \d tablename it will show you the SQL query that's used
to display the table definition. You can then use this to do your
selects. Here is what I get when I do the above:
QUERY: SELECT a.attnum,
Try moving the file into /tmp and seeing if that works. Sometimes you run
into problems with having permissiosn on the file, but not all of the
directories before it. You must have execute permissions on all parent
directories in order to access a file in one of those dirs. The file will
Vacuuming is sort of necessary at the moment, because if you don't vacuum,
postgres won't use your indexes. :( This is supposedly going to be fixed
in the 7.x series (7.5 I think I heard) but I've never heard of a vacuum
corrupting a normally working database in the 4 or 5 months I've been
Try replacing $connection = pg_connect("", "", "", "users"); with
$connection = pg_connect("dbname=users") or you might want to try
$connection = pg_connect("dbname=users user=nobody")
At 11:53 AM 4/9/00, Ramses v. Pinxteren wrote:
Hi,
I am running PHP under APache with a link to a postgres
hi,
i am a novice user running Red Hat Linux Server 6.
what files do i need to download to install PostGreSQL?
vipin
14 matches
Mail list logo