I need to store very large integers (more of 30 digits).
I found two solutions to this problem:
- using a text field
- splitting the integer into 2 parts and then storing them in a
composite type with 2 bigint fields
The definitive choice will depend on the disk space used by one solution
ins
hello,
I have a somehow related question to this topic: is it possible to know
(in postgresql) if an update on a column is absolute (set col = 3) or
relative to it's previous value (set col = col + 3)
in a trigger one have access to OLD row values and NEW row values, but
no correlation betwee
# [EMAIL PROTECTED] / 2006-02-27 16:32:55 -0400:
> On Mon, 27 Feb 2006, Roman Neuhauser wrote:
>
> ># [EMAIL PROTECTED] / 2006-02-26 19:01:58 -0400:
> >>'k, I just checked all the lists you listed, and you are subscribed to
> >>each of them ... are you not receiving messages?
(...)
> Can you tr
[EMAIL PROTECTED] writes:
> I need to store very large integers (more of 30 digits).
Er,
What's wrong with the NUMERIC type? That can go up to hundreds of
digits.
-Doug
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will igno
On 2/7/06, Martijn van Oosterhout wrote:
> On Tue, Feb 07, 2006 at 03:28:31PM +0300, Nikolay Samokhvalov wrote:
> > The real situation would be as the following.
> > I want to use some algorithm to hide real number of registered users
> > in my table user. So, I don't want to use simple sequence,
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
("[EMAIL PROTECTED]") transmitted:
> I have a somehow related question to this topic: is it possible to
> know (in postgresql) if an update on a column is absolute (set col =
> 3) or relative to it's previous value (set col =
Hello!
i tried creating indexes on columns that have datatype as
bigint or smallint , but when I performed explain analyze, the query was
using sequential scan
instead of index scanning.
Is it not possible to create indexes for attributes whose
datatypes r bigint or smallin
On Tue, Feb 28, 2006 at 07:56:14AM -0700, Chethana, Rao (IE10) wrote:
> Hello!
>
> i tried creating indexes on columns that have datatype as bigint or
> smallint , but when I performed explain analyze, the query was using
> sequential scan
>
> instead of index scanning.
>
> Is it not possib
Hello,
the following used to work:
create table t1(t1f1 text, t1f2 text, t1f3 text);
create table t2(t2f2 text, t2f3 text);
insert ...
update t1
set t1f1='test'
where t1.t1f2=t2.t2f2
and t1.t1f3=t2.t2f3;
unfortunately, now I get the error that t2 is not in the FROM clause.
I know I can d
am 28.02.2006, um 14:01:44 +0100 mailte [EMAIL PROTECTED] folgendes:
> update t1
> set t1f1='test'
> where t1.t1f2=t2.t2f2
> and t1.t1f3=t2.t2f3;
>
> unfortunately, now I get the error that t2 is not in the FROM clause.
You can set
add_missing_from
in yout postgresql.conf, but please rea
Hello,
I have an XP Pro Box, 1 Go RAM, 160 Go HD, with
PostgreSQL 8.1.3 win32.
The service pgsql-8.1 appear to be
started,
but when I try to connect with PgAdmin
III 1.4.1, it hangs and I need to terminate the program.
The pg_log gave :
2006-02-28 15:36:52 LOG: database system was
shut do
Steve Crawford wrote:
How can I dump a function definition with pg_dump?
Background: We often need to create objects that are all relevant to
only a specific project. Sometimes it is a single table. Other times
there are many tables, indexes, views, rules, triggers and functions.
All the obje
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It looks like the listserv cannot handle that address - it says:
"Individual words are not allowed in an e-mail address without an
intervening period or at symbol ('.' or '@')."
Perhaps you could simply use your normal email address, and filter
on
A. Kretschmer schrieb:
am 28.02.2006, um 14:01:44 +0100 mailte [EMAIL PROTECTED] folgendes:
update t1
set t1f1='test'
where t1.t1f2=t2.t2f2
and t1.t1f3=t2.t2f3;
unfortunately, now I get the error that t2 is not in the FROM clause.
You can set
add_missing_from
in yout postgresql.co
"Ets ROLLAND" <[EMAIL PROTECTED]> writes:
> 2006-02-28 15:36:52 WARNING: corrupted pgstat.stat file
> 2006-02-28 15:36:52 LOG: corrupted pgstat.stat file
If this happened once, immediately after an update from a pre-8.1.3
version, then it's expected and you can ignore it. If it's happening
repe
# [EMAIL PROTECTED] / 2006-02-28 15:14:39 -:
> It looks like the listserv cannot handle that address - it says:
>
> "Individual words are not allowed in an e-mail address without an
> intervening period or at symbol ('.' or '@')."
Which address? I see no whitespace in any of the addresse
Here's ps output, as you can see there is a second postmaster (pid 17303)
that is a child of the original postmaster (pid 28317):
prod 28317 1 0 Feb25 ? 00:00:02
/mnt/prod/postgresql-8.1.2/bin/postmaster -i
prod 28321 28317 0 Feb25 ? 00:00:11 postgres: logger process
prod 28323 28317 0 F
"Stock, Stuart" <[EMAIL PROTECTED]> writes:
> Perhaps I'm just seeing a moment-in-time snapshot of the postmaster
> fork()'ing to handle these connections, but because they were rejected, it
> never had time to rename itself to 'postgres'?
There's definitely a short window between the fork and the
Hello list,
I'm new here, but didn't see the problem in the archives.
Basically, I have an epoll loop that executes the following code when
I receive data from postgresql (greatly simplified).
int read_sql (PGconn *conn)
{
PGnotify *notice;
PGresult *res;
if (!PQconsumeInput (conn))
On Feb 27 03:10, Michael Fuhr wrote:
> PostGIS has geometry accessors that might work. You'd need to be
> using PostGIS geometry types instead of the PostgreSQL types.
>
> http://postgis.refractions.net/docs/ch06.html
>
> Are the following examples anything like what the user in tr-general
> was
Pelle Johansson <[EMAIL PROTECTED]> writes:
> Basically, I have an epoll loop that executes the following code when
> I receive data from postgresql (greatly simplified).
> ...
> The problem is that after two iterations in the loop PQisBusy()
> returns true, making me exit to the event loop, bu
> first of all, great effort from you this tool.
>
> Problem exists with following config:
> - Windows XP Pro, SP2 (English).
> - PostgreSQL-8.1.3
> - lot of development programs, and IDE-s (for the clients i
> am working unfortunately they are windoz-based :-(...).
>
> Same problem occurs as
Hi Doug.
I considered also the numeric type. In that case if the number is of 32
digits the storage size is of 2*8 + 8 = 24 bytes.
If i store it using a composite data type of two bigints the size is 2*8
+ composite data structure overhead bytes.
If the composite data type has 4 bytes overhea
Denis Gasparin <[EMAIL PROTECTED]> writes:
> If the composite data type has 4 bytes overhead, I save 4 bytes for
> each number... that is important because I must store many many
> numbers.
Yes, if size is a big issue you might be better off with a specialized
type.
-Doug
--
On Tue, Feb 28, 2006 at 09:51:54PM +0100, Denis Gasparin wrote:
> Hi Doug.
>
> I considered also the numeric type. In that case if the number is of 32
> digits the storage size is of 2*8 + 8 = 24 bytes.
> If i store it using a composite data type of two bigints the size is 2*8
> + composite data
--- Bernhard Weisshuhn <[EMAIL PROTECTED]> wrote:
> On Mon, Feb 27, 2006 at 10:27:20AM -0800, CG <[EMAIL PROTECTED]> wrote:
>
> > [...] I'd need to see if the space required for the varchar+btree tables
> are
> > comparible, better, or worse than the ltree+gist tables with regards to
> size.
>
On Tue, Feb 28, 2006 at 03:14:39PM -, Greg Sabino Mullane wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> It looks like the listserv cannot handle that address - it says:
>
> "Individual words are not allowed in an e-mail address without an
> intervening period or at symbol
Nope, that isn't it .. the thing is, from this end, I can't see/find any
problems ... he's subscribed to the list:
%mj_shell -p who pgsql-general | grep -i sigpipe.cz
[EMAIL PROTECTED]
[EMAIL PROTECTED]
In fact, he's been registered since Jul '05:
Address: [EMAIL PROTECTED]
Ad
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> Actually, I suspect it's puking on the #'s in the email addresses.
> Nope, that isn't it .. the thing is, from this end, I can't see/find any
> problems ... he's subscribed to the list:
> %mj_shell -p who pgsql-general | grep -i sigpipe.cz
>
On Tue, Feb 28, 2006 at 07:30:58PM -0500, Tom Lane wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> >> Actually, I suspect it's puking on the #'s in the email addresses.
>
> > Nope, that isn't it .. the thing is, from this end, I can't see/find any
> > problems ... he's subscribed to the
We are suffering from the same issue that is described in this email thread http://archives.postgresql.org/pgsql-general/2005-07/msg00486.php.
I don't know if this is the appropriate place to make this request, so if not, please forgive me. However, in our particular case, we don't have enou
Hi folks, I am having some trouble with this query that should be using
FTI. There are 2 tables, one with a list of keywords and the other
containing a body of articles.
I am trying to get a query to return the IDs of each keyword with the
ID of each article that contains that keyword.
So the 2
I'm trying to understand how large objects relate to
the write-ahead log. I've read the following sections
in the 8.1 user guide:
Chapter 26 Reliability and the Write-Ahead Log
Chapter 29 Large Objects
Section 42.21 pg_lageobject
I have some naive questions
(1)When a large object is updated, ho
On Mar 1, 2006, at 6:54 , flood wrote:
Unfortunately I can not seem to get my query to use PG's full text
indexing, it keeps doing a seq scan:
EXPLAIN
SELECT t1.id, t2.id
FROM test1 t1, test2 t2
WHERE lower( t1.keyword ) ~ ( lower ( '^' || t2.article ));
It doesn't appear that you're usin
EXPLAIN
SELECT t1.id, t2.id
FROM test1 t1, test2 t2
WHERE lower( t1.keyword ) ~ ( lower ( '^' || t2.article ));
It doesn't appear that you're using tsearch2. PostgreSQL does not
include full text search in the basic installation. Have you installed
tsearch2?
Which is included in the Postgr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Roman Neuhauser replied to me:
>> I suspect that the listserv is choking on the "#" symbol. This is
>> undoubtably a bug in their software. For one thing, it should not
>> have accepted the email address as far along as it did.
> Eh? That email addr
hi all
this is akhilesh from india.i just want to ask one thing regarding grant operation??
i am using pgsql 8.0 on ubuntu 5.10 linux.
just tell me the procedure that how can i grant all permissions for a database to any of the other user???
i am using :-
:->> grant all privileges on database
Hi
all,
I posted this on the novice mailing list and as yet had no response,
hopefully someone here can help.
While we where trying to do a vacuum / pg_dump we encountered the
following error:
[EMAIL PROTECTED]:~$ pg_dumpall -d > dump.pg
pg_dump: dumpClasses(): SQL command failed
pg_dump:
On Wed, Mar 01, 2006 at 09:50:24AM +0530, AKHILESH GUPTA wrote:
> just tell me the procedure that how can i grant all permissions for a
> database to any of the other user???
> i am using :-
> :->> grant all privileges on database to ;
> GRANT
> :->> grant all ON DATABASE to ;
> GRANT
>
> and th
On Wed, Mar 01, 2006 at 04:12:53PM +1100, Noel Faux wrote:
> Now after doing some searches I managed to work out that the data
> corruption starts at 902292.137
> using this sql:
> SELECT * FROM gap WHERE ctid = '(902292,$x)'
> Where $x I changed from 1-150.
>
> as mentioned on this
> post:http:
On Tue, Feb 28, 2006 at 10:54:48PM -0700, Michael Fuhr wrote:
> Is your table really over 100G? Anyway, if the block size is 8192
> then 902292 sould be in the .6 file. If you can spare the time
> then you might run the dd and od commands that Tom Lane mentions
> in the above message and post the
Karen Ploski <[EMAIL PROTECTED]> writes:
> I'm trying to understand how large objects relate to
> the write-ahead log.
Large objects are just some data in a table. The API for them is a bit
odd, but the reliability issues are not any different from any other
transaction.
> (1)When a large object
42 matches
Mail list logo
