Using 8.3
I have a table which has a column (tdr_tags) defined as integer[][]. The
table description shows the column as integer[]. I understand from the
docs that this is normal ("declaring number of dimensions or sizes in
CREATE TABLE is simply documentation").
If I select the column as td
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
If I select the column as tdr_tags I get:
{{161377},{32}}
{{206507},{39}}
{{232972,292831},{45,51}}
...
But, wanting just the 2nd inner array, if I try tdr_tags[2] I get NULL.
If you want a sub-array you need to use the slice no
Michael Fuhr wrote:
On Thu, Mar 27, 2008 at 06:00:57PM -0400, Colin Wetherbee wrote:
brian wrote:
I'd like to add a table, state_neighbours, which joins each state with all
of its neighbour states. Does anyone know where I can find such a list?
I'm not interested in "nearest n
Teemu Juntunen, e-ngine wrote:
Hi Tomasz,
with receipt rows I can't see any other option with key as running number.
First I tried to use serial, but it didn't start from zero again when the
foreign key (receipt number) changes. It just continues the serial despite
of the foreign key.
Then I
x asasaxax wrote:
Hi,
I have the following tablecreate table product(cod serial, user_cod
bigint, constraint product_fk Foreign Key(user_cod) references user(cod),
constraint product_pk Primary Key(cod, user_cod));
What i want to happend is that:
user_codcod
1
Ivan Sergio Borgonovo wrote:
I'm still investigating on how to return array elements.
I came out with something like:
create or replace function auz(out _errcode int, out _errmsg text)
returns setof record as $$
declare
errcode int[];
errmsg text[];
_row record;
begin
William Temperley wrote:
Hi All
I hope this isn't a FAQ, but does anyone have any suggestions as to
how to make a query that selects using:
"where in()"
secure from an sql injection point of view?
I have grid of tiles I'm using to reference geographical points.
These tiles are identical to the
Colin Fox wrote:
Hello everyone.
There were a number of people asking about ERD tools here a while ago,
so I decided to publish one that I've put together.
It's called Autograph, and you can find it on the pg foundry:
http://pgfoundry.org/projects/autograph/
Cool! Nice to have a new option
Colin Fox wrote:
brian wrote:
From the example page:
"I also wanted to make sure that there were "no dead crows" -- having
the crows-feet right side up makes the diagram a lot more readable in
my humble opinion."
Um ... those arrows look backwards to me :-(
Actually, cro
Andrus wrote:
I have table
create Document ( docdate date, docorder integer )
I need update docorder column with numbers 1,2 in docdate date order
Something like
i = 1;
UPDATE Document SET docorder = i++
ORDER BY docdate;
How to do this is PostgreSQL 8.2 ?
ALTER TABLE DROP COLUMN docord
Vance Maverick wrote:
I want to create a table with the semantics of a log. There may be
multiple concurrent writers, because log entries will be generated by
triggers. And there will be multiple concurrent readers -- mostly
remote processes watching the log over time. I'd like to guarantee th
Craig Ringer wrote:
brian wrote:
Use a timestamp column also.
That's subject to the same issues, because a transaction's
current_timestamp() is determined at transaction start. So, in a
situation like this:
WRITER 1WRITER 2
Scott Marlowe wrote:
On Wed, Apr 23, 2008 at 12:10 PM, Karsten Hilbert
<[EMAIL PROTECTED]> wrote:
On Wed, Apr 23, 2008 at 12:38:48PM +0200, Andreas 'ads' Scherbaum wrote:
> Yes. You should/can use ENUM for something like 'gender':
> male, female, unknown. You don't need to add other values ev
Jerry McRae wrote:
I am having a problem with the simplest of Python functions, so I must be
doing something wrong. After hours of searching and trying many options, I
need the key that my puny brain is missing here.
I cannot pass parameters to a plpythonu function. I have tried within psql
an
id) aid, pid, nmol
FROM foobar
WHERE pid IS NOT NULL
ORDER BY pid ASC, nmol DESC;
The pid ASC satisfies the requirement for the DISTINCT ON part, while
the nmol DESC ensures we get the MAX from each group. Or something like
that.
brian
--
Sent via pgsql-general mailing list (pgsql-general@postgres
Bayless Kirtley wrote:
I had to move my database to a new disk. I dropped the original after
a pg_dump and then removed the old directory. I then ran initdb on
the new location, created the database and restored from the pg_dump.
My problem now is that I have to supply the full pathnames to sta
Fernando Moreno wrote:
Hello, I'm new to this mailing list, and I have a couple of questions:
Is it really necessary to add the [GENERAL] prefix?
The prefix is added by the mailing list software. It's there so that
people subscribed to multiple pgsql-* lists can easily distinguish them.
Ther
[EMAIL PROTECTED] wrote:
Hi
I want to store dates / events for example birthdays (or may 5th) that
repeats every year..
what is the best way to do in postgres?
if i use timestamp it is going to be use the current year.. how do i do
this?
A timestamp includes the year so there shouldn't be any
Scott Marlowe wrote:
On Thu, Oct 16, 2008 at 10:06 PM, Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Thu, 16 Oct 2008, Scott Marlowe wrote:
On Thu, Oct 16, 2008 at 10:01 PM, Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Fri, 17 Oct 2008, Tim Uckun wrote:
Is there a way to change this behavior s
Brian714 wrote:
Hello everyone,
I am new to the forum and fairly new to databases (particularly PostgreSQL).
I have done some searching on the internet and can't really get a hold of an
answer to my question. So here it goes:
I am working on a Customer Purchasing-based project where I must use
Eduardo Arévalo wrote:
Hola Lista:
instale el postgres con el comando
./postgresql-8.3.4-1-linux-x64.bin
instale la el postgres en /usr/local/...
la base en /base/data
como yo uso caracteres en español como los acentos y la ñ Ñ le puse
es_ES.utf8 código 231
todo bien hasta que cree una base de
Greg Smith wrote:
Let's say you're using logging_collector and you've put some %-escapes
into log_filename for daily log rotation. Perhaps it's daily rotation
with this pattern:
log_filename = 'postgresql-%Y-%m-%d.log'
Is there any good way to ask the server what log file name it's
currentl
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Try:
COPY imagineoptions FROM E'C:\\Options20081112.csv' ...
or:
COPY imagineoptions FROM 'C:/Options20081112.csv' ...
Kevin Duffy wrote:
Hello All:
I am attempting to import data from a CSV file.
The command I am
The file must be on the server. IIRC, with COPY FROM (as opposed to COPY
TO) the path can be relative to the server process dir but it's probably
a good idea to always use an absolute path.
If you wish to copy from the client machine you can use \copy within psql.
b
Kevin Duffy wrote:
Hello:
Yes, this one got me, also. Strangely, you need to do:
select iterate('{1,2}');
Also, you have a typo in your function: arry_upper(a,1)
b
hendra kusuma wrote:
Hi,
I'm new here
I've been doing a little self-learning about postgresql
and find it very interesting
I've been trying to create a
novice wrote:
2008/11/20 Adam Rich <[EMAIL PROTECTED]>:
select call.call_id,
call.datetime,
mobile_custodian.user_id,
call.mobile_no
call.charge
from call, mobile_custodian
where call.mobile_no = mobile_custodian.mobile_no
and call.datetime between mobile_custodian.issue_date
and mob
novice wrote:
2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>:
On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
sorry I get nothing :(
Of course not. None of the dates you gave in the example overlap.
But it should still have the 1st entry with the name Ben? Am
David wrote:
I am unable to solve the following problem.
When I start or stop PostgreSQL using pg_ctl (without the -D option) the
system works fine. No errors. I have the PGDATA environment variable
set and it points to my cluster.
When I run the /etc/init.d/postgresql-8.2 script with either o
Tom Lane wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
>>
I am finding the email traffic
almost impossible to continue tracking, so something different is
happening, but it seems it is not volume-related.
Yes, my perception also is that it's getting harder and harder to keep
up with the li
dicating that the tokens are
unknown, rather than lexemes indicating a match. Is this expected behavior or a
bug, and is there any way to control this? Before I try to patch this in the
code I'd like to know if it's intentional behavior or not.
It gets even screwier if you add &qu
upe_filenames=# insert into projects (project_id, username )
dupe_filenames-# values (2, 'bar');
INSERT 0 1
>
...
dupe_filenames=# insert into projects (project_id, username )
dupe_filenames-# values (1, 'foo');
ERROR: duplicate key violates unique constraint "project
[EMAIL PROTECTED] wrote:
Hi all,
I want to call one of the two functions above many times (in an
aggregate function) and it says in the manual pages that substr is the
same as substring.
Does this mean that substr calls substring internally?? Or is it the
other way around?? Or are they ind
Can anybody spot the problem with this function? Or, how i'm calling it?
(it's not clear to me which it is)
CREATE TABLE member (
...
first_name character varying(64),
last_name character varying(64),
organisation character varying(128),
email character varying(128),
...
);
CREATE OR R
A. Kretschmer wrote:
am Thu, dem 05.10.2006, um 13:17:41 -0400 mailte brian folgendes:
Can anybody spot the problem with this function? Or, how i'm
calling it? (it's not clear to me which it is)
CREATE TABLE member ( ... first_name character varying(64),
last_name character
Tom Lane wrote:
Rafal Pietrak <[EMAIL PROTECTED]> writes:
Is this the expected result?
timestamp_date() currently returns NULL if the timestamp is infinity.
Since we don't have any representation for infinity in the date type,
this is pretty much its only alternative other than throwing an e
log_statement;
log_statement
---
mod
(1 row)
brian
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Bruce Momjian wrote:
brian wrote:
I changed my postgresql.conf to have:
log_statement = mod
It appears to be working, though not logging *all* INSERTs. For
instance, I have a PHP class that inserts into two tables in a
transaction. The log shows the first, but not the second. Has anyone
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
Sorry--i hadn't had time to run a test. Setting it to 'all' works fine,
and i think i see the problem: the second INSERT is in a prepared
statement, so it's not being logged.
PREPARE mdb2_statement_pgsql00fb05c2c
d set log_statement to either "mod"
or "all" (restart postgres afterwards).
brian
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Joost Kraaijeveld wrote:
Is it possible to find out the parameters used with initdb on an old
database or is this a matter of deduction?
TIA
pg_controldata - display control information of a PostgreSQL database
cluster
pg_controldata [ datadir ]
brian
---(end of
Joost Kraaijeveld wrote:
On Mon, 2006-10-23 at 02:11 -0400, brian wrote:
pg_controldata - display control information of a PostgreSQL database
cluster
pg_controldata [ datadir ]
I was hoping for the actual command but this suggests deduction ;-)
That is it.
given:
PG_DIR=/usr/local
ent upon the user. Is
this the case? And can any of those columns used in the proc be NULL?
Frankly, i couldn't read it very well (but then, i'm on my first cup of
coffee this morning), but i'm wondering if the problem lies somewhere in
between the dollar-quoting and coal
id, and b) are outside the
bounds set in the script (eg. MAX_GRACE_PERIOD = 30).
brian
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
e.
Thanks for any help.
Kind Regards.
EXIT WHEN NOT FOUND
brian
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
o run
# pg_ctl reload
for your change to take effect.
brian
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
hey are not in
conflict, who knows!
Is there anything else running at that time? What does /etc/crontab
have? I ask because my fedora box has cron.daily scripts run at 4:02am
by default.
brian
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ing specifics required in order that the tab character is recognised?
Is this fine as is?
UPDATE member SET bio = replace(bio, '\t', '');
brian
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an ap
but
had no luck.
Thanks,
Use "RETURNS SETOF record" and "FOR r IN ... LOOP RETURN NEXT; END LOOP;
RETURN;"
brian
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
wheel wrote:
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
wheel wrote:
Can a pgsql 8.1 database be restored from the raw file? For one database
I have only the files found in the base folder, example C:\PostgreSQL
\data\base\16404, there are many files called 1247, 1248, etc (n
t specify anything for
logging? If so, it's likely to have something like
PGLOG="$PGDATA/postgres.log".
brian
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
you create the user successfully with createuser?
Have you read the docs thoroughly?
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
brian
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
_table_pk ON child_table (id);
Do those last two for each child table and then make sure that you
perform your INSERTs on the child table(s).
brian
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
t think of a seventh possibility.
As has been pointed out, some governments forbid the collection of
gender information, so the seventh would be unknown/unreported.
brian
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will i
get 'service_provider_id_pkey').
There's a second table that has a foreign key constraint on
service_id_pkey, so do i need to drop that constraint first, rename the
first table, then re-create the constraint using the new pkey name?
brian
---(end of broad
Tim Tassonis wrote:
Hi Andreas
First, you should use referential integrity:
I do, that is not the point. It was a simplified data model. Of course I
have primary keys and stuff, but they don't affect join behaviour at all.
test=# create table person(id int primary key, name text);
NOTIC
ok
(1 row)
INSERT 294266 1
set_id
ok
(1 row)
DROP TABLE
CREATE TABLE
DROP TABLE
CREATE TABLE
VACUUM
-- snip --
There should be a bunch of inserts (or errors, or SOMETHING) right
before the VACUUM.
Again, the tables are all created just fine. But it's as if all of the
inserts
That should be version 8.1.4 -- sorry
brian
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
brian wrote:
postgresql 8.1, fedora core 4
I'm trying to update a database with a few new tables and insert some
data. However, psql is refusing to insert some of the data, leading to
errors when trying to refer to the sequence in the next insert (to a
cross table).
Sure, less tha
Gurjeet Singh wrote:
On 1/2/07, brian <[EMAIL PROTECTED]> wrote:
Here are the new tables (Note that set_id() and get_id() are functions
which use the $_SHARED structure so that i can set some vars and refer
back to them later)
Hi Brian,
Can you please explain the $_SHARED structu
of quotes, commas, and apostrophes in it).
This is line 39150 in the file; all previous lines import fine, but
this kills the COPY process and all of the previous inserts are rolled
back. I need to get this data loaded intact.
My copy command is
COPY posts FROM '/tmp/posts.txt' CSV QUO
t a total of zero
IF rec.total IS NULL THEN
SELECT INTO total 0;
ELSE
total := rec.total;
END IF;
RETURN NEXT;
END LOOP;
RETURN;
END;
$$ LANGUAGE plpgsql IMMUTABLE;
-- snip --
brian
---(end of broadcast)---
TIP 6: explain analyze is your friend
Richard Huxton wrote:
brian wrote:
I'm getting the above error when i try to replace a function of mine.
It seems i have two problems: the latest dump (through phpPGAdmin)
works fine, except that a function that should return a record was
replaced without the column definition list, so
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
I'm getting the above error when i try to replace a function of mine.
In what PG version?
http://archives.postgresql.org/pgsql-bugs/2006-10/msg00044.php
http://archives.postgresql.org/pgsql-committers/2006-10/msg00084.php
And w
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Need a newer phpPGAdmin, perhaps? It'd be unsurprising for pre-8.1 code
to fail to notice the OUT parameters, since it'd not know about the new
columns in pg_proc ...
phpPgAdmin 4.0.1 (4.1 is latest). But
Harpreet Dhaliwal wrote:
Is there any fedora mailinglist? Never knew if there was one
try here:
https://www.redhat.com/mailman/listinfo/fedora-list
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
#FUNCTIONS-MATH-FUNC-TABLE
brian
---(end of broadcast)---
TIP 6: explain analyze is your friend
Adam Rich wrote:
I don't see greatest or least anywhere on that page... But they ARE
here:
http://www.postgresql.org/docs/8.2/interactive/functions-conditional.htm
l#AEN13140
Yes--my bad. Wrong page.
---(end of broadcast)---
TIP 4: Have you se
good way to get across this difference is to refer to
it as *the* empty string. I prefer this description because it is
implicit that it is still a string. NULL has no type, regardless of the
column it is inserted into. Thus, the empty string is NOT NULL.
brian
---(e
Zoltan Boszormenyi wrote:
Chris írta:
CaT wrote:
On Thu, Feb 22, 2007 at 01:08:04PM +1100, Chris wrote:
In postgres, to stop an empty blank string:
create table a(a text not null check (char_length(a) > 0));
What's wrrong with using
a <> ''
sd the check? Or is this just a flavour thin
I honestly don't know
what i was thinking.
trim() trims whitespace only from the beginning and the end of the
strings but not from the middle:
# select trim(' a b c ');
I realise that. I was thinking of this case:
select trim('');
Though, i'm no
While no one in thier right mind should be using wikipgedia, I'm sympathetic
to those who might still be stuck on it for some reason, so if you guys can
produce a patch against the wikipgedia cvs, I'd be happy to apply it.
I'd like to patch that name.
---(end of broad
From the "I thought this would be trivially easy" dept:
I have a table holding member data for an organisation
CREAT table member (
id SERIAL PRIMARY KEY,
applied date,
...
and i'd like to plot the growth in memberships. I'd prefer to hand off
the data already totaled, if
Merlin Moncure wrote:
On 3/21/07, brian <[EMAIL PROTECTED]> wrote:
From the "I thought this would be trivially easy" dept:
I have a table holding member data for an organisation
CREAT table member (
id SERIAL PRIMARY KEY,
applied date,
...
and i&#x
ve
the sequence ID? Presumably, if your application is really parsing the
data first, one could simply do an INSERT and then grab the last
inserted ID. Look at nextval() & currval().
http://www.postgresql.org/docs/7.3/static/functions-sequence.html
brian
---(end of bro
Jaime Silvela wrote:
Brian, that's not what I meant.
Parsing of the uploaded file is just for the purpose of extracting the
components of each spreadsheet row and constructing the INSERTs.
Actually, whenever I copy from a file, either using COPY or with a
custom importer, I put the data i
Eddy D. Sanchez wrote:
Hello...
I need to get the a total number of business days (from monday to
friday) between two dates.
Someone can help me please.
Whether you're using PHP or not, this page may be of some help:
http://www.php.net/manual/en/function.date.php
There are a couple of exa
Glen Eustace wrote:
Is there some way that one can determine whether a table has changed
i.e. an insert, delete, update, without having to resort to setting a
flag in another table using a triger or rule.
I was wondering whether one of the system relations keep track of
whether a table has be
Just a heads up folks, someone has harvested emails out of this list,
or one of the windows users has a virus. Be on the lookout
Full header below.
From [EMAIL PROTECTED] Sat Nov 13 13:16:34 2004
Return-Path: [EMAIL PROTECTED]
Received: from [62.213.193.131] (HELO alibi.mail) by genium.com
(Stal
bles, or do you have to do
like:
CREATE INDEX on forum idx1 (datestamp);
CREATE INDEX on forum idx2 (id);
CREATE INDEX on forum idx3 (thread);
If so, then how would you say "primary"? I know some databases such as
mSQL did away with "PRIMARY KEY", and you just make indices instea
he entire field have to be updated?
Once again, field name "desc" data is "The red car", can I make it say
"The red car with blue lights"? Or do I have to update the entire field.
Brian
--
Bria
HP or anything
like that. So I am really just looking for the thumbs up that all I have
to do is a dump all.
Anyone note any good performance increase from 6.3.1 to 6.3.2?
--
Brian Feeny (BF304) | ShreveNet Inc. - Pr
maintain that many different copies of one program.
Thank you for your help,
Brian
/-- [EMAIL PROTECTED] -----\
| Brian Feeny| USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting,
Is there a difference in doing:
foo int PRIMARY KEY
and
CREATE INDEX idx1 on table (foo);
does both do the same thing (create an index)? is one faster or preffered
over the other?
/-- [EMAIL PROTECTED] -\
| Brian Feeny
quot; for each and every table, and that can be
alot of tables! Any ideas? Should this be working?
Brian
--
Brian Feeny (BF304) | ShreveNet Inc. - Premium Internet Service Provider
Network Administrator | Shreveport,
to it, It could
be 100% restored?
Brian
--
Brian Feeny (BF304) | ShreveNet Inc. - Premium Internet Service Provider
Network Administrator | Shreveport, Louisiana - http://www.shreve.net/
[EMAIL PROTECTED] | Web Ho
;
>
/-- [EMAIL PROTECTED] -\
| Brian Feeny| USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting, online stores, |
| ShreveNet Inc. | USR Pilot | Dial-Up 14.4-56k, ISDN &
o use Postgres. One of the reasons we beleive boardtown
doesn't support Postgres at this time is because of a few features SQL
server has over Postgres, and they would have to work around those.
Brian
>
> Bruce Tong | Got me an office; I'm there late at night.
t;);
$sth->execute;
$insertid = $sth->{'idnum'};
I would think that last line should be able to retreive it from the
statment handle, but it doesn't work.
Is the only way, to do *another* select after I insert and get the data?
I would hope after doing the insert, since I h
I have a sequence in a table that increments upon insert. After doing the
insert, is their a way (function maybe?) to get the sequences value
without having to do another select?
Brian
-
Brian Feeny (BF304) [EMAIL PROTECTED]
318-222
ming field "insertid" was the one being updated by the sequence, but
that doenst seem to work.
>
> -----Original Message-
> From: Brian [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 14, 1999 2:59 PM
> To: [EMAIL PROTECTED]
>
On Thu, 13 May 1999, Brett W. McCoy wrote:
> On Thu, 13 May 1999, Brian wrote:
>
> > Would something like this be appropriate?
> >
> > /usr/bin/postmaster -B 256 -i -S -D/var/lib/pgsql -o -F -B 256 -S 1024
> >
> > or should -B just be in their once? in th
erting back from
UTC+time zone is no longer the time that you were supposed to have
been at the meeting. If you had stored that future date as a
timestamp WITHOUT time zone you would have still been on-time.
This is only an issue for future dates, not past ones.
-Brian Dunavant
(time is ha
On Thu, May 21, 2015 at 5:27 PM, Thomas Kellerer wrote:
> Postgres does not store the time zone. When storing a timestamp with time
> zone, it
> is normalized to UTC based on the timezone of the client. When you retrieve
> it,
> it is adjusted to the time zone of the client.
>
Sorry, I misspoke.
_rank_cd( to_tsvector( 'gn series bandage' ),
to_tsquery( 'gn | bandage' ) );
ts_rank_cd
0.2
(1 row)
So wouldn't this be a better query for hyphenated words?
'gn-foo' | 'gn' | 'foo'
Aside: Best i can tell the parser i
I would suggest going to http://bdr-project.org/docs/stable/index.html
On Tue, Aug 4, 2015 at 3:47 PM, wrote:
> Hi,
>
>
>
> Please help me on:
>
>
>
> what is the use of bidirectional replication in PostgreSQL?
>
> How BDR works?
>
> how to setup BDR?
>
> on which versions BDR works?
>
>
>
> Th
checksums switched on so am suspecting a streaming
replication bug. Anyone know of a recent bug which could have caused
this?
--
Brian Sutherland
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, May 31, 2016 at 04:49:26PM +1000, Venkata Balaji N wrote:
> On Mon, May 30, 2016 at 11:37 PM, Brian Sutherland
> wrote:
>
> > I'm running a streaming replication setup with PostgreSQL 9.5.2 and have
> > started seeing these errors on a few INSERTs:
> >
If it's in integer columns, bitwise logic works just like you would
expect it to as well.
https://www.postgresql.org/docs/current/static/functions-math.html
db=# select 'foo' where (9 & 1) > 0;
?column?
--
foo
(1 row)
db=# select 'foo' where (9 & 2) > 0;
?column?
--
(0 rows)
J
; ERROR: could not read block 12281 in file "base/16384/29153": read only 0
> of 8192 bytes
> ginopino=# select * from stato where id=409; <<< IT WORKS FINE
--
Brian Sutherland
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e given myself this weekend
to attempt to recover more than the last backup, after that I need to
restore the service for my team to use and suck up the lost last day of
updates.
Thanks,
Brian
101 - 200 of 529 matches
Mail list logo
