On May 19, 2010, at 11:41 AM, Little, Douglas wrote:
> Hi,
>
> I have a fairly large data warehouse in Greenplum, and am having trouble
> tracking object changes.
> I need to
> 1.Know when an object was changed, by who.
> 2. Have some logging about when an object was dropped – e
On Wed, 2010-05-19 at 13:41 -0500, Little, Douglas wrote:
> Hi,
>
>
>
> I have a fairly large data warehouse in Greenplum, and am having
> trouble tracking object changes.
>
Depends on Greenplum I would assume. I don't know how compatible they
are with .Org anymore. You might look at table_
Hi,
I have a fairly large data warehouse in Greenplum, and am having trouble
tracking object changes.
I need to
1.Know when an object was changed, by who.
2. Have some logging about when an object was dropped - especially drop
cascade.
Currently I'm having a problem with a set
Hello,
We're migrating to Greenplum, and in our currently portfolio we base everything
on views.
In our prior system, we could alter tables and then refresh the views, but in
PG/greenplum most alters are blocked because of the dependent objects.
I understand that I can walk the pg_depends table
On Wed, 1 Oct 2008 22:19:29 +0200
"Filip Rembiałkowski" <[EMAIL PROTECTED]> wrote:
> > Is this kind of stuff going to affect any reference to the farm
> > table? eg. inside functions, triggers etc?
> no, not in functions source.
I've read somewhere that create *or replace* should be used exactly
2008/10/1 Ivan Sergio Borgonovo <[EMAIL PROTECTED]>:
> On Wed, 01 Oct 2008 08:32:16 -0600
> Bill Thoen <[EMAIL PROTECTED]> wrote:
>
>> CREATE TABLE farm2 (LIKE farms);
>> INSERT INTO farm2 (farm_id, fips_cd, farm_nbr, prog_year) SELECT
>> farm_id, fips_cd, farm_nbr, '2007' FROM farms;
>> DROP TABLE
On Wed, 01 Oct 2008 08:32:16 -0600
Bill Thoen <[EMAIL PROTECTED]> wrote:
> CREATE TABLE farm2 (LIKE farms);
> INSERT INTO farm2 (farm_id, fips_cd, farm_nbr, prog_year) SELECT
> farm_id, fips_cd, farm_nbr, '2007' FROM farms;
> DROP TABLE farms;
> ALTER TABLE farm2 RENAME TO farms;
> CREATE UNIQUE
Hello all,
When you create a new database, not all objects in that database are
owned by the database owner. Now some of those may need to be owned by
a superuser, eg C functions. However should other things such as the
public schema or other general objects be owned by the database owner,
OK.understand.
I'll exclude relkind IN( 's' , 'c' ) file in backup set.
THANKS Qingqing Zhou & tom lane!
Tom Lane wrote:
> "Qingqing Zhou" <[EMAIL PROTECTED]> writes:
>
>>Pg_xactlock is always there as a special relation.
>
>
> pg_xactlock isn't really a relation. The way I think about it is
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> Pg_xactlock is always there as a special relation.
pg_xactlock isn't really a relation. The way I think about it is that
it's a dummy entry in pg_class that exists to reserve a relation OID
for a specific purpose --- namely, we can lock transaction ID
Pg_xactlock is always there as a special relation. It has no footprint on
disk. Transactions will keep a record in pg_xactlock at the beginning and
remove the record at the end. Once any conflicting update happens, the
latter transaction will use this relation to wait for the former
transaction's r
Hi.
I'm writing backup guide and script.
I will look up on-disk-filename should be backuped
in a pg_class, like:
>SELECT oid,relfilenode,relname,relkind FROM pg_class;
it return like:
> 17173 | 17173 | sql_packages| r
> 17182 | 17182 | pg_toast_17178_index
Am Dienstag, den 25.01.2005, 08:36 -0500 schrieb Alex Turner:
> Actualy max() works just fine. It's not the solution I use in the
> middle tier, but it works for a functional example. both max() and
> currval() are bad because they can cause a race condition where the
> sequence has been incremen
On Tue, Jan 25, 2005 at 08:36:53AM -0500, Alex Turner wrote:
> Actualy max() works just fine. It's not the solution I use in the
> middle tier, but it works for a functional example. both max() and
> currval() are bad because they can cause a race condition where the
> sequence has been increment
On Mon, 24 Jan 2005, Alex Turner wrote:
> Insert fails with a foreign key constraint error because entity_phone
> points to entity, not person, and the rows aren't physicaly in entity,
> they are in person.
>
> Two questions:
> 1) Why can't we make this work the 'right' way - not doing so either
>
Actualy max() works just fine. It's not the solution I use in the
middle tier, but it works for a functional example. both max() and
currval() are bad because they can cause a race condition where the
sequence has been incremented by another thread. It's always better
to get nextval('sequence')
On Mon, Jan 24, 2005 at 07:22:32PM -0500, Alex Turner wrote:
> I am facing the classic pgsql ORDBMS problem:
Why are you using MAX()? That won't work at all. Perhaps you need to
look up the documentation for nextval and currval. In particular, that
second query should be:
insert into entity_pho
I am facing the classic pgsql ORDBMS problem:
create sequence entity_id_seq;
create table entity (
entity_id int not null default nextval('entity_id_seq'),
primary key (entity_id)
);
create table person (
first_name varchar(32) not null,
last_name varchar(32) not null,
primary key (enti
Well in fact we're currently using SQL server 2000, which doesn't
support object oriented technology; however, I was researching the
possibility of migrating to a database that provides the features I
mentioned, as, although not 100% crucial to the application, they fit
pretty well with the nature
From: "Renaud Tthonnart" <[EMAIL PROTECTED]>
> Can I create object and methods with postgreSQL.
> And how?
>
> Thank in advance,
> Renaud THONNART
You can define your own types with functions and operators - see chapter 13
of the programmers manual.
- Richard Huxton
Can I create object and methods with postgreSQL.
And how?
Thank in advance,
Renaud THONNART
All,
Came across a Gartner/Tech Republic research piece on object support
in Oracle 8:
http://www.techrepublic.com/download_item.jhtml?id=dr00220001002jim01.htm
You need to register for the site, but it's free. I'd be happy to
email the PDF to anyone individually as well.
Anyone know what's n
Title: Object syntax
Given the following table definitions, and data inserts:
dev=# create address (addr varchar(50), postcode varchar(9));
dev=# create client (name varchar(30), addr address);
dev=# insert into client values ('Michael');
dev=# insert into address values ('11 Windsor Close',
Hi,
This has been broken in postgres for many years. But I have fixed it
recently in current CVS. So you'll either have to wait for the next
release or else risk a development version. Another option is to go
to patches archive and manually apply the patch to 7.0.2 which wouldn't
be that hard.
Umm. I need to know the type of the _object_, not the types of the
attributes contained therein.
José Soares wrote:
>
> --retrieve column information...
>
> SELECT a.attnum, a.attname, t.typname, a.attlen,
> a.atttypmod, a.attnotnull, a.atthasdef
> FROM pg_class c, pg_
--retrieve column information...
SELECT a.attnum, a.attname,
t.typname, a.attlen,
a.atttypmod, a.attnotnull,
a.atthasdef
FROM pg_class c, pg_attribute
a, pg_type t
WHERE c.relname = 'comuni'
and a.attnum > 0
and a.attrelid = c.oid
What's the best way to do this in postgres? (basicly finding the type of
objects).
I want to run a web site with different types of content - question and
answers, stories etc. I propose an object hierarchy...
webobject (title, body)
question inherits webobject
story (image) inherits (webob
27 matches
Mail list logo
