At 06:38 PM 4/2/2001 -0400, you wrote:
>Soma Interesting <[EMAIL PROTECTED]> writes:
> > Judging by the mailing list archives, lots of people have ran into this,
> > but none received answers.
>
>You must not have looked in the right threads.
>
>If you're
At 11:03 AM 4/2/2001 -0700, you wrote:
>linking ./include/port to interfaces/odbc/port
>mkdir: cannot create directory `interfaces/odbc': No such file or directory
>ln: ./include/port: hard link not allowed for directory
>configure: error: can not link interfaces/odbc/port to ./include/port
Ok, t
I'm attempting to recompile postgres with perl support. Perl compiled fine,
however postgres insists on compiling with odbc...
I'm getting the following error when I attempt to ./configure
linking ./include/port to interfaces/odbc/port
mkdir: cannot create directory `interfaces/odbc': No such f
At 06:47 PM 3/30/2001 -0600, you wrote:
> > I may be able to use array's if postgres will allow using variables to
> > reference points in the array.
OK, so how do I reference a specific element of an array in a record within
pl/pgsql.
I've tried:
NEW.name[1]
NEW.name.1
At 05:47 PM 3/30/2001 -0600, you wrote:
>HOWEVER -- we do have arrays, don't forget... sometimes they can
>be bent to do more than intended (but usually not!)
>
> create table mailing(
> person_id serial,
> sent int4[],
> prefs varchar[],
>
At 11:30 AM 3/30/2001 -0600, you wrote:
>In my experience, the best way to find out answers like this is to try it
>out and see. Usually I find that I need to fiddle around with the syntax a
>bit (I believe it's called debugging) before getting something to work.
>Postgresql is very powerful; the
>blah blah blah
>
>...and that all meant what? The postgres manual is open to much
>interpretation to anyone new trying to understand its contents. Combine
>that with documentation that's still not written, or broken across several
>different sections (programmer, user, admin, etc) and a sear
At 12:41 AM 3/29/2001 -0600, you wrote:
>do. In the case of logfunc1(), the Postgres main parser knows
>when preparing the plan for the INSERT, that the string 'now'
>should be interpreted as datetime because the target field of
>logtable is of that type. Thus, it will make a constant from it
>at
At 02:27 PM 3/6/2001 -0500, you wrote:
>date_part('epoch', timestamp) produces a Unix-style seconds count.
>
> regards, tom lane
Ok, thanks I misunderstood the directions and thought I had to use epoch
with the timestamp function somehow :)
this is my trigger and functi
I should have mentioned that NEW.id is set to default to nextval('id_seq').
>this is my trigger and function:
>
>CREATE FUNCTION oned_member_num() RETURNS OPAQUE AS '
> BEGIN
> NEW.member_num := NEW.id + date_part('epoch', timestamp
> 'now');
> RETURN ne
Can I test for an existing table before issuing the "CREATE TABLE" command?
IF EXISTS employees{
DROP TABLE employees
}
CREATE TABLE employees
Can you provide an example of this. I couldn't find this in the manual or
Bruce's book - did I not look hard enough ? :)
- -
I'm using PHP & PostgreSQL.
All values called from the database are still padded with extra spaces from
the column size in the database. Is this normal - I don't remember this
happening when I was using MySQL. I thought usually the database stripped
the extra spaces when it retrieved the value
Date: Mon, 11 Dec 2000 18:43:55 -0800
To: [EMAIL PROTECTED]
From: Soma Interesting <[EMAIL PROTECTED]>
Subject: help with referential integrity
I'm attempting, for the first time, to make use of referential integrity,
but I'm getting an error.
Warning: PostgreSQL que
I'm attempting, for the first time, to make use of referential integrity,
but I'm getting an error.
Warning: PostgreSQL query failed: ERROR: referential integrity violation -
key referenced from LessonsPages not found in Lessons
Here is the table's structures:
CREATE SEQUENCE "LessonsPages_id
I've sent a message of mine to this list twice now, and it never comes
through. Odd.
- - - - - - -
- - - - -
WARNING: Some experts believe that use of any keyboard may cause serious
injury.
Consult
Documentation on multi-byte and locales support seems to be lacking in the
postgreSQL site - anyone have any information on this?
Thanks.
At 11:48 PM 12/5/2000 -0500, you wrote:
>Soma Interesting <[EMAIL PROTECTED]> writes:
> > I'd like to get an idea of the overhead introduced by large quantity of
> > tables being hosted off a single PostgreSQL server. It is possible I'll be
> > wanting to host
17 matches
Mail list logo
