Hi,
Konstantin Petrenko wrote, On 8/26/2003 11:37 AM:
Hello.
I accidentally deleted some recordes from my table. How can I restore
them? Is it possible in 7.3.3?
if you have a dump, or you are still in a transaction, you can rollback.
C.
---(end of broadcast)---
August 26th 2003
12:31p
Thank you for the quick response.., can u plz tell me how can I do that in db2 also..
Have a grate day
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050
DISCLAIMER: This message c
On Tue, Aug 26, 2003 at 23:15:48 +0530,
[EMAIL PROTECTED] wrote:
> August 26th 2003
> 11:30p
> How do I get the required number of rows thru a query..
> I mean...If I want to show 10 tuples per page.. instead of getting all the tuples
> from the relation and do some front end manipulation, is th
August 26th 2003
11:30p
How do I get the required number of rows thru a query..
I mean...If I want to show 10 tuples per page.. instead of getting all the tuples from
the relation and do some front end manipulation, is there any way by which I can get
only 10 required tuples from the relation
Ha
Hello.I accidentally deleted some recordes from my table. How can I
restorethem? Is it possible in 7.3.3?ThanksKonstantin
Petrenko.
TIA all...
Four tables:
content: content_id, content_name, ...
content_features: content_id, feature_id
device_features: device_id, feature_id
device: device_id, device_name, ...
One item of content can run on many devices, providing all the required
features in "content_features" corres
Hi Tom,
Not believing that PostgreSQL would be less consistent than Microsoft :-), I
spent some time looking at how the application actually was transferring the
date to the database procedure. When the datereceived parameter was defined
as type Date, it was actually arriving at the procedure as
> ... When the datereceived parameter was defined
> as type Date, it was actually arriving at the procedure as "11-08-2003" and
> "25-08-2003" in spite of showing up as indicated below. When I redefined
> the datereceived parameter as type OdbcDate, it arrived correctly at the
> procedure as "2003
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Should we consider adding some warning when someone creates an index on
> an int2 column?
I don't think so. Better to expend our energy on solving the
fundamental problem.
regards, tom lane
---(end of br
Hi gurus,
I have table A, B and need a distinct count of
Accounts from A. There is a one-2-many relation
between A and B. Accounts # in A are all unique.
However, in B there will be duplicates. So the
problem I have is, when I join as follows:
Select Count(Distinct(account_no))
from A, B
whe
On Tue, 2003-08-26 at 08:50, BenLaKnet wrote:
> just one question
>
> You use zope with postgresql ??
yes.
> No problem of connection ?
Until now no. I use debian unstable.
ciao, Michele
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
just one question
You use zope with postgresql ??
No problem of connection ?
Michele Bendazzoli wrote:
On Mon, 2003-08-25 at 09:12, Michele Bendazzoli wrote:
ops ...
apologies for the message.
Michele
---(end of broadcast)---
TIP 7: don't fo
"George Weaver" <[EMAIL PROTECTED]> writes:
> Does anyone have any idea why the default for seedlot recorded the time wit=
> h the day and month switched, resulting in the seedlot record being stamped=
> Nov 8, 2003 while the transaction was stamped correctly as Aug 11, 2003?
It's really not poss
Hi Tom,
I have written both the application and the PostgreSQL procedures (still in
development). All the timestamps I referred to are created by default when
the stored procedure is invoked. The problem may be due to some
inconsistency in how PostgreSQL is interpreting what the operating system
On Mon, 25 Aug 2003, Joseph Shraibman wrote:
> How can I join on one table with join conditions refering to two tables? In this
> example
> p is missing an entry that corresponds to u. I want to select from u and p, but have
> entries in u that don't have an entry in p. The problem is I need t
Should we consider adding some warning when someone creates an index on
an int2 column?
---
Tom Lane wrote:
> Marco Vezzoli <[EMAIL PROTECTED]> writes:
> > ewsweb_test=> \d measures_product
> > Index "measures_product"
> >
On Tuesday 26 August 2003 02:58, Joseph Shraibman wrote:
> How can I join on one table with join conditions refering to two tables?
> In this example p is missing an entry that corresponds to u. I want to
> select from u and p, but have entries in u that don't have an entry in p.
> The problem i
How can I join on one table with join conditions refering to two tables? In this example
p is missing an entry that corresponds to u. I want to select from u and p, but have
entries in u that don't have an entry in p. The problem is I need to go through table a
to get the corresponding value
18 matches
Mail list logo
