> This table has no indexes at all. Each query made (using EXPLAIN) reveals a
> "Seq Scan".
> So far, everything is OK.
> Then I define 2 indexes, one affects a varchar field, for example 'lastname'
> an the other a float type field, let´s call it 'id'.
> When I perform a query such as SELECT * FR
Postgres Version : 6.5 (beta)
I have a table with 53411 rows.
This table has no indexes at all. Each query made (using EXPLAIN) reveals a
"Seq Scan".
So far, everything is OK.
Then I define 2 indexes, one affects a varchar field, for example 'lastname'
an the other a float type field, let´s call i
Does anyone know how to open a cursor for 'C" ..?
I have checked the previous postings but cannot locate the proper syntax
here is a snipit :
void ShowTable_type(){
EXEC SQL BEGIN DECLARE SECTION;
char *Atid; // variables to retrieve the table info
char *Adesc;
EXEC SQL END DECLARE SECT
Gah!
I had:
The error message:
PostgreSQL query failed: ERROR: attribute 'input' not found in ... on line 40
Normally I would think I just mis-typed a field name, but the word 'input'
is *NOT* anywhere in the query. Honest. I spit it out before pg_exec()
just to be sure. I even spit it out after to make
Dustin Sallings wrote:
>
> On Thu, 3 Jun 1999, The Hermit Hacker wrote:
>
> # One of the long-term projects that PostgreSQL, Inc is planning on
> # working on is exactly this, unless someone jumps at it before we get a
> # chance to...
>
> It should be a trivial change, right? :)
Will
Rob Walker writes:
> > I am trying to write code to access a product catalog (more as a learning
> > exercise than anything else) and need to implement some sort of searchable
> > hierarcy. For example:
> >
> > Computer Hardware (toplevel)
> >Hard Drives
> > Internal
> >
Kapoor, Nishikant X said ...
>
> Well, after a 'make distclean' and a ./configure, the gettimeofday() error
> went away. Infact, the ./configure showed that gettimeofday() neeeded two
> arguments. BUT, the compilation error is still there and I'm still hoping
> that some expert should be able to
On Thu, 3 Jun 1999, The Hermit Hacker wrote:
# One of the long-term projects that PostgreSQL, Inc is planning on
# working on is exactly this, unless someone jumps at it before we get a
# chance to...
It should be a trivial change, right? :)
# On Thu, 3 Jun 1999, Laurence Liew wrote:
On 3 Jun 1999, Anatoly K. Lasareff wrote:
# Yes. 'serial' type implements as 'int' type for field and sequence,
# which mane is __seq. So you can do this:
#
# INSERT into Network (parentID, networkName) values (pid, mname); netid
# := Network_networkID_seq.last_value;
That doesn't te
I'm forwarding this to the general list, as I haven't used an hp-unix box
before.
Peter
On Wed, 2 Jun 1999, GTI wrote:
> Hi
> I am about to install a PostgreSQL version (6.4.2) on a hp-unix machine.
> My GNU C++ compiler is version 2.8.1, and has been tested so that I know it works.
> Prior t
Well, after a 'make distclean' and a ./configure, the gettimeofday() error
went away. Infact, the ./configure showed that gettimeofday() neeeded two
arguments. BUT, the compilation error is still there and I'm still hoping
that some expert should be able to help me get through this.
./configure -
> tt=> create table test (a int4, b bit2);
> CREATE
> tt=> CREATE FUNCTION mytrig () RETURNS opaque AS
> '
> tt-> '
> tt'> DECLARE
> tt'> def_state CONSTANT BIT2 := 'b0001'::BIT2;
> tt'> BEGIN
> tt'> new.b = def_state;
> tt'> RETURN new;
> tt'> END;
> tt'> ' LANGUAGE 'plpgsql';
> ERROR: pa
I have my marvelous bit type working now, and now I find out I cannot
use it in PL scripts.
tt=> create table test (a int4, b bit2);
CREATE
tt=> CREATE FUNCTION mytrig () RETURNS opaque AS
'
tt-> '
tt'> DECLARE
tt'> def_state CONSTANT BIT2 := 'b0001'::BIT2;
tt'> BEGIN
tt'> new.b = def_state;
> I am trying to write code to access a product catalog (more as a learning
> exercise than anything else) and need to implement some sort of searchable
> hierarcy. For example:
>
> Computer Hardware (toplevel)
>Hard Drives
> Internal
> SCSI
> Fast SCSI
>
Hello,
I am trying to link to a Postgres table from MS Access using the insight ODBC
driver (6.40.0004). When I try to link I get the following error:
The servers MsysConf exists but is in an incorrect format.
This used to work before. Strangely enough this works with NT, same driver.
Any idea
> MH> Question 2:
> MH> is there a way to get the value of the newly assigned primary key
> MH> after an insert? (rather then following the insert with a select)
>
> MH> e.g. (this would be nice if it worked (networkID is the PKey))
> MH> INSERT into Network (parentID, networkName) values (pid,
One of the long-term projects that PostgreSQL, Inc is planning on working
on is exactly this, unless someone jumps at it before we get a chance
to...
On Thu, 3 Jun 1999, Laurence Liew wrote:
> Hi!
>
> Is anyone looking at making postgreSQL scalable across a cluster of PCs?
> That is, we have
Hi,
I'm trying to define a new bit type with a length of two bytes, and to
define a set of operators on this type. I've hit the following problem:
I cannot define a | operator, as the parser doesn't like it.
tt=> drop operator | (Bit2,Bit2);
ERROR: parser: parse error at or near "|"
tt=
> "MH" == Mike Haberman <[EMAIL PROTECTED]> writes:
MH> I'm a bit new to plpgsql, so this may be an easy question,
MH> I've got a function (see below) that inserts into 3 different
MH> tables. Each table has a SERIAL type for it's primary key.
MH> Question 1:
MH> I want to group all 3
Hi!
I'm a new member and new to postgres.
beside postgrest user I would also want my student to create their own
database in their own home directory.
first I issue (under postgrest user)
createuser user_id
then under that user_id I run
initlocation ~/sql/data
then I run
21 matches
Mail list logo
