Hi Folks,
I've got a question. Users that use the web-based databases that I've
recently written (cgi-perl and pgsql) sometimes come up with errors when they
input information. I have realized that I need to write some very rigorous
error-checking routines in order to make sure that whatever t
Hi,
Is there a way to get a dictionary back in the (or almost the) same way
the database is created ?
When defining:
create table xxx (
id varchar(10) not null,
blabla varchar(100)
);
create table refxx (
id varchar(10) not null,
other values ...
primary key(id),
foreign key(
On Sun, 18 Feb 2001, Martijn van Oosterhout wrote:
> Tom Lane wrote:
>
> [snip]
> >
> > Then why are you bothering to maintain a case-sensitive index?
> >
> > There's no free lunch available here; if you think there is, then you
> > are misunderstanding what an index is. Either the index is i
Bruce Richardson writes:
> Is there a function reference for Postgresql anywhere? I can't find one
> in the standard documentation.
http://www.postgresql.org/users-lounge/docs/7.0/postgres/functions.htm
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
In pre 7.0 versions there was an 8k query size limit and in all pre 7.1
versions a limit on the size of a field (BLCKSZ from 8k (default) to 32k)...
I'd say it's either in there to prevent one or the other.
Of course 8140 isn't quite 8k but *shrug*..
-Mitch
- Original Message -
From:
The DBD::Pg perl module for some reason has a limit of 8140 bytes when
inserting, and I don't see why (yeah, I'll be contacting the authors there
too), but I thought I'd ask here... I'm writing a Postgres-backed mail
client, and storing emails in the database is obviously a little difficult
wh
If I wanted to create a table in such a way that the default value of
one column is the value of another column (or the oid value), is there
a way to do that in the CREATE TABLE statement (with the DEFAULT
keyword, I'd imagine)? Or would I need to create a trigger?
--
Bruce
Is there a function reference for Postgresql anywhere? I can't find one
in the standard documentation.
--
Bruce
Richard Huxton <[EMAIL PROTECTED]> writes:
> You can also return a tuple like:
> create function whole_row() returns foo as ...
> But - that can only be used to feed into another function, not in a
> "raw" select statement.
You can make a function returning tuple (or setof tuple), but there
are a
set nomail
Through Konsole, the Up, Down, Left, Right keys work properly, but through
psql the keystrokes seem to be wrong:
instead of up (for scrolling in the internel buffer) it appears ^[[A
Down ^[[B
Right ^[[C
Left ^[[D
Back_del (ok)
Forward_del ^[[3~
It happened when I upgraded Mandrake from 7
Martijn van Oosterhout writes:
> Well, one thing would be is that it would make it easier for other
> people to submit changes to a particular page on the docs. You can just
> go there and submit a change. Sending a patch much harder.
The policy for documentation submissions has always been "Giv
Tom Lane wrote:
[snip]
That's a very good explanation, thanks. Is it possible to get that
explanation into the docs at that page I mentioned above?
> I'd like to see the feature brought back, myself, but I dunno when it
> will get to the top of someone's to-do queue.
I'd like that too, but the
Peter Eisentraut wrote:
>
> Richard writes:
>
> > Would this lighten the work load on the folk that are
> > currently maintaining the docs? Would it lighten the
> > work load for the core developers? Would it stimulate
> > the development of richer documetation? Would it draw
> > some of the
Today is the last day for O'Reilly proposals to be submitted:
http://candle.pha.pa.us/oreilly/
I will make decisions on Monday and inform submitters. Once the list is
finalized and accepted by O'Reilly, I will post the schedule.
--
Bruce Momjian| http://cand
Tom Lane wrote:
[snip]
> > Hmmm...I'd hate to have two indexes on every field I query like this, one
> > case-senstive, one case-insensitve (like the one you create here). Is
> > there a configuration option or something that will tell pgsql to do
> > case-insensitive comparisons (kinda like MS
Feite Brekeveld wrote:
>
> I want to return mre than 1 arg
>
> create function func(varchar)
> --> returns var1, var2
> as '
> ...
> '
> language 'sql';
>
> How to deal with the return : The manual says to use SETOF can't figure
> out how that works no examples are given.
Not quite right.
On Fri, Feb 16, 2001 at 09:36:23AM -0500, Bruce Momjian wrote:
>
> Funny you should mention PHP. I talked to Rasmus about the email volume
> when I first met him in the fall. He said the volume of email is so
> great that just reading the subject lines takes a long time.
>
> We aren't there
18 matches
Mail list logo
