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
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
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
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
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
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
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
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
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/
> >
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
' 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&
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
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
>
14 matches
Mail list logo
