On Wed, 3 Jan 2001, Lincoln Yeoh wrote:
> Actually I agree with Eric.
>
> The documentation is not as detailed or organised for usage. But it is
> decent. Only sometimes you need to resort to real-life testing to see how
> things really work. I do like the real world practical info which the MySQ
On Wed, Jan 03, 2001 at 01:20:43AM +0100, Artur Pietruk wrote:
> > try to make a connection to my database, I get the following error at
> > runtime:
> ...
> I'm sorry that I am answering that question after a month, but i
> did not see someone solving your problem.
I did. But I had private
> Then it goes right back to what someone else eluded to... If you don't
> like what you see in the documentation, contribute. Send in diffs, or
> even new items. If you don't know what's needed go to the DOCS list and
> ask. Getting people to help with documentation for ANY project is like
>
On Wed, 3 Jan 2001, Gregory Wood wrote:
> > Then it goes right back to what someone else eluded to... If you don't
> > like what you see in the documentation, contribute. Send in diffs, or
> > even new items. If you don't know what's needed go to the DOCS list and
> > ask. Getting people to
Where do I find information about a sequence? I'd like to know what are
the table and column referenced by a sequence. As its name may be
truncated, it's not a consistent place to look for.
The system tables didn't seem to help.
Thanks
--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
I received an off list comment regarding this documentation issue that's
been discussed here the last few days. Rather than respond to the
comments privately I'm posting them to the whole list so that maybe folks
will understand that asking for documentation contributions doesn't
necessarily imp
I had meant to post my reply to the list... I'm used to just hitting reply
and sending it directly to the list. I would've kept it at that, but since
Vince felt he had to share, I thought I'd just post this as well.
Greg
> > > Then it goes right back to what someone else eluded to... If you
don
Hi,
I've got a problem when doing an import of data after a backup.
bkp cmd: pg_dump mydatabase > db
Then I dropped the base and recreate one.
When doing a "psql -e mydatabase < db", an error occured when recreating
indexes.
The error is :
-
FATAL 1: btree: failed to
Andre Fortin writes:
> SELECT * from Equipment*;
>
> Is there a way to know from which table each row in the returned record
> set belongs to, as you can do with OO languages.
In 7.1 there will be an implicit column TABLEOID. In 7.0 and earlier
there's no good way short of maintaining suc
>
>What a horrible chicken and egg scenario... you can't help with providing
>documentation until you have some deal of experience with something, but if
>you ask for better documentation to get that experience, you are told to
>write some. I understand the frustration, but at the same time, plea
Try:
--This shows all default values for columns
SELECT DISTINCT c.relname, a.attname, t.typname, pa.adsrc, a.atttypid
FROM pg_attribute a, pg_class c, pg_type t, pg_attrdef pa
WHERE a.attrelid = c.oid
AND a.atttypid = t.oid
AND c.oid = pa.adrelid
AND a.attnum =
"Herve Piedvache" <[EMAIL PROTECTED]> writes:
> When doing a "psql -e mydatabase < db", an error occured when recreating
> indexes.
> The error is :
> -
> FATAL 1: btree: failed to add item to the page in _bt_sort (2)
Wow. I thought we'd fixed that. Is your db dump fil
Hello,
I have some doubt about index.
Look the follow example:
naslog=# \d desconexao
Table "desconexao"
Attribute|Type |Modifier
+-+-
i just wanted to let you all know that i'm so very happy to have joined
the list. since my first day on here, support has been great. i happen to
use NetBSD/alpha and it's not the most advocated OS or platform but i like
it very much. i am still an mysql user. my impression of your support thus
fa
Eric Mueller writes:
> I'm baffled by what seems to be a lack of detailed documentation for
> something so fundamental as the built-in functions.
Just to add a particular point, in addition to Vince's excellent general
points, as the one who was last to update the function documentation:
The rea
On Wed, 3 Jan 2001, Peter Eisentraut wrote:
> > I'm baffled by what seems to be a lack of detailed documentation for
> > something so fundamental as the built-in functions.
>
> Just to add a particular point, in addition to Vince's excellent general
> points, as the one who was last to update the
> I don't think so.
>
> I'm wondering whether that feature would make Oracle faster for
hierachical
> stuff, or just more convenient.
>
I don't really know about that, but all hierarchical queries that I've done
have been pretty fast. And they are indeed very, very convenient.
> Cheerio,
> Link
Hi, when I try to do something like
PQexec(conn,"BEGIN");
I have got stranges logs like query:
ø(
ERROR: parser: parse error at or near "ø"
It seems that postgres doesn't recieve the good query does any one no
why ??
--
François Lodier . _
.
Hi all -
Are triggers part of the transaction block that triggered the
trigger? I mean if I have a trigger that updates (an insert) a table (say
for logging or whatever) and that insert fails will the original query the
fired the trigger also get rolled back?
I'm using 7.0.3.
Thanks!
-
Hi Michael,
>create table tst (id int, amount numeric(9,2));
>insert into tst values (1, 1.10);
>insert into tst values (2, 1.00);
>insert into tst values (2, 2.00);
>select * from tst where amount = 1; -- works
>select * from tst where amount = 1.1
>Actually, I like the 'grid' layout that the functions are listed in -- it
>gives the syntax, the return value and an example of usage, all in a
>single glance.
I do too, the only thing I could think to add would be an example of a
return value, i.e. trunc(42.4) | 42
Rob Nelson
[EMAIL PROTECTE
Peter - agreed, those are pretty basic functions. I'm thinking more about
stuff like the date/time functions-- abstime(), age(), interval(), that sort
of thing. I see interval() in the grid and notice that it has the word
'reltime'-- is that a data type? How is it used? Does interval() accept any
Hello Everyone,
I am in the process of migrating my Access97 application to PostgreSQL. So
far everything looks great with one exception. I converted my currency
fields in Access to numeric(9,2) as recommended in the PostgreSQL
documentation. Many things to don't play well with the numeric
23 matches
Mail list logo
