HelloI have 2
postgreSQL databases called "DATA1" and "DATA2" with several tables inside them
(table A, B, C). I modify the details in table "A" in database "DATA1"
How can I copy table "A" from database "DATA1" and paste it in database
"DATA2" using the same table name ??Thank you.
Tom,
I'm sure there's all sorts of cool optimizations under the covers
to perhaps maybe to this short circuiting,
but as the sql goes, yeah, I'm sure.
Here's an example on oracle 10g release 2 (copy paste from my screen so
you can see the error messages and all):
SQL> create table foo
"Anthony Molinaro" <[EMAIL PROTECTED]> writes:
> An additional gripe is that this isn't a good feature (standard or not).
> Oracle doesn't do it. Db2 doesn't do it.
You sure about that? It's hard to believe that the SQL committee would
put a feature into the spec that neither Oracle nor IBM inten
Well...
An additional gripe is that this isn't a good feature (standard or not).
Oracle doesn't do it. Db2 doesn't do it. I strongly suggest you guys
don't
do it.
If you wanna do the optimizations under the covers, cool, but I can't
imagine how this would be useful other than for saving some typ
In standard SQL you have to
write GROUP BY ... and list every single column you need from the master
table.
This thread seems to have gone off on a tangent that depends on the
assumption that the above is a correct statement. It's not. It *was*
true, in SQL92, but SQL99 lets you o
Greg,
"
You would prefer:
select user_id,
any(username) as username, any(firstname) as firstname,
any(lastname) as lastname, any(address) as address,
any(city) as city, any(street) as street, any(phone) as phone,
any(last_update) as last_update, any(last_login) as l
On Thu, Oct 13, 2005 at 02:26:58PM -0400, Greg Stark wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > could run this query at the same time and get different data from the
> > same set and the same point in time.
>
> I'm pretty unsympathetic to the "we should make a language less powerful a
On Thu, 2005-10-13 at 13:26, Greg Stark wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
> > Sorry, but it's worse than that. It is quite possible that two people
> > could run this query at the same time and get different data from the
> > same set and the same point in time. That shouldn't
Indexes are on all join fields. In the shown
example on all fields I have indexes.
Yes I vacuum the database regulary.
Andy.
- Original Message -
From:
Thomas F.
O'Connell
To: Andy
Cc: pgsql-sql@postgresql.org
Sent: Thursday, October 13, 2005 7:58
PM
Subj
Scott Marlowe <[EMAIL PROTECTED]> writes:
> Sorry, but it's worse than that. It is quite possible that two people
> could run this query at the same time and get different data from the
> same set and the same point in time. That shouldn't happen accidentally
> in SQL, you should know it's comi
Is a working example something that people would like to see? Or is this
considered a good use of research time?
On Thursday 13 October 2005 11:20 am, Jim C. Nasby wrote:
> On Wed, Oct 12, 2005 at 10:52:04PM -0400, Tom Lane wrote:
> > Jeff Williams <[EMAIL PROTECTED]> writes:
> > > Thanks. Trigg
On Wed, Oct 12, 2005 at 10:52:04PM -0400, Tom Lane wrote:
> Jeff Williams <[EMAIL PROTECTED]> writes:
> > Thanks. Triggers was my first thought, but chapter 35 on Triggers didn't
> > really indicate a way I could do this easily and scared me with a lot of
> > c code.
>
> Yeah. This is a documenta
What indexes do you have on these tables?And have you ANALYZEd all three recently? --Thomas F. O'ConnellCo-Founder, Information ArchitectSitening, LLCOpen Source Solutions. Optimized Web Development.http://www.sitening.com/110 30th Avenue North, Suite 6Nashville, TN 37203-6320615-469-5150615-469-51
On Wed, 2005-10-12 at 20:13, Greg Stark wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
> > Hehe. When I turn on my windshield wipers and my airbag deploys, is it
> > a documented "feature" if the dealership told me about this behaviour
> > ahead of time?
>
> Well it's more like my car wh
On Wed, Oct 12, 2005 at 10:52:04PM -0400, Tom Lane wrote:
> the documentation of the "core" system shouldn't rely on them ... but
> that leaves us presenting C-code triggers as the only examples in
> chapter 35. There is a paragraph in there suggesting you go look at
> the PL languages first, but
On Thu, Oct 13, 2005 at 12:24:55AM -0400, Greg Stark wrote:
> Well the "constants and the like" are precisely the point. There
> are plenty of cases where adding the column to the GROUP BY is
> unnecessary and since Postgres makes no attempt to prune them out,
> inefficient.
But inefficient pruni
Hi
CREATE TRIGGER associates trigger function on a table and it is not possible to give more than one table seperated by comas.
CREATE TRIGGER emp_cust_stamp BEFORE INSERT OR UPDATE ON customersFOR EACH ROW EXECUTE PROCEDURE last_updated_stamp();
CREATE TRIGGER emp_cust_stamp BEFORE INSER
Frank Bax wrote:
At 09:00 AM 10/12/05, Daryl Richter wrote:
Richard Huxton wrote:
Frank Bax wrote:
[snip]
Richard, you've summed it up nicely.
Splitting locations into subsets (like 2,2,3) doesn't work because it is
possible that low values in one location can be offset by high values
Hello,
I am trying to store images (bin files) from delphi (ADO components) to
postgresql, I found data type bytea for that, but I could not make it
work. May be anyone has sample of delphi code? or can give any help with it?
thx
Lukas
--
This message has been scanned for viruses and
dangero
19 matches
Mail list logo
