A drity method could be.
create table schema2.table2 as select * from schema1.table1 ;
in a loop that uses system catalogs.
regds
mallah.
On Wednesday 15 January 2003 06:08 pm, Lex wrote:
> I am playing with the new Schema feature in 7.3. I would like to copy
> the public schema into a new
Andre Schubert <[EMAIL PROTECTED]> writes:
> Ok, but is there another way to enable STATS_ROW_LEVEL for a special
> backend not connecting as superuser ?
No: the code is deliberately designed to prevent that, on the grounds
that it'd be a security flaw (non-superusers should not be allowed to
hide
Title: Gareth Stationery
Hey everyone.
We've got to re-install a server shortly,
and I'm trying to do a dry run of reloading their data onto a similar
server.
It's Postgres 7.1.3 on Redhat Linux ( 6.2 or
7.2 - not too important )
We used pg_dumpall > large to create a
file that's just unde
David Gilbert <[EMAIL PROTECTED]> writes:
> update customer_contact
> set next_billed=min(customer_services.eff_date)
> where customer_contact.conn_num=7698
> and customer_services.conn_num=7698
> and customer_services.inv_num=0
This is not a well-defined query --- exactly what do you th
On Wed, 15 Jan 2003 10:01:27 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andre Schubert <[EMAIL PROTECTED]> writes:
> > I want to enable the collection of STATS_ROW_LEVEL for special backends
> > by setting the environment-variable export PGOPTIONS='-c STATS_ROW_LEVEL=ON'.
> > After setting this v
Andre Schubert <[EMAIL PROTECTED]> writes:
> I want to enable the collection of STATS_ROW_LEVEL for special backends
> by setting the environment-variable export PGOPTIONS='-c STATS_ROW_LEVEL=ON'.
> After setting this variable i cant connect to my database.
> Everytime the following error occurs:
In the middle of a script, inside a transaction, I run the following
query:
update customer_contact
set next_billed=min(customer_services.eff_date)
where customer_contact.conn_num=7698
and customer_services.conn_num=7698
and customer_services.inv_num=0
I have also tried changing this to
Hi folks,
sorry if this might seem a bit too specific to WebObjects: I've used a
couple of derived attributes in my WebObjects app's EOModel. Simple stuff
along the lines of:
(SELECT COUNT(*) FROM address WHERE address.eoid_customer = customer.eoid)
in the Customer entity. (eoid being pk and eoi
I am playing with the new Schema feature in 7.3. I would
like to copy the public schema into a new schema. Is there an easy way to do
this? Something I can do with pg_dump (I don’t see a switch to specify
which schema) Right now I an only interested in copying the structures –
later on
Hi all,
I have a devel server where i want to turn on collector statistics.
I want to enable the collection of STATS_ROW_LEVEL for special backends
by setting the environment-variable export PGOPTIONS='-c STATS_ROW_LEVEL=ON'.
After setting this variable i cant connect to my database.
Everytime the
10 matches
Mail list logo
