Here's my $0.02
Stored procedures have a bunch of problems historically. Part of this is
because the interface traditionally is pretty spartan, and partly because
some people take them too far.
The first issue is that if you have a stored procedure which takes 2
arguments and you need to extend
Thank you Tom! This is what I was after!
So, to get this straight in my head.
- pg_start_backup forces a checkpoint and writes the information from
this checkpoint to the backup_label file
-
- pg_stop_backup removes the backup_label file
-
-
- Database starts and determin
On 08/01/2013 04:59 PM, BladeOfLight16 wrote:
On Thu, Aug 1, 2013 at 7:53 PM, Adrian Klaver mailto:adrian.kla...@gmail.com>> wrote:
It fails because
ALTER TABLE x
ADD COLUMN data2 VARCHAR(10) NOT NULL DEFAULT 'foo',
end in , instead of ;
You have to add the column before y
On Thu, Aug 1, 2013 at 7:53 PM, Adrian Klaver wrote:
> It fails because
>
> ALTER TABLE x
> ADD COLUMN data2 VARCHAR(10) NOT NULL DEFAULT 'foo',
>
> end in , instead of ;
>
> You have to add the column before you can alter it.
>
=/ That's the way I have it in the SQL Fiddle sample I provided. I w
On 08/01/2013 04:25 PM, BladeOfLight16 wrote:
On Thu, Aug 1, 2013 at 7:10 PM, Richard Broersma
mailto:richard.broer...@gmail.com>> wrote:
Notice :
http://www.postgresql.org/docs/9.3/static/sql-altertable.html
After you add a column to your table, you can latter *alter* this
colum
On Thu, Aug 1, 2013 at 10:25 AM, Sandeep Gupta wrote:
> @Jeff : Thanks for pointing this out. Turns out that was the case.
>
> @Tom: Thank you for the reference to random_page_cost parameters. It would
> be very useful for us. Would go through the rest of the documentation as
> well.
>
I can't sa
On Thu, Aug 1, 2013 at 7:10 PM, Richard Broersma wrote:
> Notice :
> http://www.postgresql.org/docs/9.3/static/sql-altertable.html
> After you add a column to your table, you can latter *alter* this column
> to add, change, or remove the default expression. There's no need add
> temporary column
Notice :
http://www.postgresql.org/docs/9.3/static/sql-altertable.html
After you add a column to your table, you can latter *alter* this column to
add, change, or remove the default expression. There's no need add
temporary columns to manage this kind of change. In fact, all of the DDL
that you'v
When I want to add a new column with a NOT NULL constraint, I need to
specify a DEFAULT to avoid violations. However, I don't always want to keep
that DEFAULT; going forward after the initial add, I want an error to occur
if there are inserts where this data is missing. So I have to DROP DEFAULT
on
On 02/08/13 08:24, Kevin Grittner wrote:
[...]
When working as a consultant, one client was doing everything
client-side and engaged me to fix some performance problems. In one
case a frequently run query was taking two minutes. As a stored
procedure the correct results were returned in two s
Neil Tiffin wrote:
> Some Developer wrote:
>
>> I've done quite a bit of reading on stored procedures recently and the
>> consensus seems to be that you shouldn't use them unless you really must.
>
> Application architecture is a specific software engineering discipline. These
> types of general
@Jeff : Thanks for pointing this out. Turns out that was the case.
@Tom: Thank you for the reference to random_page_cost parameters. It would
be very useful for us. Would go through the rest of the documentation as
well.
On Wed, Jul 31, 2013 at 3:55 PM, Tom Lane wrote:
> Sandeep Gupta writes:
> suppose wal archiving or PITR would be better
+1, never re-invent the wheel, unless you really need to.
Bèrto
On 1 August 2013 14:14, Luca Ferrari wrote:
> On Thu, Aug 1, 2013 at 10:59 AM, wrote:
>
> > However, the diff files seem to be considerably larger than one would
> expect.
> > One
On Thu, Aug 1, 2013 at 10:59 AM, wrote:
> However, the diff files seem to be considerably larger than one would expect.
> One obvious part of the problem is the fact that diff shows old and new text,
> so e.g. changing the amount of stock for a product with a 1kB description
> would generate at
On 01/08/2013 10:27, Stephen Brearley wrote:
> 6) This question about connecting -I think- could be what the problem is. To
> connect, I start pgAdmin and double-click on Server
> groups|Servers|myLocalHost (localhost:5432) which has a red 'X' on it
> (doesn't look good) to which I get a popup 'Er
hidayat...@gmail.com, 31.07.2013 15:52:
> As per my experience, installing postgresql on windows machine
> automatically create postgres user. When you uninstall it, the
> postgres user doesn't automatically removed, you must remove it
> manually.
Not any more.
Since 9.1 (or was it 9.2?) Postgre
Alban Hertroys, 31.07.2013 15:16:
> I suspect the postgres log is either in the Windows Event Log
> (available from the Control Panel, perhaps under Administrative Tools
> or something similar) or in a file somewhere in the Postgres
> installation directory, most likely in a directory named log.
I
Hi Nur
Yes, I'm almost sure this is the thing that is causing the main problem,
despite other apparent installation bug red herrings. I have had Alban
Hertroys pick up on the same thing.
But...how do I do this please? Please can you give me some basic
instructions.
Thanks
Stephen
Hi Alban
Think we are making progress..
I'll need to do some research to understand how to find the event log, but
to answer your other points:
1) Glad to see you think the database started up correctly. I also noted
this problem about adminpack, and spent ages trying to find out what it was
and
Hi,
I want to store copies of our data on a remote machine as a security measure.
My first attempt was a full dump (which takes too long to upload)
followed by diffs between the pgdump files.
This provides readable / searchable versioned data (I could alway apply
the diffs on the remote machine and
Hi all,
I've come across an issue within pg_hba configuration which it seems
cannot not set the record of a database name where there is a
newline(\n) in the name.
I created the database whihin psql like this:
create database "ab
cd";
I have tried all the following records, but seems not to work
21 matches
Mail list logo
