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
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
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 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
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:
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
-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
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
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
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
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
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
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
"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
>
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
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
--- 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 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
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
--
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
> 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
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
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
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))
"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
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
# [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
"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
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
-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
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
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
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,
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
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!
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
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 =
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,
[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
# [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
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
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
42 matches
Mail list logo
