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 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 servers can be
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 pages modified in the buffer cache
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; -- );
So that
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.
And it's been taken for about 35 years by a Unix command
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 list
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. cvs update, git
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 was to use
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 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 can put some
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. Then \z
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). That is fine and that works.
Now, using statement
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
---(end
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 from
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 start a new
transaction.
If that statement
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?
On Feb 4, 2008 5:14 AM, Alex Turner [EMAIL PROTECTED] wrote:
Im 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 PostgreSQL's
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
production)
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 avoid
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
could use
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 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_table_mods... Is this a feature or a bug
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 see it
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. Server Configuration. probably
somewhere in 18.3 Connections
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, then I'll do a
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
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
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
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;
QUERY PLAN
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';
QUERY PLAN
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 constraint but with
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 filesystem
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
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/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/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 you have a view which
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
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
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 if they were
completed and committed
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 high
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 to
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 get
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/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/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 typical
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 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 something conceptually similar to CREATE AGGREGATE statements
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 the
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:
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 than kill
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
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
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;
BEGIN
SELECT INTO n gseq_value+1
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 transaction will
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
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 UPDATE
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:
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/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 raising an
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/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
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
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
management too,
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
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/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/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
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 someother author listed on a book having multiple authors, etc.).Ideally, I would like the database to suspend the INSERT,
ask for confirmation (and
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_idINT4NOT
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 where
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 deniederrors.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/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 (x86). I have
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
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
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
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 that's the case with just about
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, but
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 department ALL may
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
0 is the ID of ALL
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
whenever possible).
OK, so then just define
On 7/18/05, Lincoln Yeoh lyeoh@pop.jaring.my 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
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 and
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 actually against
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 CHAR(1)! I would've
imagined that it would
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 three
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 be
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 invoice table which
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: update or delete on customer violates foreign key constraint
invoice_customer_fkey on invoice
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
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/24/05, Sebastian Böck [EMAIL PROTECTED] wrote:
/* 3rd way of separating updates
con: unnecessary updates on tables
pro: view gets evaluated only 1 time
Not adressing the problem of unnecessary updates, but the view
gets only evaluated one time.
*/
CREATE OR REPLACE
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 = OLD.id;
1 - 100 of 128 matches
Mail list logo