Hello,
In my function i had defined addnewuser(integer,character,..), and i call
this function by Java code.
I had created function with integer datatype but database always gives me error,
org.postgresql.util.PSQLException: ERROR: function addnewuser(bigint,character
varying,) does
Hi,
I have a few queries on the use of the geqo.
1. Since the value of geqo_threshold is12, does the geqo get automatically
activated for queries with 12 or more joins?
2. Can the geqo threshold be set to a smaller value like 4 or 5?
3. How do we come to know whether the geqo has been used to
On Wednesday 15 July 2009 23:02:47 Abraham, Danny wrote:
> Actually the command is:initdb --encoding=LATIN1.
>
> It fails on Windos. fails on Windows
>
> The same command worked fine on PG 8.2.4.
>
> Now, using 8.3.7, the command succeeds only with encoding 1252.
> It comments something on wron
On Thursday 16 July 2009 09:03:09 Steve Choi wrote:
> Hello. Thank you for your int
> If I queryed on PostgreSQL, SELECT Item_ID FROM Engine,
>
> I want to export the result to Single XML file. How can I make it? Have a
> nice day. Thank you for your answer. :)
http://www.postgresql.org/docs/curre
Thanks. I guess my question is then, how should I configure
Windows to have the right locale so that I can create a LATIN1 encoding cluster.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-genera
Peter Eisentraut schrieb:
On Thursday 16 July 2009 02:12:05 ANdreas Wenk wrote:
Hi,
I recognized in psql using the internal help (\?) that the *+* sign is
missing for the shortcut \du:
# \du
List of roles
Role name | Attributes | Member of
--+--+--
Arndt Lehmann schrieb:
On Jul 16, 8:05 am, t...@sss.pgh.pa.us (Tom Lane) wrote:
CG writes:
While transitioning from 8.1 to 8.4, I need to transition to the internal UUID
type in place of the contrib/uniqueidentifier module. I've built the database
around uniqueidentifier, so nearly every tab
Hi,
for need of our application we need to get list of tables, that are
used within given SELECT query - we need them in order to track
changes of the data, that may be returned by the query - it is some
kind of caching mechanism, that checks db data modifications. Right
now we create a temporary v
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello
We have a C function that works without problems when we use it with
postgresql 8.3 (32/64bit) and with postgreSQL 8.4 (32bit).
But with 8.4 in a 64bit server, postgresql generates this error when we
try to install the function:
ERROR: incomp
Raji Sridar wrote:
> We use a typical counter within a transaction to generate
> order sequence number and update the next sequence number.
> This is a simple next counter - nothing fancy about it. When
> multiple clients are concurrently accessing this table and
> updating it, under extermely
Hello,
I have an old PostgreSQL Database which was created with encoding =
SQL_ASCII. That is an old sin of mine; 9years ago I did not know better.
Now I know better than to use SQL_ASCII.
On the bright side: I am totally sure that the TEXT within that database is
in WIN1252 / CP1252 encoding.
On Thursday 16 July 2009 10:53:37 Massa, Harald Armin wrote:
> Hello,
>
> I have an old PostgreSQL Database which was created with encoding =
> SQL_ASCII. That is an old sin of mine; 9years ago I did not know better.
>
> Now I know better than to use SQL_ASCII.
>
> On the bright side: I am totally
SERIALIZABLE isolation level doesn't really conform to the spec
because it doesn't deal with phantoms. The only case I've come across
where this actually matters is when you're implementing some sort of
"insert into table if not yet present" operation. This will typically
result in a unique const
On Thursday 16 July 2009 09:02:53 Ms swati chande wrote:
> 1. Since the value of geqo_threshold is12, does the geqo get automatically
> activated for queries with 12 or more joins?
No, not directly. It will get used for 12 joins with no predefined order.
This is a bit complicated by the fact th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello
We are playing around with different statistics provided by postgresql
to get a better overview of our systems.
Until postgresql 8.2, and the presence of
'stats_reset_on_server_start=on' + pg_postmaster_start_time(), we could
calculate very eas
May be a simple way would be to use a "SEQUENCE" database object. And
call nextval('your_sequence') to obtain the next unique value (of type
bigint).
According to PG docs
"http://www.postgresql.org/docs/8.4/interactive/functions-sequence.html";,
the sequence object has functions that "provide simpl
On Jul 16, 5:46 pm, a.w...@netzmeister-st-pauli.de (Andreas Wenk)
wrote:
> Arndt Lehmann schrieb:
>
> > On Jul 16, 8:05 am, t...@sss.pgh.pa.us (Tom Lane) wrote:
> >> CG writes:
> >>> While transitioning from 8.1 to 8.4, I need to transition to the internal
> >>> UUID type in place of the contrib/
On Thursday 16 July 2009 12:14:48 Rafael Martinez wrote:
> ERROR: incompatible library "/usr/local/lib/pg_uname_8.4.so": magic
> block mismatch
> DETAIL: Server has FLOAT8PASSBYVAL = true, library has false.
You need to recompile your module.
--
Sent via pgsql-general mailing list (pgsql-gener
2009/7/16 dipesh mistry (Imap) :
> Hello,
>
> In my function i had defined addnewuser(integer,character,..), and i
> call this function by Java code.
>
> I had created function with integer datatype but database always gives me
> error,
> org.postgresql.util.PSQLException: ERROR: function
> add
hi,
http://archives.postgresql.org/pgsql-general/2009-03/msg00581.php
This was my suggestion about introducing a statment to get a sample of SQL
statements. Nobody answered yet. Why not? i think my suggestion would help a
lot. Or was it kind of stupid?
kind regards
Janning
--
Sent via pgsql
On Thursday 16 July 2009 02:12:05 ANdreas Wenk wrote:
> Hi,
>
> I recognized in psql using the internal help (\?) that the *+* sign is
> missing for the shortcut \du:
>
> # \du
>List of roles
>Role name | Attributes | Member of
> --+--+---
>
>
"Raji Sridar (raji)" wrote:
>
> We use a typical counter within a transaction to generate order sequence
> number and update the next sequence number. This is a simple next counter -
> nothing fancy about it. When multiple clients are concurrently accessing
> this table and updating it, unde
Hello
you need analyze execution plan - parser does know nothing about table order.
look on EXPLAIN statement
regards
Pavel Stehule
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Eisentraut wrote:
> On Thursday 16 July 2009 12:14:48 Rafael Martinez wrote:
>> ERROR: incompatible library "/usr/local/lib/pg_uname_8.4.so": magic
>> block mismatch
>> DETAIL: Server has FLOAT8PASSBYVAL = true, library has false.
>
> You need
Pavel Stehule schrieb:
2009/7/16 dipesh mistry (Imap) :
Hello,
In my function i had defined addnewuser(integer,character,..), and i
call this function by Java code.
I had created function with integer datatype but database always gives me
error,
org.postgresql.util.PSQLException: ERROR: fu
2009/7/16 Andreas Wenk :
> Pavel Stehule schrieb:
>>
>> 2009/7/16 dipesh mistry (Imap) :
>>>
>>> Hello,
>>>
>>> In my function i had defined addnewuser(integer,character,..), and i
>>> call this function by Java code.
>>>
>>> I had created function with integer datatype but database always give
Pavel Stehule schrieb:
2009/7/16 Andreas Wenk :
Pavel Stehule schrieb:
2009/7/16 dipesh mistry (Imap) :
Hello,
In my function i had defined addnewuser(integer,character,..), and i
call this function by Java code.
I had created function with integer datatype but database always gives me
e
On 7/16/09, Rafael Martinez wrote:
> Peter Eisentraut wrote:
> > On Thursday 16 July 2009 12:14:48 Rafael Martinez wrote:
> >> ERROR: incompatible library "/usr/local/lib/pg_uname_8.4.so": magic
> >> block mismatch
> >> DETAIL: Server has FLOAT8PASSBYVAL = true, library has false.
> >
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Marko Kreen wrote:
> On 7/16/09, Rafael Martinez wrote:
>> Peter Eisentraut wrote:
>> >
>> > You need to recompile your module.
>>
>> We recompile the module automatically when a new postgres cluster gets
>> installed. The module has been compiled
On 7/16/09, Rafael Martinez wrote:
> Marko Kreen wrote:
> > On 7/16/09, Rafael Martinez wrote:
> >> Peter Eisentraut wrote:
> >> >
>
> >> > You need to recompile your module.
> >>
> >> We recompile the module automatically when a new postgres cluster gets
> >> installed. The module has
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Marko Kreen wrote:
> On 7/16/09, Rafael Martinez wrote:
>> >> Any other ideas?
>> >
>> > The version you compile against is not the version you have running.
>> >
>>
>> Well, the only version I have installed on this server is 8.4.0
>
> Yes, bu
In response to Janning Vygen :
> hi,
>
> http://archives.postgresql.org/pgsql-general/2009-03/msg00581.php
>
> This was my suggestion about introducing a statment to get a sample of SQL
> statements. Nobody answered yet. Why not? i think my suggestion would help a
> lot. Or was it kind of stup
Florian Weimer wrote:
> SERIALIZABLE isolation level doesn't really conform to the spec
> because it doesn't deal with phantoms. The only case I've come across
> where this actually matters is when you're implementing some sort of
> "insert into table if not yet present" operation. This will typi
Thanks Andres, > 1. Since the value of geqo_threshold is 12, does the geqo get
automatically
> activated for queries with 12 or more joins?
No, not directly. It will get used for 12 joins with no predefined order.
This is a bit complicated by the fact that even a predefined order like:
a JOIN b
hi,
thanks for your comments on this.
On Thursday 16 July 2009 15:05:58 you wrote:
> In response to Janning Vygen :
> > hi,
> >
> > http://archives.postgresql.org/pgsql-general/2009-03/msg00581.php
> >
> > This was my suggestion about introducing a statment to get a sample of
> > SQL statements.
Please help me with this. I really need your
advice as to how to retrieve the data in my postgresql database.
I have postgresql installed in Windows XP platform five months ago. Just
yesterday my OS bugged down and saying NTDLR is missing. What I did was I
re-installed my OS. When I finished my i
No other takers on this one?
I'm wondering what exactly "direct attached storage" entails?
At PG Con I heard a lot about using only direct-attached storage, and not a SAN.
Are there numbers to back this up?
Does fibre-channel count as direct-attached storage? I'm thinking it would.
What exact
* Albe Laurenz:
>SELECT COUNT(id) INTO i2 FROM a WHERE id = i;
>IF i2 = 0 THEN
> /* This INSERT will never throw an exception if the
> transactions are truly serialized */
> INSERT INTO a (id) VALUES (i);
> RETURN TRUE;
>ELSE
> RETURN FALSE;
>END IF
I have a table usage, I would like to create a (function or procedure) called
by the trigger to increment column counter after an update.
Can someone lend me a hand with the process behind creating this
function,procedure and trigger.
Table "public.usage"
Column |
Hello, Roseller !
>
> What should I do to access my database and retrieve the important records in
> it?
Possible you should keep files in database cluster, recreate db
cluster and put your old files into newly created cluster.
--
Best regards,
Sincerely yours,
Yuriy Rusinov.
--
Sent via pgsq
Rafael Martinez wrote:
> This is the Makefile we use:
> - ---
> PG_SRC=/usr/local/src
> PG_LIB=/usr/local/lib
> SERVER_INCLUDES += -I $(shell /local/opt/pgsql-8.4/bin/pg_config
> - --includedir)
> SERVER_INCLUDES += -I $(shell /local/opt/pgsql-8.4/bin/pg_config
Hi,
Is there something built-in to Postgres that would suggest what indexes I
might add to improve performance? I created my required tables (they only
contain small amounts of test data) and the performance is great. But as the
data starts growing I'm betting that creating a few indexes will
Trying to fix a dump file ...
cat backup.sql | sed -e "s/uniqueidentifier/uuid/g" > backup_fixed.sql
... gives me a dump that won't import. It is hard digging through 30+ gigs of
text data to find where sed ate a field delimiter, so I'm going to give Tom's
idea a try. I didn't even know the ALT
On Thursday 16 July 2009 19:56:47 William Scott Jordan wrote:
> Hey all!
>
> Is there a better way to increase or decrease the value of an integer
> than doing something like:
>
> ---
> UPDATE the_table SET the_int = the_int + 1 WHERE the_id = 123 ;
> ---
>
> We seem to be getting a lot of deadlock
I need help understanding what I'm doing wrong with an insert statement.
I'm running 8.3.7 on Windows and the DB is complaining about the select
statement in my insert statement.
I'm trying to execute
DROP TABLE IF EXISTS "tblTempSpecs";
CREATE TEMP TABLE "tblTempSpecs" AS SELECT "tblSpecs"."Cart
Relyea, Mike wrote on 16.07.2009 21:40:
I need help understanding what I'm doing wrong with an insert statement.
I'm running 8.3.7 on Windows and the DB is complaining about the select
statement in my insert statement.
When using a SELECT for an INSERT the values part is not needed in fact its
Try dropping the word "VALUES".
eg.
INSERT INTO "tblSpecs" ("CartridgeTypeID", "ColorID",
"TestTypeID","ZoneID", "PaperID", "AttributeID", "Spec")
SELECT "CartridgeTypeID", "ColorID", "TestTypeID","ZoneID", "PaperID",
"AttributeID","Spec" from "tblTempSpecs";
On Thu, Jul 16, 2009 at 12:40 PM, Re
> From: bricklen [mailto:brick...@gmail.com]
> Sent: Thursday, July 16, 2009 4:05 PM
> To: Relyea, Mike
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Error in insert statement
>
> Try dropping the word "VALUES".
>
> eg.
> INSERT INTO "tblSpecs" ("CartridgeTypeID", "ColorID",
> "Te
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of
> Thomas Kellerer
> Sent: Thursday, July 16, 2009 4:05 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Error in insert statement
>
> Relyea, Mike wrote on 16.07.2009 21:40:
> > I
On Wed, 15 Jul 2009, Raji Sridar (raji) wrote:
When multiple clients are concurrently accessing this table and updating
it, under extermely heavy loads in the system (stress testing), we find
that the same order number is being generated for multiple clients.
The only clean way to generate se
On Wed, 15 Jul 2009, Scott Marlowe wrote:
About two months ago I updated one of our to servers to 5.3, and the new
kernel is 2.6.18-128.1.14.el5.
I had nothing but trouble on my one system with an Areca ARC-1210 using
the 2.6.18-92 kernel from 5.2 you said worked fine for you. The problem I
Hi Andrew,
That's a very good guess. We are in fact updating this table multiple
times within the same triggered function, which is being called on an
INSERT. Essentially, we're using this to keep a running total of the
number of rows being held in another table. The function we're using
c
On Thursday 16 July 2009 23:20:34 William Scott Jordan wrote:
> Hi Andrew,
>
> That's a very good guess. We are in fact updating this table multiple
> times within the same triggered function, which is being called on an
> INSERT. Essentially, we're using this to keep a running total of the
> num
Hi Andrew,
That's a very good guess. We are in fact updating this table multiple
times within the same triggered function, which is being called on an
INSERT. Essentially, we're using this to keep a running total of the
number of rows being held in another table. The function we're using
c
54 matches
Mail list logo
