Same version of DB for dump & restore? If not, was the dump done via the
pg_dump from the newer version. If not, please do that.
--
Dan Langille
http://langille.org/
On Aug 28, 2013, at 2:56 AM, Torello Querci wrote:
> Interesting .
>
> while trying to restore the databas
Hello folks,
PGCon 2010 will be held 20-21 May 2010, in Ottawa at the University of
Ottawa. It will be preceded by two days of tutorials on 18-19 May 2010.
We are now accepting proposals for talks.
If you are doing something interesting with PostgreSQL, please submit
a proposal. You might be
t's stable enough to
announce to the world.
Nice, how about doing the same for http://identi.ca? Support the open
source alternatives...
That was done about 22 hours ago according to this:
http://twitter.com/PGSQL_Announce/status/1281937759
--
Dan Langille
BSDCan - The Technical
le willing to contribute. But unfortunately, most
of them are only willing to contribute their opinions when what is lacking
is heavy lifting.
--
Dan Langille - http://www.langille.org/
---(end of broadcast)---
TIP 9: In versions below 8.0, the plan
the Venezualan folks? SRA?
As you know, I'm strongly in favor of a good, generally respected
certification. Let's get all of the interested folks on one project.
You may know that I'm part of the BSD Certification Group. Proper
certification is not a trivial project. I join
Hi folks,
With reference to:
http://www.postgresql.org/docs/8.2/interactive/errcodes-appendix.html
What error code would be raised for a duplicate index name?
I didn't see anything appropriate. Possibly: 42710 DUPLICATE OBJECT
thanks
--
Dan Langille - http://www.langille.org/
BSDCan
n a shared server. Things are often done differently when you
need to play well with others.
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On 14 Jul 2003 at 20:55, Ron Johnson wrote:
> On Mon, 2003-07-14 at 17:44, Dan Langille wrote:
> > On 14 Jul 2003 at 15:16, Terence Chang wrote:
> >
> > > Hi all:
> [snip]
> >
> > Stored procedures is one reason I moved http://www.FreshPorts.org/
> >
stgreSQL? Would you recommend it over MySQL?
Yes. Yes. Friends don't let friends use MySQL.
> 5. How often do your PostgreSQL run into problem or crash? Are most of
> the problem caused by PostgreSQL itself?
I have never seen a PostgreSQL crash. Most if not all
appears to be consistent with the SQL99 spec.
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
sed anything in the instructions.
Downloads from: http://pgvote.unixathome.org/downloads/
Feedback can be left at: http://pgvote.unixathome.org/phorum/
Thanks
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 8: explain analyze is your friend
On 15 Jan 2001, at 8:44, J.H.M. Dassen (Ray) wrote:
> On Sun, Jan 14, 2001 at 23:27:06 +1300, Dan Langille wrote:
> > I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have a
> > question: At various times, it does UPDATEs. Is there a way to tell if
>
Then
copied from the renamed tables to the new tables. Then I tried the
dump, which failed. Then I removed the renamed tables. Then the dump
worked.
Hope that helps.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/
FreshPorts - http://freshports.org/
NZ Broadband - htt
' DECLARE
v_number_of_rows int;
BEGIN update bigtable set email_confirmed = 1
where user_group = 1234;
-- and here, I want to know the number of rows updated
v_number_of_rows := *what?*;
END; ' LANGUAGE 'plpgsql&
14 matches
Mail list logo
