| > Can someone tell me what a postmaster process exiting with status = 26
| > means? FWIW, I'm doing a COPY table FROM stdin with about 14 million
| > records to trigger this.
|
| That means it got a signal 26. Since you didn't mention what platform
| you are on, I'm not going to guess what s
Can someone tell me what a postmaster process exiting with status = 26
means? FWIW, I'm doing a COPY table FROM stdin with about 14 million
records to trigger this.
Thanks,
-Dan
--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance wit
Rajit Singh writes:
> The thing is, I also want to be able to update the timestamp field
> if I want to...
Here's my solution:
CREATE FUNCTION updated_stamp () RETURNS OPAQUE AS
'BEGIN
IF NEW.updated ISNULL THEN
NEW.updated := ''now'';
END IF;
RETURN N
SELECT relacl FROM pg_class WHERE relname = '[table name]'
The relacl column contains specific information that must then be parsed to
determine the users which have access to a the table and the privileges
granted.
Example:
{"=","dan=arw","group developers
/download/download.php
Tar: ftp://ftp.greatbridge.org/pub/phppgadmin/stable/phpPgAdmin_2-2-1.tar.gz
Zip: ftp://ftp.greatbridge.org/pub/phppgadmin/stable/phpPgAdmin_2-2-1.zip
ChangeLog: http://pgdemo.acucore.com/ChangeLog
-Dan Wilson
phpPgAdmin Development Team
[EMAIL PROTECTED]
PS. If you would like to
' not found
test_db=#
I know I could just do a: insert into "mixed_Case" (mix_var) values ('not
working')
But this is for phpPgAdmin and so due to certain issues, I need to have the
nextval function work as it would without a mixed case table name.
Is this expected behavior?
-Dan
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
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
That was it! Thanks Tom. I just put this functionality into phpPgAdmin and
of course it is taking the newline char from the browser's OS.
Thanks for all your help!
-Dan
> "Dan Wilson" <[EMAIL PROTECTED]> writes:
> > I get the following error:
> > NOTIC
If you look at my function definition, you can see that this is not within
the function body. This is the testing of the trigger which produces the
error. It's just a plain old SQL statment that initiates the trigger.
-Dan
- Original Message -
From: "Robert B. Easte
http://www.postgresql.org/users-lounge/docs/7.0/user/c40874340.htm
And I get the exact same error (except of course the function name is
different). So I'm assuming that it's a problem in my system
configuration... I may be wrong.
I don't know how to fix this or even where to begin. I do have plpgsql
installed as a language. I'm running PG 7.0.2 on standard RedHat 7 ... not
sure of the Kernel.
Thanks for your help,
-Dan
27;m now convinced that PostgreSQL is the way for me to go, this
was a long uphill battle driven by my respect for people who had
different backgrounds than I, and my xenophilia for different ways of
thinking.
That momentum in the coder populace at large is going to take a while
to overcome.
Dan
Tom,
Thanks for the update on this query. I'm not positive where I found this
query, but I'm pretty sure it was for a v6.5x something. Anyway, thanks.
phpPgAdmin has been updated.
-Dan
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Dan
= a.attnum
or
i.indkey[5] = a.attnum
or
i.indkey[6] = a.attnum
or
i.indkey[7] = a.attnum
)
ORDER BY
index_name, tab_name, column_name;
This was adapted from the psql source. Hope it's what you need.
-Dan Wilson
- Original Message -
From: "Jason Davie
Is there a reason why _any_ user can create a table on a database? Even if
they do not own or have any permissions to it?
I don't think that should happen. Is there a specific reason why it does?
-Dan Wilson
...
Actually, the above is rather untrue. vacuum some_table without the
analyze gets farther along than with analyze, however it eventually spits
back the original error of
ERROR: No one parent tuple was found
Sorry for running around in circles. :-)
Cheers!
-Dan
--
Man is a rational animal
;
|
| The very next vacuum I do produces the exact same response. The next one
| after that though continues..
And as another side note :) ...
vacuum some_table (without the analyze) completes quite happily.
Cheers,
-Dan
--
Man is a rational animal who always loses his temper when he is
| | (Marc hasn't officially announced 7.0.3 yet, but to the best of my
| | knowledge the release-candidate tarballs currently available from our
| | FTP server will be it.)
|
| I've upgraded to 7.0.3, now I get...
|
| c2net=> vacuum verbose analyze some_table;
| NOTICE: --Relation some_table--
| > A vacuum without the analyze gives the error
| > ERROR: No one parent tuple was found
|
| I think you might be getting bit by the same bug that was biting Alfred
| Perlstein a month or so back. Try 7.0.3 and see if it's any better...
| if not, let me know and we'll probe deeper.
|
| (Marc
Hi guys,
I am trying to put together a web database for a series of pages that
will be in the format of a journal or magazine. I was wondering if you
knew of any urls that discuss the pros and cons of different structures
of implementation. I have an idea, I just want to see if someone has a
bett
he
site or contact me directly.
-Dan Wilson
[EMAIL PROTECTED]
http://www.phpwizard.net/phpPgAdmin
grant statement that I'd like to get rid of. How can I
reassign ownership of the entire database, or just give default
permissions on all new tables to 'tdc'?
Thanks,
Dan Chak
--
--------
dan chak ! 372 memorial driv
Does anyone know where I might find documentation on creating R-tree indexes
in PostgreSQL? The docs included in the standard distribution don't seem to
even mention the existence of R-trees.
Thanks.
--
Dan
On Tue, 12 Oct 1999, Duncan Kinder wrote:
>
> I have been told on the Novice list that in order to start Postgres for an
> Internet connection, it needs to have the -i flag set.
>
> However, following the documentation, for RedHat automatic startups, I have
> inserted the following language in
Semicolon (;) at the end of each line should fix it.
-Dan
> Hi,
>
> I insert 10,000 data into PostgreSQL database. I got the problem
> while inserting:
>
> query buffer max length of 2 exceeded
> query line ignored
> .
> query buffer max length of 2 ex
from pg_type WHERE NOT LIKE '_%'
It gives me an empty set.
Is there any way to escape the underscore. I tried to use '\_%', but that
didn't help. Any suggestions?
-Dan
primary key. Is there a better property or flag to examine for this
purpose?
-Dan
> On Sun, Jul 25, 1999 at 03:13:39PM +1000, Chris Bitmead wrote:
> > Dan Wilson wrote:
> >
> > > Yes, I am aware that the primary key does not really mean anything
except
> > > impli
except
implicitly making it a unique key, but it's supposed to be there for
compatibility and it's not even in the dump.
It's not a huge deal, but I was wondering if there was reasoning behind it
of which I am unaware.
-Dan
\d . Then be
sure to copy the adbin and adsrc from an identical default.
Hopefully that helped.
I have never tried this and so if any of you know that this won't work or if
you know that I have made some mistakes in my judgement, then please let me
know. I am a fairly new beginner at po
You'll have to forgive me if this is a trivial question but I'm *very*
new to this. I'm developing an online time clock program and was
wondering if there was a character based front end, similar to Oracle's
SQL*Forms, that could be used for a postgres 6.4.2 database.
Thank
like
"[EMAIL PROTECTED]", but what would I need to do to get
it into the database? Something in sendmail? Use procmail?
Any ideas?
--Dan
---
Daniel G. DelaneyThe Louisville Times Chorus
[
nuals, (possible better organized than man pages
allow).
Most of the sections in the manuals are simply too brief. Consider
the section in the Tutorial on Redirecting SELECT Queries. It
explains the idea as quickly as possible, gives ONE example, and is
done. This doesn't help new users much.
I thi
Is anyone running PostgreSQL on Rhapsody (aka Mac OS X Server) yet?
And, if so, did you have any problems getting it up and running?
Thanks.
--Dan
---
Daniel G. DelaneyThe Louisville Times Chorus
[EMAIL
like to be able to do it without using the large object
interface. Anyone have any ideas?
--Dan
---
Daniel G. DelaneyThe Louisville Times Chorus
[EMAIL PROTECTED] www.LouisvilleTimes.
Hello all,
Can a bitmap graphic file (say a GIF, JPEG, or EPS) be stored
into a PostgreSQL table? If so, how? What field type should I set up
in the table and how do I insert the graphic file?
Thanks.
--Dan
---
Daniel G
301 - 336 of 336 matches
Mail list logo
