[BUGS] Subquery with toplevel reference used to work in pg 8.4

2012-03-23 Thread Mark Murawski 

I agree the query is a little odd, but I like backwards compatibility!


Postgres 8.4.1
--
CREATE VIEW v_members AS
 SELECT
   1 as member_id,
   100 as tenant_id,
   3732 as conference_id,
   200 as uid
 FROM
   (select 1 as uid_user, 2 as uid_contact) as m;

SELECT
   u.tenant_id,
   u.uid
 FROM
   (select 100 as tenant_id, 200 as uid) u
   LEFT JOIN v_members m ON (m.uid = u.uid AND m.conference_id = 3732)
 WHERE
  (
SELECT 1
FROM   (select 3732 as conference_id) c
WHERE  (c.conference_id = 3732) AND (m.uid IS NOT NULL)
  ) = 1;

 tenant_id | uid
---+-
   100 | 200
(1 row)




postgres 9.1.3
--

CREATE VIEW v_members AS
 SELECT
   1 as member_id,
   100 as tenant_id,
   3732 as conference_id,
   200 as uid
 FROM
   (select 1 as uid_user, 2 as uid_contact) as m;

SELECT
   u.tenant_id,
   u.uid
 FROM
   (select 100 as tenant_id, 200 as uid) u
   LEFT JOIN v_members m ON (m.uid = u.uid AND m.conference_id = 3732)
 WHERE
  (
SELECT 1
FROM   (select 3732 as conference_id) c
WHERE  (c.conference_id = 3732) AND (m.uid IS NOT NULL)
  ) = 1;

ERROR:  Upper-level PlaceHolderVar found where not expected



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] pgadmin copy/paste bug

2013-09-03 Thread Mark Murawski 
Randomly, you are unable to use ctrl-c/ctrl-v/ctrl-x shortcut keys in 
the pgadmin edit window, but you can use the right click menu.


You can make the shortcut keys work again by clicking in another widget 
in the same editor window and then clicking back to the main edit box.


Video link to show a really good example of this happening:

http://www.youtube.com/watch?v=e6WKzaB3J1c


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs