On Wed, 7 Nov 2007, Tom Lane wrote:
> Nick Johnson <[EMAIL PROTECTED]> writes:
> > I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:
[snip]
> > Shouldn't that second row have been in the results of the second query?
>
> Huh? Those r
Before I open a bug on this, I wanted to do a sanity check, since there
may be something I'm just not seeing.
I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:
select create_date from article_lead;
create_date
---
2007-11-04 16:35:33.17+00
200
On 7/2/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Nick Johnson" <[EMAIL PROTECTED]> writes:
> I want to write a contrib module that exports a couple of functions
> that PLs (that don't natively support this) can use to set/get
> session-local variables.
Um, wh
s and functions will be executed in the
postgres process assigned to the connection that invokes them, and
therefore each will have its own copy of the global variable?
- How can I get a session-scoped MemoryContext to allocate nodes out of?
Thanks,
Nick Johnson
---(end of broa
If I create a complete database dump in custom or tar format, with a
command like the following:
pg_dump -Fc dbname > db.dump
using "pg_restore db.dump", as expected, returns the entire dump.
However, "pg_restore --schema foo db.dump", where 'foo' is the name of a
schema present in the databas
done (and won't be done, unless I develop a need or someone else wants it ) is determining when function calls are compatible even though they're not identical (eg, through use of polymorphic functions and ANYELEMENT/ANYARRAY).-Nick Johnson
On 14/03/2006, at 10:26 AM, Michael Fuhr wrote:On Tue, Mar 14, 2006 at 07:21:51AM -0800, Nick Johnson wrote: On 14/03/2006, at 12:05 AM, Michael Fuhr wrote: Why do you need to do this? What problem are you trying to solve? I want to associate Postgres functions with rows of a table (eg, a table
On 14/03/2006, at 12:05 AM, Michael Fuhr wrote:
On Mon, Mar 13, 2006 at 10:45:47PM -0800, Nick Johnson wrote:
Can anyone provide me with some direction on how to write a function
I can load into postgres that will execute a function specified by
OID (or regproc/regprocedure) at runtime, with
rmine the parameters that the specified function expects,
so I can prevent calling a function that doesn't match the expected
signature (which segfaults postgres).
-Nick Johnson
---(end of broadcast)---
TIP 4: Have you searched our lis
