On Sun, Jun 9, 2013 at 3:34 AM, wrote:
> Hi All,
>
>
>
> I have a problem with PostgreSQL 8.4. It was working perfectly fine but
> after the restart (within a couple of minutes) of my system whenever I
> login to PostgreSQL 8.4 (localhost:5432) it gives error as under:
>
>
>
> *Server doesn't
Hello, all.
In the PostgreSQL documentation I found "currval: Return the value most
recently obtained by nextval for this sequence in the current session "
In other documentations (pgpool, for example), I found "Connection Pooling
pgpool-II saves connections to the PostgreSQL servers, and reu
Gustavo Amarilla Santacruz wrote
>
> In the PostgreSQL documentation I found "currval: Return the value most
> recently obtained by nextval for this sequence in the current session
> "
>
>
>
> Then, I have the following question: PostgreSQL differentiates between
> sessions created for
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= writes:
> Le 2013-06-06 à 17:59, Tom Lane a écrit :
>> Note where the fine manual says:
>>
>> schema_name
>> The name of an existing schema. Each target_role must have CREATE privileges
>> for each specified schema.
>>
>> There was some debate previously a
Hello everybody,
since postgresql 9.2.x it seems such 32bit libs are gone for 64bit hosts
on repository-level.
In other words. They are not install-able via yum. I've recently
installed postgresql92* from pgdg-centos92-repository.
I used pgdg-centos92-9.2-6.noarch to setup the repo.
We still m
Hi John,
have you managed to get it to link with external shared libs?
tia,
Rad
Rad Cirskis
Senior Software Engineer
Level 2, Building A, The Millennium Building Phase 2, 600 Great South Road,
Ellerslie
Auckland City, Auckland, 1051
+64 9 926 2891 Office
www.emul
On Saturday, June 8, 2013, Jeff Janes wrote:
> On Sat, Jun 8, 2013 at 8:06 AM, Enrico Pirozzi
>
> > wrote:
>
>> Hi all,
>>
>> I have 2 tables:
>>
>> table1 (field1,field2,.)
>> table2 (field1,field2,field3,.)
>>
>> field1 is an uuid type
>>
>
> Is it a primary key? Is there a foreign ke
On 06/09/2013 07:42 AM, Alexander Gataric wrote:
> I need a sample database and hard practice SQL questions (multiple joins,
> window functions, subqueries, CTEs) to write ad hoc queries or perform
> database tasks. Any suggestions are welcome. Thanks in advance.
One option would be to look throu
Hello:
Would somebody please kindly tell why my function run but can't update
table via cursor:
I have table like this:
create table course_tbl(course_number integer, course_name varchar(4),
instructor varchar(10));
insert into course_tbl values (1,'','TOM'), (2,'','JACK');
