On Tue, 18 Apr 2006, lash wrote:
Sun Java Studio Creator 2 and PostgreSQL 8.1 database
using 8.1-405 jdbc3.
But "someDataProvider.commitChanges()" works only first time.
Then the only message i get after "someDataProvider.commitChanges()" is
"can't change isolation level in the middle of tran
Hi.
Sun Java Studio Creator 2 and PostgreSQL 8.1 database
using 8.1-405 jdbc3.
Connectin,fetching,... works.
But "someDataProvider.commitChanges()" works only first time.
Then the only message i get after "someDataProvider.commitChanges()" is
"can't change isolation level in the middle of trans
Running version 8.1.2, 1-2G RAM. Configuration
set up to use available RAM. Running autovacuum.
I have a table with 850 rows. The table
gets only inserts (constantly). Once a day
a range of the rows is deleted and an explicit
vacuum analyze of the table is done.
The table has 4 indexes.
M
[EMAIL PROTECTED] wrote:
Hi,
I'm trying to write a stored procedure that can capture all the changes
to a table and record the changes based on the table's primary key.
I can almost get there but the sticking point is being able to access
the primary key field of the NEW/OLD record in the trigg
On Mon, 17 Apr 2006, surabhi.ahuja wrote:
The question is that is from this SQLException can i detect if it is a
foreign key violation,
You should check the value of SQLException.getSQLState() against this
table:
http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html
Kris Jurk
Tsearch doesn't support such scan. You can add your own operation or modify
existing, but in any case index will not support it.
I don't known efficient index structure for queries you need...
Yudie Pg wrote:
Is it possible to search partial word as *like '%...%'* in tsearch?
Yudie
--
Teod
On Sun, Apr 16, 2006 at 04:32:25PM -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > EXPLAIN ANALYZE doesn't show the slow timing
> > because it requires values, not $n placeholders,
>
> To analyze the plan used for a parameterized query, try
>
> PREPARE foo(...) AS SELECT ... $n ...
>
On 4/15/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
Actually that is the application requirment to use 21 bit numbers as porting it from Oracle where it used to work. Yeah
now i have decided to use a numeric data type in a table and use that
to write my own nextval and currval functions for that purp
On 4/17/06, Tom Lane <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] writes:> I'm trying to write a stored procedure that can capture all the changes> to a table and record the changes based on the table's primary key.
> I can almost get there but the sticking point is being able to access> the primar
On Mon, 2006-04-17 at 14:48 -0500, Yudie Pg wrote:
> Is it possible to search partial word as like '%...%' in tsearch?
Well at that point you are just going to seqscan anyway... so why not
just to a standard like search?
The could see that you might get a benefit from using the '%...%' on the
vec
Peter Eisentraut wrote:
Dave Page wrote:
It's not a error, pgAdmin III simply does not display the
word integer in it's drop down comboboxes, it uses all the
internal representation of types not the SQL standard aliases.
Which allows you to use any custom datatype or domain that you l
> -Original Message-
> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
> Sent: 17 April 2006 20:16
> To: pgsql-general@postgresql.org
> Cc: Dave Page; Tony Caduto; chris smith; Zahir Lalani
> Subject: Re: [GENERAL] the integer type
>
> Dave Page wrote:
> > > It's not a error, pgAdmin
Is it possible to search partial word as like '%...%' in tsearch?
Yudie
[EMAIL PROTECTED] writes:
> I'm trying to write a stored procedure that can capture all the changes
> to a table and record the changes based on the table's primary key.
> I can almost get there but the sticking point is being able to access
> the primary key field of the NEW/OLD record in the trig
Dave Page wrote:
> > It's not a error, pgAdmin III simply does not display the
> > word integer in it's drop down comboboxes, it uses all the
> > internal representation of types not the SQL standard aliases.
>
> Which allows you to use any custom datatype or domain that you like.
That is complete
Hi,
I'm trying to write a stored procedure that can capture all the changes
to a table and record the changes based on the table's primary key.
I can almost get there but the sticking point is being able to access
the primary key field of the NEW/OLD record in the trigger stored
procedure without
On Mon, 17 Apr 2006, Tom Lane wrote:
That last is a SQL command, not a shell command, and anyway it would
default to assuming you were trying to grant privileges on a table named
"contacts" not a database named contacts.
Tom,
I should have been clearer, that I was logged in to psql when I i
Justin Pasher <[EMAIL PROTECTED]> writes:
> A client of ours has requested that we change the time on the server to
> match their time zone (one hour ahead of us). Are there any know issues
> or gotchas to look out for when bumping the server time forward an hour?
> I couldn't imagine any issues
>When I request a list of databases (psql -l), the one named contacts is
> there. However, when I open the database (psql contacts), there's no one
> home; that is, 'psql -d' returns 'no relations found.'
>
>I need a clue on how to let user 'xrms' access the database 'contacts' so
> the i
Rich Shepard <[EMAIL PROTECTED]> writes:
> postgres (from my user account):
> createdb contacts
> createuser xrms # This creates the ROLE xrms
> grant all on contacts to xrms; # This generates an error at 'to'.
That last is a SQL command, not a shell command, and anyway it would
default to as
A client of ours has requested that we change the time on the server to
match their time zone (one hour ahead of us). Are there any know issues
or gotchas to look out for when bumping the server time forward an hour?
I couldn't imagine any issues occurring, since it's really just like the
serve
Hello All,
I want to ask is there a way to inherit table column comments. I have a
table that is base for almost all other tables in my database (they
inherit it).
So the new tables receive their fields from the base table. But if I
want to put comments on this fields I must write COMMENT for
I'm working with the XRMS Contact Management System developers to get the
application working with postgres as well as the original MySQL. My role is
trying what they've produced and reporting errors.
The application runs on a httpd server (apache-1.3.34 here) with any
browser; similar to SQL
Jan Wieck <[EMAIL PROTECTED]> writes:
> The other thing that is eating OID's are temporary objects. I personally
> consider the implementation of temp tables broken for precisely that
> matter. If your application uses temp tables, sooner or later it will
> cause an OID counter wrap around and t
On 4/13/2006 6:19 AM, John Sidney-Woollett wrote:
My tables are defined "WITHOUT OID" - does that make a difference?
That's good so far.
The other thing that is eating OID's are temporary objects. I personally
consider the implementation of temp tables broken for precisely that
matter. If y
On Mon, Apr 17, 2006 at 07:26:24AM -0700, SunWuKung wrote:
> This may be totally wronb, but what about writing a Before Insert
> trigger on the pg_catalog.pg_class table checking if there is already a
> table with that name and if yes prevent the insert?
> Is there something against doing so?
Yes,
I know that one of the main reasons why schemas are there is to make it
possible to use identical table names, but this time they want to use
it to separate tables purely because they feel they would find their
ways better that way. On the other hand I feel that this separation
will be somewhat arb
"surabhi.ahuja" <[EMAIL PROTECTED]> writes:
> the user tries to do kill -9 -1 and log in again
The *first* thing you gotta do is retrain your user. kill -9
is never the appropriate way to shut down the postmaster.
The script mods you describe seem to be oriented at forcing the
postmaster to rest
Hi,
On Mon, 2006-04-17 at 15:43 +0300, Devrim GUNDUZ wrote:
> I have a question that I could not find the answer of.
Next time I'll scroll down a bit to find my answer. Sorry for the noise.
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consult
Hi,
I am writing a tutorial (in Turkish) on partitioning and I have a
question that I could not find the answer of.
http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html
This doc suggests to write a rule in order to be sure that data is
entered to the latest partition. Also it says th
i am working with PostgreSQL 8.0.0
and the programming lang used is java
i have a stored procedure which inserts a row in a
table
to this stored procedure i pass the values which
have to be inserted in that row.
now, i execute this query(which is a call to stored
procedure)
this execut
Title: Re: [GENERAL] hard shutdown of system
hi,
yah i took this script only and built upon
that
the problem is that the
statement
"pidof
postmaster"
will return some valu even if
ps -aef | grep postmaster does not return
anything
if i do kill -9
and i do pidof postmaster,
s
It is possible that one had /r/n and the other just /n. I was doing the
comparison using psql.
The issue was not using LIKE and %.
I resolved the problem by removing chr(13) from both sides. So my
working query was had a where clause like this:
WHERE REPLACE(message, chr(13), '') = REPLACE('', c
Hi Everyone,
I have installed postgresql 8.1.3.tar.gz. After compiling and
installing the postgresql is running fine but Im not able to install
tsearch2. I went under the postgresql source directory
/usr/local/postgresql8.1.3/contrib and then did a
#gmake all
#gmake install
After issuing these com
On 2006-04-15, "Peter van der Maas" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Is it correct to assume that if a user has write permission to
> \data\global\pg_auth on a Win32 machine, the superuser's MD5 hash can be
> replaced with one of a known origin in order to own the DB?
It's worse than that.
On Saturday 15 April 2006 22:33, Benjamin Arai wrote:
> Hi,
>
> Myself and a friend are PhD students at the University of California,
> Riverside. We would be interested in such a project if it were available.
> We are both experienced developers previously interning at EA Games and
> current syst
On 4/13/06, Benjamin Smith <[EMAIL PROTECTED]> wrote:
I'm stumped on this one...I have a table defined thusly:create table items (id serial,category integer not null references category(id),name varchar not null,price real,unique(category, name));
It has a LARGE number of entries. I'd like to grab
On 4/17/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
>
> the user tries to do kill -9 -1 and log in again
>
> in the startup script i do the following
>
> /sbin/pidof -s postmaster
>
> and it still displays some value,
>
> however ps -aef | grep postmaster does not display anything
>
> is it ok if
38 matches
Mail list logo
