Hello
Have the same problem but in ordinary usage,no replication or
whatsoever. Problem is when client connects to the DB,stored procedure
in its initialization check mapping between some_table_name and
corresponding OID. Once something is changed in DB,for example OID's
deleted and recreate
On Feb 19, 2008 9:38 PM, hewei <[EMAIL PROTECTED]> wrote:
> Hi,Every body;
>I have a table contains 100,000 rows, and has a primary key(int).
> Now ,I need to execute sql command like "update .. where id=*"(id
> is primary key).
> I expect execute 1200-1600 sqlcommands per second(12
On Feb 19, 2008 10:37 PM, serafin segador <[EMAIL PROTECTED]> wrote:
>
> hello list,
>
> i am a newbie in postgresql.
Why are you posting the same request twice?
> i ported a small application to postgresql 8.2 originally written to store
> data in maxdb. since stored procedures are not supporte
On Feb 19, 2008 11:39 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> > and since postgresql functions cannot return cursor to the
> > calling applications,
>
> Likewise a false statement.
Yeah, I remembered there being a section on returning cursors. I went
to the docs page and seached, and found it
hello list,
i am a newbie in postgresql.
i ported a small application to postgresql 8.2 originally written to store
data in maxdb. since stored procedures are not supported in postgresql
and since postgresql functions cannot return cursor to the calling
applications, i rewrote the maxdb
2008/2/20, Geoffrey <[EMAIL PROTECTED]>:
> We've just started seeing these errors. Research I've done seems to
> indicate that it's related to temp tables. Question is, we didn't start
> seeing these errors until we started using slony to replicate our data.
>
> The errors only showed up shortly
Postgres User wrote:
by the way, your example works fine unless it's a null value or empty string
unfortunately, postgres isn't smart enough to know that the when
p_param below is null, that the WHERE condition can be ignored
select * from table where name in (Coalesce(p_param, name))
which is
by the way, your example works fine unless it's a null value or empty string
unfortunately, postgres isn't smart enough to know that the when
p_param below is null, that the WHERE condition can be ignored
select * from table where name in (Coalesce(p_param, name))
which is the same as: select *
doh! tom, let me know if you decide to hack out a fix for this one of
these nights ;)
thanks for your help.
On Feb 19, 2008 9:45 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Postgres User" <[EMAIL PROTECTED]> writes:
> > Yes that works, but the whole point of the exercise is replace many OR
> > sta
"Postgres User" <[EMAIL PROTECTED]> writes:
> Yes that works, but the whole point of the exercise is replace many OR
> statements with 1 regex expression. So it's not what I'm looking for.
Unfortunately, Postgres is not as intelligent as you are. There is
no mechanism to rewrite a multi-branch r
im trying to allow the client to pass a varchar param into my
function, and want to avoid any parsing of the parameter inside the
function, or code to build a sql string.
if the function can use this code, it will be compiled and optimized
(unlike a dynamic sql stirng)
select * from mytable where
serafin segador <[EMAIL PROTECTED]> writes:
> i ported a small application to postgresql 8.2 originally written to store
> data in maxdb. since stored procedures are not supported in postgresql and
> since postgresql functions cannot return cursor to the calling applications,
> i rewrote the ma
Postgres User wrote:
Yes that works, but the whole point of the exercise is replace many OR
statements with 1 regex expression. So it's not what I'm looking for.
Why do you want it done this way?
You can build an array of strings to check and use an in clause.
Using php :
$checks = array('A
Yes that works, but the whole point of the exercise is replace many OR
statements with 1 regex expression. So it's not what I'm looking for.
On Feb 19, 2008 9:16 PM, Chris <[EMAIL PROTECTED]> wrote:
> Postgres User wrote:
> > Thanks, my dumb mistake.
> > I need to perform the equivalent of a WHER
Postgres User wrote:
Thanks, my dumb mistake.
I need to perform the equivalent of a WHERE clause OR expression using
regex to match exact strings.
_
this example hits the index:
select * from eod where name ~ '^BA$'
but wh
On Monday 04 February 2008 10:48, vincent wrote:
> > Christopher Browne wrote:
> >
> > Personally I'm surprised that the last couple responses seem to center
> > around not being able to make much money off of it. I agree that it
> > would require some time investment, but so did building PG in the
hello list,
i am a newbie in postgresql.
i ported a small application to postgresql 8.2 originally written to store data
in maxdb. since stored procedures are not supported in postgresql and since
postgresql functions cannot return cursor to the calling applications, i
rewrote the maxdb s
Thanks, my dumb mistake.
I need to perform the equivalent of a WHERE clause OR expression using
regex to match exact strings.
_
this example hits the index:
select * from eod where name ~ '^BA$'
but when I try to add another
On Feb 19, 2008, at 9:32 PM, Postgres User wrote:
I'm running a simple query on 8.2. With this syntax, Explain indicate
that the index is scanned:
select * from eod where name = 'AA'
However, when I change the query to use simple regex:
select * from eod where name ~ 'AA'
now Explain indicate
hewei <[EMAIL PROTECTED]> writes:
> idnumeric(5,0) NOT NULL,
Don't use NUMERIC where INTEGER would do ...
regards, tom lane
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
table:
CREATE TABLE price (
TIMESTAMP Timestamp NULL,
idnumeric(5,0) NOT NULL,
price numeric(10,3) NULL,
primary key (id)
);
sql:
update price set price=* where id=*;
On Feb 20, 2008 11:56 AM, Webb Sprague <[EMAIL PROTECTED]> wrote:
> Post the table, the query, and t
Post the table, the query, and the explain output, and then we can help you.
On Feb 19, 2008 7:38 PM, hewei <[EMAIL PROTECTED]> wrote:
> Hi,Every body;
>I have a table contains 100,000 rows, and has a primary key(int).
> Now ,I need to execute sql command like "update .. where id=*"(
Hi,Every body;
I have a table contains 100,000 rows, and has a primary key(int).
Now ,I need to execute sql command like "update .. where id=*"(id
is primary key).
I expect execute 1200-1600 sqlcommands per second(1200-1600/s).
In test,when the id increase by degrees in sqlcommands
I'm running a simple query on 8.2. With this syntax, Explain indicate
that the index is scanned:
select * from eod where name = 'AA'
However, when I change the query to use simple regex:
select * from eod where name ~ 'AA'
now Explain indicates a seq scan:
Index Scan using equity_eod_symbol_idx
We've just started seeing these errors. Research I've done seems to
indicate that it's related to temp tables. Question is, we didn't start
seeing these errors until we started using slony to replicate our data.
The errors only showed up shortly after the initial replication of the
data was
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> when i try to uninstall tsearch2 i get this error,
Hmm, maybe you originally put tsearch2 into some other schema than
"public"? If so, try setting search_path to point to that schema
before you run the uninstall script.
For that matter, are you s
hi
when i try to uninstall tsearch2 i get this error,
my postgres version is 8.2.5
how to fix this?
thanks a lot!
/usr/local/pgsql/bin/psql -U postgres -h localhost -f
/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql
BEGIN
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:8: ERROR:
Magnus Hagander wrote:
>
> On Tue, 2008-02-19 at 11:07 -0500, Tom Lane wrote:
> > Why can't ossp be used --- is it impossible to port to Windows?
>
> I haven't looked into the details - it's possible that it could be
> portable to Windows. But that would a Yet Another Dependency to be bale
> to
On Tue, 2008-02-19 at 11:07 -0500, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> >> Lack of support for Windows, which it sounds like the OP might be running?
>
> > That's something that's been on my agenda for a while. There are certainly
> > UUID generation functions available
It turned out that NT Authority\Authenticated Users and NT Authority
\Interactive had been removed from the Users group on the machine that
was getting the initdb permission error. Added these back to the
Users group and the install was successful.
---(end of broadcast)---
On Feb 19, 2008 6:33 PM, Josue Gomes <[EMAIL PROTECTED]> wrote:
> On 2/19/08, Dave Page <[EMAIL PROTECTED]> wrote:
> > On Feb 19, 2008 1:16 PM, Josue Gomes <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > I'm just wondering why lib\ms\*.lib files are not part of
> > > binaries-no-installer distribu
> > > It occurs to me that it shouldn't be terribly difficult to make an
> > > alternate version of crosstab() that returns an array rather than
> > > tuples (back when crosstab() was first written, Postgres didn't
> > > support NULL array elements). Is this worth considering for 8.4?
> >
> > How
On Tue, Feb 19, 2008 at 11:56:08AM -0300, Alvaro Herrera wrote:
> Joe Conway wrote:
> > Erik Jones wrote:
> >> See how postgres handles filling the NULLs for you? What you'd
> >> really want to do with this would be to define some functions
> >> for setting and getting a person's answers to a gi
HHB wrote:
Hi.
I have sequence for each table in my database.
In order to populate same data in the database, I created some SQL text
files.
---
insert into categories values (id value from sequence, '..', '...');
insert into books values (id value from sequence, '..', '...', '..', fk to
category
Can I have something like this in my SQL text file:
(items_seq.nextval(), '', '...')
?
Raymond O'Donnell <[EMAIL PROTECTED]> wrote: On 19/02/2008 15:43, HHB wrote:
> How to use a sequence in such text files?
You're looking for the nextval() function - look it up in the docs.
Ray.
-
Hi Everyone,
Many years ago I created a domain with a char(4) datatype.
Now in my wisdom I would like to change this to a text datatype, but I can't
see any way of altering the type of a domain.
I have experimented with backing up the database and manually editing the
dump file to change the
2008/2/19, Richard Huxton <[EMAIL PROTECTED]>:
> Markus Bertheau wrote:
> > 2008/2/19, Richard Huxton <[EMAIL PROTECTED]>:
> > I'm loading a table with some short attributes and a large toastable
> > attribute.
> > That means that for every main table heap page several toast table heap
> > pages
Magnus Hagander <[EMAIL PROTECTED]> writes:
>> Lack of support for Windows, which it sounds like the OP might be running?
> That's something that's been on my agenda for a while. There are certainly
> UUID generation functions available on Windows - at least for some of the
> cases supported by uu
HHB wrote:
Hi.
I have sequence for each table in my database.
In order to populate same data in the database, I created some SQL text
files.
---
insert into categories values (id value from sequence, '..', '...');
insert into books values (id value from sequence, '..', '...', '..', fk to
category
On 19/02/2008 15:43, HHB wrote:
How to use a sequence in such text files?
You're looking for the nextval() function - look it up in the docs.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Hi.
I have sequence for each table in my database.
In order to populate same data in the database, I created some SQL text
files.
---
insert into categories values (id value from sequence, '..', '...');
insert into books values (id value from sequence, '..', '...', '..', fk to
category id);
---
Is
django_user wrote:
How can stop postgresql from incrementing the primary key value, so
that even after many failed insert statements it get the next id val.
,,,
so wouldnt I run out of ids one day, if there are lot of failed insert
statements, lets say for every successful insert there are 50
u
On Feb 19, 2008, at 7:46 AM, [EMAIL PROTECTED] wrote:
I have tried to do partition with inheritance and rules. First, I
created master table and many child table, and also the rules for
insert, delete and update. Then I do some select, insert, delete
and update operations on the master to
Alvaro Herrera wrote:
Joe Conway wrote:
It occurs to me that it shouldn't be terribly difficult to make an
alternate version of crosstab() that returns an array rather than tuples
(back when crosstab() was first written, Postgres didn't support NULL
array elements). Is this worth considerin
Joe Conway wrote:
> Erik Jones wrote:
>> See how postgres handles filling the NULLs for you? What you'd really
>> want to do with this would be to define some functions for setting and
>> getting a person's answers to a given question or set of questions so
>> that you could implement some k
Hi,
Thank you guys.
Enrico Sirola wrote:
Il giorno 18/feb/08, alle ore 17:37, [EMAIL PROTECTED] ha scritto:
1) PostgreSQL only support partition by inheritance, and rules have to
be created for each child table, this will result *a lot of* rules if
the number of child tables is large.
Are t
On Feb 19, 2008 1:16 PM, Josue Gomes <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm just wondering why lib\ms\*.lib files are not part of
> binaries-no-installer distribution.
> Is there any specific reason they're not included there?
Everything is Microsoft-compiled now, so no need for special versions
I'm going to have to loook into it ... Dave just reported that also ... as
far as I know, everything should be still working, unless I somehow
disabled it the other day when I was in on the bayes stuff (not sure how,
its a screen I never visit) ...
Will investigate ...
On Tue, 19 Feb 2008,
Hi,
I'm just wondering why lib\ms\*.lib files are not part of
binaries-no-installer distribution.
Is there any specific reason they're not included there?
regards,
josue gomes
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, pleas
Hi,
It seems the greylisting setup stopped quarantining emails? I'm getting
a lot more spam in pgsql-hackers and the other lists I moderate, and
nothing in the headers suggest that they were greylisted at all.
Did something happen?
--
Alvaro Herrera http://www.flickr.co
Hello List membersI have just upgraded the PostgreSQL server from 8.2.4 to 8.3 on Suse 10.3 64 bit.While inspecting the log i see this errorERROR: shared buffer hash table corruptedCan anybody please help me in getting into details of it?With regardsAshish...
Unlimited freedom, unlimited s
On Mon, Feb 18, 2008 at 05:01:22PM +, Dave Page wrote:
> On Feb 18, 2008 4:52 PM, Bill Moran <[EMAIL PROTECTED]> wrote:
> > In response to "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
> >
> >
> > > Hi
> > >
> > > My porting experiment has encountered the SQL Server UniqueIdentifier
> > > problem.
Markus Bertheau wrote:
2008/2/19, Richard Huxton <[EMAIL PROTECTED]>:
I'm loading a table with some short attributes and a large toastable attribute.
That means that for every main table heap page several toast table heap pages
are written. This happens through the buffer cache and the background
On Tue, Feb 19, 2008 at 03:55:27PM +0600, Markus Bertheau wrote:
> > The "toast" pages are stored in a separate table - see manual for
> > details. There's a whole chapter (53.2) on this.
>
> Yes, but I assume that on disk the pages will be laid out sequentially
> - not intentionally so, of course
On Feb 19, 2008 8:48 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> On Mon, Feb 18, 2008 at 06:35:11PM -0300, Alvaro Herrera wrote:
> > Bruce Momjian escribió:
> > > Magnus Hagander wrote:
> >
> > > > For the case of upgrading, it wouldn't work. But there are certainly
> > > > other cases where i
On Feb 18, 1:14 pm, pgsql_user <[EMAIL PROTECTED]> wrote:
> On Feb 18, 6:08 pm, Paul Boddie <[EMAIL PROTECTED]> wrote:
>
>
>
> > On 18 Feb, 13:36, django_user <[EMAIL PROTECTED]> wrote:
>
> > > How can stop postgresql from incrementing the primary key value, so
> > > that even after many failed ins
2008/2/19, Richard Huxton <[EMAIL PROTECTED]>:
> Markus Bertheau wrote:
> > Afaics, TOAST was invented so that big attributes wouldn't be in the
> > way when working with the other attributes.
>
> Actually, I think it was designed as a way of working around PG's 8KB
> block-size. That imposed a max
Markus Bertheau wrote:
Afaics, TOAST was invented so that big attributes wouldn't be in the
way (of readahead, the buffer cache and so on) when working with the
other attributes. This is based on the assumption that the other
attributes are accessed more often than the whole contents of the big
a
On Mon, Feb 18, 2008 at 06:35:11PM -0300, Alvaro Herrera wrote:
> Bruce Momjian escribió:
> > Magnus Hagander wrote:
>
> > > For the case of upgrading, it wouldn't work. But there are certainly
> > > other cases where it would help. Say from your central pgadmin console
> > > administering 10 se
59 matches
Mail list logo
