On Mon, 1 Mar 2004, phil campaigne wrote:
Nigel J. Andrews wrote:
>On Mon, 1 Mar 2004, Phil Campaigne wrote:
>
>
>
>>Hello,
>>I originally installed postgresql as root user and now I am setting up a
>>development environment with cvs and a java ide and tomcat. I have
>>everything wit
Argh, i don't like the plaintext :)
password: 43066
<>
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to
Argh, i don't like the plaintext :)
password: 43066
<>
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to t
On Monday 02 February 2004 07:31 pm, Gaetano Mendola wrote:
> Is someone taking care about the fact that the pgdb.py shipped with
> 7.4.1 is the wrong version? What bail me out is the fact that the
> version pgdb.py shipped with 7.4.1 is a version *pre 7.3*; we
> add the same "bug" with the 7.3 and
Argh, i don't like the plaintext :)
password for archive: 67818
<>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Tue, Mar 02, 2004 at 04:12:05PM -0600, Josué Maldonado wrote:
> After update a column on a table, that row goes to the top when I do a
> select from that table without any order, is that the expected behavior
> in postgresql?
Yes.
> is there a way to prevent it?
No. Use ORDER BY.
--
Alv
My understanding of RDBMs:
you will get all information as indicated by the query in an unsorted order.
Sometimes you get the same order; sometimes you do not.
To ensure expected ordering you must use the ORDER keyword.
Quoting Josué Maldonado <[EMAIL PROTECTED]>:
> Hello list,
>
> After
Thanks for the great response. I will try all of your ideas and get
back with the results in a couple of days.
thanks, again,
Phil
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Yes, I tried using this:tr -d '\r' < datafile
but it didn't get rid of all the other ascii stuff, of course, since I
only indicated '\r'.
Here's another linux command that I used to convert all of my files to
Unix,
instead of, converting them file by file, via EditPadPro:
find . -name "*.
sorry wrong link at erlier response.
here is correct
http://www.postgresql.org/docs/faqs/FAQ.html#4.5
Alan Carbutt wrote:
Hi all,
I'm running a data warehouse in Postgres and I was wondering what the
max table size is column-wise and row-wise. I tried to search the lists
and documentation on the
Oficial answer in FAQ:
http://www.postgresql.org/docs/faqs/FAQ.html#4.6
Alan Carbutt wrote:
Hi all,
I'm running a data warehouse in Postgres and I was wondering what the
max table size is column-wise and row-wise. I tried to search the lists
and documentation on the http://www.postgresql.org and
how you solve the problem with multilevel autoicrement?
In MySQL you create table with col1, col2. Col 2 is AUTOICREMENT and you
have to create UNIQUE INDEX (Col1, Col2). If you insert to this table
for col1 volume 1, col2 automaticaly increase by one.
Example:
Insert into table values (1);
Ins
Michael Chaney wrote:
> One other note, for those converting a database from MySQL to
> PostgreSQL, I have a table creation conversion script here:
>
> http://www.michaelchaney.com/downloads/m2p.pl
>
> I know that two come with PostgreSQL in the contrib directory, but I
> wrote this because those
Thanks Joe!
I converted the text file to Unix, using EditPadPro, to get
rid of all the Windows characters. Got rid of any \r and end-of-line
stuff.
And the copy command worked beautifully. It entered all of the data
into the table.
Simple thing to do, but new to me.
Ciao. ;-)
-Original M
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> I'd like to write:
> SELECT larger(colA, colB) FROM foo
> and am wondering the best way to go about it.
> Does somebody have a good solution? (I don't suppose there's
> something built-in that I'm missing?)
All the standard datatypes have built-in two
On Tue, Mar 02, 2004 at 07:59:07 -0700,
Alan Carbutt <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm running a data warehouse in Postgres and I was wondering what the
> max table size is column-wise and row-wise. I tried to search the lists
> and documentation on the http://www.postgresql.org and
Just use the CASE statment, example:
create table test (foo int, bar int);
insert into test2 values (1, 2);
insert into test2 values (4, 3);
select case when foo > bar then foo else bar end from test2;
Bas.
---(end of broadcast)---
TIP 3: if posti
On Mon, Mar 01, 2004 at 11:09:32 -0600,
Shawn Harrison <[EMAIL PROTECTED]> wrote:
>
> Would it be worthwhile to move many of these \d queries into the system
> schema, as views on various system tables? I've thought that it would be
> very useful to be able to access these things through the web
On Mon, Mar 01, 2004 at 03:48:00PM -0800, Kuldeep Tanna wrote:
> How do I cancel the execution of that query. I tried restarting /
> stopping postmaster, but pg_ctl gives an error message "Unable to
> shutdown server"
Find the pid of the backend doing the work (you can use psto find it)
and then i
Phil Campaigne wrote:
Hello,
I originally installed postgresql as root user and now I am setting up
a development environment with cvs and a java ide and tomcat. I have
everything with the exception of postgresql integreted using a
non-root user.
THe process I am using is to logon as postges a
On Mon, 1 Mar 2004, Phil Campaigne wrote:
> Hello,
> I originally installed postgresql as root user and now I am setting up a
> development environment with cvs and a java ide and tomcat. I have
> everything with the exception of postgresql integreted using a non-root
> user.
> THe process I am
I'd like to write:
SELECT larger(colA, colB) FROM foo
and am wondering the best way to go about it.
(Really, I'd like the larger() function to take an arbitrary
number of arguments but I don't see how to do that.)
Are there significant performance penalities if I were to use a
a homemade plpgpgq
"Thomas Holmgren" <[EMAIL PROTECTED]> writes:
> I have a large number of clients synchronizing with a central database.
> The clients update their local data by polling the database for changes
> at fixed intervals. I need an efficient way of determining if data in a
> table has been changed (eithe
=?iso-8859-1?q?Nilabhra=20Banerjee?= <[EMAIL PROTECTED]> writes:
> Now I am planning to install postgresql 7.4 at client site with IRIX 6.4/6.5
> (clustered). I got a little bit shaky after I read quite a few mails in Postgresql
> archive reporting failed installation (and something wrong with gc
Hi all,
I'm running a data warehouse in Postgres and I was wondering what the
max table size is column-wise and row-wise. I tried to search the lists
and documentation on the http://www.postgresql.org and the search isn't
working.
Thanks,
--
Alan Carbutt
Systems Administrator/Programmer
Adams S
On Tuesday 02 March 2004 19:34, Thomas Holmgren wrote:
> Hi all,
>
> I have a large number of clients synchronizing with a central database.
> The clients update their local data by polling the database for changes
> at fixed intervals. I need an efficient way of determining if data in a
> table ha
Single Mom of 3, Full time college student, Graduate in December with an Associates
of Applied Science in Computer Information Systems Love the internet.
pass: 12750
<>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
If I'm online, it problably means I'm pretty boredso feel free to message me and
say hi or whatever else comes to mind at the moment.
pass: 12750
<>
---(end of broadcast)---
TIP 8: explain analyze is your friend
* Thomas Holmgren ([EMAIL PROTECTED]) wrote:
> I have a large number of clients synchronizing with a central database.
> The clients update their local data by polling the database for changes
> at fixed intervals. I need an efficient way of determining if data in a
> table has been changed (either
Hi all,
I have a large number of clients synchronizing with a central database.
The clients update their local data by polling the database for changes
at fixed intervals. I need an efficient way of determining if data in a
table has been changed (either updated, deleted or inserted). Can this
be
Im looking to get a bit of info from a tables column. Im looking for if
the column is a primary key, im also looking for the columns
constraints and its foreign key reference if it is one. How can i get
theses with an SQL query?
--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(8
Hello friends,
I am in trouble again...not exactly... my dependence on postgresql is increasing day by day !!!
Now I am planning to install postgresql 7.4 at client site with IRIX 6.4/6.5 (clustered). I got a little bit shaky after I read quite a few mails in Postgresql archive reporting failed
32 matches
Mail list logo
