On Thu, Jan 11, 2001 at 20:06:33 +0100, Christian Pomar wrote:
> Using phorum (www.phorum.org) based on PHP, I am getting the following
> error when trying to insert a message in the PosgreSQL 6.5.3 database:
>
> ProcessQuery
> ERROR: Tuple is too big: size 12440
There is an 8K tuple length in
On Sun, Jan 14, 2001 at 23:27:06 +1300, Dan Langille wrote:
> I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have a
> question: At various times, it does UPDATEs. Is there a way to tell if
> the UPDATE actually affected any rows or not? I couldn't see how to get
> UPDATE to re
Konstantinos Agouros <[EMAIL PROTECTED]> writes:
> I just tried to create another database, and all I get is a
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> connection
Hi,
I just tried to create another database, and all I get is a
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
connection to server was lost
createdb: database creation failed
On 12 Jan 2001, at 10:51, hedy Xu wrote:
> We are using the postgres7 against Linux. We got a pg_dump error when tired
> to backup a database using pg_dump. The error message is PQgetvalue: ERROR!
> tuple number 0 is out of range 0..-1 Segmentation fault. We could dump this
> database when it w
[EMAIL PROTECTED] (Brad Crockett) writes:
> I'm using V6.4.2 on RedHat Mandrake 6.0,
6.4.2 is ancient history --- we've fixed a lot of subselect bugs since
then. Please update to the current release, 7.0.3. If you still see
the problem with 7.0.3, please submit a complete script to reproduce
th
Hi, all.
I'm using V6.4.2 on RedHat Mandrake 6.0, and when I run the following
query, the backend says:
pqReadData() -- backend closed the channel unexpectedly
Here is the culprit:
SELECT Sno
FROM Take
WHERE Cno = 'CS112'
AND Cno NOT IN
(SELECT Sno FROM Take
what do u mean by the datadir problem..
if pg_ctl asks for a datadir then ucan set it in /etc/profile and start
again..
Hope this helps
Anand
On Mon, Jan 08, 2001 at 03:44:34PM +0100, MUMCU, Burak wrote:
>
>Hi all,
>
>I'm using Suse Linux 7.0 and I have installed PostgreSQL. The problem is
>when
Mike Mascari <[EMAIL PROTECTED]> writes:
> Its an extension to the embedded SQL preprocessor which allows you to
> dynamically build queries at run-time, instead of compile-time.
> [...]
> you can *dynamically* build a SELECT statement, ask the database for a
> description of the result sets' at
Its an extension to the embedded SQL preprocessor which allows you to
dynamically build queries at run-time, instead of compile-time. So instead
of having to declare the variables associated with query results at
comile-time, like:
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR userid[30];
try to go to this url http://208.160.255.143 there is a odbc and a easy to
install postgresql for win32
On 11 Jan 2001, tony wrote:
> I have an windows sistem.
> 1.It's possible to install PostgreSQL on Windows?
> 2.May I use PostODBC or OpenL
On Sun, 14 Jan 2001, Peter Eisentraut wrote:
> Thomas T. Thai writes:
>
> > i've noticed that when using php scripts or the "c" cgi search.cgi from
> > mnogosearch, if i access either script from the web browser and stop it
> > with ESC in the middle of it trying to access the pgsql db, the asso
Tom Lane wrote:
>
> Richard Francis Duggan <[EMAIL PROTECTED]> writes:
> > I am trying to create a database and use the following command:
> > 'createdb '
> > However I get the following error:
> > ERROR: CREATE DATABASE: could not initialize database directory
> > createdb: database creation fa
On Sun, 14 Jan 2001, Stephan Szabo wrote:
> I believe there was discussion about these things on -hackers a while
> back. The type promotion and which type a constant is seen as is kind of
> wierd right now. The query will probably work with explicit typecast to
> numeric for the constants.
Ye
Richard Francis Duggan <[EMAIL PROTECTED]> writes:
> I am trying to create a database and use the following command:
> 'createdb '
> However I get the following error:
> ERROR: CREATE DATABASE: could not initialize database directory
> createdb: database creation failed
Hm. That
Stupid question, but what is Dynamic SQL? :)
On Sun, 14 Jan 2001, Lark wrote:
> Hi all!
> 2 questions:
> Does PostgreSQL support dynamic SQL, if so, when can i see any documents on
> it at PostgreSQL.org?
> thank's :)
>
>
>
Marc G. Fournier ICQ#7615664 IRC Nick
On Thu, 11 Jan 2001, Thomas T. Thai wrote:
> pgsql 7.1-current, mnogosearch-3.1.8, netbsd/alpha-1.5.1-current, dec
> alpha 500, 1G ram, uw-scsi
>
> i'm trying to find out why postgres is the bottle neck in my searches with
> mnogosearch. i've tried both the search.c and php version of search and
On Sun, 14 Jan 2001, Brett W. McCoy wrote:
> Why isn't there a >= or <= operator defined for floating point datatypes?
>
> As an example:
>
> bmccoy=> select * from account where balance between 20.00 and 99.00;
> ERROR: Unable to identify an operator '>=' for types 'numeric' and 'float8'
>
On Wed, Jan 10, 2001 at 12:17:23PM -, Ryan Mahoney wrote:
> I'm actaully trying to get 7.1b to start automatically, still no success,
> but I'm making progres.
>
> Trying to modify the pg_ctl that comes with 7.1 to add the su - postgres -c
I added the following to the postgres account's .pro
On Thu, Jan 11, 2001 at 12:13:34AM +0200,
Martin Lillepuu <[EMAIL PROTECTED]> wrote:
> William Staniewicz wrote:
> >
> > Is there any way to convert an Excel file (".xls")
> > to a delimited file? Maybe using sed?
>
> search for xls2csv on freshmeat. it works for simpler excel files but
> tend
Title: Documentation
Could you please send any information on Postgresql for optimizing queries. I have tables of 1million plus rows and would like to know some optimizing techniques.
Thanks
Harold P. Brock
Medical Informatics
248-593-3804
On Tue, 9 Jan 2001, Bruce Momjian wrote:
> I think the issue here was that these functions don't make any sense for
> PHP because you can't register C functions.
I mean (I know) that you can register some common (internal) PHP
function and this function can call your PHP function. It is some u
> Bruce Momjian writes:
>
> > I believe debug adds some addition checks in the code, and that is why
> > he is seeing slowness with debug. It was not the -g flag he used but
> > --enable-debug. I just looked at configure.in, and saw the
> > --enable-debug enables assert checking.
>
> I don't t
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> BTW, it appears to me that configure won't even add the -g unless it
>> thinks the compiler is gcc ... ie, --enable-debug is a no-op on non-gcc
>> compilers. Peter, isn't that a bug?
> In case you're referring to
> if test "$ena
Tom Lane writes:
> BTW, it appears to me that configure won't even add the -g unless it
> thinks the compiler is gcc ... ie, --enable-debug is a no-op on non-gcc
> compilers. Peter, isn't that a bug?
In case you're referring to
if test "$enable_debug" = yes && test "$ac_cv_prog_cc_g" = yes; th
Bruce Momjian writes:
> I believe debug adds some addition checks in the code, and that is why
> he is seeing slowness with debug. It was not the -g flag he used but
> --enable-debug. I just looked at configure.in, and saw the
> --enable-debug enables assert checking.
I don't think so.
--
Pe
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> The effect in terms of query execution speed is probably minimal. The
> >> problem is that the executables get about 15% larger, which can lead to
> >> longer load times, more memory usage, and ultimately to some speed issues.
>
> > Not sure about
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> The effect in terms of query execution speed is probably minimal. The
>> problem is that the executables get about 15% larger, which can lead to
>> longer load times, more memory usage, and ultimately to some speed issues.
> Not sure about the longer
"Thomas T. Thai" <[EMAIL PROTECTED]> writes:
> figure out so i check my ./configure flags. and there it was
> --enable-debug. after sending my email to the list, i recompiled w/o debug
> and now i can get my results back from a query in less than 2
> seconds. before it was 59 secs if it returned a
> i'm running mnogosearch along with pgsql-current. and performance have
> been just terrible to get results back on a resonable time. i couldn't
> figure out so i check my ./configure flags. and there it was
> --enable-debug. after sending my email to the list, i recompiled w/o debug
> and now i
> Thomas T. Thai writes:
>
> > what kind of performance hit would i endure if i compiled with
> > --enable-debug on -current
>
> The effect in terms of query execution speed is probably minimal. The
> problem is that the executables get about 15% larger, which can lead to
> longer load times, m
On Sun, 14 Jan 2001, Peter Eisentraut wrote:
> Thomas T. Thai writes:
>
> > what kind of performance hit would i endure if i compiled with
> > --enable-debug on -current
>
> The effect in terms of query execution speed is probably minimal. The
> problem is that the executables get about 15% la
Fred Yankowski <[EMAIL PROTECTED]> writes:
> In PostgreSQL 7.0.3 (on NT), the expression
> to_char(date '2001-04-01', 'dd')
> evaluates to '31', which is a bit surprising.
It's just a bug: date to timestamp conversion did the wrong thing on
DST forward transition days in 7.0.3 and before.
>> $ Waiting for postmaster to start up...FATAL 2: database was initialized
>> with CATALOG_VERSION_NO
>> 200012280,
>> but the backend was compiled with CATALOG_VERSION_NO 200101061.
>> looks like you need to initdb.
>> do i have to follow the upgrade procedures?
> Yes
If you're trying to sto
In PostgreSQL 7.0.3 (on NT), the expression
to_char(date '2001-04-01', 'dd')
evaluates to '31', which is a bit surprising. But
to_char(timestamp '2001-04-01', 'dd')
evaluates to '01' as I would expect. Doing a bit of RTFM, it looks
like the various "Date/Time Functions" actua
Hello all,
Is it at all possible to create a table on the fly from a CSV file?
I'm going to ask the obvious, but . . .
Can you ping the Unix box from the ER workstation?
Did you start the postmaster with -i to allow remote connections?
Does the same ODBC DSN work from another program? (i.e. linking a Pg table
to an Access DB)
--rob
- Original Message -
From:
Konstantinos Agouros wrote:
>
>Hi,
>
>my sql has gotten a little rusty, here's what I want to do:
>I have two tables both contain urls. How what I want are all the entries in
>table b where there is no matching url in table a. I do remember doing somet
>hing
>like this with a
"Muhammad Rusydi" wrote:
>i want to update some of my field on table...
>
>sem period
>
> 3 2000/2001
> and i want it will be updated automatically to be.
>
>sem period
>---
Thomas T. Thai writes:
> what kind of performance hit would i endure if i compiled with
> --enable-debug on -current
The effect in terms of query execution speed is probably minimal. The
problem is that the executables get about 15% larger, which can lead to
longer load times, more memory usage
Hi,
my sql has gotten a little rusty, here's what I want to do:
I have two tables both contain urls. How what I want are all the entries in
table b where there is no matching url in table a. I do remember doing something
like this with a
select url from table1 where a.url not in select url from
Thomas T. Thai writes:
> $ Waiting for postmaster to start up...FATAL 2: database was initialized
> with CATALOG_VERSION_NO
> 200012280,
> but the backend was compiled with CATALOG_VERSION_NO 200101061.
> looks like you need to initdb.
> do i have to follow the upgrade procedur
I'm writing a procedure and I want to check the number of rows updated.
But I can't figure out how. I know UPDATE returns "UPDATE #" but I
don't know how to use that to get what I need.
Here's an example:
CREATE FUNCTION "test" () RETURNS int AS ' DECLARE
v_number_of_rows int;
43 matches
Mail list logo
