Mike <[EMAIL PROTECTED]> writes:
> I see. Thank you for the elaborate response. I have a clearer idea of
> what is going on now. In designing my application I was thinking of
> storing pieces of my data as serialized python data structures into a
> binary field (no more than 15KB), while a friend
Joseph S <[EMAIL PROTECTED]> writes:
> My small gripes about Ubuntu are:
> 1) rpm, for all its faults, is still better than using apt
You *must* be joking. In Debian and Ubuntu, I've never had a tenth of
the dependency hell that you regularly hit with RPMs (though yum has
improved things somew
"Brian Mathis" <[EMAIL PROTECTED]> writes:
> Please don't start this. These issues are exactly why one should be
> looking at an ENTERPRISE OS for a server. Fedora, ubuntu, etc... are
> not enterprise OSes, and any discussion of such issues are certainly
> off-topic for this mailing list. An en
"D. Dante Lorenso" <[EMAIL PROTECTED]> writes:
> I need logic like "atomic test and set" or pop 1 item off the queue
> atomically and tell me what that item was.
>
> In my situation, there are a dozen or so machines polling this queue
> periodically looking for work to do. As more polling is occu
Devrim GÜNDÜZ <[EMAIL PROTECTED]> writes:
>> What I'm pondering here is that is the cluster able to keep the
>> postmasters synchronized at all times so that the database won't get
>> corrupted.
>
> Keep all the $PGDATA in the shared disk. That would minimize data loss
> (Of course, there is stil
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Scott Marlowe wrote:
>> On 8/14/07, john_sm <[EMAIL PROTECTED]> wrote:
>>> Hey guys, for an enterprise wide deployment, what will you suggest and why
>>> among - Red Hat Linux, Suse Linux and Ubuntu Linux, also, do you think, we
>>> can negotiate the
David Siebert <[EMAIL PROTECTED]> writes:
> I have a very old postgres server that I am trying to move the data off
> of. It is running 7.1 and has been trouble free for 6 plus years.
> I am trying to move the data base off to a server running 8.1.
> I have managed to back up the data using PG_Dum
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have recently used the MS SQL Server 2005 database, and found out that
> there is no mecanism where an execution plan can be reused between two
> successive calls to a view. This is only true with stored procedures.
>
> Is that also true with
"Bima Djaloeis" <[EMAIL PROTECTED]> writes:
> I have implemented a stored procedure that writes out the newest DB
> entry on insert, and combined it with a rule.
>
> 1) create function newcache() returns void AS 'newCache', 'newCache' language
> c;
> 2) create rule newcacherule AS on insert to cac
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> Not good because in that case pg_dump will generate code that can not run in
> 8.1 ... like :
>
> ALTER SEQUENCE ... OWNED BY
Dumps produced by version X of pg_dump have never been guaranteed to
load into earlier versions.
-Doug
--
Bob Pawley <[EMAIL PROTECTED]> writes:
> Following the examples in the docs I've come to this.
>
> I am attempting to restore the existing sql dump using
> psql -d PDW -f aurel.sql
>
> I am then asked for a password.
>
> I try every password that the computer knows with no success.
>
> Funny thing
kamiseq <[EMAIL PROTECTED]> writes:
> select into _id lastval();
> and is that safe operation, can I rely on lastval() that it will
> return value of id that was inserted before?
You want to use currval() with the sequence name.
> can it happened that other user will insert something betwe
João Paulo Zavanela <[EMAIL PROTECTED]> writes:
> Thanks, but I need configure password to connect to server!
> Now the pg_hba.conf is trust, I need change to passwd.
> Changing the file to passwd, I don't know how configure password to connect!
Set pg_hba.conf to 'trust', connect and use ALTER U
mgould <[EMAIL PROTECTED]> writes:
> We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4.
> One of the features that is really nice in ASA is the ability to add
> the attribute hidden to a Create procedure, Create function and
> Create trigger. Essentially what this does is encryp
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On 10/31/07, Douglas McNaught <[EMAIL PROTECTED]> wrote:
>
>> The only bulletproof way to do this currently is to write all your
>> stored functions in C and load them as a shared library.
>
> Well, as I
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On Nov 12, 2007 11:37 AM, Sam Mason <[EMAIL PROTECTED]> wrote:
>> And what's the performance hit of using native 64bit code? I'd guess
>> similar, moving twice as much data around with each pointer has got to
>> affect things.
>
> That's not been my
Thomas Finneid <[EMAIL PROTECTED]> writes:
> Hi
>
> I need to run latest Pg, i.e. 8.x, on a solaris 9 sparc machine, does
> anybody know of any prepackaged pg for that or any documentation that
> discusses compiling the source on such a machine. The Sun site only
> discusses how to do this in sola
"Robert James" <[EMAIL PROTECTED]> writes:
> 1.) Is there a way of separating, isolating, and sharing the shared data that
> will still allow FKs to it?
The only approach I know of would be to make all your customers use
independent schemas in one database, with isolation via appropriate
permissi
On 11/27/07, Fernando Xavier <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have trouble with my java application. Since i change the network
> configuration, the postgresql idle connections broken after 10 minutes. (i
> set authentication_timeout = 600 in postgresql.conf).
>
> My network:
>
> 192.168.1
On 11/27/07, Fernando Xavier <[EMAIL PROTECTED]> wrote:
>
>
> Hi, thanks for reply!
>
> No, my router don't have configurations for timeout connections..
Get a better router then. Something between your clients and the
database server is timing out those connections, and it's most likely
that box-
On 11/27/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Nov 27, 2007 12:33 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> > Get a better router then. Something between your clients and the
> > database server is timing out those connections, and it'
On 12/10/07, Ted Byers <[EMAIL PROTECTED]> wrote:
>
> Where will I find template1? When I look at the
> databases on the server, the only template I see is
> called "template_postgis". Most of the extra stuff I
> see in all my databases relates to geometry that I
> find in this template. When I
On 12/10/07, Ted Byers <[EMAIL PROTECTED]> wrote:
> OK. A worry. How is template_postgis constructed?
> Is it just a handy reference to template1? Or does it
> exist independantly? I don't want to be dropping
> template1 only to find that breaking template_postgis.
All databases are separate
On 12/10/07, Ted Byers <[EMAIL PROTECTED]> wrote:
> So, how do I determine whether or not template1 really
> exists on my server and is a copy of template0 (as I'd
> infer from what I see in postgres) rather than
> template_postgis, and then modify things so that the
> default is the normal templa
On 12/12/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Regular database files need metadata journalling (data=writeback mount
> option for ext3). This is quite faster than full-blown journalling
> which is what you get with default ext3 mount options. WAL files
> (pg_xlog) do not need any kind
On 12/13/07, robert <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm trying to hack my inserts script from mssql to work with postgres
> 8.1.9 - I can upgrade if need be. I'm getting this error:
>
> psql -h localhost atdev < fuk2.sql
> ERROR: invalid byte sequence for encoding "UTF8": 0xe1204f
> HINT:
On 1/28/08, Dominique Bessette - Halsema <[EMAIL PROTECTED]> wrote:
>
>
>
> I dont really understand the question but here's an xml example of what is
> getting posted to postgres, and i'm trying to figure out how to do a
> connection.close() type of thing in it.
>
>
Postgres doesn't have a built-
On 1/31/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
> I've noticed that by default postgres writes its log files read/write
> only by the postgres user.
>
> I have a nagios user I want to be able to analyse the logs.
>
> Is there a way to make postgres output them so they can be read by a
> group? O
> > Be aware that when 8.2.3 was released, 8.2 had only been out for two
> > months. There's another 11 months worth of accumulated bug fixes in
> > 8.2.6, including some that can cause the server to slow or crash. It's
> > not a difficult upgrade (no changes to the database) and you shoul
On 2/15/08, Tomás Di Doménico <[EMAIL PROTECTED]> wrote:
> Now I have the data into the UTF8 DB, and using graphical clients
> everything seems to be great. The thing is, when I query the data via
> psql, with \encoding UTF8 I get weird data ("NeuquÃ(c)n" for "Neuquén").
> However, with \encod
On 2/15/08, Harald Fuchs <[EMAIL PROTECTED]> wrote:
> But you have to ensure that you build PostgreSQL on your desktop
> machine in exactly the same way as the RPM got built
> (integer_datetimes etc).
It'd probably be much easier to just install the -contrib RPM. :)
--
-Doug
---
On 2/15/08, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> LOG: could not receive data from client: Connection reset by peer
> LOG: unexpected EOF on client connection
> LOG: could not receive data from client: Connection reset by peer
> LOG: unexpected EOF on client connection
This means you
On 2/17/08, Maxim Khitrov <[EMAIL PROTECTED]> wrote:
> The simplest design would be to create two tables, one for nodes
> another for edges, and create a column for every possible property.
> This, however, is huge waste of space, since there will not be a
> single node or edge that will make use o
On 2/20/08, Kynn Jones <[EMAIL PROTECTED]> wrote:
> Alternatively, is there a better way to streamline the duplication of a
> database?
How about:
CREATE DATABASE newdb TEMPLATE olddb;
(don't remember the exact syntax, but it'll be in the docs for CREATE
DATABASE). I think the 'createdb' progr
On 2/22/08, David Jaquay <[EMAIL PROTECTED]> wrote:
> When I do a ps -ef, in the command column, I see:
>
> postgres: postgres dbname 10.170.1.60(57413) idle
>
> I get all of this, except the "57413". What does this mean, and more
> importantly, how can I tie that number back to a connection that
On 2/22/08, David Jaquay <[EMAIL PROTECTED]> wrote:
> Yeah, kinda guessed that.
>
> So there's no way (that you know of) to, say, cast my JDBC connection object
> to something Postgresql'y and peer into its internals?
The docs and the source code for the PG JDBC driver are freely
available. Worst
On 3/4/08, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
> On Tue, 2008-03-04 at 00:34 -0500, Tom Lane wrote:
> > Karl Denninger <[EMAIL PROTECTED]> writes:
> > > Anyone know where the magic incantation is to find the crypto
> > libraries?
> >
> > If the RPM layout is the same as Fedora
On 3/5/08, Erwin Brandstetter <[EMAIL PROTECTED]> wrote:
> The whole concept behind large objects is a bit off. Since we have
> TOAST tables, it is of limited use to store large objects away in a
> system table. It would be useful to have (additional) functions like:
>lo_import(text) RETURNS
On 3/6/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> I'm getting the back end closing connections early for some reason.
> Here is an exception report from my servlet. This first started
> happening with my instance of Trac, but now it's happening to my Java
> apps too. I hope someone can shed
On 3/6/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> Ok - lookint at the pg log, it appears that the server process is seg
> faulting :(. This might conceivably be my fault. I have 3 stored
> procedures written in C, but they've been on the server for months,
> and unless I didn't deploy them c
On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> Well - I know that my stored proc is segfaulting based on a strace of
> postgresql. Don't know how that affects trac which isn't using that
> stored proc... the mystery continues. Either way I didn't get a
> corefile, and ulimit -a show I hav
On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> No I'm not. Where would a core file be if there was going to be one?
They should appear in the data directory (e.g. /var/lib/pgsql/data).
> I'm not sure how I can tell if the ulimit applies to the running
> postmaster
>
> I am the postgres u
On 3/18/08, Vernon Van Zandt <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> I keep getting the following error when attempting to establish a
> connection (from Perl):
>
> install_driver(Pg) failed: DBD::Pg object version undef does not match
> bootstrap parameter 2.2.2 at /usr/lib/perl/5.8/DynaLo
On Tue, Apr 1, 2008 at 7:56 PM, carty mc <[EMAIL PROTECTED]> wrote:
> In this case the updates that were made using dblink_exec are not getting
> rolled back in Database B.
And they won't be. dblink isn't transactional in that way. Your best
bet is to put all the data into one database and use
On Thu, Apr 3, 2008 at 2:34 PM, Dan99 <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am having some troubles with a select group of tables in a database
> which are acting unacceptably slow. For example a table with
> approximately < 10,000 rows took about 3,500ms to extract a single row
> using the f
On Mon, Apr 7, 2008 at 9:51 AM, Dan99 <[EMAIL PROTECTED]> wrote:
> Unfortunately, I did not design this database (or the website for that
> matter) and am only maintaining it. As a result of the inexperience
> of the website designer, there are no indexes in any of the tables and
> it would b
On Thu, Apr 10, 2008 at 11:25 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Thu, Apr 10, 2008 at 5:45 AM, CMOS <[EMAIL PROTECTED]> wrote:
> > hi,
> > i would like to get services of postgresql from inside the process (to
> > use it as a library and linking to it), i.e not having a separate
On Thu, Apr 10, 2008 at 3:46 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
> I am moving from Windows to Solaris and I need pgcrypto and dblink.
> Where are these? I don't see anything in the configure that suggests it
> is even an option.
They're not handled by 'configure'. They are in the 'con
On Sun, Apr 27, 2008 at 2:06 AM, Matthew Dennis <[EMAIL PROTECTED]> wrote:
> Do SQL statements inside of plpgsql functions get planned upon every
> execution, only when the function is first executed/defined, or something
> else entirely?
They are planned on first execution and the plan is cached
On Tue, May 13, 2008 at 11:52 AM, Fernando <[EMAIL PROTECTED]> wrote:
>
> Is it possible to do this?
>
> SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;
You should be able to use CASE for this.
-Doug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
2008/5/13 Justin <[EMAIL PROTECTED]>:
> Your saying in Excel, Multiplication is not Commutativity??? that sends
> shudders down my back
The word you want in this case is "associative". Since floating point
math is not exact, sometimes the associativity (and other) properties
of some operati
On Sun, May 18, 2008 at 8:04 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> What is the effect of having nested functions all declared
> SERIALIZABLE?
>
> What if just the outermost is declared SERIALIZABLE?
SERIALIZABLE applies to the entire transaction, not to individual
function calls.
On Wed, Jun 18, 2008 at 8:44 PM, Albretch Mueller <[EMAIL PROTECTED]> wrote:
> ~
> I am developing a J2EE application that needs for users to only read
> DB tables. All queries are select ones, no updates, no inserts, no
> deletes for web users, so I keep this ro DB tables in certain
> partitions
On Thu, Jun 19, 2008 at 6:54 PM, Bill Thoen <[EMAIL PROTECTED]> wrote:
> I've got to load some large fixed-legnth ASCII records into PG and I was
> wondering how this is done. The Copy command looks like it works only with
> delimited files, and I would hate to have to convert these files to
> INSE
On Thu, Jun 26, 2008 at 7:12 PM, Adam Rich <[EMAIL PROTECTED]> wrote:
>
>> 1. I have heard of problems arising from compiling PostGreSQL (8.3) on
>> 64-bit
>> processors. What sort of problems am I likely to encounter and how
>> should I fix
>> them? We are will run Linux Redhat 5 on a Dell PE29
On Fri, Jun 27, 2008 at 11:52 AM, Benjamin Weaver
<[EMAIL PROTECTED]> wrote:
> Sorry, guys, for wasting bandwidth on this! You guys gave just the answer I
> wanted to hear. Sounds like there aren't any problems.
>
> Not knowing about such things, I was scared by the following quote. Perhaps
> bi
On Wed, Jul 2, 2008 at 9:55 PM, Gurjeet Singh <[EMAIL PROTECTED]> wrote:
> As you can see, if I use the machine's interface or unix sockets, it either
> asks for password or lets me in. But when I use localhost, it correctly uses
> 127.0 line for authentication, but does not let me in!!!
>
> I
On Thu, Jul 17, 2008 at 12:11 PM, Ismael <[EMAIL PROTECTED]> wrote:
>
> hi
> I have one of those master-detail relationships here and I need to be able
> to delete the master but leave the details untouched
Then remove the referential integrity constraint, since it's obviously
incompatible wi
On Thu, Jul 17, 2008 at 2:43 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> I was wondering if the postmaster was running in some other data
> directory than the OP thought. I've never heard of anything just
> randomly removing a .pid file from a data directory; and it would
> be extremely dangerous if
On Thu, Jul 17, 2008 at 7:21 PM, Francisco Reyes <[EMAIL PROTECTED]> wrote:
> Redhat 4
> postgresql 8.3.3
> Memory: 12GB
>
> While doing a couple of operations of the type
> insert into select from
>
> The OS triggered the out of memory killer (oom-killer).
Is this a 32-bit installation or 64-bi
On Thu, Jul 17, 2008 at 9:27 PM, Francisco Reyes <[EMAIL PROTECTED]> wrote:
> Douglas McNaught writes:
>
>> Is this a 32-bit installation or 64-bit? 3GB of shared_buffers is way
>> too big for a 32-bit setup.
>
>
> 64-bit.
> The machine has 12GB of RAM so shar
On Fri, Jul 18, 2008 at 12:18 AM, Francisco Reyes
<[EMAIL PROTECTED]> wrote:
> Douglas McNaught writes:
>
>
>> It does seem that reducing work_mem might help you, but others on this
>
> I reduced it from 256MB to 64MB. It seems it is helping.
You should also loo
On Fri, Jul 18, 2008 at 12:07 PM, Suresh_ <[EMAIL PROTECTED]> wrote:
>
> Hello,
> I am trying to code a simple udf in postgres. How do I write sql commands
> into pl/sql ? The foll. code doesnt work.
>
> CREATE OR REPLACE FUNCTION udf()
> RETURNS integer AS $$
> BEGIN
> for i in 1..2000 loop
> fo
On Sat, Jul 19, 2008 at 9:02 PM, Karl Denninger <[EMAIL PROTECTED]> wrote:
> childrensjustice=# create table petition_bail like petition_white;
> ERROR: syntax error at or near "like"
> LINE 1: create table petition_bail like petition_white;
It's not super-easy to see from the docs, but I think y
On Wed, Jul 23, 2008 at 1:58 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> Please excuse my lack of mac knowledge. I installed postgresql 8.3 using the
> mac os x 1 click installer onto my brand new powerbook. The install appeared
> to go very smooth. If I go to Postgresql under Applica
On Wed, Jul 23, 2008 at 2:19 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Well I got it from a link on postgresql.org. Of course it does say that it
> is a beta installer.
> http://www.postgresql.org/download/macosx
Well, hopefully the maintainer reads this mailing list then. :)
-Doug
-
On Thu, Jul 31, 2008 at 4:03 PM, Warren Bell <[EMAIL PROTECTED]> wrote:
> I am trying to cast an int to a character. The int is the number 1000 it
> gets cast down to "1" and not "1000". How do I cast from int to character
> without loosing the trailing zeros?
Please supply the exact syntax that y
On Thu, Jul 31, 2008 at 4:17 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
> On Thu, Jul 31, 2008 at 1:03 PM, Warren Bell <[EMAIL PROTECTED]> wrote:
>> I am trying to cast an int to a character. The int is the number 1000 it
>> gets cast down to "1" and not "1000". How do I cast from int to chara
On Thu, Jul 31, 2008 at 5:57 PM, Andrew <[EMAIL PROTECTED]> wrote:
> The only relevant thing I have been able to find relating to it is
> http://archives.postgresql.org/pgsql-bugs/2007-12/msg00061.php which
> suggests adding a ::uuid cast to the parameter.
>
> However, when doing that, hibernate t
On Thu, Aug 28, 2008 at 10:57 AM, John T. Dow <[EMAIL PROTECTED]> wrote:
> BACKGROUND INFO BEGINS
>
> Recently I had some questions about doing backups and received very helpful
> replies. I have now put together a BAT file to do a routine backup, using
> pg_dumpall with the -g option to get the
On Thu, Aug 28, 2008 at 12:35 PM, John T. Dow <[EMAIL PROTECTED]> wrote:
> You can't blame me for being confused. Here's from section 23.3 of the 8.2
> manual.
>
> "At all times, PostgreSQL maintains a write ahead log (WAL) in the pg_xlog/
> subdirectory of the cluster's
> data directory. The log
On Thu, Aug 28, 2008 at 3:35 PM, John T. Dow <[EMAIL PROTECTED]> wrote:
> However, it would really be nice if the WAL files could be used to make the
> restored data more current, even if not everything can be restored. Are we
> certain that useful information can't be gleaned from them to apply
On Mon, Sep 8, 2008 at 6:18 PM, William Garrison <[EMAIL PROTECTED]> wrote:
> 2) We could install PostgreSQL onto the C: drive and then configure the data
> folder to be
> on the SAN volume (Z:)
You want this. If you're going to take snapshots, you need all the
data files AND the transaction log
On Fri, Sep 19, 2008 at 3:01 PM, Michelle Konzack
<[EMAIL PROTECTED]> wrote:
> Am 2008-09-03 13:33:05, schrieb Fernando Moreno:
>> Hello, I'm new to this mailing list, and I have a couple of questions:
>>
>> Is it really necessary to add the [GENERAL] prefix?
>
> No it is not since the PostgreQL Li
On Tue, Sep 23, 2008 at 11:49 AM, William Garrison
<[EMAIL PROTECTED]> wrote:
> In Postgresql 8.2.9 on Windows, you cannot rename a database if the name
> contains mixed case.
> 3) Open a query window, or use PSQL to issue the following command
> ALTER DATABASE MixedCase RENAME TO anything_else;
On Thu, Mar 26, 2009 at 6:43 AM, Tim Uckun wrote:
> It looks like most avenues for high availability with postgres are not
> available if one of the machines is a 64 bit machine and the other a 32.
>
> Somebody on this list suggested I install a 32 bit version of postgres on my
> x64 machine. Wha
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> No, I don't want the trigger to do any db stuff at all. Basically, I've
> got a content management system that is going to be split across a
> cluster. Upon an update submission from one of them, I want to replicate
> across the others (which can
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> On Mon, 2005-05-09 at 17:01 -0400, Douglas McNaught wrote:
>> Why not have a client connection LISTENing and doing the
>> synchronization, and have the trigger use NOTIFY?
>>
>> Or, you could have the trigger w
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes:
> This may be my second posting but I think I've done it correctly this time.
> At this point, I am unable to do a pg_dump using our new Rec Hat
> Enterprise Linux AS 4 version of Postgres which is version 7.4.
> Here's what I get when I try to do a pg
Tom Lane <[EMAIL PROTECTED]> writes:
> Neil Conway <[EMAIL PROTECTED]> writes:
>> http://www.postgresql.org/about/news.315
>
> Also, note that that message was the zero-day-security-problem response
> to the issue, and that we since figured out cleaner responses. If you
> haven't yet implem
Csaba Nagy <[EMAIL PROTECTED]> writes:
> Hi all,
>
> We have a situation where a varchar column was limited to a too small
> maximum length in the design phase... shit happens, we will fix our db
> schema in our next database downtime or software version deployment,
> whichever comes first (we are
<[EMAIL PROTECTED]> writes:
> I would like to store the complete database into a WORM device (Write Once
> Read Many). I would like to access this database directly from the WORM
> device and perform read only SQL statements against this device.
>
> Does anyone have such installation, or can det
Randall Smith <[EMAIL PROTECTED]> writes:
> For fun and learning, I would like to connect to the Postgresql
> backend and issue queries using sockets. I'm using Python's socket
> module. I'm new to socket programming, but I'm experienced with
> Python and Postgresql. I've been using the JDBC dr
lister <[EMAIL PROTECTED]> writes:
> At the BSDCan tutorial last week on jails (and several other times)
> there was discussion regarding Postgres's use of system V style
> shared memory, and an unfortunate side effect of making jail() less
> secure. Specifically, to allow Postgres to operate in
Hrishikesh Deshmukh <[EMAIL PROTECTED]> writes:
> Hi All,
>
> Is there a "bulk loader" in postgresql with which one can read in say
> a tab delimited format text file. Before one does all one has to do is
> create the table with text file column names as attributes, once it is
> on DBMS world it w
"Guy Rouillier" <[EMAIL PROTECTED]> writes:
> Joshua D. Drake wrote:
>
>> External storing is useful but I prefer LO because all my data (binary
>> and meta) is all in the same place for management.
>
> But if that's a big L in LO, performance and maintenance will be
> negatively affected, perha
Kelly Burkhart <[EMAIL PROTECTED]> writes:
> I used C++ and noticed that some Postgres headers contain C++ keywords.
> Is there any interest among PG developers in making the C-language
> interface C++ clean? Or, is there hostility to this idea?
Postgres is written in C. AIUI it's somewhat dan
Postgres General <[EMAIL PROTECTED]> writes:
> what is the procedure for creating a "hot standby" (continuously
> feeding a series of WAL files created by the primary machine into the
> secondary one) ?
There currently isn't one. I think someone may be working on it.
-Doug
"Yateen Joshi" <[EMAIL PROTECTED]> writes:
> Link: File-List
>
> Hi,
>
>
>
> I am using postgres 7.4.2 on Solaris. My unix system does not place a
> limitation of 2 GB on file size. If I export a data from my database that
> causes the file size to be more than 2 GB, then that export fails (and
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> Although Npgsql seems to be a very nice library to access Postgresql, I
> was not able to do that. Adding a database to the project is fine for MS
> Access / SQL Server / Oracle databases, but I'm still searching how to
> do it for Postgresql.
>
> So m
"Marcelo" <[EMAIL PROTECTED]> writes:
> Hello,
> Using Postgres 7.4, I am trying to perform an "alter table temptable add
> column "myCol" serial"
>
> It gives the following msg
> ERROR: adding columns with defaults is not implemented
>
> You cannot add a column that is serial in a table whic
grupos <[EMAIL PROTECTED]> writes:
> I need to use large objects BUT I am having problemns... I instaled
> PostgreSQL 8.0.3 windows version with lo module.
>
> first, I created the table below:
> CREATE TABLE test
> (
> description varchar(20),
> picture lo
> )
> WITHOUT OIDS;
>
> After trying
"Surabhi Ahuja " <[EMAIL PROTECTED]> writes:
> Hello everyone.
> I have the following question:
>
> say i have two transactions going on simultaneoulsy.
> in one transaction i do an insertion
> and the other transaction i do a delete.
> what will happen if in both the transactions, the insert(in o
grupos <[EMAIL PROTECTED]> writes:
> Hi Doug!
>
> Thanks for your e-mail BUT the point is how I insert data on a table
> when the column lo have no value ( NULL), to insert the lo I have no
> problem BUT the problem is when the column should have no value...
If the "lo" field isn't NOT NULL than
grupos <[EMAIL PROTECTED]> writes:
> Hi Adam,
>
> I am sorry for the misunderstanding, when I compose the e-mail I
> forgot the ' ' on the 1 BUT the error is the same, I made:
> INSERT INTO test VALUES ('1')
>
> and I get the error:
> ERROR: invalid input syntax for integer: ""
>
> I am sure th
Bob <[EMAIL PROTECTED]> writes:
> What are the opinions on a separate list just for pl/pgsql? Seems
> pl/pgsql deserves her own area. Just wondering if this would make sense,
> and if it did can we have a separate list?
I don't think it makes sense--it's not like traffic related to
pl/pgsql floo
Bob <[EMAIL PROTECTED]> writes:
> My thought is on it's own pl/pgsql is just as important as straight SQL.
> Maybe as time goes on we will see higher volumes of pl/pgsql questions, if
> that is what warrants a separate list. I personally don't see why one
> would put pl/pgsql in with everything e
Joseph Shraibman writes:
> I want to do the following:
>
> BEGIN;
> SELECT ... FROM table WHERE a = 1 FOR UPDATE;
> UPDATE table SET ... WHERE a = 1;
> if that resturns zero then
> INSERT INTO table (...) VALUES (...);
> END;
>
> The problem is that I need to avoid race conditions. Sometimes I g
Howard Cole <[EMAIL PROTECTED]> writes:
> To improve compatibility, I created a backup on the linux system
> (8.0.1) using plain format, data only with triggers disabled. However,
> when I try to restore the plain sql on the windows machine (8.0.3) it
> fails because the first insert command fails
Dan Black <[EMAIL PROTECTED]> writes:
> First query does not use index in contrast to two query.
>
> Why?
You don't give enough information. Post EXPLAIN ANALYZE output for
both queries and perhaps someone can help.
-Doug
---(end of broadcast)---
1 - 100 of 275 matches
Mail list logo
