On Fri, Apr 18, 2008 at 9:04 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> On Fri, 18 Apr 2008 14:59:34 -0400
> Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> > I find it pretty unlikely that Slony would be unable to help you
> > upgrade here. Obviously you can upgrade one database at a time.
So I thought, "lets learn a bit of Python", and I stumbled upon
a choice of these two libraries. Whch would you suggest?
How do they differ?
By the looks of descriptions I am slightly inclined towards
psycopg2, but I would feel better if I talked with people
who actually used these libraries.
On Fri, Apr 11, 2008 at 9:21 PM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> Is there a switch (php side or pg side) to avoid things like:
>
> pg_query("select id from table1 where a=$i");
>
> into becoming
>
> pg_query("select id from table1 where a=1 and 1=1; do something
> nasty; -- "
On Sat, Apr 12, 2008 at 8:11 PM, Pavan Deolasee
<[EMAIL PROTECTED]> wrote:
> On Sat, Apr 12, 2008 at 11:00 PM, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> > Not quite workable. Remember that table data is not always available on
> > the block device -- there are p
On Fri, Apr 11, 2008 at 2:54 PM, Craig Ringer
<[EMAIL PROTECTED]> wrote:
> Pavan Deolasee wrote:
> > I wonder if it would make sense to add support to mount database in
> > *read-only* mode from multiple servers though. I am thinking about
> > data warehouse kind of operations where multiple server
On Fri, Mar 28, 2008 at 3:41 PM, Tomasz Ostrowski
<[EMAIL PROTECTED]> wrote:
> On 2008-03-28 02:00, Andrej Ricnik-Bay wrote:
> > On 28/03/2008, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> >> Agree, except I would prefer "pg" instead of "pgc".
&g
On Thu, Mar 27, 2008 at 11:49 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Mar 2008, Leif B. Kristensen wrote:
>
> > I figure something like the more or less standard options for modern
> > *nixes, with short and long options like eg.
> > pgc -C, --createdb ...
>
> The idea thrown out
On Wed, Mar 26, 2008 at 6:46 PM, Ron Mayer
<[EMAIL PROTECTED]> wrote:
> Zdeněk Kotala wrote:
>
> > 1) What type of names do you prefer?
>
> I'd prefer a "pg" program that took as arguments
> the command. So you'd have "pg createdb" instead
> of "pg_createdb".
>
> There are many precedents. "c
> 1) What type of names do you prefer?
1 b
> 2) How often do you use these tools?
2 c
> 3) What name of initdb do you prefer?
3 e (pg_createcluster by Debian), then d or b
> 4) How do you perform VACUUM?
4 c b (autovac & sql vacuum)
Regards,
Dawid
--
Sent via pgsql-general mailing li
On Mon, Mar 17, 2008 at 9:01 PM, wstrzalka <[EMAIL PROTECTED]> wrote:
> Hi
>
>Features like CREATE DATABASE WITH TEMPLATE or CREATE TABLE LIKE
> are very usefull but it would be great to have such a feature on the
> mid-level too. I mean something CREATE SCHEMA LIKE that would copy all
> the
On Thu, Mar 13, 2008 at 2:18 PM, Marko Kreen <[EMAIL PROTECTED]> wrote:
> On 3/13/08, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> > An application which uses tsearch2 ('SELECT set_curdict() / set_curcfg()'
> being
> > called upon session start). Tha
On Thu, Mar 13, 2008 at 11:52 AM, Kakoli Sen <[EMAIL PROTECTED]> wrote:
> This time the command GRANT ALL PRIVILEGES ON DATABASE "casDatabase" to
> tester; did not give error.
>
> But the permission is still not there. I run the following commands :
>
> psql -d casDatabase -U tester -W. The
On Tue, Mar 11, 2008 at 10:28 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kynn Jones" <[EMAIL PROTECTED]> writes:
> > If one can set up this insert operation so that it happens automatically
> > whenever a new connection is made, I'd like to learn how it's done.
>
> For manual psql sessions, you
On 3/5/08, A. Kretschmer <[EMAIL PROTECTED]> wrote:
> With generate_series() i generate a list of dates, and later i check if
> the date are a saturday. Okay, you need to know sunday -> change from 6
> to 0 and ou course, you can calculate the parameter for the
> generate_series like
I find it
On Tue, Feb 26, 2008 at 9:19 PM, Kynn Jones <[EMAIL PROTECTED]> wrote:
>
> Is there a simple way to copy a table from one database to another without
> generating an intermediate dump file?
Using UNIX pipes :-)
$ pg_dump ... | psql ...
:-)
Regards,
Dawid
---(e
On Feb 13, 2008 10:49 AM, Csaba Nagy <[EMAIL PROTECTED]> wrote:
> http://www.theserverside.com/news/thread.tss?thread_id=48339
>
> The interesting part is where somebody asks why NOT use postgres, and
> it's answers could give some additional hints to those interested on
> what people find missing
On Feb 11, 2008 2:27 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Dawid Kuroczko escribió:
> > I'm using 8.3.0 and I see that autovacuum processes in
> > pg_stat_activity have xact_start.
> >
> > As far as I know, since at least 8.2.x the VACUUM does not st
Hello.
I'm using 8.3.0 and I see that autovacuum processes in
pg_stat_activity have xact_start.
As far as I know, since at least 8.2.x the VACUUM does not start a new
transaction.
If that statement is correct, the xact_start column in
pg_stat_activity should be NULL...
Why does it matter? Monit
On Feb 4, 2008 5:14 AM, Alex Turner <[EMAIL PROTECTED]> wrote:
> I"m not a database expert, but wouldn't
>
[...]
>
> give you a lot less pages to load than building a table with say 90 columns
> in it that are all null, which would result in better rather than worse
> performance?
Well, but Postg
On Jan 11, 2008 7:14 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
> On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote:
> > Hi
> > We have an Oracle production database with some terbytes of data. We wanted
> > to migrate that to Postgresql (rigt now...a test database and not
> > p
On 11/1/07, Kynn Jones <[EMAIL PROTECTED]> wrote:
> Hi. This is a recurrent problem that I have not been able to find a
> good solution for. I have large database that needs to be built from
> scratch roughly once every month. I use a Perl script to do this.
>
> The tables are very large, so I
Hello.
Is there a way to scroll a cursor from within PL/PgSQL?
I tried EXECUTE, but:
ERROR: cannot manipulate cursors directly in PL/pgSQL
HINT: Use PL/pgSQL's cursor features instead.
The idea would be that PL/pgsql function would look
through (all) query results, then rewind the cursor and
> On 10/4/07, test tester <[EMAIL PROTECTED]> wrote:
> > i have version 8.1 and i want to know how to insert multiple rows in this
> version.
Please don't top post.
If you need this functionality, you should really upgrade.
In cases where you want to insert multiple rows in version 8.1, you
coul
On 9/24/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > On Mon, 2007-09-24 at 14:44 +0200, Dawid Kuroczko wrote:
> >> Hello, I see that I can modify system tables even though I have
> >> not set allow_system_ta
Hello, I see that I can modify system tables even though I have
not set allow_system_table_mods... Is this a feature or a bug?
Self contained code
postgres=# SELECT version();
version
On 8/27/07, Albe Laurenz <[EMAIL PROTECTED]> wrote:
> Dawid Kuroczko wrote:
> >>> Then again, apart from libpq I don't see it mentioned anywhere.
> [...]
> > Looking at the 8.3devel documentation...
> >
> > I think it should be mentioned in 18. Serve
On 8/27/07, Albe Laurenz <[EMAIL PROTECTED]> wrote:
> > it could be used as an advocacy lever ("you think LDAP directory with
> > DB-services
> > is neat? PostgreSQL already has it").
> I'm glad that *somebody* else appreciates it :^)
Oh, I do, I do. :)
> > Then again, apart from libpq I don't s
On 8/26/07, Kevin Kempter <[EMAIL PROTECTED]> wrote:
> On Saturday 25 August 2007 21:10:19 Ron Johnson wrote:
> > On 08/25/07 21:51, Kevin Kempter wrote:
> > > Hi List;
> > >
> > > I have a very large table (52million rows) - I'm creating a copy of it to
> > > rid it of 35G worth of dead space, the
Hello!
I've just accidently stumbled upon
http://www.postgresql.org/docs/8.2/static/libpq-ldap.html
and thought "hey, this is what my friend, a huge BigRDBMS fan, was
telling me about.
Now that I've read it, I think it could be very useful in an
enterpisish sort of way
(addressing databases as "s
I usually monitor blks_read and blks_hit (of block level stats), when
the latter is high
I see shared memory is doing a good job, when the former then it also
shows something
Also, database-wide number of commits and rollbacks (btw, Slony has a habit of
calling ROLLBACK when it done nothing -- I w
On 7/24/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
"Dawid Kuroczko" <[EMAIL PROTECTED]> writes:
> Now, if we:
>
> # EXPLAIN ANALYZE SELECT t FROM foo WHERE t='X17';
>
On 7/24/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
"Dawid Kuroczko" <[EMAIL PROTECTED]> writes:
> ALTER TABLE foo ALTER COLUMN i TYPE text;
> EXPLAIN SELECT * FROM foo WHERE i=17;
>
Hello, I guess I've stuck upon one problem with (I guess) implicit
casting varchar to text...
Basically it looks like planner makes better use of
WHERE ... IS NOT NULL indexes if either you explicitly
put "text" as a column type or that you cast the column
to ::text when making index.
Here's a s
On 7/22/07, Vincenzo Romano <[EMAIL PROTECTED]> wrote:
On Sunday 22 July 2007 19:20:08 Tom Lane wrote:
> Vincenzo Romano <[EMAIL PROTECTED]> writes:
> > In the original setup, the "UNIQUE" constraint had been dropped
> > *before* doing the tests. So the "slow" case is without the
> > UNIQUE const
On 6/27/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
I am afraid currently you are stuck with tablespaces as a quoting tool.
Of course having a filesyste
On 6/21/07, Vincenzo Romano <[EMAIL PROTECTED]> wrote:
Hi all.
I'd like to do the following:
insert into t1
values (
'atextvalue',(
insert into t2
values ( 'somethingelse' )
returning theserial
)
)
;
that is, I first insert data into t2 getting back the newly c
On 6/8/07, Billings, John <[EMAIL PROTECTED]> wrote:
Does anyone think that PostgreSQL could benefit from using the video card as a
parallel computing device? I'm working on a project using Nvidia's CUDA with
an 8800 series video card to handle non-graphical algorithms. I'm curious if
On 6/2/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:
But its said that transactions in any RDBMS follow ACID properties.
So if i put a create table and an Insert statement in the same begin end
block as one single transactioin, won't both create and insert follow acid
property, being in one
On 5/15/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
On Tue, May 15, 2007 at 06:33:26AM +0200, Dawid Kuroczko wrote:
> Well, views are not going to help with memory consumption here.
> It is the table contents that gets cached in buffer cache, not the
> views contents. So if
On 5/14/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
On Mon, 14 May 2007, PFC wrote:
> I did something like that on MySQL some time ago.
> In the Users table there was stuff that other users need to see (like
> his login name, etc), and stuff that only this user needs to see (like his
On 5/8/07, Joel Dice <[EMAIL PROTECTED]> wrote:
On Tue, 8 May 2007, Andrew Sullivan wrote:
> My real question is why you want to turn it off. If you're using a
> battery-backed cache on your disk controller, then fsync ought to be
> pretty close to free. Are you sure that turning it off will de
On 5/3/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
On Thu, 2007-05-03 at 08:58 -0700, Matthew Hixson wrote:
> I'm investigating the usage of a UUID primary key generator using
> Hibernate and Postgres. The reason for using a UUID is that we will
> have an application hosted at different sites in d
On 1/30/07, Ron Mayer <[EMAIL PROTECTED]> wrote:
Ron Johnson wrote:
>> Who would they target anyways?
>> There's no one company
>
> They could buy out CommandPrompt and EnterpriseDB...
>
> The buyouts wouldn't *kill* pg, but they would wound it mightily.
I don't think so. High-profile and
On 30 Jan 2007 12:15:17 -0800, Karen Hill <[EMAIL PROTECTED]> wrote:
On Jan 29, 11:06 pm, [EMAIL PROTECTED] ("Dawid Kuroczko") wrote:
> * updatable views [ or am I missing something? ] -- it seems to me
> they were close to be completed, but I don't remember i
On 29 Jan 2007 13:25:31 -0800, Karen Hill <[EMAIL PROTECTED]> wrote:
I was just looking at all the upcoming features scheduled to make it
into 8.3, and with all those goodies, wouldn't it make sense for this
to be a 9.0 release instead of an 8.3? It looks like postgresql is
rapidly catching up t
On 1/5/07, Jorge Godoy <[EMAIL PROTECTED]> wrote:
Andrew Chernow <[EMAIL PROTECTED]> writes:
>> And how do you guarantee that after a failure? You're restoring two
>> different sets of data here:
>
>> How do you link them together on that specific operation? Or even on a daily
>> basis, if you
On 1/3/07, Mark Harrison <[EMAIL PROTECTED]> wrote:
Does the following sound like a reasonable approach?
If not, what's a good way to go?
The processes generating the requests will insert into
a queue table. They may add a priority and timestamp.
The several processes servicing the requests wi
On 12/24/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Hello,
I have been threatened with severe penalties by the Chairwoman of the
Board if I so much as look at my email client on Christmas. So I send
this a day early!
Merry Christmas!
And same to You and all other PG-developers and users!
On 11/8/06, novnov <[EMAIL PROTECTED]> wrote:
I am very curious to hear the various conventions folks here have arrived
at. I don't expect there to be consensus, but the various rationales might
help me arrive at an approach that works well for me.
Personally I use all lower caps names a typica
On 11/10/06, Matthew Terenzio <[EMAIL PROTECTED]> wrote:
I suppose I should have named things differently but is there a way to
join two tables with a bunch of identical column names and rather than
explicitly alias each column just use some sort of wildcard like:
SELECT tablename.* AS alias.*
On 11/10/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Dawid Kuroczko" <[EMAIL PROTECTED]> writes:> Methinks it would be good idea to discuss a more general approach,> i.e. don't "create" links using existing infrastructure but rather
> provide some
Hello.
One nice feature of PostgreSQL's CREATE FUNCTION/RULE/VIEW system
is ability to create objects which "may appear closer than they really are".
Hence, all the dbi-link-like modules.
The usual method is to create a view on a set returning function (if
reasonable),
create RULEs for managing
On 10/26/06, Robert Treat <[EMAIL PROTECTED]> wrote:
the wordpress guys have basically said they do not want to support postgres,
which is mainly why we swapped to s9y on planetpg. you can read some more
info here:
http://people.planetpostgresql.org/xzilla/index.php?/archives/13-One-Good-Port.ht
On 10/29/06, Matthias Luedtke <[EMAIL PROTECTED]> wrote:
Alvaro Herrera wrote:
>> In fact, parsing this SQL dialect would just be the first step, as the
>> annotations within the query induce an ordering of the result set.
>
> Huh, what is this supposed to be able to do that you can't do with th
On 10/20/06, Shane Ambler <[EMAIL PROTECTED]> wrote:
>> After all, that's what a system crash is, right?>> A system crash is safer in that it won't leave orphaned child
> processes or IPC/synchronization resources around, making it more> comparable to a SIGQUIT than a SIGKILL.>The one thing worse t
Not necessarily. Last I heard, MySQL ships with multiple config files,
ie: small, medium and large. So by choosing one of those you're
effectively tuning MySQL as well.
Hmm, wouldn't it be a good idea to provide something similar?
I think an initdb could have an additional flag, like "--tune-fo
On 9/21/06, stevethames <[EMAIL PROTECTED]> wrote:
Ok, thanks, Jeff.
This is not a critical problem. Just annoying. I'll wait for 8.2.
BTW, while I can see the reason for adding the IF EXISTS clause to the
language for checking the existence of objects, wouldn't it be easier to
simply provide
On 9/6/06, George Pavlov <[EMAIL PROTECTED]> wrote:
I have two columns, both individually nullable, but a row needs to have
a value in one or the other. What is the best way to implement the
constraints? I currently have:
create table f (
a int,
b int,
check (a + b is null),
check (coale
On 8/17/06, Merlin Moncure <[EMAIL PROTECTED]> wrote:
On 8/17/06, Brad Nicholson <[EMAIL PROTECTED]> wrote:
> > > Hmm, I think you are wrong. There is a SELECT ... FOR UPDATE;
> > > The first-to-obtain the gapless sequence transaction will establish
> > > a lock onthe "tax_id" row. The other tr
On 8/17/06, Merlin Moncure <[EMAIL PROTECTED]> wrote:
On 8/16/06, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> -- then create a function to retrieve the values:
> CREATE FUNCTION gseq_nextval(t text) RETURNS integer AS $$
> DECLARE
>n integer;
> B
On 8/16/06, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
-- then create a function to retrieve the values:
CREATE FUNCTION gseq_nextval(t text) RETURNS integer AS $$
DECLARE
n integer;
BEGIN
SELECT INTO n gseq_value+1 FROM gapless_seq WHERE gseq_name = t
FOR
On 8/12/06, Jorge Godoy <[EMAIL PROTECTED]> wrote:
I was trying to solve a problem on an old system and realized that there might
be some better approach for doing what I need.
We have some documents that need to be ordered sequentially and without gaps.
I could use a sequence, but if the transa
On 7/29/06, gene Campbell <[EMAIL PROTECTED]> wrote:
I have a pg_hba.conf file that is setup like this
hostdb1 user1 222.152.155.194/32md5
From time to time, my ISP changes my ip address on me.
At that point, my connection to this DB is denied.
I have to log in (ssh) to my
On 5/26/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I have trigger on updating the table. Sometimes i need to make queries
without calling that trigger. How can I solve this?
You could try disabling the trigger (ALTER TABLE ...), doing you updates
and reenabling the trigger (ALTER TABLE) -
On 5/25/06, Rafal Pietrak <[EMAIL PROTECTED]> wrote:
> Well, exactly "not being interested in the outcome" is IMHO the reason
> why your demands clash with archtecture of a RDBMS. Most RDBMS go a long
> way to ensure consistency and safety of your data, once they promised
> (usually by not raisin
On 5/25/06, Rafal Pietrak <[EMAIL PROTECTED]> wrote:
I'd like to propose a 'syntax/semantics' of such trigger:
Triggers normally execute inside of a transaction.
A COMMIT within a trigger could mean: "do a fork: fork-1) return to the
main and schedule COMMIT there, fork-2) continue in bacground
On 5/23/06, Rafal Pietrak <[EMAIL PROTECTED]> wrote:
On Tue, 2006-05-23 at 15:56 +, Chris Browne wrote:
> > The use that I have for this at the moment, and I can think of many
> > other uses, is that I want to populate a statistics table each time
> > that a table is updated. But the code to
On 5/22/06, Florian G. Pflug <[EMAIL PROTECTED]> wrote:
elein wrote:
> This issue is a very old issue and people have not come up with
> the definitive solution to distributing "datablades" as Stonebraker
> called them.
True, but OTOH there is no "definitive solution" for OS-level package
managem
On 5/22/06, karthick muthu <[EMAIL PROTECTED]> wrote:
hello hai,
I am second year computerscience student(engineering),
I am very impressed by you all in asking questions and sending answers,
I am also very proud to be in this group,
now I am willing to do some mini projects(or)softwares from bas
On 5/20/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
I am not sure that Postgres needs CPAN. CPAN is particularly useful for
handling dependencies. I doubt that there will be lots of dependencies in
Postgres add ons. So having something like the current system where you
download and build packa
The idea that came up in the -hackers and -advocacy lists, and I think
it should be brought up as a separate thread, in -general.
Backgroud
Once in a while someone comes and suggests adding some package to
postgresql-contrib. Some other person asks for some feature and is directed
at Pgfoundry.
On 5/19/06, Csaba Nagy <[EMAIL PROTECTED]> wrote:
Hi all,
Currently the LIMIT clause is not allowed in UPDATE or DELETE
statements. I wonder how easy it would be to allow it, and what people
think about it ? For our application it would help a lot when processing
things chunk-wise to avoid long
On 4/15/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
Actually that is the application requirment to use 21 bit numbers as porting it from Oracle where it used to work. Yeah
now i have decided to use a numeric data type in a table and use that
to write my own nextval and currval functions for that purp
On 4/13/06, Benjamin Smith <[EMAIL PROTECTED]> wrote:
I'm stumped on this one...I have a table defined thusly:create table items (id serial,category integer not null references category(id),name varchar not null,price real,unique(category, name));
It has a LARGE number of entries. I'd like to grab
On 4/6/06, Don Y <[EMAIL PROTECTED]> wrote:
For example, the title may match an existing entry -- butthe author may be different (e.g., misspelled, or some"other" author listed on a book having multiple authors, etc.).Ideally, I would like the database to suspend the INSERT,
ask for confirmation (a
On 9/30/05, Sergei Dubov <[EMAIL PROTECTED]> wrote:
Hi guys,I'd really appreciate if you could clarify this to me. Let's say I havea table named TABLE_A that is a bridge to many-to-many relationshipbetween TABLE_B and TABLE_C, as such here is my declaration:
CREATE TABLE table_a ( table_b_id
On 9/26/05, boinger <[EMAIL PROTECTED]> wrote:
Hello.I'm not sure if this is a question suited for here, the -sql list, orthe -performance list, so if I'm mis-posting, please direct me to theright list.I was unable to come up with anything relevant from the archives
(though...I am not too sure wher
On 9/23/05, Yonatan Ben-Nes <[EMAIL PROTECTED]> wrote:
Hi all,Every few days I need to DELETE all of the content of few tables andINSERT new data in them.The amount of new data is about 5 million rows and each row get about 3queries (INSERT + UPDATE).
If I understand you well, in transaction you d
On 9/23/05, John Seberg <[EMAIL PROTECTED]> wrote:
--- Tom Lane <[EMAIL PROTECTED]> wrote:> John Seberg <[EMAIL PROTECTED]> writes:> > I have used the COPY command dozens of times! I
> think> > I *get* it. But, I'm getting "permission denied"> > errors.>> > This is a fresh install of Fedora Core 4
On 9/23/05, John Seberg <[EMAIL PROTECTED]> wrote:
I have used the COPY command dozens of times! I thinkI *get* it. But, I'm getting "permission denied"errors.This is a fresh install of Fedora Core 4 (x86). I havePostgresql running under the user postgres. I am
logged into to psql as postgres. The
On 9/20/05, Yonatan Ben-Nes <[EMAIL PROTECTED]> wrote:
Hi all,Im building a site where the users can search for products with up to 4diffrent keywords which all MUST match to each product which found as aresult to the search.I got 2 tables (which are relevant to the issue :)), one is the product
ta
On 8/15/05, MICHAEL BATTANI <[EMAIL PROTECTED]> wrote:
> I've been scanning the postgres website and yours to find out any
> information on cobol stored procedures. Is there any plans on incorporating
> this
> in future releases?
I don't think anyone is working on such a thing right now.
The pro
On 7/19/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > CREATE TABLE sample1 (
> > a boolean,
> > b int,
> > c boolean
> > );
> >
> > ...it will take more storage than:
> >
> > CREATE TABLE sample2 (
> > b int,
> > a boolean,
> > c boolean
> > );
> >
> Actually, I believe th
On 7/18/05, Lincoln Yeoh wrote:
> However, maybe padding for alignment is a waste on the disk - disks being
> so much slower than CPUs (not sure about that once the data is in memory ).
> Maybe there should be an option to reorder columns so that less space is
> wasted.
Out of curiosity, do I und
On 7/18/05, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On 7/18/05, Andrus <[EMAIL PROTECTED]> wrote:
> > I have meaningful primary key in department table (department code used
> > inside enterptise), not a surrogate number (I use meaningful primary keys
> > whe
On 7/18/05, Andrus <[EMAIL PROTECTED]> wrote:
> >> If I add ALL to department table, I must restrict all other tables of
> >> having
> >> ALL department. This is a big work and cannot be done nicely in Postgres.
> >
> > Not true. :) You simply need to add CHECK (departament_id <> 0) (assuming
> >
On 7/18/05, Andrus <[EMAIL PROTECTED]> wrote:
> > That's a lot of overhead for doing something very simple, like defining a
> > department key that means ALL and a row in the foreign table for it to
> > point to. Maintaining indices is a nontrivial performance trade-off.
>
> Yes, adding departmen
On 7/18/05, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
> Is there such a thing? PHP would be preferable, I don't want to maintain
> a MySQL-Server for such a small thing..
>
> Thanks in advance
I have used phpwiki (http://phpwiki.sourceforge.net/) with it. It's not
really a full blown wiki system
On 7/15/05, Andrus <[EMAIL PROTECTED]> wrote:
> CREATE TABLE test( col1 CHAR NOT NULL, col2 CHAR,
> UNIQUE (col1, col2) );
> INSERT INTO test VALUES ( '1', NULL );
> INSERT INTO test VALUES ( '1', NULL );
> does NOT cause error!
>
> How to create constraint so that NULL values are treated equal
On 7/12/05, Joe <[EMAIL PROTECTED]> wrote:
> Dawid Kuroczko wrote:
> > smallint takes two bytes. Numeric(1) will take around 10 bytes and char(1)
> > will
> > take 5 bytes (4 bytes for length of data).
> I never would've imagined *that* amount of overhead for C
On 7/13/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Personally I would settle for a fuller set of small fixed size datatypes.
> > The
> > "char" datatype is pretty much exactly what's needed except that it provides
> > such a quirky interface.
>
> I'm not
On 7/12/05, Joe <[EMAIL PROTECTED]> wrote:
> I have a MySQL database that I'm converting to PostgreSQL which has 10 columns
> with TINYINT type, i.e., a one-byte integer. Only one of them qualifies as a
> true BOOLEAN. Two are entity identifiers (for limited range "classes" or
> "categories") and
On 7/6/05, Ying Lu <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> Can I know whether postgreSQL 8.0 supports unsigned smallint please? I
> looked at the doc, it seems that OID is unsigned interger. While I was
> trying to create a simple table as:
> create table test (id unsigned smallint);
>
On 7/4/05, Gregory Youngblood <[EMAIL PROTECTED]> wrote:
> I would strongly suggest that you create a database specific user,
> one that has read/write access within this database, and that your
> application use that user instead of the pg super user.
>
> In general, the "super user" should never
On 7/2/05, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On 7/1/05, Andrus <[EMAIL PROTECTED]> wrote:
> > In Postgres 8 I tried commad
> >
> > DELETE FROM customer WHERE id=123
> >
> > but got an error
> >
> > ERROR: updat
On 7/1/05, Andrus <[EMAIL PROTECTED]> wrote:
> In Postgres 8 I tried commad
>
> DELETE FROM customer WHERE id=123
>
> but got an error
>
> ERROR: update or delete on "customer" violates foreign key constraint
> "invoice_customer_fkey" on "invoice"'
>
> How to determine the primary key of invoi
On 6/30/05, Jason Tesser <[EMAIL PROTECTED]> wrote:
> I work for a college and we use PG currently as our main backend. We are
> currently developing with Java. We are considering moving away from postgres
> for the reasons I am going to list below. I would appreciate some thoughts
> from the Po
Hello.
I've tried data partitioning using INHERITS mechanism (pgsql 8.0.3).
The schema looks like this:
CREATE TABLE log (
logid integer NOT NULL PRIMARY KEY,
logdate timestamp(0) without time zone NOT NULL,
typeid integer NOT NULL,
ip inet,
[.]
)
On 5/26/05, Hrishikesh Deshmukh <[EMAIL PROTECTED]> wrote:
> Is it possible to connect a DB in Postgresql to a DB in MySQL!
> I know its a crazy idea!
Why, of course. Been' doing that.
All you need is to write a set of functios, for example in PL/perlU,
some of them being set returning functions
On 5/25/05, Sebastian Böck <[EMAIL PROTECTED]> wrote:
> >>CREATE OR REPLACE FUNCTION upd (view_test) RETURNS VOID AS $$
> >>DECLARE
> >>NEW ALIAS FOR $1;
> >>BEGIN
> >>RAISE NOTICE 'UPDATE';
> >>UPDATE test SET test = NEW.test WHERE id
1 - 100 of 129 matches
Mail list logo
