Got it about cc'ing.
Actually, I restarted postgres using:
/etc/init.d/postgresql restart
Any other suggestions?
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Mon 5/19/2008 8:34 PM
To: Dan Joo; pgsql-general@postgresql.org
Subject: Re: [GENERAL]
r
besides the pg_hba.conf file?
Thanks for your help,
Dan
From: Luigi Castro Cardeles [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 20, 2008 5:53 AM
To: Dan Joo
Subject: Re: [GENERAL] psql: FATAL: Ident authentication failed for user
"postgres"
hi,
what's your mac
Hi Karsten,
The only non-commented lines are:
[EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#'
local all all trust
hostall all 127.0.0.1/32 trust
hostall all ::1/128
: Re: [GENERAL] psql: FATAL: Ident authentication failed
foruser"postgres"
On Tue, May 20, 2008 at 08:50:16AM -0700, Dan Joo wrote:
> The only non-commented lines are:
>
> [EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#'
>
> local all all
authentication
failedforuser"postgres"
On Tue, May 20, 2008 at 09:47:55AM -0700, Dan Joo wrote:
> Is there a command that I can use to find out which file PG is looking
> into for the settings in pg_hba.conf? Could it be that the config
file
> is not even titled "
rol Panel applet for ODBC
management. The answer should read:
"Go to Programs -> Administrative Tools -> Data Sources and Add the
PostgreSQL Unicode driver".
Hope this helps,
Dan Dascalescu
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
Hi all,
I have a problem connecting to postgres via the python pg module ONLY
from the cgi-scripts.
The command is:
db=pg.connect('aqdev','localhost',5432,None,None,'postgres',None)
>From the commandline the connection works great, but from a cgi-script
it barfs with the following m
Just solved it.
For others, here is the solution.
setsebool -P httpd_can_network_connect_db 1
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dan Joo
Sent: Thursday, June 05, 2008 4:18 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres connection problem
x asasaxax wrote:
CREATE SEQUENCE "public"."teste_seq"
INCREMENT 1 MINVALUE 1
MAXVALUE 32767 START 1
CACHE 1 CYCLE;
What can i do to be able to continue inserting rows on this table?
Thanks a lot.
Make the max value of your sequence larger. A lot l
I've followed the implementation instructions at 24.4.2:
http://www.postgresql.org/docs/current/static/warm-standby.html
And I've used the archive/restore commands from the example in F23.2:
http://www.postgresql.org/docs/current/static/pgstandby.html
This all works great. The primary backs up t
Excellent! Thanks. One other quick question... What would happen if I
didn't delete the recovery.conf file? Is that step just to prevent
accidentally restarting the server with it there?
On Tue, Apr 14, 2009 at 6:26 PM, Erik Jones wrote:
>
> On Apr 14, 2009, at 3:47 PM, Dan
is looking for.
Is this DB toast? Or is there something I could do to get the DB back
into a state where it will start, without losing everything?
Thanks,
Dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
em fine, but
bits and pieces of documentation I've seen for pg_resetxlog also
recommend initdb, and starting over. Is that necessary?
Thanks,
Dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> These reports seem to come up a bit, with disk full issues resulting in
> the need to pg_resetxlog, dump, and re-initdb, but I wouldn't be too
> shocked if they all turned out to be on xfs or something like that.
>
My particular disk-full condition was on ext2. Nothing exotic. Also,
the proces
here anything I can do to prevent (or minimize) the performance
impact of the checkpoint?
Thanks,
Dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Jul 8, 2009 at 12:50 PM, Tom Lane wrote:
> Dan Armbrust writes:
>> However, once the checkpoint process begins, I get a whole flood of
>> queries that take between 1 and 10 seconds to complete. My throughput
>> crashes to near nothing. The checkpoint takes betwee
On Wed, Jul 8, 2009 at 1:23 PM, Tom Lane wrote:
> Dan Armbrust writes:
>> With checkpoint_segments set to 10, the checkpoints appear to be
>> happening due to checkpoint_timeout - which I've left at the default
>> of 5 minutes.
>
> Well, you could increase both
itional slow queries logged while
the checkpoint process runs.
My takeaway is that starting the checkpoint process is really
expensive - so I don't want to start it very frequently. And the only
downside to longer intervals between checkpoints is a longer recovery
time if the system crashes?
> However, the latest report says that he
> managed that, and yet there's still a one-or-two-second transient of
> some sort. I'm wondering what's causing that. If it were at the *end*
> of the checkpoint, it might be the disk again (failing to handle a bunch
> of fsyncs, perhaps). But if it rea
r system into a state where I
could build postgres (I was using the binary install) I built a 8.3.4,
using your patch - but I didn't see any change in the behaviour. I
see hiccups that appear to be the same length as I saw on the binary
build of 8.3.4.
Thanks,
Dan
--
Sent via pgsql-general maili
> Hm, I'm not sure I believe any of that except the last bit, seeing that
> he's got plenty of excess CPU capability. But the last bit fits with
> the wimpy-I/O problem, and it also offers something we could test.
> Dan, please see what happens when you vary the wal_buffer
> So this thought leads to a couple of other things Dan could test.
> First, see if turning off full_page_writes makes the hiccup go away.
> If so, we know the problem is in this area (though still not exactly
> which reason); if not we need another idea. That's not a good perma
;m happy to test things if you send me
patches or custom code.
Thanks,
Dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jul 13, 2009 at 3:53 PM, Dan
Armbrust wrote:
>> So this thought leads to a couple of other things Dan could test.
>> First, see if turning off full_page_writes makes the hiccup go away.
>> If so, we know the problem is in this area (though still not exactly
>> which
weird cases are below. If someone could explain what the
SQL parser is really looking for, and what the "best" or "most correct" way is,
I would be grateful.
Thanks,
Dan
Examples:
db=# create temporary table x (p point);
CREATE TABLE
Can't use
n does not do
any evaluation of what's inside, e.g.
SELECT '{1,2,1+2}'::INT[];
doesn't work, but
SELECT ARRAY[1,2,1+2]::INT[];
works fine.
Dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
information back from the query .
Would something like that be possible in postgres ?
Regards
Dan
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatyp
it has
worked before at least
http://archives.postgresql.org/pgsql-odbc/2004-09/msg00046.php
//Dan
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
similar error:
column "col" is of type point but expression is of type text
If the above task can be performed some other way, perhaps I don't require
string concatenation
--
Dan Libby
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I've got a query that takes a very long time to execute if I add anadditional column to the SELECT clause. Here is Query A, the slow one. I've numbered the rowsof the EXPLAIN for convenience.psql=# explain analyze SELECT timestamp, src_ip, dst_ip, id,
string_one, string_two FROM table_one LEFT J
What have you got work_mem set to?The default, 1024.
The fact that the estimates diverge so far from reality can no doubt beblamed on the horridly bad rowcount estimates: 3 rows estimated vs
179 actual for table_one, and 128592 estimated vs 4202 actual fortable_two. Have you ANALYZEd these tables
res DB.
Short of installing an older Postgres DB that PGAdmin II will work with
- does anyone else know of a tool that can do what I want?
Is there a script of some sort that I can run that would go through a
set of tables and lowercase everything?
Thanks,
Dan
--
suggest why it is possible to create a database but not
COPY to/from a file as a non-superuser?
thanks
Dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks for that.
On Mon, 2009-10-12 at 20:21 -0400, Stephen Frost wrote:
> * Dan Kortschak (dan.kortsc...@adelaide.edu.au) wrote:
> > $dbh->do("COPY chromosome_data FROM '".chromosomes(\%options)."' CSV");
>
> > Does anyone have any suggestions
Thanks again.
On Mon, 2009-10-12 at 21:14 -0400, Stephen Frost wrote:
> > Seems like the way to go, though it will be significantly slower
> than
> > psql or superuser reads (a couple of tables have ~10s-100sM rows).
>
> Erm, really? You've tested that and found it to be that much slower?
Sorry
Hi, this is a bit of a noob question.
I am using PGSql to perform some large analyses, with the clients being
a sequentially run set of perl scripts (one to set up and populate
tables and then down stream scripts to query the database for the
results).
During manual testing everything works, but
Yes, they are separate perl files (I'm thinking that perhaps this wasn't
the best way to do it now, but for the moment I'm going to have to stick
with it).
In the case of the manual testing it's jus a matter of command line
calls. The automated runs call each script as part of a PBS torque
script
Thanks for that, that should help me sort it out. I haven't used the
autocommit option in pgdbi. I'll have a look to see if DBI::do has an
option to wait for command completion.
cheers
On Mon, 2009-12-07 at 16:12 -0500, Tom Lane wrote:
> It's not. What you want is to COMMIT and make sure you've
Thanks to everyone who has answered this. The short answer is that
torque is not behaving the way I expected and not the way I have ever
seen it behave in the past. The I/O binding of these jobs may have
something to do with this, but I will look into it further.
cheers
On Mon, 2009-12-07 at 13:2
ently because it is not attached
to a terminal (this has caused problems for others on that list with
sqlite and mysql).
Can anyone confirm/refute this? And if it is the case, is there
something that I can do about it?
thanks again.
Dan
On Mon, 2009-12-07 at 18:33 -0500, Merlin Moncure wrote:
>
kes ~40-60 hours, and unfortunately the test
case takes about 20-30 minutes - I suspect that this problem would not
arise with more convenient tests).
cheers
Dan
On Wed, 2009-12-09 at 00:22 -0500, Tom Lane wrote:
> That seems unlikely. My best guess at this point is that for some
> reason t
hat I initially
thought you were refering to in your first post.) This would essentially
be a soft lock.
thanks again
Dan
On Wed, 2009-12-09 at 00:28 -0500, Merlin Moncure wrote:
> Advisory locks are basically only useful if the locker of the resource
> maintains a database session (that is
Hello folks,
PGCon 2010 will be held 20-21 May 2010, in Ottawa at the University of
Ottawa. It will be preceded by two days of tutorials on 18-19 May 2010.
We are now accepting proposals for talks.
If you are doing something interesting with PostgreSQL, please submit
a proposal. You might be
and 3 from insert_options).
The first 3 have null vals and the second 3 have the correct vals.
It should be:
options_id | options_name | quantity | price | discount
+--+--+---+--
1 | Test | | |
2 | Test 2 |1 | 2 |3
Any ideas why this is or if there is another approach?
Thanks,
Dan
I think I found the problem with this. The rule:
CREATE OR REPLACE RULE insert_options AS
ON INSERT TO options DO INSTEAD
(INSERT INTO a (a_id, type_id, name)
VALUES (new.options_id, 6, new.options_name);
UPDATE a_item SET val = new.quantity
WHERE a_item.a_id = new.options_id
On Mar 9, 2010, at 11:00 AM, Tom Lane wrote:
Dan Fitzpatrick writes:
The rule is creating a new value from the sequence a_a_id_seq for
"new.options_id" on each UPDATE call. How do I use the variable
new.options_id in the three update statements without incrementing
the
sequ
sion give an
error ?
It would be really nice with the possibility to use infinity with the date
type.
Regards
//Dan
ks now.
Is there a description or manual page on how to install a beta in paralell
with my 8.3.10 installation ?
regards
//Dan
2010/4/30 Tom Lane
> Dan S writes:
> > I did a test but it looks like date doesn't support infinity as a value.
>
> Try 8.4 or later.
>
>regards, tom lane
>
Ds
and counts, etc, have changed, and that'd just cause other issues.
If someone can provide any assistance or info, that'd be tops!
Thanks!
Dan Herbert
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> Ouch. Are you running Slony by any chance?
Nope, just a stock install. Both servers are running CentOS.
> Do you have *any* idea what caused this?
Nothing definitive unfortunately. Looking back through SVN logs for
code updates there was mention of disabling triggers to perform a
large delete
| > 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
| | (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--
;
|
| 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
...
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
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
= 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
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
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
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
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
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
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
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
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
' 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
/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
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
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
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
| > 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
| > Signal 26 on FreeBSD is SIGVTARLM.
|
| We don't ever set a virtual timer alarm, either. Is it possible that
| you are running the postmaster with a ulimit-style limit on total
| process runtime?
No, I've tested this and postmaster is being started in an unlimited
enviornment.
The code
' DECLARE
v_number_of_rows int;
BEGIN update bigtable set email_confirmed = 1
where user_group = 1234;
-- and here, I want to know the number of rows updated
v_number_of_rows := *what?*;
END; ' LANGUAGE 'plpgsql&
Then
copied from the renamed tables to the new tables. Then I tried the
dump, which failed. Then I removed the renamed tables. Then the dump
worked.
Hope that helps.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/
FreshPorts - http://freshports.org/
NZ Broadband - htt
On 15 Jan 2001, at 8:44, J.H.M. Dassen (Ray) wrote:
> On Sun, Jan 14, 2001 at 23:27:06 +1300, Dan Langille wrote:
> > I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have a
> > question: At various times, it does UPDATEs. Is there a way to tell if
>
eries. phpPgAdmin can be downloaded from:
http://www.greatbridge.org/project/phppgadmin
-Dan
> I'm working on a project which needs to introspect the structure of a
> database. I need to fish out table names, attribute names and
> type, and foreign keys.
>
> I had a pok
Steve Leibel writes:
> I'm converting a mysql database to postgres. Is there an equivalent
> for the enum data type?
No, but you can put the enum data in a separate table and join
them. This also makes the operation of adding entries to the enum list
better defined.
Dan
Gilles DAROLD writes:
> With Apache/mod_perl it is very simple to enable DB connection
> persistance.
>
> in your perl script :
>
> use vars qw($dbh);
>
> $dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd);
Even better, Apache::DBI will pool across Perl programs, and you don't
have to change any
+-(0 rows)
Now what is going on?!?!? That just plain old doesn't make
sense!
Thanks for any help!
-Dan
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, anything you can do in Perl, you can also do in
PHP.
-Dan
Here's a simple PHP script that I use. You can backup only certain
databases or the whole server. I'm actually planning on making this part of
the phpPgAdmin package. You can specify how many days you want the backup
files to remain.
-Dan
#!/usr/
e is a way
the gurus can accomplish that.
-Dan
- Original Message -
From: "Mike Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February
us it requires an additional call to the
database.
-Dan
Is there any way to trap the NOTICE output (specifically in PHP)? I would
like to impliment an EXPLAIN feature in phpPgAdmin and have been
unsuccessful in finding a way to do this because all the information
returned by EXPLAIN is in a NOTICE.
Any ideas?
-Dan
Actually, you should take a look in the documentation. It specifically
states that the maximum size for any tuple is 8k (unless compiled
otherwise). If you want to store something larger, consider using the large
objects feature.
Dan
Bodoni Endre wrote:
> I have a little trouble with
any form on foreign key or table lookup/join is a bad idea!
They should mainly be used when trying to distinguish between similar
values in a table (ie: in case some fields are the same, the oid will
always be unique).
Hope this helps
Dan
Raymond Chui wrote:
> If I create a table like
&g
: SELECT a.x/b.y FROM vals a, (SELECT y FROM vals WHERE y > 0) b WHERE (a.x
: / b.y) > 1;
How much of a performance hit is there when using a select in the FROM
clause? Is it even noticeable? How much better is it to create a static
view?
-Dan
A friend asked me to figure out how to access PostgreSQL from Tcl via
ODBC. For posterity, here's the step by step "how I did it" that I
emailed to him. I don't know Tcl, this was just about getting the
compile options correct and doing the proper sysadminning to make
things work.
Comments, sugge
memory) you'll need pretty
recent CVS sources.
One of the bugs I had to track down even though my original CVS update
was only a few weeks old.
Dan
fix.prefix order by random() limit 1) || ...
would be more likely to work (modulo some casting and such).
Dan
ppgadmin)
has this built into it. It will automatically get the list of tables,
sequences and views and run a grant statment on them.
Second pointer. GRANT will take multiple "relations" seperated by commas:
GRANT ALL ON table1, table1, seq1, seq2, view1, view2 TO my_user;
-Dan
date_part('year', date
'today') - 2 UNION SELECT first_name, last_name, middle_name, u.uid,
end_year FROM user_info u, current c WHERE u.uid = c.uid ORDER BY
UPPER(user_info.last_name);
ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the
result columns
Is this a bug in b
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
: "Dan Wilson" <[EMAIL PROTECTED]> writes:
: > I have the following query running on two different servers. It works
on
: > 7.0.3 and gives the following error on 7.1beta4.
:
: > ERROR: A
Excellent! That worked! Thank you once again Tom! I was under the
impression that you couldn't use an alias in the ORDER BY. Obviously, I was
mistaken.
Thanks,
-Dan
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
: "Dan Wilson" <[EMAIL
Wel guys, thanks for the advice. I guess my own custom CGI would work, or
something similar. Your help has been greatly apreciated. I was merely trying to
find out if its possible to do it any other way, and you guys have already given
me some stuff to think about. Cheers!
Dan
Lincoln Yeoh
Renaud Tthonnart writes:
> Could someone give me some explaination about the metatable(s) of
> PostgreSQL?
> Where is it and is there to find in it?
A good way is to start psql with "-E", it'll then show you the queries
it makes from the metatables when you do thin
x27; where attrelid = (select oid from pg_class where relname =
'[table_name]');
-
Will doing this cause any problems?
-Dan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
sed anything in the instructions.
Downloads from: http://pgvote.unixathome.org/downloads/
Feedback can be left at: http://pgvote.unixathome.org/phorum/
Thanks
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 8: explain analyze is your friend
appears to be consistent with the SQL99 spec.
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
stgreSQL? Would you recommend it over MySQL?
Yes. Yes. Friends don't let friends use MySQL.
> 5. How often do your PostgreSQL run into problem or crash? Are most of
> the problem caused by PostgreSQL itself?
I have never seen a PostgreSQL crash. Most if not all
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
[
201 - 300 of 336 matches
Mail list logo