Lorenz,
Have you run VACUUM on the table?
Norman
On Wednesday 01 November 2000 05:43 am, you wrote:
> I'm using 'PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.0, compiled by
> cc'.
>
> The problem is that the following statement takes approx 3hrs on a table
> with approx 136,000 records.
>
> upd
"Cesar A. K. Grossmann" <[EMAIL PROTECTED]> writes:
> create function
> vinculoExportacao (varchar)
> returns setof
> as 'select codigo, nome, ''T'' as selected
> from cad_exportacao
> ...
> psql:tmp/teste2.sql:15: ERROR: parser: parse error at or near "as"
setof *what* ? The parser is expectin
> Now, the question is: Is there a way to know if a given table exist?
> Besides doing a direct query to it, of course, as I think that would be
> too much of a dinamite-fishing way of doing it.
I believe you want the pg_tables table (view?) A quick and dirty way would
be :
select tablename fro
Well, you can do
select * from pg_class where relname=''
which will tell you if there's a view/table/index
with that name.
Stephan Szabo
[EMAIL PROTECTED]
On Thu, 2 Nov 2000, Alvaro Herrera wrote:
> Hi
>
> I'm Alvaro Herrera, from Chile, South America, where I study CS
> (mostly). I'm new to
Well, I'll answer your questions and help you a little too, or at least
try...
* Alvaro Herrera in "[GENERAL] Does this table exist?" dated 2000/11/02
* 17:44 wrote:
> Now, I'm building a database to hold customer data that needs to be
> organized in a one-table-per-customer manner. No, I don't
Hi
I'm Alvaro Herrera, from Chile, South America, where I study CS
(mostly). I'm new to PostgreSQL and to SQL in general.
That's for my introduction.
Now, I'm building a database to hold customer data that needs to be
organized in a one-table-per-customer manner. No, I don't think there's
anoth
Hi!
I'm trying to use pgaccess to create a function that returns the same
tuples the query bellow:
select codigo, nome, 'T' as selected
from cad_exportacao
where codigo in (
select codigo
from user_codigo
where
username = 'cesar' and
tipo
by the number of 'set digest' messages I am seeing on the list I can finally assume
that I am not the only one that this has happened to. The general list seems to have
lost its digest setting, and for some reason I also got subscribed to the Hacker list.
While I like receiving these messages
On Thu, 2 Nov 2000, Tom Lane wrote:
> > and looking at the c client library, but I haven't been able to find
> > any information about the protocol used between the postgres database and
> > the clients,
>
> See the developer's guide at
> http://www.postgresql.org/devel-corner/docs/postgres/
Do
Greetings all,
We have been using postgres for quite some time now with excellent results.
A client of ours is looking for a Supply Chain Management solution. We would
like to implement it using postgres.
Has anyone on the list implemented an SCM using postgres.
Is there any interest in doing a
"Bernie Huang" <[EMAIL PROTECTED]> writes:
> Strange enough, it seems like the 2-d text array size depends on the last
> element size.
Looks like a bug to me too ... probably silliness in the array_in
routine that determines dimensions of an unspecified-dimensions input.
Want to look at it?
> B
Peter Korsgaard <[EMAIL PROTECTED]> writes:
> I have been browsing a bit around the develop corner at postgresql.org
> and looking at the c client library, but I haven't been able to find
> any information about the protocol used between the postgres database and
> the clients,
See the developer'
A person who will remain nameless wrote:
> set digest
Perhaps it's time to remind people once again that sending list
management commands to the list repeater address accomplishes nothing,
except to annoy the hundreds of other members of the mailing list.
If you need to change/add/remove your s
Hi,
We created a database with some boxes in it. We make spatail queries on
the boxes. like:
SELECT openMapIndex
FROM tableName
WHERE BBOX::box && '((-73,45),(-74,46))';
The query is working fine. We indexed the field BBOX. It takes about 17
seconds when doing a sequential search and 0.5 second
Hello,
RedHat 7.0, Postgres 7.1 (libpq), Intel Cel 433, 64mb, 15g hd.
I am running a test which performs 1000 transactions of 1000 updates of a single
column in a single table, or (1 tranaction = 1000 updates) *
1000. I have no indecies for any of the columns and the table has 3 columns and 20
On Thu, Nov 02, 2000 at 06:50:07AM -0500, Keith L. Musser wrote:
> > upper(a.word) = 'JIM' or upper(a.word) = 'JONES'
> > upper(s.word) = 'HELLO' or upper(s.word) = 'THERE'
> Interesting possibility. Unfortunately, the outer select ends up being
> a sequential scan over the entire messages table,
Hello Mike,
Thursday, November 02, 2000, 1:00:51 PM, you wrote:
ME> * Bob Hartung ([EMAIL PROTECTED]) wrote:
>> Partial success!
>> I have postgresql started and have "createdb testdb"
>> successfully. I am having trouble with autostarting
>> postmaster in RH6.2 however.
>>
>> I have copie
On Thu, Nov 02, 2000 at 05:00:51AM -0800, Mike E wrote:
> You can't run postmaster as root, so to do this I believe you
> have to write a wrapper script and give it a postgres (or whatever
> your admin account is named) sticky bit.
I usually make the script 'su' into postgres and then startup
po
* Bob Hartung ([EMAIL PROTECTED]) wrote:
> Partial success!
> I have postgresql started and have "createdb testdb"
> successfully. I am having trouble with autostarting
> postmaster in RH6.2 however.
>
> I have copied the file
> "/usr/local/postgresql-7.0.2...postgres-init" to
> /etc/rc
> On Thu, Nov 02, 2000 at 05:35:04PM +0600, Denis Perchine wrote:
> > Except on case... When you would like to be sure in transaction safety...
>
> Ok, but not for image galery.
Again... If you can accept that you will have half of image, it's OK.
If not...
--
Sincerely Yours,
Denis Perchine
-
On Thu, Nov 02, 2000 at 02:39:54PM +0300, Igor Roboul wrote:
> On Thu, Nov 02, 2000 at 05:35:04PM +0600, Denis Perchine wrote:
> > Except on case... When you would like to be sure in transaction safety...
> Ok, but not for image galery.
I have answered on argument about transactions
--
Igor Rob
On Thu, Nov 02, 2000 at 05:35:04PM +0600, Denis Perchine wrote:
> Except on case... When you would like to be sure in transaction safety...
Ok, but not for image galery.
--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcr
> > I want to make a image catalogue. I will use postgresql, perl and php.
> >
> > What are the advantages of having the images in the database instead of
> > having them out in a directory?
> >
> > After all, to show the images I need them on a directory?
>
> Really, you can show images from data
Found examples in:
http://www.postgresql.org/docs/aw_pgsql_book/node188.html
These include the techniques that I use at home and have had "few" problems.
Have fun.
> -Original Message-
> From: Nick Fankhauser [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 01, 2000 7:58 PM
> To:
24 matches
Mail list logo
