On Thu, Mar 27, 2008 at 11:05 PM, ajcity <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> I am trying to backup a large table with about 6 million rows. I want to
> export the data from the table and be able to import it into another table
> on a different database server (from pgsql 8.1 to 8.2). I need
On Thu, Mar 27, 2008 at 06:00:57PM -0400, Colin Wetherbee wrote:
> brian wrote:
>> I'd like to add a table, state_neighbours, which joins each state with all
>> of its neighbour states. Does anyone know where I can find such a list?
>>
>> I'm not interested in "nearest neighbour", just any connec
Hi all,
I am trying to backup a large table with about 6 million rows. I want to
export the data from the table and be able to import it into another table
on a different database server (from pgsql 8.1 to 8.2). I need to export the
data through SQL query 'cause I want to do a gradual backup.
I am fairly new to Postgres. However, I have to say that I agree with
Barry's comments.
The community's response is technically valid; they do talk about a better
way of 'designing' things, and what the company 'should' be doing.
However, coming from a MS-Sql world, people want multiple databases f
If you are a student, or know a student, or are a professor ...
www.postgresql.org/developer/summerofcode
Please submit an application as soon as you can!
--Josh
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
On Wednesday 26 March 2008 16:03, hubert depesz lubaczewski wrote:
> On Wed, Mar 26, 2008 at 10:02:45AM -0700, Steve Atkins wrote:
> > What's the psql equivalent of the "standard" use case of "vacuumdb -a"?
> > (If you don't know the answer, for both unix and windows, you don't get
> > to vote for
On Fri, 28 Mar 2008 00:06:59 -0400,
Tom Lane <[EMAIL PROTECTED]> wrote:
[...]
> Efficiency is moot, it's just plain wrong. Or at least something is
> wrong here, Subtraction of two "date" values gives an integer number
> of days already, so I'd expect the EXTRACT to fail altogether. You
> sure
Seb <[EMAIL PROTECTED]> writes:
>EXTRACT(DAY FROM (table_b.date - table_a.date)) AS age,
> Is this an efficient way to get the days from the time interval? Both
> 'date' columns are of type "Date". Thanks.
Efficiency is moot, it's just plain wrong. Or at least something is
wrong here,
Hi,
I'm not very savvy with interval manipulations, but I have a query like
this:
---<---cut here---start-->---
SELECT DISTINCT ON (table_a.id) table_a.id, table_a.var2,
EXTRACT(DAY FROM (table_b.date - table_a.date)) AS age,
FROM table_a INNER JO
Any chance we can an rpm for the plpgsql debugger to the rpms at
http://yum.pgsqlrpms.org/ ?
It would make it easier to install on systems that installed PGSQL from
rpm rather than from source.
Matt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
If I select the column as tdr_tags I get:
{{161377},{32}}
{{206507},{39}}
{{232972,292831},{45,51}}
...
But, wanting just the 2nd inner array, if I try tdr_tags[2] I get NULL.
If you want a sub-array you need to use the slice notation, eg
On Mar 26, 2008, at 7:25 AM, Zdeněk Kotala wrote:
1) What type of names do you prefer?
---
a) old notation - createdb, createuser ...
2) How often do you use these tools?
---
a) every day (e.g. in my cron)
b) one per week
c) one tim
> > Oh, then there should have been some options in the survey along the
> > lines of "things are fine how they are."
>
> Oh, a bit of answer-forcing wasn't beneath him.
Ummm... Isn't that what Option A is about ?
1) What type of names do you prefer?
---
a) old no
On 28/03/2008, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> Agree, except I would prefer "pg" instead of "pgc".
>
> With "pg" I am sure that the comand is "generic to the extreme", so I don't
> have to assume what does "c" stand for. Control? Create? Client? or
> Command.
>
> Also its about
Em Thursday 27 March 2008 08:29:04 Pettis, Barry escreveu:
> An addon Being self schooled in databases to me this seems to be a
> kludge. If you work in a large company environment the odds that
> someone somewhere is all ready storing or collecting data that you need
> ( by this I mean base
On Mar 27, 2008, at 5:41 PM, Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
Naz Gassiep napsal(a):
So I ask again, we're not seriously thinking about this are we?
Yes, we are.
Make that "Zdenek is". The reason for this survey is that he's hoping
to gather enough ammunition to
Ben <[EMAIL PROTECTED]> writes:
> On Mar 27, 2008, at 5:41 PM, Tom Lane wrote:
>> Make that "Zdenek is". The reason for this survey is that he's hoping
>> to gather enough ammunition to overrule the opposition.
> Oh, then there should have been some options in the survey along the
> lines of "t
Gregory Williamson wrote:
No can do, already taken:
"> man pg
Reformatting pg(1), please wait...
PG(1) User
Commands PG(1)
NAME
pg - browse pagewise through text files
Good catch. Haven't used th
brian <[EMAIL PROTECTED]> writes:
> If I select the column as tdr_tags I get:
> {{161377},{32}}
> {{206507},{39}}
> {{232972,292831},{45,51}}
> ...
> But, wanting just the 2nd inner array, if I try tdr_tags[2] I get NULL.
If you want a sub-array you need to use the slice notation, eg
tdr_tags[2
Dawid Kuroczko escribió:
> On Thu, Mar 27, 2008 at 11:49 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> > pgc cluster
>
> Agree, except I would prefer "pg" instead of "pgc".
pg is already taken by an ancient Unix pager utility (predecessor of
more, less, etc)
--
Alvaro Herrera
Dawid wrote:
[...]
>
> > abbreviations in cases where there's some overlap in characters:
> >
> > pgc cluster
> [...]
>
> Agree, except I would prefer "pg" instead of "pgc".
>
No can do, already taken:
"> man pg
Reformatting pg(1), please wait...
PG(1)
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
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> Naz Gassiep napsal(a):
>> So I ask again, we're not seriously thinking about this are we?
> Yes, we are.
Make that "Zdenek is". The reason for this survey is that he's hoping
to gather enough ammunition to overrule the opposition.
In any case, there *
On Thu, Mar 27, 2008 at 03:34:49PM -0700, Adrian Klaver wrote:
> Or a simpler way to do handle my previous suggestion:
>
> IF (ret_email IS NULL ) OR (ret_email='') THEN
> RETURN ('-3')
That would be the sane fix, yes.
Based on the previous emails from the OP, he seems to be missing a
lot
Using 8.3
I have a table which has a column (tdr_tags) defined as integer[][]. The
table description shows the column as integer[]. I understand from the
docs that this is normal ("declaring number of dimensions or sizes in
CREATE TABLE is simply documentation").
If I select the column as td
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 something like the CVS/svn model where a
single command gets called followed b
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Yes, I understand your point of view, but on other side there
> are arguments in discussion, that for newbies old name are
> terrible to use and frankly, who reads manual before he start
> to use a product?
This is a terrible argument.
> Nob
On Thursday 27 March 2008 3:17 pm, Sam Mason wrote:
> On Thu, Mar 27, 2008 at 08:43:46PM +0100, Alain Roger wrote:
> > i have a problem solving my function trouble.
> > this function should return an email address stored in a table
> > (tmp_newsletterreg) based on a number (sessions ID).
> > if the
On Mar 27, 2008, at 5:00 PM, Colin Wetherbee wrote:
brian wrote:
I'd like to add a table, state_neighbours, which joins each state
with all of its neighbour states. Does anyone know where I can find
such a list?
I'm not interested in "nearest neighbour", just any connected state.
That sou
On Thu, Mar 27, 2008 at 08:43:46PM +0100, Alain Roger wrote:
> i have a problem solving my function trouble.
> this function should return an email address stored in a table
> (tmp_newsletterreg) based on a number (sessions ID).
> if the session id is not find it should return a string correspondin
Colin Wetherbee wrote:
brian wrote:
I'd like to add a table, state_neighbours, which joins each state with
all of its neighbour states. Does anyone know where I can find such a
list?
I'm not interested in "nearest neighbour", just any connected state.
That sounds like something you could cr
brian wrote:
I'd like to add a table, state_neighbours, which joins each state with
all of its neighbour states. Does anyone know where I can find such a list?
I'm not interested in "nearest neighbour", just any connected state.
That sounds like something you could create in 20 minutes with a
- Original Message -
From: "Zdenek Kotala" <[EMAIL PROTECTED]>
To: "Naz Gassiep" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
Sent: Thursday, March 27, 2008 4:31 PM
Subject: Re: [GENERAL] Survey: renaming/removing script binaries (createdb,
createuser...)
> Naz Gassiep napsal(a):
>
> >
> > We're
Naz Gassiep napsal(a):
We're not seriously thinking of changing these are we? Once a command
set has been in use for as long a time as the PG command set has, any
benefit that may be derived by new users with an aversion to
documentation reading is vastly offset by the confusion that would
Tom Lane napsal(a):
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I like this too. It'd be considerably more work than the currently
proposed patch, though, since we'd have to meld the currently
separate programs into one executable.
I note that we can continue to have the curr
I'd like to add a table, state_neighbours, which joins each state with
all of its neighbour states. Does anyone know where I can find such a list?
I'm not interested in "nearest neighbour", just any connected state.
eg. IA would be associated with {MN,WS,IL,MO,KS,NB,SD} and HI & AK would
not b
On Thursday 27. March 2008, Alvaro Herrera wrote:
>Zdenek Kotala wrote:
>> And what about two commands one for create and one for drop?
>> It save 6 or 4 chars.
>>
>> pgc db (as create db)
>> pgc user
>> pgd db (as drop db)
>> pgd user
>
>Well, there are things besides create and drop -- for exam
Alvaro Herrera napsal(a):
Zdenek Kotala wrote:
And what about two commands one for create and one for drop?
It save 6 or 4 chars.
pgc db (as create db)
pgc user
pgd db (as drop db)
pgd user
Well, there are things besides create and drop -- for example vacuum.
Yeah, good point I forgot v
-- Original message --
From: "Alain Roger" <[EMAIL PROTECTED]>
> Hi,
>
> i have a problem solving my function trouble.
> this function should return an email address stored in a table
> (tmp_newsletterreg) based on a number (sessions ID).
> if the session id is
Zdenek Kotala wrote:
> And what about two commands one for create and one for drop?
> It save 6 or 4 chars.
>
> pgc db (as create db)
> pgc user
> pgd db (as drop db)
> pgd user
Well, there are things besides create and drop -- for example vacuum.
--
Alvaro Herrera
-- Original message --
From: Tom Lane <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > From: "Alain Roger" <[EMAIL PROTECTED]>
> >> once to do a comparison they use :
> > IF (ret == 1) THEN ...
> >> once,
> > IF (ret = 1) THEN...
>
> > Both are
Alvaro Herrera napsal(a):
Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Greg Smith wrote:
And if anybody suggests putting a "_" in something I have to type all the
time, I will stick my fingers in my ears and start yelling until they
stop. Bad enough I have to type pg_ctl a few
[EMAIL PROTECTED] (Adrian Klaver) writes:
> From: "Alain Roger" <[EMAIL PROTECTED]>
>> once to do a comparison they use :
> IF (ret == 1) THEN ...
>> once,
> IF (ret = 1) THEN...
> Both are correct.
No they're not, as a simple test would convince you ...
there is no '==' operator in SQL.
this is what i did, and it's true that '==' does not exist under pl/pgsql.
Only '=' should be used.
On Thu, Mar 27, 2008 at 8:53 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > From: "Alain Roger" <[EMAIL PROTECTED]>
> >> once to do a comparison they use :
Hi,
i have a problem solving my function trouble.
this function should return an email address stored in a table
(tmp_newsletterreg) based on a number (sessions ID).
if the session id is not find it should return a string corresponding to and
error.
if the email in found but already exists into an
-- Original message --
From: "Alain Roger" <[EMAIL PROTECTED]>
> Hi,
>
> i've read several books extract about controlling loops in postgreSQL under
> pl/pgsql and there is something interesting.
>
> once to do a comparison they use :
>
> > IF (ret == 1) THEN ..
Hi,
i've read several books extract about controlling loops in postgreSQL under
pl/pgsql and there is something interesting.
once to do a comparison they use :
> IF (ret == 1) THEN ...
once,
> IF (ret = 1) THEN...
so are they both correct ?
comming from .NET/C++ world, usually we use '==' o
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 Thu, 2008-03-27 at 10:37 -0400, Tom Lane wrote:
>
> What do you mean by "two separate SAN switches pulled out" --- is the
> DB spread across multiple SAN controllers?
>
It's using IO mutilpath through 2 HBAs. Both of those were taken down.
Brad.
--
Sent via pgsql-general mailing list (p
On Sun, 2007-09-16 at 11:18 -0700, Jeff Davis wrote:
> On Sun, 2007-09-16 at 09:25 +0100, Simon Riggs wrote:
> > Well, the definition of it working correctly is that a "restored log
> > file..." message occurs. Even with archive_timeout set there could be
> > various delays before that happens. We
No, not the pg data directory. The pg binaries. My problem was caused
by the timezone files installed under /usr/local/pgsql/share were not
world readable due the way I had the umask of root set when I did the
compile and install.
Erik Jones wrote:
What? Are you actually saying that a PG
Alain Roger wrote:
> i would like to know how can i control the returned value from a SQL
> statement ?
> for example, if i do an INSERT INTO... :
> 1. how can i know if the INSERT worked ?
> i mean i already trapped the unicity violation, but what if
> there is another error ? where can i get a
Tom Lane wrote:
No, he's complaining that the share/timezone file tree wasn't
world-readable. I think that's plain old pilot error though.
The install script shouldn't be second-guessing the umask it's
given, any more than it second-guesses the file ownerships.
If binaries are made readable a
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Greg Smith wrote:
> >> And if anybody suggests putting a "_" in something I have to type all the
> >> time, I will stick my fingers in my ears and start yelling until they
> >> stop. Bad enough I have to type pg_ctl a few times ev
An addon Being self schooled in databases to me this seems to be a
kludge. If you work in a large company environment the odds that
someone somewhere is all ready storing or collecting data that you need
( by this I mean base data ) could probably be pretty high. So why, if
PostGre is so old
> It sounds to me like you want to share a single database between
users,
> possibly using a suitable mix of schemas and roles to apply suitable
> permissions. If you don't want them to have shared access to the data
> then you can have separate databases and grant them access only to
their
> o
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Greg Smith wrote:
>> And if anybody suggests putting a "_" in something I have to type all the
>> time, I will stick my fingers in my ears and start yelling until they
>> stop. Bad enough I have to type pg_ctl a few times every day now.
> alias pgct
Greg Smith wrote:
> And if anybody suggests putting a "_" in something I have to type all the
> time, I will stick my fingers in my ears and start yelling until they
> stop. Bad enough I have to type pg_ctl a few times every day now.
alias pgctl=pg_ctl
--
Alvaro Herrera
On Thu, 27 Mar 2008, Alvaro Herrera wrote:
Greg Smith wrote:
And if anybody suggests putting a "_" in something I have to type all the
time...
alias pgctl=pg_ctl
If I were allowed to change the login profile on every system I touch I
wouldn't be typing pg_ctl at all; I'd be typing "up" and
Erik Jones <[EMAIL PROTECTED]> writes:
> On Mar 26, 2008, at 12:26 PM, Joseph Shraibman wrote:
>> This is a IMHO a bug in the install script. All of the postgres
>> install should be world readable, regardless of the umask (or at
>> least provide a warning).
> What? Are you actually saying
Brad Nicholson <[EMAIL PROTECTED]> writes:
> On Thu, 2008-03-27 at 10:29 -0300, Alvaro Herrera wrote:
>> Brad Nicholson wrote:
>>> It was. This table is an insert only log table that was being heavily
>>> was being heavily written to at the time of the crash.
>>
>> Is it possible that there were
On Mar 26, 2008, at 12:26 PM, Joseph Shraibman wrote:
After I sent my last email, a light bulb went off. I remembered a
similar problem I had a while ago with parts of postgres not having
read permission. Sure enough after I
[EMAIL PROTECTED] /usr/local/pgsql]# chmod -R a+r *
then restar
On Wed, 26 Mar 2008 18:03:06 -0500,
Seb <[EMAIL PROTECTED]> wrote:
> On Wed, 26 Mar 2008 22:46:08 +,
> Sam Mason <[EMAIL PROTECTED]> wrote:
[...]
>> You could turn the problem around and make the bool columns into ints
>> (which should be a simple search-and-replace, I hope) and then write
>
Alain Roger wrote:
> the purpose here, it is to solve my problem with a transaction inside a
> function.
You cannot handle transactions inside a function (apart from using EXCEPTION
blocks).
A PostgreSQL function is always executed in a single transaction.
All SQL statements you issue from with
On Thu, 2008-03-27 at 10:29 -0300, Alvaro Herrera wrote:
> Brad Nicholson wrote:
> > On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
> > > Brad Nicholson <[EMAIL PROTECTED]> writes:
> > > > We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
>
> > > It would be easier to be
Brad Nicholson wrote:
> On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
> > Brad Nicholson <[EMAIL PROTECTED]> writes:
> > > We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
> > It would be easier to believe that if the uninitialized pages were all
> > contiguous though.
Shane Ambler wrote:
Greg Smith wrote:
And if anybody suggests putting a "_" in something I have to type all
the time, I will stick my fingers in my ears and start yelling until
they stop. Bad enough I have to type pg_ctl a few times every day now.
+10 on hating "_"
+20 if need be, I'd go
On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
> It could be that but not necessarily. These could be pages that were
> allocated to put new tuples into, but the crash happ
Pettis, Barry wrote:
It sounds to me like you want to share a single database between
users,
possibly using a suitable mix of schemas and roles to apply suitable
permissions. If you don't want them to have shared access to the data
then you can have separate databases and grant them access onl
On Thu, Mar 27, 2008 at 12:40 AM, Martijn van Oosterhout <[EMAIL PROTECTED]>
wrote:
> Don't think anyone mentioned it, but if you could get it to output
> quotes around the value, like:
>
> INSERT INTO my_table (var_bool) VALUES ('0');
>
> It will also work.
>
This is good to know. There is an o
sam wrote:
> Iam trying to update a database table with approx 45000 rows. Iam not
> updating all rows at a time. Iam updating 60 rows at a given time for
> example. and this is happening in a FOR LOOP. A function that has the
> update statements is called within the loop.
>
> The updates take too
I am experiencing a strange problem where autovacuum appears to be
vacuuming 1 table in preference to another even through they have very
similar usage patterns.
For this test case I have 2 tables, 'transactions' and 'lineitems', and
the ratio of writes is approx 1:3. I am filling these tables
Pettis, Barry wrote:
An addon Being self schooled in databases to me this seems to be a
kludge.
Ah, well, self-schooling is always a good position from which to make
sweeping generalisations.
> If you work in a large company environment the odds that
someone somewhere is all ready sto
On Thu, Mar 27, 2008 at 11:25:18AM +0100, Alain Roger wrote:
> not really.. but it is true that it can be confusing...sorry :-(
>
> the purpose here, it is to solve my problem with a transaction inside a
> function.
hum, I think PG works a little differently than you think. a function
is run insi
On Wed, Mar 26, 2008 at 01:26:03PM -0700, Sam wrote:
> Iam trying to update a database table with approx 45000 rows. Iam not
> updating all rows at a time. Iam updating 60 rows at a given time for
> example. and this is happening in a FOR LOOP. A function that has the
> update statements is called
On Wed, 26 Mar 2008, sam <[EMAIL PROTECTED]> writes:
> Iam trying to update a database table with approx 45000 rows. Iam not
> updating all rows at a time. Iam updating 60 rows at a given time for
> example. and this is happening in a FOR LOOP. A function that has the
> update statements is called
not really.. but it is true that it can be confusing...sorry :-(
the purpose here, it is to solve my problem with a transaction inside a
function.
i need to know if there is a common return value for error in case of a SQL
statement failed.
it seems that not, so i would like to know if the rollbac
Alain Roger wrote:
> sorry... under pl/pgsql as stored procedure
Then this question was already asked and answered less than a week ago
on this mailing list.
By you, with almost exactly the same subject line.
Forgive my confusion, but why are you asking the same question again?
What's changed si
Pettis, Barry wrote:
Now this PostGreSQL "server" has many databases in it. Some of which I
have access to. I don't want to reinvent the wheel ( so to speak ) by
having to replicate the table in my database. Then having to create
routines that will extract from A to replicate in B. How do I r
thanks for the link regarding errors... i did not find it before.
On Thu, Mar 27, 2008 at 10:47 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Alain Roger wrote:
> > hi,
> >
> > i would like to know how can i control the returned value from a SQL
> > statement ?
> > for example, if i do an INSER
Alain Roger wrote:
hi,
i would like to know how can i control the returned value from a SQL
statement ?
for example, if i do an INSERT INTO... :
1. how can i know if the INSERT worked ?
i mean i already trapped the unicity violation, but what if there is another
error ? where can i get a complet
Alain Roger wrote:
hi,
i would like to know how can i control the returned value from a SQL
statement ?
You've left out some pretty significant information, like what method
you're using to access PostgreSQL.
ODBC from C/C++/whatever?
PHP?
Perl DBD?
Python DBI?
The .net interfaces?
sorry... under pl/pgsql as stored procedure
On Thu, Mar 27, 2008 at 10:46 AM, Craig Ringer <[EMAIL PROTECTED]>
wrote:
> Alain Roger wrote:
> > hi,
> >
> > i would like to know how can i control the returned value from a SQL
> > statement ?
> >
>
> You've left out some pretty significant informati
In article <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> writes:
>> I note that we can continue to have the current executables stashed in
>> PREFIX/share/libexec and let the "pg" executable exec them.
> Not share/ surely, since these are executables, but yeah.
> This brings me to the idea t
hi,
i would like to know how can i control the returned value from a SQL
statement ?
for example, if i do an INSERT INTO... :
1. how can i know if the INSERT worked ?
i mean i already trapped the unicity violation, but what if there is another
error ? where can i get a complete list of exceptions
sam wrote:
Hi
Iam trying to update a database table with approx 45000 rows. Iam not
updating all rows at a time. Iam updating 60 rows at a given time for
example. and this is happening in a FOR LOOP. A function that has the
update statements is called within the loop.
The updates take too long..
I work at a fairly large company 2000 people just at my site alone.
I've been given access to a new database which will be used for source
data for some software that the company just purchased.
Now this PostGreSQL "server" has many databases in it. Some of which I
have access to. I don't want t
Hi
Iam trying to update a database table with approx 45000 rows. Iam not
updating all rows at a time. Iam updating 60 rows at a given time for
example. and this is happening in a FOR LOOP. A function that has the
update statements is called within the loop.
The updates take too long.is postgre
Albe Laurenz wrote:
srdjan wrote:
What is the desired response to
INSERT INTO vvv (name, town, num) VALUES ('Karl', 'Leipzig', 18);
Should this generate an error message, do nothing, or insert something?
In this case you shouldn't be able to do this insert.
Should it generate
Albe Laurenz wrote:
srdjan wrote:
I'll try to explain my problem with an example.
-- I've got 2 tables and one view
CREATE TABLE a (name varchar(20) primary key, num integer);
CREATE TABLE b (town varchar(15), name varchar(20) references a(name));
CREATE VIEW vvv AS SELECT * FROM a NATUR
Hi,
Thank you for you detailed answer, but I am exactly in the case when I
want to paste the script and hit F5 and have both the database and
tables created.
A problem also comes from the fact that in order to use the query window
in pgadmin3, you need to select a database. Then when you cre
Hello,
i'm the maintainer of the ASP.NET PostgreSQL Provider.
You'll find the latest sources and documentation on the project home
page at: http://dev.nauck-it.de/aspsqlprovider/
There is also a ready to run example website:
http://dev.nauck-it.de/aspsqlprovider/browser/example
Currently on
Zdeněk Kotala pisze:
Hello All,
1) What type of names do you prefer?
b) new one with pg_ prefix - pg_createdb, pg_creteuser ...
b
2) How often do you use these tools?
b) one per week
b
3) What name of initdb do you prefer?
c) pg_init
c
4) How do you perform VACUUM?
a) vacuumdb - shell co
On 27/03/2008, Zdeněk Kotala <[EMAIL PROTECTED]> wrote:
> 1) What type of names do you prefer?
> ---
> a) old notation - createdb, createuser ...
a) Never seen any clashes with other tools in terms of names.
And the old sys-admin creed: don't fix it if it ain't
> Please let us know your meaning,
>
> 1) What type of names do you prefer?
> ---
a) with c) as a second choice. Keep names simple.
> 2) How often do you use these tools?
> ---
a)
> 3) What name of initdb do you prefer?
> -- -
On Wed, Mar 26, 2008 at 07:58:25PM -0400, John DeSoi wrote:
> I notice that when I build 8.3.1 psql on OS X (10.5.2) there is now a
> library dependency on /usr/lib/libgcc_s.1.dylib.
It appears to be a support library for gcc for certain routines that
are architecture specific or language specif
On Wed, Mar 26, 2008 at 05:28:18PM -0500, Seb wrote:
> > INSERT INTO my_table (var_bool) VALUES ( CAST( 0 AS BOOLEAN )); or
> > INSERT INTO my_table (var_bool) VALUES (0::BOOLEAN);
>
> Thanks Richard. Is there a way to do it without changing the INSERT
> command? As I mentioned, there are many m
Zdeněk Kotala a écrit :
I prepared patch for renaming postgreSQL script tools like createdb,
createuser, etc. to pg_createdb, pg_creteuser. Original names will be
kept for 2 or 3 following versions. The main reason for the patch is to
avoid possible clash of names with systems tools.
And afte
99 matches
Mail list logo