hi,
I want to know is there any way to execute an anonymous PL/pgSQL block
in PostgreSQL.
Thanx
--
Regards
Imad
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes
On Sun, 27 Mar 2005, Jim C. Nasby wrote:
Maybe it's just me, but it's pretty hard to read, especially at the top.
what do you mean ? Too crowdy or text is too small ?
Other than that, it's great, and very informative. Thanks!
On Mon, Mar 28, 2005 at 01:33:58AM +0400, Oleg Bartunov wrote:
Hi there,
Alvaro Herrera wrote:
> On Wed, Mar 23, 2005 at 10:42:01AM +0800, Christopher Kings-Lynne wrote:
> > >>If you want to be my friend forever, then fix CLUSTER so that it uses
> > >>sharerowexclusive as well :D
> > >
> > >I don't think it's as easy as that, because you have to move tuples
> > >around
On Sat, 19 Mar 2005 11:42:18 +, Simon Riggs <[EMAIL PROTECTED]> wrote:
> I can see that I might want the view to have a different default value
> from that of the underlying table. I can see a reason to have multiple
> updateable views on the same table, all with different columns, column
> def
On Sun, Mar 27, 2005 at 03:41:08PM -0500, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > On Sun, Mar 27, 2005 at 12:44:41PM -0500, Tom Lane wrote:
> >> I've been toying with the idea of converting the oidvector and
> >> int2vector datatypes from fixed-width arrays to variable-leng
Maybe it's just me, but it's pretty hard to read, especially at the top.
Other than that, it's great, and very informative. Thanks!
On Mon, Mar 28, 2005 at 01:33:58AM +0400, Oleg Bartunov wrote:
> Hi there,
>
> while learning inkscape I did a sketch of picture describing
> history of relational d
Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
What has changed in the last 3 weeks is that I refreshed my Cygwin
installation, I think when I was wrestling with the NLS thing. If
nothing in postgres has changed in this area I assume that platform
changes account for the regres
On Sun, 2005-03-27 at 11:43 -0800, Josh Berkus wrote:
> Tom, Karel,
>
> > Hmm, if we want to support conversion like:
> > '43 hours 20 minutes' --> 'MI min'
> > how we should work with calendar INTERVAL units? For example 'month'?
> > '1 month 1 day' --> 'D days'
> > I think answer sho
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> What has changed in the last 3 weeks is that I refreshed my Cygwin
> installation, I think when I was wrestling with the NLS thing. If
> nothing in postgres has changed in this area I assume that platform
> changes account for the regression.
Sound
Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
Well, it seems at least to be running. When I fire up postmaster there
are 4 processes running and no indication of failure that I could see on
the log. (There is a complaint about failing to dup(0) after 3195
successes - I assume th
Hi there,
while learning inkscape I did a sketch of picture describing
history of relational databases. It's available from
http://mira.sai.msu.su/~megera/pgsql/
I'd be very grateful for any corrections and comments.
It could be used in PostgreSQL related presentations,
source file is available
ht
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> So I think this is dead code. The attached patch removes it.
Yeah, it is dead code; it's a leftover from Vadim's old plan to implement
Oracle-style UNDO. AFAIK none of the current crop of hackers wants to
proceed in that direction, so we may as well r
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Sun, Mar 27, 2005 at 12:44:41PM -0500, Tom Lane wrote:
>> I've been toying with the idea of converting the oidvector and
>> int2vector datatypes from fixed-width arrays to variable-length;
>> that is, stick a varlena length word on the front and store
On Sun, Mar 27, 2005 at 12:44:41PM -0500, Tom Lane wrote:
> I've been toying with the idea of converting the oidvector and
> int2vector datatypes from fixed-width arrays to variable-length;
> that is, stick a varlena length word on the front and store only
> pronargs or indnatts entries instead of
Tom, Karel,
> Hmm, if we want to support conversion like:
> ÂÂ'43 hours 20 minutes' --> 'MI min'
> how we should work with calendar INTERVAL units? For example 'month'?
> ÂÂ'1 month 1 day' --> 'D days'
> I think answer should be error message: "missing calendar unit 'month'
> in output for
While trying to grok heap_update I came again across the
_heap_unlock_tuple function. This code apparently tries to save a XLog
round while trying to mark a tuple for update, by registering a
"rollback callback", which would unmark the tuple in case the
transaction is rolled back.
Turns out the c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sat, 26 Mar 2005, Devrim GUNDUZ wrote:
Hmph. Those should be 'i' references to the foreign key constraint,
not 'a' references to the relations. I suspect this database was
carried forward from an ancient (pre-7.3) dump that defined the triggers
>As for general collation of unicode, the reason for me to use
>ICU is that
>my system does not support strcoll correctly for multibyte
>locales, as I
>mentioned earlier. I also noted that even for systems that do handle
>strcoll correctly for unicode, ICU claims to be a couple of magnitudes
>> I have three pending kerberos patches, two of which are
>plain bugfixes
>> and one which I'd argue is a bugfix around a can't-compile
>issue, that
>> I'd very much like to see in 8.0.2.
>
>Working on these. Don't you have the test backwards here?
(Sorry, been offline for a couple of days)
C
I've been toying with the idea of converting the oidvector and
int2vector datatypes from fixed-width arrays to variable-length;
that is, stick a varlena length word on the front and store only
pronargs or indnatts entries instead of a fixed number.
This would not immediately allow us to eliminate
Karel Zak <[EMAIL PROTECTED]> writes:
> Hmm, if we want to support conversion like:
> '43 hours 20 minutes' --> 'MI min'
> how we should work with calendar INTERVAL units? For example 'month'?
> '1 month 1 day' --> 'D days'
> I think answer should be error message: "missing calendar uni
On Sun, 2005-03-27 at 12:03 +0200, Karel Zak wrote:
> On Sat, 2005-03-26 at 15:56 -0800, Josh Berkus wrote:
> > Alvaro,
> >
> > > On Sat, Mar 26, 2005 at 02:04:14PM -0800, Josh Berkus wrote:
> > > > SELECT to_char( INTERVAL '43 hours 20 minutes', 'MI' ) || ' min';
> > > > 2600 min
> > >
> > > Hmm,
On Sat, 2005-03-26 at 15:56 -0800, Josh Berkus wrote:
> Alvaro,
>
> > On Sat, Mar 26, 2005 at 02:04:14PM -0800, Josh Berkus wrote:
> > > SELECT to_char( INTERVAL '43 hours 20 minutes', 'MI' ) || ' min';
> > > 2600 min
> >
> > Hmm, what if you wanted more than one literal string? Say "1 mon 3
> >
23 matches
Mail list logo
