Tom Lane wrote:
You'd need to do something about adapting src/backend/port/tas/solaris_i386.s
It's possible that the assembly code would work as-is on amd, in which
case you'd just need a one-liner change in s_lock.h and maybe some
adjustment of the template file.
It doesn't compile with th
On Fri, Dec 16, 2005 at 05:10:11PM -0500, Tom Lane wrote:
> We need to fix plpgsql to ensure that what it returns is of the expected
> record type.
Should a test be added to regression for this? That's something I should
be able to do...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PRO
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Here's a simplified version:
> CREATE TYPE test_type AS (x integer);
> CREATE FUNCTION test() RETURNS test_type AS $$
> DECLARE
> rec record;
> BEGIN
> SELECT INTO rec 1;
> RETURN rec;
> END;
> $$ LANGUAGE plpgsql;
> SELECT test();
> I g
On 12/16/05, Pushpa Gorak <[EMAIL PROTECTED]> wrote:
>
>
> hi,
>
> i have installed postgresql8.1.1 on RedHat7.0. how do i enable TCP/IP
> connection. though i have uncommented listen_addresses = localhost in
> postgreql.conf file,the connection is refused.
>
if you simply uncomment this but not c
Pushpa Gorak <[EMAIL PROTECTED]> writes:
> i have installed postgresql8.1.1 on RedHat7.0. how do i enable TCP/IP
> connection. though i have uncommented listen_addresses = localhost in
> postgreql.conf file,the connection is refused.
You probably need to change your iptables configuration to allow
Pierre Girard <[EMAIL PROTECTED]> writes:
> It compiles but then i get a 32 bit executable which is not what i want.
> This is on a solaris 10 with amd processor using the sun forte 11 compilers.
> Are there any fix for this?
You'd need to do something about adapting src/backend/port/tas/solaris_i
Rolf Gross wrote:
> after upgrading from PostgreSQL 7.4 to 8.1 on my Debian PC (Testing
> Release) PostgreSQL hangs at boot time. This is because user
> "postgres" was set to password authentication in my database. The
> function "/usr/bin/pg_ctlcluster - cluster_port_ready" tries to
> connect t
On Thu, 2005-12-15 at 11:09 -0800, Jim Klo wrote:
> I’m having a similar problem:
>
> ERROR: relation with OID 7121526 does not exist
> CONTEXT: SQL statement "SELECT * INTO temp tmp_resourcequeue from
> resourcequeue where timeblockid in (select timeblockid from tmp_timeblock)"
> PL/pgSQL f
Tom Lane wrote:
> Is the database's locale set to something that works with EUC_JP? You
> can't just whack the encoding around without paying attention to having
> a compatible locale setting ... and unfortunately, PG doesn't have
> enough knowledge about locales to warn you when you choose a comb
Dear PostgreSQL Team,
after upgrading from PostgreSQL 7.4 to 8.1 on my Debian PC (Testing Release)
PostgreSQL hangs at boot time.
This is because user "postgres" was set to password authentication in my
database.
The function "/usr/bin/pg_ctlcluster - cluster_port_ready" tries to
connect to
the
hi,
i have installed postgresql8.1.1 on RedHat7.0. how do i enable TCP/IP
connection. though i have uncommented listen_addresses = localhost in
postgreql.conf file,the connection is refused.
Can you help me in resolving this.
Thanx in advance,
Pushpa.Gorak
--
>Folks,> >I'd swear somebody committed a fix for the issue with temp tables inside >plpgsql functions, like, months ago. Yet I still get: >ERROR: relation with OID 16607 does not exist>CONTEXT: SQL statement "INSERT INTO tmp_runs ( run_id, batch, machine ) >VALUES ( NEXTVAL('runs_run_id_se
Hello,
I'm trying to compile postgresql and I got this message telling me
to inform you:
"../../../../src/include/storage/s_lock.h", line 806: #error: PostgreSQL
does not have native spinlock support on this platform. To continue the
compilation, rerun configure using --disable-spinlocks.
Jon Keating wrote:
I have a database with the default encoding set to EUC_JP and the client
(using pgAdmin III) is set to EUC_JP as well.
pgAdmin uses Unicode (unless the DB is SQL_ASCII or MULE_INTERNAL), you
won't get happy if you change it using a SET command.
Regards,
Andreas
14 matches
Mail list logo
