On Thu, May 05, 2011 at 08:23:16AM +0930, Sam Stearns wrote:
> Dump/restore of table resolved this problem.
Yeah, the 'repair' advice was probably bleed over from some other open
source database that suffers from table corruption more regularly.
Any sort of on disk corruption in a postgresql DB l
On Tue, May 03, 2011 at 08:48:19AM +0200, Guillaume Lelarge wrote:
> On 05/03/2011 05:52 AM, Tom Hartnett wrote:
> > can it be done?
> >
> > create index my_idx on my_table(col1) where col1='';
> >
> > ERROR: invalid input syntax for integer: ""
> >
> > Seems simple enough but I don't know what
On Fri, Apr 30, 2010 at 03:33:13PM +0200, Péter Kovács wrote:
> Hi,
>
> I have a number of PostgreSQL servers which I often access through ssh
> tunnel with Pgadmin3. I would like to double check which one I have landed
> on (if the tunnel is really configured the way I want). Is there a way to
>
On Thu, Apr 22, 2010 at 11:47:34AM +0930, Samuel Stearns wrote:
> Howdy,
>
> I'm running in an 8.3.3 environment. What could cause, or how can I
> diagnose, why an 'ALTER TABLE ADD COLUMN' statement runs for hours
> eventually locking users out and requiring to be killed in the end?
>
ALTER
On Mon, Mar 10, 2003 at 03:15:18PM +0530, Rajesh Kumar Mallah wrote:
>
> use contrib/dbsize
>
> 1. select relation_size('schemaname.tablename');
> 2. select database_size('databasename');
>
>
> function 1 does not works with tablename in miXed CaSe.
Sure it does, you just need to put the quot
On Mon, Feb 24, 2003 at 11:06:38PM -0500, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> > I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your
> > right, it gives us 1752-09-03.
>
> As was pointed out at length just recently, the transition from Julian
> to Gregori
On Sun, Jan 26, 2003 at 06:31:50PM +0530, shreedhar wrote:
> Hi All,
>
> Before indexing query plan was showing cost as 40.00, after indexing query
> plan again showing as 'seq scan' and cost as 3060.55.
> The field which i indexed is primary key to this table.
> May i know
> 1) what is the cause
On Fri, 17 Jan 2003, Bruno Wolff III wrote:
> On Fri, Jan 17, 2003 at 08:57:14 -0500,
> Andrew Perrin <[EMAIL PROTECTED]> wrote:
> >
> > that way you avoid duplicates across tables.
>
> The union operator already removes duplicates.
Right, which means everyone's UNION queries have too many DIS
On Wed, Jan 15, 2003 at 04:08:40PM +0700, Yudha Setiawan wrote:
> Somebody gimme your hand plz.
>
> Using my previous Database I used to be like that;
> " ALTER TRIGGER tr_T_DtlPO ON dbo.T_DtlPO FOR UPDATE AS
> bla..bla..bla...
> IF @OldQty <> @NewQty BEGIN
> ROLLBACK
> INSERT INTO T
On Thu, Dec 05, 2002 at 02:18:15PM -0500, Bruce Momjian wrote:
>
> I don't think you can drop/recreate the sequence because the dependency
> code knows other tables depend on it.
Actually, I don't think the current dependency code notices if you use a
sequence in a default clause (other than via
On Sat, Oct 05, 2002 at 08:17:38PM -0700, Nikolaus Dilger wrote:
> Raymond,
>
> Partitioned tables would solve your issue since you
> could just truncate a partiotion in order to delete the
> unneeded data. Unfortunately they are not available in
> PostgreSQL. But maybe in a future release.
>
On Thu, Jun 06, 2002 at 05:43:28PM -0300, Robson Martins wrote:
> What err ???
>
> SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli As Coluna
>FROM Clientes WHERE RazaoSocial Like '%A%'
This looks like some other dialect of SQL, not SQL92 (nor PostGreSQL).
I _think_ yo
On Mon, Apr 22, 2002 at 04:32:37PM -0400, Tom Lane wrote:
> It'll be interesting to see how the plans change depending on whether
> you are searching for a judge or not ...
A whole new meaning to judge shopping, err, searching?
Ross
---(end of broadcast)-
Just to complete the thread.
Ross
- Forwarded message from "Zhang, Anna" <[EMAIL PROTECTED]> -
From: "Zhang, Anna" <[EMAIL PROTECTED]>
To: "'Ross J. Reedstrom'" <[EMAIL PROTECTED]>
Subject: RE: [ADMIN] tuning SQL
Date: Tue,
On Tue, Jan 29, 2002 at 12:23:17PM -0500, Zhang, Anna wrote:
> Thanks Peter Darley, Ross J. Reedstrom and Tom lane!!
> How silly am I! Your messages reminds me. Actually I want to insert rows of
> contact_discard table which are not exists in contact table to contact table
> (some d
On Tue, Jan 29, 2002 at 10:57:01AM -0500, Zhang, Anna wrote:
> Hi,
> I am running a query on postgres 7.1.3 at Red Hat 7.2 (2 CPUs, 1.5G RAM, 2
> drive disk array).
> select count(*) from contact a, contact_discard b where a.contacthandle <>
> b.contacthandle;
What are you trying to do with th
I haven't _used_ this software, and it's not ready as a 'drop in' app,
but have you looked at the GNU Enterprise work? I've been tracking that
project via the kt.zork.net 'Kernel Cousins' weekly summary. It sounds
like it's targeted at what you want, eventually. Their site is at:
http://www.gnuen
man split
Ross
On Fri, Dec 07, 2001 at 05:07:43PM +0100, David M. Richter wrote:
> Hello!
>
> Ive got a problem!
> My database has the size of almost 5 Gigabytes.
> So the dump will take at least 2 Gigs of harddisk.
> But my Kernel supports only 2 Gig Files!
>
> Any experiences with big dumpfi
On Thu, Dec 06, 2001 at 01:32:56PM -0500, Yanek Korff wrote:
> > Here's your problem: user1 has the same userid as pgsql. this
> > used to happen in 7.0, I think. Is that what you're running?
> I'm sure it's what I used to be running. I am running this now:
> postgresql-7.1.2_2
> according to Fr
On Thu, Nov 29, 2001 at 03:25:48PM -0500, Jodi Kanter wrote:
> I need to create a diagram of our schema. I recently obtained a copy of Visio.
> Has anyone used Visio to reverse engineer a model diagram from a Postgres database??
> If not, can anyone recommend the best way to create a schema from
On Thu, Oct 18, 2001 at 01:55:33PM -0400, Tom Lane wrote:
> Andrew Hill <[EMAIL PROTECTED]> writes:
> > Normally, 32 connections is heaps for what I need. However, I often get
> > connections that seem to be doing nothing. For example:
>
> > [bash]
> > \_ postmaster -i -D/var/pgsql/data -N 32
On Wed, Aug 08, 2001 at 09:40:21AM +0300, Grigoriy G. Vovk wrote:
> Aug 8, 07:17 +0200, [EMAIL PROTECTED] wrote:
>
> > Does anyone know of any package which allows a database to be distributed
> > over a number of machines (for e.g. depending on row values, rows from 0 -
> > 100 on machine A, row
Robert -
You mention having a PostgreSQL database in production for around a year.
May I ask what version it is? I'm guessing you're still at 6.5.X,
in which case, I'd suggest an upgrade to 7.1.2, before doing anything
more drastic. Not only are there bug fixes, many improving stability
of the s
On Mon, Jun 25, 2001 at 12:21:14AM +0300, Kostis Mentzelos wrote:
> In order to rename the table safely, I want to REVOKE INSERT on that
> table.
>
> But there is a problem because if there are users connected to
> database then REVOKE command wait until they disconnect.
> How can I found out who
If you look farther down that same dump, you'll see a CREATE RULE
that looks something like:
CREATE RULE AS ON SELECT
CREATE RULE "_RETincluded_works" AS ON SELECT TO "included_works" DO
INSTEAD SELECT "works"."uuid", "works"."title" as "lhs" [...]
In other words, pg_dump, especially before 7
Ranier -
Can you explain in words what this query is supposed to be doing?
I'm guessing, from the DISTINCT, and the use of multiple occurances of
the same table, that the result you want can be gotten at in some other
way, that lets the backend be smarter about how it does it. Since it _is_
rele
Hi Raju -
You're basically looking for marketing materials, which has never been
a strength of open source projects: it's a business need, really. The
problem seems to be that an old list is _worse_ than no list, and noone
has the time/incentive to keep a list up to date.
If you do write somethi
On Mon, Mar 26, 2001 at 12:00:03PM +0530, Mahesh Guleria wrote:
> Use these commands :
>
> ps -ef|grep post
> kill -9 [process id]
No, no, a thousand times, no! Haven't you seen this appended to
messages on the lists?
-
TIP 4: Don't 'kill -9' the postmaster
-
If you kill -9 the postma
Ulf -
Did you copy the pg_log file? Despite it's name, it's not a just a log:
it's used to keep track of the commit state of transactions. Without
it, the system will assume than none of your transactions are commited,
so will not show you the tuples in those transactions.
Ross
On Fri, Jan 12,
On Wed, Jan 10, 2001 at 01:34:34PM -0600, David Mehringer wrote:
> On Wed, 10 Jan 2001, Peter Eisentraut wrote:
> >
> > > We're running postgresql 7.0.2 on solaris 5.7. The admin docs say that only
> > > one postmaster process should be running.
> >
> > The docs are wrong in that case. Can you
On Tue, Dec 12, 2000 at 10:25:43PM +0300, Michael B. Babakov wrote:
>
> On 12-Dec-00 Ross J. Reedstrom wrote:
> > It's encoded in the process environment, so the 'ps' command will
> > give you what you want:
>
> Yes! For version < 7.0.2 it's righ
It's encoded in the process environment, so the 'ps' command will
give you what you want:
On my Debian linux box, I do something like:
reedstrm@cooker:~$ ps ax | grep '[/]postgres '
18737 ?S 0:02 /usr/lib/postgresql/bin/postmaster -b
/usr/lib/postgresql/bin/postgres -B 128 -D /var/
ew on pg_shadow. Can't update a view. The right
way to go about adding createuser privilage to a user is:
ALTER USER foouser CREATEUSER;
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
will do it),
they'll end up getting copied into every new db after that.
So, connect to template1, and delete everything you don't want from there.
Ross (learned from experience, I did)
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer an
es
yourself, by dragging and dropping fieldnames. The schema implementation
predates foreign key support in the backend, so it doesn't use that.
Then, the 'print' button will give you a big 'ol postscript file that
you'll have to massage to print however you can.
Ross
-
Faq
aka:
http://postgresql.org/docs/programmer/cvs.htm
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
7;
BTW, this was _not_ a fresh, clean install: you didn't rm -rf /jo/database
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
On Tue, Jul 11,
rball are at the bottom of that page.
While hunting this up, I tripped over:
http://home.snafu.de/wehe/apps_db.html
which lists another xbase tool:
http://w3.man.torun.pl/~makler/prog/pg2xbase/
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
for the data/base/dbname directory. Under linux, the md (multidisk)
drivers provide a software RAID solution (BSD has it's own solution,
I understand).
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
install, and everything should
work fine.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
;"
> ERROR: parser: parse error at or near ""
> FATAL 1: Database system does not exist. PGDATA directory
> '/var/lib/pgsql' not found.
> Normally, you create a database system by running initdb.
> FATAL 1: ReleaseLruFile: No opened files - no one can
's the daemon that serves incoming connections. As
postgres, it starts up a 'backend' proceess that access the db files. So,
yes, by running postgres.exe you _were_ trying to access the database
romkur.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
bout distributing precompiled NT binaries. Anyone
know about that?
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
s. A comment is introduced by the
token --, and ends at the next newline. I have many sql script files
that look like:
create table testit ( -- this is a test table
f1 int, -- this is a test integer
f2 real, -- this is a real, or float
f3 text -- this is a variable length text element
);
Ross
--
Ro
evice": That's
either the "can't get shared mem" error, or does Solaris allocate swap
space or something for all shared memory segments? Could it be you need
to add more swap?
Hope it helps,
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
, Email)
> values ('$V{firstname}','$V{lastname}','$V'MAILTO}')";
I think he means (deleted wrong character by MAILTO):
values ('$V{firstname}','$V{lastname}','$V{MAILTO}')";
but as I said, I don't know perl ;-)
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
ng (or validation against reserved words:
you can make very odd tablenames that way). All string values need to be
quoted with single quotes (')
idas=> select test;
ERROR: attribute 'test' not found
idas=> select 'test';
?column?
test
(1 row)
idas=>
an
int, and creating a unique index on it.
> I thought of creating my own column "identifier of tuple" in each
> table, forcing the values to be unique.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
sion caused by keeping all the old versions of
every table that lead to it's removal. You can simulate the old behavior
with 'magic' views of tables with a couple extra fileds to maintain
valid date/time info.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
N
e? In that case try:
template1=> select getpgusername();
getpgusername
-
reedstrm
HTH,
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
50 matches
Mail list logo
