hi,
i have functin which did compile on 7.0.3 and 7.1beta1, and now it doesn't.
it includes were:
#include
#include
#include
#include
since in 7.1beta4 there is no postgres.h i changed this to:
#include
#include
#include
#include
all i need this for is to have type declarations, and po
Stephan Szabo wrote:
> On Wed, 21 Feb 2001, Renaud Tthonnart wrote:
>
> > How can I use sequences in a stored procedure written with pl/pgsql?
>
> What exactly are you trying to do? Pretty much you can call the
> sequence functions you want to use on the sequence name you
> want (you have to dou
On Thu, Feb 22, 2001 at 10:21:12PM +1300, Christopher Sawtell wrote:
> I did a cvsup update about 12 hours ago and look:-
> 22:05:23 chris@berty:/usr/src/cvs/pgsql $ find . -name postgres.h
> ./src/include/postgres.h
> 22:16:22 chris@berty:/usr/src/cvs/pgsql $
sorry. my fault. i was wrong becaus
Hello:
I'm having problems with restoring database. I'm using PostgreSQL 7.0.3 on
Solaris 2.6 on a Sparc machine.
The database contains large tables, the largest contains 1,5 million rows.
While pg_dump is quite quick, restore takes ages. Situation improves if I
split the dump file into smaller
On Thu, 22 Feb 2001 22:39, hubert depesz lubaczewski wrote:
> On Thu, Feb 22, 2001 at 10:21:12PM +1300, Christopher Sawtell wrote:
> > I did a cvsup update about 12 hours ago and look:-
> > 22:05:23 chris@berty:/usr/src/cvs/pgsql $ find . -name postgres.h
> > ./src/include/postgres.h
> > 22:16:22
From: "Tom Lane" <[EMAIL PROTECTED]>
> Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> > We have a table with over 1 million rows and the statistics Postgres
gathers
> > are not particularly useful. There is not one (non-null) value that
occurs
> > significantly more often than other values
Greetings,
I have a small table with serial numbers in it.
I wish to get a selection ( approx 30 ) of those numbers into an array in
another table.
Is this possible in SQL?
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN45863470
EMAIL csawtell
Hi,
I'm trying to compile postgresql with the VACUUM LAZY patch,
but I have an error with yacc :
/usr/bin/yacc: f - maximum table size exceeded
Where should I look to fix this ?
Thanx.
Guillaume.
* Guillaume Lémery <[EMAIL PROTECTED]> [010222 04:01] wrote:
> Hi,
>
> I'm trying to compile postgresql with the VACUUM LAZY patch,
> but I have an error with yacc :
>
> /usr/bin/yacc: f - maximum table size exceeded
>
> Where should I look to fix this ?
Install Bison and re-run "configure"
-
On Thu, Feb 22, 2001 at 11:24:48PM +1300, Christopher Sawtell wrote:
> Very strange indeed.
> I have found that using cvsup is a very reliable way to keep the code
> in order. In my experience postgresql is of ultra-superior quality and
> everything just makes "out of the box".
i had the same pr
Hello:
It is possible to display error messages from PostgreSQL in other languages rather
than English ?, if it is possible, how can
achieve that. I love this RDBMS but this seems to be a problem for us in using it
with our customers. Any help or answer will
be aprecciated.
Thank yo in adv
Why does a SELECT apply to all tables, including inherited ones and not
UPDATEs or DELETEs? Is there a way to UPDATE a whole table hierarchy in
one fell swoop?
TIA
--
HIPPOLYTE: Donnerai-je l'exemple à la témérité ?
Et dans un fol amour ma jeunesse embarquée...
On Thu, Feb 22, 2001 at 02:45:46PM +0100, Louis-David Mitterrand wrote:
> Why does a SELECT apply to all tables, including inherited ones and not
> UPDATEs or DELETEs? Is there a way to UPDATE a whole table hierarchy in
> one fell swoop?
Oops, I take that back; indeed it UPDATEs and DELETEs apply
Where can I download PostgreSQL v7.1? Please
forward me to the URL where I can download it. Is there already binaries or do I
have to compile it?
TIA,
Paulo
ftp://ftp.postgresql.org/pub/dev/ all
of the 7.1 files are there though they are still in beta form.
Mike
- Original Message -
From:
Paulo
Parola
To: [EMAIL PROTECTED]
Sent: Thursday, February 22, 2001 10:04
AM
Subject: Location of 7.1 version for
download
Inside a plpgsql function trigger, is it possible to a loop over all
fields of the NEW record (and inspect their value) without knowing in
advance from which table NEW will come?
I am trying the following:
DROP FUNCTION arch_func();
CREATE FUNCTION arch_func() RETURNS opaque AS '
DECLARE
rec
This qwery takes about 2 seconds :
SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5;
This one about 5 seconds :
SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
On Thu, Feb 22, 2001 at 05:10:51PM +0100, Renaud Tthonnart wrote:
> This qwery takes about 2 seconds :
[..]
Can you send us the output of EXPLAIN for each of these queries?
Also, how large are the tables you're working with? What
indexes have been created?
Cheers,
Neil
--
Neil Conway <[EMAIL
Luis Magaña writes:
> It is possible to display error messages from PostgreSQL in other languages rather
>than English ?
No
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
I think CURSORS would be the correct way to do it..
http://www.postgresql.org/docs/aw_pgsql_book/node142.html
Jeff
On Tue, 20 Feb 2001, Richard Ehrlich wrote:
> I can post info to PostgreSQL from a webform via JSP, and I can post
> reports from PostgreSQL to a webpage. Can anyone tell me how
Here they are :
EXPLAIN
(SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5);
NOTICE: QUERY PLAN:
Hash Join (cost=25.02..60.98 rows=33 width=20)
-> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16
Quoting Peter Eisentraut <[EMAIL PROTECTED]>:
> Luis Magaña writes:
>
> > It is possible to display error messages from PostgreSQL in other
> languages rather than English ?
>
> No
The JDBC driver does return it's own error messages in French, Dutch and
Italian if the VM is in one of those lo
In article <3a952d04$0$36043$[EMAIL PROTECTED]>,
Joel Quinet <[EMAIL PROTECTED]> wrote:
>Hi all,
>
>I try to use Postgres 7.0.3 on SCO Unixware 7.1.1. It compiles fine, but I
>have the following error message when a launch psql:
>psql: No pg_hba.conf entry for localhost, user postgres, database p
Hi all.
This my code snapshot:
CREATE FUNCTION CreateObject(varchar(600)) RETURNS int4 AS '
DECLARE
. . .
ObjectSeqName text;
BEGIN
. . ..
ObjectSeqName := ''ObjectLog'' || ObjectID || ''_Seq'';
CREATE SEQUENCE ObjectSeqName start 1 increment 1 maxvalue 2147483647
minvalu
On 22 Feb 2001, at 12:49, Jeff MacDonald wrote:
> I think CURSORS would be the correct way to do it..
>
> On Tue, 20 Feb 2001, Richard Ehrlich wrote:
>
> > I can post info to PostgreSQL from a webform via JSP, and I can post
> > reports from PostgreSQL to a webpage. Can anyone tell me how I m
Alfred Perlstein wrote:
> As a general safety precaution I would close a connection after a
> timeout or N uses.
My application is running on the same host as PostgreSQL, so connection
timeouts should be rare (I guess this would only happen if a backend died).
Re-opening the connection after N us
* Shaw Terwilliger <[EMAIL PROTECTED]> [010222 15:49] wrote:
> Alfred Perlstein wrote:
> > As a general safety precaution I would close a connection after a
> > timeout or N uses.
>
> My application is running on the same host as PostgreSQL, so connection
> timeouts should be rare (I guess this w
> I'm currently working a project that is intended to handle Japanese
> character sets - and now I'm told ideally iMode too. :) The iMode isn't
> such an issue at the moment - but the article below has spooked me a
> little. At an early point in the project we tested if putting some input
> in
I'm getting this when access the cgi:
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:
Here's the cgi code:
int main()
{
printf("Content-Type: %s\n\n", contentType);
conn = PQconnectdb("dbname=template1");
if (PQstat
hello,
I finished installing pg but have two question.
1.In the install doc it makes reference to a section called "Regression
Test". I can't seem to
find this. So, I have done this test yet.
When I try : > createdb testdb
I get the following error; pg_encoding_to_char.
I didn't see any error
On Thu, Feb 22, 2001 at 07:52:54PM -0500, Jeff wrote:
> I'm getting this when access the cgi:
What HTTP daemon are you using?
> The specified CGI application misbehaved by not returning a complete set of
> HTTP headers. The headers it did return are:
Which headers did it return? You seem to hav
Hi,
Our old(7.0.2) postgres base directory is, say /user3/local/pgsql
and new(7.0.3) postgres base directory is /usr/local/pgsql.
As the doc suggested I tried to backup the whole data(7.0.2), but
it was unsuccessful. Since the normal restoration is almost over, I was
thinking about the other po
Is there a Postgresql function reference somewhere? I can't find it in
the documentation and I'm not getting far without it.
--
Bruce
Christopher Sawtell wrote:
>
[ ... High number iof questions to the list, although of good level ...
]
> This is a universal problem. It is that once a particular package reaches
> that critical mass it is completely impossible for a small team of
> developers to both help the user community _an
Hi folks,
Here's what I have:
create table contact (
contact_id serial,
...
primary key (contact_id)
);
create table customers (
customer_id serial,
shipping_contact_id int4,
billing_contact_id int4,
...
primary key (customer_id)
);
Well,
Can anybody show any reason why the code using a prepared statement with a
where clause using a date won't find any records on PostgreSQL but WILL work
using Access and the jdbc-odbc bridge?
ie.
SQL: select
OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDate,ShipVia,Fre
ight,ShipNam
hmm.. actually the problem i encountered didn't require me to try the impossible below!
-leon
Leon Sol Levy <[EMAIL PROTECTED]> wrote:
: hi. i was wondering how to go about creating an assertion to be used within a
: pl/sql function.
: do i put
:
: create assertion
: check ...
:
: before
doh, from my last post,
the table had 13000+ rows
-chris humphries
Hi
Wayne Ward wrote:
> hello,
> I finished installing pg but have two question.
> 1.In the install doc it makes reference to a section called "Regression
> Test". I can't seem to
> find this. So, I have done this test yet.
>
/src/test/regress.
Best
begin:vcard
n:Vasudevan;Thyagarajan
tel;
On Fri, 16 Feb 2001, Tom Lane wrote:
> <[EMAIL PROTECTED]> writes:
> > In psql, gethostbyname() is defined as taking a text parameter and return an
> > inet type value or reference.
>
> Huh? There's no such function in the standard Postgres distribution.
If you do a '\df' at prompt, you will b
hello all,
first off, some information:
=
=
the table:
Table "facts"
Attribute | Type | Modifier
-+--+--
keyword | varchar(80) |
description | varchar(255) |
url | varchar(255) |
the sql:
select keyword from fac
Hi when i run postmaster i got the following error and
postmaser doesn't start,
FATAL 1: InitProcGlobal: IpcSemaphoreCreate failed
IpcSemaphoreCreate: semget failed (No space left on device) key=014,
num=16, permission=600
This type of error i
Hello
I have to do some programming in C or C++ and PostgreSQL.
Having not ever done this before, I opened the documentation (in my machine,
/usr/local/pgsql/doc) and read about the options I had. SPI, libpq, libpq++ and ecpg.
I don't want, if possible, an embeded language, or anything that requ
hi!
could somebody tell me where is the problem?
i have postgres 7.0.3-4 comming with unstable debian distribution (locales 2.2.1-1,
libc6 2.2.1-1)
i am unable to force postgres to sort in correct order when I have national characters
(polish)
I tried differents locales settings (i thik that L
Using a DateTime value in a WHERE clause is not a good idea for the reason
that DateTimes are usually represented by a floating point value in the
database itself. And since floating point numbers are prone to rounding
errors, they don't make for a good unique identifier.
If you have to use dates
On Sat, Feb 17, 2001 at 10:12:27AM +0100, Emmanuel Charpentier wrote:
> A good "knowledge base" for PostgreSQL was the mailing list archive.
> However, it started having serious problems abck in november, and I
> haven't checked it since.
They're also archived on GeoCrawler:
http://www.geocr
Tressens Lionel <[EMAIL PROTECTED]> writes:
> Le 20.02.01 à 13:18, "Tom Lane" écrivait :
> )Tressens Lionel <[EMAIL PROTECTED]> writes:
> )> My pgsql DBMS works great except that when I want to dump a database,
> )> pg_dump says that database template1 doesn't exist (actually it does !)
> )> and t
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> sorry. my fault. i was wrong because the files were not installed in working
> directory. strange. error in makefile's?
No, an extremely deliberate change, which was discussed at length in the
mailing lists. The default install now installs
On Thu, Feb 22, 2001 at 07:49:56PM -0800, Ian Lance Taylor wrote:
> Aristide Aragon <[EMAIL PROTECTED]> writes:
>
> > I have to do some programming in C or C++ and PostgreSQL.
> SPI is only for stored procedures which are dynamically linked into
> the Postgres backend.
>
> Ordinary code doesn't
Aristide Aragon <[EMAIL PROTECTED]> writes:
> I have to do some programming in C or C++ and PostgreSQL.
> Having not ever done this before, I opened the documentation (in my machine,
>/usr/local/pgsql/doc) and read about the options I had. SPI, libpq, libpq++ and ecpg.
>I don't want, if possibl
Aristide Aragon <[EMAIL PROTECTED]> writes:
> On Thu, Feb 22, 2001 at 07:49:56PM -0800, Ian Lance Taylor wrote:
> > Aristide Aragon <[EMAIL PROTECTED]> writes:
> >
> > > I have to do some programming in C or C++ and PostgreSQL.
> > SPI is only for stored procedures which are dynamically linked i
On Sun, 18 Feb 2001, Chris Humphries wrote:
> Table "facts"
> Attribute | Type | Modifier
> -+--+--
> keyword | varchar(80) |
> description | varchar(255) |
> url | varchar(255) |
>
> select keyword from facts as f1
> where 1
Renaud Tthonnart <[EMAIL PROTECTED]> writes:
> Nested Loop (cost=0.00..56.67 rows=3 width=20)
> -> Seq Scan on observation o (cost=0.00..30.00 rows=1 width=4)
> -> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16)
Do a VACUUM ANALYZE, for starters. These results look like
I wanted to update everyone on upcoming PostgreSQL events.
First, the O'Reilly Conference is scheduled for July 23-27, 2001 and
will have two days of PostgreSQL presentations. I will announce titles
and speakers as soon as the list is finalized.
(http://conferences.oreilly.com/oscon2001/)
F
54 matches
Mail list logo
