I'm building a new geo type and would like to index it. I have heard about
RTREE and boundary box but I'm clueless for the moment about the
implementation
I have tried to look into PG source code to find the location where the
indexing is done of current line object is done, but couldn't pin
Jarmo Paavilainen writes:
> PS: Im thinking of making a own hack of pg where selects are case sensitive
> (ie Nov2000 and "Nov2000" are the same). If someone is interested, Ill
> upload the diff somewhere. DS.
Not that I particularly approve of this plan ;-) but look for tolower()
calls in src/b
Olivier Cherrier writes:
> I have :
> _ a server Postgresql
> _ my workstation
> I want to install the minimum configuration under the Postgresql server.
> On my workstation, I installed pgaccess and would like to connect to
> server and design databases.
> The server and the workstatio
On Fri, Nov 24, 2000 at 11:23:41AM -, Alistair Hopkins wrote:
> assuming users are logging on as psqluser but the db is owned by psqlowner:
> create table mysnapshot as select * from myuser;
> grant select on mysnapshot to psqluser;
o.k. but updating it requires to drop table, and recreate us
Hi,
...
> I have created a table with the name 'Nov2000' and now it is impossible to
> access it, because psql is always searching for the table 'nov2000'.
Put the table name inside quotes. ie: SELECT FROM "Nov2000" _not_ SELECT
FROM Nov2000
...
> Have I done something wrong or is it a bug ? I
Hello
>
>That document is not correct. --with-tcl is enough.
>
OK, I will reconpile my PostgreSQL server with only the tcl option.
>> Thus, I have no X-server on its. Is it a problem ?
>
>If you don't have an X server then you're going to have a pretty tough
>time running graphical ap
On Fri, Nov 24, 2000 at 01:29:41PM +0100, some SMTP stream spewed forth:
> I do
>
> copy tmp from '/home/algobit/product.txt
>
> tmp ia a table with one record (line varchar(255))
>
> in product.txt I have many line as:
>
> 2;"100";"Parmigiano Reggiano";"Parmigiano Reggiano stagionato 2
> ann
List z dnia: Pi? 24. Listopad 2000 05:51, :
> On Fri, Nov 24, 2000 at 08:35:34AM +0300, some SMTP stream spewed forth:
> > On Mon, Nov 20, 2000 at 12:44:20PM +0800, BaiJie wrote:
> > > I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED , NOT A INTEGER INDEX FROM
> > > I TO CURRENT ROW NUMBER!! HOW CAN
I do
copy tmp from '/home/algobit/product.txt
tmp ia a table with one record (line varchar(255))
in product.txt I have many line as:
2;"100";"Parmigiano Reggiano";"Parmigiano Reggiano stagionato 2
anni";4;"parmigiano4.jpg";2;"Fette 1 Kg";0.18;1;1.00;"true"
Then with "select * from tmp" the re
hi, i was wondering if there is something in postgresql like "create snapshot".
i once saw ti on friend's database (dont know what it was), and i really like
it.
snapshot is something like materialized view.
it is a physically existing table, with only select's allowable, and update
snapshot comma
Hi Ellen,
Subtracting one timestamp from another returns an interval type, like
this:
stasis=# select 'now'::timestamp - '10 Sep 2000'::timestamp;
?column?
-
75 12:06:57
(1 row)
But if you just want the days only, try this:
stasis=# select date_part('days', 'now'::timestamp - '1
Try a dump of your database using pg_dump. 4294967296 is the maxval if I
remember correctly. 32 bit integers are a good thing. Your question
still holds, what is the condition of overflow after maxval has been
reached.
Typically, you want to use a sequence like this for a unique opaque
indent
Hi :
I was using the wrong version(6.5.2) of pg_dump,that was
in
my PATH !!! With the correct version(7.0.2) the dump was
OK !!
Thanks !!
Claudio Grillo
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Claudio Grillo <[EMAIL PROTECTED]> writes:
> > getTables(): relation 'tb_bomb
Hi ,
I have created a table with the name 'Nov2000' and now it is impossible to
access it, because psql is always searching for the table 'nov2000'.
The only solution I have found is to manually modify the pg_class table and
the name of the physical file associated to the table.
Have I done som
Hi
As a newbie to SQL and databases, someone has asked me what is a "pivotal
system". Since in my experience most concepts are common across a number
of disciplines, just the vocabulary changes, can anyone (i) point me in
the right direction and (ii) can Postgres be set up to implement such a
sy
15 matches
Mail list logo
