On 1/22/07, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> kelly=# update pg_attribute set atttypid=25, atttypmod=-1
> kelly-# where attname = 'c1' and attrelid =
> kelly-# (select oid from pg_class where relname = 'foo');
> UPDATE 1
Also, you could replace that pg_class sub-select with "'fo
On 1/30/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Shoaib Mir wrote:
> While debugging an application, I just wanted to confirm from the list
here:
>
> Suppose I have a long running transaction which has a few updates and
> inserts running on some specific tables which means it has acquired
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/04/07 09:48, Jamie wrote:
> I typically use compound primary keys when creating a table that
> represents a many-to-many relationship. I was wondering if anyone else
> had other situations in which you would use a compound PK? Why do you
> use it
John D. Burger wrote:
> Sorry if I'm the only one to find this amusing, but I see that the
> original message was sent twenty minutes =after= I received it. :)
Probably sent from a different time zone.
Jim C.
---(end of broadcast)---
TIP 6: expla
I typically use compound primary keys when creating a table that
represents a many-to-many relationship. I was wondering if anyone else
had other situations in which you would use a compound PK? Why do you
use it instead of just a foreign key?
---(end of broadcast)
Hi,
Can I list tables and the time they were last update (adding columns,
drop columns) using sql, something like the "ls -l" command under
unix?
Can I compare the table definitions (tables, fields, but not data) of
two database using sql, something like the "diff file1, file2" command
under unix
> Besides what Tom says, '0' is a string, not an integer. PG takes
> it, but it's a bad habit.
Maybe it is and maybe it isn't. I wouldn't know. I'm merely the
unfortunate soul chosen to convert this from MySQL to Postgres. :-/
I've been working on it for a week now. I've got to say that it pai
> CREATE TABLE "credits" (
> "person" integer NOT NULL default '0',
> "chanid" int NOT NULL default '0',
> "starttime" timestamp NOT NULL default '1970-01-01 00:00:00+00',
> "role"
> set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','
RPK wrote:
How is FireBird rated when compared with PostgreSQL?
Firebird is a good db. But it has its spaces. Its is the little
brother of PG.
It has two modes: classic (spawn per connection, small caching) and
superServer (one program w/threads and lots of caching). superserver
does no
Hello all,
I was recently installing pg on a virtual machine. I also had pg installed
and working on my local machine.
On the vm I was having some issues installing a Drupal db so in searching
for a solution I found a recommendation of the following:
net user postgres /delete
and then reinstall pg
Tom,
You were right i just considered that a few minutes ago before getting your
response.
I set SELINUX=disabled in /etc/sysconfig/selinux and it started up ok.
a note in this file: http://pgfoundry.org/docman/?group_id=148 would be
handy for those who forget easily and aren't sysadmins :)
Gene <[EMAIL PROTECTED]> writes:
> In the past I've always done the following with success (this is under
> fedora core 6 x86_64):
> mv /var/lib/pgsql/data /data/pg/
> ln -s /data/pg/data /var/lib/pgsql/data
> /etc/init.d/postgresql start
> I just installed 8.2.2 on a new FC6 machine and when I d
-
PostgreSQL New RPM Sets
2007-02-05
Versions: 8.2.2, 8.1.7, 8.0.11, 7.4.16, 7.3.18
Set label: 8.2.2-1PGDG, 8.1.7-1PGDG, 8.0.11-1PGDG, 7.4.16-1PGDG,
7.3.18-1PGDG
---
On 2/3/07, elein <[EMAIL PROTECTED]> wrote:
On Tue, Jan 30, 2007 at 12:32:04PM -0800, Karen Hill wrote:
> Is it possible to have a pl/pgsql function take another pl/pgsql
> function as one of the parameters?
I think that OP meant (correct me if I'm wrong!) to be able to do
something like:
crea
In the past I've always done the following with success (this is under
fedora core 6 x86_64):
mv /var/lib/pgsql/data /data/pg/
ln -s /data/pg/data /var/lib/pgsql/data
/etc/init.d/postgresql start
I just installed 8.2.2 on a new FC6 machine and when I do that it fails to
start. The logs reveal no
Sorry if I'm the only one to find this amusing, but I see that the
original message was sent twenty minutes =after= I received it. :)
- John D. Burger
MITRE
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
h
On Sun, Feb 04, 2007 at 23:43:48 -0800,
David Fetter <[EMAIL PROTECTED]> wrote:
> On Sun, Feb 04, 2007 at 03:18:07PM -0200, Jorge Godoy wrote:
> > Tom Lane <[EMAIL PROTECTED]> writes:
> >
> > > Jorge Godoy <[EMAIL PROTECTED]> writes:
> > >> I'm using PostgreSQL 8.1.4 and psql 8.1.4 as well.
> >
FireBird has a different target audience than PostgreSQL, which is why
it's not compared to PostgreSQL as often as MySQL is.
FireBird is a direct descendant of Borland InterBase 6. Consequently,
much like Postgres inherited a lot of Ingres's weirdness (most of which
has since been weeded out or s
2007/2/3, George Weaver <[EMAIL PROTECTED]>:
>it's a windows-related problem
Is the Task Scheduler service running? (Start > Settings > Control Panel >
Administrative Tools > Services - Task Scheduler?).
If the Task Scheduler service is running , what does the Task Scheduler log
indicate abou
Jim Nasby wrote:
> Is there no way to change the index code to allow for moving index
> tuples from one page to another? If we could do that then presumably
> we could free up substantially more pages.
This paper
@inproceedings{DBLP:conf/sigmod/ZouS96,
author= {C. Zou and B. Salzberg}
Boguk Maxim wrote:
Postgres 8.1
Sample test table:
(all queries done on fresh vacuumed analyzed table with statistics on
rub_id and news_dtime set to 1000)
(all table in memory and server do not doing anything other)
media=> \d test_table
Table "public.test_table"
Column |
On Tue, Jan 30, 2007 at 03:05:27PM -0800, elein wrote:
>
> Debian Linux. Have always built from scratch with no problem.
>
> This is 8.2.1 from postgresql.org.
> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels
> -fno-strict-aliasing -g -Wno-error -L../../../../src/p
> Suddenly stops working, or continues doing exactly what it did before?
> I'm wondering if you are relying on a cached plan that doesn't include
> the new rule.
>
> regards, tom lane
>
If there´s only the insert_850 RULE then everything works as expected - the
insert pr
--
Confidentiality Notice: The information contained in this e-mail and any
accompanying attachment(s) is intended only for the use of the intended
recipient and may be confidential and/or privileged of
Tom Allison wrote:
> I would be careful about using dspam.
>
> I have documented cases where it lost email and even with posting all
> the debug and other logs on the mailing lists I've never received any
> indication that they recognize this as a dspam problem.
>
> dspam will lose your mail.
Th
25 matches
Mail list logo
