On Wed, Oct 18, 2017 at 8:05 AM, Andrus wrote:
> pg_dump.exe -b -f b.backup -Fc -h -U admin -p 5432 mydb
>
> causes error
>
> pg_dump: too many command-line arguments (first is "-p")
Don't you need a hostname after -h? I think right now pg_dump thinks
your host
On Sat, Sep 23, 2017 at 9:40 AM, Tom Lane wrote:
> I wonder whether you're using up-to-date Postgres headers (ones
> where Float8GetDatum is a static inline function).
I'm building against 9.6.3 on both machines. I'm not doing anything
special to change the compilation opti
On Fri, Sep 22, 2017 at 8:38 PM, Tom Lane wrote:
> "Premature optimization is the root of all evil". Do you have good reason
> to think that it's worth your time to write unsafe/unportable code? Do
> you know that your compiler doesn't turn Float8GetDatum into a no-
On Fri, Sep 22, 2017 at 8:05 PM, Pavel Stehule wrote:
> yes, it is 8 bytes on 64-bit.
Thanks!
> I don't think so it is good idea to write 64bit only extensions.
I agree, but how about this?:
if (FLOAT8PASSBYVAL) {
datums = (Datum *)floats;
} else {
datums = palloc0(arrlen *
On Fri, Sep 22, 2017 at 7:52 PM, Paul A Jungwirth
wrote:
> Is a Datum always 8 bytes for 64-bit architectures?
Never mind, I found this in `pg_config.h`:
/* float8, int8, and related values are passed by value if 'true', by
reference if 'false' */
#defi
The docs say that a Datum can be 4 bytes or 8 depending on the machine:
https://www.postgresql.org/docs/9.5/static/sql-createtype.html
Is a Datum always 8 bytes for 64-bit architectures?
And if so, can my C extension skip a loop like this when compiling
there, and just do a memcpy (or even a
> It's going to suck big-time :-(.
Ha ha that's what I thought, but thank you for confirming. :-)
> We ended up keeping
> the time series data outside the DB; I doubt the conclusion would be
> different today.
Interesting. That seems a little radical to me, but I'll
I'm considering a table structure where I'd be continuously appending
to long arrays of floats (10 million elements or more). Keeping the
data in arrays gives me much faster SELECT performance vs keeping it
in millions of rows.
But since these arrays keep growing, I'm wondering a
On Mon, Jun 26, 2017 at 12:47 PM, Adrian Klaver
wrote:
> On 06/26/2017 12:03 PM, Paul Jungwirth wrote:
>> Perhaps
>> you should see what is line 85 when you do `\sf words_skip_game` (rather
>> than line 85 in your own source code).
>
> Or easier yet:
>
> https://www.postgresql.org/docs/9.5/static/
I'm working on a problem where partitioning seems to be the right
approach, but we would need a lot of partitions (say 10k or 100k).
Everywhere I read that after ~100 child tables you experience
problems. I have a few questions about that:
1. Is it true that the only disadvantage to 10k chi
Hello All,
I am a Database administrator and we are using PostgreSQL-9.6.1 version in
RHEL-7 linux machine. Current server Encoding setup is UTF8 and LC_COLLATE
and LC_CTYPE is en_US.UTF-8.
Lets say table person has field name with values likes
name
--
Abc
abc
.dcb
Dcb
$sdf
EDF
en_US.UTF-8
campo como varchar(7) ou colocar um
segundo campo na chave para identificar a informação.
A considerar:
99,9% dos registros desta tabela são de tamanho 7.
Dutra e demais da lista, qual a forma mais correta de modelar isso?
--
Att.
Márcio A. Sepp
--
Sent via pgsql-general mailing list (pgsql
Hi,
My DB has has 5TB, it's on Google Cloud Compute, mostly on SSDs, part on
Standard Persistent Disks.
Querying is ok, but deleting, moving between tablespaces, dropping tables,
etc, etc is hugely slow
(note: I do have a number of indexes)
Instance RAM: 60GB
Instance CPU: 16Cores
I&#
> > Can you elaborate? Why would anyone create a text column to store
> customer name or product name which can very well be in varchar(50)
> type of cols.
>
> You sound like you think that varchar(50) is somehow cheaper than text.
> That's backwards (at least
On Tue, Jul 5, 2016 at 10:17 PM, Paul A Jungwirth
wrote:
> db=> create type inetrange;
Here is a follow-up question for creating inet ranges. Is there any
way to prevent someone from doing this?:
db=> select inetrange('1.2.3.4',
'2001:0db8::
would do just that, but of course it's not there.
It seems like an appealing solution though.
With Tom's warning that a shell type would require writing the
function in C, I figured I might as well just package it all up as an
extension, so here it is:
https://github.com/pjungwir/inetra
I don’t want to create client to do some work in the DB if the DB can do it
itself on server side much faster.
The situation is that some data are inserted in to many tables and if these
data need to be post processed a notification is generated. Then the worker
needs to wake up and do its
I don’t want to create client to do some work in the DB if the DB can do it
itself on server side much faster.
The situation is that some data are inserted in to many tables and if these
data need to be post processed a notification is generated. Then the worker
needs to wake up and do its
I am trying to create background worker which listens to notifications and do
some work after receiving one.
I got 2 problems:
- Worker is receiving notifications from every channel not only the
registered channel (in my case "foo")
- Notifications are not logged in the server
On Apr 17, 2015 8:35 AM, "Kynn Jones" wrote:
> (The only reason for wanting to transfer this data to a Pg table
> is the hope that it will be easier to work with it by using SQL
800 million 8-byte numbers doesn't seem totally unreasonable for
python/R/Matlab, if you have a l
Hello,
Has anybody used online backup feature of postgreSQL? In fact precise
postgreSQL term is called: "Point-in-time Recovery" (PITR)
This means enabling following additional options in config:
---
archive_command = on
archive_command = 'cp %p /usr/local/pgsql/pgDataPITR/wals/%f' # This is only
Hi Eugene,
> Now I need to import the patch into the database, and produce another file as
> - if the passed "series" field exists in the database, then return ID:series
> - otherwise insert a new row to the table and generate new ID and return
> ID:series
> for each r
Hello Everybody,
This is the scenario:
I have a postgres 8.4, debian packages installed from pgdg repository
and version equal to: 8.4.21-1.pgdg70+1
I have a GPS database that insert about 4 million records on some tables
every week, the database is partitioned per week, I do a manual vacuum
ery is
executed multiple times or if this is just the same query that logs the
query every time it create a temp file.
I found someone on this list also reported a similar behaviour when
doing joins:
http://www.postgresql.org/message-id/52dff90e.6060...@redhat.com
The machine is a supermicro
On 11/20/2014 12:18 PM, Adrian Klaver wrote:
> What query?
>
> How is it executed?
Hi Adrian, this is one of the queries that appear to consume all
resources, we use a CTE approach ("with") because in 9.1 _sometimes_ the
planner perform an order by before doing the joins
Hello People.
I have installed a postgres engine: PostgreSQL 8.4.22 on
x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.7.2-5) 4.7.2,
64-bit from debian packages at postgresql official repository running on
debian wheezy 7.7 64 bit.
I have a couple of databases running on a cluster, and
m verbose public.tablename;
if finish immediately, but if I do:
# vacuum analyze verbose public.tablename;
it takes forever, it seems it analyze every child table.
So for now is just a matter of removing vacuum for the master table and
then doing it manually every night I guess.
Nestor A. Diaz wro
Hello People,
Before the question, this is the scenario:
I have a postgresql 9.1 cluster with a size of 1.5 TB and composed of 70
databases.
In every database I have 50 tables (master partition), each one have an
associated trigger that insert the record into a child table of its own.
The
from(
select id,
functions.python_events_unpack(event_object) up
from _tbl
where id between startid and stopid
) a
where (up).userid is not NULL
)
I want to pass the _tbl to the select query integrated in the unpacking(), how
can I make it?
thanks
Alec
Try Libreoffice Base
Thanks,
Sunday Olutayo
- Original Message -
From: "Wolfgang Keller"
To: pgsql-general@postgresql.org
Sent: Friday, October 11, 2013 1:45:10 PM
Subject: Re: [GENERAL] Forms for entering data into postgresql
> I have developed an application using MS SQL. I have
- Original Message -
From: "Wolfgang Keller"
To: pgsql-general@postgresql.org
Sent: Friday, October 11, 2013 1:45:10 PM
Subject: Re: [GENERAL] Forms for entering data into postgresql
> I have developed an application using MS SQL. I have used MS Access
> for creating forms to enter data
- Original Message -
From: "Stuart Bishop"
To: "Bruce Momjian"
Cc: "Scott Marlowe" , "SUNDAY A. OLUTAYO"
, "Gavin Flower" , "Chris
Ernst" , pgsql-general@postgresql.org
Sent: Wednesday, January 16, 2013 1:00:56 PM
Subject:
I've seen the opinion of "avoid Ubuntu like the plague" expressed many
> times, but it is never followed up with any solid reasoning. Can you
> (or anyone else) give specific details on exactly why you believe
> Ubuntu should be avoided?
>
> - Chris
>
>
>
4
: [GENERAL] Linux Distribution Preferences?
On 14/01/13 07:27, Shaun Thomas wrote:
Hey guys,
I'm not sure the last time I saw this discussion, but I was somewhat curious:
what would be your ideal Linux distribution for a nice solid PostgreSQL
installation? We've kinda bounced back and
Hi,
In PostgreSQL 9.0.x we must define a constraint as DEFERRABLE on the "create
table", we cannot define DEFERRABLE on "create table as select", how is this
restriction in 9.2 now?
Also, in 9.2 can deferrable uniqueness be mixed with Foreign keys?
Thanks
--
Sent via p
On 8 Jan 2013, at 5:04 PM, Birta Levente wrote:
> The pooler is between client and postgresql server. So, if you want to
> connect through the pooler you need to connect on 6543.
>
> But I think you really need to read some documentation about pgbouncer.
Thanks, I can connect to any testing D
?
Thanks
On 8 Jan 2013, at 3:13 PM, Birta Levente wrote:
> On 08/01/2013 08:40, a...@hsk.hk wrote:
>> Hi,
>>
>>
>> My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection
>> pool by using pgbouncer.
>>
>>
>> I used "apt
Hi,
My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by
using pgbouncer.
I used "apt-get install pgbouncer", after configuring it, I can now connect to
pgbouncer and can use all pgbouncer SHOW commands, however:
Q1) Is version "1.4.2/bouncer&quo
Hi, got it installed, thanks
On 14 Dec 2012, at 7:36 PM, Ondrej Ivanič wrote:
> Hi,
>
> On 14 December 2012 17:56, a...@hsk.hk wrote:
>> I could see that it would install older PostgreSQL 9.1 and
>> postgresql-contrib-9.1. As I already have 9.2.1 and do not want to have
Hi,
I am using Ubuntu 12.04, I have used installer to install PostgreSQL 9.2.1, the
contrib modules are not installed together with the core.
I tried to run:
sudo apt-get install postgresql-contrib
The following packages were automatically installed and are no longer
required:
Hi, yes it is a dedicated server. and THANKS!
On 12 Dec 2012, at 3:55 PM, Pavel Stehule wrote:
> hello
>
> 2012/12/12 a...@hsk.hk :
>> Hi,
>>
>> I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to
>> turn the server with t
Hi,
I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to turn
the server with the following changes from default:
max_connections = 100 # default
shared_buffers = 2048MB # change from 24MB to 2048MB as I think 24MB is
not enough
maintenance_work_mem
Hi, thank you very much!
On 7 Dec 2012, at 11:47 AM, Ondrej Ivanič wrote:
> Hi,
>
> On 7 December 2012 14:17, a...@hsk.hk wrote:
>> I have questions about Linux Write cache sizing:
>>
>> 1) /proc/sys/vm/dirty_ratio : current value (default) 20
>> 2) /p
Hi,
I have questions about Linux Write cache sizing:
1) /proc/sys/vm/dirty_ratio : current value (default) 20
2) /proc/sys/vm/dirty_background_ratio: current value (default) 10
I am using Ubuntu 12.04 (8GB RAM) and PostgreSQL 9.2.1, what values of these
kernel ratios should be set for better
Hi all,
We are currently doing a security assessment over a PostgreSQL database
sitting on a Linux server. Just wondering if anyone has a script and/or
audit program for gathering information and assessing a postgreSQL
database (similar to the oracle sql scripts that have been distributed
n
> select abs(new.q1) into new.q2;
> return new;
> end$$;
>
> create trigger mytrig before insert on fooey for each row
> execute procedure myt();
>
> insert into fooey values(-42, 77);
>
> select * from fooey;
> q1 | q2
> -+
> -42 | 4
correction: because the single master was too BUSY
On 28 Sep 2012, at 7:48 PM, a...@hsk.hk wrote:
> Hi Jon,
>
> I have had a similar case as yours, I have one data center in Hong Kong
> another one in Tokyo, we have line between them, here are my feedback:
>
> 1) we used m
Hi Jon,
I have had a similar case as yours, I have one data center in Hong Kong another
one in Tokyo, we have line between them, here are my feedback:
1) we used multiple masters at first, from time to time, some issues like that
it took time to sync between master servers which caused obvious
Thanks you all,
" IF last_id IS NULL THEN " eventually work
Thanks,
Sunday Olutayo
Sadeeb Technologies Ltd
- Original Message -
From: "SUNDAY A. OLUTAYO"
To: "Rob Richardson"
Cc: pgsql-general@postgresql.org
Sent: Thursday, September 27
sadeeb.com
- Original Message -
From: "Chris Ernst"
To: pgsql-general@postgresql.org
Sent: Wednesday, September 26, 2012 7:10:03 PM
Subject: Re: [GENERAL] trigger and plpgsq help needed
On 09/26/2012 10:42 AM, SUNDAY A. OLUTAYO wrote:
> This IF last_id IS NULL THEN suppos
d plpgsq help needed
Why not use IF FOUND?
RobR
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of SUNDAY A. OLUTAYO
Sent: Wednesday, September 26, 2012 12:43 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] trigger and plpgsq help needed
Hi,
I have tried to compile it in my local machine, I could not reproduce the issue
yet.
Does anyone else have idea what the reason would be? Would the issue come from
the config file?
Regards
Arthur
On 27 Sep 2012, at 7:46 PM, Leonardo M. Ramé wrote:
> On 2012-09-27 11:51:46 +0800
Hi,
Could you provide the steps and commands you used to compile 9.1?
I want to reproduce your case in my machine
Regards
Arthur
On 27 Sep 2012, at 7:46 AM, Leonardo M. Ramé wrote:
> Hi, I compiled PostgreSql 9.1 from sources in a OpenSuse 10.1 PowerPC
> machine. While trying to te
Dear all,
I have issue with the red portion function below;
This IF last_id IS NULL THEN suppose to test if last_id is NULL, that is the
select query did not found it
then execute the rest of the red sql but it always fail to insert the
NEW.amount into amount , every other things fine.
Kin
Regards
Arthur
On 24 Sep 2012, at 4:45 AM, Raymond O'Donnell wrote:
> On 23/09/2012 19:31, Martin Collins wrote:
>> On 23/09/12 11:48, Adrian Klaver wrote:
>>> On 09/23/2012 04:47 AM, a...@hsk.hk wrote
Hi,
I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted postgresql,
it displayed my postgresql is 9.2 but when I log into postgresql, show version,
it is still 8.4.13, see a) and b) below,
a)
* Restarting PostgreSQL 9.2 database server
...done.
b)
psql (8.4.13)
Type "
In real world deployment, LDAP and Kerbero are often combined for
authentication and authorization.
The link below is a well documented howto:
https://help.ubuntu.com/community/SingleSignOn
Thanks,
Sunday Olutayo
- Original Message -
From: "Craig Ringer"
To: "SU
ld provide a howto reference
or some tips on how to set-up auth configuration to provide SSO to windows
clients? I've read the GSSAPI/Kerberos authentication section of the docs, but
it's still unclear to me the exact process to follow. In particular what things
would I need to con
Hi there.
I'm stuck with a machine with so very slow I/O one starts to remember
the good-old-days when we had 3,5" floppies.
So I can't do anything with the hardware, but what settings in the
config should I use to make handle the extremly slow I/O?
Any suggestions?
--
Sent vi
sql_flags="-s -m smart"
Operatin System: FreeBSD 8.2 p4
Database: PostgreSQL Server 8.2.9_2
I have had a lot of work trying to solve this issue, and I finally found the
solution.
Why at this time, with the latest version of PostgreSQL 8.4.9_2 this isssue
continue ?
I k
Le 23/09/2011 12:30, Alban Hertroys a écrit :
> On 23 September 2011 11:47, Andrew Rose <mailto:andrew.r...@metaswitch.com>> wrote:
>
> Basic Question: In text fields, is prefix matching significantly faster
> than suffix matching?
>
>
> It does depend
I'm setting up a new server for a CMS I have written (er, partially,
needs work) that uses PostgreSQL as a backend.
All my existing CentOS 5 servers, I use pgrpms for PostgreSQL.
I would like to do the same with CentOS 6 but I also want to keep
SELinux enabled on this box.
Do the RPM
Dear Pavel,
Thank you. Now it is not possible to use separate columns. The same works at
MYSQL with out casting. But here it is so. We have used CAST and works fine.
Thank you
vikram
From: Pavel Stehule
To: Vikram A
Cc: PGSQL - Genearal
Sent: Wednesday, 17
t can be
ZERO while querying. I need answer as 4055.
Can i have your suggestion/solutions please?
Regards,
Vikram A
Hello,
I was bitten by a length-truncated role name used in a script since the
truncation only raises a NOTICE. The symptom was that the some GRANTs ended up
on the wrong objects after name truncation.
Then, I experimented with tables with long names and was surprised by the
truncation
Hi Mr. David,
Thanks for the comment. I understood, its more difficult to mange the schema;
when schema itself written in jig jack.
Vikram
From: David Johnston
To: 'Vikram A'
Cc: pgsql-general@postgresql.org
Sent: Friday, 17 June 2011 7:00 PM
S
dea.
Thank you
Vikram A
my decision and about the use of PGP functions.
Thank you.
Vikram A
From: Craig Ringer
To: Vikram A
Cc: PGSQL - Genearal
Sent: Tuesday, 14 June 2011 12:52 PM
Subject: Re: [GENERAL] PGP encrypt/decrypt - Prereqistes
On 14/06/11 14:29, Vikram A wrote:
>
I am running into an odd problem when fetching from multiple cursors in
Perl. However, I do not feel knowledgeable enough to ask an intelligent
question.
Can you in the community direct me at some deeper documentation. Perhaps a
developers guide (for Postgres itself), that might discuss the
Dear Ringer,
My application work in a LAN. It will not with across internet. Number users
also less than 25. Only certain information to be cipher. Also I do not want
such a complicated public and private key as PGP defines. As you said, I would
like to go for simple[Symmetric] method with our
Dear Mr. Craig Ringer,
Thank you for your response.
I would like to crypt certain sensitive information in my applications such as
Student register number, their marks, results etc. For this reason i done a
study for doing encryption. Where I found that this PGP will help
the encryption
Hi there,
I am new to postgreSQL. I would like to use encrypt/decrypt using PGP keys on
windows.
May i know,
1. What should i know before i proceed?
2. Any manual to follow the steps ?
Thank you in advance
Vikram
Hi there!
I have a small problem, in a database I need to export parts of a
database table to another server, and I could easily accomplish ( I
hope) that by creating a view and select * from the view and send it
over to the other server or use triggers to record what rows are
inserted and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Le 27/04/2011 20:48, Dave Page a écrit :
> I'm pleased to announce that effective immediately, Magnus Hagander
> will be joining the PostgreSQL Core Team.
>
> Magnus has been a contributor to PostgreSQL for over 12 years, and
> pl
I'm very embarresed now.
There were another trigger that caused a problem. Now it works.
Thank you all for helping! :-)
2011/2/10 Adrian Klaver :
> On Thursday, February 10, 2011 6:29:58 am A B wrote:
>> Hello.
>>
>> I'm probably doing some very basic error here,
Thanks for the suggestion, but
CREATE TRIGGER trigger_foo BEFORE INSERT ON foo for each row EXECUTE
PROCEDURE trigger_foo();
gives me the same error.
2011/2/10 Vick Khera :
> On Thu, Feb 10, 2011 at 9:29 AM, A B wrote:
>> Can someone help me spot the error? :-)
>>
>
>
Hello.
I'm probably doing some very basic error here, but I get
ERROR: record "new" is not assigned yet
The tuple structure of a not-yet-assigned record is indeterminate.
when I try this small example
create table foo(x int);
create or replace function trigger_foo()
Hello.
How do you create an index for only some of the rows in a table? I
read in the docs:
"The expression used in the WHERE clause can refer only to columns of
the underlying table, but it can use all columns, not just the ones
being indexed. Presently, subqueries and aggregate expres
Does anyone know of a module for postgres that can do metadata management in
postgres but actual storage of binary objects in filesystem ?
Not really using Postgres large object but want to just do the
metadata management with postgres. Example, need to store
file name/size/directory/drive
Hello!
I have a question about catching exceptions.
If I write a plpgsql function like this
begin
do stuff;
exception
when X then
when Y then
...
end;
If the "do stuff" part can result in two different unique_violation
exception (having two unique constraints), how ca
Thank you all for your replies.
2010/10/8 Alban Hertroys :
> On 8 Oct 2010, at 8:59, A B wrote:
>
>> Hello.
>>
>> I have a table
>>
>> create table foo (
>> a serial,
>> b int,
>> c int,
>> more fields ...);
>>
>> an
Hello.
I have a table
create table foo (
a serial,
b int,
c int,
more fields ...);
and now I wish to remove for each combination of b and c, all the
rows except the one with the highest value of a.
For example
a b c other fields
=
1 5 5 .
2 5 5
3 2 3
4 2 2
Sorry, Gmail made med confused, my biggest "thank you" was to Richard
Huxton, who showed me code that worked.
2010/9/26 A B :
> 2010/9/25 Tom Lane :
>> Jeff Davis writes:
>>> There's no reason that there couldn't be a point <@ box operator in the
2010/9/25 Tom Lane :
> Jeff Davis writes:
>> There's no reason that there couldn't be a point <@ box operator in the
>> opclass, but nobody really uses these geometric types that come with
>> core postgres (at least, not that I can tell).
>
> Actually, as
But how do I do it without Postgis?
Right now I have a table
fleet (id bigserial primary key, location point);
and I have filled it with random data and then tried selecting
explain analyze select count(1) from fleet where location <@
box(point(300,300),point(600,600));
to gather runningt
Hi
I did not see this feature on the TODO page on the wiki. I apologise if I
have overlooked something similar.
I would like postgres to have a cron-like feature for scheduling things to
happen at particular times.
An example of this might be routinely purging data from tables, or
vacuuming
Hello.
If I have a table like this
create table fleet ( ship_id integer, location point);
and fill it with a lot of ships and their locations and then want to
create an index on this to speed up operations on finding ships within
a certain region (let's say its a rectangular region), h
On 9/22/2010 12:18 PM, Scott Marlowe wrote:
On Tue, Sep 21, 2010 at 9:10 PM, Christopher Gorge A. Marges
wrote:
But how would the newer version prevent bloat and eliminate making the
database unavailable while the *maintenance* goes on?
The database is more than five years old, and we did
table so we do not see any
compelling reason to upgrade. But seeing 9.0 includes an improved
vacuum makes it worth looking into.
Perhaps there is a more direct approach to remove the bloat, like with a
sql statement or some third party utility? We did use the pg_autovacuum
and unless I am
We are using 7.4.13 and run the pg_autovacuum. Over the years, the
database has grown so our maintenance plan was to "move" everything
except for the last year. Since the server is kept up always using a
full vacuum is out of the question. However the space is running out
an
Hello.
I use swedish locale
show lc_numeric;
lc_numeric
-
sv_SE.UTF-8
and I get a . (dot) in all floating-point numbers.
This makes me wonder, when can I see the effects of the locale? That is, I get
select 355/113.0 as pie;
pie
3,1415929203539823
Hello.
Is there any doc or wiki page that describes what filesystems that are
recomended to use (OS is Linux) for PostgreSQL?
Information about filesystems options/mount options and how well
they work with different RAID setups is also of interest.
--
Sent via pgsql-general mailing list (pgs
In response to Steve Clark :
> >Try this with explicet cast:
>
> Thanks guys, that seems to do the trick. Postgresql ROCKS!!!
Yeah, definitively!
You are welcome, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A32
In response to Steve Clark :
> Hello List,
>
> I want to change some columns in a database
> that were originally created as char varying to
> inet.
>
> When I try I get an error. Is there anyway to work
> around this?
>
> See below for table definiti
In response to Callum Scott :
> Hi All,
>
> I am looking for a way to define where index files should be located.
>
> I am wanting to store the index files on a separate SSD from the database
> itself. I can see that there is a way to define this from within the
> databas
How can I reset a sequence column due to deletion of some rolls?
Sunday Olutayo
Sadeeb Technologies Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
In response to zhong ming wu :
> Hello List,
>
> I have a plpgsql function returning a set of records. The record is
> effectively a join of some tables.
>
> For example, table a (column a1,column a2,column a3,column a4)
>
> table b(column b1,column b2,column b4)
>
documentation it
> informs), I'm going to go out on a limb and present an additional use-
> case that may be unpopular, or at least controversial.
>
> There are times when a documentation's audience is not interested in
> taking the subject matter to expert level. (eg: i
In response to ?? :
> so. i killed Session 1's PID with kill -9 commands
What have you killed, the client or the postmaster?
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC
In response to ?? :
> today, I found this situation.
>
>
>
> Session 1. -
>
> begin;
> delete from ;
>
>
> Session 2 -
>
> delete from ;
>
>
> thus, it occured row level locking.
>
>
>
>
> so. i killed Session 1's PID with kill -9 commands
>
>
> but. both s
1 - 100 of 1430 matches
Mail list logo
