thank you jie Liang for your response, but my problems are:
1. How to store a query in the database.
2. How to give a parameter from outside of database, for example:
select * from table1 where row1 = my_parameter_outside.
Give me an example please.
begin:vcard
n:brito;nelson
x-mozilla
Hello list,Apologies if this has been asked before. My search only
turned up ways to list the total non-null values for all columns as a single
number. I want the count for each column by column.I have inherited a
database consisting of two related huge monolithic tables that lack referential
i
Well it is certainly nice to see that my choice to send my question using plain
text was honored by this email service. Apologies for that mess. The output I
am looking for is a series of rows with two columns, one the name of the table
column, and the other the count of non-null values in a tab
On Fri, Aug 14, 2015 at 9:59 AM, John McKown
wrote:
>
> David,
>
> It still came through as junk. But I reconstructed it below
>
> === original message ===
> Apologies if this has been asked before. My search only turned up ways to
list the total non-null values for all columns as a single number.
On Fri, Aug 14, 2015 at 10:00 AM, Tom Lane wrote:
>
> David Rowley writes:
> > On 15 August 2015 at 02:32, David Nelson
wrote:
> >> Hello list,Apologies if this has been asked before. My search
only
> >> turned up ways to list the total non-null values for all colu
On Fri, Aug 14, 2015 at 9:17 PM, Ken Tanzer wrote:
> On Fri, Aug 14, 2015 at 6:35 PM, David Nelson
> wrote:
>
>> On Fri, Aug 14, 2015 at 10:00 AM, Tom Lane wrote:
>> >
>> > David Rowley writes:
>>
>
>
>> Tthat is the way I would do it for a
Good morning all,
I am creating an updatable view on a set of tables, and just ran into
unexpected (or more likely misunderstood) behavior with the UPDATE
statement. If an attribute is not explicitly listed in the UPDATE statement,
the NEW value appears to be populated with the OLD value. Unless I
>> So in the UPDATE statement, I only provided a value for last_user. But
the
>> first test of the trigger function tests for a NULL value of
>> NEW.empname. Since
>> I did not provide one, I was expecting it to be NULL and an exception to
>> be thrown. Am I just misunderstanding how things work? I
On Thu, Aug 27, 2015 at 1:21 PM, Jerry Sievers
wrote:
>
> David Nelson writes:
>
> >>> So in the UPDATE statement, I only provided a value for last_user.
But the
> >>> first test of the trigger function tests for a NULL value of
> >>> NEW.empn
On Fri, Aug 28, 2015 at 6:39 AM, Ladislav Lenart wrote:
>
> Hello.
>
>
> On 27.8.2015 18:35, David Nelson wrote:
> >>> So in the UPDATE statement, I only provided a value for last_user.
But the
> >>> first test of the trigger function tests for a NULL value
> Just for the sake of completeness...
>
> If the value (empname in the above example) can be NULL, the compare does
not work, because
>
> SELECT NULL = NULL
>
> returns NULL which is treated as FALSE.
>
> But I am sure you know this :-)
>
>
> HTH,
>
> Ladislav Lenart
>
> __
en removed
Can I simply copy the file from my archive directory back to the WAL directory?
Thanks in advance
Tony Nelson
Since 1982, Starpoint Solutions has been a trusted source of human capital and
solutions. We are committed to our clients, employees, e
> -Original Message-
> Tony Nelson wrote:
>
> > 2015-12-07 08:24:50 EST FATAL: requested WAL segment
> > 00010089002C has already been removed
> >
> >
> >
> > Can I simply copy the file from my archive directory back to the WA
Thank you very much, this is working perfectly. I copied a couple over and the
server applied them, and is waiting for the next set.
Tony
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Monday, December 07, 2015 8:59 AM
To: Tony Nelson
Cc: Andreas Kretschmer; pgsql-general
I have a nicely working 3 server, 1 master, 2 slave setup. All servers are
running on Ubuntu 12.04. I was considering building a new slave server on
16.04.
The master is currently running 9.1.13, the slave I'm going to replace is
running 9.1.20.
Does the new slave have to be running 9.1? Or
What influences the calculation of the 'width' value in query plans?
Specifically, I have two queries which both query the same set of
tables via either UNION or UNION ALL based on the presence (or
absence) of an aggregate function.
Like this:
SELECT a, b FROM foo_1 WHERE a = 'bar'
UNION
SELECT a
On Fri, Nov 19, 2010 at 12:14 PM, Tom Lane wrote:
> Jon Nelson writes:
>> What influences the calculation of the 'width' value in query plans?
>
> It's generally the sum of the estimated column widths for all the
> columns needed at that particular level of th
On Fri, Nov 19, 2010 at 1:09 PM, Tom Lane wrote:
> Jon Nelson writes:
>> On Fri, Nov 19, 2010 at 12:14 PM, Tom Lane wrote:
>>> Hard to comment about this with such an incomplete view of the situation
>>> --- in particular, data types would be a critical factor, and
On Tue, Dec 7, 2010 at 9:17 AM, Steve Clark wrote:
> Hello All,
>
> I am working with a postgresql database that has two columns.
> One for an ip address and another for the netmask. Both of these
> columns are char varying(30). I would like to convert to just
> one column as inet. Any one know a
On Wed, Dec 8, 2010 at 7:15 AM, Andre Lopes wrote:
> Hi,
>
> I need to obtain the maximum value of a date, but that comparison will be
> made between 3 tables... I will explain better with a query...
>
> [code]
> select
> a.last_refresh_date as d1, ae.last_refresh_date as d2, ha.last_refresh_date
On Fri, Dec 31, 2010 at 1:13 PM, bricklen wrote:
> On Wed, Dec 29, 2010 at 1:53 PM, bricklen wrote:
>> On Wed, Dec 29, 2010 at 12:11 PM, Tom Lane wrote:
>>>
>>> The difference in ctid, and the values of xmin and relfrozenxid,
>>> seems to confirm my suspicion that this wasn't just random cosmic
Let's say I have a database with two tables, a and b.
Each has one column. 'a' has a column 't' of type text. 'b' has a
column 'v' of type 'varchar' (no length specified).
If I join the two tables, I see in the plan something that looks like this:
Merge Cond: (a.t = (b.v)::text)
I thought 'char
On Fri, Feb 4, 2011 at 1:18 PM, Tom Lane wrote:
> Jon Nelson writes:
>> I thought 'character varying' (aka varchar) sans length was an alias
>> for text. Is it not?
>
> It has the same behavior, but it is a distinct type, so dummy coercions
> are needed.
Are
On Mon, Feb 14, 2011 at 11:57 AM, David Johnston wrote:
> You cannot ALWAYS do an indexed scan - sometimes the only option for the
> parser is to do a sequential scan (thus you can say "avoid unless you have
> to" but you can never truly disable sequential scanning).
>
Does this suggest that the
I am working with a system which periodically has to perform this operation:
update all of the rows in table A which match rows in table B, using a
subset of the columns for comparison (and one of the columns in tableA
is NULL).
This is what I've tried:
update tableA
SET column1 = some_value
FRO
On Mon, Mar 21, 2011 at 7:16 PM, John R Pierce wrote:
> On 03/21/11 5:04 PM, Tomas Vondra wrote:
>>
>> So just put there a tripod, a reasonable HD cam for $300 and you'll get
>> a decent video of the session.
>>
>
> you definitely want a sound patch from a lapel mic or the room PA, and not
> be us
, or am I even on track here?
Thanks in advance and regards,
Nelson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Sep 4, 2014 at 9:48 AM, François Beausoleil
wrote:
> Hello Nelson,
>
> Le 2014-09-04 à 10:39, Nelson Green a écrit :
>
> > Good morning,
> >
> > Hopefully this is the correct place to ask this type of question.
> >
> > I am in the early stag
oleil
>>
>>
> Thanks François. This is pretty generic stuff, but my first reading has
> got me thinking that I should at least pick up some ideas from it. I will
> give it a go. And I've got a new web site that I've now known about before,
> so thanks for th
On Fri, Sep 5, 2014 at 9:46 AM, John McKown
wrote:
> On Fri, Sep 5, 2014 at 7:52 AM, Nelson Green
> wrote:
> >
> > Thanks Robin. Ironically enough, our little local library has three
> books by
> > Joe Celko, so looks like I may have a weekend of reading ahead of me.
ore
beneficial in the long run.
Well, back to work. Gotta go explain to someone why two separate and
unrelated
tables won't model their multi step workflow too well (OK not at all
really). I
just love how people that can populate a spreadsheet think that makes them
into
data professional
change the password, but we use an automated password
generator so I'd like to not have to keep generating passwords, and
checking them, until I get one that will work, unless that my only option.
Thanks,
Nelson
On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver
wrote:
> On 09/26/2014 12:58 PM, Nelson Green wrote:
>
>> Hello all,
>>
>> I am setting up a streaming replication stand-by, and the replication
>> role password has a single quote in it. I am unable to properly
&g
On Fri, Sep 26, 2014 at 6:46 PM, Adrian Klaver
wrote:
> On 09/26/2014 04:32 PM, Nelson Green wrote:
>
>> On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver
>>
>
> Doubling the quote seems to work here.
>>
>>
>> Thanks Bosco, DrakoRod, and Adrian. Bet
On Fri, Sep 26, 2014 at 6:40 PM, John R Pierce wrote:
> On 9/26/2014 4:32 PM, Nelson Green wrote:
>
>>
>> Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became
>> obvious
>> that I was doing something wrong. And yes, in the end you were right.
programmatically if possible, to
validate input for a function I am developing.
Thanks,
Nelson
On Mon, Dec 1, 2014 at 2:14 PM, Merlin Moncure wrote:
> On Mon, Dec 1, 2014 at 10:42 AM, Nelson Green
> wrote:
> > Good morning list,
> >
> > According to the documentation for interval data type inputs, the unit
> can
> > be one of microsecond, millisecond
27;),('hour'),('day'),('week'),('month'),('year'),('decade'),('century'),('millennium');*
>
> *SELECT * FROM time_intervals;*
>
Thanks Melvin,
Actually I've already hard-coded a temporary table into the fun
On Tue, Dec 2, 2014 at 11:57 AM, Merlin Moncure wrote:
> On Tue, Dec 2, 2014 at 9:48 AM, Nelson Green
> wrote:
> > On Mon, Dec 1, 2014 at 2:14 PM, Merlin Moncure
> wrote:
> >> On Mon, Dec 1, 2014 at 10:42 AM, Nelson Green
> >> wrote:
> >> > Good
On Tue, Dec 2, 2014 at 2:25 PM, Adrian Klaver
wrote:
> On 12/02/2014 10:40 AM, Nelson Green wrote:
>
>> On Tue, Dec 2, 2014 at 11:57 AM, Merlin Moncure > <mailto:mmonc...@gmail.com>> wrote:
>>
>
>
>> Hi Merlin,
>>
>> I'm afraid I'm
On Tue, Dec 2, 2014 at 3:48 PM, Merlin Moncure wrote:
> On Tue, Dec 2, 2014 at 12:40 PM, Nelson Green
> wrote:
> > In the line: IF LOWER(_unit) NOT IN (SELECT interval_unit ..., I would
> > rather
> > query a catalog table for the interval unit names if possi
,
PRIMARY KEY (badge_number)
);
What datatype should I use for the badge_photo (bytea?), and what are the
commands to insert the picture accessing the server remotely through psql,
and to retrieve the photos as well, please?
Thanks,
Nelson
ytea's.
>
>
>
> There are downsides in both solutions, you just have to have good reasons
>
> to not use bytea.
>
>
>
> On Πεμ 09 Μαΐ 2013 10:04:18 Nelson Green wrote:
>
> Good morning list,
>
> I am designing a system that will have a table for security
her than years ago when I was studying for
some of the MySQL certs.
If I do happen to come up with a solution that works I will be sure to post
it here.
>
>
>
>
> On Πεμ 09 Μαΐ 2013 10:34:35 Nelson Green wrote:
>
> On Thu, May 9, 2013 at 10:20 AM, Achilleas Mantzios <
>
time people manipulate bytea's using a higher level
> programming lang.
>
>
>
>
>
> On Πεμ 09 Μαΐ 2013 10:34:35 Nelson Green wrote:
>
> On Thu, May 9, 2013 at 10:20 AM, Achilleas Mantzios <
> ach...@matrix.gatewaynet.com> wrote:
>
> why not bytea?
>
>
>
On Thu, May 9, 2013 at 12:05 PM, Nelson Green wrote:
>
>
>
> On Thu, May 9, 2013 at 10:51 AM, Achilleas Mantzios <
> ach...@matrix.gatewaynet.com> wrote:
>
>> **
>>
>> Take a look here first :
>>
>> http://www.postgresql.org/docs/9.2/
!
On Thu, May 9, 2013 at 12:31 PM, Misa Simic wrote:
>
>
>
> 2013/5/9 Nelson Green
>
>> Thanks Karl, but I'm trying to do this from a psql shell. I can't use the
>> C functions there, can I?
>>
>>
>> On Thu, May 9, 2013 at 11:21 AM, Karl De
.
On Thu, May 9, 2013 at 1:49 PM, Misa Simic wrote:
>
>
>
> 2013/5/9 Nelson Green
>
>> Hi Misa,
>>
>> That gives me a "ERROR: must be superuser to use server-side
>> lo_import()" on the client. I think this is enforced to preserve file
>> perm
On Fri, May 10, 2013 at 2:59 AM, Eduardo Morras wrote:
>
> Hi Nelson. I worked with images and Postgresql, and want to add some
> comments:
>
> On Thu, 9 May 2013 13:40:15 -0500
> Nelson Green wrote:
> > OK, this is kind of convoluted, but I got a couple of test case
On Fri, May 10, 2013 at 5:24 AM, Misa Simic wrote:
> 2013/5/10 Eduardo Morras
>
>>
>> Hi Nelson. I worked with images and Postgresql, and want to add some
>> comments:
>>
>> On Thu, 9 May 2013 13:40:15 -0500
>> Nelson Green wrote:
>> > OK, thi
On Tue, Feb 28, 2017 at 9:41 AM, Adrian Klaver
wrote:
> On 02/27/2017 11:14 PM, Sasa Vilic wrote:
> ...
>
> "My problem is that sometimes WAL uploaded from master and from slave are
> not 100% identical. In most cases they are but occasionally they are not. I
> have written small script that en
New to Postgres and I have never seen this condition. We are getting test
applications hanging on SELECT statements with a RowExclusiveLock. How can
a SELECT cause a RowExclusiveLock?
relname | pid | mode | granted
--+---+--+---
Hi all,
I need to do a backup from a big table that is in a machine with almost no disk
space.
Running pg_dump from another machine needs much space on the DB host? Or it
just outputs the data as it goes?
Is there a better way to do this?
Thanks,
Nelson
Hello,
I have a question regarding inserting a row into a child table when the PK of
the parent table is a composite key.
In this case, I have funding sources that buy projects, and projects generate
jobs. Project numbers are not universally unique, but are unique to funding
source. Therefore
> To: pgsql-general@postgresql.org
> Date: Tue, 26 Nov 2013 08:15:45 +0100
>
> Nelson Green, 25.11.2013 23:01:
> > Hello,
> > When inserting a record into the jobs table that references projects by
> > name, do I have to query the projects table twice,
> > o
entry for person 427 on project 15 was sequence
number 125, is that information available to me anywhere?
Thanks,
Nelson
On Wed, Jan 8, 2014 at 10:09 AM, Francisco Olarte wrote:
> Hi Nelson:
>
> On Wed, Jan 8, 2014 at 4:54 PM, Nelson Green
> wrote:
> > I have a projects log table with a three column PK, project_num,
> person_num,
> > and sequence, where each new entry for a
On Wed, Jan 8, 2014 at 10:22 AM, Tom Lane wrote:
> Francisco Olarte writes:
> > Hi Nelson:
> > On Wed, Jan 8, 2014 at 4:54 PM, Nelson Green
> wrote:
> >> I have a projects log table with a three column PK, project_num,
> person_num,
> >> and sequence, wh
On Wed, Jan 8, 2014 at 1:24 PM, David Johnston wrote:
> Nelson Green wrote
> > My apologies, I was not completely clear. I will not know any of the
> > columns in advance. The most recent insert is the result of user input
> > from
> > a web form, so I won'
On Wed, Jan 8, 2014 at 5:39 PM, Alban Hertroys wrote:
> On 08 Jan 2014, at 16:54, Nelson Green wrote:
>
> > I have a projects log table with a three column PK, project_num,
> person_num, and sequence, where each new entry for a project/person
> combination increments the sequ
When dropping lots of tables, I noticed postgresql taking longer than
I would have expected.
strace seems to report that the largest contributor is the ftruncate
and not the unlink. I'm curious what the logic is behind using
ftruncate before unlink.
I'm using an ext4 filesystem.
--
Jon
--
Se
On Sun, Feb 23, 2014 at 9:49 PM, Tom Lane wrote:
> Jeff Janes writes:
>> On Sunday, February 23, 2014, Scott Marlowe wrote:
>>> I'm guessing that this is so that it can be rolled back. Unlink is
>>> likely issued at commit;
>
>> I would hope that ftruncate is issued at commit as well. That does
On Sun, Feb 23, 2014 at 10:07 PM, Tom Lane wrote:
> Jon Nelson writes:
>> On Sun, Feb 23, 2014 at 9:49 PM, Tom Lane wrote:
>>> If memory serves, the inode should get removed during the next checkpoint.
>
>> I was moments away from commenting to say that I had traced
round?
Any ideas on what else we should try?
---
=======
Samuel Nelson
Consistent State
www.consistentstate.com
303-955-0509
===
ull on the underlying
database to a table that only exists on one node.
---
===
Samuel Nelson
Consistent State
www.consistentstate.com
303-955-0509
===
On Thu, May 5, 2011 at 12:36 PM, Scott Mead wrote:
>
> On Thu, May 5, 2011 at 1:40 PM, Merli
I am having problems importing a CSV file of sample data for testing
in a web app.
Columns & Types
---
zip_code - text
lattitude - float8
longitude - float8
city - text
state - text
county - text
Some Sample Data From CSV File
--
96799,-7.209975,-170.77
Hi Adrian, yes that is the entire table definition.
On Fri, Jul 15, 2011 at 12:30 PM, Adrian Klaver wrote:
> On 07/15/2011 09:03 AM, Bryan Nelson wrote:
>>
>> I am having problems importing a CSV file of sample data for testing
>> in a web app.
be
> around text fields. That is the norm for CSV files.
>
> Susan
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bryan Nelson
> Sent: Friday, July 15, 2011 9:04 AM
> To: pgsql-gene
thout quotes.
>>
>> Susan
>>
>> -Original Message-
>> From: pgsql-general-ow...@postgresql.org
>> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bryan Nelson
>> Sent: Friday, July 15, 2011 9:04 AM
>> To: pgsql-gener
at8
t.column :city, :text
t.column :state, :text
t.column :county, :text
end
add_index "geo_data", ["zip_code"], :name => "zip_code_optimization"
end
def self.down
drop_table :geo_data
end
end
On Fri, Jul 15, 2011 at 1:10 PM, Tom
e, figured it had to be something simple. Shows how
new I am at postgres.
On Fri, Jul 15, 2011 at 1:44 PM, Tom Lane wrote:
> Bryan Nelson writes:
>> Tom, the file was created in linunx and is utf-8. Here is the rake
>> task that created the table:
>
>> class Creat
Thanks Tom that did it :)
James: I'll add those books to my list
I appreciate everyone's help!
On Fri, Jul 15, 2011 at 2:16 PM, Tom Lane wrote:
> Bryan Nelson writes:
>> Tom, rake is a rails command, also after doing a \d geo_data it does
>> show that it
timestamps from ls (mtimes, I believe?)
against the files in the pg_xlog directory and comparing the timestamp of
the files on the master to the same files on the slave. Is this incorrect?
If so, what's the standard way of calculating the lag of a hot standby?
---
=====
but in the mean time, does anyone know if JDBC has
any issues connecting that psql and PGAdmin wouldn't have? Is it
possible that JDBC is somehow susceptible to connection issues that
JDBC and psql are not?
---
===
Samuel Nelson
Consistent State
www.consistentstate.c
Everything is remote. I thought of the IPv6 thing, but that seems
unlikely - all connections are coming from the same system.
Still, we'll ask them and try to get some more details about things like that.
---
===
Samuel Nelson
Consistent State
www.consistentstate.co
I have a table with a fair bit of TOAST data in it.
I noticed that \d+ does /not/ include that information (but
pg_total_relation_size does).
Is that intentional? It seems a bit misleading, insofar as "\d+" feels
like it is meant to be a rough indication of the table size, but if
90% of the data is
On Tue, Sep 20, 2011 at 2:09 PM, Josh Kupershmidt wrote:
> On Tue, Sep 20, 2011 at 1:26 PM, Jon Nelson wrote:
>> I have a table with a fair bit of TOAST data in it.
>> I noticed that \d+ does /not/ include that information (but
>> pg_total_relation_size does).
>
>
On Thu, Sep 29, 2011 at 7:30 AM, Alban Hertroys wrote:
> On 29 September 2011 13:12, Radosław Smogura wrote:
>>> sending ~1GB bytea values is borderline crazy, and is completely crazy
>>> if you are not absolutely sure the transmission is not 100% binary. I
>>> don't know if the JDBC sends/recei
On Thu, Sep 29, 2011 at 10:51 AM, David North wrote:
> I'll also apply GZip to keep the amount of data in any given bytea/lob as
> small as possible.
Aren't bytea fields compressed by postgresql anyway (when EXTENDED or
MAIN is used) (by default).
http://www.postgresql.org/docs/8.4/static/stora
Good morning, list.
We've got a bit of a problem on a customer's production box. We got a
"missing chunk number 0 for toast value N" (N being a number) this week on
their production box. We verified that it was only a problem with one row,
tried to fix it with updates, and ended up deleting the
Sorry, I forgot to mention that we also tried reindexing the toast table.
On Thu, Aug 19, 2010 at 1:20 PM, Scott Marlowe wrote:
> SNIP
>
> It's almost certainly not ruby's fault. Have they done anything
> strange like kill the instance and restart it without letting the db
> shut down? I'd tend
Let me preface this by saying that I've set up warm standby instances quite
a few times. I think I sort of hopefully know what I'm doing.
pg_start_backup('stuff'), tar data directory, pg_stop_backup(), copy data
directory to warm standby server, extract in data directory, etc.
We have two CentOS
if they've done anything weird with the database
in the last while.
Thanks for your help.
-Sam
On Thu, Aug 19, 2010 at 5:14 PM, Tom Lane wrote:
> Sam Nelson writes:
> >> It's almost certainly not ruby's fault. Have they done anything
> >> strange like kill
Wow. I must be blind. Or brain dead.
You're right. That was the issue.
-Sam
On Thu, Aug 19, 2010 at 9:22 PM, Tom Lane wrote:
> Sam Nelson writes:
> > Here's the output from pg_controldata:
>
> > $ pg_controldata `pwd`
> > WARNING: Calculated CRC check
Is there a way to get postgres to write a line to the log file when it
creates a WAL file? We wrote a script that tries to grab the times between
WAL file creation and ingestion without stopping to make absolutely sure
that postgres actually logs the WAL file creation, and so we're kinda stuck
sta
Alright, well, we'll probably do something with the archive command, then,
like either echoing %f to a log file or sending that to syslog (and then,
after the echo, doing the actual cp or scp or rsync or whatever). That way,
we should be able to get some form of timestamp of when each WAL file is
Hey, a client of ours has been having some data corruption in their
database. We got the data corruption fixed and we believe we've discovered
the cause (they had a script killing any waiting queries if the locks on
their database hit 1000), but they're still getting errors from one table:
pg_dum
y to remember to write back with
whether or not any of those things worked.
On Wed, Sep 8, 2010 at 1:30 PM, Tom Lane wrote:
> Sam Nelson writes:
> > pg_dump: Error message from server: ERROR: invalid memory alloc request
> > size 18446744073709551613
> > pg_dump: The com
with many more
questions.
-Sam
On Wed, Sep 8, 2010 at 2:58 PM, Tom Lane wrote:
> Merlin Moncure writes:
> > On Wed, Sep 8, 2010 at 4:03 PM, Sam Nelson
> wrote:
> >> So ... yes, it seems that those four id's are somehow part of the
> problem.
> >> They&
more info than
that. We're quite busy and my ability to remember things is ...
questionable.
-Sam
On Thu, Sep 9, 2010 at 8:14 AM, Merlin Moncure wrote:
> On Wed, Sep 8, 2010 at 6:55 PM, Sam Nelson
> wrote:
> > Even if the corruption wasn't a result of that, we weren&#
On Sun, Jan 8, 2012 at 7:13 PM, 邓尧 wrote:
> I have enabled the autocommit feature of psycopg2, and removed all the
> transactions in source code, also changed the sql statement to the
> following:
>
> insert into ACCOUNT(HOME)
> select "v1" as HOME
> where not exists (select 1 from ACCOUNT
On Sat, Mar 3, 2012 at 8:23 PM, David Boreham wrote:
> On 3/3/2012 7:05 PM, Tom Lane wrote:
>>
>>
>> [ raised eyebrow... ] As the person responsible for the packaging
>> you're dissing, I'd be interested to know exactly why you feel that
>> the Red Hat/CentOS PG packages "can never be trusted".
I have a situation that I'd like some help resolving.
Using PostgreSQL 8.4. on Linux, I have three things
coming together that cause me pain. I have a VIEW used by a bunch of
queries. Usually, these queries are fairly short (subsecond) but
sometimes they can be very long (days). I also update this
On Tue, Apr 3, 2012 at 12:16 PM, Merlin Moncure wrote:
> On Tue, Apr 3, 2012 at 12:01 PM, Jon Nelson wrote:
>> I have a situation that I'd like some help resolving.
>> Using PostgreSQL 8.4. on Linux, I have three things
>> coming together that cause me pain. I have
On Tue, Apr 3, 2012 at 1:36 PM, Merlin Moncure wrote:
> On Tue, Apr 3, 2012 at 12:30 PM, Jon Nelson wrote:
>> On Tue, Apr 3, 2012 at 12:16 PM, Merlin Moncure wrote:
>>> On Tue, Apr 3, 2012 at 12:01 PM, Jon Nelson
>>> wrote:
>>>> I have a situation that I
On Tue, Apr 3, 2012 at 2:45 PM, Thomas Kellerer wrote:
> Jon Nelson wrote on 03.04.2012 20:41:
>
>> Close, but not quite. It's not rotation but every N minutes a
>> newly-built table appears. I'd like that table to appear as part of
>> the view as soon as p
On Tue, Apr 3, 2012 at 8:58 PM, Scott Marlowe wrote:
> On Tue, Apr 3, 2012 at 7:21 PM, Jon Nelson wrote:
>> On Tue, Apr 3, 2012 at 2:45 PM, Thomas Kellerer wrote:
>>> Jon Nelson wrote on 03.04.2012 20:41:
>>>
>>>> Close, but not quite. It's not rot
On Wed, Apr 4, 2012 at 9:01 AM, Tom Lane wrote:
>
> Why aren't you using a standard partitioned table, cf
> http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
Because I'm adding "scalar" (constant-value) columns to the view like this:
SELECT * from tableA, DATE 'date string here' as
On Wed, Apr 4, 2012 at 10:43 AM, Tom Lane wrote:
> Jon Nelson writes:
>> On Wed, Apr 4, 2012 at 9:01 AM, Tom Lane wrote:
>>> Why aren't you using a standard partitioned table, cf
>>> http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
>
>> Be
On Wed, Apr 4, 2012 at 11:22 AM, Thomas Kellerer wrote:
> Jon Nelson wrote on 04.04.2012 15:50:
>
>> I need to have something table-like from the client's perspective for
>> a bunch of reasons.
>> For now, assume that I want to keep using the view and that I
1 - 100 of 125 matches
Mail list logo
