I'm just getting started with postgresql and things are going pretty well. However, I
seem to be having trouble connecting to my database via TCP/IP. I'm assuming that
my problems are related to the message I get at startup (using "postmaster -D data -
i"). The postmaster starts but produces th
On Mon, 2004-06-07 at 16:19, Bill Moran wrote:
> "John Liu" <[EMAIL PROTECTED]> wrote:
>
> > We upgraded from 7.2 to 7.4, it looks like everything working, but when I
> > issue a query such as select * from tab (tab has about 2-3 million records),
> > it causes core dump. I tuned some the paramete
On Mon, 2004-06-07 at 15:57, John Liu wrote:
> We upgraded from 7.2 to 7.4, it looks like everything working, but
> when I issue a query such as select * from tab (tab has about 2-3
> million records), it causes core dump. I tuned some the parameters, it
> still produce the core.
How odd. Anythin
On Mon, 2004-06-07 at 15:29, Dennis Gearon wrote:
> please CC me, I am on digest
> -
> I have the following code from an application that is 'mysql_centric'. I
> want to make it generic across all databases, if it's possible,
> especially postgres :-)
>
> mysql ve
"John Liu" <[EMAIL PROTECTED]> wrote:
> We upgraded from 7.2 to 7.4, it looks like everything working, but when I
> issue a query such as select * from tab (tab has about 2-3 million records),
> it causes core dump. I tuned some the parameters, it still produce the core.
It's unlikely that any co
On Mon, Jun 07, 2004 at 02:29:33PM -0700, Dennis Gearon wrote:
> I have the following code from an application that is 'mysql_centric'. I
> want to make it generic across all databases, if it's possible,
> especially postgres :-)
>
> mysql version:
>INSERT INTO calendar_setting SET setting=
On 7-6-2004 23:29, Dennis Gearon wrote:
please CC me, I am on digest
-
I have the following code from an application that is 'mysql_centric'. I
want to make it generic across all databases, if it's possible,
especially postgres :-)
mysql version:
INSERT INTO ca
We upgraded from 7.2 to 7.4, it looks like
everything working, but when I issue a query such as select * from tab (tab has
about 2-3 million records), it causes core dump. I tuned some the parameters,
it still produce the core.
Thanks for any hints.
johnl
please CC me, I am on digest
-
I have the following code from an application that is 'mysql_centric'. I
want to make it generic across all databases, if it's possible,
especially postgres :-)
mysql version:
INSERT INTO calendar_setting SET setting='colorEvent',
On Mon, 2004-06-07 at 12:11, Alexander S. wrote:
> There is bug in 7.4.2, concerning unicode and russian letters. For db
> in unicode russian data doesn`t order in alphabetical order (rows group
> with the same first letter but not in alphabetical order).
> SELECT "person" from my_table ORDER BY
>>In article <[EMAIL PROTECTED]>, Felix Finch <[EMAIL PROTECTED]> writes:
> I have a perl test program ... and began getting this complaint
> from psql:
> Can't drop schemas: Illegal seek
Ahhh yesss... otherwise known as the subroutine not returning any
specific value and the caller expecti
Bruno Wolff III wrote:
On Fri, Jun 04, 2004 at 14:11:19 +,
Bricklen <[EMAIL PROTECTED]> wrote:
Hi, I'm not sure if this is the correct group for this question, but
I'll post it hoping that it is.
I'm loading several ~15 million row files into a table using the COPY
command. Apparently one o
There is bug in 7.4.2, concerning unicode and russian letters. For db
in unicode russian data doesn`t order in alphabetical order (rows group
with the same first letter but not in alphabetical order).
SELECT "person" from my_table ORDER BY "person";
Rows group in such order (approximately): Ð-Ð-
Gaetano Mendola <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> If you access a table more frequently then other and you have enough
> RAM your OS will mantain that table on RAM, don't you think ?
> BTW if you trust on your UPS I'm sure you are able to create a RAM
> disk and pla
We have a database
that sets a column called MOD_BY = CURRENT_USER to almost all tables
on INSERT and UPDATE.
But now that the
application is n-tier, and uses connection pools, the current_user no
longer reflects the 'application user'.
Is there any way to
temporarily alter 'current_us
Stephan Szabo wrote:
On Thu, 3 Jun 2004, Jeff Boes wrote:
(asked last week on .questions, no response)
Can anyone explain why this happens? (under 7.4.1)
select '2004-05-27 09:00:00.51-04' :: timestamp(0) ;
timestamp
-
2004-05-27 09:00:01
select '20
Prabu Subroto <[EMAIL PROTECTED]> wrote:
> Dear my friends...
>
> Usually I use MySQL. Now I have to migrate my database
> from MySQL to Postgres.
>
> I have created a database successfully with "creatdb"
> and a user account successfully.
>
> But I can not access the postgres with pgaccess.
>
At 04:39 PM 6/7/2004 +0200, Jernej Kos wrote:
I have a query which orders data like this: ORDER BY a.col1, b.col2 where a
and b are different tables. Both tables are really big and so, ordering takes
quite a while. Now i would like to create an index to speed things up, but i
don't know how to crea
Well you might want to make sure the servlet only does one pg_dump at a
time to a particular file in a secured directory (making sure you don't
have any funny symlink problems) and all that sort of boring security,
reliability and predictability stuff. Don't forget the UI. The dump could
take a
Use tsearch2, tsearch is marked as obsolet :)
More serious: apply attached patch, recompile and reinstall contrib/tsearch
module. Patch commited to 7.3,7.4 and 7.5 branches, it fix asymetrical lexeme
processing for text and query.
Rajesh Kumar Mallah wrote:
Hi,
I think when search terms have ".
Dear my friends...
Usually I use MySQL. Now I have to migrate my database
from MySQL to Postgres.
I have created a database successfully with "creatdb"
and a user account successfully.
But I can not access the postgres with pgaccess.
I found this error message :
"
Error trying to connect to dat
Why
not use CURRENT_USER?
-Original Message-From: BARTKO Zoltan
[mailto:[EMAIL PROTECTED]Sent: Friday, June 04, 2004 10:34
PMTo: [EMAIL PROTECTED]Subject: [GENERAL] How
to find out who is calling the function
Dear friends,
I had a look at www.pgsql.ru, looking for ho
Maarten Boekhold <[EMAIL PROTECTED]> writes:
> The original poster seemed not to care too much about whether the data
> in this database is persistent. Under that assumption, I wonder if it's
> possible to do the following:
> 1- start postmaster
> 2 - create database on RAM disk (will be easy on
Kari Lavikka <[EMAIL PROTECTED]> writes:
> I noticed the problem while trying to use pg_dump:
>[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/pg_dump -Ugalleria galleria
>pg_dump: missing pg_database entry for database "galleria"
Hm. The row must still be there, else you could not have got tha
Easiest thing to do is to call pgsql from your servlet, have it dump the
file somewhere in your web apps directory, and then either send the link
to that file to the client or automatically forward the client there.
Option 2 would be to use JDBC to view the meta data of the table and use
it to wr
Hi,
The original poster seemed not to care too much about whether the data
in this database is persistent. Under that assumption, I wonder if it's
possible to do the following:
1- start postmaster
2 - create database on RAM disk (will be easy once tablespaces are there)
3 - work with this databa
Hi,
I'm having some problems with pg_database -system table. It lost all of
it's contents while database was running. It's actually still running but
I don't know what to do because I'm not sure if it will start up at all
after shutdown.
I noticed the problem while trying to use pg_dump:
[EMAI
I have a query which orders data like this: ORDER BY a.col1, b.col2 where a
and b are different tables. Both tables are really big and so, ordering takes
quite a while. Now i would like to create an index to speed things up, but i
don't know how to create such an index that would cover both colu
Hi Shridhar,
thank you for your reply. It is really a good idea. I'll think it over.
Many thanks,
-- Csaba
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Shridhar
> Daithankar
> Sent: 2004. június 7. 13:59
> To: [EMAIL PROTECTED]
> Cc: '[EMAIL PROTE
29 matches
Mail list logo
