--- Tom Lane <[EMAIL PROTECTED]> wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > No there is not. I actually suggest, considering your ancient
> version of
> > RedHat that you install from source.
>
> Better yet, install a more modern Red Hat release ;-)
>
> AS2.1 is very far into th
hi all,
below I have created two tables in pgsql with field name as 'name' and 'id' as their datatype 'varchar(15)' and 'integer'.
One of the table is:->
chemical=> select * from test1;
name | id
---+
akhil | 1
b | 2
c | 3
d | 4
e | 5
f | 6
(6 rows)
Anot
"Eric B. Ridge" <[EMAIL PROTECTED]> writes:
> On Mar 25, 2006, at 12:24 AM, Tom Lane wrote:
>> This is the sort of detail that you really should not omit.
> I'm now curious if complex rules can influence the planner in
> negative ways.
It's possible. I'm not certain that that is really what yo
On Mar 25, 2006, at 12:24 AM, Tom Lane wrote:
This is the sort of detail that you really should not omit.
Yeah, it didn't even occur to me until I ran the "explain execute foo
(42)" thing you suggested. We've been using these update rules for
so long that I just think of the views as regul
"Eric B. Ridge" <[EMAIL PROTECTED]> writes:
> I should have mentioned that while the UPDATE statement in the
> trigger function really is as simple as the above, "some_other_table"
> is actually a view with the requisite ON UPDATE DO INSTEAD rule:
This is the sort of detail that you really shoul
On Mar 24, 2006, at 11:39 PM, Tom Lane wrote:
The issue is probably that the planner is seeing a parameterized
query. Try this:
prepare foo(int8) as update some_other_table SET field = 'value'
WHERE id = $1;
explain execute foo(42);
I should have mentioned that while the UPDATE statement
"Eric B. Ridge" <[EMAIL PROTECTED]> writes:
> When is the UPDATE statement inside foo() planned? When the trigger
> is first created, or when it's first used per backend, or every time
> it's used per backend?
First use per backend, ignoring corner cases such as replacing the
function definit
I've found a few performance issues with an internal database
application and I'm sure it's related to my misunderstanding of how
and when queries are planned when used in a plpgsql function. This
is against Postgres 7.4.
For example, suppose this function is defined as a per-statement
u
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> /usr/bin/chcon: can't apply partial context to unlabeled file testtablespace
> /usr/bin/chcon: can't apply partial context to unlabeled file results
> The Makefile has
> [ -x /usr/bin/chcon ] && /usr/bin/chcon -t postgresql_db_t testtablespace
> result
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> No there is not. I actually suggest, considering your ancient version of
> RedHat that you install from source.
Better yet, install a more modern Red Hat release ;-)
AS2.1 is very far into the "legacy" part of its support cycle. You
shouldn't even
Hi Devrim,
is there any article or annoucement about abandon support on REEL2.1
which I can refer to?
Please send me the instructions to build RPMs on RHEL 2.1.
Anyway, is there any potential problem to install unofficial downloaded
PostgreSQL?
No there is not. I actually suggest, considerin
--- Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Fri, 2006-03-24 at 07:52 -0800, Leon Pu wrote:
>
> > I found the newest PostgreSQL binary download on Redhat Advance
> Server
> > 2.1 is version 7.4.7.
> >
> >
>
http://www.postgresql.org/ftp/binary/OLD/v7.4.7/rpms/redhat/rhel-es-2.1/
>
ok,
I fixed it using the dd command and the pg_dump is not complaining anymore,
but can I trust in my database now?
Thanks in advance!
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Reimer" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, March 24, 2006 1:11 PM
Subject: Re: [G
FYI,
Postgres 8.0.7
OS Centos 4.2 (Final)
Rebuilt and installed the rpms.
To test, I copied /usr/lib/pgsql/test/regress/
to my home directory. However,
gmake check
always produces
/usr/bin/chcon: can't apply partial context to unlabeled file
testtablespace
/usr/bin/chcon: can't apply par
sí Usted lata uso el BETWEEN predicate en PostgreSQL. Si usted está no
recogiendo el resultados usted esperar , explicar por qué usted creer así. Allí
está no conocido funcionalismo problemas con BETWEEN.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROT
"Just Someone" <[EMAIL PROTECTED]> writes:
> Actually, most table are VERY small. On each schema I would expect 4 -
> 5 tables to go over 1000 records. The rest will be much smaller, with
> most at under 100. And aside from 2-3 tables, the activity will be
> pretty low (few records a day at the mos
Hi Jim,
Actually, most table are VERY small. On each schema I would expect 4 -
5 tables to go over 1000 records. The rest will be much smaller, with
most at under 100. And aside from 2-3 tables, the activity will be
pretty low (few records a day at the most extreme).
Can I use this to optimize th
Necesito saber si alguien sabe si puedo utilizar la instruccion between
en un selet en postgress ya que lo he
probado y no me devuelve nada.
ejemplo:
SELECT * FROM NOMBRES WHERE APELLIDO BETWEEN 'R' AND 'RO';
Gracias.
---(end of broadcast)---
T
On Fri, 2006-24-03 at 14:53 -0600, Scott Marlowe wrote:
...snip...
> Only my most recent personal experience, when I was explaining to the
> guy from MySQL how frustrating it was that installing MySQL broke my
> build of PHP and meant I had to use the mysqli libs, not the mysql
> ones. The answer
Publisher Whil Hentzen has been publishing
Visual FoxPro books for many years. Whil mentors developers who want to
move from Windows to open-source platforms. He has published several books
to help users and administrators transition to Linux. Whil has also fought
with Microsoft about developers r
<[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes:
> what? The check constraint should have prevented that insert, shouldn't it?
No, because a check constraint is only designed to check values within a
row. It's applied to the proposed row before insertion.
> I do not know whether this is a bug or n
Hello everybody,
I have a problema...I am making a program using ECPG. I would like to know the number of register I update, the sentence that I am writing is:
EXEC SQL UPDATE TABLE1 SET STATUS = :t_status WHERE STATUS = :t_status_pendiente;
On Thu, 2006-03-23 at 20:18, LJJGIS wrote:
> Connect to postgres with
>
> c:\>psql.exe -h localhost -p 5432 postgres "postgres"
>
> And then
>postgres=# create database mydb
>
> Then I try to connect to "mydb" with
>
> C:\> psql mydb
> After try many password, include postgres password
hi
i am considering to port an important web applications to postgres,
this applications is made of php and i reuse the same code for many
customer, due to have a clean structure and simple updates...
now i have one code and many databases in mysql...
i know that with postgres i can inheridt som
I've been working with a time travel table as discussed in "Developing
Time-Oriented Database Applications in SQL" by Richard Snodgrass.
I attempted to build a constraint for a table that disallowed
overlapping time itervals as follows:
test=# create table test_dates (from_date date, to_date date
I've compared Debug log between correct and wrong activity:
Good activity:
2006-03-24 16:30:36 2632Debug String written: select * from
getvideodata(2::int4, 1::int4, '2006-03-24 16:30:31.40'::timestamp,
1::int4) AS (idvideodate timestamp, mediabinary bytea).
2006-03-24 16:30:36 26
Hello,
Someitmes ExectueReader doesn't return rows, if I repeat the method it
does!!
I've got code like that:
using (NpgsqlDataReader readFrames =
command.ExecuteReader())
{
if (!readFrames.HasRows)
{
System.Diagnostics.D
Connect to postgres with
c:\>psql.exe -h localhost -p 5432 postgres "postgres"
And then
postgres=# create database mydb
Then I try to connect to "mydb" with
C:\> psql mydb
After try many password, include postgres password and OS user password
report ** psql: FATAL: password authentica
Just Someone wrote:
>
> Initialized the data with: pgbench -i -s 100
> Test runs: pgbench -s 100 -t 1 -c 20
> I did 20 runs, removed the first 3 runs from each sample to account
> for stabilization.
Did you re-initialize the test pgbench database between runs?
I get weird results otherwise si
On Fri, 2006-03-24 at 13:55, Jim C. Nasby wrote:
> On Fri, Mar 24, 2006 at 10:32:42AM -0600, Scott Marlowe wrote:
> > > > http://bugs.mysql.com/bug.php?id=13301
> > > >
> > >
> > > from the response:
> > >
> > > > Years ago, to help porting applications from other database brands to
> > > > M
Seloua Seloua wrote:
> I am writting a simple C++ program to access my postgresql 8.0
> database. What is the difference from using the interface of libpq
> versus the pqxx librairy (use of PGconn, PGresult provided in the
> /usr/include/libpq-fe.h file versus connection, result etc provided
> in t
On Fri, Mar 24, 2006 at 12:13:24PM -0600, Julie Robinson wrote:
> OK. The following how to do this in SQL. How does this convert into HQL?
>
> select distinct on (qualitycontrolrange) qualitycontrolrange, date, id
> from quality_control_reset
> order by qualitycontrolrange, date desc;
That won'
On Fri, Mar 24, 2006 at 10:32:42AM -0600, Scott Marlowe wrote:
> > > http://bugs.mysql.com/bug.php?id=13301
> > >
> >
> > from the response:
> >
> > > Years ago, to help porting applications from other database brands to
> > > MySQL, MySQL was made to accept the syntax even though no real
> >
> -Original Message-
> From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
> Sent: 24 March 2006 12:28
> To: Dave Page
> Cc: David Fetter; Oisin Glynn; pgsql general; PostgreSQL Docs
> Subject: Re: [GENERAL] COPY command documentation
>
> But now that stuff gets 'lost' with ever new major ver
On Fri, Mar 24, 2006 at 11:15:56AM -0800, Just Someone wrote:
> Hi Jim,
>
> On 3/24/06, Jim Nasby <[EMAIL PROTECTED]> wrote:
> > You want max_fsm_relations to be greater than select count(*) from pg_class
> > where
> > relkind in ('i','t') *across all databases*. And you want max_fsm_pages to
>
Hi Jim,
On 3/24/06, Jim Nasby <[EMAIL PROTECTED]> wrote:
> You want max_fsm_relations to be greater than select count(*) from pg_class
> where
> relkind in ('i','t') *across all databases*. And you want max_fsm_pages to be
> bigger than
> that. That's the only way you can be assured that you'll
"Magnus Naeslund(f)" <[EMAIL PROTECTED]> writes:
> It might seem that I'm selling ext3 or something :) but it's the linux
> filesystem I know best.
> If you want ext3 to perform with large directories, there is an mkfs
> option that enables directory hashing that you can try: -O dir_index.
You ca
Chris wrote:
Steve Crawford wrote:
We have a dedicated PostgreSQL server but a variety of client machines
ranging from soon to be retired SCO 5.0.x to SuSE 10.
What is the recommended method to build/install/deploy only the
client-side libraries and utilities (psql, pg_dump, etc.) and not the
Hello all,
I am writting a simple C++ program to access my postgresql 8.0 database.
What is the difference from using the interface of libpq versus the pqxx
librairy (use of PGconn, PGresult provided in the /usr/include/libpq-fe.h
file versus connection, result etc provided in the /usr/include
Well, that's awesome. Thanks!
On Fri, 24 Mar 2006, Ian Harding wrote:
On 3/24/06, Ben <[EMAIL PROTECTED]> wrote:
My understanding is that a stored procedure does an implicit begin/commit when
it executes. Maybe my brain isn't working so well this morning, because I can't
figure out how I would
On 3/24/06, Ben <[EMAIL PROTECTED]> wrote:
> My understanding is that a stored procedure does an implicit begin/commit when
> it executes. Maybe my brain isn't working so well this morning, because I
> can't
> figure out how I would do:
>
> begin;
> call stored proc;
> call another stored proc;
>
OK. The following how to do this in SQL. How does this convert into HQL?
select distinct on (qualitycontrolrange) qualitycontrolrange, date, id
from quality_control_reset
order by qualitycontrolrange, date desc;
Julie Robinson wrote:
Given the two classes at the bottom of this email, I'm h
Mary Adel wrote:
I am trying to set PgAdmin so that i can connect from my pc to the
server but i have error saying :
Error connecting to the server: could not connect to server:
Connection refused
Is the server running on host "xxx.xxx.xxx.xxx" and accepting
TCP/IP connections on port 5432?
am 24.03.2006, um 19:13:56 + mailte Mary Adel folgendes:
> Is the server running on host "xxx.xxx.xxx.xxx" and accepting
> TCP/IP connections on port 5432?
>
> how i can solve this
> can anyone help??
You have a good error-message ;-)
My guess: you should check your pg_hab.conf.
http://ww
Hi Jim,
> Just make sure you increase max_fsm_relations, and that max_fsm_pages is
> at least > max_fsm_relations, because each relation must get at least
> one page.
I increased it to 4 relations, should I go even higher?
--
Family management on rails: http://www.famundo.com - coming soon!
My understanding is that a stored procedure does an implicit begin/commit when
it executes. Maybe my brain isn't working so well this morning, because I can't
figure out how I would do:
begin;
call stored proc;
call another stored proc;
commit;
It seems that the transaction would be committed
On Friday 24 March 2006 11:13 am, Mary Adel wrote:
> I am trying to set PgAdmin so that i can connect from my pc to the
> server but i have error saying :
>
> Error connecting to the server: could not connect to server:
> Connection refused
> Is the server running on host "xxx.xxx.xxx.xxx" and acc
I am trying to set PgAdmin so that i can connect from my pc to the
server but i have error saying :
Error connecting to the server: could not connect to server:
Connection refused
Is the server running on host "xxx.xxx.xxx.xxx" and accepting
TCP/IP connections on port 5432?
how i can solve this
Given the two classes at the bottom of this email, I'm having trouble
coming up with a Hibernate query statement that returns a list
representing all rows in the quality_control_reset table where there is
only one row for the most recent quality_control_range. Help?
Example:
In table quality
On Fri, 2006-03-24 at 02:51, Gábor Farkas wrote:
> Scott Marlowe wrote:
> > On Thu, 2006-03-23 at 12:17, Jim Nasby wrote:
> >> On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
> >>> Now, I shouldn't be able to insert anything in b that's not
> >>> referencing
> >>> an entry in a. and I used in
"Reimer" <[EMAIL PROTECTED]> writes:
> pg_dump: ERROR: could not access status of transaction 1768711534
> DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0696": =
> Arquivo ou dire
> t=F3rio n=E3o encontrado
> How is the best way to fix? pg_resetxlog?
resetxlog won't help: you've go
Hi,
On Fri, 2006-03-24 at 07:52 -0800, Leon Pu wrote:
> I found the newest PostgreSQL binary download on Redhat Advance Server
> 2.1 is version 7.4.7.
>
> http://www.postgresql.org/ftp/binary/OLD/v7.4.7/rpms/redhat/rhel-es-2.1/
>
> But I want to install newer PostgreSQL in Redhat Advance Server
Hi all,
I found the newest PostgreSQL binary download on Redhat Advance Server
2.1 is version 7.4.7.
http://www.postgresql.org/ftp/binary/OLD/v7.4.7/rpms/redhat/rhel-es-2.1/
But I want to install newer PostgreSQL in Redhat Advance Server 2.1, at
least version 8.0.4.
Any possibility to install 8
Tom,
On Fri, 2006-03-17 at 23:48 -0500, Tom Lane wrote:
> "Brandon Keepers" <[EMAIL PROTECTED]> writes:
> > If it makes a difference, when I un-tar the dump file from each failed
> > dump, it always has 2937 files in it.
>
> That's pretty consistent with the idea that you're running out of
> lock
> I discovered in the process of attempting to install Oracle 10g express
> edition that it is an extraordinary memory hog. One might have thought
> that one might have something that might have lower system requirements
> than the full version. However, this is not the case.
>
> The installation
This doesn't sound like your problem, but I'll explain the
normalization issue using Korean as an example, since that seems to be
your data: There are codepoints in Unicode both for Hangul and Jamo,
so a Hangul glyph can be represented either with the single
corresponding codepoint, or as two
problem is that my string -- which is in utf-8 -- because
all input is converted first in php with
$str_out = mb_convert_encoding($str_in, "UTF-8");
and the query, which
is like
"select wordid from korean_english where word='utf8string'";
and it is returning wordids for words which are no
On Fri, Mar 24, 2006 at 10:51:25AM -0300, Reimer wrote:
> I forgot to mention postgreSQL version: 7.4.6
Had you been running the latest 7.4 release, this probably wouldn't have
happened. There's been a number of data-loss bugs fixed since 7.4.6.
> Thanks!
> - Original Message -
> Fro
i have a problem matching a utf8 string with a field in a database
encoded in utf8.
You seem to give all the details of your configuration, but unless I
misread your message, you don't say what the actual problem is. Can
you provide more details? What exactly doesn't work?
This may not be
I forgot to mention postgreSQL version:
7.4.6
Thanks!
- Original Message -
From:
Reimer
To: pgsql-general@postgresql.org
Sent: Friday, March 24, 2006 10:41
AM
Subject: [GENERAL] URGENT! could not
access status of transaction
Hello,
We had some
d
Hello,
We had some
disk problems here and now pg_dump is complaining with:
pg_dump: ERROR: could not access status of
transaction 1768711534DETAIL: could not open file
"/usr/local/pgsql/data/pg_clog/0696": Arquivo ou diretório não
encontradopg_dump: SQL command to dump the contents of
maybe a routine question here ... i hope i can understand the
answer.
[EMAIL PROTECTED] ~]$ pg_ctl --version
pg_ctl (PostgreSQL) 8.0.0beta3
[EMAIL PROTECTED] ~]$
i have a problem matching a utf8 string with a field in a database
encoded in utf8.
i read the documentation, checked the followi
On Fri, Mar 24, 2006 at 02:33:39AM -0800, Just Someone wrote:
> Hi,
>
> I am creating a hosted solution that I want to base on separation by
> schemas. So that each hosted family we will have, will have a schema
> assigned to it (and a user). On login I will set the search path, and
> so each fami
On Fri, Mar 24, 2006 at 01:44:19AM -0500, Tom Lane wrote:
> > Or I could fire off all the queries simultaneously and hope
> > they stay in close-enough lockstep through a single pass
> > through the table to be able to share most of the IO.
>
> I have not tried this sort of thing, but right offhan
On Fri, Mar 24, 2006 at 08:58:55AM +, Dave Page wrote:
> On 23/3/06 20:12, "David Fetter" <[EMAIL PROTECTED]> wrote:
>
> > On Thu, Mar 23, 2006 at 07:00:13PM +0100, Jim Nasby wrote:
> >> On Mar 23, 2006, at 4:08 PM, Oisin Glynn wrote:
> >>
> >>> I just discovered that the comments from 8.0 ha
On Thu, Mar 23, 2006 at 12:24:18PM -0600, Scott Marlowe wrote:
> On Thu, 2006-03-23 at 12:17, Jim Nasby wrote:
> > On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
> > > Now, I shouldn't be able to insert anything in b that's not
> > > referencing
> > > an entry in a. and I used innodb tables.
On 3/24/06, Just Someone <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am creating a hosted solution that I want to base on separation by
> schemas. So that each hosted family we will have, will have a schema
> assigned to it (and a user). On login I will set the search path, and
> so each family will see
Hi,
I am creating a hosted solution that I want to base on separation by
schemas. So that each hosted family we will have, will have a schema
assigned to it (and a user). On login I will set the search path, and
so each family will see it's tables. This is all tested and works
fine.
But I would l
Hello:
My database table consists of a column of large object and i can only
use lo_export to export 1 large object file each time, as my
application is required to retrieve all the large object files from the
table, is there any way to retrieve all the large object files
quickly?? Any similar com
Hi Magnus,
> It might seem that I'm selling ext3 or something :) but it's the linux
> filesystem I know best.
> If you want ext3 to perform with large directories, there is an mkfs
> option that enables directory hashing that you can try: -O dir_index.
Not at all (sell ext3 ;-) ). It's great to g
On 23/3/06 20:12, "David Fetter" <[EMAIL PROTECTED]> wrote:
> On Thu, Mar 23, 2006 at 07:00:13PM +0100, Jim Nasby wrote:
>> On Mar 23, 2006, at 4:08 PM, Oisin Glynn wrote:
>>
>>> I just discovered that the comments from 8.0 had the answer I was
>>> looking for but these comments are not in the
Scott Marlowe wrote:
On Thu, 2006-03-23 at 12:17, Jim Nasby wrote:
On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
Now, I shouldn't be able to insert anything in b that's not
referencing
an entry in a. and I used innodb tables. and I used ansi SQL, and I
got no errors. So how come my da
72 matches
Mail list logo