salt=# vacuum full;
FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower = 12289, upper
=
1, special = 60672
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost.
Hi
I've got some tables defined as:
create table xx (
some_column references master_table
It means this column is defined by default:
NOT DEFERRABLE, INITIALLY IMMEDIATE
I tried replacing rows in this table by new ones as:
set autocommit=off;
begin;
set constraints all deferred;
delete from
Thank you for your reply.
select int4(b'1001')::bit(32); gives the same result as what you gave.
select int4(b'1001')::bit(4); gives the upper four bits, which are all
zeroes. How would I get the lower four bits? I building bitmaps using
plpgsql, and therefore, I will be doing a lot bit
On Mon, 17 Nov 2003, Tomasz Myrta wrote:
I've got some tables defined as:
create table xx (
some_column references master_table
It means this column is defined by default:
NOT DEFERRABLE, INITIALLY IMMEDIATE
I tried replacing rows in this table by new ones as:
set autocommit=off;
On Mon, 17 Nov 2003, Yasir Malik wrote:
Thank you for your reply.
select int4(b'1001')::bit(32); gives the same result as what you gave.
select int4(b'1001')::bit(4); gives the upper four bits, which are all
zeroes. How would I get the lower four bits? I building bitmaps using
plpgsql, and
Dnia 2003-11-17 16:16, Uytkownik Stephan Szabo napisa:
Hmm, I'd suggest turning on query logging to make sure pgAdmin is doing
what you expect.
Well, I've already done this. I didn't check query log, but a result by
selecting rows from modified table.
Anyway I opened a pgAdmin log and didn't
I wonder if is useless to set some indexes for columns contained in a
multifield primary key.
Suppose by example that one have a table1 with a primary key over three
field (a, b, c):
ALTER TABLE public.table1
ADD CONSTRAINT table1_pkey PRIMARY KEY(a, b, c);
are the indexes over (a) and (a,
Michele Bendazzoli writes:
ALTER TABLE public.table1
ADD CONSTRAINT table1_pkey PRIMARY KEY(a, b, c);
are the indexes over (a) and (a, b) redundant (and so useless)?
Exactly.
p.s. I know, I'll have to begin to use the explain command ...
I promise I'll do it ;-)
You could also have
Dnia 2003-11-17 18:00, Uytkownik Michele Bendazzoli napisa:
p.s. I know, I'll have to begin to use the explain command ...
I promise I'll do it ;-)
Use the explain analyze command and then answer yourself ;-)
Regards,
Tomasz Myrta
---(end of
Suppose by example that one have a table1 with a primary key over three
field (a, b, c):
..
are the indexes over (a) and (a, b) redundant (and so useless)?
Yes, they are redundant not not necessarily useless.
In short, an index with 3 keys will be larger than an index with 1 key,
as such
On Mon, 2003-11-17 at 17:15, Tomasz Myrta wrote:
Dnia 2003-11-17 18:00, Uytkownik Michele Bendazzoli napisa:
p.s. I know, I'll have to begin to use the explain command ...
I promise I'll do it ;-)
Use the explain analyze command and then answer yourself ;-)
I'm not in still in production
On Mon, 2003-11-17 at 17:14, Peter Eisentraut wrote:
Michele Bendazzoli writes:
ALTER TABLE public.table1
ADD CONSTRAINT table1_pkey PRIMARY KEY(a, b, c);
are the indexes over (a) and (a, b) redundant (and so useless)?
Exactly.
p.s. I know, I'll have to begin to use the explain
Hi all
I'm trying to optimise some sql inserts I have by using the COPY command
instead. I'm connecting from Java using 7.4 beta 3. It works at the command
line, but I can't get it to work from Java.
Here's the pg log output.
LOG: query: COPY bingo_cards (account_id, game_id, win_ball,
On Tue, 11 Nov 2003 18:49:31 -0500, Chester Kustarz wrote:
[... discussion of top-n query (where n=3) ...]
select *
from person
where age =
(select age from person order by age limit 1 offset 2);
It fails when the cardinality of person is less than 3 (returns empty
set). My solution is
cristi wrote:
salt=# vacuum full;
FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower = 12289,
upper =
1, special = 60672
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the
On Mon, 2003-11-17 at 17:23, Rod Taylor wrote:
Suppose by example that one have a table1 with a primary key over three
field (a, b, c):
..
are the indexes over (a) and (a, b) redundant (and so useless)?
Yes, they are redundant not not necessarily useless.
In short, an index with 3
Hi ,
I have a plpgsql function (MainFunc) that intends
to reuse a a particular block of code. So, I intend to make that particulat
block of code into another function. (say, HelperFunc)
My question is
1. Can I declare a function (HelperFunc) inside the
main function (MainFunc)
2. If yes
Majhi, Akas writes:
1. Can I declare a function (HelperFunc) inside the main function (MainFunc)
2. If yes then how.
You could do it if you create the CREATE FUNCTION command in a string
variable and then use EXECUTE to run it, but the normal way would be to
declare it outside. There is
18 matches
Mail list logo